APPS.XNP_SV_NETWORK$SMS_SV dependencies on XNP_SV_NETWORK$

Line 1: package body xnp_sv_network$sms_sv as

1: package body xnp_sv_network$sms_sv as
2: /* $Header: XNPSVN2B.pls 120.0 2005/05/30 11:52:10 appldev noship $ */
3:
4:
5: procedure FormView(Z_FORM_STATUS in number);

Line 130: -- Name: xnp_sv_network$sms_sv.InitialiseDomain

126:
127: D_SUBSCRIPTION_TYPE XNP_WSGL.typDVRecord;
128: D_INTERCONNECT_TYPE XNP_WSGL.typDVRecord;
129: --------------------------------------------------------------------------------
130: -- Name: xnp_sv_network$sms_sv.InitialiseDomain
131: --
132: -- Description: Initialises the Domain Record for the given Column Usage
133: --
134: -- Parameters: P_ALIAS The alias of the column usage

Line 167: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.InitialseDomain');

163:
164: exception
165: when others then
166: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
167: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.InitialseDomain');
168: end;
169:
170: --------------------------------------------------------------------------------
171: -- Name: xnp_sv_network$sms_sv.Startup

Line 171: -- Name: xnp_sv_network$sms_sv.Startup

167: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.InitialseDomain');
168: end;
169:
170: --------------------------------------------------------------------------------
171: -- Name: xnp_sv_network$sms_sv.Startup
172: --
173: -- Description: Entry point for the 'SMS_SV' module
174: -- component (Porting Network Subscriptions).
175: --

Line 184: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.startup');

180: Z_DIRECT_CALL in boolean,
181: Z_CHK in varchar2) is
182: begin
183:
184: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.startup');
185: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
186:
187: if not Z_DIRECT_CALL then
188: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

Line 202: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.Startup');

198:
199: exception
200: when others then
201: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
202: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.Startup');
203: end;
204:
205: --------------------------------------------------------------------------------
206: -- Name: xnp_sv_network$sms_sv.ActionQuery

Line 206: -- Name: xnp_sv_network$sms_sv.ActionQuery

202: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.Startup');
203: end;
204:
205: --------------------------------------------------------------------------------
206: -- Name: xnp_sv_network$sms_sv.ActionQuery
207: --
208: -- Description: Called when a Query form is subitted to action the query request.
209: --
210: -- Parameters:

Line 269: htp.p('

265: htp.noframesOpen;
266: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_INFORMATION, XNP_WSGL.MsgGetText(229,XNP_WSGLM.MSG229_NO_FRAME_SUPPORT),
267: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', DEF_BODY_ATTRIBUTES);
268: htp.noframesClose;
269: htp.p('
270:
271:
272:
273:

Line 271:

267: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', DEF_BODY_ATTRIBUTES);
268: htp.noframesClose;
269: htp.p('
270:
271:
272:
273:
274:
275:

Line 272:

268: htp.noframesClose;
269: htp.p('
270:
271:
272:
273:
274:
275:
276:

Line 274:

270:
271:
272:
273:
274:
275:
276:
277: ');
278: --if on the query form and insert is allowed

Line 283: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.ActionQuery');

279:
280: exception
281: when others then
282: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
283: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.ActionQuery');
284: end;
285:
286: --------------------------------------------------------------------------------
287: -- Name: xnp_sv_network$sms_sv.TextFrame

Line 287: -- Name: xnp_sv_network$sms_sv.TextFrame

283: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.ActionQuery');
284: end;
285:
286: --------------------------------------------------------------------------------
287: -- Name: xnp_sv_network$sms_sv.TextFrame
288: --
289: -- Description:
290: --
291: -- Parameters:

Line 319: xnp_sv_network$.TemplateHeader(TRUE,0);

315: L_ONLY_THING_IN_FRAME := (L_TEXT_TYPES = 1);
316:
317: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
318: L_ONLY_THING_IN_FRAME);
319: xnp_sv_network$.TemplateHeader(TRUE,0);
320: XNP_WSGL.ClosePageHead;
321:
322: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>TF_BODY_ATTRIBUTES);
323:

Line 329: xnp_sv_network$.FirstPage(TRUE);

325: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
326: end if;
327:
328: if Z_FIRST is not null then
329: xnp_sv_network$.FirstPage(TRUE);
330: end if;
331:
332: if Z_TEXT is not null then
333: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPSVNWK_DETAILS_TITLE')));

Line 345: TF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.TextFrame');

341:
342: exception
343: when others then
344: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
345: TF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.TextFrame');
346: XNP_WSGL.ClosePageBody;
347: end;
348: --------------------------------------------------------------------------------
349: -- Name: xnp_sv_network$sms_sv.QueryHits

Line 349: -- Name: xnp_sv_network$sms_sv.QueryHits

345: TF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.TextFrame');
346: XNP_WSGL.ClosePageBody;
347: end;
348: --------------------------------------------------------------------------------
349: -- Name: xnp_sv_network$sms_sv.QueryHits
350: --
351: -- Description: Returns the number or rows which matches the given search
352: -- criteria (if any).
353: --

Line 410: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.QueryHits');

406:
407: exception
408: when others then
409: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
410: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.QueryHits');
411: return -1;
412: end;--------------------------------------------------------------------------------
413: -- Name: xnp_sv_network$sms_sv.BuildSQL
414: --

Line 413: -- Name: xnp_sv_network$sms_sv.BuildSQL

409: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
410: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.QueryHits');
411: return -1;
412: end;--------------------------------------------------------------------------------
413: -- Name: xnp_sv_network$sms_sv.BuildSQL
414: --
415: -- Description: Builds the SQL for the 'SMS_SV' module component (Porting Network Subscriptions).
416: -- This incorporates all query criteria and Foreign key columns.
417: --

Line 454: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.BuildSQL');

450:
451: exception
452: when others then
453: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
454: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.BuildSQL');
455: return false;
456: end;
457:
458:

Line 460: -- Name: xnp_sv_network$sms_sv.FormQuery

456: end;
457:
458:
459: --------------------------------------------------------------------------------
460: -- Name: xnp_sv_network$sms_sv.FormQuery
461: --
462: -- Description: This procedure builds an HTML form for entry of query criteria.
463: -- The criteria entered are to restrict the query of the 'SMS_SV'
464: -- module component (Porting Network Subscriptions).

Line 482: xnp_sv_network$.TemplateHeader(TRUE,0);

478: end if;
479:
480: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions');
481: CreateQueryJavaScript;
482: xnp_sv_network$.TemplateHeader(TRUE,0);
483: XNP_WSGL.ClosePageHead;
484:
485: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>QF_BODY_ATTRIBUTES);
486:

Line 488: xnp_sv_network$.FirstPage(TRUE);

484:
485: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>QF_BODY_ATTRIBUTES);
486:
487: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
488: xnp_sv_network$.FirstPage(TRUE);
489: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPSVNWK_DETAILS_TITLE')));
490: htp.para;
491: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Porting Network Subscriptions'));
492: htp.para;

Line 494: htp.formOpen(curl => 'xnp_sv_network$sms_sv.actionquery', cattributes => 'NAME="frmZero"');

490: htp.para;
491: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Porting Network Subscriptions'));
492: htp.para;
493:
494: htp.formOpen(curl => 'xnp_sv_network$sms_sv.actionquery', cattributes => 'NAME="frmZero"');
495:
496: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
497:
498: XNP_WSGL.LayoutRowStart;

Line 559: QF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.FormQuery');

555:
556: exception
557: when others then
558: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
559: QF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.FormQuery');
560: XNP_WSGL.ClosePageBody;
561: end;
562:
563: --------------------------------------------------------------------------------

Line 564: -- Name: xnp_sv_network$sms_sv.FormView

560: XNP_WSGL.ClosePageBody;
561: end;
562:
563: --------------------------------------------------------------------------------
564: -- Name: xnp_sv_network$sms_sv.FormView
565: --
566: -- Description: This procedure builds an HTML form for view/update of fields in
567: -- the 'SMS_SV' module component (Porting Network Subscriptions).
568: --

Line 580: xnp_sv_network$.TemplateHeader(TRUE,0);

576:
577: begin
578:
579: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions');
580: xnp_sv_network$.TemplateHeader(TRUE,0);
581: XNP_WSGL.ClosePageHead;
582:
583: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);
584:

Line 750: 0, 'xnp_sv_network$sms_fe_map.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_FE_MAP_CHCK);

746: to_char(XNP_WSGL.Checksum(CURR_VAL.SV_SMS_ID));
747:
748:
749: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Provisioning Status',
750: 0, 'xnp_sv_network$sms_fe_map.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_FE_MAP_CHCK);
751: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Order Workitems',
752: 0, 'xnp_sv_network$sms_order.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_ORDER_CHCK);
753: XNP_WSGL.NavLinks;
754:

Line 752: 0, 'xnp_sv_network$sms_order.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_ORDER_CHCK);

748:
749: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Provisioning Status',
750: 0, 'xnp_sv_network$sms_fe_map.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_FE_MAP_CHCK);
751: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Order Workitems',
752: 0, 'xnp_sv_network$sms_order.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_ORDER_CHCK);
753: XNP_WSGL.NavLinks;
754:
755:
756: XNP_WSGL.ClosePageBody;

Line 761: VF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.FormView');

757:
758: exception
759: when others then
760: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
761: VF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.FormView');
762: XNP_WSGL.ClosePageBody;
763: end;
764:
765: --------------------------------------------------------------------------------

Line 766: -- Name: xnp_sv_network$sms_sv.QueryView

762: XNP_WSGL.ClosePageBody;
763: end;
764:
765: --------------------------------------------------------------------------------
766: -- Name: xnp_sv_network$sms_sv.QueryView
767: --
768: -- Description: Queries the details of a single row in preparation for display.
769: --
770: -- Parameters:

Line 781: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.queryview');

777: Z_DIRECT_CALL in boolean,
778: Z_CHK in varchar2) is
779: begin
780:
781: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.queryview');
782: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
783: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
784: if not Z_DIRECT_CALL then
785: if not XNP_WSGL.ValidateChecksum('' ||

Line 894: VF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.QueryView');

890: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),
891: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);
892: when others then
893: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
894: VF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.QueryView');
895: end;
896: --------------------------------------------------------------------------------
897: -- Name: xnp_sv_network$sms_sv.QueryList
898: --

Line 897: -- Name: xnp_sv_network$sms_sv.QueryList

893: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
894: VF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.QueryView');
895: end;
896: --------------------------------------------------------------------------------
897: -- Name: xnp_sv_network$sms_sv.QueryList
898: --
899: -- Description: This procedure builds the Record list for the 'SMS_SV'
900: -- module component (Porting Network Subscriptions).
901: --

Line 908: -- xnp_sv_network$sms_sv.FormView procedure for display of more details

904: -- Sets of records are displayed (10 records at a time)
905: -- with Next/Previous buttons to get other record sets.
906: --
907: -- The first context column will be created as a link to the
908: -- xnp_sv_network$sms_sv.FormView procedure for display of more details
909: -- of that particular row.
910: --
911: -- Parameters: P_PORTING_ID - Porting ID
912: -- P_SUBSCRIPTION_TYPE - Subscription Type

Line 948: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.querylist');

944: L_CHECKSUM varchar2(10);
945:
946: begin
947:
948: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.querylist');
949: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
950: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
951: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
952: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);

Line 971: xnp_sv_network$.TemplateHeader(TRUE,0);

967: end if;
968:
969: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions');
970: CreateListJavaScript;
971: xnp_sv_network$.TemplateHeader(TRUE,0);
972: XNP_WSGL.ClosePageHead;
973:
974: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
975:

Line 1089: XNP_WSGL.LayoutData(htf.anchor2('xnp_sv_network$sms_sv.queryview?P_SV_SMS_ID='||CURR_VAL.SV_SMS_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.PORTING_ID, ctarget=>L_VF_FRAME));

1085: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_SMS_ID));
1086:
1087:
1088: XNP_WSGL.LayoutRowStart('TOP');
1089: XNP_WSGL.LayoutData(htf.anchor2('xnp_sv_network$sms_sv.queryview?P_SV_SMS_ID='||CURR_VAL.SV_SMS_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.PORTING_ID, ctarget=>L_VF_FRAME));
1090: XNP_WSGL.LayoutData(CURR_VAL.SUBSCRIPTION_TN);
1091: XNP_WSGL.LayoutData(CURR_VAL.ROUTING_NUMBER);
1092: XNP_WSGL.LayoutRowEnd;
1093:

Line 1127: htp.formOpen(curl => 'xnp_sv_network$sms_sv.querylist', cattributes => 'NAME="frmZero"');

1123: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
1124: dbms_sql.close_cursor(I_CURSOR);
1125: end if;
1126:
1127: htp.formOpen(curl => 'xnp_sv_network$sms_sv.querylist', cattributes => 'NAME="frmZero"');
1128: XNP_WSGL.HiddenField('P_PORTING_ID', P_PORTING_ID);
1129: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1130: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1131: XNP_WSGL.HiddenField('P_NRC_CODE', P_NRC_CODE);

Line 1154: htp.formOpen(curl => 'xnp_sv_network$sms_sv.querylist', ctarget=>'_top', cattributes => 'NAME="frmOne"');

1150: XNP_WSGL.HiddenField('Z_CHK',
1151: to_char(XNP_WSGL.Checksum('')));
1152: htp.formClose;
1153:
1154: htp.formOpen(curl => 'xnp_sv_network$sms_sv.querylist', ctarget=>'_top', cattributes => 'NAME="frmOne"');
1155: htp.p ('');

Line 1181: RL_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.QueryList');

1177:
1178: exception
1179: when others then
1180: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
1181: RL_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.QueryList');
1182: XNP_WSGL.ClosePageBody;
1183: end;
1184:
1185: --------------------------------------------------------------------------------

Line 1186: -- Name: xnp_sv_network$sms_sv.QueryFirst

1182: XNP_WSGL.ClosePageBody;
1183: end;
1184:
1185: --------------------------------------------------------------------------------
1186: -- Name: xnp_sv_network$sms_sv.QueryFirst
1187: --
1188: -- Description: Finds the first row which matches the given search criteria
1189: -- (if any), and calls QueryView for that row
1190: --

Line 1210: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.queryfirst');

1206: I_ROWS_FETCHED integer := 0;
1207:
1208: begin
1209:
1210: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.queryfirst');
1211: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1212: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1213: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1214: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);

Line 1268: xnp_sv_network$sms_sv.QueryView(Z_DIRECT_CALL=>TRUE);

1264: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1265: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.PORTING_ID);
1266: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN);
1267: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER);
1268: xnp_sv_network$sms_sv.QueryView(Z_DIRECT_CALL=>TRUE);
1269: end if;
1270:
1271: dbms_sql.close_cursor(I_CURSOR);
1272:

Line 1276: VF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.QueryFirst');

1272:
1273: exception
1274: when others then
1275: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
1276: VF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.QueryFirst');
1277: XNP_WSGL.ClosePageBody;
1278: end;
1279:
1280: --------------------------------------------------------------------------------

Line 1281: -- Name: xnp_sv_network$sms_sv.PreQuery

1277: XNP_WSGL.ClosePageBody;
1278: end;
1279:
1280: --------------------------------------------------------------------------------
1281: -- Name: xnp_sv_network$sms_sv.PreQuery
1282: --
1283: -- Description: Provides place holder for code to be run prior to a query
1284: -- for the 'SMS_SV' module component (Porting Network Subscriptions).
1285: --

Line 1304: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.PreQuery');

1300: return L_RET_VAL;
1301: exception
1302: when others then
1303: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
1304: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.PreQuery');
1305: return FALSE;
1306: end;
1307:
1308: --------------------------------------------------------------------------------

Line 1309: -- Name: xnp_sv_network$sms_sv.PostQuery

1305: return FALSE;
1306: end;
1307:
1308: --------------------------------------------------------------------------------
1309: -- Name: xnp_sv_network$sms_sv.PostQuery
1310: --
1311: -- Description: Provides place holder for code to be run after a query
1312: -- for the 'SMS_SV' module component (Porting Network Subscriptions).
1313: --

Line 1327: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.PostQuery');

1323: return L_RET_VAL;
1324: exception
1325: when others then
1326: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
1327: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.PostQuery');
1328: return FALSE;
1329: end;
1330:
1331: --------------------------------------------------------------------------------

Line 1332: -- Name: xnp_sv_network$sms_sv.CreateQueryJavaScript

1328: return FALSE;
1329: end;
1330:
1331: --------------------------------------------------------------------------------
1332: -- Name: xnp_sv_network$sms_sv.CreateQueryJavaScript
1333: --
1334: -- Description:
1335: --
1336: -- Parameters:

Line 1347: QF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.CreateQueryJavaScript');

1343: htp.p(XNP_WSGJSL.CloseScript);
1344: exception
1345: when others then
1346: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
1347: QF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.CreateQueryJavaScript');
1348: end;
1349:
1350: --------------------------------------------------------------------------------
1351: -- Name: xnp_sv_network$sms_sv.CreateListJavaScript

Line 1351: -- Name: xnp_sv_network$sms_sv.CreateListJavaScript

1347: QF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.CreateQueryJavaScript');
1348: end;
1349:
1350: --------------------------------------------------------------------------------
1351: -- Name: xnp_sv_network$sms_sv.CreateListJavaScript
1352: --
1353: -- Description:
1354: --
1355: -- Parameters:

Line 1366: RL_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.CreateListJavaScript');

1362: htp.p(XNP_WSGJSL.CloseScript);
1363: exception
1364: when others then
1365: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
1366: RL_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.CreateListJavaScript');
1367: end;
1368: end;