Subversion Repositories DevTools

Rev

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

Rev 4216 Rev 5355
Line 1... Line 1...
1
<%@LANGUAGE="VBSCRIPT"%>
1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
2
<%
3
'=====================================================
3
'=====================================================
4
'|                                                   |
4
'|                                                   |
5
'|                 wSyncProducts                     |
5
'|                 wSyncProducts                     |
6
'|                                                   |
6
'|                                                   |
7
'=====================================================
7
'=====================================================
8
%>
8
%>
9
<%
9
<%
10
Option explicit
10
Option explicit
11
Response.Expires = 0
11
Response.Expires = 0
12
%>
12
%>
13
<%
13
<%
14
'To enable the script timeout to 10 mins
14
'To enable the script timeout to 10 mins
15
Server.ScriptTimeout=360
15
Server.ScriptTimeout=360
16
%>
16
%>
17
<!--#include file="common/globals.asp"-->
17
<!--#include file="common/globals.asp"-->
18
<!--#include file="common/config.asp"-->
18
<!--#include file="common/config.asp"-->
19
<!--#include file="common/common_subs.asp"-->
19
<!--#include file="common/common_subs.asp"-->
20
<!--#include file="common/_popup_window_common.asp"-->
20
<!--#include file="common/_popup_window_common.asp"-->
21
<%
21
<%
22
'------------ ACCESS CONTROL ------------------
22
'------------ ACCESS CONTROL ------------------
23
%>
23
%>
24
<!--#include file="_access_control_general.asp"-->
24
<!--#include file="_access_control_general.asp"-->
25
<%
25
<%
26
'------------ VARIABLE DEFINITION -------------
26
'------------ VARIABLE DEFINITION -------------
27
Dim rsQry
27
Dim rsQry
28
Dim aProducts
28
Dim aProducts
29
Dim numOfRows
29
Dim numOfRows
30
Dim rowNum
30
Dim rowNum
31
Dim objFormCollector
31
Dim objFormCollector
32
Dim currPkg_id
32
Dim currPkg_id
33
Dim Query_String
33
Dim Query_String
34
Dim errorMessage
34
Dim errorMessage
35
Dim objList
35
Dim objList
36
Dim objHideList
36
Dim objHideList
37
Dim key
37
Dim key
38
 
38
 
39
'------------ CONSTANTS DECLARATION -----------
39
'------------ CONSTANTS DECLARATION -----------
40
'------------ VARIABLE INIT -------------------
40
'------------ VARIABLE INIT -------------------
41
parBom_id = Request("bom_id")
41
parBom_id = Request("bom_id")
42
Set objFormCollector = CreateObject("Scripting.Dictionary")
42
Set objFormCollector = CreateObject("Scripting.Dictionary")
43
Set objList = CreateObject("Scripting.Dictionary")
43
Set objList = CreateObject("Scripting.Dictionary")
44
Set objHideList = CreateObject("Scripting.Dictionary")
44
Set objHideList = CreateObject("Scripting.Dictionary")
45
 
45
 
46
'------------ CONDITIONS ----------------------
46
'------------ CONDITIONS ----------------------
47
'----------------------------------------------
47
'----------------------------------------------
48
%>
48
%>
49
<%
49
<%
50
'----------------------------------------------------------------------------------------------------------------------------------
50
'----------------------------------------------------------------------------------------------------------------------------------
51
'   Get some basic information required by the form
51
'   Get some basic information required by the form
52
'
52
'
53
Sub GetFormDetails ( nBom_id, ByRef outobjDetails )
53
Sub GetFormDetails ( nBom_id, ByRef outobjDetails )
54
   Dim rsQry, query
54
   Dim rsQry, query
55
   OraDatabase.Parameters.Add "BOM_ID", nBom_id, ORAPARM_INPUT, ORATYPE_NUMBER
55
   OraDatabase.Parameters.Add "BOM_ID", nBom_id, ORAPARM_INPUT, ORATYPE_NUMBER
56
 
56
 
57
   query = _
57
   query = _
58
   "  SELECT rt.RTAG_ID, "&_
58
   "  SELECT rt.RTAG_ID, "&_
59
   "         rt.RTAG_NAME, "&_
59
   "         rt.RTAG_NAME, "&_
60
   "         rt.PRODUCT_STATE_USED "&_
60
   "         rt.PRODUCT_STATE_USED "&_
61
   "    FROM RELEASE_TAGS rt,"&_
61
   "    FROM RELEASE_TAGS rt,"&_
62
   "         BOMS bo"&_
62
   "         BOMS bo"&_
63
   "   WHERE bo.RTAG_ID_FK = rt.RTAG_ID"&_
63
   "   WHERE bo.RTAG_ID_FK = rt.RTAG_ID"&_
64
   "     AND bo.BOM_ID = :BOM_ID"
64
   "     AND bo.BOM_ID = :BOM_ID"
65
 
65
 
66
   Set rsQry = OraDatabase.DbCreateDynaset( query, ORADYN_DEFAULT )
66
   Set rsQry = OraDatabase.DbCreateDynaset( query, ORADYN_DEFAULT )
67
   If (NOT rsQry.BOF) AND (NOT rsQry.EOF)Then
67
   If (NOT rsQry.BOF) AND (NOT rsQry.EOF)Then
68
      outobjDetails.Item ("rtag_id_fk") = rsQry("rtag_id")
68
      outobjDetails.Item ("rtag_id_fk") = rsQry("rtag_id")
69
      outobjDetails.Item ("rtag_name") = rsQry("rtag_name")
69
      outobjDetails.Item ("rtag_name") = rsQry("rtag_name")
70
      outobjDetails.Item ("product_state_used") = rsQry("product_state_used")
70
      outobjDetails.Item ("product_state_used") = rsQry("product_state_used")
71
   End If
71
   End If
72
 
72
 
73
 
73
 
74
   OraDatabase.Parameters.Remove "BOM_ID"
74
   OraDatabase.Parameters.Remove "BOM_ID"
75
 
75
 
76
   rsQry.Close
76
   rsQry.Close
77
   Set rsQry = Nothing
77
   Set rsQry = Nothing
78
End Sub
78
End Sub
79
'----------------------------------------------------------------------------------------------------------------------------------
79
'----------------------------------------------------------------------------------------------------------------------------------
80
Sub UpdateProducts()
80
Sub UpdateProducts()
81
   Dim aDiffList, numOfRows, rowNum, OraParameter
81
   Dim aDiffList, numOfRows, rowNum, OraParameter
82
   Const os_id_column = 2
82
   Const os_id_column = 2
83
   Const old_prod_id_column = 1
83
   Const old_prod_id_column = 1
84
 
84
 
85
   '/* Get Latest From Release Manager */
85
   '/* Get Latest From Release Manager */
86
   OraDatabase.Parameters.Add "BOM_ID",  parBom_id,                           ORAPARM_INPUT, ORATYPE_NUMBER
86
   OraDatabase.Parameters.Add "BOM_ID",  parBom_id,                           ORAPARM_INPUT, ORATYPE_NUMBER
87
   OraDatabase.Parameters.Add "RTAG_ID", objFormCollector.Item("rtag_id_fk"), ORAPARM_INPUT, ORATYPE_NUMBER
87
   OraDatabase.Parameters.Add "RTAG_ID", objFormCollector.Item("rtag_id_fk"), ORAPARM_INPUT, ORATYPE_NUMBER
88
 
88
 
89
 
89
 
90
   Query_String = ReadFile( rootPath & "queries\CompareBomWithLatestFromRM.sql" )
90
   Query_String = ReadFile( rootPath & "queries\CompareBomWithLatestFromRM.sql" )
91
   If objFormCollector.Item ("product_state_used") =  "Y"   Then
91
   If objFormCollector.Item ("product_state_used") =  "Y"   Then
92
      Query_String = Replace( Query_String, "/* AND rc.PRODUCT_STATE = 3 */", " AND rc.PRODUCT_STATE = 3")
92
      Query_String = Replace( Query_String, "/* AND rc.PRODUCT_STATE = 3 */", " AND rc.PRODUCT_STATE = 3")
93
   End If
93
   End If
94
 
94
 
95
   Set rsQry = OraDatabase.DbCreateDynaset( Query_String, ORADYN_DEFAULT )
95
   Set rsQry = OraDatabase.DbCreateDynaset( Query_String, ORADYN_DEFAULT )
96
 
96
 
97
 
97
 
98
   '-- Get Rows
98
   '-- Get Rows
99
   If rsQry.RecordCount > 0 Then
99
   If rsQry.RecordCount > 0 Then
100
      aDiffList = rsQry.GetRows()
100
      aDiffList = rsQry.GetRows()
101
   Else
101
   Else
102
      '-- No differencses with Release Manager, hence exit
102
      '-- No differencses with Release Manager, hence exit
103
      OraDatabase.Parameters.Remove "BOM_ID"
103
      OraDatabase.Parameters.Remove "BOM_ID"
104
      OraDatabase.Parameters.Remove "RTAG_ID"
104
      OraDatabase.Parameters.Remove "RTAG_ID"
105
      Exit Sub
105
      Exit Sub
106
   End If
106
   End If
107
 
107
 
108
   ' Get the project id so we can filter out PopulateSBOMField() for SSW later.
108
   ' Get the project id so we can filter out PopulateSBOMField() for SSW later.
109
   Dim rsProjId, proj_id
109
   Dim rsProjId, proj_id
110
   Set rsProjId = OraDatabase.DbCreateDynaset("SELECT proj_id FROM branches br, boms b WHERE br.branch_id = b.branch_id AND b.bom_id = " & parBom_id, cint(0))
110
   Set rsProjId = OraDatabase.DbCreateDynaset("SELECT proj_id FROM branches br, boms b WHERE br.branch_id = b.branch_id AND b.bom_id = " & parBom_id, cint(0))
111
   proj_id = rsProjId("proj_id")
111
   proj_id = rsProjId("proj_id")
112
   rsProjId.Close()
112
   rsProjId.Close()
113
   Set rsProjId = nothing
113
   Set rsProjId = nothing
114
 
114
 
115
   '/* Update Versions */
115
   '/* Update Versions */
116
 
116
 
117
   OraDatabase.Parameters.Add "OLD_PROD_ID", 0,                       ORAPARM_INPUT, ORATYPE_NUMBER
117
   OraDatabase.Parameters.Add "OLD_PROD_ID", 0,                       ORAPARM_INPUT, ORATYPE_NUMBER
118
   OraDatabase.Parameters.Add "NEW_PROD_ID", 0,                       ORAPARM_INPUT, ORATYPE_NUMBER
118
   OraDatabase.Parameters.Add "NEW_PROD_ID", 0,                       ORAPARM_INPUT, ORATYPE_NUMBER
119
   OraDatabase.Parameters.Add "OS_ID",       0,                       ORAPARM_INPUT, ORATYPE_NUMBER
119
   OraDatabase.Parameters.Add "OS_ID",       0,                       ORAPARM_INPUT, ORATYPE_NUMBER
120
   OraDatabase.Parameters.Add "USER_ID",     objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER
120
   OraDatabase.Parameters.Add "USER_ID",     objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER
121
 
121
 
122
   Set OraParameter = OraDatabase.Parameters
122
   Set OraParameter = OraDatabase.Parameters
123
 
123
 
124
   '    Try the database operations
124
   '    Try the database operations
125
   '    Must have On Error Resume Next in effect in order for the objEH.CatchORA to operate
125
   '    Must have On Error Resume Next in effect in order for the objEH.CatchORA to operate
126
   '
126
   '
127
   objEH.TryORA ( OraSession )
127
   objEH.TryORA ( OraSession )
128
   On Error Resume Next
128
   On Error Resume Next
129
 
129
 
130
   numOfRows = UBound( aDiffList, 2 )
130
   numOfRows = UBound( aDiffList, 2 )
131
 
131
 
132
   For rowNum = 0 To numOfRows
132
   For rowNum = 0 To numOfRows
133
 
133
 
134
      If Request("update_"& aDiffList( os_id_column, rowNum ) &"_"& aDiffList( old_prod_id_column, rowNum ) ) <> "" Then
134
      If Request("update_"& aDiffList( os_id_column, rowNum ) &"_"& aDiffList( old_prod_id_column, rowNum ) ) <> "" Then
135
         OraParameter("OLD_PROD_ID").Value = aDiffList( old_prod_id_column, rowNum )
135
         OraParameter("OLD_PROD_ID").Value = aDiffList( old_prod_id_column, rowNum )
136
         OraParameter("NEW_PROD_ID").Value = Request("update_" & aDiffList( os_id_column, rowNum ) &"_"& aDiffList( old_prod_id_column, rowNum ) )
136
         OraParameter("NEW_PROD_ID").Value = Request("update_" & aDiffList( os_id_column, rowNum ) &"_"& aDiffList( old_prod_id_column, rowNum ) )
137
         OraParameter("OS_ID").Value = aDiffList( os_id_column, rowNum )
137
         OraParameter("OS_ID").Value = aDiffList( os_id_column, rowNum )
138
 
138
 
139
'******************************************************************************
139
'******************************************************************************
140
' This is causing problems for SSW, VTK and SEA and they don't use it, so it
140
' This is causing problems for SSW, VTK and SEA and they don't use it, so it
141
' has been disabled for those projects until a fix is found.
141
' has been disabled for those projects until a fix is found.
142
'******************************************************************************
142
'******************************************************************************
143
         If proj_id <> 421 AND proj_id <> 361 AND proj_id <> 122 AND proj_id <> 164 AND proj_id <> 581 Then
143
         If proj_id <> 421 AND proj_id <> 361 AND proj_id <> 122 AND proj_id <> 164 AND proj_id <> 581 Then
144
            Call PopulateSBOMField(parBom_id, Request("update_"& aDiffList( os_id_column, rowNum ) &"_"& aDiffList( old_prod_id_column, rowNum ) ), NULL, NULL )
144
            Call PopulateSBOMField(parBom_id, Request("update_"& aDiffList( os_id_column, rowNum ) &"_"& aDiffList( old_prod_id_column, rowNum ) ), NULL, NULL )
145
         End If
145
         End If
146
 
146
 
147
         'Response.Write("<script>alert('" &_
147
         'Response.Write("<script>alert('" &_
148
         '                     "OLD_PROD_ID=" & OraParameter("OLD_PROD_ID").Value & "\n" &_
148
         '                     "OLD_PROD_ID=" & OraParameter("OLD_PROD_ID").Value & "\n" &_
149
         '                     "NEW_PROD_ID=" & OraParameter("NEW_PROD_ID").Value & "\n" &_
149
         '                     "NEW_PROD_ID=" & OraParameter("NEW_PROD_ID").Value & "\n" &_
150
         '                     "OS_ID=" & OraParameter("OS_ID").Value & "\n" &_
150
         '                     "OS_ID=" & OraParameter("OS_ID").Value & "\n" &_
151
         '                     "USER_ID=" & OraParameter("USER_ID").Value & "\n" &_
151
         '                     "USER_ID=" & OraParameter("USER_ID").Value & "\n" &_
152
         '                     "rtag_id_fk=" & objFormCollector.Item("rtag_id_fk") & "\n" &_
152
         '                     "rtag_id_fk=" & objFormCollector.Item("rtag_id_fk") & "\n" &_
153
         '                     "update_"& aDiffList( os_id_column, rowNum ) &"_"& aDiffList( old_prod_id_column, rowNum ) &_
153
         '                     "update_"& aDiffList( os_id_column, rowNum ) &"_"& aDiffList( old_prod_id_column, rowNum ) &_
154
         '                     "')</script>")
154
         '                     "')</script>")
155
 
155
 
156
         OraDatabase.ExecuteSQL "BEGIN   pk_Product.Replace_Product ( :OLD_PROD_ID, :NEW_PROD_ID, :OS_ID, :USER_ID );   END;"
156
         OraDatabase.ExecuteSQL "BEGIN   pk_Product.Replace_Product ( :OLD_PROD_ID, :NEW_PROD_ID, :OS_ID, :USER_ID );   END;"
157
      End If
157
      End If
158
   Next
158
   Next
159
 
159
 
160
 
160
 
161
   '--- Log Action ---
161
   '--- Log Action ---
162
   'objEH.LogAction  _
162
   'objEH.LogAction  _
163
   'objAccessControl.UserId, _
163
   'objAccessControl.UserId, _
164
   'enumAT_EVENT_COMMENT, _
164
   'enumAT_EVENT_COMMENT, _
165
   '"Sub UpdateProducts for OS list="& Request("spos_id_list"), _
165
   '"Sub UpdateProducts for OS list="& Request("spos_id_list"), _
166
   'SCRIPT_NAME, _
166
   'SCRIPT_NAME, _
167
   '"Updated Products with new versions.", _
167
   '"Updated Products with new versions.", _
168
   'OraDatabase
168
   'OraDatabase
169
 
169
 
170
 
170
 
171
   objEH.CatchORA ( OraSession )
171
   objEH.CatchORA ( OraSession )
172
 
172
 
173
   OraDatabase.Parameters.Remove "BOM_ID"
173
   OraDatabase.Parameters.Remove "BOM_ID"
174
   OraDatabase.Parameters.Remove "RTAG_ID"
174
   OraDatabase.Parameters.Remove "RTAG_ID"
175
   OraDatabase.Parameters.Remove "OLD_PROD_ID"
175
   OraDatabase.Parameters.Remove "OLD_PROD_ID"
176
   OraDatabase.Parameters.Remove "NEW_PROD_ID"
176
   OraDatabase.Parameters.Remove "NEW_PROD_ID"
177
   OraDatabase.Parameters.Remove "OS_ID"
177
   OraDatabase.Parameters.Remove "OS_ID"
178
   OraDatabase.Parameters.Remove "USER_ID"
178
   OraDatabase.Parameters.Remove "USER_ID"
179
End Sub
179
End Sub
180
'----------------------------------------------------------------------------------------------------------------------------------
180
'----------------------------------------------------------------------------------------------------------------------------------
181
Sub AddPatches()
181
Sub AddPatches()
182
   Dim aDiffList, numOfRows, rowNum, OraParameter
182
   Dim aDiffList, numOfRows, rowNum, OraParameter
183
   Const os_id_column = 2
183
   Const os_id_column = 2
184
   Const prod_id_column = 1
184
   Const prod_id_column = 1
185
 
185
 
186
   '/* Get Lates Release Manager */
186
   '/* Get Lates Release Manager */
187
   OraDatabase.Parameters.Add "BOM_ID", parBom_id,    ORAPARM_INPUT, ORATYPE_NUMBER
187
   OraDatabase.Parameters.Add "BOM_ID", parBom_id,    ORAPARM_INPUT, ORATYPE_NUMBER
188
 
188
 
189
   Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("NewPatches.sql"), ORADYN_DEFAULT )
189
   Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("NewPatches.sql"), ORADYN_DEFAULT )
190
 
190
 
191
 
191
 
192
   '-- Get Rows
192
   '-- Get Rows
193
   If rsQry.RecordCount > 0 Then
193
   If rsQry.RecordCount > 0 Then
194
      aDiffList = rsQry.GetRows()
194
      aDiffList = rsQry.GetRows()
195
 
195
 
196
   Else
196
   Else
197
      '-- No differences with Release Manager, hence exit
197
      '-- No differences with Release Manager, hence exit
198
      OraDatabase.Parameters.Remove "BOM_ID"
198
      OraDatabase.Parameters.Remove "BOM_ID"
199
      Exit Sub
199
      Exit Sub
200
   End If
200
   End If
201
 
201
 
202
 
202
 
203
 
203
 
204
   '/* Update Versions */
204
   '/* Update Versions */
205
   OraDatabase.Parameters.Add "NEW_PROD_ID", 0,                       ORAPARM_INPUT, ORATYPE_NUMBER
205
   OraDatabase.Parameters.Add "NEW_PROD_ID", 0,                       ORAPARM_INPUT, ORATYPE_NUMBER
206
   OraDatabase.Parameters.Add "OS_ID",       0,                       ORAPARM_INPUT, ORATYPE_NUMBER
206
   OraDatabase.Parameters.Add "OS_ID",       0,                       ORAPARM_INPUT, ORATYPE_NUMBER
207
   OraDatabase.Parameters.Add "USER_ID",     objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER
207
   OraDatabase.Parameters.Add "USER_ID",     objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER
208
 
208
 
209
   Set OraParameter = OraDatabase.Parameters
209
   Set OraParameter = OraDatabase.Parameters
210
 
210
 
211
   objEH.TryORA ( OraSession )
211
   objEH.TryORA ( OraSession )
212
   On Error Resume Next
212
   On Error Resume Next
213
 
213
 
214
   numOfRows = UBound( aDiffList, 2 )
214
   numOfRows = UBound( aDiffList, 2 )
215
 
215
 
216
   For rowNum = 0 To numOfRows
216
   For rowNum = 0 To numOfRows
217
 
217
 
218
      If Request("add_"& aDiffList( os_id_column, rowNum ) &"_"& aDiffList( prod_id_column, rowNum ) ) <> "" Then
218
      If Request("add_"& aDiffList( os_id_column, rowNum ) &"_"& aDiffList( prod_id_column, rowNum ) ) <> "" Then
219
         OraParameter("NEW_PROD_ID").Value = Request("add_"& aDiffList( os_id_column, rowNum ) &"_"& aDiffList( prod_id_column, rowNum ) )
219
         OraParameter("NEW_PROD_ID").Value = Request("add_"& aDiffList( os_id_column, rowNum ) &"_"& aDiffList( prod_id_column, rowNum ) )
220
         OraParameter("OS_ID").Value = aDiffList( os_id_column, rowNum )
220
         OraParameter("OS_ID").Value = aDiffList( os_id_column, rowNum )
221
 
221
 
222
         OraDatabase.ExecuteSQL "BEGIN   pk_Product.Add_Product ( :NEW_PROD_ID, :OS_ID, :USER_ID );   END;"
222
         OraDatabase.ExecuteSQL "BEGIN   pk_Product.Add_Product ( :NEW_PROD_ID, :OS_ID, :USER_ID );   END;"
223
      End If
223
      End If
224
 
224
 
225
   Next
225
   Next
226
 
226
 
227
   objEH.CatchORA ( OraSession )
227
   objEH.CatchORA ( OraSession )
228
 
228
 
229
   OraDatabase.Parameters.Remove "BOM_ID"
229
   OraDatabase.Parameters.Remove "BOM_ID"
230
   OraDatabase.Parameters.Remove "NEW_PROD_ID"
230
   OraDatabase.Parameters.Remove "NEW_PROD_ID"
231
   OraDatabase.Parameters.Remove "OS_ID"
231
   OraDatabase.Parameters.Remove "OS_ID"
232
   OraDatabase.Parameters.Remove "USER_ID"
232
   OraDatabase.Parameters.Remove "USER_ID"
233
End Sub
233
End Sub
234
'----------------------------------------------------------------------------------------------------------------------------------
234
'----------------------------------------------------------------------------------------------------------------------------------
235
Sub HideProducts()
235
Sub HideProducts()
236
   Dim aDiffList, numOfRows, rowNum, OraParameter
236
   Dim aDiffList, numOfRows, rowNum, OraParameter
237
   Const os_id_column = 2
237
   Const os_id_column = 2
238
   Const old_prod_id_column = 1
238
   Const old_prod_id_column = 1
239
 
239
 
240
   '/* Get Latest from Release Manager */
240
   '/* Get Latest from Release Manager */
241
   OraDatabase.Parameters.Add "BOM_ID",  parBom_id,                           ORAPARM_INPUT, ORATYPE_NUMBER
241
   OraDatabase.Parameters.Add "BOM_ID",  parBom_id,                           ORAPARM_INPUT, ORATYPE_NUMBER
242
   OraDatabase.Parameters.Add "RTAG_ID", objFormCollector.Item("rtag_id_fk"), ORAPARM_INPUT, ORATYPE_NUMBER
242
   OraDatabase.Parameters.Add "RTAG_ID", objFormCollector.Item("rtag_id_fk"), ORAPARM_INPUT, ORATYPE_NUMBER
243
 
243
 
244
   Query_String = ReadFile( rootPath & "queries\CompareBomWithLatestFromRM.sql" )
244
   Query_String = ReadFile( rootPath & "queries\CompareBomWithLatestFromRM.sql" )
245
   If objFormCollector.Item ("product_state_used") =  "Y"   Then
245
   If objFormCollector.Item ("product_state_used") =  "Y"   Then
246
      Query_String = Replace( Query_String, "/* AND rc.PRODUCT_STATE IN (3, 5) */", " AND rc.PRODUCT_STATE IN (3, 5)")
246
      Query_String = Replace( Query_String, "/* AND rc.PRODUCT_STATE IN (3, 5) */", " AND rc.PRODUCT_STATE IN (3, 5)")
247
   End   If
247
   End   If
248
 
248
 
249
   Set rsQry = OraDatabase.DbCreateDynaset( Query_String, ORADYN_DEFAULT )
249
   Set rsQry = OraDatabase.DbCreateDynaset( Query_String, ORADYN_DEFAULT )
250
 
250
 
251
   '-- Get Rows
251
   '-- Get Rows
252
   If rsQry.RecordCount > 0 Then
252
   If rsQry.RecordCount > 0 Then
253
      aDiffList = rsQry.GetRows()
253
      aDiffList = rsQry.GetRows()
254
 
254
 
255
   Else
255
   Else
256
      '-- No differences with Release Manager, hence exit
256
      '-- No differences with Release Manager, hence exit
257
      OraDatabase.Parameters.Remove "BOM_ID"
257
      OraDatabase.Parameters.Remove "BOM_ID"
258
      OraDatabase.Parameters.Remove "RTAG_ID"
258
      OraDatabase.Parameters.Remove "RTAG_ID"
259
      Exit Sub
259
      Exit Sub
260
 
260
 
261
   End If
261
   End If
262
 
262
 
263
   '/* Hide Versions */
263
   '/* Hide Versions */
264
   OraDatabase.Parameters.Add "NEW_PROD_ID", 0,                       ORAPARM_INPUT, ORATYPE_NUMBER
264
   OraDatabase.Parameters.Add "NEW_PROD_ID", 0,                       ORAPARM_INPUT, ORATYPE_NUMBER
265
   OraDatabase.Parameters.Add "OS_ID",       0,                       ORAPARM_INPUT, ORATYPE_NUMBER
265
   OraDatabase.Parameters.Add "OS_ID",       0,                       ORAPARM_INPUT, ORATYPE_NUMBER
266
   OraDatabase.Parameters.Add "USER_ID",     objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER
266
   OraDatabase.Parameters.Add "USER_ID",     objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER
267
 
267
 
268
   Set OraParameter = OraDatabase.Parameters
268
   Set OraParameter = OraDatabase.Parameters
269
 
269
 
270
   On Error Resume Next
270
   On Error Resume Next
271
   objEH.TryORA ( OraSession )
271
   objEH.TryORA ( OraSession )
272
 
272
 
273
   numOfRows = UBound( aDiffList, 2 )
273
   numOfRows = UBound( aDiffList, 2 )
274
 
274
 
275
   For rowNum = 0 To numOfRows
275
   For rowNum = 0 To numOfRows
276
      If Request("hide_"& aDiffList( os_id_column, rowNum ) &"_"& aDiffList( old_prod_id_column, rowNum ) ) <> "" Then
276
      If Request("hide_"& aDiffList( os_id_column, rowNum ) &"_"& aDiffList( old_prod_id_column, rowNum ) ) <> "" Then
277
         OraParameter("NEW_PROD_ID").Value = Request("hide_"& aDiffList( os_id_column, rowNum ) &"_"& aDiffList( old_prod_id_column, rowNum ) )
277
         OraParameter("NEW_PROD_ID").Value = Request("hide_"& aDiffList( os_id_column, rowNum ) &"_"& aDiffList( old_prod_id_column, rowNum ) )
278
         OraParameter("OS_ID").Value = aDiffList( os_id_column, rowNum )
278
         OraParameter("OS_ID").Value = aDiffList( os_id_column, rowNum )
279
 
279
 
280
         OraDatabase.ExecuteSQL "BEGIN   pk_Product.Hide_Product ( :NEW_PROD_ID, :OS_ID, :USER_ID );   END;"
280
         OraDatabase.ExecuteSQL "BEGIN   pk_Product.Hide_Product ( :NEW_PROD_ID, :OS_ID, :USER_ID );   END;"
281
      End If
281
      End If
282
   Next
282
   Next
283
 
283
 
284
   '--- Log Action ---
284
   '--- Log Action ---
285
   'objEH.LogAction  _
285
   'objEH.LogAction  _
286
   'objAccessControl.UserId, _
286
   'objAccessControl.UserId, _
287
   'enumAT_EVENT_COMMENT, _
287
   'enumAT_EVENT_COMMENT, _
288
   '"Sub UpdateProducts for OS list="& Request("spos_id_list"), _
288
   '"Sub UpdateProducts for OS list="& Request("spos_id_list"), _
289
   'SCRIPT_NAME, _
289
   'SCRIPT_NAME, _
290
   '"Updated Products with new versions.", _
290
   '"Updated Products with new versions.", _
291
   'OraDatabase
291
   'OraDatabase
292
 
292
 
293
   objEH.CatchORA ( OraSession )
293
   objEH.CatchORA ( OraSession )
294
 
294
 
295
   OraDatabase.Parameters.Remove "BOM_ID"
295
   OraDatabase.Parameters.Remove "BOM_ID"
296
   OraDatabase.Parameters.Remove "RTAG_ID"
296
   OraDatabase.Parameters.Remove "RTAG_ID"
297
   OraDatabase.Parameters.Remove "OLD_PROD_ID"
297
   OraDatabase.Parameters.Remove "OLD_PROD_ID"
298
   OraDatabase.Parameters.Remove "NEW_PROD_ID"
298
   OraDatabase.Parameters.Remove "NEW_PROD_ID"
299
   OraDatabase.Parameters.Remove "OS_ID"
299
   OraDatabase.Parameters.Remove "OS_ID"
300
   OraDatabase.Parameters.Remove "USER_ID"
300
   OraDatabase.Parameters.Remove "USER_ID"
301
End Sub
301
End Sub
302
'----------------------------------------------------------------------------------------------------------------------------------
302
'----------------------------------------------------------------------------------------------------------------------------------
303
Sub HidePatches()
303
Sub HidePatches()
304
   Dim aDiffList, numOfRows, rowNum, OraParameter
304
   Dim aDiffList, numOfRows, rowNum, OraParameter
305
   Const os_id_column = 2
305
   Const os_id_column = 2
306
   Const prod_id_column = 1
306
   Const prod_id_column = 1
307
 
307
 
308
   '/* Get Latest from Release Manager */
308
   '/* Get Latest from Release Manager */
309
   OraDatabase.Parameters.Add "BOM_ID", parBom_id,    ORAPARM_INPUT, ORATYPE_NUMBER
309
   OraDatabase.Parameters.Add "BOM_ID", parBom_id,    ORAPARM_INPUT, ORATYPE_NUMBER
310
 
310
 
311
   Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("NewPatches.sql"), ORADYN_DEFAULT )
311
   Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("NewPatches.sql"), ORADYN_DEFAULT )
312
 
312
 
313
   '-- Get Rows
313
   '-- Get Rows
314
   If rsQry.RecordCount > 0 Then
314
   If rsQry.RecordCount > 0 Then
315
      aDiffList = rsQry.GetRows()
315
      aDiffList = rsQry.GetRows()
316
 
316
 
317
   Else
317
   Else
318
      '-- No differencses with Release Manager, hence exit
318
      '-- No differencses with Release Manager, hence exit
319
      OraDatabase.Parameters.Remove "BOM_ID"
319
      OraDatabase.Parameters.Remove "BOM_ID"
320
      Exit Sub
320
      Exit Sub
321
   End If
321
   End If
322
 
322
 
323
 
323
 
324
 
324
 
325
   '/* Hide Versions */
325
   '/* Hide Versions */
326
   OraDatabase.Parameters.Add "NEW_PROD_ID", 0,                       ORAPARM_INPUT, ORATYPE_NUMBER
326
   OraDatabase.Parameters.Add "NEW_PROD_ID", 0,                       ORAPARM_INPUT, ORATYPE_NUMBER
327
   OraDatabase.Parameters.Add "OS_ID",       0,                       ORAPARM_INPUT, ORATYPE_NUMBER
327
   OraDatabase.Parameters.Add "OS_ID",       0,                       ORAPARM_INPUT, ORATYPE_NUMBER
328
   OraDatabase.Parameters.Add "USER_ID",     objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER
328
   OraDatabase.Parameters.Add "USER_ID",     objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER
329
 
329
 
330
   Set OraParameter = OraDatabase.Parameters
330
   Set OraParameter = OraDatabase.Parameters
331
 
331
 
332
   objEH.TryORA ( OraSession )
332
   objEH.TryORA ( OraSession )
333
   On Error Resume Next
333
   On Error Resume Next
334
 
334
 
335
   numOfRows = UBound( aDiffList, 2 )
335
   numOfRows = UBound( aDiffList, 2 )
336
 
336
 
337
   For rowNum = 0 To numOfRows
337
   For rowNum = 0 To numOfRows
338
      If Request("hide_"& aDiffList( os_id_column, rowNum ) &"_"& aDiffList( prod_id_column, rowNum ) ) <> "" Then
338
      If Request("hide_"& aDiffList( os_id_column, rowNum ) &"_"& aDiffList( prod_id_column, rowNum ) ) <> "" Then
339
         OraParameter("NEW_PROD_ID").Value = Request("hide_"& aDiffList( os_id_column, rowNum ) &"_"& aDiffList( prod_id_column, rowNum ) )
339
         OraParameter("NEW_PROD_ID").Value = Request("hide_"& aDiffList( os_id_column, rowNum ) &"_"& aDiffList( prod_id_column, rowNum ) )
340
         OraParameter("OS_ID").Value = aDiffList( os_id_column, rowNum )
340
         OraParameter("OS_ID").Value = aDiffList( os_id_column, rowNum )
341
 
341
 
342
         OraDatabase.ExecuteSQL "BEGIN   pk_Product.Hide_Product ( :NEW_PROD_ID, :OS_ID, :USER_ID );   END;"
342
         OraDatabase.ExecuteSQL "BEGIN   pk_Product.Hide_Product ( :NEW_PROD_ID, :OS_ID, :USER_ID );   END;"
343
      End If
343
      End If
344
   Next
344
   Next
345
 
345
 
346
   objEH.CatchORA ( OraSession )
346
   objEH.CatchORA ( OraSession )
347
 
347
 
348
   OraDatabase.Parameters.Remove "BOM_ID"
348
   OraDatabase.Parameters.Remove "BOM_ID"
349
   OraDatabase.Parameters.Remove "NEW_PROD_ID"
349
   OraDatabase.Parameters.Remove "NEW_PROD_ID"
350
   OraDatabase.Parameters.Remove "OS_ID"
350
   OraDatabase.Parameters.Remove "OS_ID"
351
   OraDatabase.Parameters.Remove "USER_ID"
351
   OraDatabase.Parameters.Remove "USER_ID"
352
End Sub
352
End Sub
353
'----------------------------------------------------------------------------------------------------------------------------------
353
'----------------------------------------------------------------------------------------------------------------------------------
354
%>
354
%>
355
<%
355
<%
356
'------------ RUN BEFORE PAGE RENDER ----------
356
'------------ RUN BEFORE PAGE RENDER ----------
357
Call GetFormDetails ( parBom_id, objFormCollector )
357
Call GetFormDetails ( parBom_id, objFormCollector )
358
 
358
 
359
If Request("action") <> "" Then
359
If Request("action") <> "" Then
360
   ' -- Need to provide some level of validation
360
   ' -- Need to provide some level of validation
361
   '    Cannot handle multiple updates to the same package
361
   '    Cannot handle multiple updates to the same package
362
   '    These can be detected by examining all the Update requests that have badly formed values
362
   '    These can be detected by examining all the Update requests that have badly formed values
363
    Dim Item
363
    Dim Item
364
        For Each Item In Request.Form
364
        For Each Item In Request.Form
365
        If InStr(1, Item, "update_" , 1) = 1 Then
365
        If InStr(1, Item, "update_" , 1) = 1 Then
366
            If InStr( 1, Request.Form(Item), ",", 1) <> 0 Then
366
            If InStr( 1, Request.Form(Item), ",", 1) <> 0 Then
367
                errorMessage = "The selected set of packages to be updated is incorrect<br>" &_
367
                errorMessage = "The selected set of packages to be updated is incorrect<br>" &_
368
                               "The selection attempts to update a target package with more than one version of a package"
368
                               "The selection attempts to update a target package with more than one version of a package"
369
                Exit For
369
                Exit For
370
            End If
370
            End If
371
        End If
371
        End If
372
    Next
372
    Next
373
 
373
 
374
    ' --- Form is Valid ---
374
    ' --- Form is Valid ---
375
    If isEmpty(errorMessage) Then
375
    If isEmpty(errorMessage) Then
376
       Call UpdateProducts()
376
       Call UpdateProducts()
377
 
377
 
378
       Call AddPatches()
378
       Call AddPatches()
379
 
379
 
380
       Call HideProducts()
380
       Call HideProducts()
381
 
381
 
382
       Call HidePatches()
382
       Call HidePatches()
383
 
383
 
384
       If objEH.Finally Then
384
       If objEH.Finally Then
385
          Call OpenInParentWindow ("Bom_Home.asp?UPDATED=OK"& objPMod.ComposeURLWithout("rfile") )
385
          Call OpenInParentWindow ("Bom_Home.asp?UPDATED=OK"& objPMod.ComposeURLWithout("rfile") )
386
          Call CloseWindow()
386
          Call CloseWindow()
387
       End If
387
       End If
388
    Else
388
    Else
389
    Response.Write ("WTF")
389
    Response.Write ("WTF")
390
    End If
390
    End If
391
End If
391
End If
392
 
392
 
393
'----------------------------------------------
393
'----------------------------------------------
394
%>
394
%>
395
 
395
 
396
 
396
 
397
<html>
397
<html>
398
<head>
398
<head>
399
<SCRIPT LANGUAGE="JavaScript">
399
<SCRIPT LANGUAGE="JavaScript">
400
<!-- Begin
400
<!-- Begin
401
 
401
 
402
var checkflag = "false";
402
var checkflag = "false";
403
 
403
 
404
function check(field) {
404
function check(field) {
405
   if (checkflag == "false") {
405
   if (checkflag == "false") {
406
      for (i = 0; i < field.length; i++) {
406
      for (i = 0; i < field.length; i++) {
407
         field[i].checked = true;
407
         field[i].checked = true;
408
      }
408
      }
409
      checkflag = "true";
409
      checkflag = "true";
410
      return "Uncheck all";
410
      return "Uncheck all";
411
   }
411
   }
412
   else {
412
   else {
413
      for (i = 0; i < field.length; i++) {
413
      for (i = 0; i < field.length; i++) {
414
         field[i].checked = false;
414
         field[i].checked = false;
415
      }
415
      }
416
      checkflag = "false";
416
      checkflag = "false";
417
      return "Check all";
417
      return "Check all";
418
   }
418
   }
419
}
419
}
420
//  End -->
420
//  End -->
421
</script>
421
</script>
422
<script language="javascript">
422
<script language="javascript">
423
 
423
 
424
function checkAllHide()
424
function checkAllHide()
425
{
425
{
426
   var args = arguments;
426
   var args = arguments;
427
   start_point:
427
   start_point:
428
   for (var i=0;i<document.forms[0].elements.length;i++) {
428
   for (var i=0;i<document.forms[0].elements.length;i++) {
429
      found = false;
429
      found = false;
430
      var e=document.forms[0].elements[i];
430
      var e=document.forms[0].elements[i];
431
      if ((e.name != 'checkall') && (e.type=='checkbox')) {
431
      if ((e.name != 'checkall') && (e.type=='checkbox')) {
432
         for (var j = 0; j < args.length; j++)
432
         for (var j = 0; j < args.length; j++)
433
            if (args[j] == e.name) {
433
            if (args[j] == e.name) {
434
               e.checked=document.forms[0].checkallhide.checked;
434
               e.checked=document.forms[0].checkallhide.checked;
435
            }
435
            }
436
      }
436
      }
437
   }
437
   }
438
}
438
}
439
 
439
 
440
function checkAllAdd()
440
function checkAllAdd()
441
{
441
{
442
   var args = arguments;
442
   var args = arguments;
443
   start_point:
443
   start_point:
444
   for (var i=0;i<document.forms[0].elements.length;i++) {
444
   for (var i=0;i<document.forms[0].elements.length;i++) {
445
 
445
 
446
      found = false;
446
      found = false;
447
      var e=document.forms[0].elements[i];
447
      var e=document.forms[0].elements[i];
448
 
448
 
449
      if ((e.name != 'checkall') && (e.type=='checkbox')) {
449
      if ((e.name != 'checkall') && (e.type=='checkbox')) {
450
         for (var j = 0; j < args.length; j++)
450
         for (var j = 0; j < args.length; j++)
451
            if (args[j] == e.name) {
451
            if (args[j] == e.name) {
452
               e.checked=document.forms[0].checkalladd.checked;
452
               e.checked=document.forms[0].checkalladd.checked;
453
            }
453
            }
454
      }
454
      }
455
   }
455
   }
456
}
456
}
457
 
457
 
458
// Checks all checkboxes whose name begins with any strings listed as args to the function.
458
// Checks all checkboxes whose name begins with any strings listed as args to the function.
459
function checkAllBeforeSubmit()
459
function checkAllBeforeSubmit()
460
{
460
{
461
   var args = arguments;
461
   var args = arguments;
462
   start_point:
462
   start_point:
463
 
463
 
464
   for (var i=0;i<document.forms[0].elements.length;i++) {
464
   for (var i=0;i<document.forms[0].elements.length;i++) {
465
 
465
 
466
      var e=document.forms[0].elements[i];
466
      var e=document.forms[0].elements[i];
467
 
467
 
468
      if (e.type=='checkbox') {
468
      if (e.type=='checkbox') {
469
         for (var j = 0; j < args.length; j++)
469
         for (var j = 0; j < args.length; j++)
470
            if (e.name.indexOf(args[j]) == 0) {
470
            if (e.name.indexOf(args[j]) == 0) {
471
               e.checked=true;
471
               e.checked=true;
472
            }
472
            }
473
      }
473
      }
474
   }
474
   }
475
   return true;
475
   return true;
476
}
476
}
477
 
477
 
478
</script>
478
</script>
479
 
479
 
480
 
480
 
481
<title>Deployment Manager</title>
481
<title>Deployment Manager</title>
482
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
482
<link rel="shortcut icon" href="<%=FavIcon%>"/>
483
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
483
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
484
<link href="scripts/deployment_manager.css" rel="stylesheet" type="text/css">
484
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
485
<script language="JavaScript" src="scripts/common.js"></script>
485
<link href="scripts/deployment_manager.css" rel="stylesheet" type="text/css">
486
<style type="text/css">
486
<script language="JavaScript" src="scripts/common.js"></script>
487
<!--
487
<style type="text/css">
488
.style8 {font-size: 12px}
488
<!--
489
-->
489
.style8 {font-size: 12px}
490
</style>
490
-->
491
</head>
491
</style>
492
 
492
</head>
493
<body background="images/bg_bage_0.gif" leftmargin="0" topmargin="0" onLoad="self.focus();">
493
 
494
<table width="100%"  border="0" cellspacing="0" cellpadding="10">
494
<body background="images/bg_bage_0.gif" leftmargin="0" topmargin="0" onLoad="self.focus();">
495
   <tr>
495
<table width="100%"  border="0" cellspacing="0" cellpadding="10">
496
      <td bgcolor="#FFFFFF" class="body_txt"><span class="body_h1"><img src="icons/i_linkarrow_black.gif" width="11" height="11" align="absmiddle">&nbsp;Update Products </span> <br>
496
   <tr>
497
         Update Products, selecting the latest from "Release Manager".
497
      <td bgcolor="#FFFFFF" class="body_txt"><span class="body_h1"><img src="icons/i_linkarrow_black.gif" width="11" height="11" align="absmiddle">&nbsp;Update Products </span> <br>
498
      </td>
498
         Update Products, selecting the latest from "Release Manager".
499
   </tr>
499
      </td>
500
   <%
500
   </tr>
501
   '-- FROM START --------------------------------------------------------------------------------------------------------------
501
   <%
502
   objFormComponent.FormName = "FormName"
502
   '-- FROM START --------------------------------------------------------------------------------------------------------------
503
   objFormComponent.Action = SCRIPT_NAME
503
   objFormComponent.FormName = "FormName"
504
   objFormComponent.OnSubmit = "ShowProgress();"
504
   objFormComponent.Action = SCRIPT_NAME
505
   Call objFormComponent.FormStart()
505
   objFormComponent.OnSubmit = "ShowProgress();"
506
   %>
506
   Call objFormComponent.FormStart()
507
   <tr>
507
   %>
508
      <td background="images/bg_login.gif">
508
   <tr>
509
         <table width="100%"  border="0" cellspacing="0" cellpadding="0">
509
      <td background="images/bg_login.gif">
510
            <tr>
510
         <table width="100%"  border="0" cellspacing="0" cellpadding="0">
511
               <td><%=ProgressBar()%>
511
            <tr>
512
                  <input name="btn" type="submit" class="form_btn" value="Update Selected">
512
               <td><%=ProgressBar()%>
513
                  <input name="btn" type="submit" class="form_btn" value="Update All" onClick="checkAllBeforeSubmit('add_','update_');" >
513
                  <input name="btn" type="submit" class="form_btn" value="Update Selected">
514
                  <input name="btn" type="reset" class="form_btn" value="Cancel" onClick="self.close();">
514
                  <input name="btn" type="submit" class="form_btn" value="Update All" onClick="checkAllBeforeSubmit('add_','update_');" >
515
               </td>
515
                  <input name="btn" type="reset" class="form_btn" value="Cancel" onClick="self.close();">
516
               <td align="left">&nbsp;
516
               </td>
517
               </td>
517
               <td align="left">&nbsp;
518
            </tr>
518
               </td>
519
         </table>
519
            </tr>
520
      </td>
520
         </table>
521
   </tr>
521
      </td>
522
   <tr>
522
   </tr>
523
      <td>
523
   <tr>
524
         <!-- PRODUCT NAME RESULTS ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
524
      <td>
525
         <table width="100%"  border="0" cellspacing="10" cellpadding="0">
525
         <!-- PRODUCT NAME RESULTS ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
526
            <tr>
526
         <table width="100%"  border="0" cellspacing="10" cellpadding="0">
527
               <td width="100%" valign="top" nowrap class="body_txt">
527
            <tr>
528
                  <!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->
528
               <td width="100%" valign="top" nowrap class="body_txt">
529
                  <!--#include file="messages/_msg_inline.asp"-->
529
                  <!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->
530
                  <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
530
                  <!--#include file="messages/_msg_inline.asp"-->
531
                  <%
531
                  <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
532
                  If objFormCollector.Item("rtag_id_fk") = "" Then
532
                  <%
533
                     Call Messenger ( "This BOM does not have Release Manager Reference release.<br>Please edit BOM properties first.<br>", 1, "100%" )
533
                  If objFormCollector.Item("rtag_id_fk") = "" Then
534
                  End If
534
                     Call Messenger ( "This BOM does not have Release Manager Reference release.<br>Please edit BOM properties first.<br>", 1, "100%" )
535
                  If NOT isEmpty(errorMessage) Then
535
                  End If
536
                    Call Messenger ( errorMessage, 1, "100%" )
536
                  If NOT isEmpty(errorMessage) Then
537
                  End If
537
                    Call Messenger ( errorMessage, 1, "100%" )
538
                  %>
538
                  End If
539
                  <!-- UPDATE PRODUCTS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
539
                  %>
540
                  Select Products and click Update.
540
                  <!-- UPDATE PRODUCTS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
541
                  <table width="100%"  border="0" cellspacing="3" cellpadding="0">
541
                  Select Products and click Update.
542
                     <tr>
542
                  <table width="100%"  border="0" cellspacing="3" cellpadding="0">
543
                        <td width="1%" nowrap background="images/bg_bage_0h.gif" class="body_col">Update</td>
543
                     <tr>
544
                        <td width="1%" nowrap background="images/bg_bage_0h.gif" class="body_col"></td>
544
                        <td width="1%" nowrap background="images/bg_bage_0h.gif" class="body_col">Update</td>
545
                        <td width="40%" align="right" nowrap background="images/bg_bage_0h.gif" class="body_col"><div align="left">Location</div></td>
545
                        <td width="1%" nowrap background="images/bg_bage_0h.gif" class="body_col"></td>
546
                        <td width="20%" align="right" nowrap background="images/bg_bage_0h.gif" class="body_col"><div align="left">Version</div></td>
546
                        <td width="40%" align="right" nowrap background="images/bg_bage_0h.gif" class="body_col"><div align="left">Location</div></td>
547
                        <td align="right" background="images/bg_bage_0h.gif" class="body_col"><div align="center">Hide</div></td>
547
                        <td width="20%" align="right" nowrap background="images/bg_bage_0h.gif" class="body_col"><div align="left">Version</div></td>
548
                        <td align="right" background="images/bg_bage_0h.gif" class="body_col"><div align="left"><img src="images/spacer.gif" width="1" height="18" align="absmiddle">Latest</div>                <div align="left"></div></td>
548
                        <td align="right" background="images/bg_bage_0h.gif" class="body_col"><div align="center">Hide</div></td>
549
                     </tr>
549
                        <td align="right" background="images/bg_bage_0h.gif" class="body_col"><div align="left"><img src="images/spacer.gif" width="1" height="18" align="absmiddle">Latest</div>                <div align="left"></div></td>
550
                     <%
550
                     </tr>
551
                     OraDatabase.Parameters.Add "BOM_ID", parBom_id,    ORAPARM_INPUT, ORATYPE_NUMBER
551
                     <%
552
                     OraDatabase.Parameters.Add "RTAG_ID", objFormCollector.Item("rtag_id_fk"),    ORAPARM_INPUT, ORATYPE_NUMBER
552
                     OraDatabase.Parameters.Add "BOM_ID", parBom_id,    ORAPARM_INPUT, ORATYPE_NUMBER
553
 
553
                     OraDatabase.Parameters.Add "RTAG_ID", objFormCollector.Item("rtag_id_fk"),    ORAPARM_INPUT, ORATYPE_NUMBER
554
                     Query_String = ReadFile( rootPath & "queries\CompareBomWithLatestFromRM.sql" )
554
 
555
                     If objFormCollector.Item ("product_state_used") =  "Y"   Then
555
                     Query_String = ReadFile( rootPath & "queries\CompareBomWithLatestFromRM.sql" )
556
                        Query_String = Replace( Query_String, "/* AND rc.PRODUCT_STATE = 3 */", " AND rc.PRODUCT_STATE = 3")
556
                     If objFormCollector.Item ("product_state_used") =  "Y"   Then
557
                     End   If
557
                        Query_String = Replace( Query_String, "/* AND rc.PRODUCT_STATE = 3 */", " AND rc.PRODUCT_STATE = 3")
558
 
558
                     End   If
559
                     Set rsQry = OraDatabase.DbCreateDynaset( Query_String, ORADYN_DEFAULT )
559
 
560
                     Dim rsTemp
560
                     Set rsQry = OraDatabase.DbCreateDynaset( Query_String, ORADYN_DEFAULT )
561
                     Dim hideResult()
561
                     Dim rsTemp
562
                     Dim numHiddenProducts
562
                     Dim hideResult()
563
                     Dim len_hideResult
563
                     Dim numHiddenProducts
564
                     Dim i_hideResult
564
                     Dim len_hideResult
565
 
565
                     Dim i_hideResult
566
                     ' Evaluate hidden status of products
566
 
567
                     ' Create a hask of 'keys' to assist in identifying packages with multiple updates
567
                     ' Evaluate hidden status of products
568
                     numHiddenProducts  = 0
568
                     ' Create a hask of 'keys' to assist in identifying packages with multiple updates
569
                     len_hideResult = 0
569
                     numHiddenProducts  = 0
570
                     While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
570
                     len_hideResult = 0
571
                        key = rsQry("os_id") & "_" & rsQry("prod_id")
571
                     While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
572
                        objList.Item(key) = objList.Item(key) + 1
572
                        key = rsQry("os_id") & "_" & rsQry("prod_id")
573
 
573
                        objList.Item(key) = objList.Item(key) + 1
574
                        Set rsTemp = OraDatabase.DbCreateDynaset( "SELECT * FROM HIDE_PRODUCTS WHERE OS_ID="& rsQry("os_id") &" AND PROD_ID="& rsQry("prod_id"), ORADYN_DEFAULT )
574
 
575
 
575
                        Set rsTemp = OraDatabase.DbCreateDynaset( "SELECT * FROM HIDE_PRODUCTS WHERE OS_ID="& rsQry("os_id") &" AND PROD_ID="& rsQry("prod_id"), ORADYN_DEFAULT )
576
                        len_hideResult = len_hideResult + 1
576
 
577
                        ReDim Preserve hideResult(len_hideResult)
577
                        len_hideResult = len_hideResult + 1
578
 
578
                        ReDim Preserve hideResult(len_hideResult)
579
                        If rsTemp.RecordCount = 0 Then
579
 
580
                           hideResult(len_hideResult - 1) = False
580
                        If rsTemp.RecordCount = 0 Then
581
                        Else
581
                           hideResult(len_hideResult - 1) = False
582
                           hideResult(len_hideResult - 1) = True
582
                        Else
583
                           numHiddenProducts = numHiddenProducts + 1
583
                           hideResult(len_hideResult - 1) = True
584
                        End If
584
                           numHiddenProducts = numHiddenProducts + 1
585
 
585
                        End If
586
                        rsTemp.Close()
586
 
587
                        Set rsTemp = nothing
587
                        rsTemp.Close()
588
                        rsQry.MoveNext
588
                        Set rsTemp = nothing
589
                     Wend
589
                        rsQry.MoveNext
590
 
590
                     Wend
591
                     If (rsQry.RecordCount = numHiddenProducts) Then
591
 
592
                     %>
592
                     If (rsQry.RecordCount = numHiddenProducts) Then
593
                        <tr>
593
                     %>
594
                           <td colspan="6" class="body_row">No Products to Update (some products are hidden and status of those has not been shown)</td>
594
                        <tr>
595
                        </tr>
595
                           <td colspan="6" class="body_row">No Products to Update (some products are hidden and status of those has not been shown)</td>
596
                     <%ElseIf (rsQry.RecordCount < 1) Then%>
596
                        </tr>
597
                        <tr>
597
                     <%ElseIf (rsQry.RecordCount < 1) Then%>
598
                           <td colspan="6" class="body_row">No Products to Update.</td>
598
                        <tr>
599
                        </tr>
599
                           <td colspan="6" class="body_row">No Products to Update.</td>
600
                     <%End If
600
                        </tr>
601
 
601
                     <%End If
602
                     ' Now render the product rows themselves
602
 
603
                     ' Have a hask of products with issues
603
                     ' Now render the product rows themselves
604
                     currPkg_id = 0
604
                     ' Have a hask of products with issues
605
                     rsQry.MoveFirst
605
                     currPkg_id = 0
606
                     i_hideResult = 0
606
                     rsQry.MoveFirst
607
                     While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
607
                     i_hideResult = 0
608
                        key = rsQry("os_id") & "_" & rsQry("prod_id")
608
                     While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
609
                        If hideResult(i_hideResult) = False Then
609
                        key = rsQry("os_id") & "_" & rsQry("prod_id")
610
                           If currPkg_id <> rsQry("pkg_id") Then
610
                        If hideResult(i_hideResult) = False Then
611
                           %>
611
                           If currPkg_id <> rsQry("pkg_id") Then
612
                              <tr>
612
                           %>
613
                                 <td nowrap  colspan="6"><div align="left"><span class="body_row"><img src="icons/i_product.gif" width="19" height="19" hspace="2" align="absmiddle"><%=rsQry("prod_name")%>                                                                                   </span></div></td>
613
                              <tr>
614
                              </tr>
614
                                 <td nowrap  colspan="6"><div align="left"><span class="body_row"><img src="icons/i_product.gif" width="19" height="19" hspace="2" align="absmiddle"><%=rsQry("prod_name")%>                                                                                   </span></div></td>
615
                              <tr>
615
                              </tr>
616
                                 <td colspan="6" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
616
                              <tr>
617
                              </tr>
617
                                 <td colspan="6" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
618
                              <%
618
                              </tr>
619
                              currPkg_id = rsQry("pkg_id")
619
                              <%
620
                           End If
620
                              currPkg_id = rsQry("pkg_id")
621
                           %>
621
                           End If
622
 
622
                           %>
623
                           <tr>
623
 
624
                              <td align="right" nowrap>
624
                           <tr>
625
                                    <input type="checkbox" name="update_<%=rsQry("os_id") &"_"& rsQry("prod_id")%>" value="<%=rsQry("latest_prod_id")%>">
625
                              <td align="right" nowrap>
626
                              </td>
626
                                    <input type="checkbox" name="update_<%=rsQry("os_id") &"_"& rsQry("prod_id")%>" value="<%=rsQry("latest_prod_id")%>">
627
                              <td align="left" nowrap>
627
                              </td>
628
                                    <%If objList.Item(key) > 1 Then%>
628
                              <td align="left" nowrap>
629
                                        <img hspace="2" src="icons/s_warning.gif" align="absmiddle" border="0" title="Package has multiple versions. Only one can be updated">
629
                                    <%If objList.Item(key) > 1 Then%>
630
                                    <%End If%>
630
                                        <img hspace="2" src="icons/s_warning.gif" align="absmiddle" border="0" title="Package has multiple versions. Only one can be updated">
631
                              </td>
631
                                    <%End If%>
632
                              <td nowrap class="body_row"><img hspace="2" src="icons/<%=rsQry("node_icon")%>" align="absmiddle" border="0"><%=rsQry("prod_location")%></td>
632
                              </td>
633
                              <td nowrap class="body_row"><%=rsQry("prod_version")%></td>
633
                              <td nowrap class="body_row"><img hspace="2" src="icons/<%=rsQry("node_icon")%>" align="absmiddle" border="0"><%=rsQry("prod_location")%></td>
634
                              <td align="center" nowrap>
634
                              <td nowrap class="body_row"><%=rsQry("prod_version")%></td>
635
                              <%If NOT objHideList.Exists(key) Then%>
635
                              <td align="center" nowrap>
636
                                    <input type="checkbox" name="hide_<%=rsQry("os_id") &"_"& rsQry("prod_id")%>" value="<%=rsQry("prod_id")%>">
636
                              <%If NOT objHideList.Exists(key) Then%>
637
                              <%End If%>
637
                                    <input type="checkbox" name="hide_<%=rsQry("os_id") &"_"& rsQry("prod_id")%>" value="<%=rsQry("prod_id")%>">
638
                              <%objHideList.Item(key) = 1%>
638
                              <%End If%>
639
                              </td>
639
                              <%objHideList.Item(key) = 1%>
640
                              <td nowrap class="body_row"><span class="body_txtr"><%=rsQry("rm_latest_version")%></span></td>
640
                              </td>
641
                           </tr>
641
                              <td nowrap class="body_row"><span class="body_txtr"><%=rsQry("rm_latest_version")%></span></td>
642
                           <tr>
642
                           </tr>
643
                              <td colspan="6" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
643
                           <tr>
644
                           </tr>
644
                              <td colspan="6" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
645
                        <%
645
                           </tr>
646
                        End If
646
                        <%
647
 
647
                        End If
648
                        rsQry.MoveNext
648
 
649
                        i_hideResult = i_hideResult + 1
649
                        rsQry.MoveNext
650
                     Wend
650
                        i_hideResult = i_hideResult + 1
651
                     %>
651
                     Wend
652
 
652
                     %>
653
 
653
 
654
                     <!-- NEW PATCHES +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
654
 
655
                     <%
655
                     <!-- NEW PATCHES +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
656
                     Dim strAdd, rsAdd, strHide
656
                     <%
657
                     Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("NewPatches.sql"), ORADYN_DEFAULT )
657
                     Dim strAdd, rsAdd, strHide
658
                     Set rsAdd = OraDatabase.DbCreateDynaset( GetQuery ("NewPatches.sql"), ORADYN_DEFAULT )
658
                     Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("NewPatches.sql"), ORADYN_DEFAULT )
659
                     currPkg_id = 0
659
                     Set rsAdd = OraDatabase.DbCreateDynaset( GetQuery ("NewPatches.sql"), ORADYN_DEFAULT )
660
 
660
                     currPkg_id = 0
661
                     If rsQry.RecordCount > 0 Then
661
 
662
                        While (NOT rsAdd.BOF) AND (NOT rsAdd.EOF)
662
                     If rsQry.RecordCount > 0 Then
663
                           Set rsTemp = OraDatabase.DbCreateDynaset( "SELECT * FROM HIDE_PRODUCTS WHERE OS_ID="& rsAdd("os_id") &" AND PROD_ID="& rsAdd("prod_id"), ORADYN_DEFAULT )
663
                        While (NOT rsAdd.BOF) AND (NOT rsAdd.EOF)
664
 
664
                           Set rsTemp = OraDatabase.DbCreateDynaset( "SELECT * FROM HIDE_PRODUCTS WHERE OS_ID="& rsAdd("os_id") &" AND PROD_ID="& rsAdd("prod_id"), ORADYN_DEFAULT )
665
                           If rsTemp.RecordCount = 0 Then
665
 
666
                              strAdd = strAdd + "'add_"&rsAdd("os_id") &"_"& rsAdd("prod_id")&"',"
666
                           If rsTemp.RecordCount = 0 Then
667
                              strHide = strHide + "'hide_"&rsAdd("os_id") &"_"& rsAdd("prod_id")&"',"
667
                              strAdd = strAdd + "'add_"&rsAdd("os_id") &"_"& rsAdd("prod_id")&"',"
668
                           End If
668
                              strHide = strHide + "'hide_"&rsAdd("os_id") &"_"& rsAdd("prod_id")&"',"
669
                           rsAdd.MoveNext
669
                           End If
670
                        Wend
670
                           rsAdd.MoveNext
671
 
671
                        Wend
672
                        rsAdd.Close()
672
 
673
                        rsTemp.Close()
673
                        rsAdd.Close()
674
                        Set rsAdd = nothing
674
                        rsTemp.Close()
675
                        Set rsTemp = nothing
675
                        Set rsAdd = nothing
676
 
676
                        Set rsTemp = nothing
677
                        If NOT IsEmpty(strAdd) Then
677
 
678
                           strAdd = Mid(strAdd, 1, Len(strAdd)-1) + ", 'checkalladd'"
678
                        If NOT IsEmpty(strAdd) Then
679
                        End If
679
                           strAdd = Mid(strAdd, 1, Len(strAdd)-1) + ", 'checkalladd'"
680
                        If NOT IsEmpty(strHide) Then
680
                        End If
681
                           strHide = Mid(strHide, 1, Len(strHide)-1) + ", 'checkallhide'"
681
                        If NOT IsEmpty(strHide) Then
682
                        End If
682
                           strHide = Mid(strHide, 1, Len(strHide)-1) + ", 'checkallhide'"
683
                        %>
683
                        End If
684
 
684
                        %>
685
                        <tr>
685
 
686
                           <td nowrap background="images/bg_bage_0h.gif" class="body_col" align="center">Add</td>
686
                        <tr>
687
                           <td nowrap class="body_col">&nbsp;</td>
687
                           <td nowrap background="images/bg_bage_0h.gif" class="body_col" align="center">Add</td>
688
                           <td align="right" nowrap background="images/bg_bage_0h.gif" class="body_col"><div align="left">Location</div></td>
688
                           <td nowrap class="body_col">&nbsp;</td>
689
                           <td align="right" nowrap background="images/bg_bage_0h.gif" class="body_col"><div align="left">Version</div></td>
689
                           <td align="right" nowrap background="images/bg_bage_0h.gif" class="body_col"><div align="left">Location</div></td>
690
                           <td align="right" background="images/bg_bage_0h.gif" class="body_col"><div align="center">Hide</div></td>
690
                           <td align="right" nowrap background="images/bg_bage_0h.gif" class="body_col"><div align="left">Version</div></td>
691
                           <td align="right" background="images/bg_bage_0h.gif" class="body_col"><div align="left">Comments<img src="images/spacer.gif" width="1" height="18" align="absmiddle"></div>                </td>
691
                           <td align="right" background="images/bg_bage_0h.gif" class="body_col"><div align="center">Hide</div></td>
692
                        </tr>
692
                           <td align="right" background="images/bg_bage_0h.gif" class="body_col"><div align="left">Comments<img src="images/spacer.gif" width="1" height="18" align="absmiddle"></div>                </td>
693
                        <%If NOT IsEmpty(strAdd) Then%>
693
                        </tr>
694
                           <tr>
694
                        <%If NOT IsEmpty(strAdd) Then%>
695
                              <td align="center" nowrap><INPUT type=checkbox name="checkalladd" value="Check All" onClick="checkAllAdd(<%=strAdd%>);"></td>
695
                           <tr>
696
                              <td nowrap class="body_row">&nbsp;</td>
696
                              <td align="center" nowrap><INPUT type=checkbox name="checkalladd" value="Check All" onClick="checkAllAdd(<%=strAdd%>);"></td>
697
                              <td nowrap class="body_row">&nbsp;</td>
697
                              <td nowrap class="body_row">&nbsp;</td>
698
                              <td nowrap class="body_row">&nbsp;</td>
698
                              <td nowrap class="body_row">&nbsp;</td>
699
                              <td align="center" nowrap><INPUT type=checkbox name="checkallhide" value="Check All" onClick="checkAllHide(<%=strHide%>);"></td>
699
                              <td nowrap class="body_row">&nbsp;</td>
700
                              <td nowrap class="body_row">&nbsp;</td>
700
                              <td align="center" nowrap><INPUT type=checkbox name="checkallhide" value="Check All" onClick="checkAllHide(<%=strHide%>);"></td>
701
                           </tr>
701
                              <td nowrap class="body_row">&nbsp;</td>
702
                        <%
702
                           </tr>
703
                        End If
703
                        <%
704
 
704
                        End If
705
                        While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
705
 
706
 
706
                        While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
707
                           Set rsTemp = OraDatabase.DbCreateDynaset( "SELECT * FROM HIDE_PRODUCTS WHERE OS_ID="& rsQry("os_id") &" AND PROD_ID="& rsQry("prod_id"), ORADYN_DEFAULT )
707
 
708
 
708
                           Set rsTemp = OraDatabase.DbCreateDynaset( "SELECT * FROM HIDE_PRODUCTS WHERE OS_ID="& rsQry("os_id") &" AND PROD_ID="& rsQry("prod_id"), ORADYN_DEFAULT )
709
                           If rsTemp.RecordCount = 0 Then
709
 
710
 
710
                           If rsTemp.RecordCount = 0 Then
711
                              If currPkg_id <> rsQry("pkg_id") Then
711
 
712
                              %>
712
                              If currPkg_id <> rsQry("pkg_id") Then
713
                                 <tr>
713
                              %>
714
                                    <td colspan="3" nowrap><div align="left"><span class="body_row"><img src="icons/i_product.gif" width="19" height="19" hspace="2" align="absmiddle"><%=rsQry("prod_name")%></span></div></td>
714
                                 <tr>
715
                                    <td nowrap class="body_row">&nbsp;</td>
715
                                    <td colspan="3" nowrap><div align="left"><span class="body_row"><img src="icons/i_product.gif" width="19" height="19" hspace="2" align="absmiddle"><%=rsQry("prod_name")%></span></div></td>
716
                                    <td nowrap class="body_row"><div align="center"></div></td>
716
                                    <td nowrap class="body_row">&nbsp;</td>
717
                                    <td nowrap class="body_row"></td>
717
                                    <td nowrap class="body_row"><div align="center"></div></td>
718
                                 </tr>
718
                                    <td nowrap class="body_row"></td>
719
                                 <tr>
719
                                 </tr>
720
                                    <td colspan="6" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
720
                                 <tr>
721
                                 </tr>
721
                                    <td colspan="6" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
722
                                 <%
722
                                 </tr>
723
                                 currPkg_id = rsQry("pkg_id")
723
                                 <%
724
                              End If
724
                                 currPkg_id = rsQry("pkg_id")
725
                              %>
725
                              End If
726
                              <tr>
726
                              %>
727
                                <td align="center" nowrap><input type="checkbox" name="add_<%=rsQry("os_id") &"_"& rsQry("prod_id")%>" value="<%=rsQry("prod_id")%>"> </td>
727
                              <tr>
728
                                <td nowrap class="body_row"></td>
728
                                <td align="center" nowrap><input type="checkbox" name="add_<%=rsQry("os_id") &"_"& rsQry("prod_id")%>" value="<%=rsQry("prod_id")%>"> </td>
729
                                <td nowrap class="body_row"><img hspace="2" src="icons/<%=rsQry("node_icon")%>" align="absmiddle" border="0"><%=rsQry("prod_location")%></td>
729
                                <td nowrap class="body_row"></td>
730
                                <td nowrap class="body_row"><img src="icons/i_patch_small.gif" width="16" height="16" border="0" align="absmiddle"><%=rsQry("prod_version")%></td>
730
                                <td nowrap class="body_row"><img hspace="2" src="icons/<%=rsQry("node_icon")%>" align="absmiddle" border="0"><%=rsQry("prod_location")%></td>
731
                                <td align="center" nowrap><input type="checkbox" name="hide_<%=rsQry("os_id") &"_"& rsQry("prod_id")%>" value="<%=rsQry("prod_id")%>"> </td>
731
                                <td nowrap class="body_row"><img src="icons/i_patch_small.gif" width="16" height="16" border="0" align="absmiddle"><%=rsQry("prod_version")%></td>
732
                                <td nowrap class="body_row"><span class="body_row"><%=rsQry("comments")%></span></td>
732
                                <td align="center" nowrap><input type="checkbox" name="hide_<%=rsQry("os_id") &"_"& rsQry("prod_id")%>" value="<%=rsQry("prod_id")%>"> </td>
733
                              </tr>
733
                                <td nowrap class="body_row"><span class="body_row"><%=rsQry("comments")%></span></td>
734
                              <tr>
734
                              </tr>
735
                                 <td colspan="6" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
735
                              <tr>
736
                              </tr>
736
                                 <td colspan="6" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
737
                           <%
737
                              </tr>
738
                           End If
738
                           <%
739
 
739
                           End If
740
                           rsTemp.Close()
740
 
741
                           Set rsTemp = nothing
741
                           rsTemp.Close()
742
 
742
                           Set rsTemp = nothing
743
                           rsQry.MoveNext
743
 
744
                        Wend
744
                           rsQry.MoveNext
745
                     End If
745
                        Wend
746
                     %>
746
                     End If
747
                     <tr>
747
                     %>
748
                        <td colspan="6" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="3"></td>
748
                     <tr>
749
                     </tr>
749
                        <td colspan="6" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="3"></td>
750
                  </table>
750
                     </tr>
751
                  <%
751
                  </table>
752
                  OraDatabase.Parameters.Remove "RTAG_ID"
752
                  <%
753
                  OraDatabase.Parameters.Remove "BOM_ID"
753
                  OraDatabase.Parameters.Remove "RTAG_ID"
754
                  rsQry.Close
754
                  OraDatabase.Parameters.Remove "BOM_ID"
755
                  Set rsQry = Nothing
755
                  rsQry.Close
756
                  %>
756
                  Set rsQry = Nothing
757
               </td>
757
                  %>
758
            </tr>
758
               </td>
759
         </table>
759
            </tr>
760
         <!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
760
         </table>
761
      </td>
761
         <!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
762
   </tr>
762
      </td>
763
   <%=objPMod.ComposeHiddenTags()%>
763
   </tr>
764
   <input type="hidden" name="action" value="true">
764
   <%=objPMod.ComposeHiddenTags()%>
765
   <%
765
   <input type="hidden" name="action" value="true">
766
   Call objFormComponent.FormEnd()
766
   <%
767
   '-- FROM END ----------------------------------------------------------------------------------------------------------------
767
   Call objFormComponent.FormEnd()
768
   %>
768
   '-- FROM END ----------------------------------------------------------------------------------------------------------------
769
</table>
769
   %>
770
</body>
770
</table>
771
</html>
771
</body>
772
<%
772
</html>
773
'------------ RUN AFTER PAGE RENDER -----------
773
<%
774
'----------------------------------------------
774
'------------ RUN AFTER PAGE RENDER -----------
775
%>
775
'----------------------------------------------
776
<!--#include file="common/globals_destructor.asp"-->
776
%>
-
 
777
<!--#include file="common/globals_destructor.asp"-->