1 PACKAGE CLN_ACK_PO_PKG AUTHID CURRENT_USER AS
2 /* $Header: CLNACKPS.pls 120.2 2006/03/27 00:35:09 kkram noship $ */
3 -- Package
4 -- CLN_ACK_PO_PKG
5 --
6 -- Purpose
7 -- Spec of package CLN_ACK_PO_PKG.
8 --
9 -- History
10 -- May-14-2002 Rahul Krishan Created
11
12
13
14 -- Name
15 -- PROCESS_HEADER
16 -- Purpose
17 -- The main purpose of this procedure is to check whether the collaboration exists for
18 -- for a particular reference id or not.
19 --
20 -- Arguments
21 --
22 -- Notes
23 -- No specific notes.
24
25
26 PROCEDURE PROCESS_HEADER(
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_data OUT NOCOPY VARCHAR2,
29 p_ref_id IN VARCHAR2,
30 p_sender_component IN VARCHAR2,
31 p_po_number IN VARCHAR2,
32 p_release_number IN NUMBER,
33 p_revision_number IN NUMBER,
34 p_ackcode_header IN NUMBER,
35 p_note IN LONG,
36 p_requestor IN VARCHAR2,
37 p_int_cont_num IN VARCHAR2,
38 p_request_origin IN VARCHAR2,
39 p_tp_header_id IN NUMBER,
40 p_tp_id OUT NOCOPY VARCHAR2,
41 p_tp_site_id OUT NOCOPY VARCHAR2,
42 x_cln_required OUT NOCOPY VARCHAR2,
43 x_collaboration_type OUT NOCOPY VARCHAR2,
44 x_coll_id OUT NOCOPY NUMBER,
45 x_notification_code OUT NOCOPY VARCHAR2,
46 x_notification_status OUT NOCOPY VARCHAR2,
47 x_return_status_tp OUT NOCOPY VARCHAR2,
48 x_call_po_apis OUT NOCOPY VARCHAR2 );
49
50
51
52
53
54 -- Name
55 -- PROCESS_HEADER_LINES
56 -- Purpose
57 -- The main purpose of this procedure is to provide a sequence of actions that
58 -- need to be taken depending upon the ACKCODE value at the header level and also
59 -- on the Collaboration Type.
60 -- Arguments
61 --
62 -- Notes
63 -- No specific notes.
64
65 PROCEDURE PROCESS_HEADER_LINES(
66 x_return_status IN OUT NOCOPY VARCHAR2,
67 x_msg_data IN OUT NOCOPY VARCHAR2,
68 p_requestor IN VARCHAR2,
69 p_po_number IN VARCHAR2,
70 p_release_number IN NUMBER,
71 p_revision_number IN NUMBER,
72 p_line_number IN NUMBER,
73 p_previous_line_number IN OUT NOCOPY NUMBER,
74 p_shipment_number IN NUMBER,
75 p_new_quantity IN NUMBER,
76 p_po_quantity_uom IN VARCHAR2,
77 p_po_price_currency IN VARCHAR2,
78 p_po_price_uom IN VARCHAR2,
79 p_new_price IN NUMBER,
80 p_ackcode_header IN NUMBER,
81 p_ackcode_line IN NUMBER,
82 p_coll_id IN NUMBER,
83 p_new_promised_date IN DATE,
84 p_collaboration_type IN VARCHAR2,
85 p_org_ref IN VARCHAR2,
86 p_cln_required IN VARCHAR2,
87 p_internal_control_number IN VARCHAR2,
88 p_supplier_part_number IN VARCHAR2,
89 p_so_num IN VARCHAR2,
90 p_so_line_num IN NUMBER,
91 p_so_line_status IN VARCHAR2,
92 p_reason IN VARCHAR2,
93 p_tp_id IN VARCHAR2,
94 p_tp_site_id IN VARCHAR2,
95 p_msg_dtl_screen IN OUT NOCOPY VARCHAR2,
96 p_msg_txt_lines IN OUT NOCOPY VARCHAR2,
97 p_if_collaboration_updated IN OUT NOCOPY VARCHAR2,
98 -- Additional parameters added for new Change_PO API to
99 -- support split lines and cancellation at header and schedule level.
100 p_supp_doc_ref IN VARCHAR2 DEFAULT NULL,
101 p_supp_line_ref IN VARCHAR2 DEFAULT NULL,
102 p_supplier_shipment_ref IN VARCHAR2 DEFAULT NULL,
103 p_parent_shipment_number IN VARCHAR2 DEFAULT NULL);
104
105
106 -- Name
107 -- LOAD_CHANGES
108 -- Purpose
109 -- Call Process Supplier Request of Update_PO API to
110 -- load all changes in to interface tables
111 -- Arguments
112 -- Internal Control Number
113 -- Notes
114 -- No Specific Notes
115
116 PROCEDURE LOAD_CHANGES(
117 p_call_po_apis IN VARCHAR2,
118 p_internal_ctrl_num IN VARCHAR2,
119 p_requestor IN VARCHAR2,
120 p_request_origin IN VARCHAR2,
121 p_tp_id IN VARCHAR2,
122 p_tp_site_id IN VARCHAR2,
123 x_return_status IN OUT NOCOPY VARCHAR2,
124 x_msg_data IN OUT NOCOPY VARCHAR2 );
125
126
127 -- Name
128 -- ACKPO_ERROR_HANDLER
129 -- Purpose
130 --
131 -- Arguments
132 --
133 -- Notes
134 -- No specific notes.
135
136 PROCEDURE ACKPO_ERROR_HANDLER(
137 x_return_status IN OUT NOCOPY VARCHAR2,
138 x_msg_data IN OUT NOCOPY VARCHAR2,
139 p_po_number IN VARCHAR2,
140 p_org_ref IN VARCHAR2,
141 p_coll_id IN NUMBER,
142 p_internal_control_number IN VARCHAR2,
143 x_notification_code OUT NOCOPY VARCHAR2,
144 x_notification_status OUT NOCOPY VARCHAR2,
145 x_return_status_tp OUT NOCOPY VARCHAR2,
146 p_cln_required IN VARCHAR2 );
147
148 -- Name
149 -- PROCESS_HEADER_LINES_RN
150 -- Purpose
151 -- This procedure is used when message standard is Rosettanet.
152 -- The main purpose of this procedure is to provide a sequence of actions that
153 -- need to be taken to consume the Acknowledgement depending upon the ACKCODE
154 -- value at the header level and on the Collaboration Type.
155 -- Arguments
156 --
157 -- Notes
158 -- No specific notes.
159
160
161 PROCEDURE PROCESS_HEADER_LINES_RN(
162 x_return_status IN OUT NOCOPY VARCHAR2,
163 x_msg_data IN OUT NOCOPY VARCHAR2,
164 p_requestor IN VARCHAR2,
165 p_po_number IN VARCHAR2,
166 p_release_number IN NUMBER,
167 p_revision_number IN NUMBER,
168 p_line_number IN NUMBER,
169 p_previous_line_number IN OUT NOCOPY NUMBER,
170 p_shipment_number IN NUMBER,
171 p_new_quantity IN NUMBER,
172 p_po_quantity_uom IN VARCHAR2,
173 p_po_price_currency IN VARCHAR2,
174 p_po_price_uom IN VARCHAR2,
175 p_new_price IN NUMBER,
176 p_ackcode_header IN NUMBER,
177 p_ackcode_line IN NUMBER,
178 p_coll_id IN NUMBER,
179 p_new_promised_date IN DATE,
180 p_collaboration_type IN VARCHAR2,
181 p_org_ref IN VARCHAR2,
182 p_cln_required IN VARCHAR2,
183 p_internal_control_number IN VARCHAR2,
184 p_supplier_part_number IN VARCHAR2,
185 p_so_num IN VARCHAR2,
186 p_so_line_num IN NUMBER,
187 p_so_line_status IN VARCHAR2,
188 p_reason IN VARCHAR2,
189 p_tp_id IN VARCHAR2,
190 p_tp_site_id IN VARCHAR2,
191 p_msg_dtl_screen IN OUT NOCOPY VARCHAR2,
192 p_msg_txt_lines IN OUT NOCOPY VARCHAR2,
193 p_if_collaboration_updated IN OUT NOCOPY VARCHAR2,
194 -- Additional parameters added for new Change_PO API to
195 -- support split lines and cancellation at header and schedule level.
196 p_supp_doc_ref IN VARCHAR2 DEFAULT NULL,
197 p_supp_line_ref IN VARCHAR2 DEFAULT NULL,
198 p_supplier_shipment_ref IN VARCHAR2 DEFAULT NULL,
199 p_parent_shipment_number IN VARCHAR2 DEFAULT NULL);
200
201 -- Name
202 -- PROCESS_HEADER_RN
203 -- Purpose
204 -- This procedure is used when the message standard is Rosettanet.
205 -- This procedure processes the header level
206 -- Arguments
207 --
208 -- Notes
209 -- No specific notes.
210 PROCEDURE PROCESS_HEADER_RN(
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_data OUT NOCOPY VARCHAR2,
213 p_sender_component IN VARCHAR2,
214 p_po_number IN VARCHAR2,
215 p_release_number IN NUMBER,
216 p_revision_number IN NUMBER,
217 p_ackcode_header IN NUMBER,
218 p_note IN LONG,
219 p_requestor IN VARCHAR2,
220 p_int_cont_num IN VARCHAR2,
221 p_request_origin IN VARCHAR2,
222 p_tp_header_id IN NUMBER,
223 p_collaboration_type IN VARCHAR2,
224 p_tp_id OUT NOCOPY VARCHAR2,
225 p_tp_site_id OUT NOCOPY VARCHAR2,
226 x_cln_required OUT NOCOPY VARCHAR2,
227 x_notification_code OUT NOCOPY VARCHAR2,
228 x_notification_status OUT NOCOPY VARCHAR2,
229 x_return_status_tp OUT NOCOPY VARCHAR2,
230 x_call_po_apis OUT NOCOPY VARCHAR2 );
231 -- Name
232 -- PROCESS_HEADER_RN
233 -- Purpose
234 -- This procedure is to get the accode bases on the Acknowledgement Reason Code and
235 -- PO Status Code
236 -- Arguments
237 --
238 -- Notes
239 -- No specific notes.
240
241
242
243 PROCEDURE CLN_GET_PO_ACK_CODE_RN (
244 p_po_ack_reason_code IN VARCHAR2,
245 p_po_status_code IN VARCHAR2,
246 x_po_ack_code OUT NOCOPY VARCHAR2);
247
248 -- Name
249 -- UPDATE_COLL_FOR_HDR_ONLY_MSG
250 -- Purpose
251 -- Called to update collaboration for ACK_PO messages, which doent have POLINE
252 -- Arguments
253 --
254 -- Notes
255 -- No specific notes.
256 PROCEDURE UPDATE_COLL_FOR_HDR_ONLY_MSG(
257 x_return_status IN OUT NOCOPY VARCHAR2,
258 x_msg_data IN OUT NOCOPY VARCHAR2,
259 p_ackcode_header IN NUMBER,
260 p_ackcode_line IN NUMBER,
261 p_coll_id IN NUMBER,
262 p_org_ref IN VARCHAR2,
263 p_cln_required IN VARCHAR2,
264 p_internal_control_number IN VARCHAR2,
265 p_so_num IN VARCHAR2,
266 p_message IN OUT NOCOPY VARCHAR2,
267 p_if_collaboration_updated IN OUT NOCOPY VARCHAR2);
268
269
270 END CLN_ACK_PO_PKG;
271