1 PACKAGE CLN_PO_SYNC_CAT_PKG AUTHID CURRENT_USER AS
2 /* $Header: CLNPOCSS.pls 115.6 2004/06/30 11:49:29 kkram noship $ */
3 -- Package
4 -- CLN_PO_SYNC_CAT_PKG
5 --
6 -- Purpose
7 -- Specification of package specification: CLN_PO_CATALOG_SYNC.
8 -- This package functions facilitate in Catalog sync operation
9 -- An inbound catalog will result in a Blanket purchase order
10 -- creation or updation
11 --
12 -- History
13 -- Jun-03-2003 Viswanthan Umapathy Created
14
15
16 -- Name
17 -- PROCESS_ORDER_HEADER
18 -- Purpose
19 -- Creates a row in PO_HEADERS_INTERFACE and updates the collaboration
20 -- based on Catalog header details
21 -- Arguments
22 -- Catalog header details
23 -- Notes
24 -- No specific notes
25
26
27
28 PROCEDURE PROCESS_HEADER (
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_data OUT NOCOPY VARCHAR2,
31 x_po_hdr_id OUT NOCOPY NUMBER,
32 x_operation OUT NOCOPY VARCHAR2,
33 p_app_ref_id IN VARCHAR2,
34 p_int_cont_num IN VARCHAR2,
35 p_ctg_sync_id IN VARCHAR2,
36 p_itf_hdr_id IN NUMBER,
37 p_batch_id IN NUMBER,
38 p_doc_type IN VARCHAR2,
39 p_tp_id IN NUMBER,
40 p_tp_site_id IN NUMBER,
41 p_ctg_name IN VARCHAR2,
42 p_eff_date IN DATE,
43 p_exp_date IN DATE,
44 p_currency IN NUMBER);
45
46
47 -- Name
48 -- PROCESS_LINE
49 -- Purpose
50 -- Creates or updates a BPO Line
51 -- By creating a row in PO_LINES_INTERFACE
52 -- Updates the collaboration,
53 -- Based on Catalog line details
54 -- Arguments
55 -- Catalog line header details
56 -- Notes
57 -- No Specific Notes
58
59 PROCEDURE PROCESS_LINE(
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 x_line_num OUT NOCOPY NUMBER,
63 p_operation IN VARCHAR2,
64 p_hdr_id IN NUMBER,
65 p_app_ref_id IN VARCHAR2,
66 p_int_cont_num IN VARCHAR2,
67 p_ctg_name IN VARCHAR2,
68 p_itf_hdr_id IN NUMBER,
69 p_itf_lin_id IN NUMBER,
70 p_vdr_part_num IN VARCHAR2,
71 p_item_desc IN VARCHAR2,
72 p_item IN VARCHAR2,
73 p_item_rev IN VARCHAR2,
74 p_category IN VARCHAR2,
75 p_uom IN VARCHAR2,
76 p_item_min_ord_quan IN VARCHAR2,
77 p_price IN NUMBER,
78 p_price_uom IN VARCHAR2,
79 p_price_currency IN VARCHAR2,
80 p_attribute1 IN VARCHAR2,
81 p_attribute2 IN VARCHAR2,
82 p_attribute3 IN VARCHAR2,
83 p_attribute4 IN VARCHAR2,
84 p_attribute5 IN VARCHAR2,
85 p_attribute6 IN VARCHAR2,
86 p_attribute7 IN VARCHAR2,
87 p_attribute8 IN VARCHAR2,
88 p_attribute9 IN VARCHAR2,
89 p_attribute10 IN VARCHAR2,
90 p_attribute11 IN VARCHAR2,
91 p_attribute12 IN VARCHAR2,
92 p_attribute13 IN VARCHAR2,
93 p_attribute14 IN VARCHAR2,
94 p_attribute15 IN VARCHAR2);
95
96
97 -- Name
98 -- PROCESS_PRICE_BREAKS
99 -- Purpose
100 -- Creates a PRICE BREAK row in PO_LINES_INTERFACE
101 -- based on Catalog line details
102 -- Arguments
103 -- Catalog line details and price break details
104 -- Notes
105 -- No Specific Notes
106
107 -- BUG 3138217 - CURRENCY VALIDATION TO BE DONE ON THE BUY SIDE
108 -- Added parameter x_bpo_cur_updated IN OUT NOCOPY VARCHAR2
109
110 PROCEDURE PROCESS_PRICE_BREAKS(
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 x_bpo_cur_updated IN OUT NOCOPY VARCHAR2,
114 p_app_ref_id IN VARCHAR2,
115 p_int_cont_num IN VARCHAR2,
116 p_ctg_name IN VARCHAR2,
117 p_itf_hdr_id IN NUMBER,
118 p_itf_lin_id IN NUMBER,
119 p_line_num IN NUMBER,
120 p_item IN VARCHAR2,
121 p_item_rev IN VARCHAR2,
122 p_eff_date IN DATE,
123 p_exp_date IN DATE,
124 p_quantity IN NUMBER,
125 p_price IN NUMBER,
126 p_price_uom IN VARCHAR2,
127 p_price_currency IN VARCHAR2);
128
129
130 -- Name
131 -- GET_TRADING_PARTNER_DETAILS
132 -- Purpose
133 -- This procedure returns back the trading partner id
134 -- and trading partner site id based the header id
135 --
136 -- Arguments
137 -- Header ID
138 -- Notes
139 -- No specific notes.
140
141 PROCEDURE GET_TRADING_PARTNER_DETAILS(
142 x_tp_id OUT NOCOPY NUMBER,
143 x_tp_site_id OUT NOCOPY NUMBER,
144 p_tp_header_id IN NUMBER);
145
146
147
148 -- Name
149 -- RAISE_UPDATE_EVENT
150 -- Purpose
151 -- This procedure raises an event to update a collaboration.
152 --
153 -- Arguments
154 --
155 -- Notes
156 -- No specific notes.
157
158 PROCEDURE RAISE_UPDATE_COLLABORATION(
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_ref_id IN VARCHAR2,
162 p_doc_no IN VARCHAR2,
163 p_part_doc_no IN VARCHAR2,
164 p_msg_text IN VARCHAR2,
165 p_status_code IN NUMBER,
166 p_int_ctl_num IN VARCHAR2);
167
168
169
170 -- Name
171 -- RAISE_ADD_MSG_EVENT
172 -- Purpose
173 -- This procedure raises an event to add messages into collaboration history
174 --
175 -- Arguments
176 --
177 -- Notes
178 -- No specific notes.
179
180 PROCEDURE RAISE_ADD_MESSAGE(
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_ictrl_no IN NUMBER,
184 p_ref1 IN VARCHAR2,
185 p_ref2 IN VARCHAR2,
186 p_ref3 IN VARCHAR2,
187 p_ref4 IN VARCHAR2,
188 p_ref5 IN VARCHAR2,
189 p_dtl_msg IN VARCHAR2);
190
191
192 -- Name
193 -- CALL_TAKE_ACTIONS
194 -- Purpose
195 -- Invokes Notification Processor TAKE_ACTIONS according to the parameter.
196 -- Arguments
197 -- Description - Error message if errored out else 'SUCCESS'
198 -- Sales Order Status
199 -- Order Line Closed - YES/NO
200 -- Notes
201 -- No specific notes.
202
203 PROCEDURE CALL_TAKE_ACTIONS(
204 p_itemtype IN VARCHAR2,
205 p_itemkey IN VARCHAR2,
206 p_actid IN NUMBER,
207 p_funcmode IN VARCHAR2,
208 x_resultout IN OUT NOCOPY VARCHAR2);
209
210
211 -- Name
212 -- SET_ITEM_ATTRIBUTES
213 -- Purpose
214 -- Sets the workflow item attributes requires
215 -- Arguments
216 -- Notes
217 -- No specific notes.
218
219 PROCEDURE SET_ITEM_ATTRIBUTES(
220 p_itemtype IN VARCHAR2,
221 p_itemkey IN VARCHAR2,
222 p_actid IN NUMBER,
223 p_funcmode IN VARCHAR2,
224 x_resultout IN OUT NOCOPY VARCHAR2);
225
226 -- Name
227 -- SET_ACTION_CREATE_OR_UPDATE
228 -- Purpose
229 -- Sets the ACTION column of po_heasers_interface to either CREATE or UPDATE
230 -- Arguments
231 -- Notes
232 -- No specific notes.
233
234 PROCEDURE SET_ACTION_CREATE_OR_UPDATE(
235 p_itemtype IN VARCHAR2,
236 p_itemkey IN VARCHAR2,
237 p_actid IN NUMBER,
238 p_funcmode IN VARCHAR2,
239 x_resultout IN OUT NOCOPY VARCHAR2);
240
241
242
243 -- Name
244 -- IS_PROCESSING_ERROR
245 -- Purpose
246 -- Checks if any error has occured and returns the same
247 -- Arguments
248 -- Notes
249 -- No specific notes.
250
251 PROCEDURE IS_PROCESSING_ERROR(
252 p_itemtype IN VARCHAR2,
253 p_itemkey IN VARCHAR2,
254 p_actid IN NUMBER,
255 p_funcmode IN VARCHAR2,
256 x_resultout IN OUT NOCOPY VARCHAR2);
257
258
259 -- Name
260 -- LOG_PO_OI_ERRORS
261 -- Purpose
262 -- Quries PO Open Interface error table and captures the errors
263 -- in collaboration addmessages
264 -- Arguments
265 -- Interface Header ID available as a item attribute
266 -- Notes
267 -- No specific notes.
268
269 PROCEDURE LOG_PO_OI_ERRORS(
270 p_itemtype IN VARCHAR2,
271 p_itemkey IN VARCHAR2,
272 p_actid IN NUMBER,
273 p_funcmode IN VARCHAR2,
274 x_resultout IN OUT NOCOPY VARCHAR2);
275
276 END CLN_PO_SYNC_CAT_PKG;