PACKAGE: APPS.XNP_SYNC_U

Source

1 PACKAGE XNP_SYNC_U AUTHID CURRENT_USER AS
2 /* $Header: XNPMSYNS.pls 120.1 2005/06/18 00:21:38 appldev  $ */
3 
4 --Create message procedure for message type SYNC
5 --
6 --    18/06/2005  DPUTHIYE   R12 GSCC Mandate: SQL.39 fixed(NOCOPY hint added).
7 PROCEDURE CREATE_MSG  (   XNP$SYNC_LABEL VARCHAR2,
8   XNP$SDP_RESULT_CODE VARCHAR2 DEFAULT NULL,
9   x_msg_header OUT NOCOPY  XNP_MESSAGE.MSG_HEADER_REC_TYPE,
10   x_msg_text   OUT NOCOPY  VARCHAR2,
11   x_error_code OUT NOCOPY  NUMBER,
12   x_error_message OUT NOCOPY VARCHAR2,
13   p_sender_name IN VARCHAR2 DEFAULT NULL,
14   p_recipient_list IN VARCHAR2 DEFAULT NULL,
15   p_version IN NUMBER DEFAULT 1,
16   p_reference_id IN VARCHAR2 DEFAULT NULL,
17   p_opp_reference_id IN VARCHAR2 DEFAULT NULL,
18   p_order_id IN NUMBER DEFAULT NULL,
19   p_wi_instance_id  IN NUMBER DEFAULT NULL,
20   p_fa_instance_id  IN NUMBER  DEFAULT NULL,
21   p_delay  IN NUMBER  DEFAULT NULL,
22   p_interval  IN NUMBER  DEFAULT NULL ) ;
23 
24 --Create publish procedure for message type SYNC
25 --
26 PROCEDURE PUBLISH  (   XNP$SYNC_LABEL VARCHAR2,
27   xnp$sdp_result_code VARCHAR2 DEFAULT NULL,
28   x_message_id OUT NOCOPY  NUMBER,
29   x_error_code OUT NOCOPY  NUMBER,
30   x_error_message OUT NOCOPY VARCHAR2,
31   p_consumer_list IN VARCHAR2 DEFAULT NULL,
32   p_sender_name IN VARCHAR2 DEFAULT NULL,
33   p_recipient_list IN VARCHAR2 DEFAULT NULL,
34   p_version IN NUMBER DEFAULT 1,
35   p_reference_id IN VARCHAR2 DEFAULT NULL,
36   p_opp_reference_id IN VARCHAR2 DEFAULT NULL,
37   p_order_id IN NUMBER DEFAULT NULL,
38   p_wi_instance_id  IN NUMBER DEFAULT NULL,
39   p_fa_instance_id  IN NUMBER  DEFAULT NULL ) ;
40 
41 --Create send procedure for message type SYNC
42 --
43 PROCEDURE SEND  (   XNP$SYNC_LABEL VARCHAR2,
44   XNP$SDP_RESULT_CODE VARCHAR2 DEFAULT NULL,
45   x_message_id OUT NOCOPY  NUMBER,
46   x_error_code OUT NOCOPY  NUMBER,
47   x_error_message OUT NOCOPY VARCHAR2,
48   p_consumer_name  IN VARCHAR2,
49   p_sender_name  IN VARCHAR2 DEFAULT NULL,
50   p_recipient_name  IN VARCHAR2 DEFAULT NULL,
51   p_version  IN NUMBER DEFAULT 1,
52   p_reference_id IN VARCHAR2 DEFAULT NULL,
53   p_opp_reference_id IN VARCHAR2 DEFAULT NULL,
54   p_order_id IN NUMBER DEFAULT NULL,
55   p_wi_instance_id  IN NUMBER DEFAULT NULL,
56   p_fa_instance_id  IN NUMBER  DEFAULT NULL ) ;
57 
58 --Create process procedure for message type SYNC
59 --
60 PROCEDURE PROCESS (    p_msg_header IN XNP_MESSAGE.MSG_HEADER_REC_TYPE,
61   p_msg_text IN VARCHAR2,
62   x_error_code OUT NOCOPY  NUMBER,
63   x_error_message  OUT NOCOPY VARCHAR2,
64   p_process_reference IN VARCHAR2 DEFAULT NULL );
65 
66 --Create default process procedure for message type SYNC
67 --
68 PROCEDURE DEFAULT_PROCESS (    p_msg_header IN XNP_MESSAGE.MSG_HEADER_REC_TYPE,
69   p_msg_text IN VARCHAR2,
70   x_error_code OUT NOCOPY  NUMBER,
71   x_error_message  OUT NOCOPY VARCHAR2 ) ;
72 
73 --Create validate procedure for message type SYNC
74 --
75 PROCEDURE VALIDATE (    p_msg_header IN OUT NOCOPY XNP_MESSAGE.MSG_HEADER_REC_TYPE,
76   p_msg_text IN VARCHAR2,
77   x_error_code OUT NOCOPY  NUMBER,
78   x_error_message  OUT NOCOPY VARCHAR2 ) ;
79 
80 END XNP_SYNC_U;