DBA Data[Home] [Help]

APPS.XNP_NUMBER_SPLITS$NUMBER_SPLIT dependencies on XNP_WSGL

Line 49: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);

45: QF_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
46: QF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
47: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
48: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
49: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);
50: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT);
51: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);
52: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE';
53: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';

Line 50: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT);

46: QF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
47: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
48: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
49: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);
50: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT);
51: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);
52: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE';
53: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
54: VF_DELETE_BUT_ACTION constant varchar2(10) := 'DELETE';

Line 51: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);

47: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
48: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
49: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);
50: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT);
51: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);
52: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE';
53: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
54: VF_DELETE_BUT_ACTION constant varchar2(10) := 'DELETE';
55: VF_VERIFIED_DELETE constant varchar2(100) := 'VerifiedDelete';

Line 140: XNP_WSGL.MsgGetText(226,XNP_WSGLM.MSG226_INVALID_FK),

136: return TRUE;
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: '||

Line 145: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),

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),
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,

Line 178: XNP_WSGL.MsgGetText(226,XNP_WSGLM.MSG226_INVALID_FK),

174: return TRUE;
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: '||

Line 183: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),

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),
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,

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 212: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);

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
216: return;

Line 213: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);

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
216: return;
217: end if;

Line 214: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);

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
216: return;
217: end if;
218:

Line 215: if XNP_WSGL.NotLowerCase then

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
216: return;
217: end if;
218:
219:

Line 220: XNP_WSGL.OpenPageHead(XNP_WSGL.MsgGetText(123,XNP_WSGLM.DSP123_LOV_CAPTION,

216: return;
217: end if;
218:
219:
220: XNP_WSGL.OpenPageHead(XNP_WSGL.MsgGetText(123,XNP_WSGLM.DSP123_LOV_CAPTION,
221: 'New Range, New Range Starting Number, New Range Ending Number'));
222:
223: if Z_ISSUE_WAIT is not null then
224:

Line 238: alert("'||XNP_WSGL.MsgGetText(228,XNP_WSGLM.MSG228_LOV_NOT_IN_CONTEXT)||'");

234: else
235: htp.p('');
338:
339: XNP_WSGL.ClosePageBody;
340:
341: exception
342: when others then
343: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits',

Line 343: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits',

339: XNP_WSGL.ClosePageBody;
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: --------------------------------------------------------------------------------

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 368: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);

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
372: return;

Line 369: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);

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
372: return;
373: end if;

Line 370: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);

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
372: return;
373: end if;
374:

Line 371: if XNP_WSGL.NotLowerCase then

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
372: return;
373: end if;
374:
375:

Line 376: XNP_WSGL.OpenPageHead(XNP_WSGL.MsgGetText(123,XNP_WSGLM.DSP123_LOV_CAPTION,

372: return;
373: end if;
374:
375:
376: XNP_WSGL.OpenPageHead(XNP_WSGL.MsgGetText(123,XNP_WSGLM.DSP123_LOV_CAPTION,
377: 'Initial Range, Initial Range Starting Number, Initial Range Ending Number'));
378:
379: if Z_ISSUE_WAIT is not null then
380:

Line 394: alert("'||XNP_WSGL.MsgGetText(228,XNP_WSGLM.MSG228_LOV_NOT_IN_CONTEXT)||'");

390: else
391: htp.p('');
494:
495: XNP_WSGL.ClosePageBody;
496:
497: exception
498: when others then
499: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits',

Line 499: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits',

495: XNP_WSGL.ClosePageBody;
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: --------------------------------------------------------------------------------

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 518: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

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
522: return;

Line 521: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

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
522: return;
523: end if;
524: end if;
525:

Line 526: XNP_WSGL.StoreURLLink(1, 'Number Split Details');

522: return;
523: end if;
524: end if;
525:
526: XNP_WSGL.StoreURLLink(1, 'Number Split Details');
527:
528:
529: FormQuery(
530: Z_DIRECT_CALL=>TRUE);

Line 534: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',

530: Z_DIRECT_CALL=>TRUE);
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: --------------------------------------------------------------------------------

Line 569: L_CHK := to_char(XNP_WSGL.Checksum(''));

565: L_BUTCHK varchar2(100):= null;
566: begin
567:
568: if Z_DIRECT_CALL then
569: L_CHK := to_char(XNP_WSGL.Checksum(''));
570: else
571: if not XNP_WSGL.ValidateChecksum('', L_CHK) then
572: return;
573: end if;

Line 571: if not XNP_WSGL.ValidateChecksum('', L_CHK) then

567:
568: if Z_DIRECT_CALL then
569: L_CHK := to_char(XNP_WSGL.Checksum(''));
570: else
571: if not XNP_WSGL.ValidateChecksum('', L_CHK) then
572: return;
573: end if;
574: end if;
575:

Line 577: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE_OBJECT_REFERENCE=' || XNP_WSGL.EscapeURLParam(P_L_NRE_OBJECT_REFERENCE) || '&';

573: end if;
574: end if;
575:
576: if P_L_NRE_OBJECT_REFERENCE is not null then
577: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE_OBJECT_REFERENCE=' || XNP_WSGL.EscapeURLParam(P_L_NRE_OBJECT_REFERENCE) || '&';
578: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
579: end if;
580: if P_L_NRE2_OBJECT_REFERENCE is not null then
581: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE2_OBJECT_REFERENCE=' || XNP_WSGL.EscapeURLParam(P_L_NRE2_OBJECT_REFERENCE) || '&';

Line 581: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE2_OBJECT_REFERENCE=' || XNP_WSGL.EscapeURLParam(P_L_NRE2_OBJECT_REFERENCE) || '&';

577: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE_OBJECT_REFERENCE=' || XNP_WSGL.EscapeURLParam(P_L_NRE_OBJECT_REFERENCE) || '&';
578: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
579: end if;
580: if P_L_NRE2_OBJECT_REFERENCE is not null then
581: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE2_OBJECT_REFERENCE=' || XNP_WSGL.EscapeURLParam(P_L_NRE2_OBJECT_REFERENCE) || '&';
582: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
583: end if;
584: if P_PERMISSIVE_DIAL_START_DATE is not null then
585: I_PARAM_LIST := I_PARAM_LIST || 'P_PERMISSIVE_DIAL_START_DATE=' || XNP_WSGL.EscapeURLParam(P_PERMISSIVE_DIAL_START_DATE) || '&';

Line 585: I_PARAM_LIST := I_PARAM_LIST || 'P_PERMISSIVE_DIAL_START_DATE=' || XNP_WSGL.EscapeURLParam(P_PERMISSIVE_DIAL_START_DATE) || '&';

581: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE2_OBJECT_REFERENCE=' || XNP_WSGL.EscapeURLParam(P_L_NRE2_OBJECT_REFERENCE) || '&';
582: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
583: end if;
584: if P_PERMISSIVE_DIAL_START_DATE is not null then
585: I_PARAM_LIST := I_PARAM_LIST || 'P_PERMISSIVE_DIAL_START_DATE=' || XNP_WSGL.EscapeURLParam(P_PERMISSIVE_DIAL_START_DATE) || '&';
586: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
587: end if;
588: if U_PERMISSIVE_DIAL_START_DATE is not null then
589: I_PARAM_LIST := I_PARAM_LIST || 'U_PERMISSIVE_DIAL_START_DATE=' || XNP_WSGL.EscapeURLParam(U_PERMISSIVE_DIAL_START_DATE) || '&';

Line 589: I_PARAM_LIST := I_PARAM_LIST || 'U_PERMISSIVE_DIAL_START_DATE=' || XNP_WSGL.EscapeURLParam(U_PERMISSIVE_DIAL_START_DATE) || '&';

585: I_PARAM_LIST := I_PARAM_LIST || 'P_PERMISSIVE_DIAL_START_DATE=' || XNP_WSGL.EscapeURLParam(P_PERMISSIVE_DIAL_START_DATE) || '&';
586: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
587: end if;
588: if U_PERMISSIVE_DIAL_START_DATE is not null then
589: I_PARAM_LIST := I_PARAM_LIST || 'U_PERMISSIVE_DIAL_START_DATE=' || XNP_WSGL.EscapeURLParam(U_PERMISSIVE_DIAL_START_DATE) || '&';
590: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
591: end if;
592: if P_PERMISSIVE_DIAL_END_DATE is not null then
593: I_PARAM_LIST := I_PARAM_LIST || 'P_PERMISSIVE_DIAL_END_DATE=' || XNP_WSGL.EscapeURLParam(P_PERMISSIVE_DIAL_END_DATE) || '&';

Line 593: I_PARAM_LIST := I_PARAM_LIST || 'P_PERMISSIVE_DIAL_END_DATE=' || XNP_WSGL.EscapeURLParam(P_PERMISSIVE_DIAL_END_DATE) || '&';

589: I_PARAM_LIST := I_PARAM_LIST || 'U_PERMISSIVE_DIAL_START_DATE=' || XNP_WSGL.EscapeURLParam(U_PERMISSIVE_DIAL_START_DATE) || '&';
590: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
591: end if;
592: if P_PERMISSIVE_DIAL_END_DATE is not null then
593: I_PARAM_LIST := I_PARAM_LIST || 'P_PERMISSIVE_DIAL_END_DATE=' || XNP_WSGL.EscapeURLParam(P_PERMISSIVE_DIAL_END_DATE) || '&';
594: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
595: end if;
596: if U_PERMISSIVE_DIAL_END_DATE is not null then
597: I_PARAM_LIST := I_PARAM_LIST || 'U_PERMISSIVE_DIAL_END_DATE=' || XNP_WSGL.EscapeURLParam(U_PERMISSIVE_DIAL_END_DATE) || '&';

Line 597: I_PARAM_LIST := I_PARAM_LIST || 'U_PERMISSIVE_DIAL_END_DATE=' || XNP_WSGL.EscapeURLParam(U_PERMISSIVE_DIAL_END_DATE) || '&';

593: I_PARAM_LIST := I_PARAM_LIST || 'P_PERMISSIVE_DIAL_END_DATE=' || XNP_WSGL.EscapeURLParam(P_PERMISSIVE_DIAL_END_DATE) || '&';
594: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
595: end if;
596: if U_PERMISSIVE_DIAL_END_DATE is not null then
597: I_PARAM_LIST := I_PARAM_LIST || 'U_PERMISSIVE_DIAL_END_DATE=' || XNP_WSGL.EscapeURLParam(U_PERMISSIVE_DIAL_END_DATE) || '&';
598: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
599: end if;
600: if P_L_NRE_STARTING_NUMBER is not null then
601: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE_STARTING_NUMBER=' || XNP_WSGL.EscapeURLParam(P_L_NRE_STARTING_NUMBER) || '&';

Line 601: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE_STARTING_NUMBER=' || XNP_WSGL.EscapeURLParam(P_L_NRE_STARTING_NUMBER) || '&';

597: I_PARAM_LIST := I_PARAM_LIST || 'U_PERMISSIVE_DIAL_END_DATE=' || XNP_WSGL.EscapeURLParam(U_PERMISSIVE_DIAL_END_DATE) || '&';
598: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
599: end if;
600: if P_L_NRE_STARTING_NUMBER is not null then
601: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE_STARTING_NUMBER=' || XNP_WSGL.EscapeURLParam(P_L_NRE_STARTING_NUMBER) || '&';
602: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
603: end if;
604: if P_L_NRE_ENDING_NUMBER is not null then
605: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE_ENDING_NUMBER=' || XNP_WSGL.EscapeURLParam(P_L_NRE_ENDING_NUMBER) || '&';

Line 605: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE_ENDING_NUMBER=' || XNP_WSGL.EscapeURLParam(P_L_NRE_ENDING_NUMBER) || '&';

601: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE_STARTING_NUMBER=' || XNP_WSGL.EscapeURLParam(P_L_NRE_STARTING_NUMBER) || '&';
602: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
603: end if;
604: if P_L_NRE_ENDING_NUMBER is not null then
605: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE_ENDING_NUMBER=' || XNP_WSGL.EscapeURLParam(P_L_NRE_ENDING_NUMBER) || '&';
606: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
607: end if;
608: if P_L_NRE2_STARTING_NUMBER is not null then
609: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE2_STARTING_NUMBER=' || XNP_WSGL.EscapeURLParam(P_L_NRE2_STARTING_NUMBER) || '&';

Line 609: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE2_STARTING_NUMBER=' || XNP_WSGL.EscapeURLParam(P_L_NRE2_STARTING_NUMBER) || '&';

605: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE_ENDING_NUMBER=' || XNP_WSGL.EscapeURLParam(P_L_NRE_ENDING_NUMBER) || '&';
606: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
607: end if;
608: if P_L_NRE2_STARTING_NUMBER is not null then
609: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE2_STARTING_NUMBER=' || XNP_WSGL.EscapeURLParam(P_L_NRE2_STARTING_NUMBER) || '&';
610: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
611: end if;
612: if P_L_NRE2_ENDING_NUMBER is not null then
613: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE2_ENDING_NUMBER=' || XNP_WSGL.EscapeURLParam(P_L_NRE2_ENDING_NUMBER) || '&';

Line 613: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE2_ENDING_NUMBER=' || XNP_WSGL.EscapeURLParam(P_L_NRE2_ENDING_NUMBER) || '&';

609: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE2_STARTING_NUMBER=' || XNP_WSGL.EscapeURLParam(P_L_NRE2_STARTING_NUMBER) || '&';
610: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
611: end if;
612: if P_L_NRE2_ENDING_NUMBER is not null then
613: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE2_ENDING_NUMBER=' || XNP_WSGL.EscapeURLParam(P_L_NRE2_ENDING_NUMBER) || '&';
614: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
615: end if;
616: I_PARAM_LIST := I_PARAM_LIST || 'Z_CHK=' || XNP_WSGL.EscapeURLParam(L_CHK) || '&';
617: I_PARAM_LIST := I_PARAM_LIST||'Z_ACTION=';

Line 616: I_PARAM_LIST := I_PARAM_LIST || 'Z_CHK=' || XNP_WSGL.EscapeURLParam(L_CHK) || '&';

612: if P_L_NRE2_ENDING_NUMBER is not null then
613: I_PARAM_LIST := I_PARAM_LIST || 'P_L_NRE2_ENDING_NUMBER=' || XNP_WSGL.EscapeURLParam(P_L_NRE2_ENDING_NUMBER) || '&';
614: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
615: end if;
616: I_PARAM_LIST := I_PARAM_LIST || 'Z_CHK=' || XNP_WSGL.EscapeURLParam(L_CHK) || '&';
617: I_PARAM_LIST := I_PARAM_LIST||'Z_ACTION=';
618:
619: htp.p('
620: View Number Splits : Number Split Details

Line 624: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_INFORMATION, XNP_WSGL.MsgGetText(229,XNP_WSGLM.MSG229_NO_FRAME_SUPPORT),

620: View Number Splits : Number Split Details
621:
622: ');
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:

Line 640: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',

636: --if on the query form and insert is allowed
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: --------------------------------------------------------------------------------

Line 675: XNP_WSGL.OpenPageHead('View Number Splits'||' : '||'Number Split Details',

671: end if;
672:
673: L_ONLY_THING_IN_FRAME := (L_TEXT_TYPES = 1);
674:
675: XNP_WSGL.OpenPageHead('View Number Splits'||' : '||'Number Split Details',
676: L_ONLY_THING_IN_FRAME);
677: xnp_number_splits$.TemplateHeader(TRUE,0);
678: XNP_WSGL.ClosePageHead;
679:

Line 678: XNP_WSGL.ClosePageHead;

674:
675: XNP_WSGL.OpenPageHead('View Number Splits'||' : '||'Number Split Details',
676: L_ONLY_THING_IN_FRAME);
677: xnp_number_splits$.TemplateHeader(TRUE,0);
678: XNP_WSGL.ClosePageHead;
679:
680: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>TF_BODY_ATTRIBUTES);
681:
682: if Z_HEADER is not null then

Line 680: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>TF_BODY_ATTRIBUTES);

676: L_ONLY_THING_IN_FRAME);
677: xnp_number_splits$.TemplateHeader(TRUE,0);
678: XNP_WSGL.ClosePageHead;
679:
680: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>TF_BODY_ATTRIBUTES);
681:
682: if Z_HEADER is not null then
683: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
684: end if;

Line 698: XNP_WSGL.ClosePageBody;

694: if Z_FOOTER is not null then
695: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
696: end if;
697:
698: XNP_WSGL.ClosePageBody;
699:
700: exception
701: when others then
702: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',

Line 702: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',

698: XNP_WSGL.ClosePageBody;
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: --------------------------------------------------------------------------------

Line 704: XNP_WSGL.ClosePageBody;

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
708: --

Line 756: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,

752: P_L_NRE_STARTING_NUMBER,
753: P_L_NRE_ENDING_NUMBER,
754: P_L_NRE2_STARTING_NUMBER,
755: P_L_NRE2_ENDING_NUMBER) then
756: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
757: 'View Number Splits'||' : '||'Number Split Details', DEF_BODY_ATTRIBUTES);
758: return -1;
759: end if;
760:

Line 782: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',

778: return I_COUNT;
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

Line 814: XNP_WSGL.BuildWhere(P_L_NRE_OBJECT_REFERENCE, 'L_NRE.OBJECT_REFERENCE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);

810: -- Build up the Where clause
811: I_WHERE := I_WHERE || ' where L_NRE.NUMBER_RANGE_ID = NST.OLD_NUMBER_RANGE_ID';
812: I_WHERE := I_WHERE || ' and L_NRE2.NUMBER_RANGE_ID = NST.NEW_NUMBER_RANGE_ID';
813:
814: XNP_WSGL.BuildWhere(P_L_NRE_OBJECT_REFERENCE, 'L_NRE.OBJECT_REFERENCE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
815: XNP_WSGL.BuildWhere(P_L_NRE2_OBJECT_REFERENCE, 'L_NRE2.OBJECT_REFERENCE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
816: begin
817: XNP_WSGL.BuildWhere(P_PERMISSIVE_DIAL_START_DATE, U_PERMISSIVE_DIAL_START_DATE, 'NST.PERMISSIVE_DIAL_START_DATE', XNP_WSGL.TYPE_DATE, I_WHERE, 'DD-MON-RRRR');
818: exception

Line 815: XNP_WSGL.BuildWhere(P_L_NRE2_OBJECT_REFERENCE, 'L_NRE2.OBJECT_REFERENCE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);

811: I_WHERE := I_WHERE || ' where L_NRE.NUMBER_RANGE_ID = NST.OLD_NUMBER_RANGE_ID';
812: I_WHERE := I_WHERE || ' and L_NRE2.NUMBER_RANGE_ID = NST.NEW_NUMBER_RANGE_ID';
813:
814: XNP_WSGL.BuildWhere(P_L_NRE_OBJECT_REFERENCE, 'L_NRE.OBJECT_REFERENCE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
815: XNP_WSGL.BuildWhere(P_L_NRE2_OBJECT_REFERENCE, 'L_NRE2.OBJECT_REFERENCE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
816: begin
817: XNP_WSGL.BuildWhere(P_PERMISSIVE_DIAL_START_DATE, U_PERMISSIVE_DIAL_START_DATE, 'NST.PERMISSIVE_DIAL_START_DATE', XNP_WSGL.TYPE_DATE, I_WHERE, 'DD-MON-RRRR');
818: exception
819: when others then

Line 817: XNP_WSGL.BuildWhere(P_PERMISSIVE_DIAL_START_DATE, U_PERMISSIVE_DIAL_START_DATE, 'NST.PERMISSIVE_DIAL_START_DATE', XNP_WSGL.TYPE_DATE, I_WHERE, 'DD-MON-RRRR');

813:
814: XNP_WSGL.BuildWhere(P_L_NRE_OBJECT_REFERENCE, 'L_NRE.OBJECT_REFERENCE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
815: XNP_WSGL.BuildWhere(P_L_NRE2_OBJECT_REFERENCE, 'L_NRE2.OBJECT_REFERENCE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
816: begin
817: XNP_WSGL.BuildWhere(P_PERMISSIVE_DIAL_START_DATE, U_PERMISSIVE_DIAL_START_DATE, 'NST.PERMISSIVE_DIAL_START_DATE', XNP_WSGL.TYPE_DATE, I_WHERE, 'DD-MON-RRRR');
818: exception
819: when others then
820: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
821: 'View Number Splits'||' : '||'Number Split Details', DEF_BODY_ATTRIBUTES, NULL,

Line 820: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,

816: begin
817: XNP_WSGL.BuildWhere(P_PERMISSIVE_DIAL_START_DATE, U_PERMISSIVE_DIAL_START_DATE, 'NST.PERMISSIVE_DIAL_START_DATE', XNP_WSGL.TYPE_DATE, I_WHERE, 'DD-MON-RRRR');
818: exception
819: when others then
820: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
821: 'View Number Splits'||' : '||'Number Split Details', DEF_BODY_ATTRIBUTES, NULL,
822: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Permissive Dialing Start Date'),
823: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR')));
824: return false;

Line 822: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Permissive Dialing Start Date'),

818: exception
819: when others then
820: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
821: 'View Number Splits'||' : '||'Number Split Details', DEF_BODY_ATTRIBUTES, NULL,
822: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Permissive Dialing Start Date'),
823: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR')));
824: return false;
825: end;
826: begin

Line 823: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR')));

819: when others then
820: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
821: 'View Number Splits'||' : '||'Number Split Details', DEF_BODY_ATTRIBUTES, NULL,
822: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Permissive Dialing Start Date'),
823: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR')));
824: return false;
825: end;
826: begin
827: XNP_WSGL.BuildWhere(P_PERMISSIVE_DIAL_END_DATE, U_PERMISSIVE_DIAL_END_DATE, 'NST.PERMISSIVE_DIAL_END_DATE', XNP_WSGL.TYPE_DATE, I_WHERE, 'DD-MON-RRRR');

Line 827: XNP_WSGL.BuildWhere(P_PERMISSIVE_DIAL_END_DATE, U_PERMISSIVE_DIAL_END_DATE, 'NST.PERMISSIVE_DIAL_END_DATE', XNP_WSGL.TYPE_DATE, I_WHERE, 'DD-MON-RRRR');

823: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR')));
824: return false;
825: end;
826: begin
827: XNP_WSGL.BuildWhere(P_PERMISSIVE_DIAL_END_DATE, U_PERMISSIVE_DIAL_END_DATE, 'NST.PERMISSIVE_DIAL_END_DATE', XNP_WSGL.TYPE_DATE, I_WHERE, 'DD-MON-RRRR');
828: exception
829: when others then
830: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
831: 'View Number Splits'||' : '||'Number Split Details', DEF_BODY_ATTRIBUTES, NULL,

Line 830: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,

826: begin
827: XNP_WSGL.BuildWhere(P_PERMISSIVE_DIAL_END_DATE, U_PERMISSIVE_DIAL_END_DATE, 'NST.PERMISSIVE_DIAL_END_DATE', XNP_WSGL.TYPE_DATE, I_WHERE, 'DD-MON-RRRR');
828: exception
829: when others then
830: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
831: 'View Number Splits'||' : '||'Number Split Details', DEF_BODY_ATTRIBUTES, NULL,
832: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Permissive Dialing End Date'),
833: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR')));
834: return false;

Line 832: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Permissive Dialing End Date'),

828: exception
829: when others then
830: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
831: 'View Number Splits'||' : '||'Number Split Details', DEF_BODY_ATTRIBUTES, NULL,
832: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Permissive Dialing End Date'),
833: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR')));
834: return false;
835: end;
836: XNP_WSGL.BuildWhere(P_L_NRE_STARTING_NUMBER, 'L_NRE.STARTING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);

Line 833: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR')));

829: when others then
830: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
831: 'View Number Splits'||' : '||'Number Split Details', DEF_BODY_ATTRIBUTES, NULL,
832: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Permissive Dialing End Date'),
833: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR')));
834: return false;
835: end;
836: XNP_WSGL.BuildWhere(P_L_NRE_STARTING_NUMBER, 'L_NRE.STARTING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
837: XNP_WSGL.BuildWhere(P_L_NRE_ENDING_NUMBER, 'L_NRE.ENDING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);

Line 836: XNP_WSGL.BuildWhere(P_L_NRE_STARTING_NUMBER, 'L_NRE.STARTING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);

832: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Permissive Dialing End Date'),
833: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR')));
834: return false;
835: end;
836: XNP_WSGL.BuildWhere(P_L_NRE_STARTING_NUMBER, 'L_NRE.STARTING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
837: XNP_WSGL.BuildWhere(P_L_NRE_ENDING_NUMBER, 'L_NRE.ENDING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
838: XNP_WSGL.BuildWhere(P_L_NRE2_STARTING_NUMBER, 'L_NRE2.STARTING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
839: XNP_WSGL.BuildWhere(P_L_NRE2_ENDING_NUMBER, 'L_NRE2.ENDING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
840:

Line 837: XNP_WSGL.BuildWhere(P_L_NRE_ENDING_NUMBER, 'L_NRE.ENDING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);

833: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR')));
834: return false;
835: end;
836: XNP_WSGL.BuildWhere(P_L_NRE_STARTING_NUMBER, 'L_NRE.STARTING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
837: XNP_WSGL.BuildWhere(P_L_NRE_ENDING_NUMBER, 'L_NRE.ENDING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
838: XNP_WSGL.BuildWhere(P_L_NRE2_STARTING_NUMBER, 'L_NRE2.STARTING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
839: XNP_WSGL.BuildWhere(P_L_NRE2_ENDING_NUMBER, 'L_NRE2.ENDING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
840:
841: ZONE_SQL := 'SELECT NST.NUMBER_SPLIT_ID,

Line 838: XNP_WSGL.BuildWhere(P_L_NRE2_STARTING_NUMBER, 'L_NRE2.STARTING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);

834: return false;
835: end;
836: XNP_WSGL.BuildWhere(P_L_NRE_STARTING_NUMBER, 'L_NRE.STARTING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
837: XNP_WSGL.BuildWhere(P_L_NRE_ENDING_NUMBER, 'L_NRE.ENDING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
838: XNP_WSGL.BuildWhere(P_L_NRE2_STARTING_NUMBER, 'L_NRE2.STARTING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
839: XNP_WSGL.BuildWhere(P_L_NRE2_ENDING_NUMBER, 'L_NRE2.ENDING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
840:
841: ZONE_SQL := 'SELECT NST.NUMBER_SPLIT_ID,
842: L_NRE.OBJECT_REFERENCE,

Line 839: XNP_WSGL.BuildWhere(P_L_NRE2_ENDING_NUMBER, 'L_NRE2.ENDING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);

835: end;
836: XNP_WSGL.BuildWhere(P_L_NRE_STARTING_NUMBER, 'L_NRE.STARTING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
837: XNP_WSGL.BuildWhere(P_L_NRE_ENDING_NUMBER, 'L_NRE.ENDING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
838: XNP_WSGL.BuildWhere(P_L_NRE2_STARTING_NUMBER, 'L_NRE2.STARTING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
839: XNP_WSGL.BuildWhere(P_L_NRE2_ENDING_NUMBER, 'L_NRE2.ENDING_NUMBER', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
840:
841: ZONE_SQL := 'SELECT NST.NUMBER_SPLIT_ID,
842: L_NRE.OBJECT_REFERENCE,
843: L_NRE2.OBJECT_REFERENCE,

Line 865: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',

861: return true;
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:

Line 887: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

883: Z_CHK in varchar2) is
884: begin
885:
886: if not Z_DIRECT_CALL then
887: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
888: return;
889: end if;
890: end if;
891:

Line 892: XNP_WSGL.OpenPageHead('View Number Splits'||' : '||'Number Split Details');

888: return;
889: end if;
890: end if;
891:
892: XNP_WSGL.OpenPageHead('View Number Splits'||' : '||'Number Split Details');
893: CreateQueryJavaScript;
894: -- Added for iHelp
895: htp.p('');
898: -- <<
899: xnp_number_splits$.TemplateHeader(TRUE,0);
900: XNP_WSGL.ClosePageHead;
901:
902: -- Added for iHelp
903: htp.p(' 904: htp.p('onMouseOver="window.status='||''''||'Help'||''''||';return true">');

Line 910: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>QF_BODY_ATTRIBUTES);

906: htp.p('');
907: htp.p(htf.nl);
908: -- <<
909:
910: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>QF_BODY_ATTRIBUTES);
911:
912: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
913: xnp_number_splits$.FirstPage(TRUE);
914: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPNUMSP_DETAILS_TITLE')));

Line 916: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Number Split Details'));

912: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
913: xnp_number_splits$.FirstPage(TRUE);
914: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPNUMSP_DETAILS_TITLE')));
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:

Line 921: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);

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;
924: for i in 1..QF_NUMBER_OF_COLUMNS loop
925: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);

Line 923: XNP_WSGL.LayoutRowStart;

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;
924: for i in 1..QF_NUMBER_OF_COLUMNS loop
925: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);
926: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
927: end loop;

Line 925: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);

921: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
922:
923: XNP_WSGL.LayoutRowStart;
924: for i in 1..QF_NUMBER_OF_COLUMNS loop
925: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);
926: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
927: end loop;
928: XNP_WSGL.LayoutRowEnd;
929:

Line 926: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);

922:
923: XNP_WSGL.LayoutRowStart;
924: for i in 1..QF_NUMBER_OF_COLUMNS loop
925: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);
926: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
927: end loop;
928: XNP_WSGL.LayoutRowEnd;
929:
930: XNP_WSGL.LayoutRowStart('TOP');

Line 928: XNP_WSGL.LayoutRowEnd;

924: for i in 1..QF_NUMBER_OF_COLUMNS loop
925: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);
926: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
927: end loop;
928: XNP_WSGL.LayoutRowEnd;
929:
930: XNP_WSGL.LayoutRowStart('TOP');
931: XNP_WSGL.LayoutData(htf.bold('Initial Range:'));
932: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_OBJECT_REFERENCE', '20', FALSE) || ' ' ||

Line 930: XNP_WSGL.LayoutRowStart('TOP');

926: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
927: end loop;
928: XNP_WSGL.LayoutRowEnd;
929:
930: XNP_WSGL.LayoutRowStart('TOP');
931: XNP_WSGL.LayoutData(htf.bold('Initial Range:'));
932: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_OBJECT_REFERENCE', '20', FALSE) || ' ' ||
933: XNP_WSGJSL.LOVButton('L_NRE_OBJECT_REFERENCE',LOV_BUTTON_TEXT));
934: XNP_WSGL.LayoutRowEnd;

Line 931: XNP_WSGL.LayoutData(htf.bold('Initial Range:'));

927: end loop;
928: XNP_WSGL.LayoutRowEnd;
929:
930: XNP_WSGL.LayoutRowStart('TOP');
931: XNP_WSGL.LayoutData(htf.bold('Initial Range:'));
932: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_OBJECT_REFERENCE', '20', FALSE) || ' ' ||
933: XNP_WSGJSL.LOVButton('L_NRE_OBJECT_REFERENCE',LOV_BUTTON_TEXT));
934: XNP_WSGL.LayoutRowEnd;
935: XNP_WSGL.LayoutRowStart('TOP');

Line 932: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_OBJECT_REFERENCE', '20', FALSE) || ' ' ||

928: XNP_WSGL.LayoutRowEnd;
929:
930: XNP_WSGL.LayoutRowStart('TOP');
931: XNP_WSGL.LayoutData(htf.bold('Initial Range:'));
932: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_OBJECT_REFERENCE', '20', FALSE) || ' ' ||
933: XNP_WSGJSL.LOVButton('L_NRE_OBJECT_REFERENCE',LOV_BUTTON_TEXT));
934: XNP_WSGL.LayoutRowEnd;
935: XNP_WSGL.LayoutRowStart('TOP');
936: XNP_WSGL.LayoutData(htf.bold('New Range:'));

Line 934: XNP_WSGL.LayoutRowEnd;

930: XNP_WSGL.LayoutRowStart('TOP');
931: XNP_WSGL.LayoutData(htf.bold('Initial Range:'));
932: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_OBJECT_REFERENCE', '20', FALSE) || ' ' ||
933: XNP_WSGJSL.LOVButton('L_NRE_OBJECT_REFERENCE',LOV_BUTTON_TEXT));
934: XNP_WSGL.LayoutRowEnd;
935: XNP_WSGL.LayoutRowStart('TOP');
936: XNP_WSGL.LayoutData(htf.bold('New Range:'));
937: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_OBJECT_REFERENCE', '20', FALSE) || ' ' ||
938: XNP_WSGJSL.LOVButton('L_NRE2_OBJECT_REFERENCE',LOV_BUTTON_TEXT));

Line 935: XNP_WSGL.LayoutRowStart('TOP');

931: XNP_WSGL.LayoutData(htf.bold('Initial Range:'));
932: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_OBJECT_REFERENCE', '20', FALSE) || ' ' ||
933: XNP_WSGJSL.LOVButton('L_NRE_OBJECT_REFERENCE',LOV_BUTTON_TEXT));
934: XNP_WSGL.LayoutRowEnd;
935: XNP_WSGL.LayoutRowStart('TOP');
936: XNP_WSGL.LayoutData(htf.bold('New Range:'));
937: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_OBJECT_REFERENCE', '20', FALSE) || ' ' ||
938: XNP_WSGJSL.LOVButton('L_NRE2_OBJECT_REFERENCE',LOV_BUTTON_TEXT));
939: XNP_WSGL.LayoutRowEnd;

Line 936: XNP_WSGL.LayoutData(htf.bold('New Range:'));

932: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_OBJECT_REFERENCE', '20', FALSE) || ' ' ||
933: XNP_WSGJSL.LOVButton('L_NRE_OBJECT_REFERENCE',LOV_BUTTON_TEXT));
934: XNP_WSGL.LayoutRowEnd;
935: XNP_WSGL.LayoutRowStart('TOP');
936: XNP_WSGL.LayoutData(htf.bold('New Range:'));
937: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_OBJECT_REFERENCE', '20', FALSE) || ' ' ||
938: XNP_WSGJSL.LOVButton('L_NRE2_OBJECT_REFERENCE',LOV_BUTTON_TEXT));
939: XNP_WSGL.LayoutRowEnd;
940: XNP_WSGL.LayoutRowStart('TOP');

Line 937: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_OBJECT_REFERENCE', '20', FALSE) || ' ' ||

933: XNP_WSGJSL.LOVButton('L_NRE_OBJECT_REFERENCE',LOV_BUTTON_TEXT));
934: XNP_WSGL.LayoutRowEnd;
935: XNP_WSGL.LayoutRowStart('TOP');
936: XNP_WSGL.LayoutData(htf.bold('New Range:'));
937: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_OBJECT_REFERENCE', '20', FALSE) || ' ' ||
938: XNP_WSGJSL.LOVButton('L_NRE2_OBJECT_REFERENCE',LOV_BUTTON_TEXT));
939: XNP_WSGL.LayoutRowEnd;
940: XNP_WSGL.LayoutRowStart('TOP');
941: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));

Line 939: XNP_WSGL.LayoutRowEnd;

935: XNP_WSGL.LayoutRowStart('TOP');
936: XNP_WSGL.LayoutData(htf.bold('New Range:'));
937: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_OBJECT_REFERENCE', '20', FALSE) || ' ' ||
938: XNP_WSGJSL.LOVButton('L_NRE2_OBJECT_REFERENCE',LOV_BUTTON_TEXT));
939: XNP_WSGL.LayoutRowEnd;
940: XNP_WSGL.LayoutRowStart('TOP');
941: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));
942: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_START_DATE', '20', TRUE));
943: XNP_WSGL.LayoutRowEnd;

Line 940: XNP_WSGL.LayoutRowStart('TOP');

936: XNP_WSGL.LayoutData(htf.bold('New Range:'));
937: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_OBJECT_REFERENCE', '20', FALSE) || ' ' ||
938: XNP_WSGJSL.LOVButton('L_NRE2_OBJECT_REFERENCE',LOV_BUTTON_TEXT));
939: XNP_WSGL.LayoutRowEnd;
940: XNP_WSGL.LayoutRowStart('TOP');
941: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));
942: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_START_DATE', '20', TRUE));
943: XNP_WSGL.LayoutRowEnd;
944: XNP_WSGL.LayoutRowStart('TOP');

Line 941: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));

937: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_OBJECT_REFERENCE', '20', FALSE) || ' ' ||
938: XNP_WSGJSL.LOVButton('L_NRE2_OBJECT_REFERENCE',LOV_BUTTON_TEXT));
939: XNP_WSGL.LayoutRowEnd;
940: XNP_WSGL.LayoutRowStart('TOP');
941: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));
942: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_START_DATE', '20', TRUE));
943: XNP_WSGL.LayoutRowEnd;
944: XNP_WSGL.LayoutRowStart('TOP');
945: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));

Line 942: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_START_DATE', '20', TRUE));

938: XNP_WSGJSL.LOVButton('L_NRE2_OBJECT_REFERENCE',LOV_BUTTON_TEXT));
939: XNP_WSGL.LayoutRowEnd;
940: XNP_WSGL.LayoutRowStart('TOP');
941: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));
942: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_START_DATE', '20', TRUE));
943: XNP_WSGL.LayoutRowEnd;
944: XNP_WSGL.LayoutRowStart('TOP');
945: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));
946: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_END_DATE', '20', TRUE));

Line 943: XNP_WSGL.LayoutRowEnd;

939: XNP_WSGL.LayoutRowEnd;
940: XNP_WSGL.LayoutRowStart('TOP');
941: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));
942: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_START_DATE', '20', TRUE));
943: XNP_WSGL.LayoutRowEnd;
944: XNP_WSGL.LayoutRowStart('TOP');
945: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));
946: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_END_DATE', '20', TRUE));
947: XNP_WSGL.LayoutRowEnd;

Line 944: XNP_WSGL.LayoutRowStart('TOP');

940: XNP_WSGL.LayoutRowStart('TOP');
941: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));
942: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_START_DATE', '20', TRUE));
943: XNP_WSGL.LayoutRowEnd;
944: XNP_WSGL.LayoutRowStart('TOP');
945: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));
946: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_END_DATE', '20', TRUE));
947: XNP_WSGL.LayoutRowEnd;
948: XNP_WSGL.LayoutRowStart('TOP');

Line 945: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));

941: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));
942: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_START_DATE', '20', TRUE));
943: XNP_WSGL.LayoutRowEnd;
944: XNP_WSGL.LayoutRowStart('TOP');
945: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));
946: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_END_DATE', '20', TRUE));
947: XNP_WSGL.LayoutRowEnd;
948: XNP_WSGL.LayoutRowStart('TOP');
949: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));

Line 946: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_END_DATE', '20', TRUE));

942: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_START_DATE', '20', TRUE));
943: XNP_WSGL.LayoutRowEnd;
944: XNP_WSGL.LayoutRowStart('TOP');
945: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));
946: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_END_DATE', '20', TRUE));
947: XNP_WSGL.LayoutRowEnd;
948: XNP_WSGL.LayoutRowStart('TOP');
949: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));
950: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_STARTING_NUMBER', '20', FALSE));

Line 947: XNP_WSGL.LayoutRowEnd;

943: XNP_WSGL.LayoutRowEnd;
944: XNP_WSGL.LayoutRowStart('TOP');
945: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));
946: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_END_DATE', '20', TRUE));
947: XNP_WSGL.LayoutRowEnd;
948: XNP_WSGL.LayoutRowStart('TOP');
949: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));
950: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_STARTING_NUMBER', '20', FALSE));
951: XNP_WSGL.LayoutRowEnd;

Line 948: XNP_WSGL.LayoutRowStart('TOP');

944: XNP_WSGL.LayoutRowStart('TOP');
945: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));
946: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_END_DATE', '20', TRUE));
947: XNP_WSGL.LayoutRowEnd;
948: XNP_WSGL.LayoutRowStart('TOP');
949: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));
950: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_STARTING_NUMBER', '20', FALSE));
951: XNP_WSGL.LayoutRowEnd;
952: XNP_WSGL.LayoutRowStart('TOP');

Line 949: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));

945: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));
946: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_END_DATE', '20', TRUE));
947: XNP_WSGL.LayoutRowEnd;
948: XNP_WSGL.LayoutRowStart('TOP');
949: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));
950: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_STARTING_NUMBER', '20', FALSE));
951: XNP_WSGL.LayoutRowEnd;
952: XNP_WSGL.LayoutRowStart('TOP');
953: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));

Line 950: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_STARTING_NUMBER', '20', FALSE));

946: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PERMISSIVE_DIAL_END_DATE', '20', TRUE));
947: XNP_WSGL.LayoutRowEnd;
948: XNP_WSGL.LayoutRowStart('TOP');
949: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));
950: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_STARTING_NUMBER', '20', FALSE));
951: XNP_WSGL.LayoutRowEnd;
952: XNP_WSGL.LayoutRowStart('TOP');
953: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));
954: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_ENDING_NUMBER', '20', FALSE));

Line 951: XNP_WSGL.LayoutRowEnd;

947: XNP_WSGL.LayoutRowEnd;
948: XNP_WSGL.LayoutRowStart('TOP');
949: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));
950: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_STARTING_NUMBER', '20', FALSE));
951: XNP_WSGL.LayoutRowEnd;
952: XNP_WSGL.LayoutRowStart('TOP');
953: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));
954: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_ENDING_NUMBER', '20', FALSE));
955: XNP_WSGL.LayoutRowEnd;

Line 952: XNP_WSGL.LayoutRowStart('TOP');

948: XNP_WSGL.LayoutRowStart('TOP');
949: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));
950: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_STARTING_NUMBER', '20', FALSE));
951: XNP_WSGL.LayoutRowEnd;
952: XNP_WSGL.LayoutRowStart('TOP');
953: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));
954: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_ENDING_NUMBER', '20', FALSE));
955: XNP_WSGL.LayoutRowEnd;
956: XNP_WSGL.LayoutRowStart('TOP');

Line 953: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));

949: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));
950: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_STARTING_NUMBER', '20', FALSE));
951: XNP_WSGL.LayoutRowEnd;
952: XNP_WSGL.LayoutRowStart('TOP');
953: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));
954: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_ENDING_NUMBER', '20', FALSE));
955: XNP_WSGL.LayoutRowEnd;
956: XNP_WSGL.LayoutRowStart('TOP');
957: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));

Line 954: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_ENDING_NUMBER', '20', FALSE));

950: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_STARTING_NUMBER', '20', FALSE));
951: XNP_WSGL.LayoutRowEnd;
952: XNP_WSGL.LayoutRowStart('TOP');
953: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));
954: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_ENDING_NUMBER', '20', FALSE));
955: XNP_WSGL.LayoutRowEnd;
956: XNP_WSGL.LayoutRowStart('TOP');
957: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));
958: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_STARTING_NUMBER', '20', FALSE));

Line 955: XNP_WSGL.LayoutRowEnd;

951: XNP_WSGL.LayoutRowEnd;
952: XNP_WSGL.LayoutRowStart('TOP');
953: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));
954: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_ENDING_NUMBER', '20', FALSE));
955: XNP_WSGL.LayoutRowEnd;
956: XNP_WSGL.LayoutRowStart('TOP');
957: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));
958: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_STARTING_NUMBER', '20', FALSE));
959: XNP_WSGL.LayoutRowEnd;

Line 956: XNP_WSGL.LayoutRowStart('TOP');

952: XNP_WSGL.LayoutRowStart('TOP');
953: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));
954: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_ENDING_NUMBER', '20', FALSE));
955: XNP_WSGL.LayoutRowEnd;
956: XNP_WSGL.LayoutRowStart('TOP');
957: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));
958: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_STARTING_NUMBER', '20', FALSE));
959: XNP_WSGL.LayoutRowEnd;
960: XNP_WSGL.LayoutRowStart('TOP');

Line 957: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));

953: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));
954: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_ENDING_NUMBER', '20', FALSE));
955: XNP_WSGL.LayoutRowEnd;
956: XNP_WSGL.LayoutRowStart('TOP');
957: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));
958: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_STARTING_NUMBER', '20', FALSE));
959: XNP_WSGL.LayoutRowEnd;
960: XNP_WSGL.LayoutRowStart('TOP');
961: XNP_WSGL.LayoutData(htf.bold('New Range Ending Number:'));

Line 958: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_STARTING_NUMBER', '20', FALSE));

954: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE_ENDING_NUMBER', '20', FALSE));
955: XNP_WSGL.LayoutRowEnd;
956: XNP_WSGL.LayoutRowStart('TOP');
957: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));
958: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_STARTING_NUMBER', '20', FALSE));
959: XNP_WSGL.LayoutRowEnd;
960: XNP_WSGL.LayoutRowStart('TOP');
961: XNP_WSGL.LayoutData(htf.bold('New Range Ending Number:'));
962: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_ENDING_NUMBER', '20', FALSE));

Line 959: XNP_WSGL.LayoutRowEnd;

955: XNP_WSGL.LayoutRowEnd;
956: XNP_WSGL.LayoutRowStart('TOP');
957: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));
958: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_STARTING_NUMBER', '20', FALSE));
959: XNP_WSGL.LayoutRowEnd;
960: XNP_WSGL.LayoutRowStart('TOP');
961: XNP_WSGL.LayoutData(htf.bold('New Range Ending Number:'));
962: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_ENDING_NUMBER', '20', FALSE));
963: XNP_WSGL.LayoutRowEnd;

Line 960: XNP_WSGL.LayoutRowStart('TOP');

956: XNP_WSGL.LayoutRowStart('TOP');
957: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));
958: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_STARTING_NUMBER', '20', FALSE));
959: XNP_WSGL.LayoutRowEnd;
960: XNP_WSGL.LayoutRowStart('TOP');
961: XNP_WSGL.LayoutData(htf.bold('New Range Ending Number:'));
962: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_ENDING_NUMBER', '20', FALSE));
963: XNP_WSGL.LayoutRowEnd;
964:

Line 961: XNP_WSGL.LayoutData(htf.bold('New Range Ending Number:'));

957: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));
958: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_STARTING_NUMBER', '20', FALSE));
959: XNP_WSGL.LayoutRowEnd;
960: XNP_WSGL.LayoutRowStart('TOP');
961: XNP_WSGL.LayoutData(htf.bold('New Range Ending Number:'));
962: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_ENDING_NUMBER', '20', FALSE));
963: XNP_WSGL.LayoutRowEnd;
964:
965: XNP_WSGL.LayoutClose;

Line 962: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_ENDING_NUMBER', '20', FALSE));

958: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_STARTING_NUMBER', '20', FALSE));
959: XNP_WSGL.LayoutRowEnd;
960: XNP_WSGL.LayoutRowStart('TOP');
961: XNP_WSGL.LayoutData(htf.bold('New Range Ending Number:'));
962: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_ENDING_NUMBER', '20', FALSE));
963: XNP_WSGL.LayoutRowEnd;
964:
965: XNP_WSGL.LayoutClose;
966:

Line 963: XNP_WSGL.LayoutRowEnd;

959: XNP_WSGL.LayoutRowEnd;
960: XNP_WSGL.LayoutRowStart('TOP');
961: XNP_WSGL.LayoutData(htf.bold('New Range Ending Number:'));
962: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('L_NRE2_ENDING_NUMBER', '20', FALSE));
963: XNP_WSGL.LayoutRowEnd;
964:
965: XNP_WSGL.LayoutClose;
966:
967: htp.p ('');
975:
976: if XNP_WSGL.IsSupported ('NOSCRIPT')
977: then
978:
979: htp.p ('

Line 986: XNP_WSGL.HiddenField('Z_CHK',

982:
983: end if;
984: htp.formReset(htf.escape_sc(QF_CLEAR_BUT_CAPTION));
985:
986: XNP_WSGL.HiddenField('Z_CHK',
987: to_char(XNP_WSGL.Checksum('')));
988: htp.formClose;
989:
990: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));

Line 987: to_char(XNP_WSGL.Checksum('')));

983: end if;
984: htp.formReset(htf.escape_sc(QF_CLEAR_BUT_CAPTION));
985:
986: XNP_WSGL.HiddenField('Z_CHK',
987: to_char(XNP_WSGL.Checksum('')));
988: htp.formClose;
989:
990: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
991:

Line 992: XNP_WSGL.ClosePageBody;

988: htp.formClose;
989:
990: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
991:
992: XNP_WSGL.ClosePageBody;
993:
994: exception
995: when others then
996: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',

Line 996: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',

992: XNP_WSGL.ClosePageBody;
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:

Line 998: XNP_WSGL.ClosePageBody;

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: --------------------------------------------------------------------------------
1002: -- Name: xnp_number_splits$number_split.FormView

Line 1015: XNP_WSGL.OpenPageHead('View Number Splits'||' : '||'Number Split Details');

1011:
1012:
1013: begin
1014:
1015: XNP_WSGL.OpenPageHead('View Number Splits'||' : '||'Number Split Details');
1016: xnp_number_splits$.TemplateHeader(TRUE,0);
1017: XNP_WSGL.ClosePageHead;
1018:
1019: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);

Line 1017: XNP_WSGL.ClosePageHead;

1013: begin
1014:
1015: XNP_WSGL.OpenPageHead('View Number Splits'||' : '||'Number Split Details');
1016: xnp_number_splits$.TemplateHeader(TRUE,0);
1017: XNP_WSGL.ClosePageHead;
1018:
1019: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);
1020:
1021:

Line 1019: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);

1015: XNP_WSGL.OpenPageHead('View Number Splits'||' : '||'Number Split Details');
1016: xnp_number_splits$.TemplateHeader(TRUE,0);
1017: XNP_WSGL.ClosePageHead;
1018:
1019: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);
1020:
1021:
1022:
1023:

Line 1037: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then

1033: FORM_VAL.L_NRE2_STARTING_NUMBER := NBT_VAL.L_NRE2_STARTING_NUMBER;
1034: FORM_VAL.L_NRE2_ENDING_NUMBER := NBT_VAL.L_NRE2_ENDING_NUMBER;
1035: FORM_VAL.CONVERSION_PROCEDURE := CURR_VAL.CONVERSION_PROCEDURE;
1036:
1037: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
1038: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1039: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);
1040: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
1041: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),

Line 1038: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,

1034: FORM_VAL.L_NRE2_ENDING_NUMBER := NBT_VAL.L_NRE2_ENDING_NUMBER;
1035: FORM_VAL.CONVERSION_PROCEDURE := CURR_VAL.CONVERSION_PROCEDURE;
1036:
1037: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
1038: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1039: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);
1040: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
1041: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
1042: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);

Line 1040: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then

1036:
1037: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
1038: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1039: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);
1040: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
1041: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
1042: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);
1043: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
1044: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),

Line 1041: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),

1037: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
1038: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1039: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);
1040: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
1041: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
1042: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);
1043: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
1044: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
1045: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);

Line 1043: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then

1039: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);
1040: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
1041: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
1042: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);
1043: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
1044: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
1045: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);
1046: end if;
1047:

Line 1044: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),

1040: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
1041: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
1042: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);
1043: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
1044: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
1045: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);
1046: end if;
1047:
1048:

Line 1049: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);

1045: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);
1046: end if;
1047:
1048:
1049: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
1050:
1051: XNP_WSGL.LayoutRowStart;
1052: for i in 1..VF_NUMBER_OF_COLUMNS loop
1053: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);

Line 1051: XNP_WSGL.LayoutRowStart;

1047:
1048:
1049: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
1050:
1051: XNP_WSGL.LayoutRowStart;
1052: for i in 1..VF_NUMBER_OF_COLUMNS loop
1053: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);
1054: XNP_WSGL.LayoutHeader(40, 'LEFT', NULL);
1055: end loop;

Line 1053: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);

1049: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
1050:
1051: XNP_WSGL.LayoutRowStart;
1052: for i in 1..VF_NUMBER_OF_COLUMNS loop
1053: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);
1054: XNP_WSGL.LayoutHeader(40, 'LEFT', NULL);
1055: end loop;
1056: XNP_WSGL.LayoutRowEnd;
1057:

Line 1054: XNP_WSGL.LayoutHeader(40, 'LEFT', NULL);

1050:
1051: XNP_WSGL.LayoutRowStart;
1052: for i in 1..VF_NUMBER_OF_COLUMNS loop
1053: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);
1054: XNP_WSGL.LayoutHeader(40, 'LEFT', NULL);
1055: end loop;
1056: XNP_WSGL.LayoutRowEnd;
1057:
1058: XNP_WSGL.LayoutRowStart('TOP');

Line 1056: XNP_WSGL.LayoutRowEnd;

1052: for i in 1..VF_NUMBER_OF_COLUMNS loop
1053: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);
1054: XNP_WSGL.LayoutHeader(40, 'LEFT', NULL);
1055: end loop;
1056: XNP_WSGL.LayoutRowEnd;
1057:
1058: XNP_WSGL.LayoutRowStart('TOP');
1059: XNP_WSGL.LayoutData(htf.bold('Initial Range:'));
1060: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE_OBJECT_REFERENCE));

Line 1058: XNP_WSGL.LayoutRowStart('TOP');

1054: XNP_WSGL.LayoutHeader(40, 'LEFT', NULL);
1055: end loop;
1056: XNP_WSGL.LayoutRowEnd;
1057:
1058: XNP_WSGL.LayoutRowStart('TOP');
1059: XNP_WSGL.LayoutData(htf.bold('Initial Range:'));
1060: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE_OBJECT_REFERENCE));
1061: XNP_WSGL.LayoutRowEnd;
1062: XNP_WSGL.LayoutRowStart('TOP');

Line 1059: XNP_WSGL.LayoutData(htf.bold('Initial Range:'));

1055: end loop;
1056: XNP_WSGL.LayoutRowEnd;
1057:
1058: XNP_WSGL.LayoutRowStart('TOP');
1059: XNP_WSGL.LayoutData(htf.bold('Initial Range:'));
1060: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE_OBJECT_REFERENCE));
1061: XNP_WSGL.LayoutRowEnd;
1062: XNP_WSGL.LayoutRowStart('TOP');
1063: XNP_WSGL.LayoutData(htf.bold('New Range:'));

Line 1060: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE_OBJECT_REFERENCE));

1056: XNP_WSGL.LayoutRowEnd;
1057:
1058: XNP_WSGL.LayoutRowStart('TOP');
1059: XNP_WSGL.LayoutData(htf.bold('Initial Range:'));
1060: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE_OBJECT_REFERENCE));
1061: XNP_WSGL.LayoutRowEnd;
1062: XNP_WSGL.LayoutRowStart('TOP');
1063: XNP_WSGL.LayoutData(htf.bold('New Range:'));
1064: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE2_OBJECT_REFERENCE));

Line 1061: XNP_WSGL.LayoutRowEnd;

1057:
1058: XNP_WSGL.LayoutRowStart('TOP');
1059: XNP_WSGL.LayoutData(htf.bold('Initial Range:'));
1060: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE_OBJECT_REFERENCE));
1061: XNP_WSGL.LayoutRowEnd;
1062: XNP_WSGL.LayoutRowStart('TOP');
1063: XNP_WSGL.LayoutData(htf.bold('New Range:'));
1064: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE2_OBJECT_REFERENCE));
1065: XNP_WSGL.LayoutRowEnd;

Line 1062: XNP_WSGL.LayoutRowStart('TOP');

1058: XNP_WSGL.LayoutRowStart('TOP');
1059: XNP_WSGL.LayoutData(htf.bold('Initial Range:'));
1060: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE_OBJECT_REFERENCE));
1061: XNP_WSGL.LayoutRowEnd;
1062: XNP_WSGL.LayoutRowStart('TOP');
1063: XNP_WSGL.LayoutData(htf.bold('New Range:'));
1064: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE2_OBJECT_REFERENCE));
1065: XNP_WSGL.LayoutRowEnd;
1066: XNP_WSGL.LayoutRowStart('TOP');

Line 1063: XNP_WSGL.LayoutData(htf.bold('New Range:'));

1059: XNP_WSGL.LayoutData(htf.bold('Initial Range:'));
1060: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE_OBJECT_REFERENCE));
1061: XNP_WSGL.LayoutRowEnd;
1062: XNP_WSGL.LayoutRowStart('TOP');
1063: XNP_WSGL.LayoutData(htf.bold('New Range:'));
1064: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE2_OBJECT_REFERENCE));
1065: XNP_WSGL.LayoutRowEnd;
1066: XNP_WSGL.LayoutRowStart('TOP');
1067: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));

Line 1064: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE2_OBJECT_REFERENCE));

1060: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE_OBJECT_REFERENCE));
1061: XNP_WSGL.LayoutRowEnd;
1062: XNP_WSGL.LayoutRowStart('TOP');
1063: XNP_WSGL.LayoutData(htf.bold('New Range:'));
1064: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE2_OBJECT_REFERENCE));
1065: XNP_WSGL.LayoutRowEnd;
1066: XNP_WSGL.LayoutRowStart('TOP');
1067: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));
1068: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_START_DATE));

Line 1065: XNP_WSGL.LayoutRowEnd;

1061: XNP_WSGL.LayoutRowEnd;
1062: XNP_WSGL.LayoutRowStart('TOP');
1063: XNP_WSGL.LayoutData(htf.bold('New Range:'));
1064: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE2_OBJECT_REFERENCE));
1065: XNP_WSGL.LayoutRowEnd;
1066: XNP_WSGL.LayoutRowStart('TOP');
1067: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));
1068: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_START_DATE));
1069: XNP_WSGL.LayoutRowEnd;

Line 1066: XNP_WSGL.LayoutRowStart('TOP');

1062: XNP_WSGL.LayoutRowStart('TOP');
1063: XNP_WSGL.LayoutData(htf.bold('New Range:'));
1064: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE2_OBJECT_REFERENCE));
1065: XNP_WSGL.LayoutRowEnd;
1066: XNP_WSGL.LayoutRowStart('TOP');
1067: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));
1068: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_START_DATE));
1069: XNP_WSGL.LayoutRowEnd;
1070: XNP_WSGL.LayoutRowStart('TOP');

Line 1067: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));

1063: XNP_WSGL.LayoutData(htf.bold('New Range:'));
1064: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE2_OBJECT_REFERENCE));
1065: XNP_WSGL.LayoutRowEnd;
1066: XNP_WSGL.LayoutRowStart('TOP');
1067: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));
1068: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_START_DATE));
1069: XNP_WSGL.LayoutRowEnd;
1070: XNP_WSGL.LayoutRowStart('TOP');
1071: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));

Line 1068: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_START_DATE));

1064: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.L_NRE2_OBJECT_REFERENCE));
1065: XNP_WSGL.LayoutRowEnd;
1066: XNP_WSGL.LayoutRowStart('TOP');
1067: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));
1068: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_START_DATE));
1069: XNP_WSGL.LayoutRowEnd;
1070: XNP_WSGL.LayoutRowStart('TOP');
1071: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));
1072: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_END_DATE));

Line 1069: XNP_WSGL.LayoutRowEnd;

1065: XNP_WSGL.LayoutRowEnd;
1066: XNP_WSGL.LayoutRowStart('TOP');
1067: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));
1068: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_START_DATE));
1069: XNP_WSGL.LayoutRowEnd;
1070: XNP_WSGL.LayoutRowStart('TOP');
1071: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));
1072: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_END_DATE));
1073: XNP_WSGL.LayoutRowEnd;

Line 1070: XNP_WSGL.LayoutRowStart('TOP');

1066: XNP_WSGL.LayoutRowStart('TOP');
1067: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));
1068: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_START_DATE));
1069: XNP_WSGL.LayoutRowEnd;
1070: XNP_WSGL.LayoutRowStart('TOP');
1071: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));
1072: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_END_DATE));
1073: XNP_WSGL.LayoutRowEnd;
1074: XNP_WSGL.LayoutRowStart('TOP');

Line 1071: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));

1067: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing Start Date:'));
1068: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_START_DATE));
1069: XNP_WSGL.LayoutRowEnd;
1070: XNP_WSGL.LayoutRowStart('TOP');
1071: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));
1072: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_END_DATE));
1073: XNP_WSGL.LayoutRowEnd;
1074: XNP_WSGL.LayoutRowStart('TOP');
1075: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));

Line 1072: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_END_DATE));

1068: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_START_DATE));
1069: XNP_WSGL.LayoutRowEnd;
1070: XNP_WSGL.LayoutRowStart('TOP');
1071: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));
1072: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_END_DATE));
1073: XNP_WSGL.LayoutRowEnd;
1074: XNP_WSGL.LayoutRowStart('TOP');
1075: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));
1076: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_STARTING_NUMBER);

Line 1073: XNP_WSGL.LayoutRowEnd;

1069: XNP_WSGL.LayoutRowEnd;
1070: XNP_WSGL.LayoutRowStart('TOP');
1071: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));
1072: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_END_DATE));
1073: XNP_WSGL.LayoutRowEnd;
1074: XNP_WSGL.LayoutRowStart('TOP');
1075: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));
1076: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_STARTING_NUMBER);
1077: XNP_WSGL.LayoutRowEnd;

Line 1074: XNP_WSGL.LayoutRowStart('TOP');

1070: XNP_WSGL.LayoutRowStart('TOP');
1071: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));
1072: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_END_DATE));
1073: XNP_WSGL.LayoutRowEnd;
1074: XNP_WSGL.LayoutRowStart('TOP');
1075: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));
1076: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_STARTING_NUMBER);
1077: XNP_WSGL.LayoutRowEnd;
1078: XNP_WSGL.LayoutRowStart('TOP');

Line 1075: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));

1071: XNP_WSGL.LayoutData(htf.bold('Permissive Dialing End Date:'));
1072: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_END_DATE));
1073: XNP_WSGL.LayoutRowEnd;
1074: XNP_WSGL.LayoutRowStart('TOP');
1075: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));
1076: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_STARTING_NUMBER);
1077: XNP_WSGL.LayoutRowEnd;
1078: XNP_WSGL.LayoutRowStart('TOP');
1079: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));

Line 1076: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_STARTING_NUMBER);

1072: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PERMISSIVE_DIAL_END_DATE));
1073: XNP_WSGL.LayoutRowEnd;
1074: XNP_WSGL.LayoutRowStart('TOP');
1075: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));
1076: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_STARTING_NUMBER);
1077: XNP_WSGL.LayoutRowEnd;
1078: XNP_WSGL.LayoutRowStart('TOP');
1079: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));
1080: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_ENDING_NUMBER);

Line 1077: XNP_WSGL.LayoutRowEnd;

1073: XNP_WSGL.LayoutRowEnd;
1074: XNP_WSGL.LayoutRowStart('TOP');
1075: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));
1076: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_STARTING_NUMBER);
1077: XNP_WSGL.LayoutRowEnd;
1078: XNP_WSGL.LayoutRowStart('TOP');
1079: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));
1080: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_ENDING_NUMBER);
1081: XNP_WSGL.LayoutRowEnd;

Line 1078: XNP_WSGL.LayoutRowStart('TOP');

1074: XNP_WSGL.LayoutRowStart('TOP');
1075: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));
1076: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_STARTING_NUMBER);
1077: XNP_WSGL.LayoutRowEnd;
1078: XNP_WSGL.LayoutRowStart('TOP');
1079: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));
1080: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_ENDING_NUMBER);
1081: XNP_WSGL.LayoutRowEnd;
1082: XNP_WSGL.LayoutRowStart('TOP');

Line 1079: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));

1075: XNP_WSGL.LayoutData(htf.bold('Initial Range Starting Number:'));
1076: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_STARTING_NUMBER);
1077: XNP_WSGL.LayoutRowEnd;
1078: XNP_WSGL.LayoutRowStart('TOP');
1079: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));
1080: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_ENDING_NUMBER);
1081: XNP_WSGL.LayoutRowEnd;
1082: XNP_WSGL.LayoutRowStart('TOP');
1083: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));

Line 1080: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_ENDING_NUMBER);

1076: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_STARTING_NUMBER);
1077: XNP_WSGL.LayoutRowEnd;
1078: XNP_WSGL.LayoutRowStart('TOP');
1079: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));
1080: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_ENDING_NUMBER);
1081: XNP_WSGL.LayoutRowEnd;
1082: XNP_WSGL.LayoutRowStart('TOP');
1083: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));
1084: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_STARTING_NUMBER);

Line 1081: XNP_WSGL.LayoutRowEnd;

1077: XNP_WSGL.LayoutRowEnd;
1078: XNP_WSGL.LayoutRowStart('TOP');
1079: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));
1080: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_ENDING_NUMBER);
1081: XNP_WSGL.LayoutRowEnd;
1082: XNP_WSGL.LayoutRowStart('TOP');
1083: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));
1084: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_STARTING_NUMBER);
1085: XNP_WSGL.LayoutRowEnd;

Line 1082: XNP_WSGL.LayoutRowStart('TOP');

1078: XNP_WSGL.LayoutRowStart('TOP');
1079: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));
1080: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_ENDING_NUMBER);
1081: XNP_WSGL.LayoutRowEnd;
1082: XNP_WSGL.LayoutRowStart('TOP');
1083: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));
1084: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_STARTING_NUMBER);
1085: XNP_WSGL.LayoutRowEnd;
1086: XNP_WSGL.LayoutRowStart('TOP');

Line 1083: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));

1079: XNP_WSGL.LayoutData(htf.bold('Initial Range Ending Number:'));
1080: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_ENDING_NUMBER);
1081: XNP_WSGL.LayoutRowEnd;
1082: XNP_WSGL.LayoutRowStart('TOP');
1083: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));
1084: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_STARTING_NUMBER);
1085: XNP_WSGL.LayoutRowEnd;
1086: XNP_WSGL.LayoutRowStart('TOP');
1087: XNP_WSGL.LayoutData(htf.bold('New Range Ending Number:'));

Line 1084: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_STARTING_NUMBER);

1080: XNP_WSGL.LayoutData(FORM_VAL.L_NRE_ENDING_NUMBER);
1081: XNP_WSGL.LayoutRowEnd;
1082: XNP_WSGL.LayoutRowStart('TOP');
1083: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));
1084: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_STARTING_NUMBER);
1085: XNP_WSGL.LayoutRowEnd;
1086: XNP_WSGL.LayoutRowStart('TOP');
1087: XNP_WSGL.LayoutData(htf.bold('New Range Ending Number:'));
1088: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_ENDING_NUMBER);

Line 1085: XNP_WSGL.LayoutRowEnd;

1081: XNP_WSGL.LayoutRowEnd;
1082: XNP_WSGL.LayoutRowStart('TOP');
1083: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));
1084: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_STARTING_NUMBER);
1085: XNP_WSGL.LayoutRowEnd;
1086: XNP_WSGL.LayoutRowStart('TOP');
1087: XNP_WSGL.LayoutData(htf.bold('New Range Ending Number:'));
1088: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_ENDING_NUMBER);
1089: XNP_WSGL.LayoutRowEnd;

Line 1086: XNP_WSGL.LayoutRowStart('TOP');

1082: XNP_WSGL.LayoutRowStart('TOP');
1083: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));
1084: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_STARTING_NUMBER);
1085: XNP_WSGL.LayoutRowEnd;
1086: XNP_WSGL.LayoutRowStart('TOP');
1087: XNP_WSGL.LayoutData(htf.bold('New Range Ending Number:'));
1088: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_ENDING_NUMBER);
1089: XNP_WSGL.LayoutRowEnd;
1090: XNP_WSGL.LayoutRowStart('TOP');

Line 1087: XNP_WSGL.LayoutData(htf.bold('New Range Ending Number:'));

1083: XNP_WSGL.LayoutData(htf.bold('New Range Starting Number:'));
1084: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_STARTING_NUMBER);
1085: XNP_WSGL.LayoutRowEnd;
1086: XNP_WSGL.LayoutRowStart('TOP');
1087: XNP_WSGL.LayoutData(htf.bold('New Range Ending Number:'));
1088: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_ENDING_NUMBER);
1089: XNP_WSGL.LayoutRowEnd;
1090: XNP_WSGL.LayoutRowStart('TOP');
1091: XNP_WSGL.LayoutData(htf.bold('Conversion Procedure:'));

Line 1088: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_ENDING_NUMBER);

1084: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_STARTING_NUMBER);
1085: XNP_WSGL.LayoutRowEnd;
1086: XNP_WSGL.LayoutRowStart('TOP');
1087: XNP_WSGL.LayoutData(htf.bold('New Range Ending Number:'));
1088: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_ENDING_NUMBER);
1089: XNP_WSGL.LayoutRowEnd;
1090: XNP_WSGL.LayoutRowStart('TOP');
1091: XNP_WSGL.LayoutData(htf.bold('Conversion Procedure:'));
1092: XNP_WSGL.LayoutData(replace(FORM_VAL.CONVERSION_PROCEDURE, '

Line 1089: XNP_WSGL.LayoutRowEnd;

1085: XNP_WSGL.LayoutRowEnd;
1086: XNP_WSGL.LayoutRowStart('TOP');
1087: XNP_WSGL.LayoutData(htf.bold('New Range Ending Number:'));
1088: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_ENDING_NUMBER);
1089: XNP_WSGL.LayoutRowEnd;
1090: XNP_WSGL.LayoutRowStart('TOP');
1091: XNP_WSGL.LayoutData(htf.bold('Conversion Procedure:'));
1092: XNP_WSGL.LayoutData(replace(FORM_VAL.CONVERSION_PROCEDURE, '
1093: ', '

Line 1090: XNP_WSGL.LayoutRowStart('TOP');

1086: XNP_WSGL.LayoutRowStart('TOP');
1087: XNP_WSGL.LayoutData(htf.bold('New Range Ending Number:'));
1088: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_ENDING_NUMBER);
1089: XNP_WSGL.LayoutRowEnd;
1090: XNP_WSGL.LayoutRowStart('TOP');
1091: XNP_WSGL.LayoutData(htf.bold('Conversion Procedure:'));
1092: XNP_WSGL.LayoutData(replace(FORM_VAL.CONVERSION_PROCEDURE, '
1093: ', '

1094: '));

Line 1091: XNP_WSGL.LayoutData(htf.bold('Conversion Procedure:'));

1087: XNP_WSGL.LayoutData(htf.bold('New Range Ending Number:'));
1088: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_ENDING_NUMBER);
1089: XNP_WSGL.LayoutRowEnd;
1090: XNP_WSGL.LayoutRowStart('TOP');
1091: XNP_WSGL.LayoutData(htf.bold('Conversion Procedure:'));
1092: XNP_WSGL.LayoutData(replace(FORM_VAL.CONVERSION_PROCEDURE, '
1093: ', '

1094: '));
1095: XNP_WSGL.LayoutRowEnd;

Line 1092: XNP_WSGL.LayoutData(replace(FORM_VAL.CONVERSION_PROCEDURE, '

1088: XNP_WSGL.LayoutData(FORM_VAL.L_NRE2_ENDING_NUMBER);
1089: XNP_WSGL.LayoutRowEnd;
1090: XNP_WSGL.LayoutRowStart('TOP');
1091: XNP_WSGL.LayoutData(htf.bold('Conversion Procedure:'));
1092: XNP_WSGL.LayoutData(replace(FORM_VAL.CONVERSION_PROCEDURE, '
1093: ', '

1094: '));
1095: XNP_WSGL.LayoutRowEnd;
1096:

Line 1095: XNP_WSGL.LayoutRowEnd;

1091: XNP_WSGL.LayoutData(htf.bold('Conversion Procedure:'));
1092: XNP_WSGL.LayoutData(replace(FORM_VAL.CONVERSION_PROCEDURE, '
1093: ', '

1094: '));
1095: XNP_WSGL.LayoutRowEnd;
1096:
1097: XNP_WSGL.LayoutClose;
1098:
1099:

Line 1097: XNP_WSGL.LayoutClose;

1093: ', '

1094: '));
1095: XNP_WSGL.LayoutRowEnd;
1096:
1097: XNP_WSGL.LayoutClose;
1098:
1099:
1100:
1101:

Line 1106: XNP_WSGL.ClosePageBody;

1102:
1103:
1104:
1105:
1106: XNP_WSGL.ClosePageBody;
1107:
1108: exception
1109: when others then
1110: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',

Line 1110: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',

1106: XNP_WSGL.ClosePageBody;
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:

Line 1112: XNP_WSGL.ClosePageBody;

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: --------------------------------------------------------------------------------
1116: -- Name: xnp_number_splits$number_split.QueryView

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 1132: XNP_WSGL.AddURLParam('P_NUMBER_SPLIT_ID', P_NUMBER_SPLIT_ID);

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('' ||
1136: P_NUMBER_SPLIT_ID, Z_CHK) then

Line 1133: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

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('' ||
1136: P_NUMBER_SPLIT_ID, Z_CHK) then
1137: return;

Line 1135: if not XNP_WSGL.ValidateChecksum('' ||

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('' ||
1136: P_NUMBER_SPLIT_ID, Z_CHK) then
1137: return;
1138: end if;
1139: end if;

Line 1204: FormView(XNP_WSGL.FORM_STATUS_ERROR);

1200:
1201: end if;
1202:
1203: if not PostQuery(Z_POST_DML) then
1204: FormView(XNP_WSGL.FORM_STATUS_ERROR);
1205: else
1206: FormView(Z_FORM_STATUS);
1207: end if;
1208:

Line 1211: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),

1207: end if;
1208:
1209: exception
1210: when NO_DATA_FOUND then
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');

Line 1214: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',

1210: when NO_DATA_FOUND then
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

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 1278: XNP_WSGL.AddURLParam('P_L_NRE_OBJECT_REFERENCE', P_L_NRE_OBJECT_REFERENCE);

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);
1282: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);

Line 1279: XNP_WSGL.AddURLParam('P_L_NRE2_OBJECT_REFERENCE', P_L_NRE2_OBJECT_REFERENCE);

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);
1282: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1283: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);

Line 1280: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_START_DATE', P_PERMISSIVE_DIAL_START_DATE);

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);
1282: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1283: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1284: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);

Line 1281: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_START_DATE', U_PERMISSIVE_DIAL_START_DATE);

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);
1282: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1283: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1284: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1285: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);

Line 1282: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);

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);
1282: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1283: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1284: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1285: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1286: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);

Line 1283: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);

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);
1282: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1283: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1284: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1285: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1286: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);
1287: XNP_WSGL.AddURLParam('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);

Line 1284: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);

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);
1282: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1283: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1284: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1285: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1286: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);
1287: XNP_WSGL.AddURLParam('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);
1288: XNP_WSGL.AddURLParam('Z_START', Z_START);

Line 1285: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);

1281: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_START_DATE', U_PERMISSIVE_DIAL_START_DATE);
1282: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1283: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1284: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1285: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1286: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);
1287: XNP_WSGL.AddURLParam('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);
1288: XNP_WSGL.AddURLParam('Z_START', Z_START);
1289: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);

Line 1286: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);

1282: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1283: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1284: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1285: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1286: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);
1287: XNP_WSGL.AddURLParam('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);
1288: XNP_WSGL.AddURLParam('Z_START', Z_START);
1289: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1290: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

Line 1287: XNP_WSGL.AddURLParam('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);

1283: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1284: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1285: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1286: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);
1287: XNP_WSGL.AddURLParam('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);
1288: XNP_WSGL.AddURLParam('Z_START', Z_START);
1289: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1290: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1291: if not Z_DIRECT_CALL then

Line 1288: XNP_WSGL.AddURLParam('Z_START', Z_START);

1284: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1285: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1286: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);
1287: XNP_WSGL.AddURLParam('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);
1288: XNP_WSGL.AddURLParam('Z_START', Z_START);
1289: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1290: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1291: if not Z_DIRECT_CALL then
1292: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

Line 1289: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);

1285: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1286: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);
1287: XNP_WSGL.AddURLParam('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);
1288: XNP_WSGL.AddURLParam('Z_START', Z_START);
1289: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1290: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1291: if not Z_DIRECT_CALL then
1292: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1293: return;

Line 1290: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

1286: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);
1287: XNP_WSGL.AddURLParam('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);
1288: XNP_WSGL.AddURLParam('Z_START', Z_START);
1289: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1290: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1291: if not Z_DIRECT_CALL then
1292: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1293: return;
1294: end if;

Line 1292: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

1288: XNP_WSGL.AddURLParam('Z_START', Z_START);
1289: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1290: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1291: if not Z_DIRECT_CALL then
1292: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1293: return;
1294: end if;
1295: end if;
1296:

Line 1303: XNP_WSGL.OpenPageHead('View Number Splits'||' : '||'Number Split Details');

1299: Z_DIRECT_CALL=>TRUE);
1300: return;
1301: end if;
1302:
1303: XNP_WSGL.OpenPageHead('View Number Splits'||' : '||'Number Split Details');
1304: CreateListJavaScript;
1305: xnp_number_splits$.TemplateHeader(TRUE,0);
1306: XNP_WSGL.ClosePageHead;
1307:

Line 1306: XNP_WSGL.ClosePageHead;

1302:
1303: XNP_WSGL.OpenPageHead('View Number Splits'||' : '||'Number Split Details');
1304: CreateListJavaScript;
1305: xnp_number_splits$.TemplateHeader(TRUE,0);
1306: XNP_WSGL.ClosePageHead;
1307:
1308: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
1309:
1310: if (Z_ACTION = RL_LAST_BUT_ACTION) or (Z_ACTION = RL_LAST_BUT_CAPTION) or

Line 1308: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);

1304: CreateListJavaScript;
1305: xnp_number_splits$.TemplateHeader(TRUE,0);
1306: XNP_WSGL.ClosePageHead;
1307:
1308: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
1309:
1310: if (Z_ACTION = RL_LAST_BUT_ACTION) or (Z_ACTION = RL_LAST_BUT_CAPTION) or
1311: (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
1312: (RL_TOTAL_COUNT_REQD)

Line 1327: XNP_WSGL.ClosePageBody;

1323: P_L_NRE_ENDING_NUMBER,
1324: P_L_NRE2_STARTING_NUMBER,
1325: P_L_NRE2_ENDING_NUMBER);
1326: if I_COUNT = -1 then
1327: XNP_WSGL.ClosePageBody;
1328: return;
1329: end if;
1330: end if;
1331:

Line 1334: I_OF_TOTAL_TEXT := ' '||XNP_WSGL.MsgGetText(111,XNP_WSGLM.DSP111_OF_TOTAL, to_char(I_COUNT));

1330: end if;
1331:
1332: if (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
1333: RL_TOTAL_COUNT_REQD then
1334: I_OF_TOTAL_TEXT := ' '||XNP_WSGL.MsgGetText(111,XNP_WSGLM.DSP111_OF_TOTAL, to_char(I_COUNT));
1335: end if;
1336:
1337: if Z_START IS NULL or (Z_ACTION = RL_FIRST_BUT_ACTION) or (Z_ACTION = RL_FIRST_BUT_CAPTION) then
1338: I_START := 1;

Line 1348: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),

1344: I_START := 1 + (floor((I_COUNT-1)/RL_RECORD_SET_SIZE)*RL_RECORD_SET_SIZE);
1345: elsif Z_ACTION is null and I_START = 1 then
1346: null;
1347: elsif Z_ACTION IS NULL then
1348: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),
1349: 'View Number Splits'||' : '||'Number Split Details', RL_BODY_ATTRIBUTES);
1350: XNP_WSGL.ClosePageBody;
1351: return;
1352: end if;

Line 1350: XNP_WSGL.ClosePageBody;

1346: null;
1347: elsif Z_ACTION IS NULL then
1348: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),
1349: 'View Number Splits'||' : '||'Number Split Details', RL_BODY_ATTRIBUTES);
1350: XNP_WSGL.ClosePageBody;
1351: return;
1352: end if;
1353:
1354: if I_START < 1 then

Line 1378: XNP_WSGL.ClosePageBody;

1374: P_L_NRE_STARTING_NUMBER,
1375: P_L_NRE_ENDING_NUMBER,
1376: P_L_NRE2_STARTING_NUMBER,
1377: P_L_NRE2_ENDING_NUMBER) then
1378: XNP_WSGL.ClosePageBody;
1379: return;
1380: end if;
1381: end if;
1382:

Line 1394: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,

1390: P_L_NRE_STARTING_NUMBER,
1391: P_L_NRE_ENDING_NUMBER,
1392: P_L_NRE2_STARTING_NUMBER,
1393: P_L_NRE2_ENDING_NUMBER) then
1394: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1395: 'View Number Splits'||' : '||'Number Split Details', RL_BODY_ATTRIBUTES);
1396: return;
1397: end if;
1398:

Line 1418: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);

1414: I_TOTAL_ROWS := I_ROWS_FETCHED;
1415:
1416: if I_ROWS_FETCHED <> 0 then
1417:
1418: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
1419:
1420: XNP_WSGL.LayoutRowStart;
1421: for i in 1..RL_NUMBER_OF_COLUMNS loop
1422: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Initial Range');

Line 1420: XNP_WSGL.LayoutRowStart;

1416: if I_ROWS_FETCHED <> 0 then
1417:
1418: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
1419:
1420: XNP_WSGL.LayoutRowStart;
1421: for i in 1..RL_NUMBER_OF_COLUMNS loop
1422: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Initial Range');
1423: XNP_WSGL.LayoutHeader(20, 'LEFT', 'New Range');
1424: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Permissive Dialing Start Date');

Line 1422: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Initial Range');

1418: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
1419:
1420: XNP_WSGL.LayoutRowStart;
1421: for i in 1..RL_NUMBER_OF_COLUMNS loop
1422: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Initial Range');
1423: XNP_WSGL.LayoutHeader(20, 'LEFT', 'New Range');
1424: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Permissive Dialing Start Date');
1425: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Permissive Dialing End Date');
1426: end loop;

Line 1423: XNP_WSGL.LayoutHeader(20, 'LEFT', 'New Range');

1419:
1420: XNP_WSGL.LayoutRowStart;
1421: for i in 1..RL_NUMBER_OF_COLUMNS loop
1422: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Initial Range');
1423: XNP_WSGL.LayoutHeader(20, 'LEFT', 'New Range');
1424: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Permissive Dialing Start Date');
1425: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Permissive Dialing End Date');
1426: end loop;
1427: XNP_WSGL.LayoutRowEnd;

Line 1424: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Permissive Dialing Start Date');

1420: XNP_WSGL.LayoutRowStart;
1421: for i in 1..RL_NUMBER_OF_COLUMNS loop
1422: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Initial Range');
1423: XNP_WSGL.LayoutHeader(20, 'LEFT', 'New Range');
1424: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Permissive Dialing Start Date');
1425: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Permissive Dialing End Date');
1426: end loop;
1427: XNP_WSGL.LayoutRowEnd;
1428:

Line 1425: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Permissive Dialing End Date');

1421: for i in 1..RL_NUMBER_OF_COLUMNS loop
1422: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Initial Range');
1423: XNP_WSGL.LayoutHeader(20, 'LEFT', 'New Range');
1424: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Permissive Dialing Start Date');
1425: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Permissive Dialing End Date');
1426: end loop;
1427: XNP_WSGL.LayoutRowEnd;
1428:
1429: while I_ROWS_FETCHED <> 0 loop

Line 1427: XNP_WSGL.LayoutRowEnd;

1423: XNP_WSGL.LayoutHeader(20, 'LEFT', 'New Range');
1424: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Permissive Dialing Start Date');
1425: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Permissive Dialing End Date');
1426: end loop;
1427: XNP_WSGL.LayoutRowEnd;
1428:
1429: while I_ROWS_FETCHED <> 0 loop
1430:
1431: if I_TOTAL_ROWS >= I_START then

Line 1437: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.NUMBER_SPLIT_ID));

1433: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_NRE_OBJECT_REFERENCE);
1434: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_NRE2_OBJECT_REFERENCE);
1435: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.PERMISSIVE_DIAL_START_DATE);
1436: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
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));

Line 1440: XNP_WSGL.LayoutRowStart('TOP');

1436: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PERMISSIVE_DIAL_END_DATE);
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')));

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 1442: XNP_WSGL.LayoutData(NBT_VAL.L_NRE2_OBJECT_REFERENCE);

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;
1446:

Line 1443: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.PERMISSIVE_DIAL_START_DATE, 'DD-MON-RRRR')));

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;
1446:
1447: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

Line 1444: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.PERMISSIVE_DIAL_END_DATE, 'DD-MON-RRRR')));

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;
1446:
1447: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1448: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then

Line 1445: XNP_WSGL.LayoutRowEnd;

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;
1446:
1447: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1448: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
1449: if I_ROWS_FETCHED <> 0 then

Line 1462: XNP_WSGL.LayoutClose;

1458: I_TOTAL_ROWS := I_TOTAL_ROWS + I_ROWS_FETCHED;
1459:
1460: end loop;
1461:
1462: XNP_WSGL.LayoutClose;
1463:
1464: if I_START = I_TOTAL_ROWS then
1465: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
1466: else

Line 1465: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);

1461:
1462: XNP_WSGL.LayoutClose;
1463:
1464: if I_START = I_TOTAL_ROWS then
1465: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
1466: else
1467: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
1468: to_char(I_START), to_char(I_TOTAL_ROWS))||
1469: I_OF_TOTAL_TEXT);

Line 1467: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,

1463:
1464: if I_START = I_TOTAL_ROWS then
1465: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
1466: else
1467: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
1468: to_char(I_START), to_char(I_TOTAL_ROWS))||
1469: I_OF_TOTAL_TEXT);
1470: end if;
1471: htp.para;

Line 1473: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));

1469: I_OF_TOTAL_TEXT);
1470: end if;
1471: htp.para;
1472: else
1473: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
1474: end if;
1475:
1476: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
1477: dbms_sql.close_cursor(I_CURSOR);

Line 1481: XNP_WSGL.HiddenField('P_L_NRE_OBJECT_REFERENCE', P_L_NRE_OBJECT_REFERENCE);

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);
1485: XNP_WSGL.HiddenField('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);

Line 1482: XNP_WSGL.HiddenField('P_L_NRE2_OBJECT_REFERENCE', P_L_NRE2_OBJECT_REFERENCE);

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);
1485: XNP_WSGL.HiddenField('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1486: XNP_WSGL.HiddenField('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);

Line 1483: XNP_WSGL.HiddenField('P_PERMISSIVE_DIAL_START_DATE', P_PERMISSIVE_DIAL_START_DATE);

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);
1485: XNP_WSGL.HiddenField('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1486: XNP_WSGL.HiddenField('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1487: XNP_WSGL.HiddenField('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);

Line 1484: XNP_WSGL.HiddenField('U_PERMISSIVE_DIAL_START_DATE', U_PERMISSIVE_DIAL_START_DATE);

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);
1485: XNP_WSGL.HiddenField('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1486: XNP_WSGL.HiddenField('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1487: XNP_WSGL.HiddenField('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1488: XNP_WSGL.HiddenField('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);

Line 1485: XNP_WSGL.HiddenField('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);

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);
1485: XNP_WSGL.HiddenField('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1486: XNP_WSGL.HiddenField('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1487: XNP_WSGL.HiddenField('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1488: XNP_WSGL.HiddenField('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1489: XNP_WSGL.HiddenField('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);

Line 1486: XNP_WSGL.HiddenField('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);

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);
1485: XNP_WSGL.HiddenField('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1486: XNP_WSGL.HiddenField('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1487: XNP_WSGL.HiddenField('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1488: XNP_WSGL.HiddenField('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1489: XNP_WSGL.HiddenField('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);
1490: XNP_WSGL.HiddenField('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);

Line 1487: XNP_WSGL.HiddenField('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);

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);
1485: XNP_WSGL.HiddenField('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1486: XNP_WSGL.HiddenField('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1487: XNP_WSGL.HiddenField('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1488: XNP_WSGL.HiddenField('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1489: XNP_WSGL.HiddenField('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);
1490: XNP_WSGL.HiddenField('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);
1491: XNP_WSGL.HiddenField('Z_START', to_char(I_START));

Line 1488: XNP_WSGL.HiddenField('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);

1484: XNP_WSGL.HiddenField('U_PERMISSIVE_DIAL_START_DATE', U_PERMISSIVE_DIAL_START_DATE);
1485: XNP_WSGL.HiddenField('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1486: XNP_WSGL.HiddenField('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1487: XNP_WSGL.HiddenField('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1488: XNP_WSGL.HiddenField('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1489: XNP_WSGL.HiddenField('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);
1490: XNP_WSGL.HiddenField('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);
1491: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
1492: htp.p ('');

Line 1497: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_FIRST_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE,

1493: htp.p ('document.write ('''')');
1494: htp.p ('//-->');
1495: htp.p ('');
1496:
1497: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_FIRST_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE,
1498: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
1499: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_PREV_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE,
1500: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1501: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_NEXT_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,

Line 1499: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_PREV_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE,

1495: htp.p ('');
1496:
1497: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_FIRST_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE,
1498: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
1499: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_PREV_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE,
1500: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1501: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_NEXT_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,
1502: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1503: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_LAST_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,

Line 1501: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_NEXT_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,

1497: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_FIRST_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE,
1498: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
1499: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_PREV_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE,
1500: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1501: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_NEXT_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,
1502: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1503: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_LAST_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,
1504: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
1505:

Line 1503: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_LAST_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,

1499: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_PREV_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE,
1500: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1501: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_NEXT_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,
1502: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1503: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_LAST_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,
1504: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
1505:
1506: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
1507: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');

Line 1506: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,

1502: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1503: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_LAST_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,
1504: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
1505:
1506: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
1507: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
1508: XNP_WSGL.HiddenField('Z_CHK',
1509: to_char(XNP_WSGL.Checksum('')));
1510: htp.formClose;

Line 1508: XNP_WSGL.HiddenField('Z_CHK',

1504: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
1505:
1506: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
1507: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
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"');

Line 1509: to_char(XNP_WSGL.Checksum('')));

1505:
1506: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
1507: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
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 ('');
1521:
1522: if XNP_WSGL.IsSupported ('NOSCRIPT')
1523: then
1524:
1525: htp.p ('

Line 1530: XNP_WSGL.HiddenField('Z_CHK',

1526: htp.formSubmit('Z_ACTION', htf.escape_sc(RL_QUERY_BUT_CAPTION));
1527: htp.p ('');
1528:
1529: end if;
1530: XNP_WSGL.HiddenField('Z_CHK',
1531: to_char(XNP_WSGL.Checksum('')));
1532: htp.formClose;
1533:
1534: XNP_WSGL.ClosePageBody;

Line 1531: to_char(XNP_WSGL.Checksum('')));

1527: htp.p ('');
1528:
1529: end if;
1530: XNP_WSGL.HiddenField('Z_CHK',
1531: to_char(XNP_WSGL.Checksum('')));
1532: htp.formClose;
1533:
1534: XNP_WSGL.ClosePageBody;
1535:

Line 1534: XNP_WSGL.ClosePageBody;

1530: XNP_WSGL.HiddenField('Z_CHK',
1531: to_char(XNP_WSGL.Checksum('')));
1532: htp.formClose;
1533:
1534: XNP_WSGL.ClosePageBody;
1535:
1536: exception
1537: when others then
1538: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',

Line 1538: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',

1534: XNP_WSGL.ClosePageBody;
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:

Line 1540: XNP_WSGL.ClosePageBody;

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: --------------------------------------------------------------------------------
1544: -- Name: xnp_number_splits$number_split.QueryFirst

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 1574: XNP_WSGL.AddURLParam('P_L_NRE_OBJECT_REFERENCE', P_L_NRE_OBJECT_REFERENCE);

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);
1578: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);

Line 1575: XNP_WSGL.AddURLParam('P_L_NRE2_OBJECT_REFERENCE', P_L_NRE2_OBJECT_REFERENCE);

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);
1578: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1579: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);

Line 1576: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_START_DATE', P_PERMISSIVE_DIAL_START_DATE);

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);
1578: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1579: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1580: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);

Line 1577: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_START_DATE', U_PERMISSIVE_DIAL_START_DATE);

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);
1578: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1579: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1580: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1581: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);

Line 1578: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);

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);
1578: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1579: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1580: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1581: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1582: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);

Line 1579: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);

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);
1578: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1579: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1580: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1581: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1582: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);
1583: XNP_WSGL.AddURLParam('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);

Line 1580: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);

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);
1578: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1579: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1580: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1581: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1582: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);
1583: XNP_WSGL.AddURLParam('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);
1584: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);

Line 1581: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);

1577: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_START_DATE', U_PERMISSIVE_DIAL_START_DATE);
1578: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1579: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1580: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1581: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1582: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);
1583: XNP_WSGL.AddURLParam('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);
1584: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1585: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

Line 1582: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);

1578: XNP_WSGL.AddURLParam('P_PERMISSIVE_DIAL_END_DATE', P_PERMISSIVE_DIAL_END_DATE);
1579: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1580: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1581: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1582: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);
1583: XNP_WSGL.AddURLParam('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);
1584: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1585: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1586: if not Z_DIRECT_CALL then

Line 1583: XNP_WSGL.AddURLParam('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);

1579: XNP_WSGL.AddURLParam('U_PERMISSIVE_DIAL_END_DATE', U_PERMISSIVE_DIAL_END_DATE);
1580: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1581: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1582: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);
1583: XNP_WSGL.AddURLParam('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);
1584: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1585: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1586: if not Z_DIRECT_CALL then
1587: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

Line 1584: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);

1580: XNP_WSGL.AddURLParam('P_L_NRE_STARTING_NUMBER', P_L_NRE_STARTING_NUMBER);
1581: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1582: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);
1583: XNP_WSGL.AddURLParam('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);
1584: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1585: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1586: if not Z_DIRECT_CALL then
1587: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1588: return;

Line 1585: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

1581: XNP_WSGL.AddURLParam('P_L_NRE_ENDING_NUMBER', P_L_NRE_ENDING_NUMBER);
1582: XNP_WSGL.AddURLParam('P_L_NRE2_STARTING_NUMBER', P_L_NRE2_STARTING_NUMBER);
1583: XNP_WSGL.AddURLParam('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);
1584: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1585: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1586: if not Z_DIRECT_CALL then
1587: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1588: return;
1589: end if;

Line 1587: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

1583: XNP_WSGL.AddURLParam('P_L_NRE2_ENDING_NUMBER', P_L_NRE2_ENDING_NUMBER);
1584: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1585: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1586: if not Z_DIRECT_CALL then
1587: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1588: return;
1589: end if;
1590: end if;
1591:

Line 1593: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);

1589: end if;
1590: end if;
1591:
1592: if Z_ACTION = 'BLANK' then
1593: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1594: return;
1595: end if;
1596:
1597:

Line 1623: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,

1619: P_L_NRE_STARTING_NUMBER,
1620: P_L_NRE_ENDING_NUMBER,
1621: P_L_NRE2_STARTING_NUMBER,
1622: P_L_NRE2_ENDING_NUMBER) then
1623: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1624: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);
1625: return;
1626: end if;
1627:

Line 1641: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);

1637:
1638: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1639:
1640: if I_ROWS_FETCHED = 0 then
1641: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1642: else
1643: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.NUMBER_SPLIT_ID);
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);

Line 1655: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',

1651: dbms_sql.close_cursor(I_CURSOR);
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:

Line 1657: XNP_WSGL.ClosePageBody;

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: --------------------------------------------------------------------------------
1661: -- Name: xnp_number_splits$number_split.PreQuery

Line 1688: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',

1684: begin
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:

Line 1711: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',

1707: begin
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:

Line 1794: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',

1790:
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: --------------------------------------------------------------------------------

Line 1813: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'View Number Splits'||' : '||'Number Split Details',

1809: htp.p('var FormType = "List";');
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;