[Home] [Help]
PACKAGE: APPS.AR_RECEIPT_API_PUB
Source
1 Package AR_RECEIPT_API_PUB AUTHID CURRENT_USER AS
2 /* $Header: ARXPRECS.pls 120.40 2011/10/05 09:36:26 vpusulur 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_num%TYPE,
210 remittance_bank_account_name ce_bank_accounts.bank_account_name%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 TYPE CR_ID_TABLE IS RECORD
269 (
270 cash_receipt_id DBMS_SQL.NUMBER_TABLE,
271 cc_error_code DBMS_SQL.VARCHAR2_TABLE,
272 cc_error_text DBMS_SQL.VARCHAR2_TABLE,
273 cc_instrtype DBMS_SQL.VARCHAR2_TABLE
274 );
275
276
277
278 /*#
279 Use this procedure to create a single cash receipt for
280 * payment received in the form of a check or cash.
281 * manually created cash receipts.
282 * @rep:scope public
283 * @rep:lifecycle active
284 * @rep:displayname Create Cash Receipt
285 */
286
287 PROCEDURE Create_cash(
288 -- Standard API parameters.
289 p_api_version IN NUMBER,
290 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
291 p_commit IN VARCHAR2 := FND_API.G_FALSE,
292 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
293 x_return_status OUT NOCOPY VARCHAR2,
294 x_msg_count OUT NOCOPY NUMBER,
295 x_msg_data OUT NOCOPY VARCHAR2,
296 -- Receipt info. parameters
297 p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
298 p_currency_code IN VARCHAR2 DEFAULT NULL,
299 p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
300 p_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
301 p_exchange_rate IN NUMBER DEFAULT NULL,
302 p_exchange_rate_date IN DATE DEFAULT NULL,
303 p_amount IN NUMBER DEFAULT NULL,
304 p_factor_discount_amount IN NUMBER DEFAULT NULL,
305 p_receipt_number IN VARCHAR2 DEFAULT NULL,
306 p_receipt_date IN DATE DEFAULT NULL,
307 p_gl_date IN DATE DEFAULT NULL,
308 p_maturity_date IN DATE DEFAULT NULL,
309 p_postmark_date IN DATE DEFAULT NULL,
310 p_customer_id IN NUMBER DEFAULT NULL,
311 p_customer_name IN VARCHAR2 DEFAULT NULL,
312 p_customer_number IN VARCHAR2 DEFAULT NULL,
313 p_customer_bank_account_id IN NUMBER DEFAULT NULL,
314 p_customer_bank_account_num IN VARCHAR2 DEFAULT NULL,
315 p_customer_bank_account_name IN VARCHAR2 DEFAULT NULL,
316 p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, --payment uptake changes bichatte
317 p_location IN VARCHAR2 DEFAULT NULL,
318 p_customer_site_use_id IN NUMBER DEFAULT NULL,
319 p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug4448307-4509459
320 p_customer_receipt_reference IN VARCHAR2 DEFAULT NULL,
321 p_override_remit_account_flag IN VARCHAR2 DEFAULT NULL,
322 p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
323 p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
324 p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
325 p_deposit_date IN DATE DEFAULT NULL,
326 p_receipt_method_id IN NUMBER DEFAULT NULL,
327 p_receipt_method_name IN VARCHAR2 DEFAULT NULL,
328 p_doc_sequence_value IN NUMBER DEFAULT NULL,
329 p_ussgl_transaction_code IN VARCHAR2 DEFAULT NULL,
330 p_anticipated_clearing_date IN DATE DEFAULT NULL,
331 p_called_from IN VARCHAR2 DEFAULT NULL,
332 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
333 -- ******* Global Flexfield parameters *******
334 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
335 p_comments IN VARCHAR2 DEFAULT NULL,
336 -- *** Notes Receivable Additional Information ***
337 p_issuer_name IN VARCHAR2 DEFAULT NULL,
338 p_issue_date IN DATE DEFAULT NULL,
339 p_issuer_bank_branch_id IN NUMBER DEFAULT NULL,
340 p_org_id IN NUMBER DEFAULT NULL,
341 p_installment IN NUMBER DEFAULT NULL,
342 -- ** OUT NOCOPY variables
343 p_cr_id OUT NOCOPY NUMBER
344 );
345
346 /*#
347 * Use this procedure to apply the cash receipts from a customer
348 * to an invoice, debit memo, or other debit item.
349 * @rep:scope public
350 * @rep:lifecycle active
351 * @rep:displayname Apply Receipt
352 */
353
354 PROCEDURE Apply(
355 -- Standard API parameters.
356 p_api_version IN NUMBER,
357 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
358 p_commit IN VARCHAR2 := FND_API.G_FALSE,
359 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
360 x_return_status OUT NOCOPY VARCHAR2,
361 x_msg_count OUT NOCOPY NUMBER,
362 x_msg_data OUT NOCOPY VARCHAR2,
363 -- Receipt application parameters.
364 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
365 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
366 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
367 p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
368 p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
369 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
370 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
371 -- this is the allocated receipt amount
372 p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
373 p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
374 p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
375 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
376 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
377 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
378 p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
379 p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
380 p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
381 p_called_from IN VARCHAR2 DEFAULT NULL,
382 p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
383 p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
384 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
385 -- ******* Global Flexfield parameters *******
386 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
387 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
388 p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
389 p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
390 p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
391 p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
392 p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
393 p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
394 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
395 p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
396 p_org_id IN NUMBER DEFAULT NULL
397 );
398
399 -- LLCA
400 PROCEDURE Apply_In_Detail(
401 -- Standard API parameters.
402 p_api_version IN NUMBER,
403 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
404 p_commit IN VARCHAR2 := FND_API.G_FALSE,
405 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
406 x_return_status OUT NOCOPY VARCHAR2,
407 x_msg_count OUT NOCOPY NUMBER,
408 x_msg_data OUT NOCOPY VARCHAR2,
409 -- Receipt application parameters.
410 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
411 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
412 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
413 p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
414 p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
415 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
416 -- LLCA Parameters
417 p_llca_type IN VARCHAR2 DEFAULT 'S',
418 p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,
419 p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */
420 p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
421 p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
422 p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
423 p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
424 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
425 p_line_discount IN NUMBER DEFAULT NULL,
426 p_tax_discount IN NUMBER DEFAULT NULL,
427 p_freight_discount IN NUMBER DEFAULT NULL,
428 -- this is the allocated receipt amount
429 p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
430 p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
431 p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
432 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
433 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
434 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
435 p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
436 p_called_from IN VARCHAR2 DEFAULT NULL,
437 p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
438 p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
439 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
440 -- ******* Global Flexfield parameters *******
441 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
442 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
443 p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
444 p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
445 p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
446 p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
447 p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
448 p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
449 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
450 p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
451 p_org_id IN NUMBER DEFAULT NULL,
452 p_line_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const
453 );
454
455 /*#
456 * Use this procedure to unapply a cash receipt application against
457 * a specified installment of a debit item or payment schedule ID.
458 * @rep:scope public
459 * @rep:lifecycle active
460 * @rep:displayname Unapply Receipt
461 */
462
463 PROCEDURE Unapply(
464 -- Standard API parameters.
465 p_api_version IN NUMBER,
466 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
467 p_commit IN VARCHAR2 := FND_API.G_FALSE,
468 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
469 x_return_status OUT NOCOPY VARCHAR2 ,
470 x_msg_count OUT NOCOPY NUMBER ,
471 x_msg_data OUT NOCOPY VARCHAR2 ,
472 -- *** Receipt Info. parameters *****
473 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
474 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
475 p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
476 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
477 p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
478 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
479 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
480 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
481 p_called_from IN VARCHAR2 DEFAULT NULL,
482 p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
483 p_org_id IN NUMBER DEFAULT NULL
484 );
485
486 /*#
487 * Use this procedure to create a cash receipt and apply it
488 * to a specified installment of a debit item.
489 * @rep:scope public
490 * @rep:lifecycle active
491 * @rep:displayname Create and Apply Receipt
492 */
493
494
495 PROCEDURE Create_and_apply(
496 -- Standard API parameters.
497 p_api_version IN NUMBER,
498 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
499 p_commit IN VARCHAR2 := FND_API.G_FALSE,
500 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
501 x_return_status OUT NOCOPY VARCHAR2,
502 x_msg_count OUT NOCOPY NUMBER,
503 x_msg_data OUT NOCOPY VARCHAR2,
504 -- Receipt info. parameters
505 p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
506 p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
507 p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
508 p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
509 p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
510 p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
511 p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
512 p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
513 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
514 p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
515 p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
516 p_maturity_date IN DATE DEFAULT NULL,
517 p_postmark_date IN DATE DEFAULT NULL,
518 p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
519 p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
520 p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
521 p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
522 /* 6612301 */
523 p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL,
524 p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE DEFAULT NULL,
525 p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, --payment uptake changes bichatte
526 p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
527 p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
528 p_default_site_use IN VARCHAR2 DEFAULT 'Y', --The default site use bug4448307-4509459.
529 p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
530 p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
531 p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
532 p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
533 p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
534 p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
535 p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
536 p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
537 p_doc_sequence_value IN NUMBER DEFAULT NULL,
538 p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
539 p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
540 p_called_from IN VARCHAR2 DEFAULT NULL,
541 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
542 -- ******* Global Flexfield parameters *******
543 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
544 p_receipt_comments IN VARCHAR2 DEFAULT NULL,
545 -- *** Notes Receivable Additional Information ***
546 p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
547 p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
548 p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
549 -- ** OUT NOCOPY variables for Creating receipt
550 p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
551 -- Receipt application parameters
552 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
553 p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
554 p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
555 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
556 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
557 -- this is the allocated receipt amount
558 p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
559 p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
560 p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
561 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
562 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
563 app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
564 p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
565 p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
566 p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
567 p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
568 p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
569 app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
570 -- ******* Global Flexfield parameters *******
571 app_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
572 app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
573 -- OSTEINME 3/9/2001: added flag that indicates whether to call payment
574 -- processor such as iPayments
575 p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE,
576 p_org_id IN NUMBER DEFAULT NULL
577 -- OUT NOCOPY parameter for the Application
578 );
579
580 /*#
581 * Use this procedure to reverse cash and miscellaneous receipts.
582 * @rep:scope public
583 * @rep:lifecycle active
584 * @rep:displayname Reverse Receipt
585 */
586
587
588 PROCEDURE Reverse(
589 -- Standard API parameters.
590 p_api_version IN NUMBER,
591 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
592 p_commit IN VARCHAR2 := FND_API.G_FALSE,
593 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
594 x_return_status OUT NOCOPY VARCHAR2,
595 x_msg_count OUT NOCOPY NUMBER,
596 x_msg_data OUT NOCOPY VARCHAR2,
597 -- Receipt reversal related parameters
598 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
599 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
600 p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
601 p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
602 p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
603 p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
604 p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
605 p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
606 p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
607 p_called_from IN VARCHAR2 DEFAULT NULL,
608 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
609 --p_global_attribute_rec IN global_attribute_rec_type_upd DEFAULT global_attribute_rec_upd_cons
610 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const ,
611 p_cancel_claims_flag IN VARCHAR2 DEFAULT 'Y',
612 p_org_id IN NUMBER DEFAULT NULL
613 );
614
615 /*#
616 * Use this procedure to apply a cash receipt on account.
617 * @rep:scope public
618 * @rep:lifecycle active
619 * @rep:displayname Apply On-Account Receipt
620 */
621
622
623 PROCEDURE Apply_on_account(
624 -- Standard API parameters.
625 p_api_version IN NUMBER,
626 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
627 p_commit IN VARCHAR2 := FND_API.G_FALSE,
628 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
629 x_return_status OUT NOCOPY VARCHAR2,
630 x_msg_count OUT NOCOPY NUMBER,
631 x_msg_data OUT NOCOPY VARCHAR2,
632 -- Receipt application parameters.
633 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
634 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
635 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
636 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
637 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
638 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
639 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
640 -- ******* Global Flexfield parameters *******
641 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
642 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
643 p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
644 p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
645 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
646 p_called_from IN VARCHAR2 DEFAULT NULL,
647 p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
648 p_secondary_app_ref_type IN
649 ar_receivable_applications.secondary_application_ref_type%TYPE := null,
650 p_secondary_app_ref_num IN
651 ar_receivable_applications.secondary_application_ref_num%TYPE := null,
652 p_org_id IN NUMBER DEFAULT NULL
653 );
654
655 /*#
656 * Use this procedure to unapply an on-account application of
657 * a specified cash receipt.
658 * @rep:scope public
659 * @rep:lifecycle active
660 * @rep:displayname Unapply On-Account Receipt
661 */
662
663
664 PROCEDURE Unapply_on_account(
665 -- Standard API parameters.
666 p_api_version IN NUMBER,
667 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
668 p_commit IN VARCHAR2 := FND_API.G_FALSE,
669 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
670 x_return_status OUT NOCOPY VARCHAR2 ,
671 x_msg_count OUT NOCOPY NUMBER ,
672 x_msg_data OUT NOCOPY VARCHAR2 ,
673 -- *** Receipt Info. parameters *****
674 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
675 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
676 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
677 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
678 p_org_id IN NUMBER DEFAULT NULL
679 );
680
681 /*#
682 * Use this procedure to create an activity application on a cash receipt,
683 * including Short Term Debit (STD) and Receipt Write-off applications.
684 * @rep:scope public
685 * @rep:lifecycle active
686 * @rep:displayname Receipt Activity Application
687 */
688
689
690 PROCEDURE Activity_application(
691 -- Standard API parameters.
692 p_api_version IN NUMBER,
693 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
694 p_commit IN VARCHAR2 := FND_API.G_FALSE,
695 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
696 x_return_status OUT NOCOPY VARCHAR2,
697 x_msg_count OUT NOCOPY NUMBER,
698 x_msg_data OUT NOCOPY VARCHAR2,
699 -- Receipt application parameters.
700 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
701 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
702 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
703 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
704 p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
705 p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
706 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
707 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
708 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
709 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
710 -- ******* Global Flexfield parameters *******
711 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
712 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
713 p_application_ref_type IN OUT NOCOPY
714 ar_receivable_applications.application_ref_type%TYPE,
715 p_application_ref_id IN OUT NOCOPY
716 ar_receivable_applications.application_ref_id%TYPE,
717 p_application_ref_num IN OUT NOCOPY
718 ar_receivable_applications.application_ref_num%TYPE,
719 p_secondary_application_ref_id IN OUT NOCOPY
720 ar_receivable_applications.secondary_application_ref_id%TYPE,
721 p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
722 p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
723 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
724 p_val_writeoff_limits_flag IN VARCHAR2 DEFAULT 'Y',
725 p_called_from IN VARCHAR2 DEFAULT NULL,
726 p_netted_receipt_flag IN VARCHAR2 DEFAULT NULL,
727 p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
728 p_secondary_app_ref_type IN
729 ar_receivable_applications.secondary_application_ref_type%TYPE := null,
730 p_secondary_app_ref_num IN
731 ar_receivable_applications.secondary_application_ref_num%TYPE := null,
732 p_org_id IN NUMBER DEFAULT NULL,
733 p_customer_reason IN
734 ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
735 ,p_pay_group_lookup_code IN FND_LOOKUPS.lookup_code%TYPE DEFAULT NULL
736 ,p_pay_alone_flag IN VARCHAR2 DEFAULT NULL
737 ,p_payment_method_code IN ap_invoices.payment_method_code%TYPE DEFAULT NULL
738 ,p_payment_reason_code IN ap_invoices.payment_reason_code%TYPE DEFAULT NULL
739 ,p_payment_reason_comments IN ap_invoices.payment_reason_comments%TYPE DEFAULT NULL
740 ,p_delivery_channel_code IN ap_invoices.delivery_channel_code%TYPE DEFAULT NULL
741 ,p_remittance_message1 IN ap_invoices.remittance_message1%TYPE DEFAULT NULL
742 ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE DEFAULT NULL
743 ,p_remittance_message3 IN ap_invoices.remittance_message3%TYPE DEFAULT NULL
744 ,p_party_id IN hz_parties.party_id%TYPE DEFAULT NULL
745 ,p_party_site_id IN hz_party_sites.party_site_id%TYPE DEFAULT NULL
746 ,p_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL
747 ,p_payment_priority IN ap_invoices_interface.PAYMENT_PRIORITY%TYPE DEFAULT NULL --Bug8290172
748 ,p_terms_id IN ap_invoices_interface.TERMS_ID%TYPE DEFAULT NULL --Bug8290172
749 );
750
751 /*#
752 * Use this procedure to create a reversal of an activity application
753 * on a cash receipt including Short Term Debt and Receipt write-off.
754 * @rep:scope public
755 * @rep:lifecycle active
756 * @rep:displayname Receipt Activity Unapplication
757 */
758
759 PROCEDURE Activity_unapplication(
760 -- Standard API parameters.
761 p_api_version IN NUMBER,
762 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
763 p_commit IN VARCHAR2 := FND_API.G_FALSE,
764 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
765 x_return_status OUT NOCOPY VARCHAR2 ,
766 x_msg_count OUT NOCOPY NUMBER ,
767 x_msg_data OUT NOCOPY VARCHAR2 ,
768 -- *** Receipt Info. parameters *****
769 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
770 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
771 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
772 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
773 p_called_from IN VARCHAR2,
774 p_org_id IN NUMBER DEFAULT NULL
775 );
776
777 /*#
778 * Use this procedure to apply a cash receipt to other account activities,
779 * such as creating a claim investigation application with a
780 * noninvoice-related deduction or overpayment in Trade Management (if installed).
781 * @rep:scope public
782 * @rep:lifecycle active
783 * @rep:displayname Account Application on a Cash Receipt
784 */
785
786
787 PROCEDURE Apply_other_account(
788 -- Standard API parameters.
789 p_api_version IN NUMBER,
790 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
791 p_commit IN VARCHAR2 := FND_API.G_FALSE,
792 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
793 x_return_status OUT NOCOPY VARCHAR2,
794 x_msg_count OUT NOCOPY NUMBER,
795 x_msg_data OUT NOCOPY VARCHAR2,
796 p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
797 -- Receipt application parameters.
798 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
799 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
800 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
801 p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
802 p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
803 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
804 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
805 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
806 p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
807 p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
808 p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
809 p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
810 p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
811 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
812 -- ******* Global Flexfield parameters *******
813 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
814 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
815 p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
816 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
817 p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
818 p_called_from IN VARCHAR2 DEFAULT NULL,
819 p_org_id IN NUMBER DEFAULT NULL
820 );
821
822 /*#
823 * Use this procedure to reverse a cash receipt to other account activity.
824 * @rep:scope public
825 * @rep:lifecycle active
826 * @rep:displayname Reversal of an Account Application
827 */
828
829
830 PROCEDURE Unapply_other_account(
831 -- Standard API parameters.
832 p_api_version IN NUMBER,
833 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
834 p_commit IN VARCHAR2 := FND_API.G_FALSE,
835 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
836 x_return_status OUT NOCOPY VARCHAR2 ,
837 x_msg_count OUT NOCOPY NUMBER ,
838 x_msg_data OUT NOCOPY VARCHAR2 ,
839 -- *** Receipt Info. parameters *****
840 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
841 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
842 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
843 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
844 p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
845 p_called_from IN VARCHAR2 DEFAULT NULL,
846 p_org_id IN NUMBER DEFAULT NULL
847 );
848
849
850 /*#
851 * Use this procedure to create a miscellaneous receipt.
852 * @rep:scope public
853 * @rep:lifecycle active
854 * @rep:displayname Create Miscellaneous Receipt
855 */
856
857
858 PROCEDURE create_misc(
859 -- Standard API parameters.
860 p_api_version IN NUMBER,
861 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
862 p_commit IN VARCHAR2 := FND_API.G_FALSE,
863 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
864 x_return_status OUT NOCOPY VARCHAR2 ,
865 x_msg_count OUT NOCOPY NUMBER ,
866 x_msg_data OUT NOCOPY VARCHAR2 ,
867 -- Misc Receipt info. parameters
868 p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
869 p_currency_code IN VARCHAR2 DEFAULT NULL,
870 p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
871 p_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
872 p_exchange_rate IN NUMBER DEFAULT NULL,
873 p_exchange_rate_date IN DATE DEFAULT NULL,
874 p_amount IN NUMBER,
875 p_receipt_number IN OUT NOCOPY VARCHAR2,
876 p_receipt_date IN DATE DEFAULT NULL,
877 p_gl_date IN DATE DEFAULT NULL,
878 p_receivables_trx_id IN NUMBER DEFAULT NULL,
879 p_activity IN VARCHAR2 DEFAULT NULL,
880 p_misc_payment_source IN VARCHAR2 DEFAULT NULL,
881 p_tax_code IN VARCHAR2 DEFAULT NULL,
882 p_vat_tax_id IN VARCHAR2 DEFAULT NULL,
883 p_tax_rate IN NUMBER DEFAULT NULL,
884 p_tax_amount IN NUMBER DEFAULT NULL,
885 p_deposit_date IN DATE DEFAULT NULL,
886 p_reference_type IN VARCHAR2 DEFAULT NULL,
887 p_reference_num IN VARCHAR2 DEFAULT NULL,
888 p_reference_id IN NUMBER DEFAULT NULL,
889 p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
890 p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
891 p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
892 p_receipt_method_id IN NUMBER DEFAULT NULL,
893 p_receipt_method_name IN VARCHAR2 DEFAULT NULL,
894 p_doc_sequence_value IN NUMBER DEFAULT NULL,
895 p_ussgl_transaction_code IN VARCHAR2 DEFAULT NULL,
896 p_anticipated_clearing_date IN DATE DEFAULT NULL,
897 p_attribute_record IN attribute_rec_type DEFAULT attribute_rec_const,
898 p_global_attribute_record IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
899 p_comments IN VARCHAR2 DEFAULT NULL,
900 p_org_id IN NUMBER DEFAULT NULL,
901 p_misc_receipt_id OUT NOCOPY NUMBER,
902 p_called_from IN VARCHAR2 DEFAULT NULL,
903 p_payment_trxn_extension_id In ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL); /* Bug fix 3619780*/
904
905
906 Method_Cache_Tbl Rec_Method_Tbl_Type ;
907 Customer_Cache_Tbl Rec_Customer_Tbl_Type;
908
909 PROCEDURE set_profile_for_testing(p_profile_doc_seq VARCHAR2,
910 p_profile_enable_cc VARCHAR2,
911 p_profile_appln_gl_date_def VARCHAR2,
912 p_profile_amt_applied_def VARCHAR2,
913 p_profile_cc_rate_type VARCHAR2,
914 p_profile_dsp_inv_rate VARCHAR2,
915 p_profile_create_bk_charges VARCHAR2,
916 p_profile_def_x_rate_type VARCHAR2,
917 p_pay_unrelated_inv_flag VARCHAR2,
918 p_unearned_discount VARCHAR2);
919
920 /*#
921 * User this procedure to apply a cash receipt to another open receipt.
922 * Open receipts include unapplied cash, on-account cash, and claim investigation applications.
923 * @rep:scope public
924 * @rep:lifecycle active
925 * @rep:displayname Apply Receipt to Another Receipt
926 */
927
928
929 PROCEDURE Apply_Open_Receipt(
930 -- Standard API parameters.
931 p_api_version IN NUMBER,
932 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
933 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
934 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
935 x_return_status OUT NOCOPY VARCHAR2,
936 x_msg_count OUT NOCOPY NUMBER,
937 x_msg_data OUT NOCOPY VARCHAR2,
938 -- Receipt application parameters.
939 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
940 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
941 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
942 p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
943 p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
944 p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
945 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
946 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
947 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
948 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
949 p_called_from IN VARCHAR2 DEFAULT NULL,
950 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
951 -- ******* Global Flexfield parameters *******
952 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
953 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
954 p_org_id IN NUMBER DEFAULT NULL,
955 x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
956 x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
957 x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
958 x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
959 x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
960 );
961
962 /*#
963 * Use this procedure to reverse a payment netting application on a cash receipt.
964 * @rep:scope public
965 * @rep:lifecycle active
966 * @rep:displayname Reverse Application of a Receipt to Another Receipt
967 */
968
969
970 PROCEDURE Unapply_Open_Receipt(
971 -- Standard API parameters.
972 p_api_version IN NUMBER,
973 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
974 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
975 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
976 x_return_status OUT NOCOPY VARCHAR2 ,
977 x_msg_count OUT NOCOPY NUMBER ,
978 x_msg_data OUT NOCOPY VARCHAR2 ,
979 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
980 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
981 p_called_from IN VARCHAR2 DEFAULT NULL,
982 p_org_id IN NUMBER DEFAULT NULL);
983
984 /*=======================================================================
985 | PUBLIC Procedure Create_Apply_On_Acc
986 |
987 | DESCRIPTION
988 | This API creates a receipt and applies it on the Account.
989 |
990 | Parematers are the same as in create cash and Apply_on_Account
991 | except an extra parameter p_call_payment_processor has been added
992 | that should be passed as true for iPayment to do the credit card
993 | processing.
994 |
995 | For Creating receipts and applying to invoices please use
996 | Create_and Apply
997 | -------------------------------------------------------------------
998 |
999 | PSEUDO CODE/LOGIC
1000 |
1001 | PARAMETERS
1002 |
1003 |
1004 | RETURNS
1005 | nothing
1006 |
1007 | KNOWN ISSUES
1008 |
1009 |
1010 |
1011 | NOTES
1012 |
1013 |
1014 |
1015 | MODIFICATION HISTORY
1016 | Date Author Description of Changes
1017 | 16-FEB-2004 Jyoti Pandey Created
1018 | This API has been created for Collections team
1019 | Bug 3398538. This replaces their call to
1020 | ar_receipt_api_pub.Create_cash which is not meant
1021 | for Credit card receipts
1022 |01-MAR-2004 Bug 3398538 and 3236769.
1023 | IMPORTANT:Renaming this API as
1024 | Create_Apply_On_Acc from create-cash_cc_internal
1025 | Create_cash_cc_internal is being obsoleted.
1026 |
1027 *=======================================================================*/
1028
1029 /*#
1030 * Use this procedure to create and then apply a cash receipt to an on-account application.
1031 * @rep:scope public
1032 * @rep:lifecycle active
1033 * @rep:displayname Create and Apply Cash Receipt to On-Account
1034 */
1035
1036
1037
1038 PROCEDURE Create_Apply_On_Acc(
1039 -- Standard API parameters.
1040 p_api_version IN NUMBER,
1041 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1042 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1043 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1044 x_return_status OUT NOCOPY VARCHAR2,
1045 x_msg_count OUT NOCOPY NUMBER,
1046 x_msg_data OUT NOCOPY VARCHAR2,
1047 -- Receipt info. parameters
1048 p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
1049 p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1050 p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
1051 p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
1052 p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
1053 p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
1054 p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
1055 p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
1056 DEFAULT NULL,
1057 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1058 p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1059 p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1060 p_maturity_date IN DATE DEFAULT NULL,
1061 p_postmark_date IN DATE DEFAULT NULL,
1062 p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
1063 /* tca uptake */
1064 p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
1065 p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
1066 p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
1067 DEFAULT NULL,
1068 /* 6612301 */
1069 p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE
1070 DEFAULT NULL,
1071 p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE
1072 DEFAULT NULL,
1073 p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, --payment uptake changes bichatte
1074 p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
1075 p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
1076 p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug 4448307-4509459
1077 p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE
1078 DEFAULT NULL,
1079 p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE
1080 DEFAULT NULL,
1081 p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
1082 p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
1083 p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
1084 p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
1085 p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
1086 p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
1087 p_doc_sequence_value IN NUMBER DEFAULT NULL,
1088 p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
1089 DEFAULT NULL,
1090 p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE
1091 DEFAULT NULL,
1092 p_called_from IN VARCHAR2 DEFAULT NULL,
1093 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1094 -- ******* Global Flexfield parameters *******
1095 p_global_attribute_rec IN global_attribute_rec_type
1096 DEFAULT global_attribute_rec_const,
1097 p_receipt_comments IN VARCHAR2 DEFAULT NULL,
1098 -- *** Notes Receivable Additional Information ***
1099 p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
1100 p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
1101 p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
1102 -- ** OUT NOCOPY variables for Creating receipt
1103 p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1104 -- Receipt application parameters
1105 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1106 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1107 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1108 app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1109 app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1110 -- ******* Global Flexfield parameters *******
1111 app_global_attribute_rec IN global_attribute_rec_type
1112 DEFAULT global_attribute_rec_const,
1113 app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1114 p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
1115 DEFAULT NULL,
1116 p_secondary_application_ref_id IN
1117 ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1118 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1119 DEFAULT NULL,
1120 p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1121 p_secondary_app_ref_type IN
1122 ar_receivable_applications.secondary_application_ref_type%TYPE := null,
1123 p_secondary_app_ref_num IN
1124 ar_receivable_applications.secondary_application_ref_num%TYPE := null,
1125
1126 p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1127 p_org_id IN NUMBER DEFAULT NULL
1128 ) ;
1129
1130 PROCEDURE Copy_payment_extension(
1131 p_payment_trxn_extension_id IN NUMBER,
1132 p_customer_id IN NUMBER,
1133 p_receipt_method_id IN NUMBER,
1134 p_org_id IN NUMBER,
1135 p_customer_site_use_id IN NUMBER,
1136 p_receipt_number IN VARCHAR2,
1137 x_msg_count OUT NOCOPY NUMBER,
1138 x_msg_data OUT NOCOPY VARCHAR2,
1139 x_return_status OUT NOCOPY VARCHAR2,
1140 o_payment_trxn_extension_id OUT NOCOPY NUMBER,
1141 p_called_from IN VARCHAR2 DEFAULT NULL,
1142 p_receipt_date IN DATE DEFAULT NULL
1143 );
1144
1145 PROCEDURE process_payment_1(
1146 p_cash_receipt_id IN NUMBER,
1147 p_called_from IN VARCHAR2,
1148 p_response_error_code OUT NOCOPY VARCHAR2,
1149 x_msg_count OUT NOCOPY NUMBER,
1150 x_msg_data OUT NOCOPY VARCHAR2,
1151 x_return_status OUT NOCOPY VARCHAR2,
1152 p_payment_trxn_extension_id IN NUMBER DEFAULT NULL
1153 );
1154 PROCEDURE Create_payment_extension(
1155 p_payment_trxn_extension_id IN NUMBER,
1156 p_customer_id IN NUMBER,
1157 p_receipt_method_id IN NUMBER,
1158 p_org_id IN NUMBER,
1159 p_customer_site_use_id IN NUMBER,
1160 p_receipt_number IN VARCHAR2,
1161 p_cash_receipt_id IN NUMBER,
1162 x_msg_count OUT NOCOPY NUMBER,
1163 x_msg_data OUT NOCOPY VARCHAR2,
1164 x_return_status OUT NOCOPY VARCHAR2,
1165 o_payment_trxn_extension_id OUT NOCOPY NUMBER,
1166 p_receipt_date IN DATE DEFAULT NULL
1167 );
1168
1169 /*
1170 This procedure is for internal use only
1171 This procedure is to change status of the Receipt from remittance to confirm
1172 under certain conditions determined by offline remittance
1173 Parameters for this procedure
1174 IN:
1175 p_Cash_receipts_id CR_ID_TABLE (A table of cash receipts)
1176 p_called_from VARCHAR2 (Internal Use)
1177
1178 */
1179
1180 PROCEDURE Reverse_Remittances_in_err(
1181 -- Standard API parameters.
1182 p_api_version IN NUMBER,
1183 p_cash_receipts_id IN CR_ID_TABLE,
1184 p_called_from IN VARCHAR2 DEFAULT NULL,
1185 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1186 x_return_status OUT NOCOPY VARCHAR2,
1187 x_msg_count OUT NOCOPY NUMBER,
1188 x_msg_data OUT NOCOPY VARCHAR2
1189 );
1190
1191
1192 /*
1193 This procedure is used to create receipts in BULK mode.
1194 Before calling this procedure , ar_create_receipts_gt table has to be populated.
1195 Also set the org_context before calling this procedure
1196 */
1197
1198 PROCEDURE Create_Cash_Bulk(
1199 -- Standard API parameters.
1200 p_api_version IN NUMBER DEFAULT 1.0,
1201 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1202 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1203 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1204 p_fetch_bulk_commit IN NUMBER DEFAULT 1000,
1205 x_return_status OUT NOCOPY VARCHAR2,
1206 x_msg_count OUT NOCOPY NUMBER,
1207 x_msg_data OUT NOCOPY VARCHAR2
1208 );
1209
1210
1211 PROCEDURE process_events(p_gt_id NUMBER,
1212 p_request_id NUMBER,
1213 p_org_id NUMBER) ;
1214
1215
1216 END AR_RECEIPT_API_PUB;