Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

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