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 ('');
980: htp.formSubmit('Z_ACTION', htf.escape_sc(QF_QUERY_BUT_CAPTION));
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 ('');
1526: htp.formSubmit('Z_ACTION', htf.escape_sc(RL_QUERY_BUT_CAPTION));
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;