APPS.XNP_TIMER dependencies on XNP_TIMER_REGISTRY

Line 110: FROM xnp_timer_registry

106: x_error_message OUT NOCOPY VARCHAR2)
107: IS
108: CURSOR c_timer_reg(p_message_code IN VARCHAR2) IS
109: SELECT timer_id,timer_message_code,next_timer
110: FROM xnp_timer_registry
111: WHERE
112: reference_id=p_msg_header.reference_id
113: AND
114: (

Line 121: l_msg_code VARCHAR2(20); -- AS PER XNP_TIMER_REGISTRY.TIMER_MESSAGE_CODE

117: next_timer= p_message_code
118: )
119: AND status = 'ACTIVE';
120:
121: l_msg_code VARCHAR2(20); -- AS PER XNP_TIMER_REGISTRY.TIMER_MESSAGE_CODE
122: BEGIN
123: x_error_code := 0;
124: IF p_dummy_for IS NULL THEN
125: l_msg_code := p_msg_header.message_code;

Line 222: INSERT INTO xnp_timer_registry (

218:
219: l_start_time := SYSDATE ;
220: l_end_time := l_start_time + (l_interval/86400) ; --24*3600 replaced by 86400
221:
222: INSERT INTO xnp_timer_registry (
223: timer_id,
224: reference_id,
225: timer_message_code,
226: status,