1 PACKAGE XNP_SYNC_TIMER_U AUTHID CURRENT_USER AS
2 /* $Header: XNPSYTIS.pls 120.2 2006/02/13 07:56:46 dputhiye ship $ */
3
4 --Create message procedure for message type SYNC_TIMER
5 --
6 PROCEDURE CREATE_MSG ( x_msg_header OUT NOCOPY XNP_MESSAGE.MSG_HEADER_REC_TYPE,
7 x_msg_text OUT NOCOPY VARCHAR2,
8 x_error_code OUT NOCOPY NUMBER,
9 x_error_message OUT NOCOPY VARCHAR2,
10 p_sender_name IN VARCHAR2 DEFAULT NULL,
11 p_recipient_list IN VARCHAR2 DEFAULT NULL,
12 p_version IN NUMBER DEFAULT 1,
13 p_reference_id IN VARCHAR2 DEFAULT NULL,
14 p_opp_reference_id IN VARCHAR2 DEFAULT NULL,
15 p_order_id IN NUMBER DEFAULT NULL,
16 p_wi_instance_id IN NUMBER DEFAULT NULL,
17 p_fa_instance_id IN NUMBER DEFAULT NULL,
18 p_delay IN NUMBER DEFAULT NULL,
19 p_interval IN NUMBER DEFAULT NULL ) ;
20
21
22
23
24 --Create process procedure for message type SYNC_TIMER
25 --
26 PROCEDURE PROCESS ( p_msg_header IN XNP_MESSAGE.MSG_HEADER_REC_TYPE,
27 p_msg_text IN VARCHAR2,
28 x_error_code OUT NOCOPY NUMBER,
29 x_error_message OUT NOCOPY VARCHAR2,
30 p_process_reference IN VARCHAR2 DEFAULT NULL );
31
32 --Create default process procedure for message type SYNC_TIMER
33 --
34 PROCEDURE DEFAULT_PROCESS ( p_msg_header IN XNP_MESSAGE.MSG_HEADER_REC_TYPE,
35 p_msg_text IN VARCHAR2,
36 x_error_code OUT NOCOPY NUMBER,
37 x_error_message OUT NOCOPY VARCHAR2 ) ;
38
39 --Create validate procedure for message type SYNC_TIMER
40 --
41 PROCEDURE VALIDATE ( p_msg_header IN OUT NOCOPY XNP_MESSAGE.MSG_HEADER_REC_TYPE,
42 p_msg_text IN VARCHAR2,
43 x_error_code OUT NOCOPY NUMBER,
44 x_error_message OUT NOCOPY VARCHAR2 ) ;
45
46 --Create fire procedure for message type SYNC_TIMER
47 --
48 PROCEDURE FIRE ( x_timer_id OUT NOCOPY NUMBER,
49 x_timer_contents OUT NOCOPY VARCHAR2,
50 x_error_code OUT NOCOPY NUMBER,
51 x_error_message OUT NOCOPY VARCHAR2,
52 p_sender_name IN VARCHAR2 DEFAULT NULL,
53 p_recipient_list IN VARCHAR2 DEFAULT NULL,
54 p_version IN NUMBER DEFAULT 1,
55 p_reference_id IN VARCHAR2 DEFAULT NULL,
56 p_opp_reference_id IN VARCHAR2 DEFAULT NULL,
57 p_order_id IN NUMBER DEFAULT NULL,
58 p_wi_instance_id IN NUMBER DEFAULT NULL,
59 p_fa_instance_id IN NUMBER DEFAULT NULL ) ;
60 END XNP_SYNC_TIMER_U;