226: v_secondDelimLoc := INSTR (v_revisionDetails, ' ', 1, 7);
227: v_shipStatus := SUBSTR (v_revisionDetails, (v_firstDelimLoc + 1), ((v_secondDelimLoc)-(v_firstDelimLoc + 1)));
228:
229: -- Building the table of revision information
230: htp.htmlOpen;
231: -- ADI_Header_Footer.htmlhead ('Revision: ' || v_packageName);
232: htp.bodyOpen;
233: -- ADI_Header_Footer.pagebanner ('Package Revision Details', 'WEBR.REVI');
234: htp.para;
228:
229: -- Building the table of revision information
230: htp.htmlOpen;
231: -- ADI_Header_Footer.htmlhead ('Revision: ' || v_packageName);
232: htp.bodyOpen;
233: -- ADI_Header_Footer.pagebanner ('Package Revision Details', 'WEBR.REVI');
234: htp.para;
235:
236: htp.tableOpen ('BORDER=1', null, null, null, 'CELLPADDING=6');
230: htp.htmlOpen;
231: -- ADI_Header_Footer.htmlhead ('Revision: ' || v_packageName);
232: htp.bodyOpen;
233: -- ADI_Header_Footer.pagebanner ('Package Revision Details', 'WEBR.REVI');
234: htp.para;
235:
236: htp.tableOpen ('BORDER=1', null, null, null, 'CELLPADDING=6');
237:
238: htp.tableRowOpen;
232: htp.bodyOpen;
233: -- ADI_Header_Footer.pagebanner ('Package Revision Details', 'WEBR.REVI');
234: htp.para;
235:
236: htp.tableOpen ('BORDER=1', null, null, null, 'CELLPADDING=6');
237:
238: htp.tableRowOpen;
239: htp.tableHeader (' Package Revision Details ', 'CENTER', null, 'NOWRAP', null, 2, 'BGCOLOR=#336699');
240: htp.tableRowClose;
234: htp.para;
235:
236: htp.tableOpen ('BORDER=1', null, null, null, 'CELLPADDING=6');
237:
238: htp.tableRowOpen;
239: htp.tableHeader (' Package Revision Details ', 'CENTER', null, 'NOWRAP', null, 2, 'BGCOLOR=#336699');
240: htp.tableRowClose;
241:
242: htp.tableRowOpen;
235:
236: htp.tableOpen ('BORDER=1', null, null, null, 'CELLPADDING=6');
237:
238: htp.tableRowOpen;
239: htp.tableHeader (' Package Revision Details ', 'CENTER', null, 'NOWRAP', null, 2, 'BGCOLOR=#336699');
240: htp.tableRowClose;
241:
242: htp.tableRowOpen;
243: htp.tableData (htf.strong ('Filename'), 'LEFT', null, 'NOWRAP', null, null, null);
236: htp.tableOpen ('BORDER=1', null, null, null, 'CELLPADDING=6');
237:
238: htp.tableRowOpen;
239: htp.tableHeader (' Package Revision Details ', 'CENTER', null, 'NOWRAP', null, 2, 'BGCOLOR=#336699');
240: htp.tableRowClose;
241:
242: htp.tableRowOpen;
243: htp.tableData (htf.strong ('Filename'), 'LEFT', null, 'NOWRAP', null, null, null);
244: htp.tableData (v_fileName, 'LEFT', null, 'NOWRAP', null, null, null);
238: htp.tableRowOpen;
239: htp.tableHeader (' Package Revision Details ', 'CENTER', null, 'NOWRAP', null, 2, 'BGCOLOR=#336699');
240: htp.tableRowClose;
241:
242: htp.tableRowOpen;
243: htp.tableData (htf.strong ('Filename'), 'LEFT', null, 'NOWRAP', null, null, null);
244: htp.tableData (v_fileName, 'LEFT', null, 'NOWRAP', null, null, null);
245: htp.tableRowClose;
246:
239: htp.tableHeader (' Package Revision Details ', 'CENTER', null, 'NOWRAP', null, 2, 'BGCOLOR=#336699');
240: htp.tableRowClose;
241:
242: htp.tableRowOpen;
243: htp.tableData (htf.strong ('Filename'), 'LEFT', null, 'NOWRAP', null, null, null);
244: htp.tableData (v_fileName, 'LEFT', null, 'NOWRAP', null, null, null);
245: htp.tableRowClose;
246:
247: htp.tableRowOpen;
240: htp.tableRowClose;
241:
242: htp.tableRowOpen;
243: htp.tableData (htf.strong ('Filename'), 'LEFT', null, 'NOWRAP', null, null, null);
244: htp.tableData (v_fileName, 'LEFT', null, 'NOWRAP', null, null, null);
245: htp.tableRowClose;
246:
247: htp.tableRowOpen;
248: htp.tableData (htf.strong ('Package'), 'LEFT', null, 'NOWRAP', null, null, null);
241:
242: htp.tableRowOpen;
243: htp.tableData (htf.strong ('Filename'), 'LEFT', null, 'NOWRAP', null, null, null);
244: htp.tableData (v_fileName, 'LEFT', null, 'NOWRAP', null, null, null);
245: htp.tableRowClose;
246:
247: htp.tableRowOpen;
248: htp.tableData (htf.strong ('Package'), 'LEFT', null, 'NOWRAP', null, null, null);
249: htp.tableData (v_packageName, 'LEFT', null, 'NOWRAP', null, null, null);
243: htp.tableData (htf.strong ('Filename'), 'LEFT', null, 'NOWRAP', null, null, null);
244: htp.tableData (v_fileName, 'LEFT', null, 'NOWRAP', null, null, null);
245: htp.tableRowClose;
246:
247: htp.tableRowOpen;
248: htp.tableData (htf.strong ('Package'), 'LEFT', null, 'NOWRAP', null, null, null);
249: htp.tableData (v_packageName, 'LEFT', null, 'NOWRAP', null, null, null);
250: htp.tableRowClose;
251:
244: htp.tableData (v_fileName, 'LEFT', null, 'NOWRAP', null, null, null);
245: htp.tableRowClose;
246:
247: htp.tableRowOpen;
248: htp.tableData (htf.strong ('Package'), 'LEFT', null, 'NOWRAP', null, null, null);
249: htp.tableData (v_packageName, 'LEFT', null, 'NOWRAP', null, null, null);
250: htp.tableRowClose;
251:
252: htp.tableRowOpen;
245: htp.tableRowClose;
246:
247: htp.tableRowOpen;
248: htp.tableData (htf.strong ('Package'), 'LEFT', null, 'NOWRAP', null, null, null);
249: htp.tableData (v_packageName, 'LEFT', null, 'NOWRAP', null, null, null);
250: htp.tableRowClose;
251:
252: htp.tableRowOpen;
253: htp.tableData (htf.strong ('Version'), 'LEFT', null, 'NOWRAP', null, null, null);
246:
247: htp.tableRowOpen;
248: htp.tableData (htf.strong ('Package'), 'LEFT', null, 'NOWRAP', null, null, null);
249: htp.tableData (v_packageName, 'LEFT', null, 'NOWRAP', null, null, null);
250: htp.tableRowClose;
251:
252: htp.tableRowOpen;
253: htp.tableData (htf.strong ('Version'), 'LEFT', null, 'NOWRAP', null, null, null);
254: htp.tableData (v_versionNumber, 'LEFT', null, 'NOWRAP', null, null, null);
248: htp.tableData (htf.strong ('Package'), 'LEFT', null, 'NOWRAP', null, null, null);
249: htp.tableData (v_packageName, 'LEFT', null, 'NOWRAP', null, null, null);
250: htp.tableRowClose;
251:
252: htp.tableRowOpen;
253: htp.tableData (htf.strong ('Version'), 'LEFT', null, 'NOWRAP', null, null, null);
254: htp.tableData (v_versionNumber, 'LEFT', null, 'NOWRAP', null, null, null);
255: htp.tableRowClose;
256:
249: htp.tableData (v_packageName, 'LEFT', null, 'NOWRAP', null, null, null);
250: htp.tableRowClose;
251:
252: htp.tableRowOpen;
253: htp.tableData (htf.strong ('Version'), 'LEFT', null, 'NOWRAP', null, null, null);
254: htp.tableData (v_versionNumber, 'LEFT', null, 'NOWRAP', null, null, null);
255: htp.tableRowClose;
256:
257: htp.tableRowOpen;
250: htp.tableRowClose;
251:
252: htp.tableRowOpen;
253: htp.tableData (htf.strong ('Version'), 'LEFT', null, 'NOWRAP', null, null, null);
254: htp.tableData (v_versionNumber, 'LEFT', null, 'NOWRAP', null, null, null);
255: htp.tableRowClose;
256:
257: htp.tableRowOpen;
258: htp.tableData (htf.strong ('Checked In'), 'LEFT', null, 'NOWRAP', null, null, null);
251:
252: htp.tableRowOpen;
253: htp.tableData (htf.strong ('Version'), 'LEFT', null, 'NOWRAP', null, null, null);
254: htp.tableData (v_versionNumber, 'LEFT', null, 'NOWRAP', null, null, null);
255: htp.tableRowClose;
256:
257: htp.tableRowOpen;
258: htp.tableData (htf.strong ('Checked In'), 'LEFT', null, 'NOWRAP', null, null, null);
259: htp.tableData (v_dateCheckedIn, 'LEFT', null, 'NOWRAP', null, null, null);
253: htp.tableData (htf.strong ('Version'), 'LEFT', null, 'NOWRAP', null, null, null);
254: htp.tableData (v_versionNumber, 'LEFT', null, 'NOWRAP', null, null, null);
255: htp.tableRowClose;
256:
257: htp.tableRowOpen;
258: htp.tableData (htf.strong ('Checked In'), 'LEFT', null, 'NOWRAP', null, null, null);
259: htp.tableData (v_dateCheckedIn, 'LEFT', null, 'NOWRAP', null, null, null);
260: htp.tableRowClose;
261:
254: htp.tableData (v_versionNumber, 'LEFT', null, 'NOWRAP', null, null, null);
255: htp.tableRowClose;
256:
257: htp.tableRowOpen;
258: htp.tableData (htf.strong ('Checked In'), 'LEFT', null, 'NOWRAP', null, null, null);
259: htp.tableData (v_dateCheckedIn, 'LEFT', null, 'NOWRAP', null, null, null);
260: htp.tableRowClose;
261:
262: htp.tableRowOpen;
255: htp.tableRowClose;
256:
257: htp.tableRowOpen;
258: htp.tableData (htf.strong ('Checked In'), 'LEFT', null, 'NOWRAP', null, null, null);
259: htp.tableData (v_dateCheckedIn, 'LEFT', null, 'NOWRAP', null, null, null);
260: htp.tableRowClose;
261:
262: htp.tableRowOpen;
263: htp.tableData (htf.strong ('Ship Status'), 'LEFT', null, 'NOWRAP', null, null, null);
256:
257: htp.tableRowOpen;
258: htp.tableData (htf.strong ('Checked In'), 'LEFT', null, 'NOWRAP', null, null, null);
259: htp.tableData (v_dateCheckedIn, 'LEFT', null, 'NOWRAP', null, null, null);
260: htp.tableRowClose;
261:
262: htp.tableRowOpen;
263: htp.tableData (htf.strong ('Ship Status'), 'LEFT', null, 'NOWRAP', null, null, null);
264: htp.tableData (v_shipStatus, 'LEFT', null, 'NOWRAP', null, null, null);
258: htp.tableData (htf.strong ('Checked In'), 'LEFT', null, 'NOWRAP', null, null, null);
259: htp.tableData (v_dateCheckedIn, 'LEFT', null, 'NOWRAP', null, null, null);
260: htp.tableRowClose;
261:
262: htp.tableRowOpen;
263: htp.tableData (htf.strong ('Ship Status'), 'LEFT', null, 'NOWRAP', null, null, null);
264: htp.tableData (v_shipStatus, 'LEFT', null, 'NOWRAP', null, null, null);
265: htp.tableRowClose;
266:
259: htp.tableData (v_dateCheckedIn, 'LEFT', null, 'NOWRAP', null, null, null);
260: htp.tableRowClose;
261:
262: htp.tableRowOpen;
263: htp.tableData (htf.strong ('Ship Status'), 'LEFT', null, 'NOWRAP', null, null, null);
264: htp.tableData (v_shipStatus, 'LEFT', null, 'NOWRAP', null, null, null);
265: htp.tableRowClose;
266:
267: IF (LOWER (p_showOwner) = 'big_cheese') THEN
260: htp.tableRowClose;
261:
262: htp.tableRowOpen;
263: htp.tableData (htf.strong ('Ship Status'), 'LEFT', null, 'NOWRAP', null, null, null);
264: htp.tableData (v_shipStatus, 'LEFT', null, 'NOWRAP', null, null, null);
265: htp.tableRowClose;
266:
267: IF (LOWER (p_showOwner) = 'big_cheese') THEN
268: htp.tableRowOpen;
261:
262: htp.tableRowOpen;
263: htp.tableData (htf.strong ('Ship Status'), 'LEFT', null, 'NOWRAP', null, null, null);
264: htp.tableData (v_shipStatus, 'LEFT', null, 'NOWRAP', null, null, null);
265: htp.tableRowClose;
266:
267: IF (LOWER (p_showOwner) = 'big_cheese') THEN
268: htp.tableRowOpen;
269: htp.tableData (htf.strong ('Developer'), 'LEFT', null, 'NOWRAP', null, null, null);
264: htp.tableData (v_shipStatus, 'LEFT', null, 'NOWRAP', null, null, null);
265: htp.tableRowClose;
266:
267: IF (LOWER (p_showOwner) = 'big_cheese') THEN
268: htp.tableRowOpen;
269: htp.tableData (htf.strong ('Developer'), 'LEFT', null, 'NOWRAP', null, null, null);
270: htp.tableData (v_developer, 'LEFT', null, 'NOWRAP', null, null, null);
271: htp.tableRowClose;
272: END IF;
265: htp.tableRowClose;
266:
267: IF (LOWER (p_showOwner) = 'big_cheese') THEN
268: htp.tableRowOpen;
269: htp.tableData (htf.strong ('Developer'), 'LEFT', null, 'NOWRAP', null, null, null);
270: htp.tableData (v_developer, 'LEFT', null, 'NOWRAP', null, null, null);
271: htp.tableRowClose;
272: END IF;
273:
266:
267: IF (LOWER (p_showOwner) = 'big_cheese') THEN
268: htp.tableRowOpen;
269: htp.tableData (htf.strong ('Developer'), 'LEFT', null, 'NOWRAP', null, null, null);
270: htp.tableData (v_developer, 'LEFT', null, 'NOWRAP', null, null, null);
271: htp.tableRowClose;
272: END IF;
273:
274: htp.tableClose;
267: IF (LOWER (p_showOwner) = 'big_cheese') THEN
268: htp.tableRowOpen;
269: htp.tableData (htf.strong ('Developer'), 'LEFT', null, 'NOWRAP', null, null, null);
270: htp.tableData (v_developer, 'LEFT', null, 'NOWRAP', null, null, null);
271: htp.tableRowClose;
272: END IF;
273:
274: htp.tableClose;
275:
270: htp.tableData (v_developer, 'LEFT', null, 'NOWRAP', null, null, null);
271: htp.tableRowClose;
272: END IF;
273:
274: htp.tableClose;
275:
276: -- ADI_Header_Footer.pagefoot;
277:
278: END PackageRevision;