Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
<%@LANGUAGE="VBSCRIPT"%>
2 
<%
3 
Option explicit
4 
Response.Expires = 0	' always load the page, dont store
5 
 
6 
'To enable the script timeout to 10 mins
7 
Server.ScriptTimeout=600
8 
%>
9 
<%
10 
'=====================================================
11 
'					New Patch
12 
'=====================================================
13 
%>
14 
<!--#include file="common/conf.asp"-->
15 
<!--#include file="common/globals.asp"-->
16 
<!--#include file="common/formating.asp"-->
17 
<!--#include file="common/qstr.asp"-->
18 
<!--#include file="common/common_subs.asp"-->
19 
<!--#include file="common/common_dbedit.asp"-->
20 
<!--#include file="common/_popup_window_common.asp"-->
21 
<%
22 
'------------ ACCESS CONTROL ------------------
23 
%>
24 
<!--#include file="_access_control_login.asp"-->
25 
<!--#include file="_access_control_general.asp"-->
26 
<!--#include file="_access_control_project.asp"-->
27 
<%
28 
'------------ Variable Definition -------------
29 
Dim parPv_id
30 
Dim pkg_name
31 
Dim view_id
32 
Dim patch_version
33 
Dim rsQry
34 
Dim patch_number
35 
Dim pos
36 
Dim newPatch_version
37 
Dim fs, f, i
38 
Dim objNetwork, strDriveLetter, strRemotePath, strUser, strPassword, strProfile, CheckDrive
39 
Dim skip, AlreadyConnected
40 
Dim newPatchId
41 
'------------ Constants Declaration -----------
42 
'------------ Variable Init -------------------
43 
parPv_id = QStrPar("pv_id")
44 
strDriveLetter = "R:"
45 
strRemotePath = "\\auperaunx26\dpkg_archive"
46 
strUser = "releasem"
47 
strPassword = "releasem"
48 
strProfile = "False" ' means do not store in profile leave as false.
49 
AlreadyConnected = False
50 
'----------------------------------------------
51 
%>
52 
<%
53 
'--------------------------------------------------------------------------------------------------
54 
Function SearchAndReplace(s, Str1, Str2)
55 
	Dim pos
56 
	s = s & "" 'Fix Null
57 
	pos = InStr(s, Str1)
58 
	While pos > 0
59 
		s = Mid(s, 1, pos - 1) & Str2 & Mid(s, pos + Len(Str1))
60 
	    pos = InStr(pos, s, Str1)
61 
	Wend
62 
	SearchAndReplace = s
63 
End Function
64 
'--------------------------------------------------------------------------------------------------
65 
Sub Auto_Add_Patch (NNpv_id, patchId, sspatchversion, newPatchId)
66 
	On Error Resume Next
67 
	OraDatabase.Parameters.Add "PATCH_VERSION", 	SSpatchversion, ORAPARM_INPUT, ORATYPE_VARCHAR2
68 
	OraDatabase.Parameters.Add "PV_ID", 			NNpv_id, ORAPARM_INPUT, ORATYPE_NUMBER
69 
	OraDatabase.Parameters.Add "PATCH_ID_LIST", 	patchId, ORAPARM_INPUT, ORATYPE_VARCHAR2
70 
	OraDatabase.Parameters.Add "USER_ID", 			objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER
71 
	OraDatabase.Parameters.Add "RTAG_ID", 			Request("rtag_id"), ORAPARM_INPUT, ORATYPE_NUMBER
72 
	OraDatabase.Parameters.Add "VIEW_ID", 			view_id, ORAPARM_INPUT, ORATYPE_NUMBER
73 
	OraDatabase.Parameters.Add "RET_PATCH_ID", 		0, ORAPARM_OUTPUT, ORATYPE_NUMBER
74 
 
75 
	objEH.TryORA ( OraSession )
76 
 
77 
	OraDatabase.ExecuteSQL _
78 
	"BEGIN "&_
79 
	" PK_PACKAGE.NEW_PATCH( :PATCH_VERSION, :PV_ID, :PATCH_ID_LIST, :USER_ID, :RET_PATCH_ID ); "&_
80 
	"END; "
81 
 
82 
	'" PK_ENVIRONMENT.ADD_PACKAGE ( :RET_PATCH_ID, :VIEW_ID, :RTAG_ID, :USER_ID ); "&_
83 
 
84 
 
85 
 
86 
	objEH.CatchORA ( OraSession )
87 
 
88 
	newPatchId = OraDatabase.Parameters("RET_PATCH_ID").Value
89 
 
90 
	OraDatabase.Parameters.Remove "PATCH_VERSION"
91 
	OraDatabase.Parameters.Remove "PV_ID"
92 
	OraDatabase.Parameters.Remove "PATCH_ID_LIST"
93 
	OraDatabase.Parameters.Remove "USER_ID"
94 
	OraDatabase.Parameters.Remove "RTAG_ID"
95 
	OraDatabase.Parameters.Remove "VIEW_ID"
96 
	OraDatabase.Parameters.Remove "RET_PATCH_ID"
97 
End Sub
98 
'--------------------------------------------------------------------------------------------------
99 
Sub AutoWrite_Reason (patchId, newPatchId)
100 
 
101 
	On Error Resume Next
102 
	Dim rsTemp, filename, textdata, pos1, pos2, rsQry
103 
 
104 
	Set rsTemp = OraDatabase.DbCreateDynaset("SELECT * FROM PACKAGE_VERSIONS PV, PACKAGES PKG WHERE PKG.PKG_ID = PV.PKG_ID AND PV.PV_ID ="&patchId, ORADYN_DEFAULT)
105 
 
106 
	Set fs=Server.CreateObject("Scripting.FileSystemObject")
107 
 
108 
	'Rupesh Testing Start
109 
 
110 
	Set objNetwork = CreateObject("WScript.Network")
111 
	Set CheckDrive = objNetwork.EnumNetworkDrives()
112 
 
113 
	For i = 0 To CheckDrive.Count - 1 Step 2
114 
		If CheckDrive.Item(i) = strDriveLetter Then AlreadyConnected = True
115 
	Next
116 
	If AlreadyConnected = True then
117 
		objNetwork.RemoveNetworkDrive strDriveLetter
118 
	End If
119 
 
120 
	objNetwork.MapNetworkDrive strDriveLetter, strRemotePath, strProfile, strUser, strPassword
121 
 
122 
	filename = Mid(rsTemp("v_ext"), 2, len(rsTemp("v_ext"))) + "."
123 
 
124 
	filename = filename + rsTemp("pkg_name") + "."
125 
 
126 
	filename = filename + Mid(rsTemp("pkg_version"), 1, len(rsTemp("pkg_version")) - 4)
127 
 
128 
	filename = filename + ".sh"
129 
 
130 
	Set f=fs.OpenTextFile(""&strDriveLetter&"\"&rsTemp("pkg_name")&"\"&rsTemp("pkg_version")&"\scripts\"&filename&"", 1)
131 
 
132 
	textdata = f.ReadAll
133 
 
134 
	pos1 = Instr(textdata, "PATCH_ENV1=")
135 
 
136 
	pos2 = Instr(textdata, "PATCH_DATE")
137 
 
138 
	rsTemp.Close()
139 
	Set rsTemp = nothing
140 
 
141 
	Set rsTemp = OraDatabase.DbCreateDynaset("SELECT * FROM PACKAGE_VERSIONS WHERE PV_ID ="&newPatchId, ORADYN_DEFAULT )
142 
    rsTemp.Edit
143 
    rsTemp.Fields("COMMENTS").Value = "Schema Patch - "&Mid(textdata, pos1+11, pos2-(pos1+11))
144 
	rsTemp.Fields("PV_OVERVIEW").Value = rsTemp.Fields("PV_DESCRIPTION").Value
145 
	rsTemp.Fields("IS_BUILD_ENV_REQUIRED").Value = "N"
146 
	Set rsQry = OraDatabase.DbCreateDynaset("SELECT * FROM PACKAGES WHERE PKG_ID ="&rsTemp("pkg_id"), ORADYN_DEFAULT )
147 
	rsTemp.Fields("PKG_LABEL").Value = UCase( Replace(rsTemp("V_EXT"), ".", "") ) &"_"& UCase(rsQry("pkg_name")) &"_R_"& Format_Version( rsTemp("pkg_version"), rsTemp("V_EXT") )
148 
    rsTemp.Update
149 
 
150 
	f.Close()
151 
 
152 
	objNetwork.RemoveNetworkDrive strDriveLetter
153 
	Set f = Nothing
154 
	Set fs = Nothing
155 
	Set objNetwork= Nothing
156 
	rsTemp.Close()
157 
	Set rsTemp = Nothing
158 
	rsQry.Close()
159 
	Set rsQry = Nothing
160 
End Sub
161 
'--------------------------------------------------------------------------------------------------
162 
Sub Add_Patch ( NNpv_id, SSpatchversion )
163 
 
164 
	On Error Resume Next
165 
	OraDatabase.Parameters.Add "PATCH_VERSION", 	SSpatchversion, ORAPARM_INPUT, ORATYPE_VARCHAR2
166 
	OraDatabase.Parameters.Add "PV_ID", 			NNpv_id, ORAPARM_INPUT, ORATYPE_NUMBER
167 
	OraDatabase.Parameters.Add "PATCH_ID_LIST", 	Request("patch_id_list"), ORAPARM_INPUT, ORATYPE_VARCHAR2
168 
	OraDatabase.Parameters.Add "USER_ID", 			objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER
169 
	OraDatabase.Parameters.Add "RTAG_ID", 			Request("rtag_id"), ORAPARM_INPUT, ORATYPE_NUMBER
170 
	OraDatabase.Parameters.Add "VIEW_ID", 			view_id, ORAPARM_INPUT, ORATYPE_NUMBER
171 
	OraDatabase.Parameters.Add "RET_PATCH_ID", 		0, ORAPARM_OUTPUT, ORATYPE_NUMBER
172 
 
173 
	objEH.TryORA ( OraSession )
174 
 
175 
	OraDatabase.ExecuteSQL _
176 
	"BEGIN "&_
177 
	" PK_PACKAGE.NEW_PATCH( :PATCH_VERSION, :PV_ID, :PATCH_ID_LIST, :USER_ID, :RET_PATCH_ID ); "&_
178 
	"END; "
179 
 
180 
	'" PK_ENVIRONMENT.ADD_PACKAGE ( :RET_PATCH_ID, :VIEW_ID, :RTAG_ID, :USER_ID ); "&_
181 
 
182 
 
183 
	objEH.CatchORA ( OraSession )
184 
 
185 
 
186 
 
187 
	OraDatabase.Parameters.Remove "PATCH_VERSION"
188 
	OraDatabase.Parameters.Remove "PV_ID"
189 
	OraDatabase.Parameters.Remove "PATCH_ID_LIST"
190 
	OraDatabase.Parameters.Remove "USER_ID"
191 
	OraDatabase.Parameters.Remove "RTAG_ID"
192 
	OraDatabase.Parameters.Remove "VIEW_ID"
193 
	OraDatabase.Parameters.Remove "RET_PATCH_ID"
194 
End Sub
195 
'-----------------------------------------------------------------------------------------
196 
Sub Auto_Patch (NNpv_id, SSpatchversions)
197 
 
198 
	On Error Resume Next
199 
	Dim posComma, posUnderscore, patchId, sspatchversion, value
200 
 
201 
	value = SSpatchversions
202 
	posComma = InStr(SSpatchversions, ",")
203 
 
204 
	While posComma <> 0
205 
		value = Mid(SSpatchversions, 1, posComma-1)
206 
		posUnderscore = Instr(value, "_")
207 
		patchId = Mid(value, 1, posUnderscore - 1)
208 
		sspatchversion = Mid(value, posUnderscore + 1, posComma-1)
209 
		Call Auto_Add_Patch (NNpv_id, patchId, sspatchversion, newPatchId)
210 
		Call AutoWrite_Reason (patchId, newPatchId)
211 
		Call Insert_NOT_DONE_Unit_Test (newPatchId)
212 
		SSpatchversions = Mid(SSpatchversions, posComma + 1, Len(SSpatchversions))
213 
		posComma = InStr(SSpatchversions, ",")
214 
	Wend
215 
 
216 
	If posComma = 0 Then
217 
		posUnderscore = Instr(SSpatchversions, "_")
218 
		patchId = Mid(SSpatchversions, 1, posUnderscore - 1)
219 
		sspatchversion = Mid(SSpatchversions, posUnderscore + 1)
220 
		Call Auto_Add_Patch (NNpv_id, patchId, sspatchversion, newPatchId)
221 
		Call AutoWrite_Reason(patchId, newPatchId)
222 
		Call Insert_NOT_DONE_Unit_Test (newPatchId)
223 
	End if
224 
 
225 
 
226 
 
227 
End Sub
228 
'-----------------------------------------------------------------------------------------
229 
Sub Get_Parent_Details ( NNpv_id, nRtagId, outPkg_name, outDefPatchVersion, outViewId )
230 
	Dim rsTemp, Query_String, tempVersion, V_EXT
231 
 
232 
	OraDatabase.Parameters.Add "PV_ID", 		NNpv_id, 	ORAPARM_INPUT, ORATYPE_NUMBER
233 
	OraDatabase.Parameters.Add "RTAG_ID", 		nRtagId, 	ORAPARM_INPUT, ORATYPE_NUMBER
234 
 
235 
	Query_String = _
236 
	"  SELECT pkg.pkg_name, pv.pkg_version, pv.V_EXT, rc.BASE_VIEW_ID"&_
237 
	" FROM package_versions pv, "&_
238 
	" 	  packages pkg,"&_
239 
	"	  RELEASE_CONTENT rc"&_
240 
	" WHERE pv.pkg_id = pkg.pkg_id "&_
241 
	"   AND pv.pv_id = :PV_ID"&_
242 
	"   AND rc.RTAG_ID = :RTAG_ID"&_
243 
	"   AND rc.PV_ID = pv.PV_ID"
244 
 
245 
	Set rsTemp = OraDatabase.CreateDynaset( Query_String, cint(0))
246 
 
247 
	OraDatabase.Parameters.Remove "PV_ID"
248 
	OraDatabase.Parameters.Remove "RTAG_ID"
249 
 
250 
	'update fields
251 
	If ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF)) Then
252 
		outPkg_name = rsTemp("pkg_name")
253 
		tempVersion = rsTemp("pkg_version")
254 
		outViewId = rsTemp("base_view_id")
255 
		V_EXT = rsTemp("V_EXT")
256 
	End If
257 
 
258 
	rsTemp.Close()
259 
	Set rsTemp = nothing
260 
 
261 
	If IsNull(V_EXT) Then V_EXT = ""
262 
 
263 
	outDefPatchVersion = Replace( tempVersion, V_EXT, "" ) &".pXXX"& V_EXT
264 
 
265 
End Sub
266 
'------------------------------------------------------------------------------------------------
267 
Sub Insert_NOT_DONE_Unit_Test (nPv_id)
268 
 
269 
	' IN PARAMETERS
270 
	OraDatabase.Parameters.Add "PV_ID", 			nPv_id, 				ORAPARM_INPUT, 	ORATYPE_NUMBER
271 
	OraDatabase.Parameters.Add "TEST_TYPE_ID", 		enumTEST_TYPE_NOT_DONE,	ORAPARM_INPUT, 	ORATYPE_VARCHAR2
272 
	OraDatabase.Parameters.Add "TEST_SUMMARY", 		NULL, 					ORAPARM_INPUT, 	ORATYPE_VARCHAR2
273 
	OraDatabase.Parameters.Add "NUMOF_TEST", 		NULL, 					ORAPARM_INPUT, 	ORATYPE_CHAR
274 
	OraDatabase.Parameters.Add "DPKG_PATH", 		NULL, 					ORAPARM_INPUT, 	ORATYPE_VARCHAR2
275 
	OraDatabase.Parameters.Add "RESULTS", 			NULL,					ORAPARM_INPUT, 	ORATYPE_VARCHAR2
276 
	OraDatabase.Parameters.Add "COMPLETION_DATE", 	EuroDate ( Date ), 	ORAPARM_INPUT, 	ORATYPE_VARCHAR2
277 
	OraDatabase.Parameters.Add "COMPLETED_BY", 		objAccessControl.UserId, ORAPARM_INPUT, 	ORATYPE_NUMBER
278 
	OraDatabase.Parameters.Add "enumTEST_TYPE_AUTOMATIC", 	NULL,			ORAPARM_INPUT, 	ORATYPE_NUMBER
279 
	OraDatabase.Parameters.Add "enumTEST_TYPE_NOT_DONE", 	NULL, 			ORAPARM_INPUT, 	ORATYPE_NUMBER
280 
 
281 
 
282 
	' OUT PARAMETERS
283 
	OraDatabase.Parameters.Add "FILENAME", 			NULL,				ORAPARM_OUTPUT, ORATYPE_VARCHAR2
284 
 
285 
	OraSession.BeginTrans
286 
 
287 
	OraDatabase.ExecuteSQL _
288 
	"BEGIN  New_Unit_Test  ( :PV_ID,"&_
289 
    "                        :TEST_TYPE_ID,"&_
290 
    "                        :TEST_SUMMARY,"&_
291 
    "                        :NUMOF_TEST,"&_
292 
    "                        :DPKG_PATH,"&_
293 
	"                        :RESULTS,"&_
294 
	"                        :COMPLETION_DATE,"&_
295 
    "                        :COMPLETED_BY,"&_
296 
	"                        :enumTEST_TYPE_AUTOMATIC, "&_
297 
	"                        :enumTEST_TYPE_NOT_DONE, "&_
298 
	"                        :FILENAME "&_
299 
	"						  );  END;"
300 
 
301 
	OraSession.CommitTrans
302 
 
303 
 
304 
	OraDatabase.Parameters.Remove "PV_ID"
305 
	OraDatabase.Parameters.Remove "TEST_TYPE_ID"
306 
	OraDatabase.Parameters.Remove "TEST_SUMMARY"
307 
	OraDatabase.Parameters.Remove "NUMOF_TEST"
308 
	OraDatabase.Parameters.Remove "DPKG_PATH"
309 
	OraDatabase.Parameters.Remove "RESULTS"
310 
	OraDatabase.Parameters.Remove "COMPLETION_DATE"
311 
	OraDatabase.Parameters.Remove "COMPLETED_BY"
312 
	OraDatabase.Parameters.Remove "enumTEST_TYPE_AUTOMATIC"
313 
	OraDatabase.Parameters.Remove "enumTEST_TYPE_NOT_DONE"
314 
	OraDatabase.Parameters.Remove "FILENAME"
315 
 
316 
End Sub
317 
'------------------------------------------------------------------------------------------------
318 
%>
319 
<%
320 
'Process submition
321 
Call Get_Parent_Details ( Request("pv_id"),  Request("rtag_id"), pkg_name, patch_version, view_id )
322 
 
323 
If CBool(QStrPar("action")) AND objAccessControl.UserLogedIn Then
324 
	If Request("btn") = "AutoFill" Then
325 
		Call Auto_Patch (parPv_id, Request("auto_patch_id_list") )
326 
	Else
327 
		Call Add_Patch ( parPv_id, Request("FRversion") )
328 
	End If
329 
 
330 
	If objEH.Finally Then
331 
		Call OpenInParentWindow ( "patches.asp?pv_id="& parPv_id &"&rtag_id="& parRtag_id )
332 
		Call CloseWindow
333 
	End If
334 
 
335 
 
336 
End If
337 
%>
338 
<html>
339 
<head>
340 
<script language="javascript">
341 
function checkAllManual()
342 
{
343 
  var args = arguments;
344 
  start_point:
345 
  for (var i=0;i<document.forms[0].elements.length;i++)
346 
  {
347 
 
348 
     found = false;
349 
     var e=document.forms[0].elements[i];
350 
     if ((e.name != 'checkallmanual') && (e.type=='checkbox'))
351 
     {
352 
        for (var j = 0; j < args.length; j++)
353 
           if (args[j] == e.name)
354 
             continue start_point;
355 
 
356 
       e.checked=document.forms[0].checkallmanual.checked;
357 
    }
358 
  }
359 
}
360 
 
361 
function checkAllAuto()
362 
{
363 
  var args = arguments;
364 
  start_point:
365 
  for (var i=0;i<document.forms[0].elements.length;i++)
366 
  {
367 
 
368 
     found = false;
369 
     var e=document.forms[0].elements[i];
370 
     if ((e.name != 'checkallauto') && (e.type=='checkbox'))
371 
     {
372 
        for (var j = 0; j < args.length; j++)
373 
           if (args[j] == e.name)
374 
             continue start_point;
375 
 
376 
       e.checked=document.forms[0].checkallauto.checked;
377 
    }
378 
  }
379 
}
380 
</script>
381 
<title>Release Manager</title>
382 
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
383 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
384 
<link rel="stylesheet" href="images/release_manager_style.css" type="text/css">
385 
<link rel="stylesheet" href="images/navigation.css" type="text/css">
386 
<script language="JavaScript" src="images/common.js"></script>
387 
</head>
388 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();document.ptch.FRversion.focus();">
389 
<form name="ptch" method="post" action="<%=scriptName%>" onSubmit="MM_validateForm('FRversion','Patch Version','RisVersionStr');return document.MM_returnValue;">
390 
  <table width="100%" border="0" cellspacing="0" cellpadding="2" height="100%">
391 
    <tr>
392 
      <td background="images/lbox_bg_orange.gif" width="1%" height="1%"><img src="images/i_new_pkg_off.gif" width="21" height="23" hspace="5" border="0"></td>
393 
      <td background="images/lbox_bg_blue.gif" nowrap width="50%" class="wform_ttl">&nbsp;New Patch</td>
394 
      <td background="images/lbox_bg_blue.gif" align="right" width="50%">
395 
		<input type="submit" name="btn" value="AutoFill" class="form_btn_comp">
396 
        <input type="submit" name="btn" value="Submit" class="form_btn_comp">
397 
        <input type="reset" name="btn" value="Cancel" class="form_btn_comp" onclick="self.close()">
398 
      </td>
399 
      <td background="images/lbox_bg_blue.gif" align="right" width="1%%" nowrap>
400 
        <img src="images/h_trsp_dot.gif" width="5" height="22"> </td>
401 
    </tr>
402 
    <tr>
403 
      <td height="100%" width="1%">&nbsp;</td>
404 
      <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_form_lightgray.gif">
405 
        <table width="100%" border="0" cellspacing="1" cellpadding="3">
406 
          <tr>
407 
            <td width="1%" nowrap background="images/bg_form_lightbluedark.gif" class="form_field" colspan="2">Package</td>
408 
            <td width="100%" nowrap background="images/bg_form_lightbluedark.gif" class="form_txt"><%=pkg_name%></td>
409 
          </tr>
410 
          <tr>
411 
            <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field" colspan="2">Patch Version</td>
412 
            <td nowrap background="images/bg_form_lightbluedark.gif" class="form_txt">
413 
              <input name="FRversion" type="text" class="form_item"  size="30" maxlength="50" value="<%=patch_version%>">
414 
            </td>
415 
          </tr>
416 
		  <!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->
417 
          <%If NOT objEH.Finally Then%>
418 
          <tr>
419 
            <td class="form_iname" colspan="2">&nbsp;</td>
420 
            <td>
421 
              <%objEH.DisplayMessage()%>
422 
            </td>
423 
          </tr>
424 
          <%End If%>
425 
          <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
426 
		  <!-- INCLUDE DEPENDENCY PATCHES +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++  -->
427 
		  <%
428 
		  OraDatabase.Parameters.Add "PV_ID", 	parPv_id, ORAPARM_INPUT, ORATYPE_NUMBER
429 
		  OraDatabase.Parameters.Add "RTAG_ID", parRtag_id, ORAPARM_INPUT, ORATYPE_NUMBER
430 
		  %>
431 
		  <%
432 
		  Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("UnusedPatches.sql"), cint(0))
433 
		  %>
434 
		  <%If rsQry.RecordCount > 0 Then%>
435 
		  <tr>
436 
            <td nowrap class="body_colb" colspan="3"><br><br>Include Dependency Patches</td>
437 
          </tr>
438 
		  <tr>
439 
            <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Manual</td>
440 
            <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Package</td>
441 
            <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Patch Version</td>
442 
            <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Auto</td>
443 
            <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Package</td>
444 
            <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Patch Version</td>
445 
          </tr>
446 
		  <tr>
447 
            <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field"><INPUT type=checkbox name="checkallmanual"   value="Check All"
448 
				onClick="checkAllManual('auto_patch_id_list', 'checkallauto');"></td>
449 
            <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field"></td>
450 
            <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field"></td>
451 
            <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field"><INPUT type=checkbox name="checkallauto"   value="Check All"
452 
				onClick="checkAllAuto('patch_id_list', 'checkallmanual');"></td>
453 
            <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field"></td>
454 
            <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field"></td>
455 
          </tr>
456 
		  <%End If%>
457 
		  <%While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))
458 
 
459 
		  newPatch_version = patch_version
460 
		  pos = InStr(rsQry("pkg_version"), "p")
461 
 
462 
		  patch_number = Mid(rsQry("pkg_version"), pos+1, 3)
463 
 
464 
		  newPatch_version = SearchAndReplace(newPatch_version, "XXX", patch_number)
465 
		  %>
466 
          <tr>
467 
            <td><input type="checkbox" name="patch_id_list" value="<%=rsQry("patch_id")%>"></td>
468 
            <td nowrap class="form_txt"><%=rsQry("pkg_name")%></td>
469 
            <td nowrap class="form_txt"><%=rsQry("pkg_version")%></td>
470 
            <td><input type="checkbox" name="auto_patch_id_list" value="<%=rsQry("patch_id")%>_<%=newPatch_version%>"></td>
471 
            <td nowrap class="form_txt"><font color="#808080"><b><%=pkg_name%></b></font></td>
472 
            <td nowrap class="form_txt"><font color="#808080"><b><%=newPatch_version%></b></font></td>
473 
          </tr>
474 
		  <%rsQry.MoveNext
475 
		  WEnd
476 
 
477 
		  rsQry.Close
478 
		  Set rsQry = nothing
479 
		  %>
480 
 
481 
		  <!-- INCLUDE PACKAGES +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++  -->
482 
		  <%
483 
		  Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("UnusedPackages.sql"), cint(0))
484 
		  %>
485 
		  <%If rsQry.RecordCount > 0 Then%>
486 
		  <tr>
487 
            <td nowrap class="body_colb" colspan="3"><br><br>Include Latest Packages</td>
488 
          </tr>
489 
		  <tr>
490 
            <td width="1%" background="images/bg_form_lightbluedark.gif">&nbsp;</td>
491 
            <td width="1%" nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Package</td>
492 
            <td width="100%" nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Patch Version</td>
493 
          </tr>
494 
		  <%End If%>
495 
		  <%While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))%>
496 
          <tr>
497 
            <td><input type="checkbox" name="patch_id_list" value="<%=rsQry("latest_pv_id")%>"></td>
498 
            <td nowrap class="form_txt"><%=rsQry("pkg_name")%></td>
499 
            <td nowrap class="form_txt"><%=rsQry("pkg_version")%></td>
500 
          </tr>
501 
		  <%rsQry.MoveNext
502 
		  WEnd
503 
 
504 
		  rsQry.Close
505 
		  Set rsQry = nothing
506 
		  %>
507 
		  <%
508 
		  OraDatabase.Parameters.Remove "PV_ID"
509 
		  OraDatabase.Parameters.Remove "RTAG_ID"
510 
		  %>
511 
        </table> </td>
512 
    </tr>
513 
    <tr>
514 
      <td height="1%" width="1%"><img src="images/h_trsp_dot.gif" width="5" height="5"></td>
515 
      <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/lbox_bg_blue.gif"></td>
516 
    </tr>
517 
  </table>
518 
<input type="hidden" name="pv_id" value="<%=parPv_id%>">
519 
<input type="hidden" name="rtag_id" value="<%=parRtag_id%>">
520 
<input type="hidden" name="action" value="true">
521 
</form>
522 
</body>
523 
</html>
524 
 
525 
 
526 
<!-- DESTRUCTOR ------->
527 
<!--#include file="common/destructor.asp"-->