[Home] [Help]
PACKAGE BODY: APPS.AR_RECEIPT_API_COVER
Source
1 PACKAGE BODY AR_RECEIPT_API_COVER AS
2 /* $Header: ARXRCCVB.pls 120.2 2003/08/12 17:48:56 jbeckett noship $ */
3 --Start of comments
4 --API name : Receipt API cover routine
5 --Type : Public.
6 --Function : Create , apply, unapply and reverse Receipts
7 --Pre-reqs :
8 --
9 -- Notes : Note text
10 --
11 -- Modification History
12 -- Date Name Description
13 -- 20-MAY-2003 Jon Beckett Created to ensure backward compatibility for Trade
14 -- Management. This version compatible with 11.5.10+
15 -- AR installations.
16 -- End of comments
17
18
19 PROCEDURE Create_cash(
20 -- Standard API parameters.
21 p_api_version IN NUMBER,
22 p_init_msg_list IN VARCHAR2,
23 p_commit IN VARCHAR2,
24 p_validation_level IN NUMBER,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2,
28 -- Receipt info. parameters
29 p_usr_currency_code IN VARCHAR2, --the translated currency code
30 p_currency_code IN VARCHAR2,
31 p_usr_exchange_rate_type IN VARCHAR2,
32 p_exchange_rate_type IN VARCHAR2,
33 p_exchange_rate IN NUMBER ,
34 p_exchange_rate_date IN DATE ,
35 p_amount IN NUMBER ,
36 p_factor_discount_amount IN NUMBER ,
37 p_receipt_number IN VARCHAR2,
38 p_receipt_date IN DATE ,
39 p_gl_date IN DATE ,
40 p_maturity_date IN DATE ,
41 p_postmark_date IN DATE ,
42 p_customer_id IN NUMBER ,
43 p_customer_name IN VARCHAR2,
44 p_customer_number IN VARCHAR2,
45 p_customer_bank_account_id IN NUMBER ,
46 p_customer_bank_account_num IN VARCHAR2,
47 p_customer_bank_account_name IN VARCHAR2,
48 p_location IN VARCHAR2,
49 p_customer_site_use_id IN NUMBER ,
50 p_customer_receipt_reference IN VARCHAR2,
51 p_override_remit_account_flag IN VARCHAR2,
52 p_remittance_bank_account_id IN NUMBER ,
53 p_remittance_bank_account_num IN VARCHAR2,
54 p_remittance_bank_account_name IN VARCHAR2,
55 p_deposit_date IN DATE ,
56 p_receipt_method_id IN NUMBER ,
57 p_receipt_method_name IN VARCHAR2 ,
58 p_doc_sequence_value IN NUMBER ,
59 p_ussgl_transaction_code IN VARCHAR2 ,
60 p_anticipated_clearing_date IN DATE ,
61 p_called_from IN VARCHAR2 ,
62 p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
63 -- ******* Global Flexfield parameters *******
64 p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type,
65 p_comments IN VARCHAR2 ,
66 -- *** Notes Receivable Additional Information ***
67 p_issuer_name IN VARCHAR2,
68 p_issue_date IN DATE ,
69 p_issuer_bank_branch_id IN NUMBER,
70 -- ** OUT NOCOPY variables
71 p_cr_id OUT NOCOPY NUMBER
72 )
73 IS
74
75 BEGIN
76
77 -- Call the receipt API
78 AR_Receipt_API_PUB.Create_cash(
79 -- Standard API parameters.
80 p_api_version => p_api_version,
81 p_init_msg_list => p_init_msg_list,
82 p_commit => p_commit,
83 p_validation_level => p_validation_level,
84 x_return_status => x_return_status,
85 x_msg_count => x_msg_count ,
86 x_msg_data => x_msg_data ,
87 -- Receipt info. parameters
88 p_usr_currency_code => p_usr_currency_code, --the translated currency code
89 p_currency_code => p_currency_code ,
90 p_usr_exchange_rate_type => p_usr_exchange_rate_type ,
91 p_exchange_rate_type => p_exchange_rate_type ,
92 p_exchange_rate => p_exchange_rate ,
93 p_exchange_rate_date => p_exchange_rate_date ,
94 p_amount => p_amount,
95 p_factor_discount_amount => p_factor_discount_amount ,
96 p_receipt_number => p_receipt_number,
97 p_receipt_date => p_receipt_date,
98 p_gl_date => p_gl_date,
99 p_maturity_date => p_maturity_date ,
100 p_postmark_date => p_postmark_date ,
101 p_customer_id => p_customer_id ,
102 p_customer_name => p_customer_name,
103 p_customer_number => p_customer_number ,
104 p_customer_bank_account_id => p_customer_bank_account_id,
105 p_customer_bank_account_num => p_customer_bank_account_num ,
106 p_customer_bank_account_name => p_customer_bank_account_name ,
107 p_location => p_location ,
108 p_customer_site_use_id => p_customer_site_use_id ,
109 p_customer_receipt_reference => p_customer_receipt_reference ,
110 p_override_remit_account_flag => p_override_remit_account_flag ,
111 p_remittance_bank_account_id => p_remittance_bank_account_id ,
112 p_remittance_bank_account_num => p_remittance_bank_account_num ,
113 p_remittance_bank_account_name => p_remittance_bank_account_name ,
114 p_deposit_date => p_deposit_date ,
115 p_receipt_method_id => p_receipt_method_id ,
116 p_receipt_method_name => p_receipt_method_name ,
117 p_doc_sequence_value => p_doc_sequence_value ,
118 p_ussgl_transaction_code => p_ussgl_transaction_code ,
119 p_anticipated_clearing_date => p_anticipated_clearing_date ,
120 p_called_from => p_called_from ,
121 p_attribute_rec => p_attribute_rec ,
122 -- ******* Global Flexfield parameters *******
123 p_global_attribute_rec => p_global_attribute_rec ,
124 p_comments => p_comments ,
125 -- *** Notes Receivable Additional Information ***
126 p_issuer_name => p_issuer_name ,
127 p_issue_date => p_issue_date ,
128 p_issuer_bank_branch_id => p_issuer_bank_branch_id ,
129 -- ** OUT NOCOPY variables
130 p_cr_id => p_cr_id
131 ) ;
132 END Create_Cash;
133
134 PROCEDURE Apply(
135 -- Standard API parameters.
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2,
138 p_commit IN VARCHAR2,
139 p_validation_level IN NUMBER ,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 -- Receipt application parameters.
144 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
145 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
146 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
147 p_trx_number IN ra_customer_trx.trx_number%TYPE ,
148 p_installment IN ar_payment_schedules.terms_sequence_number%TYPE ,
149 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE ,
150 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
151 -- this is the allocated receipt amount
152 p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE ,
153 p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE ,
154 p_discount IN ar_receivable_applications.earned_discount_taken%TYPE ,
155 p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
156 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
157 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
158 p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE ,
159 p_line_number IN ra_customer_trx_lines.line_number%TYPE ,
160 p_show_closed_invoices IN VARCHAR2 , /* Bug fix 2462013 */
161 p_called_from IN VARCHAR2 ,
162 p_move_deferred_tax IN VARCHAR2 ,
163 p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE ,
164 p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
165 -- ******* Global Flexfield parameters *******
166 p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
167 p_comments IN ar_receivable_applications.comments%TYPE ,
168 p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
169 p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE ,
170 p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE ,
171 p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE ,
172 p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE ,
173 p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE ,
174 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
175 p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
176 )
177 IS
178
179 BEGIN
180
181 -- Call the receipt API
182 AR_Receipt_API_PUB.Apply(
183 -- Standard API parameters.
184 p_api_version => p_api_version,
185 p_init_msg_list => p_init_msg_list,
186 p_commit => p_commit,
187 p_validation_level => p_validation_level,
188 x_return_status => x_return_status,
189 x_msg_count => x_msg_count ,
190 x_msg_data => x_msg_data ,
191 -- Receipt info. parameters
192 p_cash_receipt_id => p_cash_receipt_id,
193 p_receipt_number => p_receipt_number,
194 p_customer_trx_id => p_customer_trx_id,
195 p_trx_number => p_trx_number ,
196 p_installment => p_installment ,
197 p_applied_payment_schedule_id => p_applied_payment_schedule_id ,
198 p_amount_applied => p_amount_applied ,
199 -- this is the allocated receipt amount
200 p_amount_applied_from =>p_amount_applied_from ,
201 p_trans_to_receipt_rate => p_trans_to_receipt_rate ,
202 p_discount => p_discount ,
203 p_apply_date => p_apply_date ,
204 p_apply_gl_date => p_apply_gl_date ,
205 p_ussgl_transaction_code => p_ussgl_transaction_code ,
206 p_customer_trx_line_id => p_customer_trx_line_id ,
207 p_line_number => p_line_number ,
208 p_show_closed_invoices => p_show_closed_invoices , /* Bug fix 2462013 */
209 p_called_from => p_called_from ,
210 p_move_deferred_tax => p_move_deferred_tax ,
211 p_link_to_trx_hist_id => p_link_to_trx_hist_id,
212 p_attribute_rec => p_attribute_rec ,
213 -- ******* Global Flexfield parameters *******
214 p_global_attribute_rec => p_global_attribute_rec ,
215 p_comments => p_comments ,
216 p_payment_set_id => p_payment_set_id,
217 p_application_ref_type => p_application_ref_type,
218 p_application_ref_id => p_application_ref_id,
219 p_application_ref_num => p_application_ref_num,
220 p_secondary_application_ref_id => p_secondary_application_ref_id,
221 p_application_ref_reason => p_application_ref_reason,
222 p_customer_reference => p_customer_reference,
223 p_customer_reason => p_customer_reason
224 ) ;
225 END Apply;
226
227 PROCEDURE Unapply(
228 -- Standard API parameters.
229 p_api_version IN NUMBER,
230 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231 p_commit IN VARCHAR2 := FND_API.G_FALSE,
232 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233 x_return_status OUT NOCOPY VARCHAR2 ,
234 x_msg_count OUT NOCOPY NUMBER ,
235 x_msg_data OUT NOCOPY VARCHAR2 ,
236 -- *** Receipt Info. parameters *****
237 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
238 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
239 p_trx_number IN ra_customer_trx.trx_number%TYPE ,
240 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
241 p_installment IN ar_payment_schedules.terms_sequence_number%TYPE ,
242 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE ,
243 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE ,
244 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
245 p_called_from IN VARCHAR2 ,
246 p_cancel_claim_flag IN VARCHAR2
247 )
248 IS
249
250 BEGIN
251
252 -- Call the receipt API
253 AR_Receipt_API_PUB.Unapply(
254 -- Standard API parameters.
255 p_api_version => p_api_version,
256 p_init_msg_list => p_init_msg_list,
257 p_commit => p_commit,
258 p_validation_level => p_validation_level,
259 x_return_status => x_return_status,
260 x_msg_count => x_msg_count ,
261 x_msg_data => x_msg_data ,
262 -- Receipt info. parameters
263 p_receipt_number => p_receipt_number,
264 p_cash_receipt_id => p_cash_receipt_id,
265 p_trx_number => p_trx_number ,
266 p_customer_trx_id => p_customer_trx_id,
267 p_installment => p_installment ,
268 p_applied_payment_schedule_id => p_applied_payment_schedule_id ,
269 p_receivable_application_id => p_receivable_application_id,
270 p_reversal_gl_date => p_reversal_gl_date,
271 p_called_from => p_called_from,
272 p_cancel_claim_flag => p_cancel_claim_flag
273 );
274 END Unapply;
275
276 PROCEDURE Create_and_apply(
277 -- Standard API parameters.
278 p_api_version IN NUMBER,
279 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280 p_commit IN VARCHAR2 := FND_API.G_FALSE,
281 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
282 x_return_status OUT NOCOPY VARCHAR2,
283 x_msg_count OUT NOCOPY NUMBER,
284 x_msg_data OUT NOCOPY VARCHAR2,
285 -- Receipt info. parameters
286 p_usr_currency_code IN VARCHAR2 , --the translated currency code
287 p_currency_code IN ar_cash_receipts.currency_code%TYPE ,
288 p_usr_exchange_rate_type IN VARCHAR2 ,
289 p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE ,
290 p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE ,
291 p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE ,
292 p_amount IN ar_cash_receipts.amount%TYPE ,
293 p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE ,
294 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
295 p_receipt_date IN ar_cash_receipts.receipt_date%TYPE ,
296 p_gl_date IN ar_cash_receipt_history.gl_date%TYPE ,
297 p_maturity_date IN DATE ,
298 p_postmark_date IN DATE ,
299 p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE ,
300 p_customer_name IN hz_parties.party_name%TYPE ,
301 p_customer_number IN hz_cust_accounts.account_number%TYPE ,
302 p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE ,
303 p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE ,
304 p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE ,
305 p_location IN hz_cust_site_uses.location%TYPE ,
306 p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE ,
307 p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE ,
308 p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE ,
309 p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE ,
310 p_remittance_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE ,
311 p_remittance_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE ,
312 p_deposit_date IN ar_cash_receipts.deposit_date%TYPE ,
313 p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE ,
314 p_receipt_method_name IN ar_receipt_methods.name%TYPE ,
315 p_doc_sequence_value IN NUMBER ,
316 p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE ,
317 p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE ,
318 p_called_from IN VARCHAR2 ,
319 p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
320 -- ******* Global Flexfield parameters *******
321 p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
322 p_receipt_comments IN VARCHAR2 ,
323 -- *** Notes Receivable Additional Information ***
324 p_issuer_name IN ar_cash_receipts.issuer_name%TYPE ,
325 p_issue_date IN ar_cash_receipts.issue_date%TYPE ,
326 p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE ,
327 -- ** OUT NOCOPY variables for Creating receipt
328 p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
329 -- Receipt application parameters
330 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
331 p_trx_number IN ra_customer_trx.trx_number%TYPE ,
332 p_installment IN ar_payment_schedules.terms_sequence_number%TYPE ,
333 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE ,
334 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
335 -- this is the allocated receipt amount
336 p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE ,
337 p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE ,
338 p_discount IN ar_receivable_applications.earned_discount_taken%TYPE ,
339 p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
340 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
341 app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
342 p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE ,
343 p_line_number IN ra_customer_trx_lines.line_number%TYPE ,
344 p_show_closed_invoices IN VARCHAR2 , /* Bug fix 2462013 */
345 p_move_deferred_tax IN VARCHAR2 ,
346 p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE ,
347 app_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
348 -- ******* Global Flexfield parameters *******
349 app_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
350 app_comments IN ar_receivable_applications.comments%TYPE ,
351 -- OSTEINME 3/9/2001: added flag that indicates whether to call payment
352 -- processor such as iPayments
353 p_call_payment_processor IN VARCHAR2
354
355 -- OUT NOCOPY parameter for the Application
356 )
357 IS
358
359 BEGIN
360
361 -- Call the receipt API
362 AR_Receipt_API_PUB.Create_and_apply(
363 -- Standard API parameters.
364 p_api_version => p_api_version,
365 p_init_msg_list => p_init_msg_list,
366 p_commit => p_commit,
367 p_validation_level => p_validation_level,
368 x_return_status => x_return_status,
369 x_msg_count => x_msg_count ,
370 x_msg_data => x_msg_data ,
371 -- Receipt info. parameters
372 p_usr_currency_code => p_usr_currency_code, --the translated currency code
373 p_currency_code => p_currency_code ,
374 p_usr_exchange_rate_type => p_usr_exchange_rate_type ,
375 p_exchange_rate_type => p_exchange_rate_type ,
376 p_exchange_rate => p_exchange_rate ,
377 p_exchange_rate_date => p_exchange_rate_date ,
378 p_amount => p_amount,
379 p_factor_discount_amount => p_factor_discount_amount ,
380 p_receipt_number => p_receipt_number,
381 p_receipt_date => p_receipt_date,
382 p_gl_date => p_gl_date,
383 p_maturity_date => p_maturity_date ,
384 p_postmark_date => p_postmark_date ,
385 p_customer_id => p_customer_id ,
386 p_customer_name => p_customer_name,
387 p_customer_number => p_customer_number ,
388 p_customer_bank_account_id => p_customer_bank_account_id,
389 p_customer_bank_account_num => p_customer_bank_account_num ,
390 p_customer_bank_account_name => p_customer_bank_account_name ,
391 p_location => p_location ,
392 p_customer_site_use_id => p_customer_site_use_id ,
393 p_customer_receipt_reference => p_customer_receipt_reference ,
394 p_override_remit_account_flag => p_override_remit_account_flag ,
395 p_remittance_bank_account_id => p_remittance_bank_account_id ,
396 p_remittance_bank_account_num => p_remittance_bank_account_num ,
397 p_remittance_bank_account_name => p_remittance_bank_account_name ,
398 p_deposit_date => p_deposit_date ,
399 p_receipt_method_id => p_receipt_method_id ,
400 p_receipt_method_name => p_receipt_method_name ,
401 p_doc_sequence_value => p_doc_sequence_value ,
402 p_ussgl_transaction_code => p_ussgl_transaction_code ,
403 p_anticipated_clearing_date => p_anticipated_clearing_date ,
404 p_called_from => p_called_from ,
405 p_attribute_rec => p_attribute_rec ,
406 -- ******* Global Flexfield parameters *******
407 p_global_attribute_rec => p_global_attribute_rec ,
408 p_receipt_comments => p_receipt_comments,
409 -- *** Notes Receivable Additional Information ***
410 p_issuer_name => p_issuer_name ,
411 p_issue_date => p_issue_date ,
412 p_issuer_bank_branch_id => p_issuer_bank_branch_id ,
413 -- ** OUT NOCOPY variables
414 p_cr_id => p_cr_id,
415 p_customer_trx_id => p_customer_trx_id,
416 p_trx_number => p_trx_number ,
417 p_installment => p_installment ,
418 p_applied_payment_schedule_id => p_applied_payment_schedule_id ,
419 p_amount_applied => p_amount_applied ,
420 -- this is the allocated receipt amount
421 p_amount_applied_from =>p_amount_applied_from ,
422 p_trans_to_receipt_rate => p_trans_to_receipt_rate ,
423 p_discount => p_discount ,
424 p_apply_date => p_apply_date ,
425 p_apply_gl_date => p_apply_gl_date ,
426 app_ussgl_transaction_code => app_ussgl_transaction_code ,
427 p_customer_trx_line_id => p_customer_trx_line_id ,
428 p_line_number => p_line_number ,
429 p_show_closed_invoices => p_show_closed_invoices , /* Bug fix 2462013 */
430 p_move_deferred_tax => p_move_deferred_tax ,
431 p_link_to_trx_hist_id => p_link_to_trx_hist_id,
432 app_attribute_rec => app_attribute_rec ,
433 -- ******* Global Flexfield parameters *******
434 app_global_attribute_rec => app_global_attribute_rec ,
435 app_comments => app_comments ,
436 p_call_payment_processor => p_call_payment_processor) ;
437 END Create_and_apply;
438
439
440 PROCEDURE Reverse(
441 -- Standard API parameters.
442 p_api_version IN NUMBER,
443 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
444 p_commit IN VARCHAR2 := FND_API.G_FALSE,
445 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
446 x_return_status OUT NOCOPY VARCHAR2,
447 x_msg_count OUT NOCOPY NUMBER,
448 x_msg_data OUT NOCOPY VARCHAR2,
449 -- Receipt reversal related parameters
450 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
451 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
452 p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE ,
453 p_reversal_category_name IN ar_lookups.meaning%TYPE ,
454 p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE ,
455 p_reversal_date IN ar_cash_receipts.reversal_date%TYPE ,
456 p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE ,
457 p_reversal_reason_name IN ar_lookups.meaning%TYPE ,
458 p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE ,
459 p_called_from IN VARCHAR2 ,
460 p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
461 p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
462 p_cancel_claims_flag IN VARCHAR2
463 )
464 IS
465
466 BEGIN
467
468 -- Call the receipt API
469 AR_Receipt_API_PUB.Reverse(
470 -- Standard API parameters.
471 p_api_version => p_api_version,
472 p_init_msg_list => p_init_msg_list,
473 p_commit => p_commit,
474 p_validation_level => p_validation_level,
475 x_return_status => x_return_status,
476 x_msg_count => x_msg_count ,
477 x_msg_data => x_msg_data ,
478 -- Receipt info. parameters
479 p_cash_receipt_id => p_cash_receipt_id,
480 p_receipt_number => p_receipt_number,
481 p_reversal_category_code => p_reversal_category_code,
482 p_reversal_category_name => p_reversal_category_name,
483 p_reversal_gl_date => p_reversal_gl_date,
484 p_reversal_date => p_reversal_date,
485 p_reversal_reason_code => p_reversal_reason_code,
486 p_reversal_reason_name => p_reversal_reason_name,
487 p_reversal_comments => p_reversal_comments,
488 p_called_from => p_called_from,
489 p_attribute_rec => p_attribute_rec ,
490 p_global_attribute_rec => p_global_attribute_rec ,
491 p_cancel_claims_flag => p_cancel_claims_flag
492 );
493 END Reverse;
494
495 PROCEDURE Apply_on_account(
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 application parameters.
505 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
506 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
507 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
508 p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
509 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
510 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
511 p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
512 -- ******* Global Flexfield parameters *******
513 p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
514 p_comments IN ar_receivable_applications.comments%TYPE ,
515 p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE ,
516 p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE ,
517 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
518 p_called_from IN VARCHAR2
519 )
520 IS
521
522 BEGIN
523
524 -- Call the receipt API
525 AR_Receipt_API_PUB.Apply_on_account(
526 -- Standard API parameters.
527 p_api_version => p_api_version,
528 p_init_msg_list => p_init_msg_list,
529 p_commit => p_commit,
530 p_validation_level => p_validation_level,
531 x_return_status => x_return_status,
532 x_msg_count => x_msg_count ,
533 x_msg_data => x_msg_data ,
534 -- Receipt info. parameters
535 p_cash_receipt_id => p_cash_receipt_id,
536 p_receipt_number => p_receipt_number,
537 p_amount_applied => p_amount_applied ,
538 p_apply_date => p_apply_date ,
539 p_apply_gl_date => p_apply_gl_date ,
540 p_ussgl_transaction_code => p_ussgl_transaction_code ,
541 p_attribute_rec => p_attribute_rec ,
542 -- ******* Global Flexfield parameters *******
543 p_global_attribute_rec => p_global_attribute_rec ,
544 p_comments => p_comments ,
545 p_application_ref_num => p_application_ref_num,
546 p_secondary_application_ref_id => p_secondary_application_ref_id,
547 p_customer_reference => p_customer_reference,
548 p_called_from => p_called_from
549 ) ;
550 END Apply_on_account;
551
552 PROCEDURE Unapply_on_account(
553 -- Standard API parameters.
554 p_api_version IN NUMBER,
555 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
556 p_commit IN VARCHAR2 := FND_API.G_FALSE,
557 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
558 x_return_status OUT NOCOPY VARCHAR2 ,
559 x_msg_count OUT NOCOPY NUMBER ,
560 x_msg_data OUT NOCOPY VARCHAR2 ,
561 -- *** Receipt Info. parameters *****
562 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
563 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
564 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE ,
565 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE
566 )
567 IS
568
569 BEGIN
570
571 -- Call the receipt API
572 AR_Receipt_API_PUB.Unapply_on_account(
573 -- Standard API parameters.
574 p_api_version => p_api_version,
575 p_init_msg_list => p_init_msg_list,
576 p_commit => p_commit,
577 p_validation_level => p_validation_level,
578 x_return_status => x_return_status,
579 x_msg_count => x_msg_count ,
580 x_msg_data => x_msg_data ,
581 -- Receipt info. parameters
582 p_receipt_number => p_receipt_number,
583 p_cash_receipt_id => p_cash_receipt_id,
584 p_receivable_application_id => p_receivable_application_id,
585 p_reversal_gl_date => p_reversal_gl_date
586 );
587 END Unapply_on_account;
588
589 PROCEDURE Activity_application(
590 -- Standard API parameters.
591 p_api_version IN NUMBER,
592 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
593 p_commit IN VARCHAR2 := FND_API.G_FALSE,
594 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
595 x_return_status OUT NOCOPY VARCHAR2,
596 x_msg_count OUT NOCOPY NUMBER,
597 x_msg_data OUT NOCOPY VARCHAR2,
598 -- Receipt application parameters.
599 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
600 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
601 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
602 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
603 p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
604 p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
605 p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
606 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
607 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
608 p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
609 -- ******* Global Flexfield parameters *******
610 p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
611 p_comments IN ar_receivable_applications.comments%TYPE ,
612 p_application_ref_type IN OUT NOCOPY
613 ar_receivable_applications.application_ref_type%TYPE,
614 p_application_ref_id IN OUT NOCOPY
615 ar_receivable_applications.application_ref_id%TYPE,
616 p_application_ref_num IN OUT NOCOPY
617 ar_receivable_applications.application_ref_num%TYPE,
618 p_secondary_application_ref_id IN OUT NOCOPY
619 ar_receivable_applications.secondary_application_ref_id%TYPE,
620 p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
621 p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
622 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
623 p_val_writeoff_limits_flag IN VARCHAR2 ,
624 p_called_from IN VARCHAR2
625 )
626 IS
627
628 BEGIN
629
630 -- Call the receipt API
631 AR_Receipt_API_PUB.Activity_application(
632 -- Standard API parameters.
633 p_api_version => p_api_version,
634 p_init_msg_list => p_init_msg_list,
635 p_commit => p_commit,
636 p_validation_level => p_validation_level,
637 x_return_status => x_return_status,
638 x_msg_count => x_msg_count ,
639 x_msg_data => x_msg_data ,
640 -- Receipt info. parameters
641 p_cash_receipt_id => p_cash_receipt_id,
642 p_receipt_number => p_receipt_number,
643 p_amount_applied => p_amount_applied ,
644 p_applied_payment_schedule_id => p_applied_payment_schedule_id ,
645 p_link_to_customer_trx_id => p_link_to_customer_trx_id ,
646 p_receivables_trx_id => p_receivables_trx_id ,
647 p_apply_date => p_apply_date ,
648 p_apply_gl_date => p_apply_gl_date ,
649 p_ussgl_transaction_code => p_ussgl_transaction_code ,
650 p_attribute_rec => p_attribute_rec ,
651 -- ******* Global Flexfield parameters *******
652 p_global_attribute_rec => p_global_attribute_rec ,
653 p_comments => p_comments ,
654 p_application_ref_type => p_application_ref_type,
655 p_application_ref_id => p_application_ref_id,
656 p_application_ref_num => p_application_ref_num,
657 p_secondary_application_ref_id => p_secondary_application_ref_id,
658 p_payment_set_id => p_payment_set_id,
659 p_receivable_application_id => p_receivable_application_id,
660 p_customer_reference => p_customer_reference,
661 p_val_writeoff_limits_flag => p_val_writeoff_limits_flag,
662 p_called_from => p_called_from
663 ) ;
664 END Activity_application;
665
666 PROCEDURE Activity_unapplication(
667 -- Standard API parameters.
668 p_api_version IN NUMBER,
669 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
670 p_commit IN VARCHAR2 := FND_API.G_FALSE,
671 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
672 x_return_status OUT NOCOPY VARCHAR2 ,
673 x_msg_count OUT NOCOPY NUMBER ,
674 x_msg_data OUT NOCOPY VARCHAR2 ,
675 -- *** Receipt Info. parameters *****
676 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
677 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
678 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE ,
679 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
680 p_called_from IN VARCHAR2
681 )
682 IS
683
684 BEGIN
685
686 -- Call the receipt API
687 AR_Receipt_API_PUB.Activity_Unapplication(
688 -- Standard API parameters.
689 p_api_version => p_api_version,
690 p_init_msg_list => p_init_msg_list,
691 p_commit => p_commit,
692 p_validation_level => p_validation_level,
693 x_return_status => x_return_status,
694 x_msg_count => x_msg_count ,
695 x_msg_data => x_msg_data ,
696 -- Receipt info. parameters
697 p_receipt_number => p_receipt_number,
698 p_cash_receipt_id => p_cash_receipt_id,
699 p_receivable_application_id => p_receivable_application_id,
700 p_reversal_gl_date => p_reversal_gl_date,
701 p_called_from => p_called_from
702 );
703 END Activity_Unapplication;
704
705 PROCEDURE Apply_other_account(
706 -- Standard API parameters.
707 p_api_version IN NUMBER,
708 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
709 p_commit IN VARCHAR2 := FND_API.G_FALSE,
710 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
711 x_return_status OUT NOCOPY VARCHAR2,
712 x_msg_count OUT NOCOPY NUMBER,
713 x_msg_data OUT NOCOPY VARCHAR2,
714 p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
715 -- Receipt application parameters.
716 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
717 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
718 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
719 p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE ,
720 p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE ,
721 p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
722 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
723 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
724 p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE ,
725 p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
726 p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
727 p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
728 p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE ,
729 p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
730 -- ******* Global Flexfield parameters *******
731 p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
732 p_comments IN ar_receivable_applications.comments%TYPE ,
733 p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE ,
734 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE ,
735 p_customer_reason IN ar_receivable_applications.customer_reason%TYPE ,
736 p_called_from IN VARCHAR2
737 )
738 IS
739
740 BEGIN
741
742 -- Call the receipt API
743 AR_Receipt_API_PUB.Apply_other_account(
744 -- Standard API parameters.
745 p_api_version => p_api_version,
746 p_init_msg_list => p_init_msg_list,
747 p_commit => p_commit,
748 p_validation_level => p_validation_level,
749 x_return_status => x_return_status,
750 x_msg_count => x_msg_count ,
751 x_msg_data => x_msg_data ,
752 p_receivable_application_id => p_receivable_application_id,
753 -- Receipt info. parameters
754 p_cash_receipt_id => p_cash_receipt_id,
755 p_receipt_number => p_receipt_number,
756 p_amount_applied => p_amount_applied ,
757 p_receivables_trx_id => p_receivables_trx_id ,
758 p_applied_payment_schedule_id => p_applied_payment_schedule_id ,
759 p_apply_date => p_apply_date ,
760 p_apply_gl_date => p_apply_gl_date ,
761 p_ussgl_transaction_code => p_ussgl_transaction_code ,
762 p_application_ref_type => p_application_ref_type,
763 p_application_ref_id => p_application_ref_id,
764 p_application_ref_num => p_application_ref_num,
765 p_secondary_application_ref_id => p_secondary_application_ref_id,
766 p_payment_set_id => p_payment_set_id,
767 p_attribute_rec => p_attribute_rec ,
768 -- ******* Global Flexfield parameters *******
769 p_global_attribute_rec => p_global_attribute_rec ,
770 p_comments => p_comments ,
771 p_application_ref_reason => p_application_ref_reason,
772 p_customer_reference => p_customer_reference,
773 p_customer_reason => p_customer_reason,
774 p_called_from => p_called_from
775 ) ;
776 END Apply_other_account;
777
778 PROCEDURE Unapply_other_account(
779 -- Standard API parameters.
780 p_api_version IN NUMBER,
781 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
782 p_commit IN VARCHAR2 := FND_API.G_FALSE,
783 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
784 x_return_status OUT NOCOPY VARCHAR2 ,
785 x_msg_count OUT NOCOPY NUMBER ,
786 x_msg_data OUT NOCOPY VARCHAR2 ,
787 -- *** Receipt Info. parameters *****
788 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
789 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
790 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
791 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
792 p_cancel_claim_flag IN VARCHAR2 ,
793 p_called_from IN VARCHAR2
794 )
795 IS
796
797 BEGIN
798
799 -- Call the receipt API
800 AR_Receipt_API_PUB.Unapply_other_account(
801 -- Standard API parameters.
802 p_api_version => p_api_version,
803 p_init_msg_list => p_init_msg_list,
804 p_commit => p_commit,
805 p_validation_level => p_validation_level,
806 x_return_status => x_return_status,
807 x_msg_count => x_msg_count ,
808 x_msg_data => x_msg_data ,
809 -- Receipt info. parameters
810 p_receipt_number => p_receipt_number,
811 p_cash_receipt_id => p_cash_receipt_id,
812 p_receivable_application_id => p_receivable_application_id,
813 p_reversal_gl_date => p_reversal_gl_date,
814 p_cancel_claim_flag => p_cancel_claim_flag,
815 p_called_from => p_called_from
816 );
817 END Unapply_other_account;
818
819 PROCEDURE create_misc(
820 -- Standard API parameters.
821 p_api_version IN NUMBER,
822 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
823 p_commit IN VARCHAR2 := FND_API.G_FALSE,
824 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
825 x_return_status OUT NOCOPY VARCHAR2 ,
826 x_msg_count OUT NOCOPY NUMBER ,
827 x_msg_data OUT NOCOPY VARCHAR2 ,
828 -- Misc Receipt info. parameters
829 p_usr_currency_code IN VARCHAR2 , --the translated currency code
830 p_currency_code IN VARCHAR2 ,
831 p_usr_exchange_rate_type IN VARCHAR2 ,
832 p_exchange_rate_type IN VARCHAR2 ,
833 p_exchange_rate IN NUMBER ,
834 p_exchange_rate_date IN DATE ,
835 p_amount IN NUMBER,
836 p_receipt_number IN OUT NOCOPY VARCHAR2,
837 p_receipt_date IN DATE ,
838 p_gl_date IN DATE ,
839 p_receivables_trx_id IN NUMBER ,
840 p_activity IN VARCHAR2 ,
841 p_misc_payment_source IN VARCHAR2 ,
842 p_tax_code IN VARCHAR2 ,
843 p_vat_tax_id IN VARCHAR2 ,
844 p_tax_rate IN NUMBER ,
845 p_tax_amount IN NUMBER ,
846 p_deposit_date IN DATE ,
847 p_reference_type IN VARCHAR2 ,
848 p_reference_num IN VARCHAR2 ,
849 p_reference_id IN NUMBER ,
850 p_remittance_bank_account_id IN NUMBER ,
851 p_remittance_bank_account_num IN VARCHAR2 ,
852 p_remittance_bank_account_name IN VARCHAR2 ,
853 p_receipt_method_id IN NUMBER ,
854 p_receipt_method_name IN VARCHAR2 ,
855 p_doc_sequence_value IN NUMBER ,
856 p_ussgl_transaction_code IN VARCHAR2 ,
857 p_anticipated_clearing_date IN DATE ,
858 p_attribute_record IN ar_receipt_api_pub.attribute_rec_type ,
859 p_global_attribute_record IN ar_receipt_api_pub.global_attribute_rec_type ,
860 p_comments IN VARCHAR2 ,
861 p_misc_receipt_id OUT NOCOPY NUMBER)
862 IS
863
864 BEGIN
865
866 -- Call the receipt API
867 AR_Receipt_API_PUB.Create_misc(
868 -- Standard API parameters.
869 p_api_version => p_api_version,
870 p_init_msg_list => p_init_msg_list,
871 p_commit => p_commit,
872 p_validation_level => p_validation_level,
873 x_return_status => x_return_status,
874 x_msg_count => x_msg_count ,
875 x_msg_data => x_msg_data ,
876 -- Receipt info. parameters
877 p_usr_currency_code => p_usr_currency_code, --the translated currency code
878 p_currency_code => p_currency_code ,
879 p_usr_exchange_rate_type => p_usr_exchange_rate_type ,
880 p_exchange_rate_type => p_exchange_rate_type ,
881 p_exchange_rate => p_exchange_rate ,
882 p_exchange_rate_date => p_exchange_rate_date ,
883 p_amount => p_amount,
884 p_receipt_number => p_receipt_number,
885 p_receipt_date => p_receipt_date,
886 p_gl_date => p_gl_date,
887 p_receivables_trx_id => p_receivables_trx_id ,
888 p_activity => p_activity ,
889 p_misc_payment_source => p_misc_payment_source ,
890 p_tax_code => p_tax_code,
891 p_vat_tax_id => p_vat_tax_id,
892 p_tax_rate => p_tax_rate,
893 p_tax_amount => p_tax_amount,
894 p_deposit_date => p_deposit_date ,
895 p_reference_type => p_reference_type ,
896 p_reference_num => p_reference_num ,
897 p_reference_id => p_reference_id ,
898 p_remittance_bank_account_id => p_remittance_bank_account_id ,
899 p_remittance_bank_account_num => p_remittance_bank_account_num ,
900 p_remittance_bank_account_name => p_remittance_bank_account_name ,
901 p_receipt_method_id => p_receipt_method_id ,
902 p_receipt_method_name => p_receipt_method_name ,
903 p_doc_sequence_value => p_doc_sequence_value ,
904 p_ussgl_transaction_code => p_ussgl_transaction_code ,
905 p_anticipated_clearing_date => p_anticipated_clearing_date ,
906 p_attribute_record => p_attribute_record ,
907 p_global_attribute_record => p_global_attribute_record ,
908 p_comments => p_comments ,
909 p_misc_receipt_id => p_misc_receipt_id
910 ) ;
911 END Create_misc;
912
913 PROCEDURE Apply_Open_Receipt(
914 -- Standard API parameters.
915 p_api_version IN NUMBER,
916 p_init_msg_list IN VARCHAR2 ,
917 p_commit IN VARCHAR2 ,
918 p_validation_level IN NUMBER ,
919 x_return_status OUT NOCOPY VARCHAR2,
920 x_msg_count OUT NOCOPY NUMBER,
921 x_msg_data OUT NOCOPY VARCHAR2,
922 -- Receipt application parameters.
923 p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
924 p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
925 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
926 p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
927 p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
928 p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE ,
929 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
930 p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
931 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
932 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,
933 p_called_from IN VARCHAR2 ,
934 p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
935 -- ******* Global Flexfield parameters *******
936 p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
937 p_comments IN ar_receivable_applications.comments%TYPE ,
938 x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
939 x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
940 x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE
941 )
942 IS
943
944 l_acctd_amount_applied_from NUMBER;
945 l_acctd_amount_applied_to NUMBER;
946
947 BEGIN
948
949 -- Call the receipt API
950 AR_Receipt_API_PUB.Apply_open_receipt(
951 -- Standard API parameters.
952 p_api_version => p_api_version,
953 p_init_msg_list => p_init_msg_list,
954 p_commit => p_commit,
955 p_validation_level => p_validation_level,
956 x_return_status => x_return_status,
957 x_msg_count => x_msg_count ,
958 x_msg_data => x_msg_data ,
959 -- Receipt info. parameters
960 p_cash_receipt_id => p_cash_receipt_id,
961 p_receipt_number => p_receipt_number,
962 p_applied_payment_schedule_id => p_applied_payment_schedule_id ,
963 p_open_cash_receipt_id => p_open_cash_receipt_id,
964 p_open_receipt_number => p_open_receipt_number,
965 p_open_rec_app_id => p_open_rec_app_id ,
966 p_amount_applied => p_amount_applied ,
967 p_apply_date => p_apply_date ,
968 p_apply_gl_date => p_apply_gl_date ,
969 p_ussgl_transaction_code => p_ussgl_transaction_code ,
970 p_called_from => p_called_from ,
971 p_attribute_rec => p_attribute_rec ,
972 -- ******* Global Flexfield parameters *******
973 p_global_attribute_rec => p_global_attribute_rec ,
974 p_comments => p_comments ,
975 x_application_ref_num => x_application_ref_num ,
976 x_receivable_application_id => x_receivable_application_id,
977 x_applied_rec_app_id => x_applied_rec_app_id,
978 x_acctd_amount_applied_from => l_acctd_amount_applied_from,
979 x_acctd_amount_applied_to => l_acctd_amount_applied_to
980 ) ;
981 END Apply_open_receipt;
982
983 PROCEDURE Unapply_Open_Receipt(
984 -- Standard API parameters.
985 p_api_version IN NUMBER,
986 p_init_msg_list IN VARCHAR2 ,
987 p_commit IN VARCHAR2 ,
988 p_validation_level IN NUMBER ,
989 x_return_status OUT NOCOPY VARCHAR2 ,
990 x_msg_count OUT NOCOPY NUMBER ,
991 x_msg_data OUT NOCOPY VARCHAR2 ,
992 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
993 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
994 p_called_from IN VARCHAR2 )
995 IS
996
997 BEGIN
998
999 -- Call the receipt API
1000 AR_Receipt_API_PUB.Unapply_open_receipt(
1001 -- Standard API parameters.
1002 p_api_version => p_api_version,
1003 p_init_msg_list => p_init_msg_list,
1004 p_commit => p_commit,
1005 p_validation_level => p_validation_level,
1006 x_return_status => x_return_status,
1007 x_msg_count => x_msg_count ,
1008 x_msg_data => x_msg_data ,
1009 p_receivable_application_id => p_receivable_application_id,
1010 p_reversal_gl_date => p_reversal_gl_date,
1011 p_called_from => p_called_from
1012 );
1013 END Unapply_open_receipt;
1014
1015 END AR_RECEIPT_API_COVER;