Subversion Repositories DevTools

Rev

Go to most recent revision | Details | 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 
 
131 
	Else
132 
		GetBomTreeList = NULL
133 
 
134 
	End If
135 
 
136 
	OraDatabase.Parameters.Remove "BOM_ID"
137 
 
138 
	rsQry.Close
139 
	Set rsQry = Nothing
140 
End Function
141 
'--------------------------------------------------------------------------------------------------------------
142 
%>
143 
<%
144 
'------------ RUN BEFORE PAGE RENDER ----------
145 
objPMod.PersistInQryString ( Array("compare_bom_id") )
146 
 
147 
Call GetFormDetails ( dbPARbom_id, objFormCollector )
148 
'----------------------------------------------
149 
%>
150 
<html>
151 
<head>
152 
<title>Deployment Manager</title>
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 
 
25 rsolanki 161 
function RequestProductLocation( paramString, rowId ){
162 
	var requestURL;
13 rsolanki 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")
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 
 
25 rsolanki 262 
<!-- BOM REJECTED ------------------------------------------------------------------------------------------ -->
263 
	<%If objBomCollector.Item ("is_readonly") = enumDB_YES Then%>
13 rsolanki 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 
 
274 
			sMessage = "<table width='100%'  border='0' cellspacing='3' cellpadding='0'>"
275 
			sMessage = sMessage &"<tr>"
25 rsolanki 276 
			sMessage = sMessage &"<td width='100%' class='body_txt'><b>BOM NOTES</b><br><br><br></td>"
277 
			If rsQry.RecordCount = 0 Then
278 
				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>"
279 
			Else
280 
				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>"
281 
			End If
13 rsolanki 282 
			sMessage = sMessage &"</tr>"
283 
 
284 
			While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
285 
				sMessage = sMessage & "<tr><td colspan='2' background='images/bg_table_border.gif'><img src='images/spacer.gif' width='1' height='1'></td></tr>"
286 
				sMessage = sMessage &"<tr>"
287 
				sMessage = sMessage &"<td class='body_txt'>"
25 rsolanki 288 
 
13 rsolanki 289 
				If rsQry("is_rejected") = enumDB_YES Then
25 rsolanki 290 
					sMessage = sMessage &"<b>BOM is REJECTED!</b><br>"
291 
				ElseIf (rsQry("is_rejected")) = "N" Then
292 
					sMessage = sMessage &"<b>BOM is ACCEPTED!</b><br>"
13 rsolanki 293 
				Else
25 rsolanki 294 
					sMessage = sMessage &"<b>BOM is LOCKED!</b><br>"
13 rsolanki 295 
				End If
296 
				sMessage = sMessage & objFormater.TextToHTML( rsQry("comments") ) &"<br><SPAN class='body_smltxtg'>"& rsQry("creator") &"</SPAN></td>"
297 
				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>"
298 
				sMessage = sMessage &"</tr>"
299 
 
300 
				rsQry.MoveNext
301 
			WEnd
25 rsolanki 302 
 
13 rsolanki 303 
 
304 
			sMessage = sMessage &"</table>"
305 
 
306 
 
25 rsolanki 307 
			If objBomCollector.Item ("is_rejected") = enumDB_YES Then
308 
				Call Messenger ( sMessage, "bi_rejected.gif", "100%" )
309 
			ElseIf objBomCollector.Item ("is_rejected") = "N" Then
310 
				Call Messenger ( sMessage, "bi_accepted.gif", "100%" )
311 
			Else
312 
				Call Messenger ( sMessage, "bi_new.gif", "100%" )
313 
			End If
314 
 
13 rsolanki 315 
			Response.write "<br>"
316 
 
25 rsolanki 317 
			rsQry.Close()
318 
			Set rsQry = Nothing
13 rsolanki 319 
 
320 
			OraDatabase.Parameters.Remove "ENTITY_ID"
321 
			OraDatabase.Parameters.Remove "ENUM_ENTITY_TYPE"
322 
		%>
323 
 
324 
		</td>
325 
        </tr>
326 
    </table>
327 
	<%End If%>
328 
<!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
329 
 
330 
 
331 
	<table width="100%"  border="0" cellspacing="10" cellpadding="0">
332 
 
333 
	  <tr>
334 
        <td width="1"><img src="images/spacer.gif" width="1" height="1"></td>
335 
        <td width="100%"><img src="images/spacer.gif" width="1" height="1"></td>
336 
      </tr>
337 
 
338 
	  <!-- BOM Comments +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
339 
	  <%If (objBomCollector.Item("bom_comments") <> "") Then%>
340 
      <tr>
341 
        <td align="right" valign="top"><img src="icons/i_bom_properties.gif" width="30" height="30" hspace="3"></td>
342 
        <td valign="top" class="body_txt">
343 
 
344 
 
345 
			<SPAN class="body_colb">BOM Comments</SPAN>
346 
			<hr width="100%" size="1px" noshade color="#808080">
347 
			<SPAN class="body_txt"><%= objFormater.TextToHTML( objBomCollector.Item("bom_comments") )%></SPAN><br><br><br><br>
348 
        </td>
349 
      </tr>
350 
	  <%End If%>
351 
 
352 
 
353 
	  <!-- COMPARE BOM +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
354 
      <tr>
355 
        <td align="right" valign="top"><img src="icons/i_bom_diff.gif" width="37" height="33" hspace="3"></td>
356 
        <td valign="top" class="body_txt">
357 
 
358 
		<%
359 
		'-- FROM START --------------------------------------------------------------------------------------------------------------
360 
		objFormComponent.FormName = "OldVersion"
361 
		objFormComponent.Action = SCRIPT_NAME
362 
		objFormComponent.Method = "get"
363 
		Call objFormComponent.FormStart()
364 
		%>
365 
		<SPAN class="body_colb"><%Call RenderTitle( objBomCollector )%><br>compared with <%= GetCompareBomDetails( objFormCollector.Item("compare_bom_id") ) %></SPAN><br>
366 
            <hr width="100%" size="1px" noshade color="#808080"><br>
367 
 
368 
		<SPAN class="body_txt">Show changes since BOM version&nbsp;</SPAN>
369 
		<%=objFormComponent.Combo ( "compare_bom_id", GetBomTreeList(), TRUE, "class='form_ivalue'" )%>
370 
		<%=objPMod.ComposeHiddenTagsWithout("compare_bom_id")%>
371 
		<%=objFormComponent.SubmitButton ( "Compare", "class='form_btn'" )%>
372 
 
373 
		<table width="100%"  border="0" cellspacing="2" cellpadding="0">
374 
          <tr>
375 
		  	<td width="1" background="images/bg_table_col.gif"><img src="images/spacer.gif" width="11" height="11"></td>
376 
		  	<td width="20%" background="images/bg_table_border.gif"><table width="100%"  border="0" cellspacing="1" cellpadding="2">
377 
              <tr>
15 rsolanki 378 
                <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Product</td>
13 rsolanki 379 
              </tr>
380 
            </table></td>
15 rsolanki 381 
			<td width="20%" nowrap align="left" background="images/bg_table_col.gif" class="body_col">Version</td>
382 
			<td width="60%" nowrap align="left" background="images/bg_table_col.gif" class="body_col"></td>
13 rsolanki 383 
          </tr>
384 
		  <%
25 rsolanki 385 
		  Call GetProductList ( dbPARbom_id, objFormCollector.Item("compare_bom_id"), aProductList, TRUE )
13 rsolanki 386 
 
387 
		  If NOT IsNull( aProductList ) Then
388 
		  	numOfRows = UBound( aProductList, 2 )
389 
 
390 
			For rowNum = 0 To numOfRows
391 
 
392 
				ProdId = aProductList( 0, rowNum )
393 
				ChangeType = aProductList( 3, rowNum )
394 
		  %>
395 
		  <tr>
396 
		  	<td valign="top"><%=Eval( aProductList( 5, rowNum ) )%></td>
397 
            <td nowrap valign="top">
23 rsolanki 398 
			<%
399 
			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 )
400 
			%>
25 rsolanki 401 
			<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%>', '<%=ProdId & ChangeType%>');"><%=LIMG_EXPAND & GetProductIcon( rsTemp ) &  aProductList( 1, rowNum )%></a></SPAN>
23 rsolanki 402 
			<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>
403 
			<%
404 
			rsTemp.Close()
405 
			Set rsTemp = nothing
406 
			%>
13 rsolanki 407 
			</td>
15 rsolanki 408 
            <td nowrap class="body_row" valign="top"><a href=http://erg:8002/ManagerSuite/Release_Manager/dependencies.asp?pv_id=<%=aProductList( 0, rowNum )%> TARGET="_blank">
409 
				<%=aProductList( 2, rowNum )%></a>			</td>
13 rsolanki 410 
			<td class="body_rowlite"></td>
411 
          </tr>
412 
 
413 
		  <tr>
414 
			  	<td><img src="images/spacer.gif" width="1" height="1"></td>
415 
	            <td nowrap valign="top" class="body_row" colspan="3">
416 
				<DIV id="PRODUCT_<%=ProdId & ChangeType%>" name="PRODUCT_<%=ProdId & ChangeType%>" style="display:none;"><%=enumLOADING%></DIV>
417 
				</td>
418 
	          </tr>
419 
 
420 
		  <%If rowNum <> numOfRows Then%>
421 
		  <tr>
422 
            <td colspan="4" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
423 
          </tr>
424 
		  <%End If%>
425 
 
426 
		  <%
427 
		  	Next
428 
		  Else%>
429 
 
430 
		  <tr>
431 
            <td colspan="4" class="body_txt">No Changes Found.</td>
432 
          </tr>
433 
 
434 
		  <%End If%>
25 rsolanki 435 
 
436 
		  <tr>
437 
            <td colspan="4" class="body_txt"><b>Base Configuration Changes.</b></td>
438 
          </tr>
439 
 
440 
		  		  <%
441 
		  Call GetProductList ( dbPARbom_id, objFormCollector.Item("compare_bom_id"), aProductList, FALSE )
442 
 
443 
		  If NOT IsNull( aProductList ) Then
444 
		  	numOfRows = UBound( aProductList, 2 )
445 
 
446 
			For rowNum = 0 To numOfRows
447 
 
448 
				ProdId = aProductList( 0, rowNum )
449 
				ChangeType = aProductList( 3, rowNum )
450 
		  %>
451 
		  <tr>
452 
		  	<td valign="top"><%=Eval( aProductList( 5, rowNum ) )%></td>
453 
            <td nowrap valign="top">
454 
			<%
455 
			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 )
456 
			%>
457 
			<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%>', '<%=ProdId & ChangeType%>');"><%=LIMG_EXPAND & GetProductIcon( rsTemp ) &  aProductList( 1, rowNum )%></a></SPAN>
458 
			<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>
459 
			<%
460 
			rsTemp.Close()
461 
			Set rsTemp = nothing
462 
			%>
463 
			</td>
464 
            <td nowrap class="body_row" valign="top"><a href=http://erg:8002/ManagerSuite/Release_Manager/dependencies.asp?pv_id=<%=aProductList( 0, rowNum )%> TARGET="_blank">
465 
				<%=aProductList( 2, rowNum )%></a>			</td>
466 
			<td class="body_rowlite"></td>
467 
          </tr>
468 
 
469 
		  <tr>
470 
			  	<td><img src="images/spacer.gif" width="1" height="1"></td>
471 
	            <td nowrap valign="top" class="body_row" colspan="3">
472 
				<DIV id="PRODUCT_<%=ProdId & ChangeType%>" name="PRODUCT_<%=ProdId & ChangeType%>" style="display:none;"><%=enumLOADING%></DIV>
473 
				</td>
474 
	          </tr>
475 
 
476 
		  <%If rowNum <> numOfRows Then%>
477 
		  <tr>
478 
            <td colspan="4" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
479 
          </tr>
480 
		  <%End If%>
481 
 
482 
		  <%
483 
		  	Next
484 
		  Else%>
485 
 
486 
		  <tr>
487 
            <td colspan="4" class="body_txt">No Changes Found.</td>
488 
          </tr>
489 
 
490 
		  <%End If%>
491 
 
492 
 
13 rsolanki 493 
 
494 
          <tr>
495 
            <td colspan="4" background="images/bg_table_border.gif">
496 
			 <table width="100%"  border="0" cellspacing="1" cellpadding="2">
497 
              <tr>
498 
                <td nowrap background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
499 
              </tr>
500 
             </table>
501 
			</td>
502 
          </tr>
503 
         </table>
504 
		 <SPAN class="body_smltxtg">
505 
		 LEGEND: <%=LIMG_ADDED%>&nbsp;Added, <%=LIMG_UPDATED%>&nbsp;Updated, <%=LIMG_REMOVED%>&nbsp;Removed
506 
		 </span>
507 
 
508 
		<%
509 
		Call objFormComponent.FormEnd()
510 
		'-- FROM END ----------------------------------------------------------------------------------------------------------------
511 
		%>
512 
 
513 
	    </td>
514 
      </tr>
515 
    </table></td>
516 
    <td width="1%" valign="top" background="images/bg_favourits.gif">
517 
	<%If Request.Cookies( enumCOOKIE_NAME )( "user_bar" ) <> "hide" Then%>
518 
	<!-- PERSONAL PANE +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
519 
      <table width="100%"  border="0" cellspacing="0" cellpadding="0">
520 
      <tr>
521 
        <td width="100%" valign="bottom" background="images/bg_node_icon.gif"><%=GetNodeImage ( dbPARnode_id )%></td>
522 
        <td width="1" background="images/bg_node_icon.gif"><img src="images/spacer.gif" width="1" height="97"></td>
523 
      </tr>
524 
      </table>
525 
      <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">
526 
      <tr>
527 
        <td valign="top"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
528 
          <tr>
529 
            <td valign="top" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
530 
            <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="10" height="3"></td>
531 
            <td align="right" valign="top" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
532 
          </tr>
533 
          <tr>
534 
            <td colspan="3" background="images/bg_favourits2.gif"><table width="100%"  border="0" cellspacing="5" cellpadding="0">
535 
              <tr>
536 
                <td valign="top" class="fav_txt"><span class="fav_head">Reason for release</span><br>
537 
                      <br>
23 rsolanki 538 
<!--         This version needs to be rebuild on new sysbase_types 1.5.0.mas<br> -->
13 rsolanki 539 
                </td>
540 
              </tr>
541 
            </table></td>
542 
            </tr>
543 
          <tr>
544 
            <td valign="bottom" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
545 
            <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="190" height="3"></td>
546 
            <td align="right" valign="bottom" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
547 
          </tr>
548 
        </table>
549 
          <br>
550 
          <table width="100%"  border="0" cellspacing="0" cellpadding="0">
551 
            <tr>
552 
              <td valign="top" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
553 
              <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="10" height="3"></td>
554 
              <td align="right" valign="top" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
555 
            </tr>
556 
            <tr background="images/bg_gray.gif">
557 
              <td colspan="3" background="images/bg_favourits2.gif"><table width="100%"  border="0" cellspacing="5" cellpadding="0">
558 
                <tr>
559 
                  <td valign="top" class="fav_txt"><span class="fav_head">Fixed Issues</span><br>
560 
                      <br>
561 
                      <table width="100%"  border="0" cellspacing="0" cellpadding="2">
23 rsolanki 562 
<!--                         <tr>
13 rsolanki 563 
                          <td><img src="icons/i_bulet.gif" width="4" height="4" hspace="5"></td>
564 
                          <td><a href="#" class="fav_link">DEVI-021532</a></td>
565 
                        </tr>
566 
                        <tr>
567 
                          <td><img src="icons/i_bulet.gif" width="4" height="4" hspace="5"></td>
568 
                          <td><a href="#" class="fav_link">DEVI-021534</a></td>
569 
                        </tr>
570 
                        <tr>
571 
                          <td width="1%"><img src="icons/i_bulet.gif" width="4" height="4" hspace="5"></td>
572 
                          <td width="100%"><a href="#" class="fav_link">DEVI-021536</a></td>
23 rsolanki 573 
                        </tr> -->
13 rsolanki 574 
                    </table></td>
575 
                </tr>
576 
              </table></td>
577 
              </tr>
578 
            <tr>
579 
              <td valign="bottom" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
580 
              <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="190" height="3"></td>
581 
              <td align="right" valign="bottom" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
582 
            </tr>
583 
          </table></td>
584 
        <td width="1%"><img src="images/spacer.gif" width="15" height="400"></td>
585 
      </tr>
586 
    </table>
587 
	<!-- END OF PERSONAL BAR ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
588 
	<%End If%>
589 
   </td>
590 
  </tr>
591 
  <tr>
592 
    <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="1" height="15"></td>
593 
    <td background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="1"></td>
594 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
595 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
596 
  </tr>
597 
  <tr>
598 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="20"></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 
    <td bgcolor="#FFFFFF">&nbsp;</td>
602 
  </tr>
603 
</table>
604 
<!-- FOOTER ++++++++++++++++ -->
605 
<!--#include file="_footer.asp"-->
606 
<!-- +++++++++++++++++++++++ -->
607 
</body>
608 
</html>
609 
<%
610 
'------------ RUN AFTER PAGE RENDER -----------
611 
Set objPMod = Nothing
612 
Set objCrumbs = Nothing
613 
Set objTabControl = Nothing
614 
'----------------------------------------------
615 
%><!--#include file="common/globals_destructor.asp"-->