| Line 28... |
Line 28... |
| 28 |
'Dim parRtag_id
|
28 |
'Dim parRtag_id
|
| 29 |
Dim parRfile
|
29 |
Dim parRfile
|
| 30 |
Dim parView_id
|
30 |
Dim parView_id
|
| 31 |
Dim parBase_view_id
|
31 |
Dim parBase_view_id
|
| 32 |
Dim bPreventSubmit
|
32 |
Dim bPreventSubmit
|
| - |
|
33 |
Dim sMessage
|
| 33 |
'------------ Constants Declaration -----------
|
34 |
'------------ Constants Declaration -----------
|
| 34 |
'------------ Constants Declaration -----------
|
35 |
'------------ Constants Declaration -----------
|
| 35 |
Const imgPkgLocked = "<img src='images/i_locked.gif' width='7' height='10' hspace='4' align='absmiddle'>"
|
36 |
Const imgPkgLocked = "<img src='images/i_locked.gif' width='7' height='10' hspace='4' align='absmiddle'>"
|
| 36 |
Const imgPkgLockSpacer = "<img src='images/spacer.gif' width='7' height='10' hspace='4' align='absmiddle'>"
|
37 |
Const imgPkgLockSpacer = "<img src='images/spacer.gif' width='7' height='10' hspace='4' align='absmiddle'>"
|
| 37 |
'------------ Variable Init -------------------
|
38 |
'------------ Variable Init -------------------
|
| Line 41... |
Line 42... |
| 41 |
parRtag_id = QStrPar("rtag_id")
|
42 |
parRtag_id = QStrPar("rtag_id")
|
| 42 |
parRfile = Request("rfile")
|
43 |
parRfile = Request("rfile")
|
| 43 |
parView_id = QStrPar("view_id")
|
44 |
parView_id = QStrPar("view_id")
|
| 44 |
parBase_view_id = QStrPar("base_view_id")
|
45 |
parBase_view_id = QStrPar("base_view_id")
|
| 45 |
bPreventSubmit = false
|
46 |
bPreventSubmit = false
|
| - |
|
47 |
sMessage = NULL
|
| 46 |
'----------------------------------------------
|
48 |
'----------------------------------------------
|
| 47 |
%>
|
49 |
%>
|
| 48 |
<%
|
50 |
<%
|
| 49 |
Sub Get_Pkg_Information ( NNpv_id)
|
51 |
Sub Get_Pkg_Information ( NNpv_id)
|
| 50 |
Dim rsTemp, Query_String
|
52 |
Dim rsTemp, Query_String
|
| Line 80... |
Line 82... |
| 80 |
OraDatabase.Parameters.Add "RTAG_ID", RtagId, ORAPARM_INPUT, ORATYPE_NUMBER
|
82 |
OraDatabase.Parameters.Add "RTAG_ID", RtagId, ORAPARM_INPUT, ORATYPE_NUMBER
|
| 81 |
OraDatabase.Parameters.Add "PV_ID", pvId, ORAPARM_INPUT, ORATYPE_VARCHAR2
|
83 |
OraDatabase.Parameters.Add "PV_ID", pvId, ORAPARM_INPUT, ORATYPE_VARCHAR2
|
| 82 |
OraDatabase.Parameters.Add "USER_ID", objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER
|
84 |
OraDatabase.Parameters.Add "USER_ID", objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER
|
| 83 |
OraDatabase.Parameters.Add "VIEW_ID", viewId, ORAPARM_INPUT, ORATYPE_NUMBER
|
85 |
OraDatabase.Parameters.Add "VIEW_ID", viewId, ORAPARM_INPUT, ORATYPE_NUMBER
|
| 84 |
|
86 |
|
| - |
|
87 |
objEH.ErrorRedirect = FALSE
|
| - |
|
88 |
On Error Resume Next
|
| 85 |
objEH.TryORA ( OraSession )
|
89 |
objEH.TryORA ( OraSession )
|
| 86 |
|
90 |
|
| 87 |
' check if the package already exists in a pending or wip state
|
- |
|
| 88 |
If PackageExists(RtagId, pvId, "planned") Then
|
- |
|
| 89 |
Call RaiseMsg ( enum_WMSG_ERROR, "Package " & pkgInfoHash.Item ("pkg_name") & " " & pkgInfoHash.Item ("pkg_version") & " already exists in a pending state")
|
- |
|
| 90 |
ElseIf PackageExists(RtagId, pvId, "work_in_progress") Then
|
- |
|
| 91 |
Call RaiseMsg ( enum_WMSG_ERROR, "Package " & pkgInfoHash.Item ("pkg_name") & " " & pkgInfoHash.Item ("pkg_version") & " already exists as a WIP")
|
- |
|
| 92 |
End If
|
- |
|
| 93 |
|
- |
|
| 94 |
OraDatabase.ExecuteSQL _
|
91 |
OraDatabase.ExecuteSQL _
|
| 95 |
"BEGIN PK_PLANNED.REMOVE_PACKAGE ( :PV_ID, :RTAG_ID, :USER_ID ); END;"
|
92 |
"BEGIN PK_PLANNED.REMOVE_PACKAGE ( :PV_ID, :RTAG_ID, :USER_ID ); END;"
|
| 96 |
|
93 |
|
| 97 |
If Err.Number = 0 Then
|
94 |
If Err.Number = 0 Then
|
| 98 |
OraDatabase.ExecuteSQL _
|
95 |
OraDatabase.ExecuteSQL _
|
| 99 |
"BEGIN PK_RELEASE.ADD_PACKAGE ( :PV_ID, :VIEW_ID, :RTAG_ID, :USER_ID ); END;"
|
96 |
"BEGIN PK_RELEASE.ADD_PACKAGE ( :PV_ID, :VIEW_ID, :RTAG_ID, :USER_ID ); END;"
|
| 100 |
End If
|
97 |
End If
|
| Line 123... |
Line 120... |
| 123 |
" AND bv.BASE_VIEW_ID (+) = vi.VIEW_ID "&_
|
120 |
" AND bv.BASE_VIEW_ID (+) = vi.VIEW_ID "&_
|
| 124 |
"ORDER BY vi.view_name ASC"
|
121 |
"ORDER BY vi.view_name ASC"
|
| 125 |
|
122 |
|
| 126 |
End Function
|
123 |
End Function
|
| 127 |
|
124 |
|
| 128 |
%>
|
- |
|
| - |
|
125 |
Call Get_Pkg_Information ( parPv_id)
|
| 129 |
<%
|
126 |
|
| 130 |
'Process submition
|
- |
|
| 131 |
If CBool(QStrPar("action")) AND objAccessControl.UserLogedIn Then
|
127 |
' check if the package already exists in a pending or wip state
|
| 132 |
Call Add_Missing_Dependency(parRtag_id,parPv_id,parView_id)
|
128 |
If PackageExists(parRtag_id,parPv_id, "planned") Then
|
| 133 |
Call OpenInParentWindow ( "dependencies.asp?pv_id="& parPPv_id &"&rtag_id="& parRtag_id )
|
129 |
sMessage = "Package " & pkgInfoHash.Item ("pkg_name") & " " & pkgInfoHash.Item ("pkg_version") & " already exists in a pending state"
|
| 134 |
Call CloseWindow
|
- |
|
| 135 |
|
130 |
|
| - |
|
131 |
ElseIf PackageExists(parRtag_id,parPv_id, "work_in_progress") Then
|
| - |
|
132 |
sMessage = "Package " & pkgInfoHash.Item ("pkg_name") & " " & pkgInfoHash.Item ("pkg_version") & " already exists as a WIP"
|
| - |
|
133 |
|
| - |
|
134 |
ElseIf CBool(QStrPar("action")) AND objAccessControl.UserLogedIn Then
|
| - |
|
135 |
'Process submition
|
| - |
|
136 |
Call Add_Missing_Dependency(parRtag_id,parPv_id,parView_id)
|
| - |
|
137 |
If objEH.Finally Then
|
| - |
|
138 |
Call OpenInParentWindow ( "dependencies.asp?pv_id="& parPPv_id &"&rtag_id="& parRtag_id )
|
| - |
|
139 |
Call CloseWindow
|
| - |
|
140 |
End If
|
| 136 |
End If
|
141 |
End If
|
| 137 |
%>
|
142 |
%>
|
| 138 |
<%
|
- |
|
| 139 |
Call Get_Pkg_Information ( parPv_id)
|
- |
|
| 140 |
%>
|
- |
|
| 141 |
<html>
|
143 |
<html>
|
| 142 |
<head>
|
144 |
<head>
|
| 143 |
<title>Release Manager</title>
|
145 |
<title>Release Manager</title>
|
| 144 |
<link rel="shortcut icon" href="<%=FavIcon%>"/>
|
146 |
<link rel="shortcut icon" href="<%=FavIcon%>"/>
|
| 145 |
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
|
147 |
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
|
| Line 150... |
Line 152... |
| 150 |
<script language="JavaScript" src="images/_help_tips.js"></script>
|
152 |
<script language="JavaScript" src="images/_help_tips.js"></script>
|
| 151 |
<script language="JavaScript" src="images/common.js"></script>
|
153 |
<script language="JavaScript" src="images/common.js"></script>
|
| 152 |
</head>
|
154 |
</head>
|
| 153 |
|
155 |
|
| 154 |
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();">
|
156 |
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();">
|
| 155 |
<form name="addmissingdep" method="post" action="<%=scriptName%>">
|
157 |
<form class="form_tight" name="addmissingdep" method="post" action="<%=scriptName%>">
|
| 156 |
<table width="100%" border="0" cellspacing="0" cellpadding="2" height="100%">
|
158 |
<table width="100%" border="0" cellspacing="0" cellpadding="2">
|
| 157 |
<tr>
|
159 |
<tr>
|
| 158 |
<td background="images/lbox_bg_orange.gif" width="1%" height="1%"><img src="images/i_add_deps.gif" width="22" height="25" hspace="5"></td>
|
- |
|
| 159 |
<td background="images/lbox_bg_blue.gif" nowrap width="50%" class="wform_ttl"> Add Missing Dependency</td>
|
- |
|
| 160 |
<td background="images/lbox_bg_blue.gif" align="right" width="50%">
|
- |
|
| 161 |
<input type="submit" name="btn" value="Add" style="width:50" class="form_btn_comp">
|
- |
|
| 162 |
<input type="reset" name="btn" value="Cancel" style="width:50" class="form_btn_comp" onclick="self.close()">
|
- |
|
| 163 |
</td>
|
- |
|
| 164 |
<td background="images/lbox_bg_blue.gif" align="right" width="1%%" nowrap>
|
- |
|
| 165 |
<img src="images/h_trsp_dot.gif" width="5" height="22">
|
- |
|
| 166 |
</td>
|
- |
|
| 167 |
</tr>
|
- |
|
| 168 |
<tr>
|
- |
|
| 169 |
<td height="100%" width="1%"> </td>
|
- |
|
| 170 |
<td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_form_lightgray.gif">
|
160 |
<td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_form_lightgray.gif">
|
| - |
|
161 |
<!-- LOCAL ERROR +++++++++++++++++++++++++++++++++++++++++++++++ -->
|
| - |
|
162 |
<%Call Messenger ( sMessage , 3, "100%" )%>
|
| - |
|
163 |
<!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->
|
| - |
|
164 |
<!--#include file="messages/_msg_inline.asp"-->
|
| 171 |
<table width="100%" border="0" cellspacing="1" cellpadding="2">
|
165 |
<table width="100%" border="0" cellspacing="1" cellpadding="2">
|
| 172 |
<tr>
|
166 |
<tr>
|
| 173 |
<td width="1%"><img src="images/h_trsp_dot.gif" width="10" height="30"></td>
|
- |
|
| 174 |
<td width="1%" nowrap class="form_group" valign="bottom">Details of Dependency that will be Added:</td>
|
167 |
<td width="1%" nowrap class="form_group" valign="bottom">Details of Dependency that will be Added:</td>
|
| 175 |
<td nowrap width="100%"> </td>
|
168 |
<td nowrap width="100%"> </td>
|
| 176 |
<td nowrap width="100%"> </td>
|
169 |
<td nowrap width="100%"> </td>
|
| 177 |
</tr>
|
170 |
</tr>
|
| 178 |
<tr>
|
171 |
<tr>
|
| 179 |
<td width="1%"> </td>
|
- |
|
| 180 |
<td width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif">Package</td>
|
172 |
<td width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif">Package</td>
|
| 181 |
<td nowrap width="100%" background="images/bg_form_lightbluedark.gif" class="form_txt">
|
173 |
<td nowrap width="100%" background="images/bg_form_lightbluedark.gif" class="form_txt">
|
| 182 |
<%=imgPkgLockSpacer%>
|
174 |
<%=imgPkgLockSpacer%>
|
| 183 |
<%=pkgInfoHash.Item("pkg_name")%>
|
175 |
<%=pkgInfoHash.Item("pkg_name")%>
|
| 184 |
</td>
|
176 |
</td>
|
| 185 |
</tr>
|
177 |
</tr>
|
| 186 |
<tr>
|
178 |
<tr>
|
| 187 |
<td width="1%"> </td>
|
- |
|
| 188 |
<td width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif">Version</td>
|
179 |
<td width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif">Version</td>
|
| 189 |
<td nowrap width="100%" background="images/bg_form_lightbluedark.gif" class="form_txt">
|
180 |
<td nowrap width="100%" background="images/bg_form_lightbluedark.gif" class="form_txt">
|
| 190 |
<%If pkgInfoHash.Item("dlocked") = "Y" Then%><%=imgPkgLocked%><%Else%><%=imgPkgLockSpacer%><%End If%>
|
181 |
<%If pkgInfoHash.Item("dlocked") = "Y" Then%><%=imgPkgLocked%><%Else%><%=imgPkgLockSpacer%><%End If%>
|
| 191 |
<%=pkgInfoHash.Item("pkg_version")%>
|
182 |
<%=pkgInfoHash.Item("pkg_version")%>
|
| 192 |
</td>
|
183 |
</td>
|
| 193 |
</tr>
|
184 |
</tr>
|
| 194 |
<tr>
|
185 |
<tr>
|
| 195 |
<td width="1%"> </td>
|
- |
|
| 196 |
<td width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif">Last Modified</td>
|
186 |
<td width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif">Last Modified</td>
|
| 197 |
<td nowrap width="100%" background="images/bg_form_lightbluedark.gif" class="form_txt">
|
187 |
<td nowrap width="100%" background="images/bg_form_lightbluedark.gif" class="form_txt">
|
| 198 |
<%=imgPkgLockSpacer%>
|
188 |
<%=imgPkgLockSpacer%>
|
| 199 |
<%=EuroDateTime(pkgInfoHash.Item ("modified_stamp")) & " by " & pkgInfoHash.Item ("modifier")%>
|
189 |
<%=EuroDateTime(pkgInfoHash.Item ("modified_stamp")) & " by " & pkgInfoHash.Item ("modifier")%>
|
| 200 |
</td>
|
190 |
</td>
|
| 201 |
</tr>
|
191 |
</tr>
|
| 202 |
<tr>
|
192 |
<tr>
|
| 203 |
<td width="1%"> </td>
|
- |
|
| 204 |
<td width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif">Created</td>
|
193 |
<td width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif">Created</td>
|
| 205 |
<td nowrap width="100%" background="images/bg_form_lightbluedark.gif" class="form_txt">
|
194 |
<td nowrap width="100%" background="images/bg_form_lightbluedark.gif" class="form_txt">
|
| 206 |
<%=imgPkgLockSpacer%>
|
195 |
<%=imgPkgLockSpacer%>
|
| 207 |
<%=EuroDateTime(pkgInfoHash.Item ("created_stamp")) & " by " & pkgInfoHash.Item ("creator")%>
|
196 |
<%=EuroDateTime(pkgInfoHash.Item ("created_stamp")) & " by " & pkgInfoHash.Item ("creator")%>
|
| 208 |
</td>
|
197 |
</td>
|
| 209 |
</tr>
|
198 |
</tr>
|
| 210 |
<tr>
|
199 |
<tr>
|
| 211 |
<td width="1%"><img src="images/h_trsp_dot.gif" width="10" height="30"></td>
|
- |
|
| 212 |
<td width="1%" nowrap class="form_group" valign="bottom">Select Destination View</td>
|
200 |
<td width="1%" nowrap class="form_group" valign="bottom">Select Destination View</td>
|
| 213 |
<td nowrap width="100%"> </td>
|
201 |
<td nowrap width="100%"> </td>
|
| 214 |
</tr>
|
202 |
</tr>
|
| 215 |
<tr>
|
203 |
<tr>
|
| 216 |
<td width="1%"> </td>
|
- |
|
| 217 |
<td width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif" valign=top>Base View</td>
|
204 |
<td width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif" valign=top>Base View</td>
|
| 218 |
<td nowrap width="100%" background="images/bg_form_lightbluedark.gif">
|
205 |
<td nowrap width="100%" background="images/bg_form_lightbluedark.gif">
|
| 219 |
<table border=0 cellpadding=0 cellspacing=0 class="rep_small">
|
206 |
<table border=0 cellpadding=0 cellspacing=0 class="rep_small">
|
| 220 |
<tr>
|
207 |
<tr>
|
| 221 |
<td>
|
208 |
<td>
|
| Line 260... |
Line 247... |
| 260 |
</tr>
|
247 |
</tr>
|
| 261 |
</table>
|
248 |
</table>
|
| 262 |
</td>
|
249 |
</td>
|
| 263 |
</tr>
|
250 |
</tr>
|
| 264 |
<tr>
|
251 |
<tr>
|
| 265 |
<td height="100%" width="1%"> </td>
|
- |
|
| 266 |
<td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_form_lightgray.gif">
|
252 |
<td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_form_lightgray.gif">
|
| 267 |
<table width="100%" border="0" cellspacing="1" cellpadding="2">
|
253 |
<table width="100%" border="0" cellspacing="1" cellpadding="2">
|
| 268 |
<tr>
|
254 |
<tr>
|
| 269 |
<td width="1%" wrap class="form_group" valign="bottom">
|
255 |
<td width="1%" wrap class="form_group" valign="bottom">
|
| 270 |
WARNING:<br>
|
256 |
WARNING:<br>
|
| Line 275... |
Line 261... |
| 275 |
</tr>
|
261 |
</tr>
|
| 276 |
</table>
|
262 |
</table>
|
| 277 |
</td>
|
263 |
</td>
|
| 278 |
</tr>
|
264 |
</tr>
|
| 279 |
<tr>
|
265 |
<tr>
|
| 280 |
<td height="1%" width="1%"><img src="images/h_trsp_dot.gif" width="5" height="5"></td>
|
266 |
<td align="right" width="50%">
|
| - |
|
267 |
<input type="submit" name="btn" value="Add" style="width:50" <%=iif(isNull(sMessage), "", "disabled")%> class="<%=iif(isNull(sMessage), "form_btn_comp", "form_btn_comp_disabled")%>">
|
| 281 |
<td valign="top" nowrap colspan="3" class="wform_ttl" background="images/lbox_bg_blue.gif"></td>
|
268 |
<input type="reset" name="btn" value="Cancel" style="width:50" class="form_btn_comp" onclick="parent.closeIFrame();">
|
| - |
|
269 |
</td>
|
| 282 |
</tr>
|
270 |
</tr>
|
| 283 |
</table>
|
271 |
</table>
|
| 284 |
</form>
|
272 |
</form>
|
| 285 |
<!-- TIPS LAYERS -------------------------------------->
|
273 |
<!-- TIPS LAYERS -------------------------------------->
|
| 286 |
<div id="formTipsLayer" style="position: absolute; z-index: 1000; visibility: hidden; left:0; top: 0; width: 10"> </div>
|
274 |
<div id="formTipsLayer" style="position: absolute; z-index: 1000; visibility: hidden; left:0; top: 0; width: 10"> </div>
|