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