Subversion Repositories DevTools

Rev

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

Rev 5357 Rev 5384
Line 45... Line 45...
45 
   "       projects proj"&_
 45 
   "       projects proj"&_
46 
   " WHERE pv.pkg_id = pkg.pkg_id"&_
 46 
   " WHERE pv.pkg_id = pkg.pkg_id"&_
47 
   "   AND rc.pv_id = pv.pv_id"&_
 47 
   "   AND rc.pv_id = pv.pv_id"&_
48 
   "   AND rc.rtag_id = rt.rtag_id"&_
 48 
   "   AND rc.rtag_id = rt.rtag_id"&_
49 
   "   AND rt.proj_id = proj.proj_id "&_
 49 
   "   AND rt.proj_id = proj.proj_id "&_
50 
   "   AND rt.official = 'N'"&_
 50 
   "   AND rt.official not in ( 'A', 'P', 'Y', 'O')"&_
51 
   "   AND pv.pv_id IN ( "& NNpv_list &" )"&_
 51 
   "   AND pv.pv_id IN ( "& NNpv_list &" )"&_
52 
   " ORDER BY pv.pv_id, UPPER(pkg.pkg_name), UPPER(proj.proj_name) "
 52 
   " ORDER BY pv.pv_id, UPPER(pkg.pkg_name), UPPER(proj.proj_name) "
53 
End Function
 53 
End Function
54 
 
 54 
 
55 
 
 55 
 
Line 139... Line 139...
139 
          <td bgcolor="#FFFFFF" valign="top" class="form_item"> <br>
 139 
          <td bgcolor="#FFFFFF" valign="top" class="form_item"> <br>
140 
              Select new owner and click Apply.<br><br>
 140 
              Select new owner and click Apply.<br><br>
141 
              <table width="100%" border="0" cellspacing="1" cellpadding="2">
 141 
              <table width="100%" border="0" cellspacing="1" cellpadding="2">
142 
                <tr>
 142 
                <tr>
143 
                  <td width="1%" nowrap class="form_field">Package Name and Version&nbsp;</td>
 143 
                  <td width="1%" nowrap class="form_field">Package Name and Version&nbsp;</td>
144 
                  <td width="100%" class="form_field">Location</td>
 144 
                  <td width="100%" nowrap class="form_field">Location</td>
145 
                </tr>
 145 
                </tr>
146 
                <%
 146 
                <%
147 
            Set rsTemp = OraDatabase.DbCreateDynaset( Get_Packages( parPv_list ), cint(0))
 147 
            Set rsTemp = OraDatabase.DbCreateDynaset( Get_Packages( parPv_list ), cint(0))
148 
             While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
 148 
             While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
149 
            %>
 149 
            %>
150 
                <tr>
 150 
                <tr>
151 
                  <td class="form_item"><%=rsTemp("pkg_name") &" "& rsTemp("pkg_version")%></td>
 151 
                  <td nowrap class="form_item"><%=rsTemp("pkg_name") &" "& rsTemp("pkg_version")%></td>
152 
                  <td class="form_item"><%=rsTemp("proj_name") &" &gt; "& rsTemp("rtag_name") %></td>
 152 
                  <td nowrap class="form_item"><%=rsTemp("proj_name") &" &gt; "& rsTemp("rtag_name") %></td>
153 
                </tr>
 153 
                </tr>
154 
                <%rsTemp.MoveNext
 154 
                <%rsTemp.MoveNext
155 
              WEnd%>
 155 
              WEnd%>
156 
              </table>
 156 
              </table>
157 
              <br>
 157 
              <br>