[Home] [Help]
PACKAGE: APPS.AR_RECEIPT_API_PUB
Source
1 Package AR_RECEIPT_API_PUB AS
2 /* $Header: ARXPRECS.pls 120.28.12010000.3 2008/11/14 13:40:16 pbapna ship $ */
3 /*#
4 * Receipt APIs provide an extension to existing
5 * functionality for creating and manipulating receipts
6 * through standard AR Receipts forms and lockboxes.
7 * @rep:scope public
8 * @rep:metalink 236938.1 See OracleMetaLink note 236938.1
9 * @rep:product AR
10 * @rep:lifecycle active
11 * @rep:displayname Receipt
12 * @rep:category BUSINESS_ENTITY AR_RECEIPT
13 */
14
15 --Start of comments
16 --API name : ReceiptsAPI
17 --Type : Public.
18 --Function : Create , apply, unapply and reverse Receipts
19 --Pre-reqs :
20 --
21 -- Notes : Note text
22 --
23 -- Modification History
24 -- Date Name Description
25 -- 10-19-00 Debbie Jancis Modified for tca uptake. Replaced all
26 -- occurances of ra customer tables with
27 -- their hz counterparts.
28 -- 25-MAR-2002 jbeckett Bug 2270809,2270825 - Additional claim validation
29 -- Added dbdrv commands
30 -- 14-FEB-2003 jbeckett Bug 2571910 - new procedure Apply_Open_Receipt().
31 --
32 -- 03-NOV-2003 Obaidur Rashid
33 --
34 -- Description of changes:
35 -- =======================
36 --
37 -- Changes for the CONSOLIDATE BANK ACCOUNTS project are done in this
38 -- version. List of changes are given below.
39 --
40 -- PLEASE NOTE ONLY SOME OF THESE MAY APPLY TO THIS FILE.
41 --
42 -- 1. References to ap_bank_branches has been changed to ce_bank_branches_v
43 -- where possible.
44 --
45 -- 2. Reference to ap_bank_accounts for internal bank accounts has been
46 -- changed to ce_bank_acct_uses. An additional join may have been added
47 -- to ce_bank_accounts table if the column selected does not appear in
48 -- the uses table.
49 --
50 -- 3. All bank branch/bank account related identifiers declared with %TYPE
51 -- has been appropriately changed to point to the new data model.
52 --
53 -- 4. All local identifiers holding the remittance_bank_account_id has been
54 -- renamed to remit_bank_acct_use_id signifying what it holds now.
55 -- Please note that parameters for subroutines are left alone even though
56 -- they too hold use ids now.
57 --
58 -- 5. Some columns are renamed when mapped in the new data model, so those
59 -- changes are also made.
60 --
61 -- 6. For internal bank account, the Where clause conditions involving
62 -- ap_bank_accounts.set_of_books_id has been omitted as it is now
63 -- redundant and the column set_of_books_id column is obsolete.
64 --
65 -- 02-Feb-2005 Debbie Jancis Added p_customer_reason to activity_application
66 -- for Enh 4145224
67 -- 25-Feb-2005 Added API Create_Apply_On_Acc for forward port bug 3398539
68
69 -- Changes for the PAYMENT UPTAKE PROJECT project are done in this
70 -- version. List of changes are given below.
71 --
72 -- 1.Removed bank_account_id ,bank_branch_id from Customer_Rec
73 --
74 -- 2. Removed customer_bank_account_id,customer_bank_account_num,
75 -- customer_bank_account_name from G_create_cash_rec_type .
76 --
77 -- 3. Replaced customer_bank_account_id,customer_bank_account_num,
78 -- customer_bank_account_name
79 -- with
80 -- p_trxn_extension_id
81 -- In the following packages
82 -- PROCEDURE Create_cash
83 -- PROCEDURE Create_and_apply
84 -- PROCEDURE Create_Apply_On_Acc
85 --
86 -- 02-Jun-2006 LLCA : Added API Apply_In_Detail
87 --=============================================================================
88
89
90 TYPE Receipt_Method_Rec IS RECORD
91 (
92 receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
93 remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE
94 );
95
96 TYPE Customer_Rec IS RECORD
97 (customer_id ar_cash_receipts.pay_from_customer%TYPE,
98 site_use_id ar_cash_receipts.customer_site_use_id%TYPE
99 );
100
101 TYPE attribute_rec_type IS RECORD(
102 attribute_category VARCHAR2(30) DEFAULT NULL,
103 attribute1 VARCHAR2(150) DEFAULT NULL,
104 attribute2 VARCHAR2(150) DEFAULT NULL,
105 attribute3 VARCHAR2(150) DEFAULT NULL,
106 attribute4 VARCHAR2(150) DEFAULT NULL,
107 attribute5 VARCHAR2(150) DEFAULT NULL,
108 attribute6 VARCHAR2(150) DEFAULT NULL,
109 attribute7 VARCHAR2(150) DEFAULT NULL,
110 attribute8 VARCHAR2(150) DEFAULT NULL,
111 attribute9 VARCHAR2(150) DEFAULT NULL,
112 attribute10 VARCHAR2(150) DEFAULT NULL,
113 attribute11 VARCHAR2(150) DEFAULT NULL,
114 attribute12 VARCHAR2(150) DEFAULT NULL,
115 attribute13 VARCHAR2(150) DEFAULT NULL,
116 attribute14 VARCHAR2(150) DEFAULT NULL,
117 attribute15 VARCHAR2(150) DEFAULT NULL);
118
119 TYPE global_attribute_rec_type IS RECORD(
120 global_attribute_category VARCHAR2(30) default null,
121 global_attribute1 VARCHAR2(150) default NULL,
122 global_attribute2 VARCHAR2(150) DEFAULT NULL,
123 global_attribute3 VARCHAR2(150) DEFAULT NULL,
124 global_attribute4 VARCHAR2(150) DEFAULT NULL,
125 global_attribute5 VARCHAR2(150) DEFAULT NULL,
126 global_attribute6 VARCHAR2(150) DEFAULT NULL,
127 global_attribute7 VARCHAR2(150) DEFAULT NULL,
128 global_attribute8 VARCHAR2(150) DEFAULT NULL,
129 global_attribute9 VARCHAR2(150) DEFAULT NULL,
130 global_attribute10 VARCHAR2(150) DEFAULT NULL,
131 global_attribute11 VARCHAR2(150) DEFAULT NULL,
132 global_attribute12 VARCHAR2(150) DEFAULT NULL,
133 global_attribute13 VARCHAR2(150) DEFAULT NULL,
134 global_attribute14 VARCHAR2(150) DEFAULT NULL,
135 global_attribute15 VARCHAR2(150) DEFAULT NULL,
136 global_attribute16 VARCHAR2(150) DEFAULT NULL,
137 global_attribute17 VARCHAR2(150) DEFAULT NULL,
138 global_attribute18 VARCHAR2(150) DEFAULT NULL,
139 global_attribute19 VARCHAR2(150) DEFAULT NULL,
140 global_attribute20 VARCHAR2(150) DEFAULT NULL);
141
142 TYPE global_attribute_rec_type_upd IS RECORD(
143 global_attribute_category VARCHAR2(30) default FND_API.G_MISS_CHAR,
144 global_attribute1 VARCHAR2(150) default FND_API.G_MISS_CHAR,
145 global_attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
146 global_attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
147 global_attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
148 global_attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
149 global_attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
150 global_attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
151 global_attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
152 global_attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
153 global_attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
154 global_attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
155 global_attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
156 global_attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
157 global_attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
158 global_attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
159 global_attribute16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
160 global_attribute17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
161 global_attribute18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
162 global_attribute19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
163 global_attribute20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR);
164
165 TYPE apply_out_rec_type IS RECORD
166 (receivable_application_id ar_receivable_applications.receivable_application_id%TYPE
167 );
168 attribute_rec_const attribute_rec_type;
169 global_attribute_rec_const global_attribute_rec_type;
170
171 global_attribute_rec_upd_cons global_attribute_rec_type_upd;
172 apply_out_rec apply_out_rec_type;
173
174 --Bug 3628401
175 TYPE apply_on_account_rec_type IS RECORD
176 (receivable_application_id ar_receivable_applications.receivable_application_id%TYPE
177 );
178 g_apply_on_account_out_rec apply_on_account_rec_type;
179
180
181 TYPE Rec_Method_Tbl_Type IS TABLE OF Receipt_Method_Rec
182 INDEX BY BINARY_INTEGER;
183
184 TYPE Rec_Customer_Tbl_Type IS TABLE OF Customer_Rec
185 INDEX BY BINARY_INTEGER;
186 TYPE G_application_rec_type IS RECORD
187 ( cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
188 receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
189 customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
190 trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL,
191 installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
192 applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
193 customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
194 line_number ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
195 amount_applied_from ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
196 trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL
197 );
198 TYPE G_create_cash_rec_type IS RECORD
199 ( customer_id hz_cust_accounts.cust_account_id%TYPE,
200 customer_name hz_parties.party_name%TYPE,
201 customer_number hz_cust_accounts.account_number%TYPE,
202 cust_site_use_id hz_cust_site_uses.site_use_id%TYPE,
203 location hz_cust_site_uses.location%TYPE,
204 /* 6612301 */
205 customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,
206 customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE,
207 customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE,
208 remit_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
209 remittance_bank_account_num ce_bank_accounts.bank_account_name%TYPE,
210 remittance_bank_account_name ce_bank_accounts.bank_account_num%TYPE,
211 receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
212 receipt_method_name ar_receipt_methods.name%TYPE
213 );
214 TYPE G_unapp_rec_type IS RECORD
215 (trx_number ra_customer_trx.trx_number%TYPE,
216 customer_trx_id ar_receivable_applications.customer_trx_id%TYPE,
217 applied_ps_id ar_receivable_applications.applied_payment_schedule_id%TYPE,
218 cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
219 receipt_number ar_cash_receipts.receipt_number%TYPE,
220 receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
221 TYPE G_unapp_on_ac_rec IS RECORD
222 (cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
223 receipt_number ar_cash_receipts.receipt_number%TYPE,
224 receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
225 TYPE G_activity_unapp_rec IS RECORD
226 (cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
227 receipt_number ar_cash_receipts.receipt_number%TYPE,
228 receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
229
230 Original_create_cash_info G_create_cash_rec_type;
231 Original_application_info G_application_rec_type;
232 Original_unapp_info G_unapp_rec_type;
233 Original_unapp_onac_info G_unapp_on_ac_rec;
234 Original_activity_unapp_info G_activity_unapp_rec;
235
236 TYPE llca_trx_lines_rec_type IS RECORD (
237 customer_trx_line_id NUMBER DEFAULT NULL,
238 line_number NUMBER DEFAULT NULL,
239 line_amount NUMBER DEFAULT NULL,
240 tax_amount NUMBER DEFAULT NULL,
241 amount_applied NUMBER DEFAULT NULL,
242 amount_applied_from NUMBER DEFAULT NULL,
243 line_discount NUMBER DEFAULT NULL,
244 tax_discount NUMBER DEFAULT NULL,
245 attribute_category VARCHAR2(30) DEFAULT NULL,
246 attribute1 VARCHAR2(150) DEFAULT NULL,
247 attribute2 VARCHAR2(150) DEFAULT NULL,
248 attribute3 VARCHAR2(150) DEFAULT NULL,
249 attribute4 VARCHAR2(150) DEFAULT NULL,
250 attribute5 VARCHAR2(150) DEFAULT NULL,
251 attribute6 VARCHAR2(150) DEFAULT NULL,
252 attribute7 VARCHAR2(150) DEFAULT NULL,
253 attribute8 VARCHAR2(150) DEFAULT NULL,
254 attribute9 VARCHAR2(150) DEFAULT NULL,
255 attribute10 VARCHAR2(150) DEFAULT NULL,
256 attribute11 VARCHAR2(150) DEFAULT NULL,
257 attribute12 VARCHAR2(150) DEFAULT NULL,
258 attribute13 VARCHAR2(150) DEFAULT NULL,
259 attribute14 VARCHAR2(150) DEFAULT NULL,
260 attribute15 VARCHAR2(150) DEFAULT NULL
261 );
262
263 TYPE llca_trx_lines_tbl_type IS TABLE OF llca_trx_lines_rec_type
264 INDEX BY BINARY_INTEGER;
265
266 llca_def_trx_lines_tbl_type llca_trx_lines_tbl_type;
267
268 /*
269 Use this procedure to create a single cash receipt for
270 * payment received in the form of a check or cash.
271 * manually created cash receipts.
272 * @rep:scope public
273 * @rep:lifecycle active
274 * @rep:displayname Create Cash Receipt
275 */
276
277 PROCEDURE Create_cash(
278 -- Standard API parameters.
279 p_api_version IN NUMBER,
280 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281 p_commit IN VARCHAR2 := FND_API.G_FALSE,
282 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
283 x_return_status OUT NOCOPY VARCHAR2,
284 x_msg_count OUT NOCOPY NUMBER,
285 x_msg_data OUT NOCOPY VARCHAR2,
286 -- Receipt info. parameters
287 p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
288 p_currency_code IN VARCHAR2 DEFAULT NULL,
289 p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
290 p_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
291 p_exchange_rate IN NUMBER DEFAULT NULL,
292 p_exchange_rate_date IN DATE DEFAULT NULL,
293 p_amount IN NUMBER DEFAULT NULL,
294 p_factor_discount_amount IN NUMBER DEFAULT NULL,
295 p_receipt_number IN VARCHAR2 DEFAULT NULL,
296 p_receipt_date IN DATE DEFAULT NULL,
297 p_gl_date IN DATE DEFAULT NULL,
298 p_maturity_date IN DATE DEFAULT NULL,
299 p_postmark_date IN DATE DEFAULT NULL,
300 p_customer_id IN NUMBER DEFAULT NULL,
301 p_customer_name IN VARCHAR2 DEFAULT NULL,
302 p_customer_number IN VARCHAR2 DEFAULT NULL,
303 p_customer_bank_account_id IN NUMBER DEFAULT NULL,
304 p_customer_bank_account_num IN VARCHAR2 DEFAULT NULL,
305 p_customer_bank_account_name IN VARCHAR2 DEFAULT NULL,
306 p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, --payment uptake changes bichatte
307 p_location IN VARCHAR2 DEFAULT NULL,
308 p_customer_site_use_id IN NUMBER DEFAULT NULL,
309 p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug4448307-4509459
310 p_customer_receipt_reference IN VARCHAR2 DEFAULT NULL,
311 p_override_remit_account_flag IN VARCHAR2 DEFAULT NULL,
312 p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
313 p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
314 p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
315 p_deposit_date IN DATE DEFAULT NULL,
316 p_receipt_method_id IN NUMBER DEFAULT NULL,
317 p_receipt_method_name IN VARCHAR2 DEFAULT NULL,
318 p_doc_sequence_value IN NUMBER DEFAULT NULL,
319 p_ussgl_transaction_code IN VARCHAR2 DEFAULT NULL,
320 p_anticipated_clearing_date IN DATE DEFAULT NULL,
321 p_called_from IN VARCHAR2 DEFAULT NULL,
322 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
323 -- ******* Global Flexfield parameters *******
324 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
325 p_comments IN VARCHAR2 DEFAULT NULL,
326 -- *** Notes Receivable Additional Information ***
327 p_issuer_name IN VARCHAR2 DEFAULT NULL,
328 p_issue_date IN DATE DEFAULT NULL,
329 p_issuer_bank_branch_id IN NUMBER DEFAULT NULL,
330 p_org_id IN NUMBER DEFAULT NULL,
331 p_installment IN NUMBER DEFAULT NULL,
332 -- ** OUT NOCOPY variables
333 p_cr_id OUT NOCOPY NUMBER
334 );
335
336 /*#
337 * Use this procedure to apply the cash receipts from a customer
338 * to an invoice, debit memo, or other debit item.
339 * @rep:scope public
340 * @rep:lifecycle active
341 * @rep:displayname Apply Receipt
342 */
343
344 PROCEDURE Apply(
345 -- Standard API parameters.
346 p_api_version IN NUMBER,
347 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
348 p_commit IN VARCHAR2 := FND_API.G_FALSE,
349 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350 x_return_status OUT NOCOPY VARCHAR2,
351 x_msg_count OUT NOCOPY NUMBER,
352 x_msg_data OUT NOCOPY VARCHAR2,
353 -- Receipt application parameters.
354 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
355 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
356 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
357 p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
358 p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
359 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
360 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
361 -- this is the allocated receipt amount
362 p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
363 p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
364 p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
365 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
366 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
367 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
368 p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
369 p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
370 p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
371 p_called_from IN VARCHAR2 DEFAULT NULL,
372 p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
373 p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
374 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
375 -- ******* Global Flexfield parameters *******
376 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
377 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
378 p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
379 p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
380 p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
381 p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
382 p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
383 p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
384 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
385 p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
386 p_org_id IN NUMBER DEFAULT NULL
387 );
388
389 -- LLCA
390 PROCEDURE Apply_In_Detail(
391 -- Standard API parameters.
392 p_api_version IN NUMBER,
393 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
394 p_commit IN VARCHAR2 := FND_API.G_FALSE,
395 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
396 x_return_status OUT NOCOPY VARCHAR2,
397 x_msg_count OUT NOCOPY NUMBER,
398 x_msg_data OUT NOCOPY VARCHAR2,
399 -- Receipt application parameters.
400 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
401 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
402 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
403 p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
404 p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
405 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
406 -- LLCA Parameters
407 p_llca_type IN VARCHAR2 DEFAULT 'S',
408 p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,
409 p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */
410 p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
411 p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
412 p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
413 p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
414 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
415 p_line_discount IN NUMBER DEFAULT NULL,
416 p_tax_discount IN NUMBER DEFAULT NULL,
417 p_freight_discount IN NUMBER DEFAULT NULL,
418 -- this is the allocated receipt amount
419 p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
420 p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
421 p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
422 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
423 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
424 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
425 p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
426 p_called_from IN VARCHAR2 DEFAULT NULL,
427 p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
428 p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
429 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
430 -- ******* Global Flexfield parameters *******
431 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
432 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
433 p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
434 p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
435 p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
436 p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
437 p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
438 p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
439 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
440 p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
441 p_org_id IN NUMBER DEFAULT NULL,
442 p_line_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const
443 );
444
445 /*#
446 * Use this procedure to unapply a cash receipt application against
447 * a specified installment of a debit item or payment schedule ID.
448 * @rep:scope public
449 * @rep:lifecycle active
450 * @rep:displayname Unapply Receipt
451 */
452
453 PROCEDURE Unapply(
454 -- Standard API parameters.
455 p_api_version IN NUMBER,
456 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
457 p_commit IN VARCHAR2 := FND_API.G_FALSE,
458 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
459 x_return_status OUT NOCOPY VARCHAR2 ,
460 x_msg_count OUT NOCOPY NUMBER ,
461 x_msg_data OUT NOCOPY VARCHAR2 ,
462 -- *** Receipt Info. parameters *****
463 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
464 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
465 p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
466 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
467 p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
468 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
469 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
470 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
471 p_called_from IN VARCHAR2 DEFAULT NULL,
472 p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
473 p_org_id IN NUMBER DEFAULT NULL
474 );
475
476 /*#
477 * Use this procedure to create a cash receipt and apply it
478 * to a specified installment of a debit item.
479 * @rep:scope public
480 * @rep:lifecycle active
481 * @rep:displayname Create and Apply Receipt
482 */
483
484
485 PROCEDURE Create_and_apply(
486 -- Standard API parameters.
487 p_api_version IN NUMBER,
488 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
489 p_commit IN VARCHAR2 := FND_API.G_FALSE,
490 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
491 x_return_status OUT NOCOPY VARCHAR2,
492 x_msg_count OUT NOCOPY NUMBER,
493 x_msg_data OUT NOCOPY VARCHAR2,
494 -- Receipt info. parameters
495 p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
496 p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
497 p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
498 p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
499 p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
500 p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
501 p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
502 p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
503 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
504 p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
505 p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
506 p_maturity_date IN DATE DEFAULT NULL,
507 p_postmark_date IN DATE DEFAULT NULL,
508 p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
509 p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
510 p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
511 p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
512 /* 6612301 */
513 p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL,
514 p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE DEFAULT NULL,
515 p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, --payment uptake changes bichatte
516 p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
517 p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
518 p_default_site_use IN VARCHAR2 DEFAULT 'Y', --The default site use bug4448307-4509459.
519 p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
520 p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
521 p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
522 p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
523 p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
524 p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
525 p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
526 p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
527 p_doc_sequence_value IN NUMBER DEFAULT NULL,
528 p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
529 p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
530 p_called_from IN VARCHAR2 DEFAULT NULL,
531 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
532 -- ******* Global Flexfield parameters *******
533 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
534 p_receipt_comments IN VARCHAR2 DEFAULT NULL,
535 -- *** Notes Receivable Additional Information ***
536 p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
537 p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
538 p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
539 -- ** OUT NOCOPY variables for Creating receipt
540 p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
541 -- Receipt application parameters
542 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
543 p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
544 p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
545 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
546 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
547 -- this is the allocated receipt amount
548 p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
549 p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
550 p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
551 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
552 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
553 app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
554 p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
555 p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
556 p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
557 p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
558 p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
559 app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
560 -- ******* Global Flexfield parameters *******
561 app_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
562 app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
563 -- OSTEINME 3/9/2001: added flag that indicates whether to call payment
564 -- processor such as iPayments
565 p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE,
566 p_org_id IN NUMBER DEFAULT NULL
567 -- OUT NOCOPY parameter for the Application
568 );
569
570 /*#
571 * Use this procedure to reverse cash and miscellaneous receipts.
572 * @rep:scope public
573 * @rep:lifecycle active
574 * @rep:displayname Reverse Receipt
575 */
576
577
578 PROCEDURE Reverse(
579 -- Standard API parameters.
580 p_api_version IN NUMBER,
581 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
582 p_commit IN VARCHAR2 := FND_API.G_FALSE,
583 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
584 x_return_status OUT NOCOPY VARCHAR2,
585 x_msg_count OUT NOCOPY NUMBER,
586 x_msg_data OUT NOCOPY VARCHAR2,
587 -- Receipt reversal related parameters
588 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
589 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
590 p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
591 p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
592 p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
593 p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
594 p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
595 p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
596 p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
597 p_called_from IN VARCHAR2 DEFAULT NULL,
598 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
599 --p_global_attribute_rec IN global_attribute_rec_type_upd DEFAULT global_attribute_rec_upd_cons
600 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const ,
601 p_cancel_claims_flag IN VARCHAR2 DEFAULT 'Y',
602 p_org_id IN NUMBER DEFAULT NULL
603 );
604
605 /*#
606 * Use this procedure to apply a cash receipt on account.
607 * @rep:scope public
608 * @rep:lifecycle active
609 * @rep:displayname Apply On-Account Receipt
610 */
611
612
613 PROCEDURE Apply_on_account(
614 -- Standard API parameters.
615 p_api_version IN NUMBER,
616 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
617 p_commit IN VARCHAR2 := FND_API.G_FALSE,
618 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
619 x_return_status OUT NOCOPY VARCHAR2,
620 x_msg_count OUT NOCOPY NUMBER,
621 x_msg_data OUT NOCOPY VARCHAR2,
622 -- Receipt application parameters.
623 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
624 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
625 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
626 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
627 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
628 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
629 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
630 -- ******* Global Flexfield parameters *******
631 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
632 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
633 p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
634 p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
635 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
636 p_called_from IN VARCHAR2 DEFAULT NULL,
637 p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
638 p_secondary_app_ref_type IN
639 ar_receivable_applications.secondary_application_ref_type%TYPE := null,
640 p_secondary_app_ref_num IN
641 ar_receivable_applications.secondary_application_ref_num%TYPE := null,
642 p_org_id IN NUMBER DEFAULT NULL
643 );
644
645 /*#
646 * Use this procedure to unapply an on-account application of
647 * a specified cash receipt.
648 * @rep:scope public
649 * @rep:lifecycle active
650 * @rep:displayname Unapply On-Account Receipt
651 */
652
653
654 PROCEDURE Unapply_on_account(
655 -- Standard API parameters.
656 p_api_version IN NUMBER,
657 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
658 p_commit IN VARCHAR2 := FND_API.G_FALSE,
659 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
660 x_return_status OUT NOCOPY VARCHAR2 ,
661 x_msg_count OUT NOCOPY NUMBER ,
662 x_msg_data OUT NOCOPY VARCHAR2 ,
663 -- *** Receipt Info. parameters *****
664 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
665 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
666 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
667 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
668 p_org_id IN NUMBER DEFAULT NULL
669 );
670
671 /*#
672 * Use this procedure to create an activity application on a cash receipt,
673 * including Short Term Debit (STD) and Receipt Write-off applications.
674 * @rep:scope public
675 * @rep:lifecycle active
676 * @rep:displayname Receipt Activity Application
677 */
678
679
680 PROCEDURE Activity_application(
681 -- Standard API parameters.
682 p_api_version IN NUMBER,
683 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
684 p_commit IN VARCHAR2 := FND_API.G_FALSE,
685 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
686 x_return_status OUT NOCOPY VARCHAR2,
687 x_msg_count OUT NOCOPY NUMBER,
688 x_msg_data OUT NOCOPY VARCHAR2,
689 -- Receipt application parameters.
690 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
691 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
692 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
693 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
694 p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
695 p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
696 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
697 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
698 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
699 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
700 -- ******* Global Flexfield parameters *******
701 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
702 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
703 p_application_ref_type IN OUT NOCOPY
704 ar_receivable_applications.application_ref_type%TYPE,
705 p_application_ref_id IN OUT NOCOPY
706 ar_receivable_applications.application_ref_id%TYPE,
707 p_application_ref_num IN OUT NOCOPY
708 ar_receivable_applications.application_ref_num%TYPE,
709 p_secondary_application_ref_id IN OUT NOCOPY
710 ar_receivable_applications.secondary_application_ref_id%TYPE,
711 p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
712 p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
713 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
714 p_val_writeoff_limits_flag IN VARCHAR2 DEFAULT 'Y',
715 p_called_from IN VARCHAR2 DEFAULT NULL,
716 p_netted_receipt_flag IN VARCHAR2 DEFAULT NULL,
717 p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
718 p_secondary_app_ref_type IN
719 ar_receivable_applications.secondary_application_ref_type%TYPE := null,
720 p_secondary_app_ref_num IN
721 ar_receivable_applications.secondary_application_ref_num%TYPE := null,
722 p_org_id IN NUMBER DEFAULT NULL,
723 p_customer_reason IN
724 ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
725 ,p_pay_group_lookup_code IN FND_LOOKUPS.lookup_code%TYPE DEFAULT NULL
726 ,p_pay_alone_flag IN VARCHAR2 DEFAULT NULL
727 ,p_payment_method_code IN ap_invoices.payment_method_code%TYPE DEFAULT NULL
728 ,p_payment_reason_code IN ap_invoices.payment_reason_code%TYPE DEFAULT NULL
729 ,p_payment_reason_comments IN ap_invoices.payment_reason_comments%TYPE DEFAULT NULL
730 ,p_delivery_channel_code IN ap_invoices.delivery_channel_code%TYPE DEFAULT NULL
731 ,p_remittance_message1 IN ap_invoices.remittance_message1%TYPE DEFAULT NULL
732 ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE DEFAULT NULL
733 ,p_remittance_message3 IN ap_invoices.remittance_message3%TYPE DEFAULT NULL
734 ,p_party_id IN hz_parties.party_id%TYPE DEFAULT NULL
735 ,p_party_site_id IN hz_party_sites.party_site_id%TYPE DEFAULT NULL
736 ,p_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL
737 );
738
739 /*#
740 * Use this procedure to create a reversal of an activity application
741 * on a cash receipt including Short Term Debt and Receipt write-off.
742 * @rep:scope public
743 * @rep:lifecycle active
744 * @rep:displayname Receipt Activity Unapplication
745 */
746
747 PROCEDURE Activity_unapplication(
748 -- Standard API parameters.
749 p_api_version IN NUMBER,
750 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
751 p_commit IN VARCHAR2 := FND_API.G_FALSE,
752 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
753 x_return_status OUT NOCOPY VARCHAR2 ,
754 x_msg_count OUT NOCOPY NUMBER ,
755 x_msg_data OUT NOCOPY VARCHAR2 ,
756 -- *** Receipt Info. parameters *****
757 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
758 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
759 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
760 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
761 p_called_from IN VARCHAR2,
762 p_org_id IN NUMBER DEFAULT NULL
763 );
764
765 /*#
766 * Use this procedure to apply a cash receipt to other account activities,
767 * such as creating a claim investigation application with a
768 * noninvoice-related deduction or overpayment in Trade Management (if installed).
769 * @rep:scope public
770 * @rep:lifecycle active
771 * @rep:displayname Account Application on a Cash Receipt
772 */
773
774
775 PROCEDURE Apply_other_account(
776 -- Standard API parameters.
777 p_api_version IN NUMBER,
778 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
779 p_commit IN VARCHAR2 := FND_API.G_FALSE,
780 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
781 x_return_status OUT NOCOPY VARCHAR2,
782 x_msg_count OUT NOCOPY NUMBER,
783 x_msg_data OUT NOCOPY VARCHAR2,
784 p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
785 -- Receipt application parameters.
786 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
787 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
788 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
789 p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
790 p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
791 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
792 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
793 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
794 p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
795 p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
796 p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
797 p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
798 p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
799 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
800 -- ******* Global Flexfield parameters *******
801 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
802 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
803 p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
804 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
805 p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
806 p_called_from IN VARCHAR2 DEFAULT NULL,
807 p_org_id IN NUMBER DEFAULT NULL
808 );
809
810 /*#
811 * Use this procedure to reverse a cash receipt to other account activity.
812 * @rep:scope public
813 * @rep:lifecycle active
814 * @rep:displayname Reversal of an Account Application
815 */
816
817
818 PROCEDURE Unapply_other_account(
819 -- Standard API parameters.
820 p_api_version IN NUMBER,
821 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
822 p_commit IN VARCHAR2 := FND_API.G_FALSE,
823 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
824 x_return_status OUT NOCOPY VARCHAR2 ,
825 x_msg_count OUT NOCOPY NUMBER ,
826 x_msg_data OUT NOCOPY VARCHAR2 ,
827 -- *** Receipt Info. parameters *****
828 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
829 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
830 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
831 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
832 p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
833 p_called_from IN VARCHAR2 DEFAULT NULL,
834 p_org_id IN NUMBER DEFAULT NULL
835 );
836
837
838 /*#
839 * Use this procedure to create a miscellaneous receipt.
840 * @rep:scope public
841 * @rep:lifecycle active
842 * @rep:displayname Create Miscellaneous Receipt
843 */
844
845
846 PROCEDURE create_misc(
847 -- Standard API parameters.
848 p_api_version IN NUMBER,
849 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
850 p_commit IN VARCHAR2 := FND_API.G_FALSE,
851 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
852 x_return_status OUT NOCOPY VARCHAR2 ,
853 x_msg_count OUT NOCOPY NUMBER ,
854 x_msg_data OUT NOCOPY VARCHAR2 ,
855 -- Misc Receipt info. parameters
856 p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
857 p_currency_code IN VARCHAR2 DEFAULT NULL,
858 p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
859 p_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
860 p_exchange_rate IN NUMBER DEFAULT NULL,
861 p_exchange_rate_date IN DATE DEFAULT NULL,
862 p_amount IN NUMBER,
863 p_receipt_number IN OUT NOCOPY VARCHAR2,
864 p_receipt_date IN DATE DEFAULT NULL,
865 p_gl_date IN DATE DEFAULT NULL,
866 p_receivables_trx_id IN NUMBER DEFAULT NULL,
867 p_activity IN VARCHAR2 DEFAULT NULL,
868 p_misc_payment_source IN VARCHAR2 DEFAULT NULL,
869 p_tax_code IN VARCHAR2 DEFAULT NULL,
870 p_vat_tax_id IN VARCHAR2 DEFAULT NULL,
871 p_tax_rate IN NUMBER DEFAULT NULL,
872 p_tax_amount IN NUMBER DEFAULT NULL,
873 p_deposit_date IN DATE DEFAULT NULL,
874 p_reference_type IN VARCHAR2 DEFAULT NULL,
875 p_reference_num IN VARCHAR2 DEFAULT NULL,
876 p_reference_id IN NUMBER DEFAULT NULL,
877 p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
878 p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
879 p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
880 p_receipt_method_id IN NUMBER DEFAULT NULL,
881 p_receipt_method_name IN VARCHAR2 DEFAULT NULL,
882 p_doc_sequence_value IN NUMBER DEFAULT NULL,
883 p_ussgl_transaction_code IN VARCHAR2 DEFAULT NULL,
884 p_anticipated_clearing_date IN DATE DEFAULT NULL,
885 p_attribute_record IN attribute_rec_type DEFAULT attribute_rec_const,
886 p_global_attribute_record IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
887 p_comments IN VARCHAR2 DEFAULT NULL,
888 p_org_id IN NUMBER DEFAULT NULL,
889 p_misc_receipt_id OUT NOCOPY NUMBER,
890 p_called_from IN VARCHAR2 DEFAULT NULL,
891 p_payment_trxn_extension_id In ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL); /* Bug fix 3619780*/
892
893
894 Method_Cache_Tbl Rec_Method_Tbl_Type ;
895 Customer_Cache_Tbl Rec_Customer_Tbl_Type;
896
897 PROCEDURE set_profile_for_testing(p_profile_doc_seq VARCHAR2,
898 p_profile_enable_cc VARCHAR2,
899 p_profile_appln_gl_date_def VARCHAR2,
900 p_profile_amt_applied_def VARCHAR2,
901 p_profile_cc_rate_type VARCHAR2,
902 p_profile_dsp_inv_rate VARCHAR2,
903 p_profile_create_bk_charges VARCHAR2,
904 p_profile_def_x_rate_type VARCHAR2,
905 p_pay_unrelated_inv_flag VARCHAR2,
906 p_unearned_discount VARCHAR2);
907
908 /*#
909 * User this procedure to apply a cash receipt to another open receipt.
910 * Open receipts include unapplied cash, on-account cash, and claim investigation applications.
911 * @rep:scope public
912 * @rep:lifecycle active
913 * @rep:displayname Apply Receipt to Another Receipt
914 */
915
916
917 PROCEDURE Apply_Open_Receipt(
918 -- Standard API parameters.
919 p_api_version IN NUMBER,
920 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
921 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
922 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
923 x_return_status OUT NOCOPY VARCHAR2,
924 x_msg_count OUT NOCOPY NUMBER,
925 x_msg_data OUT NOCOPY VARCHAR2,
926 -- Receipt application parameters.
927 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
928 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
929 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
930 p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
931 p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
932 p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
933 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
934 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
935 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
936 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
937 p_called_from IN VARCHAR2 DEFAULT NULL,
938 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
939 -- ******* Global Flexfield parameters *******
940 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
941 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
942 p_org_id IN NUMBER DEFAULT NULL,
943 x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
944 x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
945 x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
946 x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
947 x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
948 );
949
950 /*#
951 * Use this procedure to reverse a payment netting application on a cash receipt.
952 * @rep:scope public
953 * @rep:lifecycle active
954 * @rep:displayname Reverse Application of a Receipt to Another Receipt
955 */
956
957
958 PROCEDURE Unapply_Open_Receipt(
959 -- Standard API parameters.
960 p_api_version IN NUMBER,
961 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
962 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
963 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
964 x_return_status OUT NOCOPY VARCHAR2 ,
965 x_msg_count OUT NOCOPY NUMBER ,
966 x_msg_data OUT NOCOPY VARCHAR2 ,
967 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
968 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
969 p_called_from IN VARCHAR2 DEFAULT NULL,
970 p_org_id IN NUMBER DEFAULT NULL);
971
972 /*=======================================================================
973 | PUBLIC Procedure Create_Apply_On_Acc
974 |
975 | DESCRIPTION
976 | This API creates a receipt and applies it on the Account.
977 |
978 | Parematers are the same as in create cash and Apply_on_Account
979 | except an extra parameter p_call_payment_processor has been added
980 | that should be passed as true for iPayment to do the credit card
981 | processing.
982 |
983 | For Creating receipts and applying to invoices please use
984 | Create_and Apply
985 | -------------------------------------------------------------------
986 |
987 | PSEUDO CODE/LOGIC
988 |
989 | PARAMETERS
990 |
991 |
992 | RETURNS
993 | nothing
994 |
995 | KNOWN ISSUES
996 |
997 |
998 |
999 | NOTES
1000 |
1001 |
1002 |
1003 | MODIFICATION HISTORY
1004 | Date Author Description of Changes
1005 | 16-FEB-2004 Jyoti Pandey Created
1006 | This API has been created for Collections team
1007 | Bug 3398538. This replaces their call to
1008 | ar_receipt_api_pub.Create_cash which is not meant
1009 | for Credit card receipts
1010 |01-MAR-2004 Bug 3398538 and 3236769.
1011 | IMPORTANT:Renaming this API as
1012 | Create_Apply_On_Acc from create-cash_cc_internal
1013 | Create_cash_cc_internal is being obsoleted.
1014 |
1015 *=======================================================================*/
1016
1017 /*#
1018 * Use this procedure to create and then apply a cash receipt to an on-account application.
1019 * @rep:scope public
1020 * @rep:lifecycle active
1021 * @rep:displayname Create and Apply Cash Receipt to On-Account
1022 */
1023
1024
1025
1026 PROCEDURE Create_Apply_On_Acc(
1027 -- Standard API parameters.
1028 p_api_version IN NUMBER,
1029 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1030 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1031 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1032 x_return_status OUT NOCOPY VARCHAR2,
1033 x_msg_count OUT NOCOPY NUMBER,
1034 x_msg_data OUT NOCOPY VARCHAR2,
1035 -- Receipt info. parameters
1036 p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
1037 p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1038 p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
1039 p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
1040 p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
1041 p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
1042 p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
1043 p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
1044 DEFAULT NULL,
1045 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1046 p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1047 p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1048 p_maturity_date IN DATE DEFAULT NULL,
1049 p_postmark_date IN DATE DEFAULT NULL,
1050 p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
1051 /* tca uptake */
1052 p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
1053 p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
1054 p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
1055 DEFAULT NULL,
1056 /* 6612301 */
1057 p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE
1058 DEFAULT NULL,
1059 p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE
1060 DEFAULT NULL,
1061 p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, --payment uptake changes bichatte
1062 p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
1063 p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
1064 p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug 4448307-4509459
1065 p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE
1066 DEFAULT NULL,
1067 p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE
1068 DEFAULT NULL,
1069 p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
1070 p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
1071 p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
1072 p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
1073 p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
1074 p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
1075 p_doc_sequence_value IN NUMBER DEFAULT NULL,
1076 p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
1077 DEFAULT NULL,
1078 p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE
1079 DEFAULT NULL,
1080 p_called_from IN VARCHAR2 DEFAULT NULL,
1081 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1082 -- ******* Global Flexfield parameters *******
1083 p_global_attribute_rec IN global_attribute_rec_type
1084 DEFAULT global_attribute_rec_const,
1085 p_receipt_comments IN VARCHAR2 DEFAULT NULL,
1086 -- *** Notes Receivable Additional Information ***
1087 p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
1088 p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
1089 p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
1090 -- ** OUT NOCOPY variables for Creating receipt
1091 p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1092 -- Receipt application parameters
1093 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1094 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1095 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1096 app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1097 app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1098 -- ******* Global Flexfield parameters *******
1099 app_global_attribute_rec IN global_attribute_rec_type
1100 DEFAULT global_attribute_rec_const,
1101 app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1102 p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
1103 DEFAULT NULL,
1104 p_secondary_application_ref_id IN
1105 ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1106 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1107 DEFAULT NULL,
1108 p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1109 p_secondary_app_ref_type IN
1110 ar_receivable_applications.secondary_application_ref_type%TYPE := null,
1111 p_secondary_app_ref_num IN
1112 ar_receivable_applications.secondary_application_ref_num%TYPE := null,
1113
1114 p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1115 p_org_id IN NUMBER DEFAULT NULL
1116 ) ;
1117
1118 PROCEDURE Copy_payment_extension(
1119 p_payment_trxn_extension_id IN NUMBER,
1120 p_customer_id IN NUMBER,
1121 p_receipt_method_id IN NUMBER,
1122 p_org_id IN NUMBER,
1123 p_customer_site_use_id IN NUMBER,
1124 p_receipt_number IN VARCHAR2,
1125 x_msg_count OUT NOCOPY NUMBER,
1126 x_msg_data OUT NOCOPY VARCHAR2,
1127 x_return_status OUT NOCOPY VARCHAR2,
1128 o_payment_trxn_extension_id OUT NOCOPY NUMBER
1129 );
1130
1131 PROCEDURE process_payment_1(
1132 p_cash_receipt_id IN NUMBER,
1133 p_called_from IN VARCHAR2,
1134 p_response_error_code OUT NOCOPY VARCHAR2,
1135 x_msg_count OUT NOCOPY NUMBER,
1136 x_msg_data OUT NOCOPY VARCHAR2,
1137 x_return_status OUT NOCOPY VARCHAR2,
1138 p_payment_trxn_extension_id IN NUMBER DEFAULT NULL
1139 );
1140 PROCEDURE Create_payment_extension(
1141 p_payment_trxn_extension_id IN NUMBER,
1142 p_customer_id IN NUMBER,
1143 p_receipt_method_id IN NUMBER,
1144 p_org_id IN NUMBER,
1145 p_customer_site_use_id IN NUMBER,
1146 p_receipt_number IN VARCHAR2,
1147 p_cash_receipt_id IN NUMBER,
1148 x_msg_count OUT NOCOPY NUMBER,
1149 x_msg_data OUT NOCOPY VARCHAR2,
1150 x_return_status OUT NOCOPY VARCHAR2,
1151 o_payment_trxn_extension_id OUT NOCOPY NUMBER
1152 );
1153
1154
1155
1156 END AR_RECEIPT_API_PUB;