DBA Data[Home] [Help]

APPS.ARP_PROC_RECEIPTS2 dependencies on AR_CASH_RECEIPTS

Line 29: | AR_CASH_RECEIPTS |

25: | DESCRIPTION |
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 |

Line 179: l_cr_rec ar_cash_receipts%ROWTYPE;

175: p_called_from IN VARCHAR2 DEFAULT NULL, /* BR */
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;

Line 181: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;

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;
185: l_ra_unid_ccid ar_receivable_applications.code_combination_id%TYPE;

Line 191: l_status ar_cash_receipts.status%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;
195: l_acctd_factor_discount_amount ar_cash_receipt_history.acctd_factor_discount_amount%TYPE;

Line 561: FROM ar_cash_receipts

557: -- get the ROWID out NOCOPY parameter:
558:
559: SELECT rowid
560: INTO p_row_id
561: FROM ar_cash_receipts
562: WHERE cash_receipt_id = l_cr_rec.cash_receipt_id;
563:
564: IF PG_DEBUG in ('Y', 'C') THEN
565: arp_standard.debug('arp_process_receipts.insert_cash_receipt()-');

Line 609: l_cr_rec ar_cash_receipts%ROWTYPE;

605: p_cash_receipt_id IN NUMBER,
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;

Line 613: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;

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;
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;