APPS.XNP_TIMERS$XNP_TIMER_REGISTRY dependencies on XNP_MSG_TYPES_B

Line 165: from XNP_MSG_TYPES_B MESSAGE_TYPES_2

161: Z_MODE in varchar2) return boolean is
162: begin
163: select MESSAGE_TYPES_2.MSG_CODE
164: into CURR_VAL.TIMER_MESSAGE_CODE
165: from XNP_MSG_TYPES_B MESSAGE_TYPES_2
166: where rownum = 1
167: and ( MESSAGE_TYPES_2.MSG_CODE = P_TIMER_MESSAGE_CODE )
168: and MSG_TYPE = 'TIMER';
169: return TRUE;

Line 200: from XNP_MSG_TYPES_B

196: Z_MODE in varchar2) return boolean is
197: begin
198: select MSG_CODE
199: into CURR_VAL.NEXT_TIMER
200: from XNP_MSG_TYPES_B
201: where rownum = 1
202: and MSG_TYPE = 'TIMER'
203: and ( MSG_CODE = P_NEXT_TIMER
204: or (MSG_CODE is null and P_NEXT_TIMER is null) );

Line 340: from XNP_MSG_TYPES_B MESSAGE_TYPES_2

336: l_ll varchar2(100);
337: l_retval number;
338: cursor c1(zmode varchar2,srch varchar2,uu varchar2,ul varchar2,lu varchar2,ll varchar2) is
339: select MESSAGE_TYPES_2.MSG_CODE TIMER_MESSAGE_CODE
340: from XNP_MSG_TYPES_B MESSAGE_TYPES_2
341: where ((MESSAGE_TYPES_2.MSG_CODE like uu||'%' or
342: MESSAGE_TYPES_2.MSG_CODE like ul||'%' or
343: MESSAGE_TYPES_2.MSG_CODE like lu||'%' or
344: MESSAGE_TYPES_2.MSG_CODE like ll||'%') and

Line 494: from XNP_MSG_TYPES_B

490: l_ll varchar2(100);
491: l_retval number;
492: cursor c1(zmode varchar2,srch varchar2,uu varchar2,ul varchar2,lu varchar2,ll varchar2) is
493: select MSG_CODE NEXT_TIMER
494: from XNP_MSG_TYPES_B
495: where ((MSG_CODE like uu||'%' or
496: MSG_CODE like ul||'%' or
497: MSG_CODE like lu||'%' or
498: MSG_CODE like ll||'%') and

Line 772: XNP_MSG_TYPES_B MESSAGE_TYPES_2';

768: TIMER_REGISTRY.START_TIME,
769: TIMER_REGISTRY.END_TIME,
770: TIMER_REGISTRY.NEXT_TIMER
771: FROM XNP_TIMER_REGISTRY TIMER_REGISTRY,
772: XNP_MSG_TYPES_B MESSAGE_TYPES_2';
773:
774: ZONE_SQL := ZONE_SQL || I_WHERE;
775: ZONE_SQL := ZONE_SQL || ' ORDER BY TIMER_REGISTRY.TIMER_ID Desc ,
776: TIMER_REGISTRY.TIMER_MESSAGE_CODE';

Line 1095: XNP_MSG_TYPES_B MESSAGE_TYPES_2

1091: CURR_VAL.START_TIME,
1092: CURR_VAL.END_TIME,
1093: CURR_VAL.NEXT_TIMER
1094: FROM XNP_TIMER_REGISTRY TIMER_REGISTRY,
1095: XNP_MSG_TYPES_B MESSAGE_TYPES_2
1096: WHERE TIMER_REGISTRY.TIMER_ID = CURR_VAL.TIMER_ID
1097: AND MESSAGE_TYPES_2.MSG_CODE = TIMER_REGISTRY.TIMER_MESSAGE_CODE
1098: ;
1099: