eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XNP_NUMBER_SPLITS$NUMBER_SPLIT dependencies on XNP_NUMBER_SPLITS$NUMBER_SPLIT

Line 1: package body xnp_number_splits$number_split as

1: package body xnp_number_splits$number_split as
2: /* $Header: XNPNUM2B.pls 120.1 2005/06/21 04:10:54 appldev ship $ */
3:
4:
5: procedure FormView(Z_FORM_STATUS in number);

Line 116: -- Name: xnp_number_splits$number_split.NEW_NUMBER_RANGE_ID_TranslateF

112:
113: ZONE_SQL VARCHAR2(3300) := null;
114:
115: --------------------------------------------------------------------------------
116: -- Name: xnp_number_splits$number_split.NEW_NUMBER_RANGE_ID_TranslateF
117: --
118: -- Description:
119: --
120: -- Parameters:

Line 141: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.NEW_NUMBER_RANGE_ID_TranslateF');

137: exception
138: when no_data_found then
139: XNP_cg$errors.push('New Range, New Range Starting Number, New Range Ending Number: '||
140: XNP_WSGL.MsgGetText(226,XNP_WSGLM.MSG226_INVALID_FK),
141: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.NEW_NUMBER_RANGE_ID_TranslateF');
142: return FALSE;
143: when too_many_rows then
144: XNP_cg$errors.push('New Range, New Range Starting Number, New Range Ending Number: '||
145: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),

Line 146: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.NEW_NUMBER_RANGE_ID_TranslateF');

142: return FALSE;
143: when too_many_rows then
144: XNP_cg$errors.push('New Range, New Range Starting Number, New Range Ending Number: '||
145: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),
146: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.NEW_NUMBER_RANGE_ID_TranslateF');
147: return FALSE;
148: when others then
149: XNP_cg$errors.push('New Range, New Range Starting Number, New Range Ending Number: '||SQLERRM,
150: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.NEW_NUMBER_RANGE_ID_TranslateF');

Line 150: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.NEW_NUMBER_RANGE_ID_TranslateF');

146: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.NEW_NUMBER_RANGE_ID_TranslateF');
147: return FALSE;
148: when others then
149: XNP_cg$errors.push('New Range, New Range Starting Number, New Range Ending Number: '||SQLERRM,
150: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.NEW_NUMBER_RANGE_ID_TranslateF');
151: return FALSE;
152: end;
153: --------------------------------------------------------------------------------
154: -- Name: xnp_number_splits$number_split.OLD_NUMBER_RANGE_ID_TranslateF

Line 154: -- Name: xnp_number_splits$number_split.OLD_NUMBER_RANGE_ID_TranslateF

150: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.NEW_NUMBER_RANGE_ID_TranslateF');
151: return FALSE;
152: end;
153: --------------------------------------------------------------------------------
154: -- Name: xnp_number_splits$number_split.OLD_NUMBER_RANGE_ID_TranslateF
155: --
156: -- Description:
157: --
158: -- Parameters:

Line 179: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.OLD_NUMBER_RANGE_ID_TranslateF');

175: exception
176: when no_data_found then
177: XNP_cg$errors.push('Initial Range, Initial Range Starting Number, Initial Range Ending Number: '||
178: XNP_WSGL.MsgGetText(226,XNP_WSGLM.MSG226_INVALID_FK),
179: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.OLD_NUMBER_RANGE_ID_TranslateF');
180: return FALSE;
181: when too_many_rows then
182: XNP_cg$errors.push('Initial Range, Initial Range Starting Number, Initial Range Ending Number: '||
183: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),

Line 184: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.OLD_NUMBER_RANGE_ID_TranslateF');

180: return FALSE;
181: when too_many_rows then
182: XNP_cg$errors.push('Initial Range, Initial Range Starting Number, Initial Range Ending Number: '||
183: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),
184: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.OLD_NUMBER_RANGE_ID_TranslateF');
185: return FALSE;
186: when others then
187: XNP_cg$errors.push('Initial Range, Initial Range Starting Number, Initial Range Ending Number: '||SQLERRM,
188: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.OLD_NUMBER_RANGE_ID_TranslateF');

Line 188: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.OLD_NUMBER_RANGE_ID_TranslateF');

184: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.OLD_NUMBER_RANGE_ID_TranslateF');
185: return FALSE;
186: when others then
187: XNP_cg$errors.push('Initial Range, Initial Range Starting Number, Initial Range Ending Number: '||SQLERRM,
188: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.OLD_NUMBER_RANGE_ID_TranslateF');
189: return FALSE;
190: end;
191: --------------------------------------------------------------------------------
192: -- Name: xnp_number_splits$number_split.l_nre2_object_reference_listof

Line 192: -- Name: xnp_number_splits$number_split.l_nre2_object_reference_listof

188: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.OLD_NUMBER_RANGE_ID_TranslateF');
189: return FALSE;
190: end;
191: --------------------------------------------------------------------------------
192: -- Name: xnp_number_splits$number_split.l_nre2_object_reference_listof
193: --
194: -- Description:
195: --
196: -- Parameters:

Line 211: XNP_WSGL.RegisterURL('xnp_number_splits$number_split.l_nre2_object_reference_listof');

207: L_ANY boolean := FALSE;
208: L_BODY_ATTRIBUTES VarChar2 (1000) := LOV_BODY_ATTRIBUTES;
209: begin
210:
211: XNP_WSGL.RegisterURL('xnp_number_splits$number_split.l_nre2_object_reference_listof');
212: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
213: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
214: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
215: if XNP_WSGL.NotLowerCase then

Line 271: htp.formOpen('xnp_number_splits$number_split.l_nre2_object_reference_listof');

267: htp.p(XNP_WSGL.MsgGetText(127,XNP_WSGLM.DSP127_LOV_PLEASE_WAIT));
268: XNP_WSGL.ClosePageBody;
269: return;
270: else
271: htp.formOpen('xnp_number_splits$number_split.l_nre2_object_reference_listof');
272: XNP_WSGL.HiddenField('Z_CALLER_URL', Z_CALLER_URL);
273: XNP_WSGL.HiddenField('Z_MODE', Z_MODE);
274: end if;
275:

Line 344: LOV_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.l_nre2_object_reference_listof');

340:
341: exception
342: when others then
343: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits',
344: LOV_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.l_nre2_object_reference_listof');
345: end;
346:
347: --------------------------------------------------------------------------------
348: -- Name: xnp_number_splits$number_split.l_nre_object_reference_listofv

Line 348: -- Name: xnp_number_splits$number_split.l_nre_object_reference_listofv

344: LOV_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.l_nre2_object_reference_listof');
345: end;
346:
347: --------------------------------------------------------------------------------
348: -- Name: xnp_number_splits$number_split.l_nre_object_reference_listofv
349: --
350: -- Description:
351: --
352: -- Parameters:

Line 367: XNP_WSGL.RegisterURL('xnp_number_splits$number_split.l_nre_object_reference_listofv');

363: L_ANY boolean := FALSE;
364: L_BODY_ATTRIBUTES VarChar2 (1000) := LOV_BODY_ATTRIBUTES;
365: begin
366:
367: XNP_WSGL.RegisterURL('xnp_number_splits$number_split.l_nre_object_reference_listofv');
368: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
369: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
370: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
371: if XNP_WSGL.NotLowerCase then

Line 427: htp.formOpen('xnp_number_splits$number_split.l_nre_object_reference_listofv');

423: htp.p(XNP_WSGL.MsgGetText(127,XNP_WSGLM.DSP127_LOV_PLEASE_WAIT));
424: XNP_WSGL.ClosePageBody;
425: return;
426: else
427: htp.formOpen('xnp_number_splits$number_split.l_nre_object_reference_listofv');
428: XNP_WSGL.HiddenField('Z_CALLER_URL', Z_CALLER_URL);
429: XNP_WSGL.HiddenField('Z_MODE', Z_MODE);
430: end if;
431:

Line 500: LOV_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.l_nre_object_reference_listofv');

496:
497: exception
498: when others then
499: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits',
500: LOV_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.l_nre_object_reference_listofv');
501: end;
502:
503: --------------------------------------------------------------------------------
504: -- Name: xnp_number_splits$number_split.Startup

Line 504: -- Name: xnp_number_splits$number_split.Startup

500: LOV_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.l_nre_object_reference_listofv');
501: end;
502:
503: --------------------------------------------------------------------------------
504: -- Name: xnp_number_splits$number_split.Startup
505: --
506: -- Description: Entry point for the 'NUMBER_SPLITS' module
507: -- component (Number Split Details).
508: --

Line 517: XNP_WSGL.RegisterURL('xnp_number_splits$number_split.startup');

513: Z_DIRECT_CALL in boolean,
514: Z_CHK in varchar2) is
515: begin
516:
517: XNP_WSGL.RegisterURL('xnp_number_splits$number_split.startup');
518: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
519:
520: if not Z_DIRECT_CALL then
521: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

Line 535: DEF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.Startup');

531:
532: exception
533: when others then
534: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',
535: DEF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.Startup');
536: end;
537:
538: --------------------------------------------------------------------------------
539: -- Name: xnp_number_splits$number_split.ActionQuery

Line 539: -- Name: xnp_number_splits$number_split.ActionQuery

535: DEF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.Startup');
536: end;
537:
538: --------------------------------------------------------------------------------
539: -- Name: xnp_number_splits$number_split.ActionQuery
540: --
541: -- Description: Called when a Query form is subitted to action the query request.
542: --
543: -- Parameters:

Line 627: htp.p('

623: htp.noframesOpen;
624: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_INFORMATION, XNP_WSGL.MsgGetText(229,XNP_WSGLM.MSG229_NO_FRAME_SUPPORT),
625: 'View Number Splits'||' : '||'Number Split Details', DEF_BODY_ATTRIBUTES);
626: htp.noframesClose;
627: htp.p('
628:
629:
630:
631:

Line 629:

625: 'View Number Splits'||' : '||'Number Split Details', DEF_BODY_ATTRIBUTES);
626: htp.noframesClose;
627: htp.p('
628:
629:
630:
631:
632:
633:

Line 630:

626: htp.noframesClose;
627: htp.p('
628:
629:
630:
631:
632:
633:
634:

Line 632:

628:
629:
630:
631:
632:
633:
634:
635: ');
636: --if on the query form and insert is allowed

Line 641: DEF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.ActionQuery');

637:
638: exception
639: when others then
640: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',
641: DEF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.ActionQuery');
642: end;
643:
644: --------------------------------------------------------------------------------
645: -- Name: xnp_number_splits$number_split.TextFrame

Line 645: -- Name: xnp_number_splits$number_split.TextFrame

641: DEF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.ActionQuery');
642: end;
643:
644: --------------------------------------------------------------------------------
645: -- Name: xnp_number_splits$number_split.TextFrame
646: --
647: -- Description:
648: --
649: -- Parameters:

Line 703: TF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.TextFrame');

699:
700: exception
701: when others then
702: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',
703: TF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.TextFrame');
704: XNP_WSGL.ClosePageBody;
705: end;
706: --------------------------------------------------------------------------------
707: -- Name: xnp_number_splits$number_split.QueryHits

Line 707: -- Name: xnp_number_splits$number_split.QueryHits

703: TF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.TextFrame');
704: XNP_WSGL.ClosePageBody;
705: end;
706: --------------------------------------------------------------------------------
707: -- Name: xnp_number_splits$number_split.QueryHits
708: --
709: -- Description: Returns the number or rows which matches the given search
710: -- criteria (if any).
711: --

Line 783: DEF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.QueryHits');

779:
780: exception
781: when others then
782: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',
783: DEF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.QueryHits');
784: return -1;
785: end;--------------------------------------------------------------------------------
786: -- Name: xnp_number_splits$number_split.BuildSQL
787: --

Line 786: -- Name: xnp_number_splits$number_split.BuildSQL

782: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',
783: DEF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.QueryHits');
784: return -1;
785: end;--------------------------------------------------------------------------------
786: -- Name: xnp_number_splits$number_split.BuildSQL
787: --
788: -- Description: Builds the SQL for the 'NUMBER_SPLITS' module component (Number Split Details).
789: -- This incorporates all query criteria and Foreign key columns.
790: --

Line 866: DEF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.BuildSQL');

862:
863: exception
864: when others then
865: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',
866: DEF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.BuildSQL');
867: return false;
868: end;
869:
870:

Line 872: -- Name: xnp_number_splits$number_split.FormQuery

868: end;
869:
870:
871: --------------------------------------------------------------------------------
872: -- Name: xnp_number_splits$number_split.FormQuery
873: --
874: -- Description: This procedure builds an HTML form for entry of query criteria.
875: -- The criteria entered are to restrict the query of the 'NUMBER_SPLITS'
876: -- module component (Number Split Details).

Line 919: htp.formOpen(curl => 'xnp_number_splits$number_split.actionquery', cattributes => 'NAME="frmZero"');

915: htp.para;
916: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Number Split Details'));
917: htp.para;
918:
919: htp.formOpen(curl => 'xnp_number_splits$number_split.actionquery', cattributes => 'NAME="frmZero"');
920:
921: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
922:
923: XNP_WSGL.LayoutRowStart;

Line 997: QF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.FormQuery');

993:
994: exception
995: when others then
996: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',
997: QF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.FormQuery');
998: XNP_WSGL.ClosePageBody;
999: end;
1000:
1001: --------------------------------------------------------------------------------

Line 1002: -- Name: xnp_number_splits$number_split.FormView

998: XNP_WSGL.ClosePageBody;
999: end;
1000:
1001: --------------------------------------------------------------------------------
1002: -- Name: xnp_number_splits$number_split.FormView
1003: --
1004: -- Description: This procedure builds an HTML form for view/update of fields in
1005: -- the 'NUMBER_SPLITS' module component (Number Split Details).
1006: --

Line 1111: VF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.FormView');

1107:
1108: exception
1109: when others then
1110: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',
1111: VF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.FormView');
1112: XNP_WSGL.ClosePageBody;
1113: end;
1114:
1115: --------------------------------------------------------------------------------

Line 1116: -- Name: xnp_number_splits$number_split.QueryView

1112: XNP_WSGL.ClosePageBody;
1113: end;
1114:
1115: --------------------------------------------------------------------------------
1116: -- Name: xnp_number_splits$number_split.QueryView
1117: --
1118: -- Description: Queries the details of a single row in preparation for display.
1119: --
1120: -- Parameters:

Line 1131: XNP_WSGL.RegisterURL('xnp_number_splits$number_split.queryview');

1127: Z_DIRECT_CALL in boolean,
1128: Z_CHK in varchar2) is
1129: begin
1130:
1131: XNP_WSGL.RegisterURL('xnp_number_splits$number_split.queryview');
1132: XNP_WSGL.AddURLParam('P_NUMBER_SPLIT_ID', P_NUMBER_SPLIT_ID);
1133: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1134: if not Z_DIRECT_CALL then
1135: if not XNP_WSGL.ValidateChecksum('' ||

Line 1215: VF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.QueryView');

1211: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),
1212: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);
1213: when others then
1214: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',
1215: VF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.QueryView');
1216: end;
1217: --------------------------------------------------------------------------------
1218: -- Name: xnp_number_splits$number_split.QueryList
1219: --

Line 1218: -- Name: xnp_number_splits$number_split.QueryList

1214: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',
1215: VF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.QueryView');
1216: end;
1217: --------------------------------------------------------------------------------
1218: -- Name: xnp_number_splits$number_split.QueryList
1219: --
1220: -- Description: This procedure builds the Record list for the 'NUMBER_SPLITS'
1221: -- module component (Number Split Details).
1222: --

Line 1229: -- xnp_number_splits$number_split.FormView procedure for display of more details

1225: -- Sets of records are displayed (10 records at a time)
1226: -- with Next/Previous buttons to get other record sets.
1227: --
1228: -- The first context column will be created as a link to the
1229: -- xnp_number_splits$number_split.FormView procedure for display of more details
1230: -- of that particular row.
1231: --
1232: -- Parameters: P_L_NRE_OBJECT_REFERENCE - Initial Range
1233: -- P_L_NRE2_OBJECT_REFERENCE - New Range

Line 1277: XNP_WSGL.RegisterURL('xnp_number_splits$number_split.querylist');

1273: L_CHECKSUM varchar2(10);
1274:
1275: begin
1276:
1277: XNP_WSGL.RegisterURL('xnp_number_splits$number_split.querylist');
1278: XNP_WSGL.AddURLParam('P_L_NRE_OBJECT_REFERENCE', P_L_NRE_OBJECT_REFERENCE);
1279: XNP_WSGL.AddURLParam('P_L_NRE2_OBJECT_REFERENCE', P_L_NRE2_OBJECT_REFERENCE);
1280: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_START_DATE', P_PERMISSIVE_DIAL_START_DATE);
1281: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_START_DATE', U_PERMISSIVE_DIAL_START_DATE);

Line 1441: XNP_WSGL.LayoutData(htf.anchor2('xnp_number_splits$number_split.queryview?P_NUMBER_SPLIT_ID='||CURR_VAL.NUMBER_SPLIT_ID||'&Z_CHK='||L_CHECKSUM, NBT_VAL.L_NRE_OBJECT_REFERENCE, ctarget=>L_VF_FRAME));

1437: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.NUMBER_SPLIT_ID));
1438:
1439:
1440: XNP_WSGL.LayoutRowStart('TOP');
1441: XNP_WSGL.LayoutData(htf.anchor2('xnp_number_splits$number_split.queryview?P_NUMBER_SPLIT_ID='||CURR_VAL.NUMBER_SPLIT_ID||'&Z_CHK='||L_CHECKSUM, NBT_VAL.L_NRE_OBJECT_REFERENCE, ctarget=>L_VF_FRAME));
1442: XNP_WSGL.LayoutData(NBT_VAL.L_NRE2_OBJECT_REFERENCE);
1443: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.PERMISSIVE_DIAL_START_DATE, 'DD-MON-RRRR')));
1444: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.PERMISSIVE_DIAL_END_DATE, 'DD-MON-RRRR')));
1445: XNP_WSGL.LayoutRowEnd;

Line 1480: htp.formOpen(curl => 'xnp_number_splits$number_split.querylist', cattributes => 'NAME="frmZero"');

1476: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
1477: dbms_sql.close_cursor(I_CURSOR);
1478: end if;
1479:
1480: htp.formOpen(curl => 'xnp_number_splits$number_split.querylist', cattributes => 'NAME="frmZero"');
1481: XNP_WSGL.HiddenField('P_L_NRE_OBJECT_REFERENCE', P_L_NRE_OBJECT_REFERENCE);
1482: XNP_WSGL.HiddenField('P_L_NRE2_OBJECT_REFERENCE', P_L_NRE2_OBJECT_REFERENCE);
1483: XNP_WSGL.HiddenField('P_PERMISSIVE_DIAL_START_DATE', P_PERMISSIVE_DIAL_START_DATE);
1484: XNP_WSGL.HiddenField('U_PERMISSIVE_DIAL_START_DATE', U_PERMISSIVE_DIAL_START_DATE);

Line 1512: htp.formOpen(curl => 'xnp_number_splits$number_split.querylist', ctarget=>'_top', cattributes => 'NAME="frmOne"');

1508: XNP_WSGL.HiddenField('Z_CHK',
1509: to_char(XNP_WSGL.Checksum('')));
1510: htp.formClose;
1511:
1512: htp.formOpen(curl => 'xnp_number_splits$number_split.querylist', ctarget=>'_top', cattributes => 'NAME="frmOne"');
1513: htp.p ('');

Line 1539: RL_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.QueryList');

1535:
1536: exception
1537: when others then
1538: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',
1539: RL_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.QueryList');
1540: XNP_WSGL.ClosePageBody;
1541: end;
1542:
1543: --------------------------------------------------------------------------------

Line 1544: -- Name: xnp_number_splits$number_split.QueryFirst

1540: XNP_WSGL.ClosePageBody;
1541: end;
1542:
1543: --------------------------------------------------------------------------------
1544: -- Name: xnp_number_splits$number_split.QueryFirst
1545: --
1546: -- Description: Finds the first row which matches the given search criteria
1547: -- (if any), and calls QueryView for that row
1548: --

Line 1573: XNP_WSGL.RegisterURL('xnp_number_splits$number_split.queryfirst');

1569: I_ROWS_FETCHED integer := 0;
1570:
1571: begin
1572:
1573: XNP_WSGL.RegisterURL('xnp_number_splits$number_split.queryfirst');
1574: XNP_WSGL.AddURLParam('P_L_NRE_OBJECT_REFERENCE', P_L_NRE_OBJECT_REFERENCE);
1575: XNP_WSGL.AddURLParam('P_L_NRE2_OBJECT_REFERENCE', P_L_NRE2_OBJECT_REFERENCE);
1576: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_START_DATE', P_PERMISSIVE_DIAL_START_DATE);
1577: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_START_DATE', U_PERMISSIVE_DIAL_START_DATE);

Line 1648: xnp_number_splits$number_split.QueryView(Z_DIRECT_CALL=>TRUE);

1644: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE);
1645: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE);
1646: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1647: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
1648: xnp_number_splits$number_split.QueryView(Z_DIRECT_CALL=>TRUE);
1649: end if;
1650:
1651: dbms_sql.close_cursor(I_CURSOR);
1652:

Line 1656: VF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.QueryFirst');

1652:
1653: exception
1654: when others then
1655: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',
1656: VF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.QueryFirst');
1657: XNP_WSGL.ClosePageBody;
1658: end;
1659:
1660: --------------------------------------------------------------------------------

Line 1661: -- Name: xnp_number_splits$number_split.PreQuery

1657: XNP_WSGL.ClosePageBody;
1658: end;
1659:
1660: --------------------------------------------------------------------------------
1661: -- Name: xnp_number_splits$number_split.PreQuery
1662: --
1663: -- Description: Provides place holder for code to be run prior to a query
1664: -- for the 'NUMBER_SPLITS' module component (Number Split Details).
1665: --

Line 1689: DEF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.PreQuery');

1685: return L_RET_VAL;
1686: exception
1687: when others then
1688: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',
1689: DEF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.PreQuery');
1690: return FALSE;
1691: end;
1692:
1693: --------------------------------------------------------------------------------

Line 1694: -- Name: xnp_number_splits$number_split.PostQuery

1690: return FALSE;
1691: end;
1692:
1693: --------------------------------------------------------------------------------
1694: -- Name: xnp_number_splits$number_split.PostQuery
1695: --
1696: -- Description: Provides place holder for code to be run after a query
1697: -- for the 'NUMBER_SPLITS' module component (Number Split Details).
1698: --

Line 1712: DEF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.PostQuery');

1708: return L_RET_VAL;
1709: exception
1710: when others then
1711: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',
1712: DEF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.PostQuery');
1713: return FALSE;
1714: end;
1715:
1716: --------------------------------------------------------------------------------

Line 1717: -- Name: xnp_number_splits$number_split.CreateQueryJavaScript

1713: return FALSE;
1714: end;
1715:
1716: --------------------------------------------------------------------------------
1717: -- Name: xnp_number_splits$number_split.CreateQueryJavaScript
1718: --
1719: -- Description:
1720: --
1721: -- Parameters:

Line 1745: frmLOV = open("xnp_number_splits$number_split.l_nre_object_reference_listofv" +

1741: the_pathname = the_pathname.substring (j, the_pathname.length);
1742:
1743: }; // (i != -1)
1744:
1745: frmLOV = open("xnp_number_splits$number_split.l_nre_object_reference_listofv" +
1746: "?Z_FILTER=" + escape(filter) + "&Z_MODE=Q" +
1747: "&Z_CALLER_URL=" + escape(location.protocol + ''//'' + location.host + the_pathname + location.search) +
1748: "&Z_ISSUE_WAIT=Y",');
1749: if LOV_FRAME is not null then

Line 1776: frmLOV = open("xnp_number_splits$number_split.l_nre2_object_reference_listof" +

1772: the_pathname = the_pathname.substring (j, the_pathname.length);
1773:
1774: }; // (i != -1)
1775:
1776: frmLOV = open("xnp_number_splits$number_split.l_nre2_object_reference_listof" +
1777: "?Z_FILTER=" + escape(filter) + "&Z_MODE=Q" +
1778: "&Z_CALLER_URL=" + escape(location.protocol + ''//'' + location.host + the_pathname + location.search) +
1779: "&Z_ISSUE_WAIT=Y",');
1780: if LOV_FRAME is not null then

Line 1795: QF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.CreateQueryJavaScript');

1791: htp.p(XNP_WSGJSL.CloseScript);
1792: exception
1793: when others then
1794: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',
1795: QF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.CreateQueryJavaScript');
1796: end;
1797:
1798: --------------------------------------------------------------------------------
1799: -- Name: xnp_number_splits$number_split.CreateListJavaScript

Line 1799: -- Name: xnp_number_splits$number_split.CreateListJavaScript

1795: QF_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.CreateQueryJavaScript');
1796: end;
1797:
1798: --------------------------------------------------------------------------------
1799: -- Name: xnp_number_splits$number_split.CreateListJavaScript
1800: --
1801: -- Description:
1802: --
1803: -- Parameters:

Line 1814: RL_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.CreateListJavaScript');

1810: htp.p(XNP_WSGJSL.CloseScript);
1811: exception
1812: when others then
1813: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',
1814: RL_BODY_ATTRIBUTES, 'xnp_number_splits$number_split.CreateListJavaScript');
1815: end;
1816: end;