39: P_L_NRE_ENDING_NUMBER in varchar2 default null,
40: Z_MODE in varchar2 default 'D') return boolean;
41:
42: QF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
43: QF_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIND_BUTTON'));
44: QF_CLEAR_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_CLEAR_BUTTON'));
45: QF_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
46: QF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
47: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
40: Z_MODE in varchar2 default 'D') return boolean;
41:
42: QF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
43: QF_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIND_BUTTON'));
44: QF_CLEAR_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_CLEAR_BUTTON'));
45: QF_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
46: QF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
47: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
48: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
54: VF_DELETE_BUT_ACTION constant varchar2(10) := 'DELETE';
55: VF_VERIFIED_DELETE constant varchar2(100) := 'VerifiedDelete';
56: VF_NUMBER_OF_COLUMNS constant number(4) := 2;
57: RL_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
58: RL_NEXT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_NEXT_BUTTON'));
59: RL_PREV_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_PREVIOUS_BUTTON'));
60: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
61: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
62: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
55: VF_VERIFIED_DELETE constant varchar2(100) := 'VerifiedDelete';
56: VF_NUMBER_OF_COLUMNS constant number(4) := 2;
57: RL_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
58: RL_NEXT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_NEXT_BUTTON'));
59: RL_PREV_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_PREVIOUS_BUTTON'));
60: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
61: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
62: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
63: RL_REQUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_REFRESH_BUTTON'));
56: VF_NUMBER_OF_COLUMNS constant number(4) := 2;
57: RL_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
58: RL_NEXT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_NEXT_BUTTON'));
59: RL_PREV_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_PREVIOUS_BUTTON'));
60: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
61: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
62: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
63: RL_REQUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_REFRESH_BUTTON'));
64: RL_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_SEARCH_BUTTON'));
57: RL_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
58: RL_NEXT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_NEXT_BUTTON'));
59: RL_PREV_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_PREVIOUS_BUTTON'));
60: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
61: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
62: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
63: RL_REQUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_REFRESH_BUTTON'));
64: RL_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_SEARCH_BUTTON'));
65: RL_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
58: RL_NEXT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_NEXT_BUTTON'));
59: RL_PREV_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_PREVIOUS_BUTTON'));
60: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
61: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
62: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
63: RL_REQUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_REFRESH_BUTTON'));
64: RL_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_SEARCH_BUTTON'));
65: RL_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
66: RL_NEXT_BUT_ACTION constant varchar2(10) := 'NEXT';
59: RL_PREV_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_PREVIOUS_BUTTON'));
60: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
61: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
62: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
63: RL_REQUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_REFRESH_BUTTON'));
64: RL_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_SEARCH_BUTTON'));
65: RL_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
66: RL_NEXT_BUT_ACTION constant varchar2(10) := 'NEXT';
67: RL_PREV_BUT_ACTION constant varchar2(10) := 'PREV';
60: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
61: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
62: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
63: RL_REQUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_REFRESH_BUTTON'));
64: RL_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_SEARCH_BUTTON'));
65: RL_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
66: RL_NEXT_BUT_ACTION constant varchar2(10) := 'NEXT';
67: RL_PREV_BUT_ACTION constant varchar2(10) := 'PREV';
68: RL_FIRST_BUT_ACTION constant varchar2(10) := 'FIRST';
72: RL_RECORD_SET_SIZE constant number(4) := 10;
73: RL_TOTAL_COUNT_REQD constant boolean := TRUE;
74: RL_NUMBER_OF_COLUMNS constant number(4) := 1;
75: LOV_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
76: LOV_FIND_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIND_BUTTON'));
77: LOV_CLOSE_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_CLOSE_BUTTON'));
78: LOV_FIND_BUT_ACTION constant varchar2(10) := 'FIND';
79: LOV_CLOSE_BUT_ACTION constant varchar2(10) := 'CLOSE';
80: LOV_BUTTON_TEXT constant varchar2(100) := htf.italic(fnd_message.get_string('XNP','LIST_OF_VALUES'));
73: RL_TOTAL_COUNT_REQD constant boolean := TRUE;
74: RL_NUMBER_OF_COLUMNS constant number(4) := 1;
75: LOV_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
76: LOV_FIND_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIND_BUTTON'));
77: LOV_CLOSE_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_CLOSE_BUTTON'));
78: LOV_FIND_BUT_ACTION constant varchar2(10) := 'FIND';
79: LOV_CLOSE_BUT_ACTION constant varchar2(10) := 'CLOSE';
80: LOV_BUTTON_TEXT constant varchar2(100) := htf.italic(fnd_message.get_string('XNP','LIST_OF_VALUES'));
81: LOV_FRAME constant varchar2(20) := null;
76: LOV_FIND_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIND_BUTTON'));
77: LOV_CLOSE_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_CLOSE_BUTTON'));
78: LOV_FIND_BUT_ACTION constant varchar2(10) := 'FIND';
79: LOV_CLOSE_BUT_ACTION constant varchar2(10) := 'CLOSE';
80: LOV_BUTTON_TEXT constant varchar2(100) := htf.italic(fnd_message.get_string('XNP','LIST_OF_VALUES'));
81: LOV_FRAME constant varchar2(20) := null;
82: TF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
83: DEF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
84:
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;
685:
686: if Z_FIRST is not null then
687: xnp_number_splits$.FirstPage(TRUE);
687: xnp_number_splits$.FirstPage(TRUE);
688: end if;
689:
690: if Z_TEXT is not null then
691: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPNUMSP_DETAILS_TITLE')));
692: end if;
693:
694: if Z_FOOTER is not null then
695: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
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')));
915: htp.para;
916: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Number Split Details'));
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')));
915: htp.para;
916: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Number Split Details'));
917: htp.para;
918: