1 PACKAGE XNP_CONTROL_U AUTHID CURRENT_USER AS
2 /* $Header: XNPCTRLS.pls 120.1 2005/06/18 00:37:00 appldev $ */
3 -- Create message procedure for message type control used
4 -- to handle the operations of adapter.
5 --
6 -- 18/06/2005 DPUTHIYE R12 GSCC Mandate: SQL.39 fixed(NOCOPY hint added).
7 PROCEDURE CREATE_MSG ( XNP$OPERATION VARCHAR2,
8 XNP$OP_DATA VARCHAR2,
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 -- Publish message procedure for message type control used to
24 -- handle the opeartions of adapter
25 --
26 PROCEDURE PUBLISH ( XNP$OPERATION VARCHAR2,
27 XNP$OP_DATA VARCHAR2,
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 -- Send message procedure for message type control
41 -- used to handle the operations of adapter
42 --
43 PROCEDURE SEND ( XNP$OPERATION VARCHAR2,
44 XNP$OP_DATA VARCHAR2,
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 -- Process message procedure for message type control used
58 -- to handle the operations of adapter
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 -- Deafult process procedure for message type control used
66 -- to handle the operations of adapter
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 -- Validate message procedure for message type control used
73 -- to handle the operations of adapter
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_CONTROL_U;