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 182: l_cr_rec ar_cash_receipts%ROWTYPE;

178: p_automatch_set_id IN NUMBER DEFAULT NULL, /* ER Automatch Application */
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;

Line 184: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;

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

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

Line 570: FROM ar_cash_receipts

566: -- get the ROWID out NOCOPY parameter:
567:
568: SELECT rowid
569: INTO p_row_id
570: FROM ar_cash_receipts
571: WHERE cash_receipt_id = l_cr_rec.cash_receipt_id;
572:
573: IF PG_DEBUG in ('Y', 'C') THEN
574: arp_standard.debug('arp_process_receipts.insert_cash_receipt()-');

Line 618: l_cr_rec ar_cash_receipts%ROWTYPE;

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

Line 622: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;

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