Subversion Repositories DevTools

Rev

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

Rev 5925 Rev 5939
Line 19... Line 19...
19 
<!--#include file="common/_rtree_common.asp"-->
 19 
<!--#include file="common/_rtree_common.asp"-->
20 
<%
 20 
<%
21 
'------------ Variable Definition -------------
 21 
'------------ Variable Definition -------------
22 
Dim rsTemp
 22 
Dim rsTemp
23 
Dim pkgId
 23 
Dim pkgId
- 
 
 24 
Dim parExactMatch
24 
'------------ Constants Declaration -----------
 25 
'------------ Constants Declaration -----------
25 
'------------ Variable Init -------------------
 26 
'------------ Variable Init -------------------
26 
pkgId = Request ("pkg_id")
 27 
pkgId = Request ("pkg_id")
- 
 
 28 
parExactMatch = Request ("mode")
27 
'----------------------------------------------
 29 
'----------------------------------------------
28 
%>
 30 
%>
29 
<%
 31 
<%
30 
'------------------------------------------------------------------------------------------------------------------------
 32 
'------------------------------------------------------------------------------------------------------------------------
31 
%>
 33 
%>
Line 37... Line 39...
37 
	<tr>
 39 
	<tr>
38 
	 <td background="images/bg_form_lightbluedark.gif">
40 
	 <td background="images/bg_form_lightbluedark.gif">
39
41
40 
						<table width="100%" border="0" cellspacing="1" cellpadding="1">
 42 
						<table width="100%" border="0" cellspacing="1" cellpadding="1">
41 
                          <tr>
 43 
                          <tr>
42 
						    <td width="33%" background="images/bg_form_lightbluedark.gif" nowrap class="body_col">Package</td>
 44 
						    <td width="33%" background="images/bg_form_lightbluedark.gif" nowrap class="body_col">Package and Version</td>
43 
						    <td width="33%" background="images/bg_form_lightbluedark.gif" nowrap class="body_col">Version</td>
 45 
						    <td width="33%" background="images/bg_form_lightbluedark.gif" nowrap class="body_col">Version Used</td>
44 
						    <td width="33%" background="images/bg_form_lightbluedark.gif" nowrap class="body_col"></td>
 46 
						    <td width="33%" background="images/bg_form_lightbluedark.gif" nowrap class="body_col"></td>
45 
						    <td width="1" background="images/bg_form_lightbluedark.gif" nowrap class="body_col">Last&nbsp;Modified</td>
 47 
						    <td width="1" background="images/bg_form_lightbluedark.gif" nowrap class="body_col">Last&nbsp;Modified</td>
46 
						  </tr>
 48 
						  </tr>
47 
                          <%
 49 
                          <%
48 
						  OraDatabase.Parameters.Add "PV_ID",  Request("pv_id"),   ORAPARM_INPUT, ORATYPE_NUMBER
50 
						  OraDatabase.Parameters.Add "PV_ID",  Request("pv_id"),   ORAPARM_INPUT, ORATYPE_NUMBER
49 
						  OraDatabase.Parameters.Add "PKG_ID", pkgId, ORAPARM_INPUT, ORATYPE_NUMBER
51 
						  OraDatabase.Parameters.Add "PKG_ID", pkgId, ORAPARM_INPUT, ORATYPE_NUMBER
- 
 
 52 
						  OraDatabase.Parameters.Add "MATCH",  parExactMatch, ORAPARM_INPUT, ORATYPE_NUMBER
50
53
51 
						  Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery("UsedByPackageDetail.sql"), cint(0))
 54 
						  Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery("UsedByPackageDetail.sql"), cint(0))
52
55
- 
 
 56 
						  OraDatabase.Parameters.Remove "MATCH"
53 
						  OraDatabase.Parameters.Remove "PV_ID"
 57 
						  OraDatabase.Parameters.Remove "PV_ID"
54 
						  OraDatabase.Parameters.Remove "PKG_ID"
 58 
						  OraDatabase.Parameters.Remove "PKG_ID"
55
59
56 
						  %>
 60 
						  %>
57 
						  <%If rsTemp.RecordCount < 1 Then%>
 61 
						  <%If rsTemp.RecordCount < 1 Then%>
Line 65... Line 69...
65 
			  			  <%While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))%>
 69 
			  			  <%While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))%>
66 
                          <tr>
70 
                          <tr>
67 
                            <td background="images/bg_form_lightgray.gif" nowrap>
 71 
                            <td background="images/bg_form_lightgray.gif" nowrap>
68 
                                <%If rsTemp("dlocked") = "Y" Then%><%=imgPkgLocked%><%Else%><%=imgPkgLockSpacer%><%End If%>
 72 
                                <%If rsTemp("dlocked") = "Y" Then%><%=imgPkgLocked%><%Else%><%=imgPkgLockSpacer%><%End If%>
69 
                                <a href="view_by_version.asp?pkg_id=<%=pkgId%>&listby=1" class="txt_linked">
 73 
                                <a href="view_by_version.asp?pkg_id=<%=pkgId%>&listby=1" class="txt_linked">
70 
                                    <%=rsTemp("pkg_name")%>
 74 
                                    <%=rsTemp("pkg_name")%></a>&nbsp;<a href="dependencies.asp?pv_id=<%=rsTemp("pv_id")%>" class="txt_linked"><%=rsTemp("pkg_version")%></a>
71 
                                </a>
 75 
                                </a>
72 
                            </td>
 76 
                            </td>
73 
                            <td background="images/bg_form_lightgray.gif" nowrap>
 77 
                            <td background="images/bg_form_lightgray.gif" nowrap>
74 
                              <a href="dependencies.asp?pv_id=<%=rsTemp("pv_id")%>" class="txt_linked">
 78 
                              <a href="dependencies.asp?pv_id=<%=rsTemp("used_pv_id")%>" class="txt_linked <%=iif(rsTemp("MATCH") <> 1,"err_alert","")%>">
75 
                                    <%=rsTemp("pkg_version")%>
 79 
                                    <%=rsTemp("used_version")%>
76 
                            </td>
 80 
                            </td>
77 
                            <td background="images/bg_form_lightgray.gif" nowrap>
 81 
                            <td background="images/bg_form_lightgray.gif" nowrap>
78 
                            </td>
 82 
                            </td>
79 
                            <td background="images/bg_form_lightgray.gif" nowrap class="form_item">
 83 
                            <td background="images/bg_form_lightgray.gif" nowrap class="form_item">
80 
                              <a href="mailto:<%=rsTemp("user_email")%>" class="txt_linked"><%=enum_imgUser%><%=rsTemp("full_name")%></a>
 84 
                              <a href="mailto:<%=rsTemp("user_email")%>" class="txt_linked"><%=enum_imgUser%><%=rsTemp("full_name")%></a>