DBA Data[Home] [Help]

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 183: l_crh_rec ar_cash_receipt_history%ROWTYPE;

179: p_autoapply_flag IN VARCHAR2 DEFAULT NULL
180:
181: ) IS
182: l_cr_rec ar_cash_receipts%ROWTYPE;
183: l_crh_rec ar_cash_receipt_history%ROWTYPE;
184: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
185: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
186: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
187: l_ra_ccid ar_receivable_applications.code_combination_id%TYPE;

Line 186: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;

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

Line 193: l_creation_status ar_cash_receipt_history.status%TYPE;

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

Line 195: l_crh_amount ar_cash_receipt_history.amount%TYPE;

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

Line 197: l_crh_acctd_amount ar_cash_receipt_history.amount%TYPE;

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

Line 198: l_acctd_factor_discount_amount ar_cash_receipt_history.acctd_factor_discount_amount%TYPE;

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

Line 199: l_bank_charges_ccid ar_cash_receipt_history.bank_charge_account_ccid%TYPE;

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

Line 593: | AR_CASH_RECEIPT_HISTORY |

589: | |
590: | DESCRIPTION |
591: | This entity handler is created for remitting a confirmed receipt. |
592: | Review this routine if you are planing to use it for anyother purpose |
593: | AR_CASH_RECEIPT_HISTORY |
594: | AR_DISTRIBUTIONS |
595: | |
596: | SCOPE - PUBLIC |
597: | |

Line 619: l_crh_rec ar_cash_receipt_history%ROWTYPE;

615: x_return_status OUT NOCOPY VARCHAR2
616: ) IS
617:
618: l_cr_rec ar_cash_receipts%ROWTYPE;
619: l_crh_rec ar_cash_receipt_history%ROWTYPE;
620: l_new_crh_rec ar_cash_receipt_history%ROWTYPE;
621:
622: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
623: l_prev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 620: l_new_crh_rec ar_cash_receipt_history%ROWTYPE;

616: ) IS
617:
618: l_cr_rec ar_cash_receipts%ROWTYPE;
619: l_crh_rec ar_cash_receipt_history%ROWTYPE;
620: l_new_crh_rec ar_cash_receipt_history%ROWTYPE;
621:
622: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
623: l_prev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
624: l_new_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 623: l_prev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

619: l_crh_rec ar_cash_receipt_history%ROWTYPE;
620: l_new_crh_rec ar_cash_receipt_history%ROWTYPE;
621:
622: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
623: l_prev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
624: l_new_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
625: l_confirmation_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
626: l_remittance_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
627:

Line 624: l_new_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

620: l_new_crh_rec ar_cash_receipt_history%ROWTYPE;
621:
622: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
623: l_prev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
624: l_new_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
625: l_confirmation_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
626: l_remittance_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
627:
628: l_ra_ccid ar_receivable_applications.code_combination_id%TYPE;

Line 625: l_confirmation_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;

621:
622: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
623: l_prev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
624: l_new_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
625: l_confirmation_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
626: l_remittance_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
627:
628: l_ra_ccid ar_receivable_applications.code_combination_id%TYPE;
629: l_ra_unid_ccid ar_receivable_applications.code_combination_id%TYPE;

Line 626: l_remittance_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;

622: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
623: l_prev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
624: l_new_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
625: l_confirmation_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
626: l_remittance_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
627:
628: l_ra_ccid ar_receivable_applications.code_combination_id%TYPE;
629: l_ra_unid_ccid ar_receivable_applications.code_combination_id%TYPE;
630: l_ra_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;

Line 632: l_crh_amount ar_cash_receipt_history.amount%TYPE;

628: l_ra_ccid ar_receivable_applications.code_combination_id%TYPE;
629: l_ra_unid_ccid ar_receivable_applications.code_combination_id%TYPE;
630: l_ra_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
631:
632: l_crh_amount ar_cash_receipt_history.amount%TYPE;
633: l_cr_acctd_amount ar_payment_schedules.acctd_amount_due_remaining%TYPE;
634: l_crh_acctd_amount ar_cash_receipt_history.amount%TYPE;
635: l_bank_charges_ccid ar_cash_receipt_history.bank_charge_account_ccid%TYPE;
636:

Line 634: l_crh_acctd_amount ar_cash_receipt_history.amount%TYPE;

630: l_ra_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
631:
632: l_crh_amount ar_cash_receipt_history.amount%TYPE;
633: l_cr_acctd_amount ar_payment_schedules.acctd_amount_due_remaining%TYPE;
634: l_crh_acctd_amount ar_cash_receipt_history.amount%TYPE;
635: l_bank_charges_ccid ar_cash_receipt_history.bank_charge_account_ccid%TYPE;
636:
637: l_dummy NUMBER;
638: l_id_dummy NUMBER;

Line 635: l_bank_charges_ccid ar_cash_receipt_history.bank_charge_account_ccid%TYPE;

631:
632: l_crh_amount ar_cash_receipt_history.amount%TYPE;
633: l_cr_acctd_amount ar_payment_schedules.acctd_amount_due_remaining%TYPE;
634: l_crh_acctd_amount ar_cash_receipt_history.amount%TYPE;
635: l_bank_charges_ccid ar_cash_receipt_history.bank_charge_account_ccid%TYPE;
636:
637: l_dummy NUMBER;
638: l_id_dummy NUMBER;
639: