Subversion Repositories DevTools

Rev

Rev 43 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
<%@LANGUAGE="VBSCRIPT"%>
2 
<%
3 
'=====================================================
4 
'|                                                   |
25 rsolanki 5 
'|			          Bom_Home					 	 |
13 rsolanki 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 -------------
23 rsolanki 24 
Dim rsQry, rsTemp
13 rsolanki 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 
'--------------------------------------------------------------------------------------------------------------
25 rsolanki 51 
Sub GetProductList ( nBom_id, nComparedBomId, outProductList, Flag )
13 rsolanki 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
25 rsolanki 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
13 rsolanki 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 
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
153 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
154 
<link href="scripts/deployment_manager.css" rel="stylesheet" type="text/css">
155 
<script language="JavaScript" src="scripts/common.js"></script>
156 
<script language="JavaScript" src="scripts/remote_scripting.js"></script>
157 
<script language="JavaScript" type="text/javascript">
158 
<!--
159 
 
25 rsolanki 160 
function RequestProductLocation( paramString, rowId ){
161 
	var requestURL;
13 rsolanki 162 
 
163 
	// Product is changes, hence can be found in current bom
164 
	requestURL = 'RequestBomDiffProductLocation.asp';
165 
 
166 
 
167 
	// Show div
168 
	ToggleDisplay( 'PRODUCT_'+ rowId, 'IMG_EXPAND_PRODUCT_' + rowId, 'IMG_COLLAPSE_PRODUCT_' + rowId );
169 
 
170 
	// Set ajax divname
171 
	ajaxdivname = 'PRODUCT_'+ rowId;
172 
 
173 
	if ( MM_findObj( ajaxdivname ).innerHTML == '<%=enumLOADING%>')
174 
	{
175 
 
176 
		//Append the name to search for to the requestURL
177 
		var url = requestURL + paramString;
178 
 
179 
		//Create the xmlHttp object to use in the request
180 
		//stateChangeHandler will fire when the state has changed, i.e. data is received back
181 
		// This is non-blocking (asynchronous)
182 
		xmlHttp = GetXmlHttpObject(stateChangeHandler);
183 
 
184 
		//Send the xmlHttp get to the specified url
185 
		xmlHttp_Get(xmlHttp, url);
186 
 
187 
	}
188 
 
189 
 
190 
}
191 
 
192 
//-->
193 
</script>
194 
</head>
195 
 
196 
<body leftmargin="0" topmargin="0">
197 
<!-- HEADER ++++++++++++++++ -->
198 
<!--#include file="_header.asp"-->
199 
<!-- +++++++++++++++++++++++ -->
200 
<!-- MAIN MENU  +  CRUMBS ++++++++++++++++ -->
201 
<!--#include file="_main_menu.asp"-->
202 
<!-- +++++++++++++++++++++++++++++++++++++ -->
203 
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
204 
  <tr>
205 
    <td width="1%" valign="top" background="images/bg_bage_0.gif">
206 
	<!-- NODE BROWSER ++++++++++++++++++++++ -->
207 
	<!--#include file="_bom_browser.asp"-->
208 
	<!-- END OF NODE BROWSER +++++++++++++++ -->
209 
	</td>
210 
    <td width="1" background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="600"></td>
211 
    <td width="100%" valign="top" bgcolor="#FFFFFF">
212 
	<table width="100%"  border="0" cellspacing="0" cellpadding="0">
213 
	  <tr>
214 
        <td valign="top" background="images/bg_blue.gif"></td>
215 
        <td align="right" valign="bottom" background="images/bg_blue.gif" class="body_txtw"><%Call RenderTitle( objBomCollector )%></td>
216 
        <td background="images/bg_blue.gif"><img src="images/spacer.gif" width="10" height="20"></td>
217 
      </tr>
218 
      <tr>
219 
        <td width="1%" valign="top" background="images/bg_blue.gif"></td>
220 
        <td width="100%" valign="bottom" background="images/bg_blue.gif">
221 
		<!-- TAB CONTROLS ++++++++++++++++++++++ -->
222 
		<!--#include file="_tabs_definition.asp"-->
223 
		<%
224 
		Set objTabControl = New TabControl
225 
		objTabControl.TemplateDoc = ReadFile( Server.MapPath("controls/ERGTabStyleWinXP/tab_style.html") ) ' Supply tab style definition
226 
		objTabControl.TabStyle = "StyleWinXP"
227 
		objTabControl.AddTabDefnition ( arrBomTabDef )
228 
		objTabControl.Render ()
229 
		%>
230 
		<!-- END OF TAB CONTROLS +++++++++++++++ -->
231 
		</td>
232 
        <td width="1%" background="images/bg_blue.gif"><img src="images/spacer.gif" width="10" height="35"></td>
233 
        </tr>
234 
      <tr>
235 
        <td background="images/bg_bage_0.gif"><img src="images/spacer.gif" width="30" height="10"></td>
236 
        <td background="images/bg_bage_0.gif">
237 
		<!-- BUTTONS CONTROL +++++++++++++++++++ -->
238 
		<%
239 
		'-- Define Action buttons on this tab
29 jtweddle 240 
		aTabBtnsDef = Array("abtnSyncProdLatest", "abtnUnhideProducts", "abtnRevertProdLatest")
13 rsolanki 241 
 
242 
		Call LoadTabActionButtons ( aTabBtnsDef, objBtnControl )
243 
 
244 
		' -- Tell control if buttons need to be readonly actions
245 
		objBtnControl.IsReadonlyAction = objBomCollector.Item("is_readonly")
246 
 
247 
		' -- Render Buttons
248 
		Call objBtnControl.Render  ( aTabBtnsDef )
249 
		%>
250 
		<!-- +++++++++++++++++++++++++++++++++++ -->
251 
		</td>
252 
        <td background="images/bg_blue.gif"><img src="images/p_bar_corrner.gif" width="17" height="42"></td>
253 
        </tr>
254 
      <tr>
255 
        <td>&nbsp;</td>
256 
        <td>&nbsp;</td>
257 
        <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>
258 
        </tr>
259 
    </table>
260 
 
25 rsolanki 261 
<!-- BOM REJECTED ------------------------------------------------------------------------------------------ -->
262 
	<%If objBomCollector.Item ("is_readonly") = enumDB_YES Then%>
13 rsolanki 263 
	<table width="100%"  border="0" cellspacing="10" cellpadding="0">
264 
      <tr>
265 
        <td>
266 
		<%
267 
			OraDatabase.Parameters.Add "ENTITY_ID", 		dbPARbom_id,	ORAPARM_INPUT, ORATYPE_NUMBER
268 
			OraDatabase.Parameters.Add "ENUM_ENTITY_TYPE", 	"enumENTITY_TYPE_BOM",	ORAPARM_INPUT, ORATYPE_VARCHAR2
269 
 
270 
			Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("RejectionTrail.sql"), ORADYN_DEFAULT )
271 
 
272 
			sMessage = "<table width='100%'  border='0' cellspacing='3' cellpadding='0'>"
273 
			sMessage = sMessage &"<tr>"
25 rsolanki 274 
			sMessage = sMessage &"<td width='100%' class='body_txt'><b>BOM NOTES</b><br><br><br></td>"
275 
			If rsQry.RecordCount = 0 Then
276 
				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>"
277 
			Else
278 
				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>"
279 
			End If
13 rsolanki 280 
			sMessage = sMessage &"</tr>"
281 
 
282 
			While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
283 
				sMessage = sMessage & "<tr><td colspan='2' background='images/bg_table_border.gif'><img src='images/spacer.gif' width='1' height='1'></td></tr>"
284 
				sMessage = sMessage &"<tr>"
285 
				sMessage = sMessage &"<td class='body_txt'>"
25 rsolanki 286 
 
13 rsolanki 287 
				If rsQry("is_rejected") = enumDB_YES Then
25 rsolanki 288 
					sMessage = sMessage &"<b>BOM is REJECTED!</b><br>"
289 
				ElseIf (rsQry("is_rejected")) = "N" Then
290 
					sMessage = sMessage &"<b>BOM is ACCEPTED!</b><br>"
13 rsolanki 291 
				Else
25 rsolanki 292 
					sMessage = sMessage &"<b>BOM is LOCKED!</b><br>"
13 rsolanki 293 
				End If
294 
				sMessage = sMessage & objFormater.TextToHTML( rsQry("comments") ) &"<br><SPAN class='body_smltxtg'>"& rsQry("creator") &"</SPAN></td>"
295 
				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>"
296 
				sMessage = sMessage &"</tr>"
297 
 
298 
				rsQry.MoveNext
299 
			WEnd
25 rsolanki 300 
 
13 rsolanki 301 
 
302 
			sMessage = sMessage &"</table>"
303 
 
304 
 
25 rsolanki 305 
			If objBomCollector.Item ("is_rejected") = enumDB_YES Then
306 
				Call Messenger ( sMessage, "bi_rejected.gif", "100%" )
307 
			ElseIf objBomCollector.Item ("is_rejected") = "N" Then
308 
				Call Messenger ( sMessage, "bi_accepted.gif", "100%" )
309 
			Else
310 
				Call Messenger ( sMessage, "bi_new.gif", "100%" )
311 
			End If
312 
 
13 rsolanki 313 
			Response.write "<br>"
314 
 
25 rsolanki 315 
			rsQry.Close()
316 
			Set rsQry = Nothing
13 rsolanki 317 
 
318 
			OraDatabase.Parameters.Remove "ENTITY_ID"
319 
			OraDatabase.Parameters.Remove "ENUM_ENTITY_TYPE"
320 
		%>
321 
 
322 
		</td>
323 
        </tr>
324 
    </table>
325 
	<%End If%>
326 
<!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
327 
 
328 
 
329 
	<table width="100%"  border="0" cellspacing="10" cellpadding="0">
330 
 
331 
	  <tr>
332 
        <td width="1"><img src="images/spacer.gif" width="1" height="1"></td>
333 
        <td width="100%"><img src="images/spacer.gif" width="1" height="1"></td>
334 
      </tr>
335 
 
336 
	  <!-- BOM Comments +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
337 
	  <%If (objBomCollector.Item("bom_comments") <> "") Then%>
338 
      <tr>
339 
        <td align="right" valign="top"><img src="icons/i_bom_properties.gif" width="30" height="30" hspace="3"></td>
340 
        <td valign="top" class="body_txt">
341 
 
342 
 
343 
			<SPAN class="body_colb">BOM Comments</SPAN>
344 
			<hr width="100%" size="1px" noshade color="#808080">
345 
			<SPAN class="body_txt"><%= objFormater.TextToHTML( objBomCollector.Item("bom_comments") )%></SPAN><br><br><br><br>
346 
        </td>
347 
      </tr>
348 
	  <%End If%>
349 
 
350 
 
351 
	  <!-- COMPARE BOM +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
352 
      <tr>
353 
        <td align="right" valign="top"><img src="icons/i_bom_diff.gif" width="37" height="33" hspace="3"></td>
354 
        <td valign="top" class="body_txt">
355 
 
356 
		<%
357 
		'-- FROM START --------------------------------------------------------------------------------------------------------------
358 
		objFormComponent.FormName = "OldVersion"
359 
		objFormComponent.Action = SCRIPT_NAME
360 
		objFormComponent.Method = "get"
361 
		Call objFormComponent.FormStart()
362 
		%>
29 jtweddle 363 
 
13 rsolanki 364 
		<SPAN class="body_colb"><%Call RenderTitle( objBomCollector )%><br>compared with <%= GetCompareBomDetails( objFormCollector.Item("compare_bom_id") ) %></SPAN><br>
29 jtweddle 365 
		<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>
366 
		<%If NOT IsNull(objFormCollector.Item("pdf_attachment_path")) Then%>
367 
		<a href="pdf/<%=objFormCollector.Item("pdf_attachment_path")%>" class="txt_linked" target='_blank'>Download PDF<img src="images/i_new.gif" width="13" height="13" hspace="2" border="0" align="absmiddle" alt="Download pdf."></a>
368 
		<%End If%>
13 rsolanki 369 
            <hr width="100%" size="1px" noshade color="#808080"><br>
29 jtweddle 370 
 
13 rsolanki 371 
 
372 
		<SPAN class="body_txt">Show changes since BOM version&nbsp;</SPAN>
373 
		<%=objFormComponent.Combo ( "compare_bom_id", GetBomTreeList(), TRUE, "class='form_ivalue'" )%>
374 
		<%=objPMod.ComposeHiddenTagsWithout("compare_bom_id")%>
375 
		<%=objFormComponent.SubmitButton ( "Compare", "class='form_btn'" )%>
376 
 
377 
		<table width="100%"  border="0" cellspacing="2" cellpadding="0">
378 
          <tr>
379 
		  	<td width="1" background="images/bg_table_col.gif"><img src="images/spacer.gif" width="11" height="11"></td>
380 
		  	<td width="20%" background="images/bg_table_border.gif"><table width="100%"  border="0" cellspacing="1" cellpadding="2">
381 
              <tr>
15 rsolanki 382 
                <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Product</td>
13 rsolanki 383 
              </tr>
384 
            </table></td>
15 rsolanki 385 
			<td width="20%" nowrap align="left" background="images/bg_table_col.gif" class="body_col">Version</td>
386 
			<td width="60%" nowrap align="left" background="images/bg_table_col.gif" class="body_col"></td>
13 rsolanki 387 
          </tr>
388 
		  <%
25 rsolanki 389 
		  Call GetProductList ( dbPARbom_id, objFormCollector.Item("compare_bom_id"), aProductList, TRUE )
13 rsolanki 390 
 
391 
		  If NOT IsNull( aProductList ) Then
392 
		  	numOfRows = UBound( aProductList, 2 )
393 
 
394 
			For rowNum = 0 To numOfRows
395 
 
396 
				ProdId = aProductList( 0, rowNum )
397 
				ChangeType = aProductList( 3, rowNum )
398 
		  %>
399 
		  <tr>
400 
		  	<td valign="top"><%=Eval( aProductList( 5, rowNum ) )%></td>
401 
            <td nowrap valign="top">
23 rsolanki 402 
			<%
403 
			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 )
404 
			%>
29 jtweddle 405 
			<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>
23 rsolanki 406 
			<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>
407 
			<%
408 
			rsTemp.Close()
409 
			Set rsTemp = nothing
410 
			%>
13 rsolanki 411 
			</td>
43 brianf 412 
            <td nowrap class="body_row" valign="top"><a href=http://bms:8002/ManagerSuite/Release_Manager/dependencies.asp?pv_id=<%=aProductList( 0, rowNum )%> TARGET="_blank">
15 rsolanki 413 
				<%=aProductList( 2, rowNum )%></a>			</td>
13 rsolanki 414 
			<td class="body_rowlite"></td>
415 
          </tr>
416 
 
417 
		  <tr>
418 
			  	<td><img src="images/spacer.gif" width="1" height="1"></td>
419 
	            <td nowrap valign="top" class="body_row" colspan="3">
420 
				<DIV id="PRODUCT_<%=ProdId & ChangeType%>" name="PRODUCT_<%=ProdId & ChangeType%>" style="display:none;"><%=enumLOADING%></DIV>
421 
				</td>
422 
	          </tr>
423 
 
424 
		  <%If rowNum <> numOfRows Then%>
425 
		  <tr>
426 
            <td colspan="4" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
427 
          </tr>
428 
		  <%End If%>
429 
 
430 
		  <%
431 
		  	Next
432 
		  Else%>
433 
 
434 
		  <tr>
435 
            <td colspan="4" class="body_txt">No Changes Found.</td>
436 
          </tr>
437 
 
438 
		  <%End If%>
25 rsolanki 439 
 
440 
		  <tr>
441 
            <td colspan="4" class="body_txt"><b>Base Configuration Changes.</b></td>
442 
          </tr>
443 
 
444 
		  		  <%
445 
		  Call GetProductList ( dbPARbom_id, objFormCollector.Item("compare_bom_id"), aProductList, FALSE )
446 
 
447 
		  If NOT IsNull( aProductList ) Then
448 
		  	numOfRows = UBound( aProductList, 2 )
449 
 
450 
			For rowNum = 0 To numOfRows
451 
 
452 
				ProdId = aProductList( 0, rowNum )
453 
				ChangeType = aProductList( 3, rowNum )
454 
		  %>
455 
		  <tr>
456 
		  	<td valign="top"><%=Eval( aProductList( 5, rowNum ) )%></td>
457 
            <td nowrap valign="top">
458 
			<%
459 
			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 )
460 
			%>
29 jtweddle 461 
			<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>
25 rsolanki 462 
			<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>
463 
			<%
464 
			rsTemp.Close()
465 
			Set rsTemp = nothing
466 
			%>
467 
			</td>
43 brianf 468 
            <td nowrap class="body_row" valign="top"><a href=http://bms:8002/ManagerSuite/Release_Manager/dependencies.asp?pv_id=<%=aProductList( 0, rowNum )%> TARGET="_blank">
25 rsolanki 469 
				<%=aProductList( 2, rowNum )%></a>			</td>
470 
			<td class="body_rowlite"></td>
471 
          </tr>
472 
 
473 
		  <tr>
474 
			  	<td><img src="images/spacer.gif" width="1" height="1"></td>
475 
	            <td nowrap valign="top" class="body_row" colspan="3">
476 
				<DIV id="PRODUCT_<%=ProdId & ChangeType%>" name="PRODUCT_<%=ProdId & ChangeType%>" style="display:none;"><%=enumLOADING%></DIV>
477 
				</td>
478 
	          </tr>
479 
 
480 
		  <%If rowNum <> numOfRows Then%>
481 
		  <tr>
482 
            <td colspan="4" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
483 
          </tr>
484 
		  <%End If%>
485 
 
486 
		  <%
487 
		  	Next
488 
		  Else%>
489 
 
490 
		  <tr>
491 
            <td colspan="4" class="body_txt">No Changes Found.</td>
492 
          </tr>
493 
 
494 
		  <%End If%>
495 
 
496 
 
13 rsolanki 497 
 
498 
          <tr>
499 
            <td colspan="4" background="images/bg_table_border.gif">
500 
			 <table width="100%"  border="0" cellspacing="1" cellpadding="2">
501 
              <tr>
502 
                <td nowrap background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
503 
              </tr>
504 
             </table>
505 
			</td>
506 
          </tr>
507 
         </table>
508 
		 <SPAN class="body_smltxtg">
509 
		 LEGEND: <%=LIMG_ADDED%>&nbsp;Added, <%=LIMG_UPDATED%>&nbsp;Updated, <%=LIMG_REMOVED%>&nbsp;Removed
510 
		 </span>
511 
 
512 
		<%
513 
		Call objFormComponent.FormEnd()
514 
		'-- FROM END ----------------------------------------------------------------------------------------------------------------
515 
		%>
516 
 
517 
	    </td>
518 
      </tr>
519 
    </table></td>
520 
    <td width="1%" valign="top" background="images/bg_favourits.gif">
521 
	<%If Request.Cookies( enumCOOKIE_NAME )( "user_bar" ) <> "hide" Then%>
522 
	<!-- PERSONAL PANE +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
523 
      <table width="100%"  border="0" cellspacing="0" cellpadding="0">
524 
      <tr>
525 
        <td width="100%" valign="bottom" background="images/bg_node_icon.gif"><%=GetNodeImage ( dbPARnode_id )%></td>
526 
        <td width="1" background="images/bg_node_icon.gif"><img src="images/spacer.gif" width="1" height="97"></td>
527 
      </tr>
528 
      </table>
529 
      <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">
530 
      <tr>
531 
        <td valign="top"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
532 
          <tr>
533 
            <td valign="top" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
534 
            <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="10" height="3"></td>
535 
            <td align="right" valign="top" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
536 
          </tr>
537 
          <tr>
538 
            <td colspan="3" background="images/bg_favourits2.gif"><table width="100%"  border="0" cellspacing="5" cellpadding="0">
539 
              <tr>
540 
                <td valign="top" class="fav_txt"><span class="fav_head">Reason for release</span><br>
541 
                      <br>
23 rsolanki 542 
<!--         This version needs to be rebuild on new sysbase_types 1.5.0.mas<br> -->
13 rsolanki 543 
                </td>
544 
              </tr>
545 
            </table></td>
546 
            </tr>
547 
          <tr>
548 
            <td valign="bottom" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
549 
            <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="190" height="3"></td>
550 
            <td align="right" valign="bottom" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
551 
          </tr>
552 
        </table>
553 
          <br>
554 
          <table width="100%"  border="0" cellspacing="0" cellpadding="0">
555 
            <tr>
556 
              <td valign="top" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
557 
              <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="10" height="3"></td>
558 
              <td align="right" valign="top" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
559 
            </tr>
560 
            <tr background="images/bg_gray.gif">
561 
              <td colspan="3" background="images/bg_favourits2.gif"><table width="100%"  border="0" cellspacing="5" cellpadding="0">
562 
                <tr>
563 
                  <td valign="top" class="fav_txt"><span class="fav_head">Fixed Issues</span><br>
564 
                      <br>
565 
                      <table width="100%"  border="0" cellspacing="0" cellpadding="2">
23 rsolanki 566 
<!--                         <tr>
13 rsolanki 567 
                          <td><img src="icons/i_bulet.gif" width="4" height="4" hspace="5"></td>
568 
                          <td><a href="#" class="fav_link">DEVI-021532</a></td>
569 
                        </tr>
570 
                        <tr>
571 
                          <td><img src="icons/i_bulet.gif" width="4" height="4" hspace="5"></td>
572 
                          <td><a href="#" class="fav_link">DEVI-021534</a></td>
573 
                        </tr>
574 
                        <tr>
575 
                          <td width="1%"><img src="icons/i_bulet.gif" width="4" height="4" hspace="5"></td>
576 
                          <td width="100%"><a href="#" class="fav_link">DEVI-021536</a></td>
23 rsolanki 577 
                        </tr> -->
13 rsolanki 578 
                    </table></td>
579 
                </tr>
580 
              </table></td>
581 
              </tr>
582 
            <tr>
583 
              <td valign="bottom" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
584 
              <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="190" height="3"></td>
585 
              <td align="right" valign="bottom" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
586 
            </tr>
587 
          </table></td>
588 
        <td width="1%"><img src="images/spacer.gif" width="15" height="400"></td>
589 
      </tr>
590 
    </table>
591 
	<!-- END OF PERSONAL BAR ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
592 
	<%End If%>
593 
   </td>
594 
  </tr>
595 
  <tr>
596 
    <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="1" height="15"></td>
597 
    <td background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="1"></td>
598 
    <td bgcolor="#FFFFFF"><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 
  </tr>
601 
  <tr>
602 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="20"></td>
603 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
604 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
605 
    <td bgcolor="#FFFFFF">&nbsp;</td>
606 
  </tr>
607 
</table>
608 
<!-- FOOTER ++++++++++++++++ -->
609 
<!--#include file="_footer.asp"-->
610 
<!-- +++++++++++++++++++++++ -->
611 
</body>
612 
</html>
613 
<%
614 
'------------ RUN AFTER PAGE RENDER -----------
615 
Set objPMod = Nothing
616 
Set objCrumbs = Nothing
617 
Set objTabControl = Nothing
618 
'----------------------------------------------
619 
%><!--#include file="common/globals_destructor.asp"-->