277: XNP_WSGL.ClosePageHead;
278:
279: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
280:
281: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
282: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPSVORD_EVENTS_TITLE')));
283: if (Z_ACTION = RL_LAST_BUT_ACTION) or (Z_ACTION = RL_LAST_BUT_CAPTION) or
284: (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
285: (RL_TOTAL_COUNT_REQD)
278:
279: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
280:
281: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
282: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPSVORD_EVENTS_TITLE')));
283: if (Z_ACTION = RL_LAST_BUT_ACTION) or (Z_ACTION = RL_LAST_BUT_CAPTION) or
284: (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
285: (RL_TOTAL_COUNT_REQD)
286: then
408:
409: XNP_WSGL.LayoutClose;
410:
411: if I_START = I_TOTAL_ROWS then
412: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
413: else
414: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
415: to_char(I_START), to_char(I_TOTAL_ROWS))||
416: I_OF_TOTAL_TEXT);
410:
411: if I_START = I_TOTAL_ROWS then
412: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
413: else
414: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
415: to_char(I_START), to_char(I_TOTAL_ROWS))||
416: I_OF_TOTAL_TEXT);
417: end if;
418: htp.para;
414: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
415: to_char(I_START), to_char(I_TOTAL_ROWS))||
416: I_OF_TOTAL_TEXT);
417: end if;
418: htp.para;
419: else
420: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
421: end if;
422:
416: I_OF_TOTAL_TEXT);
417: end if;
418: htp.para;
419: else
420: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
421: end if;
422:
423: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
424: dbms_sql.close_cursor(I_CURSOR);
423: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
424: dbms_sql.close_cursor(I_CURSOR);
425: end if;
426:
427: htp.formOpen(curl => 'xnp_sv_orders$soa_events.querylist', cattributes => 'NAME="frmZero"');
428: XNP_WSGL.HiddenField('P_SV_SOA_ID', P_SV_SOA_ID);
429: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
430: htp.p ('');
434:
427: htp.formOpen(curl => 'xnp_sv_orders$soa_events.querylist', cattributes => 'NAME="frmZero"');
428: XNP_WSGL.HiddenField('P_SV_SOA_ID', P_SV_SOA_ID);
429: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
430: htp.p ('');
434:
435: 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,
428: XNP_WSGL.HiddenField('P_SV_SOA_ID', P_SV_SOA_ID);
429: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
430: htp.p ('');
434:
435: 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,
436: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
429: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
430: htp.p ('');
434:
435: 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,
436: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
437: 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,
444: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
445: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
446: XNP_WSGL.HiddenField('Z_CHK',
447: to_char(XNP_WSGL.Checksum(''||P_SV_SOA_ID)));
448: htp.formClose;
449:
450: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);
451: XNP_WSGL.NavLinks;
452:
449:
450: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);
451: XNP_WSGL.NavLinks;
452:
453: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
454:
455: XNP_WSGL.ClosePageBody;
456:
457: exception
518: --
519: --------------------------------------------------------------------------------
520: procedure CreateListJavaScript is
521: begin
522: htp.p(XNP_WSGJSL.OpenScript);
523: htp.p('var FormType = "List";');
524: htp.p(XNP_WSGJSL.CloseScript);
525: exception
526: when others then
519: --------------------------------------------------------------------------------
520: procedure CreateListJavaScript is
521: begin
522: htp.p(XNP_WSGJSL.OpenScript);
523: htp.p('var FormType = "List";');
524: htp.p(XNP_WSGJSL.CloseScript);
525: exception
526: when others then
527: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',
520: procedure CreateListJavaScript is
521: begin
522: htp.p(XNP_WSGJSL.OpenScript);
523: htp.p('var FormType = "List";');
524: htp.p(XNP_WSGJSL.CloseScript);
525: exception
526: when others then
527: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',
528: RL_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.CreateListJavaScript');