Subversion Repositories DevTools

Rev

Rev 5623 | Rev 5670 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
5623 dpurdie 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
4
'
5
'  Build Status and Plan Information
6
'
7
'=====================================================
8
%>
9
<%
10
Option explicit
11
' Good idea to set when using redirect
12
Response.Expires = 0  ' always load the page, dont store
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/_form_window_common.asp"-->
20
<!--#include file="_action_buttons.asp"-->
21
<!--#include file="class/classActionButtonControl.asp"-->
22
<!--#include file="common/daemon_instructions.asp"-->
23
<%
24
'------------ ACCESS CONTROL ------------------
25
'Let users view the build status without being logged in, but as soon as they try and 
26
'submit the form, check their login status.
27
If Request("action") <> "" AND NOT objAccessControl.UserLogedIn Then%>
28
<!--#include file="_access_control_login.asp"-->
29
<!--#include file="_access_control_project.asp"-->
30
<%End If%>
31
<!--#include file="_access_control_general.asp"-->
32
<% '------------ Scripts -------------------------- %>
33
<%
34
'------------ Variable Definition -------------
35
Dim objSortHelper
36
Dim rsQry
37
Dim parRtagId
38
Dim query_string
39
Dim rcon_id
40
Dim rsQry2
41
'------------ Constants Declaration -----------
42
'------------ Variable Init -------------------
43
parRtagId = Request("rtag_id")
44
objPMod.PersistInQryString("rtag_id")
45
 
46
'----------------------------------------------
47
%>
48
<%
49
'--------------------------------------------------------------------------------------------------------------------------
50
Function PrettyDelta( delta, daemonState,pkgId )
51
    Dim style
52
    style = ""
53
 
54
    If (delta > 600) AND (IsNull(pkgId) OR pkgId = "") Then
55
      style = "style=color:Red"
56
      If (delta > 86400 ) Then
57
        Dim bdate, dd,mm,yy
58
        bdate = DateAdd("s", - delta,Now())
59
        dd = Day(bdate)
60
        mm = MonthName(Month(bdate),1)
61
        yy = Year( bdate)
62
        delta = dd & "-" & mm & "-" & yy
63
        If ( daemonState >= 2 ) Then
64
            style = ""
65
        End If
66
      ElseIf ( delta > 60*60 ) Then
67
        'Dim bdate, hh, mins, ss
68
        bdate = DateAdd("s", - delta,Now())
69
        delta = TimeValue( bdate)
70
        'delta = hh & ":" & mins & ":" & ss
71
      End If
72
    End If
73
 
74
    If style <> "" Then
75
        delta = "<span " & style & ">" & delta & "</span>"
76
    End If
77
    PrettyDelta = delta
78
End Function
79
'--------------------------------------------------------------------------------------------------------------------------
80
Function Get_Daemon_Mode( cMode )
81
 
82
   If cMode = "S" Then
83
      Get_Daemon_Mode = "Slave"
84
   ElseIf cMode = "M" Then
85
      Get_Daemon_Mode = "Master"
86
   End If
87
 
88
End Function
89
'--------------------------------------------------------------------------------------------------------------------------
90
Function Get_Run_Level( nLevel, indefinitePause, astate)
91
 
92
   If indefinitePause Then
93
      Get_Run_Level = "<span class='err_alert'>Stopped</span>"
94
   ElseIf astate = 1 Then      ' if build daemon paused
95
      Get_Run_Level = "Paused"
96
   ElseIf astate = 2 Then      ' if build daemon disabled
97
      Get_Run_Level = "Disabled"
98
   ElseIf astate = 0 Then     ' if build daemon enabled
99
      If nLevel = 1 Then
100
         Get_Run_Level = "Cannot Continue"
101
      ElseIf nLevel = 2 Then
102
         Get_Run_Level = "Paused"
103
      ElseIf nLevel = 3 Then
104
         Get_Run_Level = "Building"
105
      ElseIf nLevel = 4 Then
106
         Get_Run_Level = "Idle"
107
      ElseIf nLevel = 5 Then
108
         Get_Run_Level = "Waiting"
109
      ElseIf nLevel = 6 Then
110
         Get_Run_Level = "Publishing"
111
      Else
112
         Get_Run_Level = "<span class='err_alert'>Unknown!</span>"
113
      End If
114
   End If
115
 
116
End Function
117
 
118
'--------------------------------------------------------------------------------------------------------------------------
119
Function Get_Package_Name( sPackageName,nRtagId,nPkgPvid )
120
 
121
  If IsNull(sPackageName) Then
122
    Get_Package_Name = "None"
123
  ElseIf IsNull(nPkgPvid) or nPkgPvid <= 0 Then
124
    Get_Package_Name = sPackageName
125
  Else
126
    Get_Package_Name = "<a class=""txt_linked"" href=""dependencies.asp?pv_id=" +  nPkgPvid + "&rtag_id=" + nRtagId + """>" + sPackageName + "</a>"
127
  End If
128
 
129
End Function
130
'--------------------------------------------------------------------------------------------------------------------------
131
Function GetLastBuildAge( rtagid)
132
   Dim  query_string, rsQry
133
       query_string = "SELECT TRUNC (86400*(SYSDATE - rl.LAST_BUILD)) as delta," &_
134
                      "       TO_CHAR(rl.LAST_BUILD, 'DD-Mon-YYYY') as last_build," &_
135
                      "       TO_CHAR(rl.LAST_BUILD, 'HH:MM:SS PM') as last_build_hours," &_
136
                      "       TRUNC (SYSDATE - rl.LAST_BUILD) as last_build_days" &_
137
                      " FROM RELEASE_CONFIG rc, RUN_LEVEL rl, BUILD_MACHINE_CONFIG bm " &_
138
                      " WHERE rc.RTAG_ID =" &rtagid &_
139
                      "   AND rc.bmcon_id is not null" &_
140
                      "   AND rl.RCON_ID = rc.RCON_ID" &_
141
                      "   AND rc.bmcon_id = bm.bmcon_id(+)"
142
 
143
        Set rsQry = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )
144
        If (NOT rsQry.BOF) AND (NOT rsQry.EOF) Then
145
            Dim delta, last_build, last_build_time, last_build_days
146
            If IsNull(rsQry("delta")) Then
147
                delta = 0
148
            Else
149
                delta = CLng(rsQry("delta"))
150
            End If
151
            last_build = rsQry("last_build")
152
            last_build_time = rsQry("last_build_hours")
153
            last_build_days = rsQry("last_build_days")
154
            If delta < (60*60*24) Then
155
                GetLastBuildAge = last_build_time  
156
            Else     
157
                GetLastBuildAge = last_build
158
            End If
159
        End If
160
        rsQry.Close()
161
        Set rsQry = nothing
162
 
163
End Function
164
 
165
'--------------------------------------------------------------------------------------------------------------------------
166
Function GetModifiedSeqNo( rtagid)
167
   Dim  query_string, rsQry
168
       query_string = "SELECT SEQNUM FROM RELEASE_MODIFIED WHERE RTAG_ID = " & rtagid
169
 
170
        Set rsQry = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )
171
        If (NOT rsQry.BOF) AND (NOT rsQry.EOF) Then
172
            GetModifiedSeqNo = rsQry("SEQNUM")
173
        Else
174
            GetModifiedSeqNo = "-"
175
        End If
176
        rsQry.Close()
177
        Set rsQry = nothing
178
 
179
End Function
180
'--------------------------------------------------------------------------------------------------------------------------
181
'------------ RUN BEFORE PAGE RENDER ----------
182
%>
183
<html>
184
   <head>
185
      <title>Release Manager</title>
186
      <link rel="shortcut icon" href="<%=FavIcon%>"/>
187
      <meta http-equiv="Pragma" content="no-cache">
188
      <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
189
      <link rel="stylesheet" href="images/release_manager_style.css" type="text/css">
190
      <link rel="stylesheet" href="images/navigation.css" type="text/css">
191
      <script language="JavaScript" src="images/common.js"></script>
192
      <!--#include file="_jquery_includes.asp"-->
193
      <!-- TIPS -->
194
      <script type="text/javascript" src="scripts/json2.js"></script>
195
      <script language="JavaScript" src="images/tipster.js"></script>
196
      <script language="JavaScript" src="images/_help_tips.js"></script>
197
      <script language="JavaScript" type="text/JavaScript">
198
      formTips.tips.h_buildplan       = stdTip(300, 'Build Plan', 'The build plan is a guess as to the order in which packages will be built.' +
199
                                                                  '<p>It will be recalculated before each build.' + 
200
                                                                  '<p>The plan includes test builds, new builds and resultant ripples.' 
201
                                                                  );
5635 dpurdie 202
      formTips.tips.h_buildDuration       = stdTip(300, 'Planned Duration', 'The build duration (seconds) of the last build of this package - if known.' +
203
                                                                  '<p>This is used as a guess as to the duration of the planned build.' 
204
                                                                  );
5623 dpurdie 205
      formTips.tips.h_lastchange       = stdTip(300, 'Last Change', 'This is an indication of the time since the daemon interogated the database.' +
206
                                                                  '<p>Short times will be shown as seconds. Longer times will be shown as a time within ' + 
207
                                                                  'the last 24 hours. Longer times will be shown as a date.' 
208
                                                                  );
209
 
210
      </script>
211
      <!-- DROPDOWN MENUS -->
212
      <!--#include file="_menu_def.asp"-->
213
      <script language="JavaScript1.2" src="images/popup_menu.js"></script>
214
   </head>
215
   <body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
216
      <!-- MENU LAYERS -------------------------------------->
217
      <div id="popmenu" class="menuskin" onmouseover="clearhidemenu();highlightmenu(event,'on')" onmouseout="highlightmenu(event,'off');dynamichide(event)"></div>
218
      <!-- TIPS LAYERS -------------------------------------->
219
      <div id="formTipsLayer" style="position: absolute; z-index: 1000; visibility: hidden; left:0; top: 0; width: 10">&nbsp;</div>
220
      <!----------------------------------------------------->
221
      <!-- HEADER -->
222
      <!--#include file="_header.asp"-->
223
      <!-- BODY ---->
224
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
225
         <tr>
226
            <td width="1" background="images/bg_home_orange.gif" valign="top"></td>
227
            <td width="100%" rowspan="2" align="center" valign="top" bgcolor="#EEEFEF">
228
               <table width="10" border="0" cellspacing="0" cellpadding="0">
229
                  <tr>
230
                     <td width="1%"></td>
231
                     <td width="100%">
232
                        <table width="100%" border="0" cellspacing="0" cellpadding="0">
233
                           <tr>
234
                              <td nowrap class="form_ttl"><p>&nbsp;</p>
235
                                 <p>DAEMON STATUS INFORMATION</p>
236
                              </td>
237
                              <td  valign="bottom" class="body_rowg">
238
                                Last Build: <%=GetLastBuildAge(parRtagId)%> [<%=GetModifiedSeqNo(parRtagId)%>]
239
                              </td>
240
                              <td align="right" valign="bottom">
241
                                <a class="txt_linked" href="<%=scriptName%>?rtag_id=<%=parRtagId%>" title="Refresh Page">[Refresh]</a></td>
242
                              </td>
243
                           </tr>
244
                        </table>
245
                     </td>
246
                     <td width="1%"></td>
247
                  </tr>
248
                  <tr>
249
                     <td align="left" valign="top" background="images/lbox_bg_blue.gif"><img src="images/lbox_tl_cnr_b.gif" width="13" height="13"></td>
250
                     <td background="images/lbox_bg_blue.gif" class="lbox_ttl_w"><img src="images/h_trsp_dot.gif" width="600" height="15"></td>
251
                     <td align="right" valign="top" background="images/lbox_bg_blue.gif"><img src="images/lbox_tr_cnr_b.gif" width="13" height="13"></td>
252
                  </tr>
253
                  <tr>
254
                     <td bgcolor="#FFFFFF"><img src="images/h_trsp_dot.gif" width="10" height="100"></td>
255
                     <td bgcolor="#FFFFFF" valign="top">
256
                        <!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->
257
                        <!--#include file="messages/_msg_inline.asp"-->
258
                        <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
259
                        <br>
260
                        <table width="100%" border="0" cellspacing="2" cellpadding="0">
261
                           <%
262
                           Dim indefinitelyPaused
263
                           indefinitelyPaused = FALSE
264
                           ' Insert a warning into the page if the build daemons are indefintely paused.
265
                           query_string = " select * from run_level_schedule rls where rls.indefinite_pause = 'P'"
266
 
267
                           Set rsQry = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )
268
                           If rsQry.RecordCount > 0 Then
269
                              indefinitelyPaused = TRUE %>
270
                              <tr>
271
                                 <span class='err_alert'>
272
                                    <font size='2'><b>WARNING: Build Daemons are all stopped - please contact an administrator</b></font>
273
                                 </span>
274
                              </tr>
275
                           <%End If
276
 
277
                           rsQry.Close()
278
                           Set rsQry = nothing
279
                           %>
280
                           <td width="9%" valign="top"></td>
281
                           <tr>
282
                              <td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Daemon Host</td>
283
                              <td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Machine Type</td>
284
                              <td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Mode</td>
285
                              <td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Run Level</td>
286
                              <td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Current Package</td>
287
                              <td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Last Change<%=Quick_Help("h_lastchange")%></td>
288
                              <td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Control State</td>
289
                           </tr>
290
                           <%
291
                           ' Get the number of release configurations for this RTAG_ID, and iterate through them
292
                           query_string = " select * from release_config rc, gbe_machtype gm, build_machine_config bm"&_
293
                                          "  where rc.rtag_id = "& parRtagId &_
294
                                          "    and gm.gbe_id = rc.gbe_id"&_
295
                                          "    and rc.bmcon_id=bm.bmcon_id(+)" &_
296
                                          "  order by bm.display_name, rc.rcon_id"
297
 
298
                           Set rsQry = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )
299
 
300
                           Do While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
301
                              rcon_id = rsQry("rcon_id")
302
 
303
                              Dim pkgName
304
                              Dim pkgPvid
305
                              Dim currentRunLevel
306
                              Dim daemonState
307
                              Dim delta
308
                              Dim pkgId
309
 
310
                              ' For this release configuration, get its entry from the run_level table. This table may not
311
                              ' have an entry so we must handle that outcome too.
312
                              query_string = " select rl.pause, rl.current_run_level, rl.current_pkg_id_being_built, "&_
313
                                             "        TRUNC (86400*(SYSDATE - rl.KEEP_ALIVE)) as delta" &_
314
                                             "   from run_level rl"&_
315
                                             "  where rl.rcon_id = "& rcon_id
316
 
317
                              Set rsQry2 = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )
318
 
319
                              currentRunLevel = -1
320
                              pkgId = Null
321
                              pkgName = NULL
322
                              pkgPvid = NULL
323
                              daemonState = 0
324
                              delta = NULL
325
 
326
                              If (rsQry2.RecordCount > 0) Then
327
                                ' Get the run level from the run_level table
328
                                currentRunLevel = rsQry2("current_run_level")
329
                                pkgId = rsQry2("current_pkg_id_being_built")
330
 
331
                                daemonState = rsQry2("pause")
332
                                If IsNull(daemonState) Then daemonState = 0
333
                                If daemonState = "2" Then pkgId = Null
334
 
335
                                delta = rsQry2("delta")
336
                              End If
337
 
338
                              ' If we got an entry from the run_level table, try and use the pkg_id it contains, to obtain a
339
                              ' package name from the packages table
340
                              Dim rsQry3
341
                              If NOT IsNull(pkgId) Then
342
                                 query_string = " select pkg_name,rl.current_pv_id from run_level rl, packages pk"&_
343
                                                "  where rl.rcon_id = "& rcon_id &_
344
                                                "   and  rl.current_pkg_id_being_built = pk.pkg_id"
345
 
346
                                 Set rsQry3 = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )
347
                                 If (rsQry3.RecordCount > 0) Then
348
                                    pkgName = rsQry3("pkg_name")
349
                                    pkgPvid = rsQry3("current_pv_id")
350
                                 End If
351
                                 rsQry3.Close()
352
                                 Set rsQry3 = nothing
353
                              End If
354
 
355
                              ' --- Now render HTML for this release configuration ---
356
                              %>
357
                              <tr>
358
                                 <td colspan="7" background="images/bg_rep_line.gif"><img src="images/spacer.gif" width="1" height="1"></td>
359
                              </tr>
360
                              <tr>
361
                                 <td nowrap class="body_rowg"><%=rsQry("display_name")%></td>
362
                                 <td nowrap class="body_rowg"><%=rsQry("gbe_value")%></td>
363
                                 <td nowrap class="body_rowg"><%=Get_Daemon_Mode(rsQry("daemon_mode"))%></td>
364
                                 <td nowrap class="body_rowg"><%=Get_Run_Level(currentRunLevel, indefinitelyPaused,daemonState)%></td>
365
                                 <td nowrap class="body_rowg"><%=Get_Package_Name(pkgName,parRtagId,pkgPvid)%></td>
366
                                 <td nowrap class="body_rowg"><%=PrettyDelta(delta, daemonState,pkgName )%></td>
367
                                 <td nowrap class="body_rowg">
368
                                    <%
369
                                    If (rsQry2.RecordCount > 0) AND NOT indefinitelyPaused  Then
370
                                       If objAccessControl.UserLogedIn AND canActionControlInProject("BuildControl") Then
371
                                          If daemonState = 0 Then
372
                                             Call Action_Buttons ( "Daemon Pause" )
373
                                          ElseIf daemonState = 1 Then
374
                                             Call Action_Buttons ( "Daemon Resume" )
375
                                          ElseIf daemonState = 2 Then
376
                                             Call Action_Buttons ( "Daemon Start" )
377
                                          Else
378
                                             Call Action_Buttons ( "Daemon Resume" )
379
                                          End If
380
                                       Else
381
                                          If daemonState = 0 Then
382
                                             Call Action_Buttons ( "Daemon Pause Disabled" )
383
                                          ElseIf daemonState = 1 Then
384
                                             Call Action_Buttons ( "Daemon Resume Disabled" )
385
                                          ElseIf daemonState = 2 Then
386
                                             Call Action_Buttons ( "Daemon Start Disabled" )
387
                                          Else
388
                                             Call Action_Buttons ( "Daemon Resume Disabled" )
389
                                          End If
390
                                       End If
391
                                    Else
392
                                       %>Unavailable<%
393
                                    End If
394
                                    %>
395
                                 </td>
396
                              </tr>
397
                              <%
398
                              rsQry2.Close()
399
                              Set rsQry2 = nothing
400
                              rsQry.MoveNext
401
                           Loop
402
                           %>
403
                           <tr>
404
                             <td valign="bottom" background="images/bg_table_col.gif" class="body_col"></td>
405
                             <td valign="bottom" nowrap background="images/bg_table_col.gif" class="body_col"></td>
406
                             <td valign="bottom" nowrap background="images/bg_table_col.gif" class="body_col"></td>
407
                             <td valign="bottom" background="images/bg_table_col.gif" class="body_col"></td>
408
                             <td valign="bottom" nowrap background="images/bg_table_col.gif" class="body_col"></td>
409
                             <td valign="bottom" nowrap background="images/bg_table_col.gif" class="body_col"></td>
410
                             <td valign="bottom" nowrap background="images/bg_table_col.gif" class="body_col">
411
                             <%
412
                               If (rsQry.RecordCount > 0) AND NOT indefinitelyPaused  Then
413
                                 If objAccessControl.UserLogedIn AND canActionControlInProject("BuildControl") Then
414
                                   Call Action_Buttons ( "Daemon Control All" )
415
                                 Else 
416
                                   Call Action_Buttons ( "Daemon Control All Disabled" )
417
                                 End If
418
                               Else
419
                                 %>&nbsp<%
420
                               End If
421
                             %>
422
                             </td>
423
                           </tr>
424
                           <%
425
                             rsQry.Close()
426
                             Set rsQry = nothing
427
                           %>
428
                        </table>
429
                     </td>
430
                     <td background="images/lbox_bgside_white.gif">&nbsp;</td>
431
                  </tr>
432
                  <tr>
433
                     <input type="hidden" name="action" value="true">
434
                     <%=objPMod.ComposeHiddenTags()%>
435
                     <td background="images/lbox_bg_blue.gif" valign="bottom"><img src="images/lbox_bl_cnr_b.gif" width="13" height="13"></td>
436
                     <td background="images/lbox_bg_blue.gif"></td>
437
                     <td background="images/lbox_bg_blue.gif" valign="bottom" align="right"><img src="images/lbox_br_cnr_b.gif" width="13" height="13"></td>
438
                  </tr>
439
               </table>
440
 
441
               <!-- Planned Builds Display -->
442
               <table width="10" border="0" cellspacing="0" cellpadding="0">
443
                  <tr>
444
                     <td width="1%"></td>
445
                     <td width="100%">
446
                        <table width="100%" border="0" cellspacing="0" cellpadding="0">
447
                           <tr>
448
                              <td nowrap class="form_ttl"><p>&nbsp;</p>
449
                                 <p>DAEMON BUILD PLAN<%=Quick_Help("h_buildplan")%></p>
450
                              </td>
451
                              <td align="right" valign="bottom"></td>
452
                           </tr>
453
                        </table>
454
                     </td>
455
                     <td width="1%"></td>
456
                  </tr>
457
                  <tr>
458
                     <td align="left" valign="top" background="images/lbox_bg_blue.gif"><img src="images/lbox_tl_cnr_b.gif" width="13" height="13"></td>
459
                     <td background="images/lbox_bg_blue.gif" class="lbox_ttl_w"><img src="images/h_trsp_dot.gif" width="600" height="15"></td>
460
                     <td align="right" valign="top" background="images/lbox_bg_blue.gif"><img src="images/lbox_tr_cnr_b.gif" width="13" height="13"></td>
461
                  </tr>
462
                  <tr>
463
                     <td bgcolor="#FFFFFF"><img src="images/h_trsp_dot.gif" width="10" ></td>
464
                     <td bgcolor="#FFFFFF" valign="top">
465
                        <table width="100%" border="0" cellspacing="2" cellpadding="0">
466
                           <tr>
467
                              <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Package</td>
468
                              <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Version</td>
5635 dpurdie 469
                              <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Duration<%=Quick_Help("h_buildDuration")%></td>
5623 dpurdie 470
                           </tr>
471
                           <%
472
                           Dim PkgVersion
473
                           Set rsQry = OraDatabase.DbCreateDynaset( "SELECT p.PKG_NAME," &_
5635 dpurdie 474
                                                                    "  pv.PKG_VERSION, pv.BUILD_TIME," &_
5623 dpurdie 475
                                                                    "  bp.PV_ID" &_
476
                                                                    " FROM build_plan bp," &_
477
                                                                    "  packages p," &_
478
                                                                    "  package_versions pv" &_
479
                                                                    " WHERE bp.PV_ID = pv.pv_id" &_
480
                                                                    " AND RTAG_ID = " & parRtagId &_
481
                                                                    " AND pv.PKG_ID  = p.pkg_id" &_
482
                                                                    " ORDER BY build_order" , ORADYN_DEFAULT )
483
                           While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
484
                              %>
485
                              <tr>
486
 
487
                                 <td align="left" valign="top" class="body_txt">
488
                                    <%=Get_Package_Name(rsQry("PKG_NAME"), parRtagId, rsQry("PV_ID"))%>
489
                                 </td>
490
                                 <td align="left" valign="top" class="body_txt">
491
                                    <%=rsQry("PKG_VERSION")%>
492
                                 </td>
5635 dpurdie 493
                                 <td align="left" valign="top" class="body_txt">
494
                                    <%=rsQry("BUILD_TIME")%>
495
                                 </td>
496
 
5623 dpurdie 497
                              </tr>
498
                              <tr>
499
                                 <td colspan="6" background="images/bg_rep_line.gif"><img src="images/spacer.gif" width="1" height="1"></td>
500
                              </tr>
501
                              <%
502
                              rsQry.MoveNext()
503
                           Wend
504
                           rsQry.Close()
505
                           Set rsQry = nothing
506
                           %>
507
                        </table>
508
                     </td>
509
                     <td background="images/lbox_bgside_white.gif">&nbsp;</td>
510
                  </tr>
511
                  <tr>
512
                     <td background="images/lbox_bg_blue.gif" valign="bottom"><img src="images/lbox_bl_cnr_b.gif" width="13" height="13"></td>
513
                     <td background="images/lbox_bg_blue.gif"></td>
514
                     <td background="images/lbox_bg_blue.gif" valign="bottom" align="right"><img src="images/lbox_br_cnr_b.gif" width="13" height="13"></td>
515
                  </tr>
516
               </table>
517
 
518
            </td>
519
            <td width="1" valign="top"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
520
         </tr>
521
         <tr>
522
            <td valign="bottom" align="center" background="images/bg_home_orange.gif">
523
                <img src="images/img_gear.gif" width="86" height="99" vspace="20" hspace="30">
524
            </td>
525
            <td background="images/bg_lght_gray.gif" valign="top"><img src="images/h_trsp_dot.gif" width="1" height="350">
526
            </td>
527
         </tr>
528
      </table>
529
      <!-- FOOTER -->
530
      <!--#include file="_footer.asp"-->
531
   </body>
532
</html>
533
<%
534
Call Destroy_All_Objects
535
%>