Subversion Repositories DevTools

Rev

Rev 5190 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5190 Rev 5357
Line 1... Line 1...
1
<%@LANGUAGE="VBSCRIPT"%>
1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
2
<%
3
'=====================================================
3
'=====================================================
4
'|                                                   |
4
'|                                                   |
5
'|		           Run Time Dependencies             |
5
'|		           Run Time Dependencies             |
6
'|                                                   |
6
'|                                                   |
7
'=====================================================
7
'=====================================================
8
%>
8
%>
9
<%
9
<%
10
Option explicit
10
Option explicit
11
' Good idea to set when using redirect
11
' Good idea to set when using redirect
12
Response.Expires = 0	' always load the page, dont store
12
Response.Expires = 0	' always load the page, dont store
13
%>
13
%>
14
<!--#include file="common/conf.asp"-->
14
<!--#include file="common/conf.asp"-->
15
<!--#include file="common/globals.asp"-->
15
<!--#include file="common/globals.asp"-->
16
<!--#include file="common/formating.asp"-->
16
<!--#include file="common/formating.asp"-->
17
<!--#include file="common/qstr.asp"-->
17
<!--#include file="common/qstr.asp"-->
18
<!--#include file="common/common_subs.asp"-->
18
<!--#include file="common/common_subs.asp"-->
19
<!--#include file="common/common_dbedit.asp"-->
19
<!--#include file="common/common_dbedit.asp"-->
20
<!--#include file="_tabs.asp"-->
20
<!--#include file="_tabs.asp"-->
21
<!--#include file="_action_buttons.asp"-->
21
<!--#include file="_action_buttons.asp"-->
22
<!--#include file="common/_package_common.asp"-->
22
<!--#include file="common/_package_common.asp"-->
23
<%
23
<%
24
'------------ ACCESS CONTROL ------------------
24
'------------ ACCESS CONTROL ------------------
25
%>
25
%>
26
<!--#include file="_access_control_general.asp"-->
26
<!--#include file="_access_control_general.asp"-->
27
<%
27
<%
28
'------------ Variable Definition -------------
28
'------------ Variable Definition -------------
29
Dim rsTemp
29
Dim rsTemp
30
Dim	rsQry
30
Dim	rsQry
31
Dim criticalSectionIsEditable
31
Dim criticalSectionIsEditable
32
'------------ Constants Declaration -----------
32
'------------ Constants Declaration -----------
33
'------------ Variable Init -------------------
33
'------------ Variable Init -------------------
34
'----------------------------------------------
34
'----------------------------------------------
35
%>
35
%>
36
<%
36
<%
37
Function Get_Runtime_Dependencies ( NNpv_id )
37
Function Get_Runtime_Dependencies ( NNpv_id )
38
	Get_Runtime_Dependencies = _
38
	Get_Runtime_Dependencies = _
39
	" SELECT rtd.rtd_id, pkg.pkg_name, pv.pkg_version, rtd.rtd_comments, rtd.rtd_url, "&_
39
	" SELECT rtd.rtd_id, pkg.pkg_name, pv.pkg_version, rtd.rtd_comments, rtd.rtd_url, "&_
40
	"       rtd.mod_date, usr.full_name, usr.user_email"&_
40
	"       rtd.mod_date, usr.full_name, usr.user_email"&_
41
	"  FROM packages pkg, package_versions pv, runtime_dependencies rtd, users usr"&_
41
	"  FROM packages pkg, package_versions pv, runtime_dependencies rtd, users usr"&_
42
	" WHERE pv.pkg_id = pkg.pkg_id"&_
42
	" WHERE pv.pkg_id = pkg.pkg_id"&_
43
	"   AND rtd.rtd_id = pv.pv_id"&_
43
	"   AND rtd.rtd_id = pv.pv_id"&_
44
	"   AND rtd.mod_user = usr.user_id"&_
44
	"   AND rtd.mod_user = usr.user_id"&_
45
	"   AND rtd.pv_id = "& NNpv_id &_
45
	"   AND rtd.pv_id = "& NNpv_id &_
46
	" ORDER BY UPPER(pkg.pkg_name) "
46
	" ORDER BY UPPER(pkg.pkg_name) "
47
End Function
47
End Function
48
%>
48
%>
49
 
49
 
50
<%
50
<%
51
'------------------------- MAIN LINE ---------------------------
51
'------------------------- MAIN LINE ---------------------------
52
criticalSectionIsEditable = Is_Critical_Section_Editable ( pkgInfoHash.Item ("dlocked") )
52
criticalSectionIsEditable = Is_Critical_Section_Editable ( pkgInfoHash.Item ("dlocked") )
53
%>
53
%>
54
 
54
 
55
<html>
55
<html>
56
<head>
56
<head>
57
<title><%=Title(Request("rtag_id"))%></title>
57
<title><%=Title(Request("rtag_id"))%></title>
58
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
58
<link rel="shortcut icon" href="<%=FavIcon%>"/>
59
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
59
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
60
<link rel="stylesheet" href="images/release_manager_style.css" type="text/css">
60
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
61
<link rel="stylesheet" href="images/navigation.css" type="text/css">
61
<link rel="stylesheet" href="images/release_manager_style.css" type="text/css">
62
<script language="JavaScript" src="images/common.js"></script>
62
<link rel="stylesheet" href="images/navigation.css" type="text/css">
63
<script language="JavaScript" src="scripts/remote_scripting.js"></script>
63
<script language="JavaScript" src="images/common.js"></script>
64
<!--#include file="_jquery_includes.asp"-->
64
<script language="JavaScript" src="scripts/remote_scripting.js"></script>
65
 
65
<!--#include file="_jquery_includes.asp"-->
66
<!-- DROPDOWN MENUS -->
66
 
67
<!--#include file="_menu_def.asp"-->
67
<!-- DROPDOWN MENUS -->
68
<script language="JavaScript1.2" src="images/popup_menu.js"></script>
68
<!--#include file="_menu_def.asp"-->
69
</head>
69
<script language="JavaScript1.2" src="images/popup_menu.js"></script>
70
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
70
</head>
71
<!-- MENU LAYERS -------------------------------------->
71
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
72
<div id="popmenu" class="menuskin" onMouseover="clearhidemenu();highlightmenu(event,'on')" onMouseout="highlightmenu(event,'off');dynamichide(event)">
72
<!-- MENU LAYERS -------------------------------------->
73
  <!----------------------------------------------------->
73
<div id="popmenu" class="menuskin" onMouseover="clearhidemenu();highlightmenu(event,'on')" onMouseout="highlightmenu(event,'off');dynamichide(event)">
74
</div>
74
  <!----------------------------------------------------->
75
<!-- HEADER -->
75
</div>
76
<!--#include file="_header.asp"-->
76
<!-- HEADER -->
77
<!-- BODY ---->
77
<!--#include file="_header.asp"-->
78
<table width="100%" border="0" cellspacing="0" cellpadding="0">
78
<!-- BODY ---->
79
	<tr>
79
<table width="100%" border="0" cellspacing="0" cellpadding="0">
80
		<td valign="top" width="1" background="images/bg_bage.gif">
80
	<tr>
81
		<!-- LEFT -->
81
		<td valign="top" width="1" background="images/bg_bage.gif">
82
		<!--#include file="_environment.asp"-->
82
		<!-- LEFT -->
83
		</td>
83
		<!--#include file="_environment.asp"-->
84
		<td width="1" bgcolor="#999999"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
84
		</td>
85
		<td valign="top" width="100%">
85
		<td width="1" bgcolor="#999999"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
86
		<!-- MIDDLE -->
86
		<td valign="top" width="100%">
87
		<table width="100%" border="0" cellspacing="0" cellpadding="0">
87
		<!-- MIDDLE -->
88
		  <tr>
88
		<table width="100%" border="0" cellspacing="0" cellpadding="0">
89
		    <td width="1%" background="images/bg_action_norm.gif"><IMG height=35 src="images/spacer.gif" width=15></td>
89
		  <tr>
90
		    <td width="100%" background="images/bg_action_norm.gif"><%Call RenderActionBar(parRtag_id,parPv_id)%></td>
90
		    <td width="1%" background="images/bg_action_norm.gif"><IMG height=35 src="images/spacer.gif" width=15></td>
91
		    <td width="1%" background="images/bg_action_norm.gif"><IMG height=1 src="images/spacer.gif" width=15></td>
91
		    <td width="100%" background="images/bg_action_norm.gif"><%Call RenderActionBar(parRtag_id,parPv_id)%></td>
92
		  </tr>
92
		    <td width="1%" background="images/bg_action_norm.gif"><IMG height=1 src="images/spacer.gif" width=15></td>
93
          <tr>
93
		  </tr>
94
            <td background="images/bg_lght_gray.gif"><IMG height="45" src="images/spacer.gif" width=1></td>
94
          <tr>
95
            <td background="images/bg_lght_gray.gif"><%Call RenderStatus(parRtag_id,parPv_id)%></td>
95
            <td background="images/bg_lght_gray.gif"><IMG height="45" src="images/spacer.gif" width=1></td>
96
            <td background="images/bg_lght_gray.gif">&nbsp;</td>
96
            <td background="images/bg_lght_gray.gif"><%Call RenderStatus(parRtag_id,parPv_id)%></td>
97
          </tr>
97
            <td background="images/bg_lght_gray.gif">&nbsp;</td>
98
		  <tr>
98
          </tr>
99
		    <td background="images/bg_lght_gray.gif">&nbsp;</td>
99
		  <tr>
100
		    <td valign="bottom" background="images/bg_lght_gray.gif">
100
		    <td background="images/bg_lght_gray.gif">&nbsp;</td>
101
		      <table width="100" border="0" cellspacing="0" cellpadding="0">
101
		    <td valign="bottom" background="images/bg_lght_gray.gif">
102
		        <tr>
102
		      <table width="100" border="0" cellspacing="0" cellpadding="0">
103
		          <td><IMG height="1" src="images/spacer.gif" width="0" alt="tab-left-margin" ></td>
103
		        <tr>
104
		          <td>
104
		          <td><IMG height="1" src="images/spacer.gif" width="0" alt="tab-left-margin" ></td>
105
				  <!-- TABS ------------------------------------->
105
		          <td>
106
				  <%Call Generate_Tab_Menu ( TABarray1, "Runtime", "orange" )%>
106
				  <!-- TABS ------------------------------------->
107
				  </td>
107
				  <%Call Generate_Tab_Menu ( TABarray1, "Runtime", "orange" )%>
108
		        </tr>
108
				  </td>
109
		      </table>
109
		        </tr>
110
		    </td>
110
		      </table>
111
		    <td background="images/bg_lght_gray.gif">&nbsp;</td>
111
		    </td>
112
		  </tr>
112
		    <td background="images/bg_lght_gray.gif">&nbsp;</td>
113
		  <tr>
113
		  </tr>
114
		    <td background="images/lbox_bg_orange.gif"><IMG height=35 src="images/spacer.gif" width=1></td>
114
		  <tr>
115
		    <td background="images/lbox_bg_orange.gif">
115
		    <td background="images/lbox_bg_orange.gif"><IMG height=35 src="images/spacer.gif" width=1></td>
116
			<!-- TAB ACTION BUTTONS ------------------------------------->
116
		    <td background="images/lbox_bg_orange.gif">
117
			<%Call Action_Buttons ( "Runtime Dependencies" )%>
117
			<!-- TAB ACTION BUTTONS ------------------------------------->
118
			</td>
118
			<%Call Action_Buttons ( "Runtime Dependencies" )%>
119
		    <td background="images/lbox_bg_orange.gif">&nbsp;</td>
119
			</td>
120
		  </tr>
120
		    <td background="images/lbox_bg_orange.gif">&nbsp;</td>
121
		  <tr>
121
		  </tr>
122
		    <td></td>
122
		  <tr>
123
		    <td valign="top">
123
		    <td></td>
124
			<!-- DETAILS ------------------------------------------------->
124
		    <td valign="top">
125
			<br>
125
			<!-- DETAILS ------------------------------------------------->
126
                        <span class="body_colb">Runtime Dependencies</span><br>
126
			<br>
127
                        <table width="100%" border="0" cellspacing="1" cellpadding="3">
127
                        <span class="body_colb">Runtime Dependencies</span><br>
128
                          <tr>
128
                        <table width="100%" border="0" cellspacing="1" cellpadding="3">
129
                            <td background="images/bg_form_lightbluedark.gif" nowrap width="1%" class="form_field"></td>
129
                          <tr>
130
                            <td background="images/bg_form_lightbluedark.gif" nowrap width="1%" class="form_field">Product&nbsp;&nbsp;</td>
130
                            <td background="images/bg_form_lightbluedark.gif" nowrap width="1%" class="form_field"></td>
131
                            <td background="images/bg_form_lightbluedark.gif" nowrap width="1%" class="form_field">Version&nbsp;&nbsp;</td>
131
                            <td background="images/bg_form_lightbluedark.gif" nowrap width="1%" class="form_field">Product&nbsp;&nbsp;</td>
132
                            <td background="images/bg_form_lightbluedark.gif" nowrap width="100%" class="form_field">Comments</td>
132
                            <td background="images/bg_form_lightbluedark.gif" nowrap width="1%" class="form_field">Version&nbsp;&nbsp;</td>
133
							<td background="images/bg_form_lightbluedark.gif" nowrap width="1%" class="form_field">URL</td>
133
                            <td background="images/bg_form_lightbluedark.gif" nowrap width="100%" class="form_field">Comments</td>
134
							<td background="images/bg_form_lightbluedark.gif" nowrap width="1%" class="form_field" align="center">Added</td>
134
							<td background="images/bg_form_lightbluedark.gif" nowrap width="1%" class="form_field">URL</td>
135
                            <td background="images/bg_form_lightbluedark.gif" nowrap width="1%" class="form_field"></td>
135
							<td background="images/bg_form_lightbluedark.gif" nowrap width="1%" class="form_field" align="center">Added</td>
136
                          </tr>
136
                            <td background="images/bg_form_lightbluedark.gif" nowrap width="1%" class="form_field"></td>
137
                          <%Set rsTemp = OraDatabase.DbCreateDynaset( Get_Runtime_Dependencies ( parPv_id ), cint(0))%>
137
                          </tr>
138
                          <%If rsTemp.RecordCount < 1 Then%>
138
                          <%Set rsTemp = OraDatabase.DbCreateDynaset( Get_Runtime_Dependencies ( parPv_id ), cint(0))%>
139
                          <tr>
139
                          <%If rsTemp.RecordCount < 1 Then%>
140
                            <td background="images/bg_form_lightgray.gif" nowrap>&nbsp;</td>
140
                          <tr>
141
                            <td background="images/bg_form_lightgray.gif" nowrap>&nbsp;</td>
141
                            <td background="images/bg_form_lightgray.gif" nowrap>&nbsp;</td>
142
                            <td background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
142
                            <td background="images/bg_form_lightgray.gif" nowrap>&nbsp;</td>
143
                            <td background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
143
                            <td background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
144
							<td background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
144
                            <td background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
145
							<td background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
145
							<td background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
146
                            <td background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
146
							<td background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
147
                          </tr>
147
                            <td background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
148
                          <%End If%>
148
                          </tr>
149
                          <%While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))%>
149
                          <%End If%>
150
                          <tr>
150
                          <%While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))%>
151
						    <%If (pkgInfoHash.Item("dlocked") = "N") OR (pkgInfoHash.Item("dlocked") = "R") Then%>
151
                          <tr>
152
                            	<td align="center" nowrap background="images/bg_form_lightgray.gif"><a href="javascript:;" onClick="MM_openBrWindow('_wform_update_runtime_dependency.asp?pv_id=<%=parPv_id%>&rtag_id=<%=parRtag_id%>&rtd_id=<%=rsTemp("rtd_id")%>','UpdateRTD','resizable=yes,width=500,height=350')"><img src="images/i_edit.gif" alt="Edit" width="12" height="12" hspace="3" vspace="3" border="0"></a></td>
152
						    <%If (pkgInfoHash.Item("dlocked") = "N") OR (pkgInfoHash.Item("dlocked") = "R") Then%>
153
							<%Else%>
153
                            	<td align="center" nowrap background="images/bg_form_lightgray.gif"><a href="javascript:;" onClick="MM_openBrWindow('_wform_update_runtime_dependency.asp?pv_id=<%=parPv_id%>&rtag_id=<%=parRtag_id%>&rtd_id=<%=rsTemp("rtd_id")%>','UpdateRTD','resizable=yes,width=500,height=350')"><img src="images/i_edit.gif" alt="Edit" width="12" height="12" hspace="3" vspace="3" border="0"></a></td>
154
								<td align="center" nowrap background="images/bg_form_lightgray.gif"><img src="images/i_edit_disable.gif" alt="Edit disabled." width="12" height="12" hspace="3" vspace="3" border="0"></td>
154
							<%Else%>
155
							<%End If%>
155
								<td align="center" nowrap background="images/bg_form_lightgray.gif"><img src="images/i_edit_disable.gif" alt="Edit disabled." width="12" height="12" hspace="3" vspace="3" border="0"></td>
156
                            <td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=rsTemp("pkg_name")%></td>
156
							<%End If%>
157
                            <td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=rsTemp("pkg_version")%></td>
157
                            <td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=rsTemp("pkg_name")%></td>
158
                            <td background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=rsTemp("rtd_comments")%></td>
158
                            <td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=rsTemp("pkg_version")%></td>
159
							<td background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%If NOT IsNull(rsTemp("rtd_url")) Then Response.write "<a href='http://"& rsTemp("rtd_url") &"' target='_blank'><img src='images/i_url.gif' width='15' height='15' hspace='3' vspace='3' border='0' alt='"& rsTemp("rtd_url") &"'></a>"%></td>
159
                            <td background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=rsTemp("rtd_comments")%></td>
160
							<td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=EuroDate(rsTemp("mod_date")) &" by <a href='mailto:"& rsTemp("user_email") &"' class='txt_linked'>"& rsTemp("full_name") &"</a>"%></td>
160
							<td background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%If NOT IsNull(rsTemp("rtd_url")) Then Response.write "<a href='http://"& rsTemp("rtd_url") &"' target='_blank'><img src='images/i_url.gif' width='15' height='15' hspace='3' vspace='3' border='0' alt='"& rsTemp("rtd_url") &"'></a>"%></td>
161
							<%If pkgInfoHash.Item("dlocked") = "N" OR (pkgInfoHash.Item("dlocked") = "R")  Then%>
161
							<td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=EuroDate(rsTemp("mod_date")) &" by <a href='mailto:"& rsTemp("user_email") &"' class='txt_linked'>"& rsTemp("full_name") &"</a>"%></td>
162
                            	<td align="center" background="images/bg_form_lightgray.gif" class="form_item" valign="top"><a href="_remove_runtime_dependency.asp?pv_id=<%=parPv_id%>&rtag_id=<%=parRtag_id%>&rtd_id=<%=rsTemp("rtd_id")%>" onClick="return vixConfirmDelete('this Runtime Dependency');"><img src="images/i_delete.gif" alt="Remove from list." width="13" height="12" hspace="3" border="0"></a></td>
162
							<%If pkgInfoHash.Item("dlocked") = "N" OR (pkgInfoHash.Item("dlocked") = "R")  Then%>
163
							<%Else%>
163
                            	<td align="center" background="images/bg_form_lightgray.gif" class="form_item" valign="top"><a href="_remove_runtime_dependency.asp?pv_id=<%=parPv_id%>&rtag_id=<%=parRtag_id%>&rtd_id=<%=rsTemp("rtd_id")%>" onClick="return vixConfirmDelete('this Runtime Dependency');"><img src="images/i_delete.gif" alt="Remove from list." width="13" height="12" hspace="3" border="0"></a></td>
164
								<td align="center" background="images/bg_form_lightgray.gif" class="form_item" valign="top"><img src="images/i_delete_disable.gif" alt="Remove disabled." width="13" height="12" hspace="3" border="0"></td>
164
							<%Else%>
165
							<%End If%>
165
								<td align="center" background="images/bg_form_lightgray.gif" class="form_item" valign="top"><img src="images/i_delete_disable.gif" alt="Remove disabled." width="13" height="12" hspace="3" border="0"></td>
166
                          </tr>
166
							<%End If%>
167
                          <%rsTemp.MoveNext
167
                          </tr>
168
						  WEnd
168
                          <%rsTemp.MoveNext
169
						  rsTemp.Close
169
						  WEnd
170
						  Set rsTemp = nothing%>
170
						  rsTemp.Close
171
                        </table>
171
						  Set rsTemp = nothing%>
172
                        <!------------------------------------------------------------>
172
                        </table>
173
           <br><br>
173
                        <!------------------------------------------------------------>
174
			<!-- END DETAILS ------------------------------------------------->
174
           <br><br>
175
			</td>
175
			<!-- END DETAILS ------------------------------------------------->
176
		    <td>&nbsp;</td>
176
			</td>
177
		  </tr>
177
		    <td>&nbsp;</td>
178
		</table>
178
		  </tr>
179
		<!-- END MIDDLE -------->
179
		</table>
180
		</td>
180
		<!-- END MIDDLE -------->
181
	</tr>
181
		</td>
182
</table>
182
	</tr>
183
<!-- FOOTER -->
183
</table>
184
<!--#include file="_footer.asp"-->
184
<!-- FOOTER -->
185
</body>
185
<!--#include file="_footer.asp"-->
186
</html>
186
</body>
187
<%
187
</html>
188
Call Destroy_All_Objects
188
<%
189
%>
189
Call Destroy_All_Objects
-
 
190
%>