Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
5355 dpurdie 1 
<%@LANGUAGE="VBSCRIPT"%>
2 
<%
3 
'=====================================================
4 
'|                                                   |
5 
'|			          Bom_Home					 	 |
6 
'|                                                   |
7 
'=====================================================
8 
%>
9 
<%
10 
Option explicit
11 
Response.Expires = 0
12 
%>
13 
<!--#include file="common/globals.asp"-->
14 
<!--#include file="common/config.asp"-->
15 
<!--#include file="common/common_subs.asp"-->
16 
<!--#include file="common/_bom_common.asp"-->
17 
<!--#include file="controls/ERGFormComponent/classFormComponent.asp"-->
18 
<%
19 
'------------ ACCESS CONTROL ------------------
20 
%>
21 
<!--#include file="_access_control_general.asp"-->
22 
<%
23 
'------------ VARIABLE DEFINITION -------------
24 
Dim rsQry, rsTemp
25 
Dim aProductList
26 
Dim parProd_id_select
27 
Dim parShowall
28 
Dim numOfRows
29 
Dim rowNum
30 
Dim objFormCollector
31 
Dim objFormComponent
32 
Dim sMessage
33 
Dim ProdId
34 
Dim ChangeType
35 
'------------ CONSTANTS DECLARATION -----------
36 
Const LIMG_UPDATED = "<img src='icons/i_updated.gif' width='11' height='11' hspace='2' vspace='2' border='0' align='absmiddle' title='Updated'>"
37 
Const LIMG_ADDED = "<img src='icons/i_added.gif' width='11' height='11' border='0' hspace='2' vspace='2' align='absmiddle' title='Added'>"
38 
Const LIMG_REMOVED = "<img src='icons/i_removed.gif' width='11' height='11' border='0' hspace='2' vspace='2' align='absmiddle' title='Removed'>"
39 
Const LIMG_NOTE_NEW = "<img src='icons/i_note_new.gif' width='18' height='18' border='0' align='absmiddle'>"
40 
Const LIMG_NOTE_EDIT = "<img src='icons/i_note_edit.gif' width='18' height='18' border='0' align='absmiddle'>"
41 
'------------ VARIABLE INIT -------------------
42 
parProd_id_select = Request("prod_id_select")
43 
parShowall = Request("showall")
44 
Set objFormCollector = CreateObject("Scripting.Dictionary")
45 
Set objFormComponent = New FormComponent
46 
'------------ CONDITIONS ----------------------
47 
'----------------------------------------------
48 
%>
49 
<%
50 
'--------------------------------------------------------------------------------------------------------------
51 
Sub GetProductList ( nBom_id, nComparedBomId, outProductList, Flag )
52 
	Dim rsQry, query, showAll
53 
 
54 
	'' Use SHOWALL parameter is BOM has old bom
55 
	'showAll = "Y"
56 
	'If nBom_id <> nComparedBomId Then
57 
	'	showAll = parShowall
58 
	'End If
59 
 
60 
 
61 
	OraDatabase.Parameters.Add "BOM_ID", 	 	 nBom_id,		 ORAPARM_INPUT, ORATYPE_NUMBER
62 
	OraDatabase.Parameters.Add "COMPARE_BOM_ID", nComparedBomId, ORAPARM_INPUT, ORATYPE_NUMBER
63 
	If Flag = TRUE Then
64 
		Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("BomCompare.sql"), ORADYN_DEFAULT )
65 
	Else
66 
		Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("BomCompare_BaseConfig.sql"), ORADYN_DEFAULT )
67 
	End If
68 
	If rsQry.RecordCount > 0 Then
69 
		outProductList = rsQry.GetRows()
70 
	Else
71 
		outProductList = NULL
72 
	End If
73 
 
74 
 
75 
	OraDatabase.Parameters.Remove "COMPARE_BOM_ID"
76 
	OraDatabase.Parameters.Remove "BOM_ID"
77 
End Sub
78 
'--------------------------------------------------------------------------------------------------------------------------
79 
Sub GetFormDetails ( nBom_id, ByRef outobjDetails )
80 
 
81 
	Call GetBomDetails ( nBom_id, outobjDetails )
82 
 
83 
	outobjDetails.Item("root_version") = GetRootVersion ( outobjDetails.Item("bom_version") )
84 
 
85 
	'-- Set compare_bom_id
86 
	If Request("compare_bom_id") <> "" Then
87 
		outobjDetails.Item("compare_bom_id") =  Request("compare_bom_id")
88 
	Else
89 
		outobjDetails.Item("compare_bom_id") = outobjDetails.Item("parent_bom_id")
90 
	End If
91 
 
92 
End Sub
93 
'--------------------------------------------------------------------------------------------------------------
94 
Function GetBomTreeList ()
95 
	Dim rsQry, query
96 
	OraDatabase.Parameters.Add "BOM_NAME_ID", 		objFormCollector.Item("bom_name_id"),		ORAPARM_INPUT, ORATYPE_NUMBER
97 
	OraDatabase.Parameters.Add "BRANCH_ID", 		objFormCollector.Item("branch_id"),			ORAPARM_INPUT, ORATYPE_NUMBER
98 
	OraDatabase.Parameters.Add "BOM_VERSION", 		objFormCollector.Item("root_version"),		ORAPARM_INPUT, ORATYPE_VARCHAR2
99 
	OraDatabase.Parameters.Add "LIKE_BOM_VERSION", 	objFormCollector.Item("root_version") &".%",ORAPARM_INPUT, ORATYPE_VARCHAR2
100 
	OraDatabase.Parameters.Add "COMPARE_BOM_ID", 	objFormCollector.Item("compare_bom_id"),	ORAPARM_INPUT, ORATYPE_NUMBER
101 
 
102 
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("BomTreeCombo.sql"), ORADYN_DEFAULT )
103 
 
104 
	If rsQry.RecordCount > 0 Then
105 
		GetBomTreeList = rsQry.GetRows()
106 
 
107 
	Else
108 
		GetBomTreeList = NULL
109 
 
110 
	End If
111 
 
112 
	OraDatabase.Parameters.Remove "BOM_NAME_ID"
113 
	OraDatabase.Parameters.Remove "BRANCH_ID"
114 
	OraDatabase.Parameters.Remove "BOM_VERSION"
115 
	OraDatabase.Parameters.Remove "LIKE_BOM_VERSION"
116 
	OraDatabase.Parameters.Remove "COMPARE_BOM_ID"
117 
 
118 
	rsQry.Close
119 
	Set rsQry = Nothing
120 
End Function
121 
'--------------------------------------------------------------------------------------------------------------
122 
Function GetCompareBomDetails ( nBomId )
123 
	Dim rsQry, query
124 
	OraDatabase.Parameters.Add "BOM_ID", 	nBomId,	ORAPARM_INPUT, ORATYPE_NUMBER
125 
 
126 
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("BomLocationDetails.sql"), ORADYN_DEFAULT )
127 
 
128 
	If rsQry.RecordCount > 0 Then
129 
		GetCompareBomDetails = rsQry("proj_name") &"&nbsp;/&nbsp;"& rsQry("branch_name") &"&nbsp;/&nbsp;"& rsQry("bom_name") &"&nbsp;"& rsQry("bom_version") &"."& rsQry("bom_lifecycle")
130 
	Else
131 
		GetBomTreeList = NULL
132 
 
133 
	End If
134 
 
135 
	OraDatabase.Parameters.Remove "BOM_ID"
136 
 
137 
	rsQry.Close
138 
	Set rsQry = Nothing
139 
End Function
140 
'--------------------------------------------------------------------------------------------------------------
141 
%>
142 
<%
143 
'------------ RUN BEFORE PAGE RENDER ----------
144 
objPMod.PersistInQryString ( Array("compare_bom_id") )
145 
 
146 
Call GetFormDetails ( dbPARbom_id, objFormCollector )
147 
'----------------------------------------------
148 
%>
149 
<html>
150 
<head>
151 
<title>Deployment Manager</title>
152 
<link rel="shortcut icon" href="<%=FavIcon%>"/>
153 
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
154 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
155 
<link href="scripts/deployment_manager.css" rel="stylesheet" type="text/css">
156 
<script language="JavaScript" src="scripts/common.js"></script>
157 
<script language="JavaScript" src="scripts/remote_scripting.js"></script>
158 
<script language="JavaScript" type="text/javascript">
159 
<!--
160 
 
161 
function RequestProductLocation( paramString, rowId ){
162 
	var requestURL;
163 
 
164 
	// Product is changes, hence can be found in current bom
165 
	requestURL = 'RequestBomDiffProductLocation.asp';
166 
 
167 
 
168 
	// Show div
169 
	ToggleDisplay( 'PRODUCT_'+ rowId, 'IMG_EXPAND_PRODUCT_' + rowId, 'IMG_COLLAPSE_PRODUCT_' + rowId );
170 
 
171 
	// Set ajax divname
172 
	ajaxdivname = 'PRODUCT_'+ rowId;
173 
 
174 
	if ( MM_findObj( ajaxdivname ).innerHTML == '<%=enumLOADING%>')
175 
	{
176 
 
177 
		//Append the name to search for to the requestURL
178 
		var url = requestURL + paramString;
179 
 
180 
		//Create the xmlHttp object to use in the request
181 
		//stateChangeHandler will fire when the state has changed, i.e. data is received back
182 
		// This is non-blocking (asynchronous)
183 
		xmlHttp = GetXmlHttpObject(stateChangeHandler);
184 
 
185 
		//Send the xmlHttp get to the specified url
186 
		xmlHttp_Get(xmlHttp, url);
187 
 
188 
	}
189 
 
190 
 
191 
}
192 
 
193 
//-->
194 
</script>
195 
</head>
196 
 
197 
<body leftmargin="0" topmargin="0">
198 
<!-- HEADER ++++++++++++++++ -->
199 
<!--#include file="_header.asp"-->
200 
<!-- +++++++++++++++++++++++ -->
201 
<!-- MAIN MENU  +  CRUMBS ++++++++++++++++ -->
202 
<!--#include file="_main_menu.asp"-->
203 
<!-- +++++++++++++++++++++++++++++++++++++ -->
204 
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
205 
  <tr>
206 
    <td width="1%" valign="top" background="images/bg_bage_0.gif">
207 
	<!-- NODE BROWSER ++++++++++++++++++++++ -->
208 
	<!--#include file="_bom_browser.asp"-->
209 
	<!-- END OF NODE BROWSER +++++++++++++++ -->
210 
	</td>
211 
    <td width="1" background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="600"></td>
212 
    <td width="100%" valign="top" bgcolor="#FFFFFF">
213 
	<table width="100%"  border="0" cellspacing="0" cellpadding="0">
214 
	  <tr>
215 
        <td valign="top" background="images/bg_blue.gif"></td>
216 
        <td align="right" valign="bottom" background="images/bg_blue.gif" class="body_txtw"><%Call RenderTitle( objBomCollector )%></td>
217 
        <td background="images/bg_blue.gif"><img src="images/spacer.gif" width="10" height="20"></td>
218 
      </tr>
219 
      <tr>
220 
        <td width="1%" valign="top" background="images/bg_blue.gif"></td>
221 
        <td width="100%" valign="bottom" background="images/bg_blue.gif">
222 
		<!-- TAB CONTROLS ++++++++++++++++++++++ -->
223 
		<!--#include file="_tabs_definition.asp"-->
224 
		<%
225 
		Set objTabControl = New TabControl
226 
		objTabControl.TemplateDoc = ReadFile( Server.MapPath("controls/ERGTabStyleWinXP/tab_style.html") ) ' Supply tab style definition
227 
		objTabControl.TabStyle = "StyleWinXP"
228 
		objTabControl.AddTabDefnition ( arrBomTabDef )
229 
		objTabControl.Render ()
230 
		%>
231 
		<!-- END OF TAB CONTROLS +++++++++++++++ -->
232 
		</td>
233 
        <td width="1%" background="images/bg_blue.gif"><img src="images/spacer.gif" width="10" height="35"></td>
234 
        </tr>
235 
      <tr>
236 
        <td background="images/bg_bage_0.gif"><img src="images/spacer.gif" width="30" height="10"></td>
237 
        <td background="images/bg_bage_0.gif">
238 
		<!-- BUTTONS CONTROL +++++++++++++++++++ -->
239 
		<%
240 
		'-- Define Action buttons on this tab
241 
		aTabBtnsDef = Array("abtnSyncProdLatest", "abtnUnhideProducts", "abtnRevertProdLatest")
242 
 
243 
		Call LoadTabActionButtons ( aTabBtnsDef, objBtnControl )
244 
 
245 
		' -- Tell control if buttons need to be readonly actions
246 
		objBtnControl.IsReadonlyAction = objBomCollector.Item("is_readonly")
247 
 
248 
		' -- Render Buttons
249 
		Call objBtnControl.Render  ( aTabBtnsDef )
250 
		%>
251 
		<!-- +++++++++++++++++++++++++++++++++++ -->
252 
		</td>
253 
        <td background="images/bg_blue.gif"><img src="images/p_bar_corrner.gif" width="17" height="42"></td>
254 
        </tr>
255 
      <tr>
256 
        <td>&nbsp;</td>
257 
        <td>&nbsp;</td>
258 
        <td valign="top"><%If Request.Cookies( enumCOOKIE_NAME )( "user_bar" ) = "hide" Then%><a href="<%=SCRIPT_NAME%>?user_bar=<%=enumDEFAULT%>&<%=objPMod.ComposeURL()%>"><img src="icons/b_left.gif" title="Maximize favourits" width="13" height="13" vspace="5" border="0"></a><%End If%></td>
259 
        </tr>
260 
    </table>
261 
 
262 
<!-- BOM REJECTED ------------------------------------------------------------------------------------------ -->
263 
	<%If objBomCollector.Item ("is_readonly") = enumDB_YES Then%>
264 
	<table width="100%"  border="0" cellspacing="10" cellpadding="0">
265 
      <tr>
266 
        <td>
267 
		<%
268 
			OraDatabase.Parameters.Add "ENTITY_ID", 		dbPARbom_id,	ORAPARM_INPUT, ORATYPE_NUMBER
269 
			OraDatabase.Parameters.Add "ENUM_ENTITY_TYPE", 	"enumENTITY_TYPE_BOM",	ORAPARM_INPUT, ORATYPE_VARCHAR2
270 
 
271 
			Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("RejectionTrail.sql"), ORADYN_DEFAULT )
272 
 
273 
			sMessage = "<table width='100%'  border='0' cellspacing='3' cellpadding='0'>"
274 
			sMessage = sMessage &"<tr>"
275 
			sMessage = sMessage &"<td width='100%' class='body_txt'><b>BOM NOTES</b><br><br><br></td>"
276 
			If rsQry.RecordCount = 0 Then
277 
				sMessage = sMessage &"<td width='1%' nowrap valign='bottom' align='right'><a href='javascript:;' onClick=""MM_openBrWindow('wBomAddNote.asp?rfile="& SCRIPT_NAME &"&"& objPMod.ComposeURL() &"','BomRejectNote','scrollbars=yes,resizable=yes,width=600,height=350');""  class='body_smllink' title='Create new note'>Create Note"& LIMG_NOTE_NEW &"</a></td>"
278 
			Else
279 
				sMessage = sMessage &"<td width='1%' nowrap valign='bottom' align='right'><a href='javascript:;' onClick=""MM_openBrWindow('wBomRejectNote.asp?rfile="& SCRIPT_NAME &"&"& objPMod.ComposeURL() &"','BomRejectNote','scrollbars=yes,resizable=yes,width=600,height=350');""  class='body_smllink' title='Create new note'>Create Note"& LIMG_NOTE_NEW &"</a></td>"
280 
			End If
281 
			sMessage = sMessage &"</tr>"
282 
 
283 
			While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
284 
				sMessage = sMessage & "<tr><td colspan='2' background='images/bg_table_border.gif'><img src='images/spacer.gif' width='1' height='1'></td></tr>"
285 
				sMessage = sMessage &"<tr>"
286 
				sMessage = sMessage &"<td class='body_txt'>"
287 
 
288 
				If rsQry("is_rejected") = enumDB_YES Then
289 
					sMessage = sMessage &"<b>BOM is REJECTED!</b><br>"
290 
				ElseIf (rsQry("is_rejected")) = "N" Then
291 
					sMessage = sMessage &"<b>BOM is ACCEPTED!</b><br>"
292 
				Else
293 
					sMessage = sMessage &"<b>BOM is LOCKED!</b><br>"
294 
				End If
295 
				sMessage = sMessage & objFormater.TextToHTML( rsQry("comments") ) &"<br><SPAN class='body_smltxtg'>"& rsQry("creator") &"</SPAN></td>"
296 
				sMessage = sMessage &"<td nowrap valign='bottom' align='right'><a href='javascript:;' onClick=""MM_openBrWindow('wBomRejectNote.asp?reject_seq="& rsQry("reject_seq") &"&rfile="& SCRIPT_NAME &"&"& objPMod.ComposeURL() &"','BomRejectNote','scrollbars=yes,resizable=yes,width=600,height=350');"" class='body_smllink' title='Edit note'>Edit Note"& LIMG_NOTE_EDIT &"</a></td>"
297 
				sMessage = sMessage &"</tr>"
298 
 
299 
				rsQry.MoveNext
300 
			WEnd
301 
 
302 
 
303 
			sMessage = sMessage &"</table>"
304 
 
305 
 
306 
			If objBomCollector.Item ("is_rejected") = enumDB_YES Then
307 
				Call Messenger ( sMessage, "bi_rejected.gif", "100%" )
308 
			ElseIf objBomCollector.Item ("is_rejected") = "N" Then
309 
				Call Messenger ( sMessage, "bi_accepted.gif", "100%" )
310 
			Else
311 
				Call Messenger ( sMessage, "bi_new.gif", "100%" )
312 
			End If
313 
 
314 
			Response.write "<br>"
315 
 
316 
			rsQry.Close()
317 
			Set rsQry = Nothing
318 
 
319 
			OraDatabase.Parameters.Remove "ENTITY_ID"
320 
			OraDatabase.Parameters.Remove "ENUM_ENTITY_TYPE"
321 
		%>
322 
 
323 
		</td>
324 
        </tr>
325 
    </table>
326 
	<%End If%>
327 
<!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
328 
 
329 
 
330 
	<table width="100%"  border="0" cellspacing="10" cellpadding="0">
331 
 
332 
	  <tr>
333 
        <td width="1"><img src="images/spacer.gif" width="1" height="1"></td>
334 
        <td width="100%"><img src="images/spacer.gif" width="1" height="1"></td>
335 
      </tr>
336 
 
337 
	  <!-- BOM Comments +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
338 
	  <%If (objBomCollector.Item("bom_comments") <> "") Then%>
339 
      <tr>
340 
        <td align="right" valign="top"><img src="icons/i_bom_properties.gif" width="30" height="30" hspace="3"></td>
341 
        <td valign="top" class="body_txt">
342 
 
343 
 
344 
			<SPAN class="body_colb">BOM Comments</SPAN>
345 
			<hr width="100%" size="1px" noshade color="#808080">
346 
			<SPAN class="body_txt"><%= objFormater.TextToHTML( objBomCollector.Item("bom_comments") )%></SPAN><br><br><br><br>
347 
        </td>
348 
      </tr>
349 
	  <%End If%>
350 
 
351 
 
352 
	  <!-- COMPARE BOM +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
353 
      <tr>
354 
        <td align="right" valign="top"><img src="icons/i_bom_diff.gif" width="37" height="33" hspace="3"></td>
355 
        <td valign="top" class="body_txt">
356 
 
357 
		<%
358 
		'-- FROM START --------------------------------------------------------------------------------------------------------------
359 
		objFormComponent.FormName = "OldVersion"
360 
		objFormComponent.Action = SCRIPT_NAME
361 
		objFormComponent.Method = "get"
362 
		Call objFormComponent.FormStart()
363 
		%>
364 
 
365 
		<SPAN class="body_colb"><%Call RenderTitle( objBomCollector )%><br>compared with <%= GetCompareBomDetails( objFormCollector.Item("compare_bom_id") ) %></SPAN><br>
366 
		<a href="javascript:;" onclick="MM_openBrWindow('_wform_upload_pdf.asp?bom_id=<%=dbPARbom_id%>', 'upload', 'resizable=yes,height=250,width=500')" class="txt_linked">Upload PDF<img src="images/i_new.gif" width="13" height="13" hspace="2" border="0" align="absmiddle" alt="Upload pdf."></a>
367 
		<%If NOT IsNull(objFormCollector.Item("pdf_attachment_path")) Then%>
368 
		<a href="_download_pdf.asp?bom_id=<%=dbPARbom_id%>" title="Download the file: <%=objFormCollector.Item("pdf_attachment_path")%>">Download PDF<img src="images/i_new.gif" width="13" height="13" hspace="2" border="0" align="absmiddle" alt="Download pdf."></a>
369 
		<%End If%>
370 
            <hr width="100%" size="1px" noshade color="#808080"><br>
371 
 
372 
 
373 
		<SPAN class="body_txt">Show changes since BOM version&nbsp;</SPAN>
374 
		<%=objFormComponent.Combo ( "compare_bom_id", GetBomTreeList(), TRUE, "class='form_ivalue'" )%>
375 
		<%=objPMod.ComposeHiddenTagsWithout("compare_bom_id")%>
376 
		<%=objFormComponent.SubmitButton ( "Compare", "class='form_btn'" )%>
377 
 
378 
		<table width="100%"  border="0" cellspacing="2" cellpadding="0">
379 
          <tr>
380 
		  	<td width="1" background="images/bg_table_col.gif"><img src="images/spacer.gif" width="11" height="11"></td>
381 
		  	<td width="20%" background="images/bg_table_border.gif"><table width="100%"  border="0" cellspacing="1" cellpadding="2">
382 
              <tr>
383 
                <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Product</td>
384 
              </tr>
385 
            </table></td>
386 
			<td width="20%" nowrap align="left" background="images/bg_table_col.gif" class="body_col">Version</td>
387 
			<td width="60%" nowrap align="left" background="images/bg_table_col.gif" class="body_col"></td>
388 
          </tr>
389 
		  <%
390 
		  Call GetProductList ( dbPARbom_id, objFormCollector.Item("compare_bom_id"), aProductList, TRUE )
391 
 
392 
		  If NOT IsNull( aProductList ) Then
393 
		  	numOfRows = UBound( aProductList, 2 )
394 
 
395 
			For rowNum = 0 To numOfRows
396 
 
397 
				ProdId = aProductList( 0, rowNum )
398 
				ChangeType = aProductList( 3, rowNum )
399 
		  %>
400 
		  <tr>
401 
		  	<td valign="top"><%=Eval( aProductList( 5, rowNum ) )%></td>
402 
            <td nowrap valign="top">
403 
			<%
404 
			Set rsTemp = OraDatabase.DbCreateDynaset("SELECT * FROM PACKAGE_VERSIONS PV, PRODUCT_DETAILS PD WHERE PD.PROD_ID(+) = PV.PV_ID AND PV.PV_ID ="&ProdId, ORADYN_DEFAULT )
405 
			%>
406 
			<SPAN id="IMG_EXPAND_PRODUCT_<%=ProdId & ChangeType%>" name="IMG_EXPAND_PRODUCT_<%=ProdId & ChangeType%>" style="display:block;"><a href="javascript:;" class="menu_link" onClick="RequestProductLocation('?new_version=<%=aProductList( 2, rowNum )%>&prod_id=<%=ProdId%>&bom_id=<%=dbPARbom_id%>&compare_bom_id=<%=objFormCollector.Item("compare_bom_id")%>&change_type=<%=ChangeType%>&pkg_name=<%=aProductList( 1, rowNum )%>', '<%=ProdId & ChangeType%>');"><%=LIMG_EXPAND & GetProductIcon( rsTemp ) &  aProductList( 1, rowNum )%></a></SPAN>
407 
			<SPAN id="IMG_COLLAPSE_PRODUCT_<%=ProdId & ChangeType%>" name="IMG_COLLAPSE_PRODUCT_<%=ProdId & ChangeType%>" style="display:none;"><a href="javascript:;" class="menu_link" onClick="ToggleDisplay( 'PRODUCT_<%=ProdId & ChangeType%>', 'IMG_EXPAND_PRODUCT_<%=ProdId & ChangeType%>', 'IMG_COLLAPSE_PRODUCT_<%=ProdId & ChangeType%>');"><%=LIMG_COLLAPSE & GetProductIcon( rsTemp ) &  aProductList( 1, rowNum )%></a></SPAN>
408 
			<%
409 
			rsTemp.Close()
410 
			Set rsTemp = nothing
411 
			%>
412 
			</td>
413 
            <td nowrap class="body_row" valign="top"><a href=http://bms:8002/ManagerSuite/Release_Manager/dependencies.asp?pv_id=<%=aProductList( 0, rowNum )%> TARGET="_blank">
414 
				<%=aProductList( 2, rowNum )%></a>			</td>
415 
			<td class="body_rowlite"></td>
416 
          </tr>
417 
 
418 
		  <tr>
419 
			  	<td><img src="images/spacer.gif" width="1" height="1"></td>
420 
	            <td nowrap valign="top" class="body_row" colspan="3">
421 
				<DIV id="PRODUCT_<%=ProdId & ChangeType%>" name="PRODUCT_<%=ProdId & ChangeType%>" style="display:none;"><%=enumLOADING%></DIV>
422 
				</td>
423 
	          </tr>
424 
 
425 
		  <%If rowNum <> numOfRows Then%>
426 
		  <tr>
427 
            <td colspan="4" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
428 
          </tr>
429 
		  <%End If%>
430 
 
431 
		  <%
432 
		  	Next
433 
		  Else%>
434 
 
435 
		  <tr>
436 
            <td colspan="4" class="body_txt">No Changes Found.</td>
437 
          </tr>
438 
 
439 
		  <%End If%>
440 
 
441 
		  <tr>
442 
            <td colspan="4" class="body_txt"><b>Base Configuration Changes.</b></td>
443 
          </tr>
444 
 
445 
		  		  <%
446 
		  Call GetProductList ( dbPARbom_id, objFormCollector.Item("compare_bom_id"), aProductList, FALSE )
447 
 
448 
		  If NOT IsNull( aProductList ) Then
449 
		  	numOfRows = UBound( aProductList, 2 )
450 
 
451 
			For rowNum = 0 To numOfRows
452 
 
453 
				ProdId = aProductList( 0, rowNum )
454 
				ChangeType = aProductList( 3, rowNum )
455 
		  %>
456 
		  <tr>
457 
		  	<td valign="top"><%=Eval( aProductList( 5, rowNum ) )%></td>
458 
            <td nowrap valign="top">
459 
			<%
460 
			Set rsTemp = OraDatabase.DbCreateDynaset("SELECT * FROM PACKAGE_VERSIONS PV, PRODUCT_DETAILS PD WHERE PD.PROD_ID(+) = PV.PV_ID AND PV.PV_ID ="&ProdId, ORADYN_DEFAULT )
461 
			%>
462 
			<SPAN id="IMG_EXPAND_PRODUCT_<%=ProdId & ChangeType%>" name="IMG_EXPAND_PRODUCT_<%=ProdId & ChangeType%>" style="display:block;"><a href="javascript:;" class="menu_link" onClick="RequestProductLocation('?new_version=<%=aProductList( 2, rowNum )%>&prod_id=<%=ProdId%>&bom_id=<%=dbPARbom_id%>&compare_bom_id=<%=objFormCollector.Item("compare_bom_id")%>&change_type=<%=ChangeType%>&pkg_name=<%=aProductList( 1, rowNum )%>', '<%=ProdId & ChangeType%>');"><%=LIMG_EXPAND & GetProductIcon( rsTemp ) &  aProductList( 1, rowNum )%></a></SPAN>
463 
			<SPAN id="IMG_COLLAPSE_PRODUCT_<%=ProdId & ChangeType%>" name="IMG_COLLAPSE_PRODUCT_<%=ProdId & ChangeType%>" style="display:none;"><a href="javascript:;" class="menu_link" onClick="ToggleDisplay( 'PRODUCT_<%=ProdId & ChangeType%>', 'IMG_EXPAND_PRODUCT_<%=ProdId & ChangeType%>', 'IMG_COLLAPSE_PRODUCT_<%=ProdId & ChangeType%>');"><%=LIMG_COLLAPSE & GetProductIcon( rsTemp ) &  aProductList( 1, rowNum )%></a></SPAN>
464 
			<%
465 
			rsTemp.Close()
466 
			Set rsTemp = nothing
467 
			%>
468 
			</td>
469 
            <td nowrap class="body_row" valign="top"><a href=http://bms:8002/ManagerSuite/Release_Manager/dependencies.asp?pv_id=<%=aProductList( 0, rowNum )%> TARGET="_blank">
470 
				<%=aProductList( 2, rowNum )%></a>			</td>
471 
			<td class="body_rowlite"></td>
472 
          </tr>
473 
 
474 
		  <tr>
475 
			  	<td><img src="images/spacer.gif" width="1" height="1"></td>
476 
	            <td nowrap valign="top" class="body_row" colspan="3">
477 
				<DIV id="PRODUCT_<%=ProdId & ChangeType%>" name="PRODUCT_<%=ProdId & ChangeType%>" style="display:none;"><%=enumLOADING%></DIV>
478 
				</td>
479 
	          </tr>
480 
 
481 
		  <%If rowNum <> numOfRows Then%>
482 
		  <tr>
483 
            <td colspan="4" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
484 
          </tr>
485 
		  <%End If%>
486 
 
487 
		  <%
488 
		  	Next
489 
		  Else%>
490 
 
491 
		  <tr>
492 
            <td colspan="4" class="body_txt">No Changes Found.</td>
493 
          </tr>
494 
 
495 
		  <%End If%>
496 
 
497 
 
498 
 
499 
          <tr>
500 
            <td colspan="4" background="images/bg_table_border.gif">
501 
			 <table width="100%"  border="0" cellspacing="1" cellpadding="2">
502 
              <tr>
503 
                <td nowrap background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
504 
              </tr>
505 
             </table>
506 
			</td>
507 
          </tr>
508 
         </table>
509 
		 <SPAN class="body_smltxtg">
510 
		 LEGEND: <%=LIMG_ADDED%>&nbsp;Added, <%=LIMG_UPDATED%>&nbsp;Updated, <%=LIMG_REMOVED%>&nbsp;Removed
511 
		 </span>
512 
 
513 
		<%
514 
		Call objFormComponent.FormEnd()
515 
		'-- FROM END ----------------------------------------------------------------------------------------------------------------
516 
		%>
517 
 
518 
	    </td>
519 
      </tr>
520 
    </table></td>
521 
    <td width="1%" valign="top" background="images/bg_favourits.gif">
522 
	<%If Request.Cookies( enumCOOKIE_NAME )( "user_bar" ) <> "hide" Then%>
523 
	<!-- PERSONAL PANE +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
524 
      <table width="100%"  border="0" cellspacing="0" cellpadding="0">
525 
      <tr>
526 
        <td width="100%" valign="bottom" background="images/bg_node_icon.gif"><%=GetNodeImage ( dbPARnode_id )%></td>
527 
        <td width="1" background="images/bg_node_icon.gif"><img src="images/spacer.gif" width="1" height="97"></td>
528 
      </tr>
529 
      </table>
530 
      <a href="<%=SCRIPT_NAME%>?user_bar=hide&<%=objPMod.ComposeURL()%>"><img src="icons/b_right.gif" title="Minimize favourits" width="13" height="13" vspace="5" border="0"></a>      <table width="100%"  border="0" cellspacing="0" cellpadding="0">
531 
      <tr>
532 
        <td valign="top"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
533 
          <tr>
534 
            <td valign="top" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
535 
            <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="10" height="3"></td>
536 
            <td align="right" valign="top" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
537 
          </tr>
538 
          <tr>
539 
            <td colspan="3" background="images/bg_favourits2.gif"><table width="100%"  border="0" cellspacing="5" cellpadding="0">
540 
              <tr>
541 
                <td valign="top" class="fav_txt"><span class="fav_head">Reason for release</span><br>
542 
                      <br>
543 
<!--         This version needs to be rebuild on new sysbase_types 1.5.0.mas<br> -->
544 
                </td>
545 
              </tr>
546 
            </table></td>
547 
            </tr>
548 
          <tr>
549 
            <td valign="bottom" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
550 
            <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="190" height="3"></td>
551 
            <td align="right" valign="bottom" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
552 
          </tr>
553 
        </table>
554 
          <br>
555 
          <table width="100%"  border="0" cellspacing="0" cellpadding="0">
556 
            <tr>
557 
              <td valign="top" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
558 
              <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="10" height="3"></td>
559 
              <td align="right" valign="top" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
560 
            </tr>
561 
            <tr background="images/bg_gray.gif">
562 
              <td colspan="3" background="images/bg_favourits2.gif"><table width="100%"  border="0" cellspacing="5" cellpadding="0">
563 
                <tr>
564 
                  <td valign="top" class="fav_txt"><span class="fav_head">Fixed Issues</span><br>
565 
                      <br>
566 
                      <table width="100%"  border="0" cellspacing="0" cellpadding="2">
567 
<!--                         <tr>
568 
                          <td><img src="icons/i_bulet.gif" width="4" height="4" hspace="5"></td>
569 
                          <td><a href="#" class="fav_link">DEVI-021532</a></td>
570 
                        </tr>
571 
                        <tr>
572 
                          <td><img src="icons/i_bulet.gif" width="4" height="4" hspace="5"></td>
573 
                          <td><a href="#" class="fav_link">DEVI-021534</a></td>
574 
                        </tr>
575 
                        <tr>
576 
                          <td width="1%"><img src="icons/i_bulet.gif" width="4" height="4" hspace="5"></td>
577 
                          <td width="100%"><a href="#" class="fav_link">DEVI-021536</a></td>
578 
                        </tr> -->
579 
                    </table></td>
580 
                </tr>
581 
              </table></td>
582 
              </tr>
583 
            <tr>
584 
              <td valign="bottom" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
585 
              <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="190" height="3"></td>
586 
              <td align="right" valign="bottom" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
587 
            </tr>
588 
          </table></td>
589 
        <td width="1%"><img src="images/spacer.gif" width="15" height="400"></td>
590 
      </tr>
591 
    </table>
592 
	<!-- END OF PERSONAL BAR ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
593 
	<%End If%>
594 
   </td>
595 
  </tr>
596 
  <tr>
597 
    <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="1" height="15"></td>
598 
    <td background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="1"></td>
599 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
600 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
601 
  </tr>
602 
  <tr>
603 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="20"></td>
604 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
605 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
606 
    <td bgcolor="#FFFFFF">&nbsp;</td>
607 
  </tr>
608 
</table>
609 
<!-- FOOTER ++++++++++++++++ -->
610 
<!--#include file="_footer.asp"-->
611 
<!-- +++++++++++++++++++++++ -->
612 
</body>
613 
</html>
614 
<%
615 
'------------ RUN AFTER PAGE RENDER -----------
616 
Set objPMod = Nothing
617 
Set objCrumbs = Nothing
618 
Set objTabControl = Nothing
619 
'----------------------------------------------
13 rsolanki 620 
%><!--#include file="common/globals_destructor.asp"-->