1 PACKAGE CLN_NP_PROCESSOR_PKG AS
2 /* $Header: ECXNPNPS.pls 120.0 2005/08/25 04:47:51 nparihar noship $ */
3 --
4 -- Package
5 -- CLN_NP_PROCESSOR_PKG
6 --
7 -- Purpose
8 -- Spec of package CLN_NP_PROCESSOR_PKG
9 -- Based on the notification code, fetches the notification actions
10 -- and executes the actions that are defined by the user.
11 -- The actions can be one of the following : Raise Event, Start Workflow,
12 -- Notify Administartor, Notify Trading Pratner and Call user Procedure.
13 -- This package is triggered by Notification Message Map when a Notification BOD arraives,
14 -- XML Gateway Error Handling.
15 -- History
16 -- Mar-22-2001 Kodanda Ram Created
17 --
18
19
20 -- Name
21 -- PROCESS_NOTIFICATION
22 -- Purpose
23 -- Based on the notification code, fetches the notification actions
24 -- and executes the actions that are defined by the user.
25 -- Arguments
26 -- p_tp_id Trading Partner ID
27 -- notification_code Notification Code Received
28 -- p_reference Application Reference ID
29 -- p_statuslvl '00' for Sucess and '99' for Error
30 -- p_header_desc Header description
31 -- p_reason_code Comma seperated list of notification code
32 -- p_line_desc Line description
33 -- p_int_con_no Internal Control Number
34 -- p_coll_point Collaboration Point
35 -- p_doc_dir Document Direction
36 -- Notes
37 -- No specific notes
38
39 PROCEDURE PROCESS_NOTIFICATION(
40 x_ret_code OUT NOCOPY VARCHAR2,
41 x_ret_desc OUT NOCOPY VARCHAR2,
42 p_tp_id IN VARCHAR2,
43 p_reference IN VARCHAR2,
44 p_statuslvl IN VARCHAR2,
45 p_header_desc IN VARCHAR2,
46 p_reason_code IN VARCHAR2,
47 p_line_desc IN VARCHAR2,
48 p_int_con_no IN VARCHAR2,
49 p_coll_point IN VARCHAR2,
50 p_doc_dir IN VARCHAR2,
51 p_coll_id IN NUMBER,
52 p_collaboration_standard IN VARCHAR2 DEFAULT NULL);
53
54
55 -- Name
56 -- TAKE_ACTIONS
57 -- Purpose
58 -- This procedure performs all the user defined actions for the specified
59 -- comma seperated list of notification codes
60 -- Arguments
61 -- p_notification_code Comma seperated list of notification code
62 -- p_notification_desc Comma seperated list of notification description
63 -- p_status SUCCESS/ERROR
64 -- p_tp_id Trading Partner ID
65 -- p_reference Application Reference ID
66 -- p_coll_point Collaboration Point
67 -- Notes
68 -- No specific notes
69
70 PROCEDURE TAKE_ACTIONS(
71 x_ret_code OUT NOCOPY VARCHAR2,
72 x_ret_desc OUT NOCOPY VARCHAR2,
73 p_notification_code IN VARCHAR2,
74 p_notification_desc IN VARCHAR2,
75 p_status IN VARCHAR2,
76 p_tp_id IN VARCHAR2,
77 p_reference IN VARCHAR2,
78 p_coll_point IN VARCHAR2,
79 p_int_con_no IN VARCHAR2);
80
81 -- Name
82 -- GET_DELIMITER
83 -- Purpose
84 -- This function returns the delimiter character used to delimit a list of notification code/description
85 -- Arguments
86 --
87 -- Notes
88 -- No specific notes.
89
90 FUNCTION GET_DELIMITER RETURN VARCHAR2;
91
92 -- Name
93 -- GET_TRADING_PARTNER_DETAILS
94 -- Purpose
95 -- This procedure gets the trading partner id based on the internal control number
96 -- Arguments
97 --
98 -- Notes
99 -- No specific notes.
100
101 PROCEDURE GET_TRADING_PARTNER_DETAILS(
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_xmlg_internal_control_number IN NUMBER,
105 p_tr_partner_id IN OUT NOCOPY VARCHAR2);
106
107 -- Name
108 -- NOTIFY_ADMINISTRATOR
109 -- Purpose
110 -- Sends a mail to the administrator
111 -- Arguments
112 -- Message to be send to the administrator
113 -- Notes
114 -- No specific notes.
115
116 PROCEDURE NOTIFY_ADMINISTRATOR(
117 p_message IN VARCHAR2);
118
119
120
121 -- Name
122 -- PROCESS_NOTIF_ACTIONS_EVT
123 -- Purpose
124 -- This procedure handles a notification by executing all the actions defined by the user
125 -- for a given notification code.
126 --
127 -- Arguments
128 --
129 -- Notes
130 -- No specific notes
131
132 PROCEDURE PROCESS_NOTIF_ACTIONS_EVT(
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_coll_id IN NUMBER,
136 p_xmlg_transaction_type IN VARCHAR2,
137 p_xmlg_transaction_subtype IN VARCHAR2,
138 p_xmlg_int_transaction_type IN VARCHAR2,
139 p_xmlg_int_transaction_subtype IN VARCHAR2,
140 p_xmlg_document_id IN VARCHAR2,
141 p_doc_dir IN VARCHAR2,
142 p_tr_partner_type IN VARCHAR2,
143 p_tr_partner_id IN VARCHAR2,
144 p_tr_partner_site IN VARCHAR2,
145 p_xmlg_msg_id IN VARCHAR2,
146 p_application_id IN VARCHAR2,
147 p_unique1 IN VARCHAR2,
148 p_unique2 IN VARCHAR2,
149 p_unique3 IN VARCHAR2,
150 p_unique4 IN VARCHAR2,
151 p_unique5 IN VARCHAR2,
152 p_xmlg_internal_control_number IN NUMBER,
153 p_collaboration_pt IN VARCHAR2,
154 p_notification_code IN VARCHAR2,
155 p_notification_desc IN VARCHAR2,
156 p_notification_status IN VARCHAR2,
157 p_notification_event IN WF_EVENT_T DEFAULT NULL );
158
159
160 -- Name
161 -- PROCESS_NOTIF_BATCH_EVT
162 -- Purpose
163 -- This procedure handles a Batch notification request by executing all the actions
164 -- defined by the user for a given notification code.
165 --
166 -- Arguments
167 --
168 -- Notes
169 -- No specific notes
170
171 PROCEDURE PROCESS_NOTIF_BATCH_EVT(
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_data OUT NOCOPY VARCHAR2,
174 p_attribute_name IN VARCHAR2,
175 p_attribute_value IN VARCHAR2,
176 p_notification_receiver IN VARCHAR2,
177 p_application_id IN VARCHAR2,
178 p_collaboration_std IN VARCHAR2,
179 p_collaboration_type IN VARCHAR2,
180 p_collaboration_point IN VARCHAR2,
181 p_notification_code IN VARCHAR2,
182 p_notification_msg IN VARCHAR2,
183 p_notification_status IN VARCHAR2);
184
185
186
187 END CLN_NP_PROCESSOR_PKG;