Subversion Repositories DevTools

Rev

Rev 5513 | Rev 5958 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5513 Rev 5955
Line 1... Line 1...
1 
<%@LANGUAGE="VBSCRIPT"%>
 1 
<%@LANGUAGE="VBSCRIPT"%>
2 
<%
 2 
<%
3 
'=====================================================
 3 
'=====================================================
4 
'|                                                   |
 4 
'|                                                   |
5 
'|			          OSDefault					 	 |
 5 
'|                    OSDefault                      |
6 
'|                                                   |
 6 
'|                                                   |
7 
'=====================================================
 7 
'=====================================================
8 
%>
 8 
%>
9 
<%
 9 
<%
10 
Option explicit
 10 
Option explicit
Line 38... Line 38...
38 
 
 38 
 
39 
<style type="text/css">
 39 
<style type="text/css">
40 
<!--
 40 
<!--
41 
.style1 {color: #0000FF}
 41 
.style1 {color: #0000FF}
42 
.style2 {
 42 
.style2 {
43 
	font-size: 14px;
 43 
    font-size: 14px;
44 
	font-weight: bold;
 44 
    font-weight: bold;
45 
}
 45 
}
46 
-->
 46 
-->
47 
</style>
 47 
</style>
48 
</head>
 48 
</head>
49 
 
 49 
 
50 
<body leftmargin="0" topmargin="0">
 50 
<body leftmargin="0" topmargin="0">
51 
 
 51 
 
52 
<%
 52 
<%
53 
	OraDatabase.Parameters.Add "NODE_NAME", 		Request("node"),		ORAPARM_INPUT, ORATYPE_VARCHAR2
53 
    OraDatabase.Parameters.Add "NODE_NAME",         Request("node"),        ORAPARM_INPUT, ORATYPE_VARCHAR2
54 
	OraDatabase.Parameters.Add "PROJ_NAME", 		Request("project"),		ORAPARM_INPUT, ORATYPE_VARCHAR2
54 
    OraDatabase.Parameters.Add "PROJ_NAME",         Request("project"),     ORAPARM_INPUT, ORATYPE_VARCHAR2
55 
	OraDatabase.Parameters.Add "BRANCH_NAME", 		Request("release"),		ORAPARM_INPUT, ORATYPE_VARCHAR2
55 
    OraDatabase.Parameters.Add "BRANCH_NAME",       Request("release"),     ORAPARM_INPUT, ORATYPE_VARCHAR2
56 
	OraDatabase.Parameters.Add "BOM_VERSION", 		Request("version"),		ORAPARM_INPUT, ORATYPE_NUMBER
 56 
    OraDatabase.Parameters.Add "BOM_VERSION",       Request("version"),     ORAPARM_INPUT, ORATYPE_NUMBER
57 
	OraDatabase.Parameters.Add "BOM_LIFECYCLE", 	Request("lifecycle"),		ORAPARM_INPUT, ORATYPE_NUMBER
57 
    OraDatabase.Parameters.Add "BOM_LIFECYCLE",     Request("lifecycle"),       ORAPARM_INPUT, ORATYPE_NUMBER
58 
	OraDatabase.Parameters.Add "OS_NAME", 			Request("os"),		ORAPARM_INPUT, ORATYPE_VARCHAR2
58 
    OraDatabase.Parameters.Add "OS_NAME",           Request("os"),      ORAPARM_INPUT, ORATYPE_VARCHAR2
59 
 
 59 
 
60 
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("patch_OsId.sql"), ORADYN_DEFAULT )
 60 
    Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("patch_OsId.sql"), ORADYN_DEFAULT )
61
61
62 
If rsQry.Recordcount > 0 Then
62 
If rsQry.Recordcount > 0 Then
63 
%>
63 
%>
64 
<table width="20%"  border="0" cellspacing="3" cellpadding="0">
 64 
<table width="20%"  border="0" cellspacing="3" cellpadding="0">
65 
  <tr>
 65 
  <tr>
66 
    <td colspan="2" valign="top" nowrap class="body_row style1 style2"><div align="center">Product</div>      <div align="center"></div></td>
 66 
    <td colspan="2" valign="top" nowrap class="body_row style1 style2"><div align="center">Product</div>      <div align="center"></div></td>
67 
    <td colspan="2" valign="top" nowrap class="body_row style1 style2"><div align="center">Package</div>      <div align="center"></div></td>
 67 
    <td colspan="2" valign="top" nowrap class="body_row style1 style2"><div align="center">Package</div>      <div align="center"></div></td>
68 
  </tr>
68 
  </tr>
69 
   <tr>
 69 
   <tr>
70 
    <td width="50%" valign="top" nowrap class="style1 body_row"><div align="center">Name</div></td>
 70 
    <td width="50%" valign="top" nowrap class="style1 body_row"><div align="center">Name</div></td>
71 
    <td width="30%" valign="top" nowrap class="style1 body_row"><div align="center">Version</div></td>
 71 
    <td width="30%" valign="top" nowrap class="style1 body_row"><div align="center">Version</div></td>
72 
	<td width="50%" valign="top" nowrap class="style1 body_row"><div align="center">Name</div></td>
 72 
    <td width="50%" valign="top" nowrap class="style1 body_row"><div align="center">Name</div></td>
73 
    <td width="30%" valign="top" nowrap class="style1 body_row"><div align="center">Version</div></td>
73 
    <td width="30%" valign="top" nowrap class="style1 body_row"><div align="center">Version</div></td>
74 
 </tr>
74 
 </tr>
75 
<%
 75 
<%
76 
Else
 76 
Else
77 
Response.Write("No Patches Found For "&Request("node")&".")
 77 
Response.Write("No Patches Found For "&Request("node")&".")
78 
End If
 78 
End If
79 
		While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
 79 
    While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
80 
	OraDatabase.Parameters.Add "PV_ID", 	rsQry("pv_id"),		ORAPARM_INPUT, ORATYPE_NUMBER
80 
        OraDatabase.Parameters.Add "PV_ID",     rsQry("pv_id"),     ORAPARM_INPUT, ORATYPE_NUMBER
81 
	Set rsPD = OraDatabase.DbCreateDynaset( GetQuery ("pd_patch.sql"), ORADYN_DEFAULT )
81 
        Set rsPD = OraDatabase.DbCreateDynaset( GetQuery ("pd_patch.sql"), ORADYN_DEFAULT )
82 
%>
82 
%>
83 
  <tr>
 83 
  <tr>
84 
    <td width="50%" nowrap class="body_row" valign="top"><div align="center"><%=rsQry("pkg_name")%></div></td>
 84 
    <td width="50%" nowrap class="body_row" valign="top"><div align="center"><%=rsQry("pkg_name")%></div></td>
85 
    <td width="30%" nowrap class="body_row" valign="top"><div align="center"><%=rsQry("pkg_version")%></div></td>
 85 
    <td width="30%" nowrap class="body_row" valign="top"><div align="center"><%=rsQry("pkg_version")%></div></td>
86 
    <td width="50%" nowrap class="body_row" valign="top"><div align="center"><%=rsPD("pkg_name")%></div></td>
 86 
    <td width="50%" nowrap class="body_row" valign="top"><div align="center"><%=rsPD("pkg_name")%></div></td>
87 
    <td width="30%" nowrap class="body_row" valign="top"><div align="center"><%=rsPD("pkg_version")%></div></td>
87 
    <td width="30%" nowrap class="body_row" valign="top"><div align="center"><%=rsPD("pkg_version")%></div></td>
88 
  </tr>
 88 
  </tr>
89 
<%
89 
<%
90 
	OraDatabase.Parameters.Remove "PV_ID"
90 
        OraDatabase.Parameters.Remove "PV_ID"
91 
		rsPD.Close()
 91 
        rsPD.Close()
92 
		Set rsPD = nothing
 92 
        Set rsPD = nothing
93 
		rsQry.MoveNext
93 
        rsQry.MoveNext
94 
		WEnd
94 
    WEnd
95 
	OraDatabase.Parameters.Remove "OS_NAME"
95 
    OraDatabase.Parameters.Remove "OS_NAME"
96 
	OraDatabase.Parameters.Remove "BOM_LIFECYCLE"
96 
    OraDatabase.Parameters.Remove "BOM_LIFECYCLE"
97 
	OraDatabase.Parameters.Remove "BOM_VERSION"
97 
    OraDatabase.Parameters.Remove "BOM_VERSION"
98 
	OraDatabase.Parameters.Remove "RBANCH_NAME"
98 
    OraDatabase.Parameters.Remove "BRANCH_NAME"
99 
	OraDatabase.Parameters.Remove "PROJ_NAME"
99 
    OraDatabase.Parameters.Remove "PROJ_NAME"
100 
	OraDatabase.Parameters.Remove "NODE_NAME"
100 
    OraDatabase.Parameters.Remove "NODE_NAME"
101
101
102 
		rsQry.Close()
 102 
    rsQry.Close()
103 
		Set rsQry = nothing
 103 
    Set rsQry = nothing
104 
%>
 104 
%>
105 
</table>
 105 
</table>
106 
</body>
 106 
</body>
107 
</html>
 107 
</html>
108 
<%
 108 
<%
109 
'------------ RUN AFTER PAGE RENDER -----------
 109 
'------------ RUN AFTER PAGE RENDER -----------
110 
 
 - 
 
111 
 
 - 
 
112 
'----------------------------------------------
 110 
'----------------------------------------------
113 
%>
 111 
%>
114 

            112