1 PACKAGE RCV_AccEvents_PVT AS
2 /* $Header: RCVVRAES.pls 120.1 2005/08/19 12:44:14 visrivas noship $ */
3
4 -- Start of comments
5 -- API name : Create_ReceivingEvents
6 -- Type : Private
7 -- Function : To seed accounting events for receiving transactions.
8 -- Pre-reqs :
9 -- Parameters :
10 -- IN : p_api_version IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2 Optional
12 -- Default = FND_API.G_FALSE
13 -- p_commit IN VARCHAR2 Optional
14 -- Default = FND_API.G_FALSE
15 -- p_validation_level IN NUMBER Optional
16 -- Default = FND_API.G_VALID_LEVEL_FULL
17 -- p_rcv_transaction_id IN NUMBER Required
18 -- p_direct_delivery_flag IN VARCHAR2 Optional
19 -- Default = FND_API.G_FALSE
20 --
21 -- OUT : x_return_status OUT VARCHAR2(1)
22 -- x_msg_count OUT NUMBER
23 -- x_msg_data OUT VARCHAR2(2000)
24 -- Version :
25 -- Initial version 1.0
26 --
27 -- Notes : This API creates all accounting events for receiving transactions
28 -- in RCV_ACCOUNTING_EVENTS. For online accruals, it also generates
29 -- the accounting entries for the event.
30 --
31 -- End of comments
32 -------------------------------------------------------------------------------
33 PROCEDURE Create_ReceivingEvents(
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36 p_commit IN VARCHAR2 := FND_API.G_FALSE,
37 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2,
41
42 p_rcv_transaction_id IN NUMBER,
43 p_direct_delivery_flag IN VARCHAR2 := FND_API.G_FALSE
44 );
45
46 -- Start of comments
47 -- API name : Create_AdjustEvents
48 -- Type : Private
49 -- Function : To seed accounting events for retroactive price adjustments.
50 -- Pre-reqs :
51 -- Parameters :
52 -- IN : p_api_version IN NUMBER Required
53 -- p_init_msg_list IN VARCHAR2 Optional
54 -- Default = FND_API.G_FALSE
55 -- p_commit IN VARCHAR2 Optional
56 -- Default = FND_API.G_FALSE
57 -- p_validation_level IN NUMBER Optional
58 -- Default = FND_API.G_VALID_LEVEL_FULL
59 -- p_po_header_id IN NUMBER Required
60 -- p_po_release_id IN NUMBER Optional
61 -- p_po_line_id IN NUMBER Optional
62 -- p_po_line_location_id IN NUMBER Required
63 -- p_old_po_price IN NUMBER Required
64 -- p_new_po_price IN NUMBER Required
65 --
66 -- OUT : x_return_status OUT VARCHAR2(1)
67 -- x_msg_count OUT NUMBER
68 -- x_msg_data OUT VARCHAR2(2000)
69 -- Version :
70 -- Initial version 1.0
71 --
72 -- Notes : This API creates all accounting events for retroactive price adjustments
73 -- in RCV_ACCOUNTING_EVENTS. For online accruals, it also generates
74 -- the accounting entries for the event.
75 --
76 -- End of comments
77 -------------------------------------------------------------------------------
78 PROCEDURE Create_AdjustEvents(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81 p_commit IN VARCHAR2 := FND_API.G_FALSE,
82 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86
87 p_po_header_id IN NUMBER,
88 p_po_release_id IN NUMBER,
89 p_po_line_id IN NUMBER DEFAULT NULL,
90 p_po_line_location_id IN NUMBER,
91 p_old_po_price IN NUMBER,
92 p_new_po_price IN NUMBER
93
94 );
95
96 -- Start of comments
97 -- API name : Create_ICEvents
98 -- Type : Private
99 -- Function : To seed Intercompany events for period end AP line matches.
100 -- Pre-reqs :
101 -- Parameters :
102 -- IN : p_api_version IN NUMBER Required
103 -- p_init_msg_list IN VARCHAR2 Optional
104 -- Default = FND_API.G_FALSE
105 -- p_commit IN VARCHAR2 Optional
106 -- Default = FND_API.G_FALSE
107 -- p_validation_level IN NUMBER Optional
108 -- Default = FND_API.G_VALID_LEVEL_FULL
109 -- p_invoice_distribution_id IN NUMBER Required
110 --
111 -- OUT : x_return_status OUT VARCHAR2(1)
112 -- x_msg_count OUT NUMBER
113 -- x_msg_data OUT VARCHAR2(2000)
114 -- Version :
115 -- Initial version 1.0
116 --
117 -- Notes : This API creates inter-company accounting events for
118 -- global procurement scenarios with period-end accruals.
119 --
120 -- End of comments
121 -------------------------------------------------------------------------------
122 PROCEDURE Create_ICEvents(
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125 p_commit IN VARCHAR2 := FND_API.G_FALSE,
126 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130
131 p_invoice_distribution_id IN NUMBER
132 );
133
134 -- Start of comments
135 -- API name : Create_ReceiveEvents
136 -- Type : Private
137 -- Function : To seed accounting events for RECEIVE transactions.
138 -- Pre-reqs :
139 -- Parameters :
140 -- IN : p_api_version IN NUMBER Required
141 -- p_init_msg_list IN VARCHAR2 Optional
142 -- Default = FND_API.G_FALSE
143 -- p_commit IN VARCHAR2 Optional
144 -- Default = FND_API.G_FALSE
145 -- p_validation_level IN NUMBER Optional
146 -- Default = FND_API.G_VALID_LEVEL_FULL
147 -- p_rcv_transaction_id IN NUMBER Required
148 -- p_direct_delivery_flag IN VARCHAR2 Required
149 --
150 -- OUT : x_return_status OUT VARCHAR2(1)
151 -- x_msg_count OUT NUMBER
152 -- x_msg_data OUT VARCHAR2(2000)
153 -- Version :
154 -- Initial version 1.0
155 --
156 -- Notes : This API creates all accounting events for RECEIVE
157 -- transactions in RCV_ACCOUNTING_EVENTS.
158 --
159 -- End of comments
160 -------------------------------------------------------------------------------
161 PROCEDURE Create_ReceiveEvents(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164 p_commit IN VARCHAR2 := FND_API.G_FALSE,
165 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169
170 p_rcv_transaction_id IN NUMBER,
171 p_direct_delivery_flag IN VARCHAR2 := FND_API.G_FALSE
172 );
173
174 -- Start of comments
175 -- API name : Create_DeliverEvents
176 -- Type : Private
177 -- Function : To seed accounting events for DELIVER transactions.
178 -- Pre-reqs :
179 -- Parameters :
180 -- IN : p_api_version IN NUMBER Required
181 -- p_init_msg_list IN VARCHAR2 Optional
182 -- Default = FND_API.G_FALSE
183 -- p_commit IN VARCHAR2 Optional
184 -- Default = FND_API.G_FALSE
185 -- p_validation_level IN NUMBER Optional
186 -- Default = FND_API.G_VALID_LEVEL_FULL
187 -- p_rcv_transaction_id IN NUMBER Required
188 -- p_direct_delivery_flag IN VARCHAR2 Required
189 --
190 -- OUT : x_return_status OUT VARCHAR2(1)
191 -- x_msg_count OUT NUMBER
192 -- x_msg_data OUT VARCHAR2(2000)
193 -- Version :
194 -- Initial version 1.0
195 --
196 --
197 -- Notes : This API creates all accounting events for DELIVER
198 -- transactions in RCV_ACCOUNTING_EVENTS.
199 --
200 -- End of comments
201 -------------------------------------------------------------------------------
202 PROCEDURE Create_DeliverEvents(
203 p_api_version IN NUMBER,
204 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205 p_commit IN VARCHAR2 := FND_API.G_FALSE,
206 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2,
210
211 p_rcv_transaction_id IN NUMBER,
212 p_direct_delivery_flag IN VARCHAR2 := FND_API.G_FALSE
213 );
214
215 -- Start of comments
216 -- API name : Create_RTREvents
217 -- Type : Private
218 -- Function : To seed accounting events for RETURN TO RECEIVING transactions.
219 -- Pre-reqs :
220 -- Parameters :
221 -- IN : p_api_version IN NUMBER Required
222 -- p_init_msg_list IN VARCHAR2 Optional
223 -- Default = FND_API.G_FALSE
224 -- p_commit IN VARCHAR2 Optional
225 -- Default = FND_API.G_FALSE
226 -- p_validation_level IN NUMBER Optional
227 -- Default = FND_API.G_VALID_LEVEL_FULL
228 -- p_rcv_transaction_id IN NUMBER Required
229 -- p_direct_delivery_flag IN VARCHAR2 Required
230 --
231 -- OUT : x_return_status OUT VARCHAR2(1)
232 -- x_msg_count OUT NUMBER
233 -- x_msg_data OUT VARCHAR2(2000)
234 -- Version :
235 -- Initial version 1.0
236 --
237 --
238 -- Notes : This API creates all accounting events for RETURN TO RECEIVING
239 -- transactions in RCV_ACCOUNTING_EVENTS.
240 --
241 -- End of comments
242 PROCEDURE Create_RTREvents(
243 p_api_version IN NUMBER,
244 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245 p_commit IN VARCHAR2 := FND_API.G_FALSE,
246 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
247 x_return_status OUT NOCOPY VARCHAR2,
248 x_msg_count OUT NOCOPY NUMBER,
249 x_msg_data OUT NOCOPY VARCHAR2,
250
251 p_rcv_transaction_id IN NUMBER,
252 p_direct_delivery_flag IN VARCHAR2 := FND_API.G_FALSE
253 );
254
255 -- Start of comments
256 -- API name : Create_RTVEvents
257 -- Type : Private
258 -- Function : To seed accounting events for RETURN TO VENDOR transactions.
259 -- Pre-reqs :
260 -- Parameters :
261 -- IN : p_api_version IN NUMBER Required
262 -- p_init_msg_list IN VARCHAR2 Optional
263 -- Default = FND_API.G_FALSE
264 -- p_commit IN VARCHAR2 Optional
265 -- Default = FND_API.G_FALSE
266 -- p_validation_level IN NUMBER Optional
267 -- Default = FND_API.G_VALID_LEVEL_FULL
268 -- p_rcv_transaction_id IN NUMBER Required
269 -- p_direct_delivery_flag IN VARCHAR2 Required
270 --
271 -- OUT : x_return_status OUT VARCHAR2(1)
272 -- x_msg_count OUT NUMBER
273 -- x_msg_data OUT VARCHAR2(2000)
274 -- Version :
275 -- Initial version 1.0
276 --
277 --
278 -- Notes : This API creates all accounting events for RETURN TO VENDOR
279 -- transactions in RCV_ACCOUNTING_EVENTS.
280 --
281 -- End of comments
282 PROCEDURE Create_RTVEvents(
283 p_api_version IN NUMBER,
284 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
285 p_commit IN VARCHAR2 := FND_API.G_FALSE,
286 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
287 x_return_status OUT NOCOPY VARCHAR2,
288 x_msg_count OUT NOCOPY NUMBER,
289 x_msg_data OUT NOCOPY VARCHAR2,
290
291 p_rcv_transaction_id IN NUMBER,
292 p_direct_delivery_flag IN VARCHAR2 := FND_API.G_FALSE
293 );
294
295 -- Start of comments
296 -- API name : Get_InvTransactionInfo
297 -- Type : Private
298 -- Pre-reqs :
299 -- Function : To return the transfer price and distribution account in
300 -- global procurement and drop shipment scenarios.
301 -- Parameters :
302 -- IN : p_api_version IN NUMBER Required
303 -- p_init_msg_list IN VARCHAR2 Optional
304 -- Default = FND_API.G_FALSE
305 -- p_commit IN VARCHAR2 Optional
306 -- Default = FND_API.G_FALSE
307 -- p_validation_level IN NUMBER Optional
308 -- Default = FND_API.G_VALID_LEVEL_FULL
309 -- p_rcv_transaction_id IN NUMBER Required
310 --
311 -- OUT : x_return_status OUT VARCHAR2(1)
312 -- x_msg_count OUT NUMBER
313 -- x_msg_data OUT VARCHAR2(2000)
314 -- x_intercompany_pricing_option OUT BOOLEAN
315 -- x_currency_code OUT VARCHAR2
316 -- x_currency_conversion_rate OUT NUMBER
317 -- x_currency_conversion_date OUT DATE
318 -- x_currency_conversion_type OUT VARCHAR2(30)
319 -- x_distribution_acct_id OUT NUMBER
320 -- Version :
321 -- Initial version 1.0
322 --
323 -- Notes :
324 -- This API is called by the receiving transaction processor for Deliver, RTR
325 -- and Corrections to Deliver/RTR transactions, to determine if the price to be
326 -- stamped on MMTT is the PO price or the transfer price. This API returns a
327 -- flag to indicate if transfer price is to be used. If this flag is set to 'Y',
328 -- the transfer price and the corresponding currency code are returned. The
329 -- transfer price is returned in the transaction UOM.
330 -- If the returned transfer price flag is 'N', the Receiving transaction
331 -- Processor should stamp the PO price as usual.
332 --
333 -- This API also returns the distribution account for External Drop Shipments
334 -- when the new accounting flag is checked. If the returned distribution account
335 -- is -1, the Receiving transaction processor should stamp the MMTT transaction
336 -- with the Receiving Inspection account as usual.
337 -- Otherwise, it should stamp the returned Clearing Account.
338 --
339 -- End of comments
340 -------------------------------------------------------------------------------
341 PROCEDURE Get_InvTransactionInfo(
342 p_api_version IN NUMBER,
343 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
344 p_commit IN VARCHAR2 := FND_API.G_FALSE,
345 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
346 x_return_status OUT NOCOPY VARCHAR2,
347 x_msg_count OUT NOCOPY NUMBER,
348 x_msg_data OUT NOCOPY VARCHAR2,
349
350 p_rcv_transaction_id IN NUMBER,
351
352 x_intercompany_pricing_option OUT NOCOPY NUMBER,
353 x_transfer_price OUT NOCOPY NUMBER,
354 x_currency_code OUT NOCOPY VARCHAR2,
355 x_currency_conversion_rate OUT NOCOPY NUMBER,
356 x_currency_conversion_date OUT NOCOPY DATE,
357 x_currency_conversion_type OUT NOCOPY VARCHAR2,
358 x_distribution_acct_id OUT NOCOPY NUMBER);
359
360 END RCV_AccEvents_PVT;