APPS.XNP_TIMER dependencies on XNP_TIMER

Line 1: PACKAGE BODY xnp_timer AS

1: PACKAGE BODY xnp_timer AS
2: /* $Header: XNPTIMRB.pls 120.2 2006/02/13 07:57:10 dputhiye ship $ */
3:
4: /* forward declarations */
5: PROCEDURE add_timer (

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 186: xnp_timer_core.remove_timer(

182: IF (x_error_code <> 0) THEN
183: return;
184: ELSE
185: IF l_timer_id IS NOT NULL THEN
186: xnp_timer_core.remove_timer(
187: p_timer_id => l_timer_id,
188: x_error_code => x_error_code,
189: x_error_message => x_error_message) ;
190:

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,

Line 263: END xnp_timer;

259:
260: END add_timer ;
261:
262:
263: END xnp_timer;