[Home] [Help]
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"';
46: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);
47: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT);
48: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);
49: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE';
50: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
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"';
46: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);
47: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT);
48: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);
49: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE';
50: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
51: VF_DELETE_BUT_ACTION constant varchar2(10) := 'DELETE';
44: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
45: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
46: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);
47: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT);
48: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);
49: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE';
50: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
51: VF_DELETE_BUT_ACTION constant varchar2(10) := 'DELETE';
52: VF_VERIFIED_DELETE constant varchar2(100) := 'VerifiedDelete';
102: NBT_VAL NBT_REC;
103:
104: ZONE_SQL VARCHAR2(2236) := null;
105:
106: D_STATUS XNP_WSGL.typDVRecord;
107: --------------------------------------------------------------------------------
108: -- Name: xnp_timers$xnp_timer_registry.InitialiseDomain
109: --
110: -- Description: Initialises the Domain Record for the given Column Usage
116: begin
117:
118: if P_ALIAS = 'STATUS' and not D_STATUS.Initialised then
119: D_STATUS.ColAlias := 'STATUS';
120: D_STATUS.ControlType := XNP_WSGL.DV_TEXT;
121: D_STATUS.DispWidth := 20;
122: D_STATUS.DispHeight := 1;
123: D_STATUS.MaxWidth := 20;
124: D_STATUS.UseMeanings := False;
143: end if;
144:
145: exception
146: when others then
147: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
148: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.InitialseDomain');
149: end;
150:
151: --------------------------------------------------------------------------------
169: return TRUE;
170: exception
171: when no_data_found then
172: XNP_cg$errors.push('Timer: '||
173: XNP_WSGL.MsgGetText(226,XNP_WSGLM.MSG226_INVALID_FK),
174: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.TIMER_MESSAGE_CODE_TranslateFK');
175: return FALSE;
176: when too_many_rows then
177: XNP_cg$errors.push('Timer: '||
174: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.TIMER_MESSAGE_CODE_TranslateFK');
175: return FALSE;
176: when too_many_rows then
177: XNP_cg$errors.push('Timer: '||
178: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),
179: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.TIMER_MESSAGE_CODE_TranslateFK');
180: return FALSE;
181: when others then
182: XNP_cg$errors.push('Timer: '||SQLERRM,
205: return TRUE;
206: exception
207: when no_data_found then
208: XNP_cg$errors.push('Next Timer: '||
209: XNP_WSGL.MsgGetText(226,XNP_WSGLM.MSG226_INVALID_FK),
210: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.NEXT_TIMER_TranslateFK');
211: return FALSE;
212: when too_many_rows then
213: XNP_cg$errors.push('Next Timer: '||
210: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.NEXT_TIMER_TranslateFK');
211: return FALSE;
212: when too_many_rows then
213: XNP_cg$errors.push('Next Timer: '||
214: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),
215: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.NEXT_TIMER_TranslateFK');
216: return FALSE;
217: when others then
218: XNP_cg$errors.push('Next Timer: '||SQLERRM,
238: L_ANY boolean := FALSE;
239: L_BODY_ATTRIBUTES VarChar2 (1000) := LOV_BODY_ATTRIBUTES;
240: begin
241:
242: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.timer_message_code_listofvalue');
243: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
244: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
245: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
246: if XNP_WSGL.NotLowerCase then
239: L_BODY_ATTRIBUTES VarChar2 (1000) := LOV_BODY_ATTRIBUTES;
240: begin
241:
242: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.timer_message_code_listofvalue');
243: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
244: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
245: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
246: if XNP_WSGL.NotLowerCase then
247: return;
240: begin
241:
242: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.timer_message_code_listofvalue');
243: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
244: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
245: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
246: if XNP_WSGL.NotLowerCase then
247: return;
248: end if;
241:
242: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.timer_message_code_listofvalue');
243: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
244: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
245: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
246: if XNP_WSGL.NotLowerCase then
247: return;
248: end if;
249:
242: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.timer_message_code_listofvalue');
243: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
244: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
245: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
246: if XNP_WSGL.NotLowerCase then
247: return;
248: end if;
249:
250:
247: return;
248: end if;
249:
250:
251: XNP_WSGL.OpenPageHead('Timers');
252:
253: if Z_ISSUE_WAIT is not null then
254:
255: htp.p ('');
366:
367: XNP_WSGL.ClosePageBody;
368:
369: exception
370: when others then
371: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry',
367: XNP_WSGL.ClosePageBody;
368:
369: exception
370: when others then
371: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry',
372: LOV_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.timer_message_code_listofvalue');
373: end;
374:
375: --------------------------------------------------------------------------------
391: L_ANY boolean := FALSE;
392: L_BODY_ATTRIBUTES VarChar2 (1000) := LOV_BODY_ATTRIBUTES;
393: begin
394:
395: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.next_timer_listofvalues');
396: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
397: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
398: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
399: if XNP_WSGL.NotLowerCase then
392: L_BODY_ATTRIBUTES VarChar2 (1000) := LOV_BODY_ATTRIBUTES;
393: begin
394:
395: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.next_timer_listofvalues');
396: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
397: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
398: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
399: if XNP_WSGL.NotLowerCase then
400: return;
393: begin
394:
395: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.next_timer_listofvalues');
396: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
397: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
398: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
399: if XNP_WSGL.NotLowerCase then
400: return;
401: end if;
394:
395: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.next_timer_listofvalues');
396: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
397: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
398: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
399: if XNP_WSGL.NotLowerCase then
400: return;
401: end if;
402:
395: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.next_timer_listofvalues');
396: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
397: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
398: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
399: if XNP_WSGL.NotLowerCase then
400: return;
401: end if;
402:
403:
400: return;
401: end if;
402:
403:
404: XNP_WSGL.OpenPageHead(XNP_WSGL.MsgGetText(123,XNP_WSGLM.DSP123_LOV_CAPTION,
405: 'Next Timer'));
406:
407: if Z_ISSUE_WAIT is not null then
408:
418: else
419: htp.p('');
520:
521: XNP_WSGL.ClosePageBody;
522:
523: exception
524: when others then
525: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry',
521: XNP_WSGL.ClosePageBody;
522:
523: exception
524: when others then
525: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry',
526: LOV_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.next_timer_listofvalues');
527: end;
528:
529: --------------------------------------------------------------------------------
539: Z_DIRECT_CALL in boolean,
540: Z_CHK in varchar2) is
541: begin
542:
543: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.startup');
544: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
545:
546: if not Z_DIRECT_CALL then
547: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
540: Z_CHK in varchar2) is
541: begin
542:
543: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.startup');
544: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
545:
546: if not Z_DIRECT_CALL then
547: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
548: return;
543: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.startup');
544: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
545:
546: if not Z_DIRECT_CALL then
547: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
548: return;
549: end if;
550: end if;
551:
548: return;
549: end if;
550: end if;
551:
552: XNP_WSGL.StoreURLLink(1, 'Timers');
553:
554:
555: FormQuery(
556: Z_DIRECT_CALL=>TRUE);
556: Z_DIRECT_CALL=>TRUE);
557:
558: exception
559: when others then
560: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
561: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.Startup');
562: end;
563:
564: --------------------------------------------------------------------------------
588: L_BUTCHK varchar2(100):= null;
589: begin
590:
591: if Z_DIRECT_CALL then
592: L_CHK := to_char(XNP_WSGL.Checksum(''));
593: else
594: if not XNP_WSGL.ValidateChecksum('', L_CHK) then
595: return;
596: end if;
590:
591: if Z_DIRECT_CALL then
592: L_CHK := to_char(XNP_WSGL.Checksum(''));
593: else
594: if not XNP_WSGL.ValidateChecksum('', L_CHK) then
595: return;
596: end if;
597: end if;
598:
611: null, L_BUTCHK, Z_DIRECT_CALL=>TRUE);
612:
613: exception
614: when others then
615: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
616: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.ActionQuery');
617: end;
618:
619: --------------------------------------------------------------------------------
665: U_START_TIME,
666: P_END_TIME,
667: U_END_TIME,
668: P_NEXT_TIMER) then
669: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
670: 'Timer Registry'||' : '||'Timers', DEF_BODY_ATTRIBUTES);
671: return -1;
672: end if;
673:
691: return I_COUNT;
692:
693: exception
694: when others then
695: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
696: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.QueryHits');
697: return -1;
698: end;--------------------------------------------------------------------------------
699: -- Name: xnp_timers$xnp_timer_registry.BuildSQL
725: I_WHERE := I_WHERE || ' where MESSAGE_TYPES_2.MSG_CODE = TIMER_REGISTRY.TIMER_MESSAGE_CODE';
726: I_WHERE := I_WHERE || ' and ' || 'MESSAGE_TYPES_2.MSG_TYPE = ''TIMER''';
727:
728: begin
729: XNP_WSGL.BuildWhere(P_ORDER_ID, U_ORDER_ID, 'TIMER_REGISTRY.ORDER_ID', XNP_WSGL.TYPE_NUMBER, I_WHERE);
730: exception
731: when others then
732: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
733: 'Timer Registry'||' : '||'Timers', DEF_BODY_ATTRIBUTES, NULL,
728: begin
729: XNP_WSGL.BuildWhere(P_ORDER_ID, U_ORDER_ID, 'TIMER_REGISTRY.ORDER_ID', XNP_WSGL.TYPE_NUMBER, I_WHERE);
730: exception
731: when others then
732: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
733: 'Timer Registry'||' : '||'Timers', DEF_BODY_ATTRIBUTES, NULL,
734: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Order Id'));
735: return false;
736: end;
730: exception
731: when others then
732: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
733: 'Timer Registry'||' : '||'Timers', DEF_BODY_ATTRIBUTES, NULL,
734: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Order Id'));
735: return false;
736: end;
737: XNP_WSGL.BuildWhere(P_REFERENCE_ID, 'TIMER_REGISTRY.REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
738: XNP_WSGL.BuildWhere(P_TIMER_MESSAGE_CODE, 'TIMER_REGISTRY.TIMER_MESSAGE_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
733: 'Timer Registry'||' : '||'Timers', DEF_BODY_ATTRIBUTES, NULL,
734: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Order Id'));
735: return false;
736: end;
737: XNP_WSGL.BuildWhere(P_REFERENCE_ID, 'TIMER_REGISTRY.REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
738: XNP_WSGL.BuildWhere(P_TIMER_MESSAGE_CODE, 'TIMER_REGISTRY.TIMER_MESSAGE_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
739: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_STATUS, P_STATUS), 'TIMER_REGISTRY.STATUS', XNP_WSGL.TYPE_CHAR, I_WHERE);
740: begin
741: XNP_WSGL.BuildWhere(P_START_TIME, U_START_TIME, 'TIMER_REGISTRY.START_TIME', XNP_WSGL.TYPE_DATE, I_WHERE, 'DD-MON-RRRR HH24:MI:SS');
734: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Order Id'));
735: return false;
736: end;
737: XNP_WSGL.BuildWhere(P_REFERENCE_ID, 'TIMER_REGISTRY.REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
738: XNP_WSGL.BuildWhere(P_TIMER_MESSAGE_CODE, 'TIMER_REGISTRY.TIMER_MESSAGE_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
739: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_STATUS, P_STATUS), 'TIMER_REGISTRY.STATUS', XNP_WSGL.TYPE_CHAR, I_WHERE);
740: begin
741: XNP_WSGL.BuildWhere(P_START_TIME, U_START_TIME, 'TIMER_REGISTRY.START_TIME', XNP_WSGL.TYPE_DATE, I_WHERE, 'DD-MON-RRRR HH24:MI:SS');
742: exception
735: return false;
736: end;
737: XNP_WSGL.BuildWhere(P_REFERENCE_ID, 'TIMER_REGISTRY.REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
738: XNP_WSGL.BuildWhere(P_TIMER_MESSAGE_CODE, 'TIMER_REGISTRY.TIMER_MESSAGE_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
739: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_STATUS, P_STATUS), 'TIMER_REGISTRY.STATUS', XNP_WSGL.TYPE_CHAR, I_WHERE);
740: begin
741: XNP_WSGL.BuildWhere(P_START_TIME, U_START_TIME, 'TIMER_REGISTRY.START_TIME', XNP_WSGL.TYPE_DATE, I_WHERE, 'DD-MON-RRRR HH24:MI:SS');
742: exception
743: when others then
737: XNP_WSGL.BuildWhere(P_REFERENCE_ID, 'TIMER_REGISTRY.REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
738: XNP_WSGL.BuildWhere(P_TIMER_MESSAGE_CODE, 'TIMER_REGISTRY.TIMER_MESSAGE_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
739: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_STATUS, P_STATUS), 'TIMER_REGISTRY.STATUS', XNP_WSGL.TYPE_CHAR, I_WHERE);
740: begin
741: XNP_WSGL.BuildWhere(P_START_TIME, U_START_TIME, 'TIMER_REGISTRY.START_TIME', XNP_WSGL.TYPE_DATE, I_WHERE, 'DD-MON-RRRR HH24:MI:SS');
742: exception
743: when others then
744: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
745: 'Timer Registry'||' : '||'Timers', DEF_BODY_ATTRIBUTES, NULL,
740: begin
741: XNP_WSGL.BuildWhere(P_START_TIME, U_START_TIME, 'TIMER_REGISTRY.START_TIME', XNP_WSGL.TYPE_DATE, I_WHERE, 'DD-MON-RRRR HH24:MI:SS');
742: exception
743: when others then
744: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
745: 'Timer Registry'||' : '||'Timers', DEF_BODY_ATTRIBUTES, NULL,
746: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Start Time'),
747: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR HH24:MI:SS')));
748: return false;
742: exception
743: when others then
744: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
745: 'Timer Registry'||' : '||'Timers', DEF_BODY_ATTRIBUTES, NULL,
746: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Start Time'),
747: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR HH24:MI:SS')));
748: return false;
749: end;
750: begin
743: when others then
744: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
745: 'Timer Registry'||' : '||'Timers', DEF_BODY_ATTRIBUTES, NULL,
746: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Start Time'),
747: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR HH24:MI:SS')));
748: return false;
749: end;
750: begin
751: XNP_WSGL.BuildWhere(P_END_TIME, U_END_TIME, 'TIMER_REGISTRY.END_TIME', XNP_WSGL.TYPE_DATE, I_WHERE, 'DD-MON-RRRR HH24:MI:SS');
747: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR HH24:MI:SS')));
748: return false;
749: end;
750: begin
751: XNP_WSGL.BuildWhere(P_END_TIME, U_END_TIME, 'TIMER_REGISTRY.END_TIME', XNP_WSGL.TYPE_DATE, I_WHERE, 'DD-MON-RRRR HH24:MI:SS');
752: exception
753: when others then
754: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
755: 'Timer Registry'||' : '||'Timers', DEF_BODY_ATTRIBUTES, NULL,
750: begin
751: XNP_WSGL.BuildWhere(P_END_TIME, U_END_TIME, 'TIMER_REGISTRY.END_TIME', XNP_WSGL.TYPE_DATE, I_WHERE, 'DD-MON-RRRR HH24:MI:SS');
752: exception
753: when others then
754: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
755: 'Timer Registry'||' : '||'Timers', DEF_BODY_ATTRIBUTES, NULL,
756: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'End Time'),
757: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR HH24:MI:SS')));
758: return false;
752: exception
753: when others then
754: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
755: 'Timer Registry'||' : '||'Timers', DEF_BODY_ATTRIBUTES, NULL,
756: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'End Time'),
757: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR HH24:MI:SS')));
758: return false;
759: end;
760: XNP_WSGL.BuildWhere(P_NEXT_TIMER, 'TIMER_REGISTRY.NEXT_TIMER', XNP_WSGL.TYPE_CHAR, I_WHERE);
753: when others then
754: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
755: 'Timer Registry'||' : '||'Timers', DEF_BODY_ATTRIBUTES, NULL,
756: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'End Time'),
757: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR HH24:MI:SS')));
758: return false;
759: end;
760: XNP_WSGL.BuildWhere(P_NEXT_TIMER, 'TIMER_REGISTRY.NEXT_TIMER', XNP_WSGL.TYPE_CHAR, I_WHERE);
761:
756: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'End Time'),
757: XNP_WSGL.MsgGetText(211,XNP_WSGLM.MSG211_EXAMPLE_TODAY,to_char(sysdate, 'DD-MON-RRRR HH24:MI:SS')));
758: return false;
759: end;
760: XNP_WSGL.BuildWhere(P_NEXT_TIMER, 'TIMER_REGISTRY.NEXT_TIMER', XNP_WSGL.TYPE_CHAR, I_WHERE);
761:
762: ZONE_SQL := 'SELECT TIMER_REGISTRY.TIMER_ID,
763: TIMER_REGISTRY.ORDER_ID,
764: TIMER_REGISTRY.REFERENCE_ID,
777: return true;
778:
779: exception
780: when others then
781: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
782: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.BuildSQL');
783: return false;
784: end;
785:
799: Z_CHK in varchar2) is
800: begin
801:
802: if not Z_DIRECT_CALL then
803: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
804: return;
805: end if;
806: end if;
807:
804: return;
805: end if;
806: end if;
807:
808: XNP_WSGL.OpenPageHead('Timer Registry'||' : '||'Timers');
809: CreateQueryJavaScript;
810: -- Added for iHelp
811: htp.p('');
814: -- <<
815: xnp_timers$.TemplateHeader(TRUE,0);
816: XNP_WSGL.ClosePageHead;
817:
818: -- Added for iHelp
819: htp.p('
820: htp.p('onMouseOver="window.status='||''''||'Help'||''''||';return true">');
822: htp.p('');
823: htp.p(htf.nl);
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')));
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:
835: htp.formOpen(curl => 'xnp_timers$xnp_timer_registry.actionquery', cattributes => 'NAME="frmZero"');
836:
833: htp.para;
834:
835: htp.formOpen(curl => 'xnp_timers$xnp_timer_registry.actionquery', cattributes => 'NAME="frmZero"');
836:
837: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
838:
839: XNP_WSGL.LayoutRowStart;
840: for i in 1..QF_NUMBER_OF_COLUMNS loop
841: XNP_WSGL.LayoutHeader(13, 'LEFT', NULL);
835: htp.formOpen(curl => 'xnp_timers$xnp_timer_registry.actionquery', cattributes => 'NAME="frmZero"');
836:
837: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
838:
839: XNP_WSGL.LayoutRowStart;
840: for i in 1..QF_NUMBER_OF_COLUMNS loop
841: XNP_WSGL.LayoutHeader(13, 'LEFT', NULL);
842: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
843: end loop;
837: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
838:
839: XNP_WSGL.LayoutRowStart;
840: for i in 1..QF_NUMBER_OF_COLUMNS loop
841: XNP_WSGL.LayoutHeader(13, 'LEFT', NULL);
842: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
843: end loop;
844: XNP_WSGL.LayoutRowEnd;
845:
838:
839: XNP_WSGL.LayoutRowStart;
840: for i in 1..QF_NUMBER_OF_COLUMNS loop
841: XNP_WSGL.LayoutHeader(13, 'LEFT', NULL);
842: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
843: end loop;
844: XNP_WSGL.LayoutRowEnd;
845:
846: XNP_WSGL.LayoutRowStart('TOP');
840: for i in 1..QF_NUMBER_OF_COLUMNS loop
841: XNP_WSGL.LayoutHeader(13, 'LEFT', NULL);
842: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
843: end loop;
844: XNP_WSGL.LayoutRowEnd;
845:
846: XNP_WSGL.LayoutRowStart('TOP');
847: XNP_WSGL.LayoutData(htf.bold('Order Id:'));
848: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ORDER_ID', '8', TRUE));
842: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
843: end loop;
844: XNP_WSGL.LayoutRowEnd;
845:
846: XNP_WSGL.LayoutRowStart('TOP');
847: XNP_WSGL.LayoutData(htf.bold('Order Id:'));
848: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ORDER_ID', '8', TRUE));
849: XNP_WSGL.LayoutRowEnd;
850: XNP_WSGL.LayoutRowStart('TOP');
843: end loop;
844: XNP_WSGL.LayoutRowEnd;
845:
846: XNP_WSGL.LayoutRowStart('TOP');
847: XNP_WSGL.LayoutData(htf.bold('Order Id:'));
848: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ORDER_ID', '8', TRUE));
849: XNP_WSGL.LayoutRowEnd;
850: XNP_WSGL.LayoutRowStart('TOP');
851: XNP_WSGL.LayoutData(htf.bold('Reference Id:'));
844: XNP_WSGL.LayoutRowEnd;
845:
846: XNP_WSGL.LayoutRowStart('TOP');
847: XNP_WSGL.LayoutData(htf.bold('Order Id:'));
848: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ORDER_ID', '8', TRUE));
849: XNP_WSGL.LayoutRowEnd;
850: XNP_WSGL.LayoutRowStart('TOP');
851: XNP_WSGL.LayoutData(htf.bold('Reference Id:'));
852: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REFERENCE_ID', '20', FALSE));
845:
846: XNP_WSGL.LayoutRowStart('TOP');
847: XNP_WSGL.LayoutData(htf.bold('Order Id:'));
848: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ORDER_ID', '8', TRUE));
849: XNP_WSGL.LayoutRowEnd;
850: XNP_WSGL.LayoutRowStart('TOP');
851: XNP_WSGL.LayoutData(htf.bold('Reference Id:'));
852: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REFERENCE_ID', '20', FALSE));
853: XNP_WSGL.LayoutRowEnd;
846: XNP_WSGL.LayoutRowStart('TOP');
847: XNP_WSGL.LayoutData(htf.bold('Order Id:'));
848: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ORDER_ID', '8', TRUE));
849: XNP_WSGL.LayoutRowEnd;
850: XNP_WSGL.LayoutRowStart('TOP');
851: XNP_WSGL.LayoutData(htf.bold('Reference Id:'));
852: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REFERENCE_ID', '20', FALSE));
853: XNP_WSGL.LayoutRowEnd;
854: XNP_WSGL.LayoutRowStart('TOP');
847: XNP_WSGL.LayoutData(htf.bold('Order Id:'));
848: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ORDER_ID', '8', TRUE));
849: XNP_WSGL.LayoutRowEnd;
850: XNP_WSGL.LayoutRowStart('TOP');
851: XNP_WSGL.LayoutData(htf.bold('Reference Id:'));
852: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REFERENCE_ID', '20', FALSE));
853: XNP_WSGL.LayoutRowEnd;
854: XNP_WSGL.LayoutRowStart('TOP');
855: XNP_WSGL.LayoutData(htf.bold('Timer:'));
848: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ORDER_ID', '8', TRUE));
849: XNP_WSGL.LayoutRowEnd;
850: XNP_WSGL.LayoutRowStart('TOP');
851: XNP_WSGL.LayoutData(htf.bold('Reference Id:'));
852: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REFERENCE_ID', '20', FALSE));
853: XNP_WSGL.LayoutRowEnd;
854: XNP_WSGL.LayoutRowStart('TOP');
855: XNP_WSGL.LayoutData(htf.bold('Timer:'));
856: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('TIMER_MESSAGE_CODE', '20', FALSE) || ' ' ||
849: XNP_WSGL.LayoutRowEnd;
850: XNP_WSGL.LayoutRowStart('TOP');
851: XNP_WSGL.LayoutData(htf.bold('Reference Id:'));
852: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REFERENCE_ID', '20', FALSE));
853: XNP_WSGL.LayoutRowEnd;
854: XNP_WSGL.LayoutRowStart('TOP');
855: XNP_WSGL.LayoutData(htf.bold('Timer:'));
856: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('TIMER_MESSAGE_CODE', '20', FALSE) || ' ' ||
857: XNP_WSGJSL.LOVButton('TIMER_MESSAGE_CODE',LOV_BUTTON_TEXT));
850: XNP_WSGL.LayoutRowStart('TOP');
851: XNP_WSGL.LayoutData(htf.bold('Reference Id:'));
852: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REFERENCE_ID', '20', FALSE));
853: XNP_WSGL.LayoutRowEnd;
854: XNP_WSGL.LayoutRowStart('TOP');
855: XNP_WSGL.LayoutData(htf.bold('Timer:'));
856: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('TIMER_MESSAGE_CODE', '20', FALSE) || ' ' ||
857: XNP_WSGJSL.LOVButton('TIMER_MESSAGE_CODE',LOV_BUTTON_TEXT));
858: XNP_WSGL.LayoutRowEnd;
851: XNP_WSGL.LayoutData(htf.bold('Reference Id:'));
852: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REFERENCE_ID', '20', FALSE));
853: XNP_WSGL.LayoutRowEnd;
854: XNP_WSGL.LayoutRowStart('TOP');
855: XNP_WSGL.LayoutData(htf.bold('Timer:'));
856: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('TIMER_MESSAGE_CODE', '20', FALSE) || ' ' ||
857: XNP_WSGJSL.LOVButton('TIMER_MESSAGE_CODE',LOV_BUTTON_TEXT));
858: XNP_WSGL.LayoutRowEnd;
859: XNP_WSGL.LayoutRowStart('TOP');
852: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REFERENCE_ID', '20', FALSE));
853: XNP_WSGL.LayoutRowEnd;
854: XNP_WSGL.LayoutRowStart('TOP');
855: XNP_WSGL.LayoutData(htf.bold('Timer:'));
856: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('TIMER_MESSAGE_CODE', '20', FALSE) || ' ' ||
857: XNP_WSGJSL.LOVButton('TIMER_MESSAGE_CODE',LOV_BUTTON_TEXT));
858: XNP_WSGL.LayoutRowEnd;
859: XNP_WSGL.LayoutRowStart('TOP');
860: XNP_WSGL.LayoutData(htf.bold('Status:'));
854: XNP_WSGL.LayoutRowStart('TOP');
855: XNP_WSGL.LayoutData(htf.bold('Timer:'));
856: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('TIMER_MESSAGE_CODE', '20', FALSE) || ' ' ||
857: XNP_WSGJSL.LOVButton('TIMER_MESSAGE_CODE',LOV_BUTTON_TEXT));
858: XNP_WSGL.LayoutRowEnd;
859: XNP_WSGL.LayoutRowStart('TOP');
860: XNP_WSGL.LayoutData(htf.bold('Status:'));
861: InitialiseDomain('STATUS');
862: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_STATUS, XNP_WSGL.CTL_QUERY));
855: XNP_WSGL.LayoutData(htf.bold('Timer:'));
856: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('TIMER_MESSAGE_CODE', '20', FALSE) || ' ' ||
857: XNP_WSGJSL.LOVButton('TIMER_MESSAGE_CODE',LOV_BUTTON_TEXT));
858: XNP_WSGL.LayoutRowEnd;
859: XNP_WSGL.LayoutRowStart('TOP');
860: XNP_WSGL.LayoutData(htf.bold('Status:'));
861: InitialiseDomain('STATUS');
862: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_STATUS, XNP_WSGL.CTL_QUERY));
863: XNP_WSGL.LayoutRowEnd;
856: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('TIMER_MESSAGE_CODE', '20', FALSE) || ' ' ||
857: XNP_WSGJSL.LOVButton('TIMER_MESSAGE_CODE',LOV_BUTTON_TEXT));
858: XNP_WSGL.LayoutRowEnd;
859: XNP_WSGL.LayoutRowStart('TOP');
860: XNP_WSGL.LayoutData(htf.bold('Status:'));
861: InitialiseDomain('STATUS');
862: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_STATUS, XNP_WSGL.CTL_QUERY));
863: XNP_WSGL.LayoutRowEnd;
864: XNP_WSGL.LayoutRowStart('TOP');
858: XNP_WSGL.LayoutRowEnd;
859: XNP_WSGL.LayoutRowStart('TOP');
860: XNP_WSGL.LayoutData(htf.bold('Status:'));
861: InitialiseDomain('STATUS');
862: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_STATUS, XNP_WSGL.CTL_QUERY));
863: XNP_WSGL.LayoutRowEnd;
864: XNP_WSGL.LayoutRowStart('TOP');
865: XNP_WSGL.LayoutData(htf.bold('Start Time:'));
866: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('START_TIME', '18', TRUE));
859: XNP_WSGL.LayoutRowStart('TOP');
860: XNP_WSGL.LayoutData(htf.bold('Status:'));
861: InitialiseDomain('STATUS');
862: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_STATUS, XNP_WSGL.CTL_QUERY));
863: XNP_WSGL.LayoutRowEnd;
864: XNP_WSGL.LayoutRowStart('TOP');
865: XNP_WSGL.LayoutData(htf.bold('Start Time:'));
866: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('START_TIME', '18', TRUE));
867: XNP_WSGL.LayoutRowEnd;
860: XNP_WSGL.LayoutData(htf.bold('Status:'));
861: InitialiseDomain('STATUS');
862: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_STATUS, XNP_WSGL.CTL_QUERY));
863: XNP_WSGL.LayoutRowEnd;
864: XNP_WSGL.LayoutRowStart('TOP');
865: XNP_WSGL.LayoutData(htf.bold('Start Time:'));
866: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('START_TIME', '18', TRUE));
867: XNP_WSGL.LayoutRowEnd;
868: XNP_WSGL.LayoutRowStart('TOP');
861: InitialiseDomain('STATUS');
862: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_STATUS, XNP_WSGL.CTL_QUERY));
863: XNP_WSGL.LayoutRowEnd;
864: XNP_WSGL.LayoutRowStart('TOP');
865: XNP_WSGL.LayoutData(htf.bold('Start Time:'));
866: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('START_TIME', '18', TRUE));
867: XNP_WSGL.LayoutRowEnd;
868: XNP_WSGL.LayoutRowStart('TOP');
869: XNP_WSGL.LayoutData(htf.bold('End Time:'));
862: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_STATUS, XNP_WSGL.CTL_QUERY));
863: XNP_WSGL.LayoutRowEnd;
864: XNP_WSGL.LayoutRowStart('TOP');
865: XNP_WSGL.LayoutData(htf.bold('Start Time:'));
866: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('START_TIME', '18', TRUE));
867: XNP_WSGL.LayoutRowEnd;
868: XNP_WSGL.LayoutRowStart('TOP');
869: XNP_WSGL.LayoutData(htf.bold('End Time:'));
870: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('END_TIME', '18', TRUE));
863: XNP_WSGL.LayoutRowEnd;
864: XNP_WSGL.LayoutRowStart('TOP');
865: XNP_WSGL.LayoutData(htf.bold('Start Time:'));
866: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('START_TIME', '18', TRUE));
867: XNP_WSGL.LayoutRowEnd;
868: XNP_WSGL.LayoutRowStart('TOP');
869: XNP_WSGL.LayoutData(htf.bold('End Time:'));
870: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('END_TIME', '18', TRUE));
871: XNP_WSGL.LayoutRowEnd;
864: XNP_WSGL.LayoutRowStart('TOP');
865: XNP_WSGL.LayoutData(htf.bold('Start Time:'));
866: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('START_TIME', '18', TRUE));
867: XNP_WSGL.LayoutRowEnd;
868: XNP_WSGL.LayoutRowStart('TOP');
869: XNP_WSGL.LayoutData(htf.bold('End Time:'));
870: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('END_TIME', '18', TRUE));
871: XNP_WSGL.LayoutRowEnd;
872: XNP_WSGL.LayoutRowStart('TOP');
865: XNP_WSGL.LayoutData(htf.bold('Start Time:'));
866: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('START_TIME', '18', TRUE));
867: XNP_WSGL.LayoutRowEnd;
868: XNP_WSGL.LayoutRowStart('TOP');
869: XNP_WSGL.LayoutData(htf.bold('End Time:'));
870: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('END_TIME', '18', TRUE));
871: XNP_WSGL.LayoutRowEnd;
872: XNP_WSGL.LayoutRowStart('TOP');
873: XNP_WSGL.LayoutData(htf.bold('Next Timer:'));
866: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('START_TIME', '18', TRUE));
867: XNP_WSGL.LayoutRowEnd;
868: XNP_WSGL.LayoutRowStart('TOP');
869: XNP_WSGL.LayoutData(htf.bold('End Time:'));
870: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('END_TIME', '18', TRUE));
871: XNP_WSGL.LayoutRowEnd;
872: XNP_WSGL.LayoutRowStart('TOP');
873: XNP_WSGL.LayoutData(htf.bold('Next Timer:'));
874: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NEXT_TIMER', '20', FALSE) || ' ' ||
867: XNP_WSGL.LayoutRowEnd;
868: XNP_WSGL.LayoutRowStart('TOP');
869: XNP_WSGL.LayoutData(htf.bold('End Time:'));
870: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('END_TIME', '18', TRUE));
871: XNP_WSGL.LayoutRowEnd;
872: XNP_WSGL.LayoutRowStart('TOP');
873: XNP_WSGL.LayoutData(htf.bold('Next Timer:'));
874: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NEXT_TIMER', '20', FALSE) || ' ' ||
875: XNP_WSGJSL.LOVButton('NEXT_TIMER',LOV_BUTTON_TEXT));
868: XNP_WSGL.LayoutRowStart('TOP');
869: XNP_WSGL.LayoutData(htf.bold('End Time:'));
870: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('END_TIME', '18', TRUE));
871: XNP_WSGL.LayoutRowEnd;
872: XNP_WSGL.LayoutRowStart('TOP');
873: XNP_WSGL.LayoutData(htf.bold('Next Timer:'));
874: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NEXT_TIMER', '20', FALSE) || ' ' ||
875: XNP_WSGJSL.LOVButton('NEXT_TIMER',LOV_BUTTON_TEXT));
876: XNP_WSGL.LayoutRowEnd;
869: XNP_WSGL.LayoutData(htf.bold('End Time:'));
870: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('END_TIME', '18', TRUE));
871: XNP_WSGL.LayoutRowEnd;
872: XNP_WSGL.LayoutRowStart('TOP');
873: XNP_WSGL.LayoutData(htf.bold('Next Timer:'));
874: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NEXT_TIMER', '20', FALSE) || ' ' ||
875: XNP_WSGJSL.LOVButton('NEXT_TIMER',LOV_BUTTON_TEXT));
876: XNP_WSGL.LayoutRowEnd;
877:
870: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('END_TIME', '18', TRUE));
871: XNP_WSGL.LayoutRowEnd;
872: XNP_WSGL.LayoutRowStart('TOP');
873: XNP_WSGL.LayoutData(htf.bold('Next Timer:'));
874: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NEXT_TIMER', '20', FALSE) || ' ' ||
875: XNP_WSGJSL.LOVButton('NEXT_TIMER',LOV_BUTTON_TEXT));
876: XNP_WSGL.LayoutRowEnd;
877:
878: XNP_WSGL.LayoutClose;
872: XNP_WSGL.LayoutRowStart('TOP');
873: XNP_WSGL.LayoutData(htf.bold('Next Timer:'));
874: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NEXT_TIMER', '20', FALSE) || ' ' ||
875: XNP_WSGJSL.LOVButton('NEXT_TIMER',LOV_BUTTON_TEXT));
876: XNP_WSGL.LayoutRowEnd;
877:
878: XNP_WSGL.LayoutClose;
879:
880: htp.p ('');
888:
889: if XNP_WSGL.IsSupported ('NOSCRIPT')
890: then
891:
892: htp.p ('
895:
896: end if;
897: htp.formReset(htf.escape_sc(QF_CLEAR_BUT_CAPTION));
898:
899: XNP_WSGL.HiddenField('Z_CHK',
900: to_char(XNP_WSGL.Checksum('')));
901: htp.formClose;
902:
903: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
896: end if;
897: htp.formReset(htf.escape_sc(QF_CLEAR_BUT_CAPTION));
898:
899: XNP_WSGL.HiddenField('Z_CHK',
900: to_char(XNP_WSGL.Checksum('')));
901: htp.formClose;
902:
903: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
904:
901: htp.formClose;
902:
903: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
904:
905: XNP_WSGL.ClosePageBody;
906:
907: exception
908: when others then
909: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
905: XNP_WSGL.ClosePageBody;
906:
907: exception
908: when others then
909: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
910: QF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.FormQuery');
911: XNP_WSGL.ClosePageBody;
912: end;
913:
907: exception
908: when others then
909: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
910: QF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.FormQuery');
911: XNP_WSGL.ClosePageBody;
912: end;
913:
914: --------------------------------------------------------------------------------
915: -- Name: xnp_timers$xnp_timer_registry.FormView
924:
925:
926: begin
927:
928: XNP_WSGL.OpenPageHead('Timer Registry'||' : '||'Timers');
929: xnp_timers$.TemplateHeader(TRUE,0);
930: XNP_WSGL.ClosePageHead;
931:
932: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);
926: begin
927:
928: XNP_WSGL.OpenPageHead('Timer Registry'||' : '||'Timers');
929: xnp_timers$.TemplateHeader(TRUE,0);
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')));
928: XNP_WSGL.OpenPageHead('Timer Registry'||' : '||'Timers');
929: xnp_timers$.TemplateHeader(TRUE,0);
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');
943: FORM_VAL.XML_PAYLOAD_LINK := NBT_VAL.XML_PAYLOAD_LINK;
944: FORM_VAL.WI_INSTANCE_ID := CURR_VAL.WI_INSTANCE_ID;
945: FORM_VAL.FA_INSTANCE_ID := CURR_VAL.FA_INSTANCE_ID;
946: FORM_VAL.TIMER_MESSAGE_CODE := CURR_VAL.TIMER_MESSAGE_CODE;
947: FORM_VAL.STATUS := XNP_WSGL.DomainMeaning(D_STATUS, CURR_VAL.STATUS);
948: FORM_VAL.START_TIME := ltrim(to_char(CURR_VAL.START_TIME, 'DD-MON-RRRR HH24:MI:SS'));
949: FORM_VAL.END_TIME := ltrim(to_char(CURR_VAL.END_TIME, 'DD-MON-RRRR HH24:MI:SS'));
950: FORM_VAL.NEXT_TIMER := CURR_VAL.NEXT_TIMER;
951:
948: FORM_VAL.START_TIME := ltrim(to_char(CURR_VAL.START_TIME, 'DD-MON-RRRR HH24:MI:SS'));
949: FORM_VAL.END_TIME := ltrim(to_char(CURR_VAL.END_TIME, 'DD-MON-RRRR HH24:MI:SS'));
950: FORM_VAL.NEXT_TIMER := CURR_VAL.NEXT_TIMER;
951:
952: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
953: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
954: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
955: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
956: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
949: FORM_VAL.END_TIME := ltrim(to_char(CURR_VAL.END_TIME, 'DD-MON-RRRR HH24:MI:SS'));
950: FORM_VAL.NEXT_TIMER := CURR_VAL.NEXT_TIMER;
951:
952: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
953: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
954: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
955: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
956: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
957: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
951:
952: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
953: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
954: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
955: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
956: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
957: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
958: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
959: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
952: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
953: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
954: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
955: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
956: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
957: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
958: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
959: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
960: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
954: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
955: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
956: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
957: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
958: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
959: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
960: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
961: end if;
962:
955: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
956: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
957: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
958: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
959: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
960: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
961: end if;
962:
963:
960: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
961: end if;
962:
963:
964: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
965:
966: XNP_WSGL.LayoutRowStart;
967: for i in 1..VF_NUMBER_OF_COLUMNS loop
968: XNP_WSGL.LayoutHeader(31, 'LEFT', NULL);
962:
963:
964: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
965:
966: XNP_WSGL.LayoutRowStart;
967: for i in 1..VF_NUMBER_OF_COLUMNS loop
968: XNP_WSGL.LayoutHeader(31, 'LEFT', NULL);
969: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);
970: end loop;
964: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
965:
966: XNP_WSGL.LayoutRowStart;
967: for i in 1..VF_NUMBER_OF_COLUMNS loop
968: XNP_WSGL.LayoutHeader(31, 'LEFT', NULL);
969: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);
970: end loop;
971: XNP_WSGL.LayoutRowEnd;
972:
965:
966: XNP_WSGL.LayoutRowStart;
967: for i in 1..VF_NUMBER_OF_COLUMNS loop
968: XNP_WSGL.LayoutHeader(31, 'LEFT', NULL);
969: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);
970: end loop;
971: XNP_WSGL.LayoutRowEnd;
972:
973: XNP_WSGL.LayoutRowStart('TOP');
967: for i in 1..VF_NUMBER_OF_COLUMNS loop
968: XNP_WSGL.LayoutHeader(31, 'LEFT', NULL);
969: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);
970: end loop;
971: XNP_WSGL.LayoutRowEnd;
972:
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Order Id:'));
975: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ORDER_ID));
969: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);
970: end loop;
971: XNP_WSGL.LayoutRowEnd;
972:
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Order Id:'));
975: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ORDER_ID));
976: XNP_WSGL.LayoutRowEnd;
977: XNP_WSGL.LayoutRowStart('TOP');
970: end loop;
971: XNP_WSGL.LayoutRowEnd;
972:
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Order Id:'));
975: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ORDER_ID));
976: XNP_WSGL.LayoutRowEnd;
977: XNP_WSGL.LayoutRowStart('TOP');
978: XNP_WSGL.LayoutData(htf.bold('Reference Id:'));
971: XNP_WSGL.LayoutRowEnd;
972:
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Order Id:'));
975: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ORDER_ID));
976: XNP_WSGL.LayoutRowEnd;
977: XNP_WSGL.LayoutRowStart('TOP');
978: XNP_WSGL.LayoutData(htf.bold('Reference Id:'));
979: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.REFERENCE_ID));
972:
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Order Id:'));
975: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ORDER_ID));
976: XNP_WSGL.LayoutRowEnd;
977: XNP_WSGL.LayoutRowStart('TOP');
978: XNP_WSGL.LayoutData(htf.bold('Reference Id:'));
979: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.REFERENCE_ID));
980: XNP_WSGL.LayoutRowEnd;
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Order Id:'));
975: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ORDER_ID));
976: XNP_WSGL.LayoutRowEnd;
977: XNP_WSGL.LayoutRowStart('TOP');
978: XNP_WSGL.LayoutData(htf.bold('Reference Id:'));
979: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.REFERENCE_ID));
980: XNP_WSGL.LayoutRowEnd;
981: if NBT_VAL.XML_PAYLOAD_LINK is not null then
974: XNP_WSGL.LayoutData(htf.bold('Order Id:'));
975: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ORDER_ID));
976: XNP_WSGL.LayoutRowEnd;
977: XNP_WSGL.LayoutRowStart('TOP');
978: XNP_WSGL.LayoutData(htf.bold('Reference Id:'));
979: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.REFERENCE_ID));
980: XNP_WSGL.LayoutRowEnd;
981: if NBT_VAL.XML_PAYLOAD_LINK is not null then
982: XNP_WSGL.LayoutRowStart('TOP');
975: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ORDER_ID));
976: XNP_WSGL.LayoutRowEnd;
977: XNP_WSGL.LayoutRowStart('TOP');
978: XNP_WSGL.LayoutData(htf.bold('Reference Id:'));
979: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.REFERENCE_ID));
980: XNP_WSGL.LayoutRowEnd;
981: if NBT_VAL.XML_PAYLOAD_LINK is not null then
982: XNP_WSGL.LayoutRowStart('TOP');
983: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.XML_PAYLOAD_LINK, 'XML'));
976: XNP_WSGL.LayoutRowEnd;
977: XNP_WSGL.LayoutRowStart('TOP');
978: XNP_WSGL.LayoutData(htf.bold('Reference Id:'));
979: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.REFERENCE_ID));
980: XNP_WSGL.LayoutRowEnd;
981: if NBT_VAL.XML_PAYLOAD_LINK is not null then
982: XNP_WSGL.LayoutRowStart('TOP');
983: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.XML_PAYLOAD_LINK, 'XML'));
984: XNP_WSGL.LayoutData('');
978: XNP_WSGL.LayoutData(htf.bold('Reference Id:'));
979: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.REFERENCE_ID));
980: XNP_WSGL.LayoutRowEnd;
981: if NBT_VAL.XML_PAYLOAD_LINK is not null then
982: XNP_WSGL.LayoutRowStart('TOP');
983: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.XML_PAYLOAD_LINK, 'XML'));
984: XNP_WSGL.LayoutData('');
985: XNP_WSGL.LayoutRowEnd;
986: end if;
979: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.REFERENCE_ID));
980: XNP_WSGL.LayoutRowEnd;
981: if NBT_VAL.XML_PAYLOAD_LINK is not null then
982: XNP_WSGL.LayoutRowStart('TOP');
983: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.XML_PAYLOAD_LINK, 'XML'));
984: XNP_WSGL.LayoutData('');
985: XNP_WSGL.LayoutRowEnd;
986: end if;
987: XNP_WSGL.LayoutRowStart('TOP');
980: XNP_WSGL.LayoutRowEnd;
981: if NBT_VAL.XML_PAYLOAD_LINK is not null then
982: XNP_WSGL.LayoutRowStart('TOP');
983: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.XML_PAYLOAD_LINK, 'XML'));
984: XNP_WSGL.LayoutData('');
985: XNP_WSGL.LayoutRowEnd;
986: end if;
987: XNP_WSGL.LayoutRowStart('TOP');
988: XNP_WSGL.LayoutData(htf.bold('Workitem Instance Id:'));
981: if NBT_VAL.XML_PAYLOAD_LINK is not null then
982: XNP_WSGL.LayoutRowStart('TOP');
983: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.XML_PAYLOAD_LINK, 'XML'));
984: XNP_WSGL.LayoutData('');
985: XNP_WSGL.LayoutRowEnd;
986: end if;
987: XNP_WSGL.LayoutRowStart('TOP');
988: XNP_WSGL.LayoutData(htf.bold('Workitem Instance Id:'));
989: XNP_WSGL.LayoutData(FORM_VAL.WI_INSTANCE_ID);
983: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.XML_PAYLOAD_LINK, 'XML'));
984: XNP_WSGL.LayoutData('');
985: XNP_WSGL.LayoutRowEnd;
986: end if;
987: XNP_WSGL.LayoutRowStart('TOP');
988: XNP_WSGL.LayoutData(htf.bold('Workitem Instance Id:'));
989: XNP_WSGL.LayoutData(FORM_VAL.WI_INSTANCE_ID);
990: XNP_WSGL.LayoutRowEnd;
991: XNP_WSGL.LayoutRowStart('TOP');
984: XNP_WSGL.LayoutData('');
985: XNP_WSGL.LayoutRowEnd;
986: end if;
987: XNP_WSGL.LayoutRowStart('TOP');
988: XNP_WSGL.LayoutData(htf.bold('Workitem Instance Id:'));
989: XNP_WSGL.LayoutData(FORM_VAL.WI_INSTANCE_ID);
990: XNP_WSGL.LayoutRowEnd;
991: XNP_WSGL.LayoutRowStart('TOP');
992: XNP_WSGL.LayoutData(htf.bold('Fulfillment Action Instance Id:'));
985: XNP_WSGL.LayoutRowEnd;
986: end if;
987: XNP_WSGL.LayoutRowStart('TOP');
988: XNP_WSGL.LayoutData(htf.bold('Workitem Instance Id:'));
989: XNP_WSGL.LayoutData(FORM_VAL.WI_INSTANCE_ID);
990: XNP_WSGL.LayoutRowEnd;
991: XNP_WSGL.LayoutRowStart('TOP');
992: XNP_WSGL.LayoutData(htf.bold('Fulfillment Action Instance Id:'));
993: XNP_WSGL.LayoutData(FORM_VAL.FA_INSTANCE_ID);
986: end if;
987: XNP_WSGL.LayoutRowStart('TOP');
988: XNP_WSGL.LayoutData(htf.bold('Workitem Instance Id:'));
989: XNP_WSGL.LayoutData(FORM_VAL.WI_INSTANCE_ID);
990: XNP_WSGL.LayoutRowEnd;
991: XNP_WSGL.LayoutRowStart('TOP');
992: XNP_WSGL.LayoutData(htf.bold('Fulfillment Action Instance Id:'));
993: XNP_WSGL.LayoutData(FORM_VAL.FA_INSTANCE_ID);
994: XNP_WSGL.LayoutRowEnd;
987: XNP_WSGL.LayoutRowStart('TOP');
988: XNP_WSGL.LayoutData(htf.bold('Workitem Instance Id:'));
989: XNP_WSGL.LayoutData(FORM_VAL.WI_INSTANCE_ID);
990: XNP_WSGL.LayoutRowEnd;
991: XNP_WSGL.LayoutRowStart('TOP');
992: XNP_WSGL.LayoutData(htf.bold('Fulfillment Action Instance Id:'));
993: XNP_WSGL.LayoutData(FORM_VAL.FA_INSTANCE_ID);
994: XNP_WSGL.LayoutRowEnd;
995: XNP_WSGL.LayoutRowStart('TOP');
988: XNP_WSGL.LayoutData(htf.bold('Workitem Instance Id:'));
989: XNP_WSGL.LayoutData(FORM_VAL.WI_INSTANCE_ID);
990: XNP_WSGL.LayoutRowEnd;
991: XNP_WSGL.LayoutRowStart('TOP');
992: XNP_WSGL.LayoutData(htf.bold('Fulfillment Action Instance Id:'));
993: XNP_WSGL.LayoutData(FORM_VAL.FA_INSTANCE_ID);
994: XNP_WSGL.LayoutRowEnd;
995: XNP_WSGL.LayoutRowStart('TOP');
996: XNP_WSGL.LayoutData(htf.bold('Timer:'));
989: XNP_WSGL.LayoutData(FORM_VAL.WI_INSTANCE_ID);
990: XNP_WSGL.LayoutRowEnd;
991: XNP_WSGL.LayoutRowStart('TOP');
992: XNP_WSGL.LayoutData(htf.bold('Fulfillment Action Instance Id:'));
993: XNP_WSGL.LayoutData(FORM_VAL.FA_INSTANCE_ID);
994: XNP_WSGL.LayoutRowEnd;
995: XNP_WSGL.LayoutRowStart('TOP');
996: XNP_WSGL.LayoutData(htf.bold('Timer:'));
997: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.TIMER_MESSAGE_CODE));
990: XNP_WSGL.LayoutRowEnd;
991: XNP_WSGL.LayoutRowStart('TOP');
992: XNP_WSGL.LayoutData(htf.bold('Fulfillment Action Instance Id:'));
993: XNP_WSGL.LayoutData(FORM_VAL.FA_INSTANCE_ID);
994: XNP_WSGL.LayoutRowEnd;
995: XNP_WSGL.LayoutRowStart('TOP');
996: XNP_WSGL.LayoutData(htf.bold('Timer:'));
997: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.TIMER_MESSAGE_CODE));
998: XNP_WSGL.LayoutRowEnd;
991: XNP_WSGL.LayoutRowStart('TOP');
992: XNP_WSGL.LayoutData(htf.bold('Fulfillment Action Instance Id:'));
993: XNP_WSGL.LayoutData(FORM_VAL.FA_INSTANCE_ID);
994: XNP_WSGL.LayoutRowEnd;
995: XNP_WSGL.LayoutRowStart('TOP');
996: XNP_WSGL.LayoutData(htf.bold('Timer:'));
997: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.TIMER_MESSAGE_CODE));
998: XNP_WSGL.LayoutRowEnd;
999: XNP_WSGL.LayoutRowStart('TOP');
992: XNP_WSGL.LayoutData(htf.bold('Fulfillment Action Instance Id:'));
993: XNP_WSGL.LayoutData(FORM_VAL.FA_INSTANCE_ID);
994: XNP_WSGL.LayoutRowEnd;
995: XNP_WSGL.LayoutRowStart('TOP');
996: XNP_WSGL.LayoutData(htf.bold('Timer:'));
997: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.TIMER_MESSAGE_CODE));
998: XNP_WSGL.LayoutRowEnd;
999: XNP_WSGL.LayoutRowStart('TOP');
1000: XNP_WSGL.LayoutData(htf.bold('Status:'));
993: XNP_WSGL.LayoutData(FORM_VAL.FA_INSTANCE_ID);
994: XNP_WSGL.LayoutRowEnd;
995: XNP_WSGL.LayoutRowStart('TOP');
996: XNP_WSGL.LayoutData(htf.bold('Timer:'));
997: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.TIMER_MESSAGE_CODE));
998: XNP_WSGL.LayoutRowEnd;
999: XNP_WSGL.LayoutRowStart('TOP');
1000: XNP_WSGL.LayoutData(htf.bold('Status:'));
1001: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.STATUS));
994: XNP_WSGL.LayoutRowEnd;
995: XNP_WSGL.LayoutRowStart('TOP');
996: XNP_WSGL.LayoutData(htf.bold('Timer:'));
997: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.TIMER_MESSAGE_CODE));
998: XNP_WSGL.LayoutRowEnd;
999: XNP_WSGL.LayoutRowStart('TOP');
1000: XNP_WSGL.LayoutData(htf.bold('Status:'));
1001: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.STATUS));
1002: XNP_WSGL.LayoutRowEnd;
995: XNP_WSGL.LayoutRowStart('TOP');
996: XNP_WSGL.LayoutData(htf.bold('Timer:'));
997: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.TIMER_MESSAGE_CODE));
998: XNP_WSGL.LayoutRowEnd;
999: XNP_WSGL.LayoutRowStart('TOP');
1000: XNP_WSGL.LayoutData(htf.bold('Status:'));
1001: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.STATUS));
1002: XNP_WSGL.LayoutRowEnd;
1003: XNP_WSGL.LayoutRowStart('TOP');
996: XNP_WSGL.LayoutData(htf.bold('Timer:'));
997: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.TIMER_MESSAGE_CODE));
998: XNP_WSGL.LayoutRowEnd;
999: XNP_WSGL.LayoutRowStart('TOP');
1000: XNP_WSGL.LayoutData(htf.bold('Status:'));
1001: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.STATUS));
1002: XNP_WSGL.LayoutRowEnd;
1003: XNP_WSGL.LayoutRowStart('TOP');
1004: XNP_WSGL.LayoutData(htf.bold('Start Time:'));
997: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.TIMER_MESSAGE_CODE));
998: XNP_WSGL.LayoutRowEnd;
999: XNP_WSGL.LayoutRowStart('TOP');
1000: XNP_WSGL.LayoutData(htf.bold('Status:'));
1001: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.STATUS));
1002: XNP_WSGL.LayoutRowEnd;
1003: XNP_WSGL.LayoutRowStart('TOP');
1004: XNP_WSGL.LayoutData(htf.bold('Start Time:'));
1005: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.START_TIME));
998: XNP_WSGL.LayoutRowEnd;
999: XNP_WSGL.LayoutRowStart('TOP');
1000: XNP_WSGL.LayoutData(htf.bold('Status:'));
1001: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.STATUS));
1002: XNP_WSGL.LayoutRowEnd;
1003: XNP_WSGL.LayoutRowStart('TOP');
1004: XNP_WSGL.LayoutData(htf.bold('Start Time:'));
1005: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.START_TIME));
1006: XNP_WSGL.LayoutRowEnd;
999: XNP_WSGL.LayoutRowStart('TOP');
1000: XNP_WSGL.LayoutData(htf.bold('Status:'));
1001: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.STATUS));
1002: XNP_WSGL.LayoutRowEnd;
1003: XNP_WSGL.LayoutRowStart('TOP');
1004: XNP_WSGL.LayoutData(htf.bold('Start Time:'));
1005: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.START_TIME));
1006: XNP_WSGL.LayoutRowEnd;
1007: XNP_WSGL.LayoutRowStart('TOP');
1000: XNP_WSGL.LayoutData(htf.bold('Status:'));
1001: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.STATUS));
1002: XNP_WSGL.LayoutRowEnd;
1003: XNP_WSGL.LayoutRowStart('TOP');
1004: XNP_WSGL.LayoutData(htf.bold('Start Time:'));
1005: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.START_TIME));
1006: XNP_WSGL.LayoutRowEnd;
1007: XNP_WSGL.LayoutRowStart('TOP');
1008: XNP_WSGL.LayoutData(htf.bold('End Time:'));
1001: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.STATUS));
1002: XNP_WSGL.LayoutRowEnd;
1003: XNP_WSGL.LayoutRowStart('TOP');
1004: XNP_WSGL.LayoutData(htf.bold('Start Time:'));
1005: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.START_TIME));
1006: XNP_WSGL.LayoutRowEnd;
1007: XNP_WSGL.LayoutRowStart('TOP');
1008: XNP_WSGL.LayoutData(htf.bold('End Time:'));
1009: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.END_TIME));
1002: XNP_WSGL.LayoutRowEnd;
1003: XNP_WSGL.LayoutRowStart('TOP');
1004: XNP_WSGL.LayoutData(htf.bold('Start Time:'));
1005: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.START_TIME));
1006: XNP_WSGL.LayoutRowEnd;
1007: XNP_WSGL.LayoutRowStart('TOP');
1008: XNP_WSGL.LayoutData(htf.bold('End Time:'));
1009: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.END_TIME));
1010: XNP_WSGL.LayoutRowEnd;
1003: XNP_WSGL.LayoutRowStart('TOP');
1004: XNP_WSGL.LayoutData(htf.bold('Start Time:'));
1005: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.START_TIME));
1006: XNP_WSGL.LayoutRowEnd;
1007: XNP_WSGL.LayoutRowStart('TOP');
1008: XNP_WSGL.LayoutData(htf.bold('End Time:'));
1009: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.END_TIME));
1010: XNP_WSGL.LayoutRowEnd;
1011: XNP_WSGL.LayoutRowStart('TOP');
1004: XNP_WSGL.LayoutData(htf.bold('Start Time:'));
1005: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.START_TIME));
1006: XNP_WSGL.LayoutRowEnd;
1007: XNP_WSGL.LayoutRowStart('TOP');
1008: XNP_WSGL.LayoutData(htf.bold('End Time:'));
1009: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.END_TIME));
1010: XNP_WSGL.LayoutRowEnd;
1011: XNP_WSGL.LayoutRowStart('TOP');
1012: XNP_WSGL.LayoutData(htf.bold('Next Timer:'));
1005: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.START_TIME));
1006: XNP_WSGL.LayoutRowEnd;
1007: XNP_WSGL.LayoutRowStart('TOP');
1008: XNP_WSGL.LayoutData(htf.bold('End Time:'));
1009: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.END_TIME));
1010: XNP_WSGL.LayoutRowEnd;
1011: XNP_WSGL.LayoutRowStart('TOP');
1012: XNP_WSGL.LayoutData(htf.bold('Next Timer:'));
1013: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.NEXT_TIMER));
1006: XNP_WSGL.LayoutRowEnd;
1007: XNP_WSGL.LayoutRowStart('TOP');
1008: XNP_WSGL.LayoutData(htf.bold('End Time:'));
1009: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.END_TIME));
1010: XNP_WSGL.LayoutRowEnd;
1011: XNP_WSGL.LayoutRowStart('TOP');
1012: XNP_WSGL.LayoutData(htf.bold('Next Timer:'));
1013: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.NEXT_TIMER));
1014: XNP_WSGL.LayoutRowEnd;
1007: XNP_WSGL.LayoutRowStart('TOP');
1008: XNP_WSGL.LayoutData(htf.bold('End Time:'));
1009: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.END_TIME));
1010: XNP_WSGL.LayoutRowEnd;
1011: XNP_WSGL.LayoutRowStart('TOP');
1012: XNP_WSGL.LayoutData(htf.bold('Next Timer:'));
1013: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.NEXT_TIMER));
1014: XNP_WSGL.LayoutRowEnd;
1015:
1008: XNP_WSGL.LayoutData(htf.bold('End Time:'));
1009: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.END_TIME));
1010: XNP_WSGL.LayoutRowEnd;
1011: XNP_WSGL.LayoutRowStart('TOP');
1012: XNP_WSGL.LayoutData(htf.bold('Next Timer:'));
1013: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.NEXT_TIMER));
1014: XNP_WSGL.LayoutRowEnd;
1015:
1016: XNP_WSGL.LayoutClose;
1009: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.END_TIME));
1010: XNP_WSGL.LayoutRowEnd;
1011: XNP_WSGL.LayoutRowStart('TOP');
1012: XNP_WSGL.LayoutData(htf.bold('Next Timer:'));
1013: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.NEXT_TIMER));
1014: XNP_WSGL.LayoutRowEnd;
1015:
1016: XNP_WSGL.LayoutClose;
1017:
1010: XNP_WSGL.LayoutRowEnd;
1011: XNP_WSGL.LayoutRowStart('TOP');
1012: XNP_WSGL.LayoutData(htf.bold('Next Timer:'));
1013: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.NEXT_TIMER));
1014: XNP_WSGL.LayoutRowEnd;
1015:
1016: XNP_WSGL.LayoutClose;
1017:
1018:
1012: XNP_WSGL.LayoutData(htf.bold('Next Timer:'));
1013: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.NEXT_TIMER));
1014: XNP_WSGL.LayoutRowEnd;
1015:
1016: XNP_WSGL.LayoutClose;
1017:
1018:
1019:
1020:
1019:
1020:
1021:
1022:
1023: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);
1024: XNP_WSGL.NavLinks;
1025:
1026:
1027: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
1020:
1021:
1022:
1023: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);
1024: XNP_WSGL.NavLinks;
1025:
1026:
1027: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
1028:
1025:
1026:
1027: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
1028:
1029: XNP_WSGL.ClosePageBody;
1030:
1031: exception
1032: when others then
1033: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1029: XNP_WSGL.ClosePageBody;
1030:
1031: exception
1032: when others then
1033: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1034: VF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.FormView');
1035: XNP_WSGL.ClosePageBody;
1036: end;
1037:
1031: exception
1032: when others then
1033: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1034: VF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.FormView');
1035: XNP_WSGL.ClosePageBody;
1036: end;
1037:
1038: --------------------------------------------------------------------------------
1039: -- Name: xnp_timers$xnp_timer_registry.QueryView
1050: Z_DIRECT_CALL in boolean,
1051: Z_CHK in varchar2) is
1052: begin
1053:
1054: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.queryview');
1055: XNP_WSGL.AddURLParam('P_TIMER_ID', P_TIMER_ID);
1056: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1057: if not Z_DIRECT_CALL then
1058: if not XNP_WSGL.ValidateChecksum('' ||
1051: Z_CHK in varchar2) is
1052: begin
1053:
1054: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.queryview');
1055: XNP_WSGL.AddURLParam('P_TIMER_ID', P_TIMER_ID);
1056: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1057: if not Z_DIRECT_CALL then
1058: if not XNP_WSGL.ValidateChecksum('' ||
1059: P_TIMER_ID, Z_CHK) then
1052: begin
1053:
1054: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.queryview');
1055: XNP_WSGL.AddURLParam('P_TIMER_ID', P_TIMER_ID);
1056: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1057: if not Z_DIRECT_CALL then
1058: if not XNP_WSGL.ValidateChecksum('' ||
1059: P_TIMER_ID, Z_CHK) then
1060: return;
1054: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.queryview');
1055: XNP_WSGL.AddURLParam('P_TIMER_ID', P_TIMER_ID);
1056: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1057: if not Z_DIRECT_CALL then
1058: if not XNP_WSGL.ValidateChecksum('' ||
1059: P_TIMER_ID, Z_CHK) then
1060: return;
1061: end if;
1062: end if;
1101:
1102: NBT_VAL.XML_PAYLOAD_LINK := 'xnp_web_utils.show_msg_body?p_msg_id='||CURR_VAL.TIMER_ID;
1103:
1104: if not PostQuery(Z_POST_DML) then
1105: FormView(XNP_WSGL.FORM_STATUS_ERROR);
1106: else
1107: FormView(Z_FORM_STATUS);
1108: end if;
1109:
1108: end if;
1109:
1110: exception
1111: when NO_DATA_FOUND then
1112: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),
1113: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
1114: when others then
1115: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1116: VF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.QueryView');
1111: when NO_DATA_FOUND then
1112: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),
1113: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
1114: when others then
1115: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1116: VF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.QueryView');
1117: end;
1118: --------------------------------------------------------------------------------
1119: -- Name: xnp_timers$xnp_timer_registry.QueryList
1174: L_CHECKSUM varchar2(10);
1175:
1176: begin
1177:
1178: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.querylist');
1179: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1180: XNP_WSGL.AddURLParam('U_ORDER_ID', U_ORDER_ID);
1181: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1182: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1175:
1176: begin
1177:
1178: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.querylist');
1179: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1180: XNP_WSGL.AddURLParam('U_ORDER_ID', U_ORDER_ID);
1181: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1182: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1183: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
1176: begin
1177:
1178: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.querylist');
1179: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1180: XNP_WSGL.AddURLParam('U_ORDER_ID', U_ORDER_ID);
1181: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1182: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1183: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
1184: XNP_WSGL.AddURLParam('P_START_TIME', P_START_TIME);
1177:
1178: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.querylist');
1179: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1180: XNP_WSGL.AddURLParam('U_ORDER_ID', U_ORDER_ID);
1181: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1182: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1183: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
1184: XNP_WSGL.AddURLParam('P_START_TIME', P_START_TIME);
1185: XNP_WSGL.AddURLParam('U_START_TIME', U_START_TIME);
1178: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.querylist');
1179: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1180: XNP_WSGL.AddURLParam('U_ORDER_ID', U_ORDER_ID);
1181: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1182: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1183: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
1184: XNP_WSGL.AddURLParam('P_START_TIME', P_START_TIME);
1185: XNP_WSGL.AddURLParam('U_START_TIME', U_START_TIME);
1186: XNP_WSGL.AddURLParam('P_END_TIME', P_END_TIME);
1179: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1180: XNP_WSGL.AddURLParam('U_ORDER_ID', U_ORDER_ID);
1181: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1182: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1183: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
1184: XNP_WSGL.AddURLParam('P_START_TIME', P_START_TIME);
1185: XNP_WSGL.AddURLParam('U_START_TIME', U_START_TIME);
1186: XNP_WSGL.AddURLParam('P_END_TIME', P_END_TIME);
1187: XNP_WSGL.AddURLParam('U_END_TIME', U_END_TIME);
1180: XNP_WSGL.AddURLParam('U_ORDER_ID', U_ORDER_ID);
1181: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1182: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1183: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
1184: XNP_WSGL.AddURLParam('P_START_TIME', P_START_TIME);
1185: XNP_WSGL.AddURLParam('U_START_TIME', U_START_TIME);
1186: XNP_WSGL.AddURLParam('P_END_TIME', P_END_TIME);
1187: XNP_WSGL.AddURLParam('U_END_TIME', U_END_TIME);
1188: XNP_WSGL.AddURLParam('P_NEXT_TIMER', P_NEXT_TIMER);
1181: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1182: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1183: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
1184: XNP_WSGL.AddURLParam('P_START_TIME', P_START_TIME);
1185: XNP_WSGL.AddURLParam('U_START_TIME', U_START_TIME);
1186: XNP_WSGL.AddURLParam('P_END_TIME', P_END_TIME);
1187: XNP_WSGL.AddURLParam('U_END_TIME', U_END_TIME);
1188: XNP_WSGL.AddURLParam('P_NEXT_TIMER', P_NEXT_TIMER);
1189: XNP_WSGL.AddURLParam('Z_START', Z_START);
1182: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1183: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
1184: XNP_WSGL.AddURLParam('P_START_TIME', P_START_TIME);
1185: XNP_WSGL.AddURLParam('U_START_TIME', U_START_TIME);
1186: XNP_WSGL.AddURLParam('P_END_TIME', P_END_TIME);
1187: XNP_WSGL.AddURLParam('U_END_TIME', U_END_TIME);
1188: XNP_WSGL.AddURLParam('P_NEXT_TIMER', P_NEXT_TIMER);
1189: XNP_WSGL.AddURLParam('Z_START', Z_START);
1190: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1183: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
1184: XNP_WSGL.AddURLParam('P_START_TIME', P_START_TIME);
1185: XNP_WSGL.AddURLParam('U_START_TIME', U_START_TIME);
1186: XNP_WSGL.AddURLParam('P_END_TIME', P_END_TIME);
1187: XNP_WSGL.AddURLParam('U_END_TIME', U_END_TIME);
1188: XNP_WSGL.AddURLParam('P_NEXT_TIMER', P_NEXT_TIMER);
1189: XNP_WSGL.AddURLParam('Z_START', Z_START);
1190: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1191: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1184: XNP_WSGL.AddURLParam('P_START_TIME', P_START_TIME);
1185: XNP_WSGL.AddURLParam('U_START_TIME', U_START_TIME);
1186: XNP_WSGL.AddURLParam('P_END_TIME', P_END_TIME);
1187: XNP_WSGL.AddURLParam('U_END_TIME', U_END_TIME);
1188: XNP_WSGL.AddURLParam('P_NEXT_TIMER', P_NEXT_TIMER);
1189: XNP_WSGL.AddURLParam('Z_START', Z_START);
1190: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1191: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1192: if not Z_DIRECT_CALL then
1185: XNP_WSGL.AddURLParam('U_START_TIME', U_START_TIME);
1186: XNP_WSGL.AddURLParam('P_END_TIME', P_END_TIME);
1187: XNP_WSGL.AddURLParam('U_END_TIME', U_END_TIME);
1188: XNP_WSGL.AddURLParam('P_NEXT_TIMER', P_NEXT_TIMER);
1189: XNP_WSGL.AddURLParam('Z_START', Z_START);
1190: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1191: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1192: if not Z_DIRECT_CALL then
1193: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1186: XNP_WSGL.AddURLParam('P_END_TIME', P_END_TIME);
1187: XNP_WSGL.AddURLParam('U_END_TIME', U_END_TIME);
1188: XNP_WSGL.AddURLParam('P_NEXT_TIMER', P_NEXT_TIMER);
1189: XNP_WSGL.AddURLParam('Z_START', Z_START);
1190: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1191: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1192: if not Z_DIRECT_CALL then
1193: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1194: return;
1187: XNP_WSGL.AddURLParam('U_END_TIME', U_END_TIME);
1188: XNP_WSGL.AddURLParam('P_NEXT_TIMER', P_NEXT_TIMER);
1189: XNP_WSGL.AddURLParam('Z_START', Z_START);
1190: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1191: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1192: if not Z_DIRECT_CALL then
1193: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1194: return;
1195: end if;
1189: XNP_WSGL.AddURLParam('Z_START', Z_START);
1190: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1191: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1192: if not Z_DIRECT_CALL then
1193: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1194: return;
1195: end if;
1196: end if;
1197:
1200: Z_DIRECT_CALL=>TRUE);
1201: return;
1202: end if;
1203:
1204: XNP_WSGL.OpenPageHead('Timer Registry'||' : '||'Timers');
1205: CreateListJavaScript;
1206: xnp_timers$.TemplateHeader(TRUE,0);
1207: XNP_WSGL.ClosePageHead;
1208:
1203:
1204: XNP_WSGL.OpenPageHead('Timer Registry'||' : '||'Timers');
1205: CreateListJavaScript;
1206: xnp_timers$.TemplateHeader(TRUE,0);
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')));
1205: CreateListJavaScript;
1206: xnp_timers$.TemplateHeader(TRUE,0);
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
1226: P_END_TIME,
1227: U_END_TIME,
1228: P_NEXT_TIMER);
1229: if I_COUNT = -1 then
1230: XNP_WSGL.ClosePageBody;
1231: return;
1232: end if;
1233: end if;
1234:
1233: end if;
1234:
1235: if (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
1236: RL_TOTAL_COUNT_REQD then
1237: I_OF_TOTAL_TEXT := ' '||XNP_WSGL.MsgGetText(111,XNP_WSGLM.DSP111_OF_TOTAL, to_char(I_COUNT));
1238: end if;
1239:
1240: if Z_START IS NULL or (Z_ACTION = RL_FIRST_BUT_ACTION) or (Z_ACTION = RL_FIRST_BUT_CAPTION) then
1241: I_START := 1;
1247: I_START := 1 + (floor((I_COUNT-1)/RL_RECORD_SET_SIZE)*RL_RECORD_SET_SIZE);
1248: elsif Z_ACTION is null and I_START = 1 then
1249: null;
1250: elsif Z_ACTION IS NULL then
1251: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),
1252: 'Timer Registry'||' : '||'Timers', RL_BODY_ATTRIBUTES);
1253: XNP_WSGL.ClosePageBody;
1254: return;
1255: end if;
1249: null;
1250: elsif Z_ACTION IS NULL then
1251: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),
1252: 'Timer Registry'||' : '||'Timers', RL_BODY_ATTRIBUTES);
1253: XNP_WSGL.ClosePageBody;
1254: return;
1255: end if;
1256:
1257: if I_START < 1 then
1277: U_START_TIME,
1278: P_END_TIME,
1279: U_END_TIME,
1280: P_NEXT_TIMER) then
1281: XNP_WSGL.ClosePageBody;
1282: return;
1283: end if;
1284: end if;
1285:
1293: U_START_TIME,
1294: P_END_TIME,
1295: U_END_TIME,
1296: P_NEXT_TIMER) then
1297: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1298: 'Timer Registry'||' : '||'Timers', RL_BODY_ATTRIBUTES);
1299: return;
1300: end if;
1301:
1322: I_TOTAL_ROWS := I_ROWS_FETCHED;
1323:
1324: if I_ROWS_FETCHED <> 0 then
1325:
1326: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
1327:
1328: XNP_WSGL.LayoutRowStart;
1329: for i in 1..RL_NUMBER_OF_COLUMNS loop
1330: XNP_WSGL.LayoutHeader(8, 'RIGHT', 'Order Id');
1324: if I_ROWS_FETCHED <> 0 then
1325:
1326: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
1327:
1328: XNP_WSGL.LayoutRowStart;
1329: for i in 1..RL_NUMBER_OF_COLUMNS loop
1330: XNP_WSGL.LayoutHeader(8, 'RIGHT', 'Order Id');
1331: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Reference Id');
1332: XNP_WSGL.LayoutHeader(30, 'LEFT', 'XML');
1326: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
1327:
1328: XNP_WSGL.LayoutRowStart;
1329: for i in 1..RL_NUMBER_OF_COLUMNS loop
1330: XNP_WSGL.LayoutHeader(8, 'RIGHT', 'Order Id');
1331: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Reference Id');
1332: XNP_WSGL.LayoutHeader(30, 'LEFT', 'XML');
1333: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Timer');
1334: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1327:
1328: XNP_WSGL.LayoutRowStart;
1329: for i in 1..RL_NUMBER_OF_COLUMNS loop
1330: XNP_WSGL.LayoutHeader(8, 'RIGHT', 'Order Id');
1331: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Reference Id');
1332: XNP_WSGL.LayoutHeader(30, 'LEFT', 'XML');
1333: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Timer');
1334: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1335: XNP_WSGL.LayoutHeader(18, 'LEFT', 'Start Time');
1328: XNP_WSGL.LayoutRowStart;
1329: for i in 1..RL_NUMBER_OF_COLUMNS loop
1330: XNP_WSGL.LayoutHeader(8, 'RIGHT', 'Order Id');
1331: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Reference Id');
1332: XNP_WSGL.LayoutHeader(30, 'LEFT', 'XML');
1333: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Timer');
1334: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1335: XNP_WSGL.LayoutHeader(18, 'LEFT', 'Start Time');
1336: XNP_WSGL.LayoutHeader(18, 'LEFT', 'End Time');
1329: for i in 1..RL_NUMBER_OF_COLUMNS loop
1330: XNP_WSGL.LayoutHeader(8, 'RIGHT', 'Order Id');
1331: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Reference Id');
1332: XNP_WSGL.LayoutHeader(30, 'LEFT', 'XML');
1333: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Timer');
1334: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1335: XNP_WSGL.LayoutHeader(18, 'LEFT', 'Start Time');
1336: XNP_WSGL.LayoutHeader(18, 'LEFT', 'End Time');
1337: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Next Timer');
1330: XNP_WSGL.LayoutHeader(8, 'RIGHT', 'Order Id');
1331: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Reference Id');
1332: XNP_WSGL.LayoutHeader(30, 'LEFT', 'XML');
1333: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Timer');
1334: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1335: XNP_WSGL.LayoutHeader(18, 'LEFT', 'Start Time');
1336: XNP_WSGL.LayoutHeader(18, 'LEFT', 'End Time');
1337: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Next Timer');
1338: end loop;
1331: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Reference Id');
1332: XNP_WSGL.LayoutHeader(30, 'LEFT', 'XML');
1333: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Timer');
1334: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1335: XNP_WSGL.LayoutHeader(18, 'LEFT', 'Start Time');
1336: XNP_WSGL.LayoutHeader(18, 'LEFT', 'End Time');
1337: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Next Timer');
1338: end loop;
1339: XNP_WSGL.LayoutRowEnd;
1332: XNP_WSGL.LayoutHeader(30, 'LEFT', 'XML');
1333: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Timer');
1334: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1335: XNP_WSGL.LayoutHeader(18, 'LEFT', 'Start Time');
1336: XNP_WSGL.LayoutHeader(18, 'LEFT', 'End Time');
1337: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Next Timer');
1338: end loop;
1339: XNP_WSGL.LayoutRowEnd;
1340:
1333: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Timer');
1334: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1335: XNP_WSGL.LayoutHeader(18, 'LEFT', 'Start Time');
1336: XNP_WSGL.LayoutHeader(18, 'LEFT', 'End Time');
1337: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Next Timer');
1338: end loop;
1339: XNP_WSGL.LayoutRowEnd;
1340:
1341: while I_ROWS_FETCHED <> 0 loop
1335: XNP_WSGL.LayoutHeader(18, 'LEFT', 'Start Time');
1336: XNP_WSGL.LayoutHeader(18, 'LEFT', 'End Time');
1337: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Next Timer');
1338: end loop;
1339: XNP_WSGL.LayoutRowEnd;
1340:
1341: while I_ROWS_FETCHED <> 0 loop
1342:
1343: if I_TOTAL_ROWS >= I_START then
1349: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);
1350: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.START_TIME);
1351: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.END_TIME);
1352: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.NEXT_TIMER);
1353: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.TIMER_ID));
1354:
1355:
1356: XNP_WSGL.LayoutRowStart('TOP');
1357: XNP_WSGL.LayoutData(htf.anchor2('xnp_timers$xnp_timer_registry.queryview?P_TIMER_ID='||CURR_VAL.TIMER_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.ORDER_ID, ctarget=>L_VF_FRAME));
1352: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.NEXT_TIMER);
1353: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.TIMER_ID));
1354:
1355:
1356: XNP_WSGL.LayoutRowStart('TOP');
1357: XNP_WSGL.LayoutData(htf.anchor2('xnp_timers$xnp_timer_registry.queryview?P_TIMER_ID='||CURR_VAL.TIMER_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.ORDER_ID, ctarget=>L_VF_FRAME));
1358: XNP_WSGL.LayoutData(CURR_VAL.REFERENCE_ID);
1359: XNP_WSGL.LayoutData(htf.anchor2(NBT_VAL.XML_PAYLOAD_LINK, 'XML'));
1360: XNP_WSGL.LayoutData(CURR_VAL.TIMER_MESSAGE_CODE);
1353: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.TIMER_ID));
1354:
1355:
1356: XNP_WSGL.LayoutRowStart('TOP');
1357: XNP_WSGL.LayoutData(htf.anchor2('xnp_timers$xnp_timer_registry.queryview?P_TIMER_ID='||CURR_VAL.TIMER_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.ORDER_ID, ctarget=>L_VF_FRAME));
1358: XNP_WSGL.LayoutData(CURR_VAL.REFERENCE_ID);
1359: XNP_WSGL.LayoutData(htf.anchor2(NBT_VAL.XML_PAYLOAD_LINK, 'XML'));
1360: XNP_WSGL.LayoutData(CURR_VAL.TIMER_MESSAGE_CODE);
1361: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_STATUS, CURR_VAL.STATUS));
1354:
1355:
1356: XNP_WSGL.LayoutRowStart('TOP');
1357: XNP_WSGL.LayoutData(htf.anchor2('xnp_timers$xnp_timer_registry.queryview?P_TIMER_ID='||CURR_VAL.TIMER_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.ORDER_ID, ctarget=>L_VF_FRAME));
1358: XNP_WSGL.LayoutData(CURR_VAL.REFERENCE_ID);
1359: XNP_WSGL.LayoutData(htf.anchor2(NBT_VAL.XML_PAYLOAD_LINK, 'XML'));
1360: XNP_WSGL.LayoutData(CURR_VAL.TIMER_MESSAGE_CODE);
1361: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_STATUS, CURR_VAL.STATUS));
1362: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.START_TIME, 'DD-MON-RRRR HH24:MI:SS')));
1355:
1356: XNP_WSGL.LayoutRowStart('TOP');
1357: XNP_WSGL.LayoutData(htf.anchor2('xnp_timers$xnp_timer_registry.queryview?P_TIMER_ID='||CURR_VAL.TIMER_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.ORDER_ID, ctarget=>L_VF_FRAME));
1358: XNP_WSGL.LayoutData(CURR_VAL.REFERENCE_ID);
1359: XNP_WSGL.LayoutData(htf.anchor2(NBT_VAL.XML_PAYLOAD_LINK, 'XML'));
1360: XNP_WSGL.LayoutData(CURR_VAL.TIMER_MESSAGE_CODE);
1361: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_STATUS, CURR_VAL.STATUS));
1362: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.START_TIME, 'DD-MON-RRRR HH24:MI:SS')));
1363: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.END_TIME, 'DD-MON-RRRR HH24:MI:SS')));
1356: XNP_WSGL.LayoutRowStart('TOP');
1357: XNP_WSGL.LayoutData(htf.anchor2('xnp_timers$xnp_timer_registry.queryview?P_TIMER_ID='||CURR_VAL.TIMER_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.ORDER_ID, ctarget=>L_VF_FRAME));
1358: XNP_WSGL.LayoutData(CURR_VAL.REFERENCE_ID);
1359: XNP_WSGL.LayoutData(htf.anchor2(NBT_VAL.XML_PAYLOAD_LINK, 'XML'));
1360: XNP_WSGL.LayoutData(CURR_VAL.TIMER_MESSAGE_CODE);
1361: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_STATUS, CURR_VAL.STATUS));
1362: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.START_TIME, 'DD-MON-RRRR HH24:MI:SS')));
1363: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.END_TIME, 'DD-MON-RRRR HH24:MI:SS')));
1364: XNP_WSGL.LayoutData(CURR_VAL.NEXT_TIMER);
1357: XNP_WSGL.LayoutData(htf.anchor2('xnp_timers$xnp_timer_registry.queryview?P_TIMER_ID='||CURR_VAL.TIMER_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.ORDER_ID, ctarget=>L_VF_FRAME));
1358: XNP_WSGL.LayoutData(CURR_VAL.REFERENCE_ID);
1359: XNP_WSGL.LayoutData(htf.anchor2(NBT_VAL.XML_PAYLOAD_LINK, 'XML'));
1360: XNP_WSGL.LayoutData(CURR_VAL.TIMER_MESSAGE_CODE);
1361: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_STATUS, CURR_VAL.STATUS));
1362: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.START_TIME, 'DD-MON-RRRR HH24:MI:SS')));
1363: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.END_TIME, 'DD-MON-RRRR HH24:MI:SS')));
1364: XNP_WSGL.LayoutData(CURR_VAL.NEXT_TIMER);
1365: XNP_WSGL.LayoutRowEnd;
1358: XNP_WSGL.LayoutData(CURR_VAL.REFERENCE_ID);
1359: XNP_WSGL.LayoutData(htf.anchor2(NBT_VAL.XML_PAYLOAD_LINK, 'XML'));
1360: XNP_WSGL.LayoutData(CURR_VAL.TIMER_MESSAGE_CODE);
1361: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_STATUS, CURR_VAL.STATUS));
1362: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.START_TIME, 'DD-MON-RRRR HH24:MI:SS')));
1363: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.END_TIME, 'DD-MON-RRRR HH24:MI:SS')));
1364: XNP_WSGL.LayoutData(CURR_VAL.NEXT_TIMER);
1365: XNP_WSGL.LayoutRowEnd;
1366:
1359: XNP_WSGL.LayoutData(htf.anchor2(NBT_VAL.XML_PAYLOAD_LINK, 'XML'));
1360: XNP_WSGL.LayoutData(CURR_VAL.TIMER_MESSAGE_CODE);
1361: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_STATUS, CURR_VAL.STATUS));
1362: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.START_TIME, 'DD-MON-RRRR HH24:MI:SS')));
1363: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.END_TIME, 'DD-MON-RRRR HH24:MI:SS')));
1364: XNP_WSGL.LayoutData(CURR_VAL.NEXT_TIMER);
1365: XNP_WSGL.LayoutRowEnd;
1366:
1367: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1360: XNP_WSGL.LayoutData(CURR_VAL.TIMER_MESSAGE_CODE);
1361: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_STATUS, CURR_VAL.STATUS));
1362: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.START_TIME, 'DD-MON-RRRR HH24:MI:SS')));
1363: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.END_TIME, 'DD-MON-RRRR HH24:MI:SS')));
1364: XNP_WSGL.LayoutData(CURR_VAL.NEXT_TIMER);
1365: XNP_WSGL.LayoutRowEnd;
1366:
1367: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1368: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
1361: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_STATUS, CURR_VAL.STATUS));
1362: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.START_TIME, 'DD-MON-RRRR HH24:MI:SS')));
1363: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.END_TIME, 'DD-MON-RRRR HH24:MI:SS')));
1364: XNP_WSGL.LayoutData(CURR_VAL.NEXT_TIMER);
1365: XNP_WSGL.LayoutRowEnd;
1366:
1367: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1368: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
1369: if I_ROWS_FETCHED <> 0 then
1378: I_TOTAL_ROWS := I_TOTAL_ROWS + I_ROWS_FETCHED;
1379:
1380: end loop;
1381:
1382: XNP_WSGL.LayoutClose;
1383:
1384: if I_START = I_TOTAL_ROWS then
1385: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
1386: else
1381:
1382: XNP_WSGL.LayoutClose;
1383:
1384: if I_START = I_TOTAL_ROWS then
1385: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
1386: else
1387: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
1388: to_char(I_START), to_char(I_TOTAL_ROWS))||
1389: I_OF_TOTAL_TEXT);
1383:
1384: if I_START = I_TOTAL_ROWS then
1385: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
1386: else
1387: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
1388: to_char(I_START), to_char(I_TOTAL_ROWS))||
1389: I_OF_TOTAL_TEXT);
1390: end if;
1391: htp.para;
1389: I_OF_TOTAL_TEXT);
1390: end if;
1391: htp.para;
1392: else
1393: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
1394: end if;
1395:
1396: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
1397: dbms_sql.close_cursor(I_CURSOR);
1397: dbms_sql.close_cursor(I_CURSOR);
1398: end if;
1399:
1400: htp.formOpen(curl => 'xnp_timers$xnp_timer_registry.querylist', cattributes => 'NAME="frmZero"');
1401: XNP_WSGL.HiddenField('P_ORDER_ID', P_ORDER_ID);
1402: XNP_WSGL.HiddenField('U_ORDER_ID', U_ORDER_ID);
1403: XNP_WSGL.HiddenField('P_REFERENCE_ID', P_REFERENCE_ID);
1404: XNP_WSGL.HiddenField('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1405: XNP_WSGL.HiddenField('P_STATUS', P_STATUS);
1398: end if;
1399:
1400: htp.formOpen(curl => 'xnp_timers$xnp_timer_registry.querylist', cattributes => 'NAME="frmZero"');
1401: XNP_WSGL.HiddenField('P_ORDER_ID', P_ORDER_ID);
1402: XNP_WSGL.HiddenField('U_ORDER_ID', U_ORDER_ID);
1403: XNP_WSGL.HiddenField('P_REFERENCE_ID', P_REFERENCE_ID);
1404: XNP_WSGL.HiddenField('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1405: XNP_WSGL.HiddenField('P_STATUS', P_STATUS);
1406: XNP_WSGL.HiddenField('P_START_TIME', P_START_TIME);
1399:
1400: htp.formOpen(curl => 'xnp_timers$xnp_timer_registry.querylist', cattributes => 'NAME="frmZero"');
1401: XNP_WSGL.HiddenField('P_ORDER_ID', P_ORDER_ID);
1402: XNP_WSGL.HiddenField('U_ORDER_ID', U_ORDER_ID);
1403: XNP_WSGL.HiddenField('P_REFERENCE_ID', P_REFERENCE_ID);
1404: XNP_WSGL.HiddenField('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1405: XNP_WSGL.HiddenField('P_STATUS', P_STATUS);
1406: XNP_WSGL.HiddenField('P_START_TIME', P_START_TIME);
1407: XNP_WSGL.HiddenField('U_START_TIME', U_START_TIME);
1400: htp.formOpen(curl => 'xnp_timers$xnp_timer_registry.querylist', cattributes => 'NAME="frmZero"');
1401: XNP_WSGL.HiddenField('P_ORDER_ID', P_ORDER_ID);
1402: XNP_WSGL.HiddenField('U_ORDER_ID', U_ORDER_ID);
1403: XNP_WSGL.HiddenField('P_REFERENCE_ID', P_REFERENCE_ID);
1404: XNP_WSGL.HiddenField('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1405: XNP_WSGL.HiddenField('P_STATUS', P_STATUS);
1406: XNP_WSGL.HiddenField('P_START_TIME', P_START_TIME);
1407: XNP_WSGL.HiddenField('U_START_TIME', U_START_TIME);
1408: XNP_WSGL.HiddenField('P_END_TIME', P_END_TIME);
1401: XNP_WSGL.HiddenField('P_ORDER_ID', P_ORDER_ID);
1402: XNP_WSGL.HiddenField('U_ORDER_ID', U_ORDER_ID);
1403: XNP_WSGL.HiddenField('P_REFERENCE_ID', P_REFERENCE_ID);
1404: XNP_WSGL.HiddenField('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1405: XNP_WSGL.HiddenField('P_STATUS', P_STATUS);
1406: XNP_WSGL.HiddenField('P_START_TIME', P_START_TIME);
1407: XNP_WSGL.HiddenField('U_START_TIME', U_START_TIME);
1408: XNP_WSGL.HiddenField('P_END_TIME', P_END_TIME);
1409: XNP_WSGL.HiddenField('U_END_TIME', U_END_TIME);
1402: XNP_WSGL.HiddenField('U_ORDER_ID', U_ORDER_ID);
1403: XNP_WSGL.HiddenField('P_REFERENCE_ID', P_REFERENCE_ID);
1404: XNP_WSGL.HiddenField('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1405: XNP_WSGL.HiddenField('P_STATUS', P_STATUS);
1406: XNP_WSGL.HiddenField('P_START_TIME', P_START_TIME);
1407: XNP_WSGL.HiddenField('U_START_TIME', U_START_TIME);
1408: XNP_WSGL.HiddenField('P_END_TIME', P_END_TIME);
1409: XNP_WSGL.HiddenField('U_END_TIME', U_END_TIME);
1410: XNP_WSGL.HiddenField('P_NEXT_TIMER', P_NEXT_TIMER);
1403: XNP_WSGL.HiddenField('P_REFERENCE_ID', P_REFERENCE_ID);
1404: XNP_WSGL.HiddenField('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1405: XNP_WSGL.HiddenField('P_STATUS', P_STATUS);
1406: XNP_WSGL.HiddenField('P_START_TIME', P_START_TIME);
1407: XNP_WSGL.HiddenField('U_START_TIME', U_START_TIME);
1408: XNP_WSGL.HiddenField('P_END_TIME', P_END_TIME);
1409: XNP_WSGL.HiddenField('U_END_TIME', U_END_TIME);
1410: XNP_WSGL.HiddenField('P_NEXT_TIMER', P_NEXT_TIMER);
1411: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
1404: XNP_WSGL.HiddenField('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1405: XNP_WSGL.HiddenField('P_STATUS', P_STATUS);
1406: XNP_WSGL.HiddenField('P_START_TIME', P_START_TIME);
1407: XNP_WSGL.HiddenField('U_START_TIME', U_START_TIME);
1408: XNP_WSGL.HiddenField('P_END_TIME', P_END_TIME);
1409: XNP_WSGL.HiddenField('U_END_TIME', U_END_TIME);
1410: XNP_WSGL.HiddenField('P_NEXT_TIMER', P_NEXT_TIMER);
1411: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
1412: htp.p ('');
1413: htp.p ('document.write ('''')');
1414: htp.p ('//-->');
1415: htp.p ('');
1416:
1417: 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,
1418: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
1419: 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,
1420: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1421: 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,
1415: htp.p ('');
1416:
1417: 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,
1418: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
1419: 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,
1420: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1421: 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,
1422: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1423: 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,
1417: 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,
1418: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
1419: 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,
1420: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1421: 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,
1422: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1423: 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,
1424: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
1425:
1419: 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,
1420: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1421: 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,
1422: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1423: 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,
1424: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
1425:
1426: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
1427: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
1422: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1423: 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,
1424: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
1425:
1426: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
1427: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
1428: htp.para;
1429:
1430: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_QUERY_BUT_CAPTION),p_dojs=>FALSE,
1426: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
1427: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
1428: htp.para;
1429:
1430: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_QUERY_BUT_CAPTION),p_dojs=>FALSE,
1431: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_QUERY_BUT_ACTION || '\''"');
1432: XNP_WSGL.HiddenField('Z_CHK',
1433: to_char(XNP_WSGL.Checksum('')));
1434: htp.formClose;
1428: htp.para;
1429:
1430: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_QUERY_BUT_CAPTION),p_dojs=>FALSE,
1431: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_QUERY_BUT_ACTION || '\''"');
1432: XNP_WSGL.HiddenField('Z_CHK',
1433: to_char(XNP_WSGL.Checksum('')));
1434: htp.formClose;
1435:
1436: XNP_WSGL.ReturnLinks('0', XNP_WSGL.MENU_LONG);
1429:
1430: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_QUERY_BUT_CAPTION),p_dojs=>FALSE,
1431: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_QUERY_BUT_ACTION || '\''"');
1432: XNP_WSGL.HiddenField('Z_CHK',
1433: to_char(XNP_WSGL.Checksum('')));
1434: htp.formClose;
1435:
1436: XNP_WSGL.ReturnLinks('0', XNP_WSGL.MENU_LONG);
1437: XNP_WSGL.NavLinks;
1432: XNP_WSGL.HiddenField('Z_CHK',
1433: to_char(XNP_WSGL.Checksum('')));
1434: htp.formClose;
1435:
1436: XNP_WSGL.ReturnLinks('0', XNP_WSGL.MENU_LONG);
1437: XNP_WSGL.NavLinks;
1438:
1439: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
1440:
1433: to_char(XNP_WSGL.Checksum('')));
1434: htp.formClose;
1435:
1436: XNP_WSGL.ReturnLinks('0', XNP_WSGL.MENU_LONG);
1437: XNP_WSGL.NavLinks;
1438:
1439: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
1440:
1441: XNP_WSGL.ClosePageBody;
1437: XNP_WSGL.NavLinks;
1438:
1439: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
1440:
1441: XNP_WSGL.ClosePageBody;
1442:
1443: exception
1444: when others then
1445: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1441: XNP_WSGL.ClosePageBody;
1442:
1443: exception
1444: when others then
1445: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1446: RL_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.QueryList');
1447: XNP_WSGL.ClosePageBody;
1448: end;
1449:
1443: exception
1444: when others then
1445: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1446: RL_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.QueryList');
1447: XNP_WSGL.ClosePageBody;
1448: end;
1449:
1450: --------------------------------------------------------------------------------
1451: -- Name: xnp_timers$xnp_timer_registry.QueryFirst
1476: I_ROWS_FETCHED integer := 0;
1477:
1478: begin
1479:
1480: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.queryfirst');
1481: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1482: XNP_WSGL.AddURLParam('U_ORDER_ID', U_ORDER_ID);
1483: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1484: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1477:
1478: begin
1479:
1480: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.queryfirst');
1481: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1482: XNP_WSGL.AddURLParam('U_ORDER_ID', U_ORDER_ID);
1483: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1484: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1485: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
1478: begin
1479:
1480: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.queryfirst');
1481: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1482: XNP_WSGL.AddURLParam('U_ORDER_ID', U_ORDER_ID);
1483: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1484: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1485: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
1486: XNP_WSGL.AddURLParam('P_START_TIME', P_START_TIME);
1479:
1480: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.queryfirst');
1481: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1482: XNP_WSGL.AddURLParam('U_ORDER_ID', U_ORDER_ID);
1483: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1484: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1485: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
1486: XNP_WSGL.AddURLParam('P_START_TIME', P_START_TIME);
1487: XNP_WSGL.AddURLParam('U_START_TIME', U_START_TIME);
1480: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.queryfirst');
1481: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1482: XNP_WSGL.AddURLParam('U_ORDER_ID', U_ORDER_ID);
1483: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1484: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1485: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
1486: XNP_WSGL.AddURLParam('P_START_TIME', P_START_TIME);
1487: XNP_WSGL.AddURLParam('U_START_TIME', U_START_TIME);
1488: XNP_WSGL.AddURLParam('P_END_TIME', P_END_TIME);
1481: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1482: XNP_WSGL.AddURLParam('U_ORDER_ID', U_ORDER_ID);
1483: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1484: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1485: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
1486: XNP_WSGL.AddURLParam('P_START_TIME', P_START_TIME);
1487: XNP_WSGL.AddURLParam('U_START_TIME', U_START_TIME);
1488: XNP_WSGL.AddURLParam('P_END_TIME', P_END_TIME);
1489: XNP_WSGL.AddURLParam('U_END_TIME', U_END_TIME);
1482: XNP_WSGL.AddURLParam('U_ORDER_ID', U_ORDER_ID);
1483: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1484: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1485: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
1486: XNP_WSGL.AddURLParam('P_START_TIME', P_START_TIME);
1487: XNP_WSGL.AddURLParam('U_START_TIME', U_START_TIME);
1488: XNP_WSGL.AddURLParam('P_END_TIME', P_END_TIME);
1489: XNP_WSGL.AddURLParam('U_END_TIME', U_END_TIME);
1490: XNP_WSGL.AddURLParam('P_NEXT_TIMER', P_NEXT_TIMER);
1483: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1484: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1485: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
1486: XNP_WSGL.AddURLParam('P_START_TIME', P_START_TIME);
1487: XNP_WSGL.AddURLParam('U_START_TIME', U_START_TIME);
1488: XNP_WSGL.AddURLParam('P_END_TIME', P_END_TIME);
1489: XNP_WSGL.AddURLParam('U_END_TIME', U_END_TIME);
1490: XNP_WSGL.AddURLParam('P_NEXT_TIMER', P_NEXT_TIMER);
1491: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1484: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);
1485: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
1486: XNP_WSGL.AddURLParam('P_START_TIME', P_START_TIME);
1487: XNP_WSGL.AddURLParam('U_START_TIME', U_START_TIME);
1488: XNP_WSGL.AddURLParam('P_END_TIME', P_END_TIME);
1489: XNP_WSGL.AddURLParam('U_END_TIME', U_END_TIME);
1490: XNP_WSGL.AddURLParam('P_NEXT_TIMER', P_NEXT_TIMER);
1491: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1492: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1485: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
1486: XNP_WSGL.AddURLParam('P_START_TIME', P_START_TIME);
1487: XNP_WSGL.AddURLParam('U_START_TIME', U_START_TIME);
1488: XNP_WSGL.AddURLParam('P_END_TIME', P_END_TIME);
1489: XNP_WSGL.AddURLParam('U_END_TIME', U_END_TIME);
1490: XNP_WSGL.AddURLParam('P_NEXT_TIMER', P_NEXT_TIMER);
1491: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1492: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1493: if not Z_DIRECT_CALL then
1486: XNP_WSGL.AddURLParam('P_START_TIME', P_START_TIME);
1487: XNP_WSGL.AddURLParam('U_START_TIME', U_START_TIME);
1488: XNP_WSGL.AddURLParam('P_END_TIME', P_END_TIME);
1489: XNP_WSGL.AddURLParam('U_END_TIME', U_END_TIME);
1490: XNP_WSGL.AddURLParam('P_NEXT_TIMER', P_NEXT_TIMER);
1491: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1492: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1493: if not Z_DIRECT_CALL then
1494: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1487: XNP_WSGL.AddURLParam('U_START_TIME', U_START_TIME);
1488: XNP_WSGL.AddURLParam('P_END_TIME', P_END_TIME);
1489: XNP_WSGL.AddURLParam('U_END_TIME', U_END_TIME);
1490: XNP_WSGL.AddURLParam('P_NEXT_TIMER', P_NEXT_TIMER);
1491: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1492: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1493: if not Z_DIRECT_CALL then
1494: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1495: return;
1488: XNP_WSGL.AddURLParam('P_END_TIME', P_END_TIME);
1489: XNP_WSGL.AddURLParam('U_END_TIME', U_END_TIME);
1490: XNP_WSGL.AddURLParam('P_NEXT_TIMER', P_NEXT_TIMER);
1491: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1492: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1493: if not Z_DIRECT_CALL then
1494: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1495: return;
1496: end if;
1490: XNP_WSGL.AddURLParam('P_NEXT_TIMER', P_NEXT_TIMER);
1491: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1492: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1493: if not Z_DIRECT_CALL then
1494: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1495: return;
1496: end if;
1497: end if;
1498:
1496: end if;
1497: end if;
1498:
1499: if Z_ACTION = 'BLANK' then
1500: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1501: return;
1502: end if;
1503:
1504:
1526: U_START_TIME,
1527: P_END_TIME,
1528: U_END_TIME,
1529: P_NEXT_TIMER) then
1530: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1531: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
1532: return;
1533: end if;
1534:
1548:
1549: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1550:
1551: if I_ROWS_FETCHED = 0 then
1552: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1553: else
1554: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.TIMER_ID);
1555: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);
1556: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.REFERENCE_ID);
1566: dbms_sql.close_cursor(I_CURSOR);
1567:
1568: exception
1569: when others then
1570: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1571: VF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.QueryFirst');
1572: XNP_WSGL.ClosePageBody;
1573: end;
1574:
1568: exception
1569: when others then
1570: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1571: VF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.QueryFirst');
1572: XNP_WSGL.ClosePageBody;
1573: end;
1574:
1575: --------------------------------------------------------------------------------
1576: -- Name: xnp_timers$xnp_timer_registry.PreQuery
1599: begin
1600: return L_RET_VAL;
1601: exception
1602: when others then
1603: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1604: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.PreQuery');
1605: return FALSE;
1606: end;
1607:
1622: begin
1623: return L_RET_VAL;
1624: exception
1625: when others then
1626: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1627: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.PostQuery');
1628: return FALSE;
1629: end;
1630:
1705:
1706: htp.p(XNP_WSGJSL.CloseScript);
1707: exception
1708: when others then
1709: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1710: QF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.CreateQueryJavaScript');
1711: end;
1712:
1713: --------------------------------------------------------------------------------
1724: htp.p('var FormType = "List";');
1725: htp.p(XNP_WSGJSL.CloseScript);
1726: exception
1727: when others then
1728: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1729: RL_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.CreateListJavaScript');
1730: end;
1731: end;