36: P_NEXT_TIMER in varchar2 default null,
37: Z_MODE in varchar2 default 'D') return boolean;
38:
39: QF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
40: QF_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIND_BUTTON'));
41: QF_CLEAR_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_CLEAR_BUTTON'));
42: QF_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
43: QF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
44: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
37: Z_MODE in varchar2 default 'D') return boolean;
38:
39: QF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
40: QF_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIND_BUTTON'));
41: QF_CLEAR_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_CLEAR_BUTTON'));
42: QF_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
43: QF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
44: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
45: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
51: VF_DELETE_BUT_ACTION constant varchar2(10) := 'DELETE';
52: VF_VERIFIED_DELETE constant varchar2(100) := 'VerifiedDelete';
53: VF_NUMBER_OF_COLUMNS constant number(4) := 2;
54: RL_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
55: RL_NEXT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_NEXT_BUTTON'));
56: RL_PREV_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_PREVIOUS_BUTTON'));
57: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
58: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
59: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
52: VF_VERIFIED_DELETE constant varchar2(100) := 'VerifiedDelete';
53: VF_NUMBER_OF_COLUMNS constant number(4) := 2;
54: RL_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
55: RL_NEXT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_NEXT_BUTTON'));
56: RL_PREV_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_PREVIOUS_BUTTON'));
57: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
58: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
59: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
60: RL_REQUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_REFRESH_BUTTON'));
53: VF_NUMBER_OF_COLUMNS constant number(4) := 2;
54: RL_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
55: RL_NEXT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_NEXT_BUTTON'));
56: RL_PREV_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_PREVIOUS_BUTTON'));
57: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
58: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
59: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
60: RL_REQUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_REFRESH_BUTTON'));
61: RL_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_SEARCH_BUTTON'));
54: RL_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
55: RL_NEXT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_NEXT_BUTTON'));
56: RL_PREV_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_PREVIOUS_BUTTON'));
57: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
58: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
59: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
60: RL_REQUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_REFRESH_BUTTON'));
61: RL_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_SEARCH_BUTTON'));
62: RL_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
55: RL_NEXT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_NEXT_BUTTON'));
56: RL_PREV_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_PREVIOUS_BUTTON'));
57: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
58: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
59: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
60: RL_REQUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_REFRESH_BUTTON'));
61: RL_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_SEARCH_BUTTON'));
62: RL_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
63: RL_NEXT_BUT_ACTION constant varchar2(10) := 'NEXT';
56: RL_PREV_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_PREVIOUS_BUTTON'));
57: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
58: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
59: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
60: RL_REQUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_REFRESH_BUTTON'));
61: RL_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_SEARCH_BUTTON'));
62: RL_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
63: RL_NEXT_BUT_ACTION constant varchar2(10) := 'NEXT';
64: RL_PREV_BUT_ACTION constant varchar2(10) := 'PREV';
57: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
58: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
59: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
60: RL_REQUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_REFRESH_BUTTON'));
61: RL_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_SEARCH_BUTTON'));
62: RL_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
63: RL_NEXT_BUT_ACTION constant varchar2(10) := 'NEXT';
64: RL_PREV_BUT_ACTION constant varchar2(10) := 'PREV';
65: RL_FIRST_BUT_ACTION constant varchar2(10) := 'FIRST';
69: RL_RECORD_SET_SIZE constant number(4) := 12;
70: RL_TOTAL_COUNT_REQD constant boolean := TRUE;
71: RL_NUMBER_OF_COLUMNS constant number(4) := 1;
72: LOV_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
73: LOV_FIND_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIND_BUTTON'));
74: LOV_CLOSE_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_CLOSE_BUTTON'));
75: LOV_FIND_BUT_ACTION constant varchar2(10) := 'FIND';
76: LOV_CLOSE_BUT_ACTION constant varchar2(10) := 'CLOSE';
77: LOV_BUTTON_TEXT constant varchar2(100) := htf.italic(fnd_message.get_string('XNP','LIST_OF_VALUES'));
70: RL_TOTAL_COUNT_REQD constant boolean := TRUE;
71: RL_NUMBER_OF_COLUMNS constant number(4) := 1;
72: LOV_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
73: LOV_FIND_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIND_BUTTON'));
74: LOV_CLOSE_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_CLOSE_BUTTON'));
75: LOV_FIND_BUT_ACTION constant varchar2(10) := 'FIND';
76: LOV_CLOSE_BUT_ACTION constant varchar2(10) := 'CLOSE';
77: LOV_BUTTON_TEXT constant varchar2(100) := htf.italic(fnd_message.get_string('XNP','LIST_OF_VALUES'));
78: LOV_FRAME constant varchar2(20) := null;
73: LOV_FIND_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIND_BUTTON'));
74: LOV_CLOSE_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_CLOSE_BUTTON'));
75: LOV_FIND_BUT_ACTION constant varchar2(10) := 'FIND';
76: LOV_CLOSE_BUT_ACTION constant varchar2(10) := 'CLOSE';
77: LOV_BUTTON_TEXT constant varchar2(100) := htf.italic(fnd_message.get_string('XNP','LIST_OF_VALUES'));
78: LOV_FRAME constant varchar2(20) := null;
79: TF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
80: DEF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
81:
824: -- <<
825:
826: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>QF_BODY_ATTRIBUTES);
827:
828: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
829: xnp_timers$.FirstPage(TRUE);
830: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPTIMER_DETAILS_TITLE')));
831: htp.para;
832: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Timers'));
826: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>QF_BODY_ATTRIBUTES);
827:
828: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
829: xnp_timers$.FirstPage(TRUE);
830: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPTIMER_DETAILS_TITLE')));
831: htp.para;
832: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Timers'));
833: htp.para;
834:
930: XNP_WSGL.ClosePageHead;
931:
932: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);
933:
934: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
935: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPTIMER_DETAILS_TITLE')));
936: InitialiseDomain('STATUS');
937:
938:
931:
932: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);
933:
934: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
935: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPTIMER_DETAILS_TITLE')));
936: InitialiseDomain('STATUS');
937:
938:
939:
1207: XNP_WSGL.ClosePageHead;
1208:
1209: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
1210:
1211: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
1212: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPTIMER_DETAILS_TITLE')));
1213: if (Z_ACTION = RL_LAST_BUT_ACTION) or (Z_ACTION = RL_LAST_BUT_CAPTION) or
1214: (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
1215: (RL_TOTAL_COUNT_REQD)
1208:
1209: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
1210:
1211: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
1212: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPTIMER_DETAILS_TITLE')));
1213: if (Z_ACTION = RL_LAST_BUT_ACTION) or (Z_ACTION = RL_LAST_BUT_CAPTION) or
1214: (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
1215: (RL_TOTAL_COUNT_REQD)
1216: then