eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PROC_RECEIPTS2 dependencies on AR_CASH_RECEIPT_HISTORY

Line 30: | AR_CASH_RECEIPT_HISTORY |

26: | Function inserts a cash receipt into the database. This entity |
27: | handler is called from the Receipts Gateway form and creates records |
28: | in the following tables: |
29: | AR_CASH_RECEIPTS |
30: | AR_CASH_RECEIPT_HISTORY |
31: | AR_DISTRIBUTIONS |
32: | AR_RECEIVABLE_APPLICATIONS |
33: | AR_PAYMENT_SCHEDULES |
34: | |

Line 180: l_crh_rec ar_cash_receipt_history%ROWTYPE;

176: p_le_id IN NUMBER DEFAULT NULL, /* LE */
177: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL /* payment uptake */
178: ) IS
179: l_cr_rec ar_cash_receipts%ROWTYPE;
180: l_crh_rec ar_cash_receipt_history%ROWTYPE;
181: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
182: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
183: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
184: l_ra_ccid ar_receivable_applications.code_combination_id%TYPE;

Line 183: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;

179: l_cr_rec ar_cash_receipts%ROWTYPE;
180: l_crh_rec ar_cash_receipt_history%ROWTYPE;
181: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
182: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
183: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
184: l_ra_ccid ar_receivable_applications.code_combination_id%TYPE;
185: l_ra_unid_ccid ar_receivable_applications.code_combination_id%TYPE;
186: l_ra_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
187: l_source_type ar_distributions.source_type%TYPE;

Line 190: l_creation_status ar_cash_receipt_history.status%TYPE;

186: l_ra_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
187: l_source_type ar_distributions.source_type%TYPE;
188: l_override_dummy
189: ar_receipt_method_accounts.override_remit_account_flag%TYPE;
190: l_creation_status ar_cash_receipt_history.status%TYPE;
191: l_status ar_cash_receipts.status%TYPE;
192: l_crh_amount ar_cash_receipt_history.amount%TYPE;
193: l_cr_acctd_amount ar_payment_schedules.acctd_amount_due_remaining%TYPE;
194: l_crh_acctd_amount ar_cash_receipt_history.amount%TYPE;

Line 192: l_crh_amount ar_cash_receipt_history.amount%TYPE;

188: l_override_dummy
189: ar_receipt_method_accounts.override_remit_account_flag%TYPE;
190: l_creation_status ar_cash_receipt_history.status%TYPE;
191: l_status ar_cash_receipts.status%TYPE;
192: l_crh_amount ar_cash_receipt_history.amount%TYPE;
193: l_cr_acctd_amount ar_payment_schedules.acctd_amount_due_remaining%TYPE;
194: l_crh_acctd_amount ar_cash_receipt_history.amount%TYPE;
195: l_acctd_factor_discount_amount ar_cash_receipt_history.acctd_factor_discount_amount%TYPE;
196: l_bank_charges_ccid ar_cash_receipt_history.bank_charge_account_ccid%TYPE;

Line 194: l_crh_acctd_amount ar_cash_receipt_history.amount%TYPE;

190: l_creation_status ar_cash_receipt_history.status%TYPE;
191: l_status ar_cash_receipts.status%TYPE;
192: l_crh_amount ar_cash_receipt_history.amount%TYPE;
193: l_cr_acctd_amount ar_payment_schedules.acctd_amount_due_remaining%TYPE;
194: l_crh_acctd_amount ar_cash_receipt_history.amount%TYPE;
195: l_acctd_factor_discount_amount ar_cash_receipt_history.acctd_factor_discount_amount%TYPE;
196: l_bank_charges_ccid ar_cash_receipt_history.bank_charge_account_ccid%TYPE;
197: l_application_rule ar_receivable_applications.application_rule%TYPE;
198: l_called_from_api varchar2(1);

Line 195: l_acctd_factor_discount_amount ar_cash_receipt_history.acctd_factor_discount_amount%TYPE;

191: l_status ar_cash_receipts.status%TYPE;
192: l_crh_amount ar_cash_receipt_history.amount%TYPE;
193: l_cr_acctd_amount ar_payment_schedules.acctd_amount_due_remaining%TYPE;
194: l_crh_acctd_amount ar_cash_receipt_history.amount%TYPE;
195: l_acctd_factor_discount_amount ar_cash_receipt_history.acctd_factor_discount_amount%TYPE;
196: l_bank_charges_ccid ar_cash_receipt_history.bank_charge_account_ccid%TYPE;
197: l_application_rule ar_receivable_applications.application_rule%TYPE;
198: l_called_from_api varchar2(1);
199:

Line 196: l_bank_charges_ccid ar_cash_receipt_history.bank_charge_account_ccid%TYPE;

192: l_crh_amount ar_cash_receipt_history.amount%TYPE;
193: l_cr_acctd_amount ar_payment_schedules.acctd_amount_due_remaining%TYPE;
194: l_crh_acctd_amount ar_cash_receipt_history.amount%TYPE;
195: l_acctd_factor_discount_amount ar_cash_receipt_history.acctd_factor_discount_amount%TYPE;
196: l_bank_charges_ccid ar_cash_receipt_history.bank_charge_account_ccid%TYPE;
197: l_application_rule ar_receivable_applications.application_rule%TYPE;
198: l_called_from_api varchar2(1);
199:
200: l_dummy NUMBER;

Line 584: | AR_CASH_RECEIPT_HISTORY |

580: | |
581: | DESCRIPTION |
582: | This entity handler is created for remitting a confirmed receipt. |
583: | Review this routine if you are planing to use it for anyother purpose |
584: | AR_CASH_RECEIPT_HISTORY |
585: | AR_DISTRIBUTIONS |
586: | |
587: | SCOPE - PUBLIC |
588: | |

Line 610: l_crh_rec ar_cash_receipt_history%ROWTYPE;

606: x_return_status OUT NOCOPY VARCHAR2
607: ) IS
608:
609: l_cr_rec ar_cash_receipts%ROWTYPE;
610: l_crh_rec ar_cash_receipt_history%ROWTYPE;
611: l_new_crh_rec ar_cash_receipt_history%ROWTYPE;
612:
613: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
614: l_prev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 611: l_new_crh_rec ar_cash_receipt_history%ROWTYPE;

607: ) IS
608:
609: l_cr_rec ar_cash_receipts%ROWTYPE;
610: l_crh_rec ar_cash_receipt_history%ROWTYPE;
611: l_new_crh_rec ar_cash_receipt_history%ROWTYPE;
612:
613: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
614: l_prev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
615: l_new_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 614: l_prev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

610: l_crh_rec ar_cash_receipt_history%ROWTYPE;
611: l_new_crh_rec ar_cash_receipt_history%ROWTYPE;
612:
613: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
614: l_prev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
615: l_new_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
616: l_confirmation_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
617: l_remittance_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
618:

Line 615: l_new_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

611: l_new_crh_rec ar_cash_receipt_history%ROWTYPE;
612:
613: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
614: l_prev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
615: l_new_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
616: l_confirmation_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
617: l_remittance_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
618:
619: l_ra_ccid ar_receivable_applications.code_combination_id%TYPE;

Line 616: l_confirmation_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;

612:
613: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
614: l_prev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
615: l_new_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
616: l_confirmation_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
617: l_remittance_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
618:
619: l_ra_ccid ar_receivable_applications.code_combination_id%TYPE;
620: l_ra_unid_ccid ar_receivable_applications.code_combination_id%TYPE;

Line 617: l_remittance_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;

613: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
614: l_prev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
615: l_new_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
616: l_confirmation_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
617: l_remittance_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
618:
619: l_ra_ccid ar_receivable_applications.code_combination_id%TYPE;
620: l_ra_unid_ccid ar_receivable_applications.code_combination_id%TYPE;
621: l_ra_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;

Line 623: l_crh_amount ar_cash_receipt_history.amount%TYPE;

619: l_ra_ccid ar_receivable_applications.code_combination_id%TYPE;
620: l_ra_unid_ccid ar_receivable_applications.code_combination_id%TYPE;
621: l_ra_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
622:
623: l_crh_amount ar_cash_receipt_history.amount%TYPE;
624: l_cr_acctd_amount ar_payment_schedules.acctd_amount_due_remaining%TYPE;
625: l_crh_acctd_amount ar_cash_receipt_history.amount%TYPE;
626: l_bank_charges_ccid ar_cash_receipt_history.bank_charge_account_ccid%TYPE;
627:

Line 625: l_crh_acctd_amount ar_cash_receipt_history.amount%TYPE;

621: l_ra_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
622:
623: l_crh_amount ar_cash_receipt_history.amount%TYPE;
624: l_cr_acctd_amount ar_payment_schedules.acctd_amount_due_remaining%TYPE;
625: l_crh_acctd_amount ar_cash_receipt_history.amount%TYPE;
626: l_bank_charges_ccid ar_cash_receipt_history.bank_charge_account_ccid%TYPE;
627:
628: l_dummy NUMBER;
629: l_id_dummy NUMBER;

Line 626: l_bank_charges_ccid ar_cash_receipt_history.bank_charge_account_ccid%TYPE;

622:
623: l_crh_amount ar_cash_receipt_history.amount%TYPE;
624: l_cr_acctd_amount ar_payment_schedules.acctd_amount_due_remaining%TYPE;
625: l_crh_acctd_amount ar_cash_receipt_history.amount%TYPE;
626: l_bank_charges_ccid ar_cash_receipt_history.bank_charge_account_ccid%TYPE;
627:
628: l_dummy NUMBER;
629: l_id_dummy NUMBER;
630: