DBA Data[Home] [Help]

APPS.XNP_TIMER dependencies on XNP_MESSAGE

Line 6: p_msg_header IN xnp_message.msg_header_rec_type,

2: /* $Header: XNPTIMRB.pls 120.2 2006/02/13 07:57:10 dputhiye ship $ */
3:
4: /* forward declarations */
5: PROCEDURE add_timer (
6: p_msg_header IN xnp_message.msg_header_rec_type,
7: p_msg_text IN VARCHAR2,
8: p_dummy_for IN VARCHAR2 DEFAULT NULL,
9: x_error_code OUT NOCOPY NUMBER,
10: x_error_message OUT NOCOPY VARCHAR2 ) ;

Line 22: p_msg_header IN xnp_message.msg_header_rec_type

18: ---- Otherwise enqueues the actual timer.
19: --------------------------------------------------------------------------
20: PROCEDURE start_timer (
21:
22: p_msg_header IN xnp_message.msg_header_rec_type
23: ,p_msg_text IN VARCHAR2
24: ,x_error_code OUT NOCOPY NUMBER
25: ,x_error_message OUT NOCOPY VARCHAR2
26:

Line 34: l_msg_header xnp_message.msg_header_rec_type;

30: l_delay NUMBER := 0 ;
31: l_interval NUMBER := 0 ;
32:
33: l_temp VARCHAR2(1024) ;
34: l_msg_header xnp_message.msg_header_rec_type;
35: l_msg_text VARCHAR2(32767) ;
36:
37: l_payload varchar2(32767) ;
38:

Line 102: p_msg_header IN xnp_message.msg_header_rec_type,

98: -- Caller: add_to_registry
99: ----------------------------------------------------------------------
100:
101: PROCEDURE get_active_timer(
102: p_msg_header IN xnp_message.msg_header_rec_type,
103: p_dummy_for IN VARCHAR2,
104: p_timer_id OUT NOCOPY NUMBER,
105: x_error_code OUT NOCOPY NUMBER,
106: x_error_message OUT NOCOPY VARCHAR2)

Line 146: p_msg_header IN xnp_message.msg_header_rec_type,

142: ---- PROCEDURE: add_timer()
143: ---- PURPOSE: Adds the timer to the queue and to the registry.
144: -------------------------------------------------------------------------
145: PROCEDURE add_timer (
146: p_msg_header IN xnp_message.msg_header_rec_type,
147: p_msg_text IN VARCHAR2,
148: p_dummy_for IN VARCHAR2 DEFAULT NULL,
149: x_error_code OUT NOCOPY NUMBER,
150: x_error_message OUT NOCOPY VARCHAR2 )

Line 211: xnp_message.push(p_msg_header => p_msg_header,

207: END IF ;
208:
209: l_interval := TO_NUMBER(l_interval_txt) ;
210:
211: xnp_message.push(p_msg_header => p_msg_header,
212: p_body_text => p_msg_text,
213: p_queue_name => xnp_event.c_timer_q,
214: p_priority => 1,
215: p_delay => l_interval,

Line 216: p_commit_mode => xnp_message.c_on_commit) ;

212: p_body_text => p_msg_text,
213: p_queue_name => xnp_event.c_timer_q,
214: p_priority => 1,
215: p_delay => l_interval,
216: p_commit_mode => xnp_message.c_on_commit) ;
217:
218:
219: l_start_time := SYSDATE ;
220: l_end_time := l_start_time + (l_interval/86400) ; --24*3600 replaced by 86400