Subversion Repositories DevTools

Rev

Rev 5506 | Rev 5632 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5506 Rev 5607
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">&nbsp;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%">&nbsp;</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%">&nbsp; </td>
168
                  <td nowrap width="100%">&nbsp; </td>
176
                  <td nowrap width="100%">&nbsp; </td>
169
                  <td nowrap width="100%">&nbsp; </td>
177
               </tr>
170
               </tr>
178
               <tr>
171
               <tr>
179
                  <td width="1%">&nbsp;</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%">&nbsp;</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%">&nbsp;</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%">&nbsp;</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%">&nbsp; </td>
201
                  <td nowrap width="100%">&nbsp; </td>
214
               </tr>
202
               </tr>
215
               <tr> 
203
               <tr> 
216
                 <td width="1%">&nbsp;</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%">&nbsp;</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">&nbsp;</div>
274
<div id="formTipsLayer" style="position: absolute; z-index: 1000; visibility: hidden; left:0; top: 0; width: 10">&nbsp;</div>