242: XNP_WSGL.ClosePageHead;
243:
244: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
245:
246: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
247: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPSVNWK_ORDERS_TITLE')));
248: if (Z_ACTION = RL_LAST_BUT_ACTION) or (Z_ACTION = RL_LAST_BUT_CAPTION) or
249: (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
250: (RL_TOTAL_COUNT_REQD)
243:
244: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
245:
246: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
247: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPSVNWK_ORDERS_TITLE')));
248: if (Z_ACTION = RL_LAST_BUT_ACTION) or (Z_ACTION = RL_LAST_BUT_CAPTION) or
249: (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
250: (RL_TOTAL_COUNT_REQD)
251: then
364:
365: XNP_WSGL.LayoutClose;
366:
367: if I_START = I_TOTAL_ROWS then
368: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
369: else
370: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
371: to_char(I_START), to_char(I_TOTAL_ROWS))||
372: I_OF_TOTAL_TEXT);
366:
367: if I_START = I_TOTAL_ROWS then
368: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
369: else
370: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
371: to_char(I_START), to_char(I_TOTAL_ROWS))||
372: I_OF_TOTAL_TEXT);
373: end if;
374: htp.para;
370: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
371: to_char(I_START), to_char(I_TOTAL_ROWS))||
372: I_OF_TOTAL_TEXT);
373: end if;
374: htp.para;
375: else
376: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
377: end if;
378:
372: I_OF_TOTAL_TEXT);
373: end if;
374: htp.para;
375: else
376: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
377: end if;
378:
379: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
380: dbms_sql.close_cursor(I_CURSOR);
379: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
380: dbms_sql.close_cursor(I_CURSOR);
381: end if;
382:
383: htp.formOpen(curl => 'xnp_sv_network$sms_order.querylist', cattributes => 'NAME="frmZero"');
384: XNP_WSGL.HiddenField('P_SV_SMS_ID', P_SV_SMS_ID);
385: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
386: htp.p ('');
390:
383: htp.formOpen(curl => 'xnp_sv_network$sms_order.querylist', cattributes => 'NAME="frmZero"');
384: XNP_WSGL.HiddenField('P_SV_SMS_ID', P_SV_SMS_ID);
385: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
386: htp.p ('');
390:
391: 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,
384: XNP_WSGL.HiddenField('P_SV_SMS_ID', P_SV_SMS_ID);
385: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
386: htp.p ('');
390:
391: 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,
392: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
385: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
386: htp.p ('');
390:
391: 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,
392: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
393: 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,
400: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
401: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
402: XNP_WSGL.HiddenField('Z_CHK',
403: to_char(XNP_WSGL.Checksum(''||P_SV_SMS_ID)));
404: htp.formClose;
405:
406: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);
407: XNP_WSGL.NavLinks;
408:
405:
406: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);
407: XNP_WSGL.NavLinks;
408:
409: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
410:
411: XNP_WSGL.ClosePageBody;
412:
413: exception
474: --
475: --------------------------------------------------------------------------------
476: procedure CreateListJavaScript is
477: begin
478: htp.p(XNP_WSGJSL.OpenScript);
479: htp.p('var FormType = "List";');
480: htp.p(XNP_WSGJSL.CloseScript);
481: exception
482: when others then
475: --------------------------------------------------------------------------------
476: procedure CreateListJavaScript is
477: begin
478: htp.p(XNP_WSGJSL.OpenScript);
479: htp.p('var FormType = "List";');
480: htp.p(XNP_WSGJSL.CloseScript);
481: exception
482: when others then
483: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Order Workitems',
476: procedure CreateListJavaScript is
477: begin
478: htp.p(XNP_WSGJSL.OpenScript);
479: htp.p('var FormType = "List";');
480: htp.p(XNP_WSGJSL.CloseScript);
481: exception
482: when others then
483: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Order Workitems',
484: RL_BODY_ATTRIBUTES, 'xnp_sv_network$sms_order.CreateListJavaScript');