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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 *******
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 ,
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,
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
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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
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 ,
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 ,
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: )
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
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 ,
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
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
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: )
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 ,
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 ,
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 ,
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
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 ,
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 ,
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 ,
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 ,