APPS.XNP_SV_ORDERS$SOA_SV dependencies on XNP_SV_ORDERS$SOA_SV

Line 1: package body xnp_sv_orders$soa_sv as

1: package body xnp_sv_orders$soa_sv as
2: /* $Header: XNPSVO2B.pls 120.0 2005/05/30 11:52:54 appldev noship $ */
3:
4:
5: procedure FormView(Z_FORM_STATUS in number);

Line 176: -- Name: xnp_sv_orders$soa_sv.InitialiseDomain

172: D_PTO_FLAG XNP_WSGL.typDVRecord;
173: D_RETAIN_TN_FLAG XNP_WSGL.typDVRecord;
174: D_BLOCKED_FLAG XNP_WSGL.typDVRecord;
175: --------------------------------------------------------------------------------
176: -- Name: xnp_sv_orders$soa_sv.InitialiseDomain
177: --
178: -- Description: Initialises the Domain Record for the given Column Usage
179: --
180: -- Parameters: P_ALIAS The alias of the column usage

Line 321: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.InitialseDomain');

317:
318: exception
319: when others then
320: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
321: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.InitialseDomain');
322: end;
323:
324: --------------------------------------------------------------------------------
325: -- Name: xnp_sv_orders$soa_sv.Startup

Line 325: -- Name: xnp_sv_orders$soa_sv.Startup

321: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.InitialseDomain');
322: end;
323:
324: --------------------------------------------------------------------------------
325: -- Name: xnp_sv_orders$soa_sv.Startup
326: --
327: -- Description: Entry point for the 'SOA_SV' module
328: -- component (Porting Ordering Subscriptions).
329: --

Line 338: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.startup');

334: Z_DIRECT_CALL in boolean,
335: Z_CHK in varchar2) is
336: begin
337:
338: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.startup');
339: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
340:
341: if not Z_DIRECT_CALL then
342: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

Line 356: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.Startup');

352:
353: exception
354: when others then
355: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
356: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.Startup');
357: end;
358:
359: --------------------------------------------------------------------------------
360: -- Name: xnp_sv_orders$soa_sv.ActionQuery

Line 360: -- Name: xnp_sv_orders$soa_sv.ActionQuery

356: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.Startup');
357: end;
358:
359: --------------------------------------------------------------------------------
360: -- Name: xnp_sv_orders$soa_sv.ActionQuery
361: --
362: -- Description: Called when a Query form is subitted to action the query request.
363: --
364: -- Parameters:

Line 443: htp.p('

439: htp.noframesOpen;
440: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_INFORMATION, XNP_WSGL.MsgGetText(229,XNP_WSGLM.MSG229_NO_FRAME_SUPPORT),
441: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', DEF_BODY_ATTRIBUTES);
442: htp.noframesClose;
443: htp.p('
444:
445:
446:
447:

Line 445:

441: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', DEF_BODY_ATTRIBUTES);
442: htp.noframesClose;
443: htp.p('
444:
445:
446:
447:
448:
449:

Line 446:

442: htp.noframesClose;
443: htp.p('
444:
445:
446:
447:
448:
449:
450:

Line 448:

444:
445:
446:
447:
448:
449:
450:
451: ');
452: --if on the query form and insert is allowed

Line 457: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.ActionQuery');

453:
454: exception
455: when others then
456: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
457: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.ActionQuery');
458: end;
459:
460: --------------------------------------------------------------------------------
461: -- Name: xnp_sv_orders$soa_sv.TextFrame

Line 461: -- Name: xnp_sv_orders$soa_sv.TextFrame

457: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.ActionQuery');
458: end;
459:
460: --------------------------------------------------------------------------------
461: -- Name: xnp_sv_orders$soa_sv.TextFrame
462: --
463: -- Description:
464: --
465: -- Parameters:

Line 519: TF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.TextFrame');

515:
516: exception
517: when others then
518: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
519: TF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.TextFrame');
520: XNP_WSGL.ClosePageBody;
521: end;
522: --------------------------------------------------------------------------------
523: -- Name: xnp_sv_orders$soa_sv.QueryHits

Line 523: -- Name: xnp_sv_orders$soa_sv.QueryHits

519: TF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.TextFrame');
520: XNP_WSGL.ClosePageBody;
521: end;
522: --------------------------------------------------------------------------------
523: -- Name: xnp_sv_orders$soa_sv.QueryHits
524: --
525: -- Description: Returns the number or rows which matches the given search
526: -- criteria (if any).
527: --

Line 596: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.QueryHits');

592:
593: exception
594: when others then
595: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
596: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.QueryHits');
597: return -1;
598: end;--------------------------------------------------------------------------------
599: -- Name: xnp_sv_orders$soa_sv.BuildSQL
600: --

Line 599: -- Name: xnp_sv_orders$soa_sv.BuildSQL

595: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
596: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.QueryHits');
597: return -1;
598: end;--------------------------------------------------------------------------------
599: -- Name: xnp_sv_orders$soa_sv.BuildSQL
600: --
601: -- Description: Builds the SQL for the 'SOA_SV' module component (Porting Ordering Subscriptions).
602: -- This incorporates all query criteria and Foreign key columns.
603: --

Line 649: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.BuildSQL');

645:
646: exception
647: when others then
648: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
649: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.BuildSQL');
650: return false;
651: end;
652:
653:

Line 655: -- Name: xnp_sv_orders$soa_sv.FormQuery

651: end;
652:
653:
654: --------------------------------------------------------------------------------
655: -- Name: xnp_sv_orders$soa_sv.FormQuery
656: --
657: -- Description: This procedure builds an HTML form for entry of query criteria.
658: -- The criteria entered are to restrict the query of the 'SOA_SV'
659: -- module component (Porting Ordering Subscriptions).

Line 689: htp.formOpen(curl => 'xnp_sv_orders$soa_sv.actionquery', cattributes => 'NAME="frmZero"');

685: htp.para;
686: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Porting Ordering Subscriptions'));
687: htp.para;
688:
689: htp.formOpen(curl => 'xnp_sv_orders$soa_sv.actionquery', cattributes => 'NAME="frmZero"');
690:
691: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
692:
693: XNP_WSGL.LayoutRowStart;

Line 770: QF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.FormQuery');

766:
767: exception
768: when others then
769: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
770: QF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.FormQuery');
771: XNP_WSGL.ClosePageBody;
772: end;
773:
774: --------------------------------------------------------------------------------

Line 775: -- Name: xnp_sv_orders$soa_sv.FormView

771: XNP_WSGL.ClosePageBody;
772: end;
773:
774: --------------------------------------------------------------------------------
775: -- Name: xnp_sv_orders$soa_sv.FormView
776: --
777: -- Description: This procedure builds an HTML form for view/update of fields in
778: -- the 'SOA_SV' module component (Porting Ordering Subscriptions).
779: --

Line 1098: VF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.FormView');

1094:
1095: exception
1096: when others then
1097: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1098: VF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.FormView');
1099: XNP_WSGL.ClosePageBody;
1100: end;
1101:
1102: --------------------------------------------------------------------------------

Line 1103: -- Name: xnp_sv_orders$soa_sv.QueryView

1099: XNP_WSGL.ClosePageBody;
1100: end;
1101:
1102: --------------------------------------------------------------------------------
1103: -- Name: xnp_sv_orders$soa_sv.QueryView
1104: --
1105: -- Description: Queries the details of a single row in preparation for display.
1106: --
1107: -- Parameters:

Line 1118: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.queryview');

1114: Z_DIRECT_CALL in boolean,
1115: Z_CHK in varchar2) is
1116: begin
1117:
1118: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.queryview');
1119: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
1120: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1121: if not Z_DIRECT_CALL then
1122: if not XNP_WSGL.ValidateChecksum('' ||

Line 1277: VF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.QueryView');

1273: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),
1274: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);
1275: when others then
1276: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1277: VF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.QueryView');
1278: end;
1279: --------------------------------------------------------------------------------
1280: -- Name: xnp_sv_orders$soa_sv.QueryList
1281: --

Line 1280: -- Name: xnp_sv_orders$soa_sv.QueryList

1276: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1277: VF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.QueryView');
1278: end;
1279: --------------------------------------------------------------------------------
1280: -- Name: xnp_sv_orders$soa_sv.QueryList
1281: --
1282: -- Description: This procedure builds the Record list for the 'SOA_SV'
1283: -- module component (Porting Ordering Subscriptions).
1284: --

Line 1291: -- xnp_sv_orders$soa_sv.FormView procedure for display of more details

1287: -- Sets of records are displayed (10 records at a time)
1288: -- with Next/Previous buttons to get other record sets.
1289: --
1290: -- The first context column will be created as a link to the
1291: -- xnp_sv_orders$soa_sv.FormView procedure for display of more details
1292: -- of that particular row.
1293: --
1294: -- Parameters: P_PORTING_ID - Porting ID
1295: -- P_SUBSCRIPTION_TYPE - Subscription Type

Line 1339: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.querylist');

1335: L_CHECKSUM varchar2(10);
1336:
1337: begin
1338:
1339: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.querylist');
1340: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1341: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1342: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1343: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);

Line 1496: XNP_WSGL.LayoutData(htf.anchor2('xnp_sv_orders$soa_sv.queryview?P_SV_SOA_ID='||CURR_VAL.SV_SOA_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.PORTING_ID, ctarget=>L_VF_FRAME));

1492: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_SOA_ID));
1493:
1494:
1495: XNP_WSGL.LayoutRowStart('TOP');
1496: XNP_WSGL.LayoutData(htf.anchor2('xnp_sv_orders$soa_sv.queryview?P_SV_SOA_ID='||CURR_VAL.SV_SOA_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.PORTING_ID, ctarget=>L_VF_FRAME));
1497: XNP_WSGL.LayoutData(CURR_VAL.SUBSCRIPTION_TN);
1498: XNP_WSGL.LayoutData(CURR_VAL.STATUS_DISPLAY_NAME);
1499: XNP_WSGL.LayoutRowEnd;
1500:

Line 1534: htp.formOpen(curl => 'xnp_sv_orders$soa_sv.querylist', cattributes => 'NAME="frmZero"');

1530: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
1531: dbms_sql.close_cursor(I_CURSOR);
1532: end if;
1533:
1534: htp.formOpen(curl => 'xnp_sv_orders$soa_sv.querylist', cattributes => 'NAME="frmZero"');
1535: XNP_WSGL.HiddenField('P_PORTING_ID', P_PORTING_ID);
1536: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1537: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1538: XNP_WSGL.HiddenField('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);

Line 1565: htp.formOpen(curl => 'xnp_sv_orders$soa_sv.querylist', ctarget=>'_top', cattributes => 'NAME="frmOne"');

1561: XNP_WSGL.HiddenField('Z_CHK',
1562: to_char(XNP_WSGL.Checksum('')));
1563: htp.formClose;
1564:
1565: htp.formOpen(curl => 'xnp_sv_orders$soa_sv.querylist', ctarget=>'_top', cattributes => 'NAME="frmOne"');
1566: htp.p ('');

Line 1592: RL_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.QueryList');

1588:
1589: exception
1590: when others then
1591: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1592: RL_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.QueryList');
1593: XNP_WSGL.ClosePageBody;
1594: end;
1595:
1596: --------------------------------------------------------------------------------

Line 1597: -- Name: xnp_sv_orders$soa_sv.QueryFirst

1593: XNP_WSGL.ClosePageBody;
1594: end;
1595:
1596: --------------------------------------------------------------------------------
1597: -- Name: xnp_sv_orders$soa_sv.QueryFirst
1598: --
1599: -- Description: Finds the first row which matches the given search criteria
1600: -- (if any), and calls QueryView for that row
1601: --

Line 1625: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.queryfirst');

1621: I_ROWS_FETCHED integer := 0;
1622:
1623: begin
1624:
1625: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_sv.queryfirst');
1626: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1627: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1628: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1629: XNP_WSGL.AddURLParam('P_STATUS_DISPLAY_NAME', P_STATUS_DISPLAY_NAME);

Line 1695: xnp_sv_orders$soa_sv.QueryView(Z_DIRECT_CALL=>TRUE);

1691: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.PORTING_ID);
1692: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.SUBSCRIPTION_TN);
1693: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.STATUS_DISPLAY_NAME);
1694: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.SV_SOA_ID);
1695: xnp_sv_orders$soa_sv.QueryView(Z_DIRECT_CALL=>TRUE);
1696: end if;
1697:
1698: dbms_sql.close_cursor(I_CURSOR);
1699:

Line 1703: VF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.QueryFirst');

1699:
1700: exception
1701: when others then
1702: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1703: VF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.QueryFirst');
1704: XNP_WSGL.ClosePageBody;
1705: end;
1706:
1707: --------------------------------------------------------------------------------

Line 1708: -- Name: xnp_sv_orders$soa_sv.PreQuery

1704: XNP_WSGL.ClosePageBody;
1705: end;
1706:
1707: --------------------------------------------------------------------------------
1708: -- Name: xnp_sv_orders$soa_sv.PreQuery
1709: --
1710: -- Description: Provides place holder for code to be run prior to a query
1711: -- for the 'SOA_SV' module component (Porting Ordering Subscriptions).
1712: --

Line 1735: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.PreQuery');

1731: return L_RET_VAL;
1732: exception
1733: when others then
1734: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1735: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.PreQuery');
1736: return FALSE;
1737: end;
1738:
1739: --------------------------------------------------------------------------------

Line 1740: -- Name: xnp_sv_orders$soa_sv.PostQuery

1736: return FALSE;
1737: end;
1738:
1739: --------------------------------------------------------------------------------
1740: -- Name: xnp_sv_orders$soa_sv.PostQuery
1741: --
1742: -- Description: Provides place holder for code to be run after a query
1743: -- for the 'SOA_SV' module component (Porting Ordering Subscriptions).
1744: --

Line 1758: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.PostQuery');

1754: return L_RET_VAL;
1755: exception
1756: when others then
1757: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1758: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.PostQuery');
1759: return FALSE;
1760: end;
1761:
1762: --------------------------------------------------------------------------------

Line 1763: -- Name: xnp_sv_orders$soa_sv.CreateQueryJavaScript

1759: return FALSE;
1760: end;
1761:
1762: --------------------------------------------------------------------------------
1763: -- Name: xnp_sv_orders$soa_sv.CreateQueryJavaScript
1764: --
1765: -- Description:
1766: --
1767: -- Parameters:

Line 1778: QF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.CreateQueryJavaScript');

1774: htp.p(XNP_WSGJSL.CloseScript);
1775: exception
1776: when others then
1777: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1778: QF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.CreateQueryJavaScript');
1779: end;
1780:
1781: --------------------------------------------------------------------------------
1782: -- Name: xnp_sv_orders$soa_sv.CreateListJavaScript

Line 1782: -- Name: xnp_sv_orders$soa_sv.CreateListJavaScript

1778: QF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.CreateQueryJavaScript');
1779: end;
1780:
1781: --------------------------------------------------------------------------------
1782: -- Name: xnp_sv_orders$soa_sv.CreateListJavaScript
1783: --
1784: -- Description:
1785: --
1786: -- Parameters:

Line 1797: RL_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.CreateListJavaScript');

1793: htp.p(XNP_WSGJSL.CloseScript);
1794: exception
1795: when others then
1796: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions',
1797: RL_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.CreateListJavaScript');
1798: end;
1799: end;