DBA Data[Home] [Help]

APPS.ARP_PROCESS_CHARGEBACK dependencies on AR_CASH_RECEIPTS

Line 1238: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;

1234: l_defaulting_rule_used VARCHAR2(50);
1235: l_default_gl_date DATE;
1236: error_defaulting_gl_date EXCEPTION;
1237: l_receivables_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
1238: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1239: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1240: l_cr_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
1241: l_inv_rec_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1242: l_id_dummy ar_receivable_applications.code_combination_id%TYPE;

Line 1239: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;

1235: l_default_gl_date DATE;
1236: error_defaulting_gl_date EXCEPTION;
1237: l_receivables_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
1238: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1239: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1240: l_cr_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
1241: l_inv_rec_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1242: l_id_dummy ar_receivable_applications.code_combination_id%TYPE;
1243: l_bill_to_customer_id ar_cash_receipts.pay_from_customer%TYPE;

Line 1243: l_bill_to_customer_id ar_cash_receipts.pay_from_customer%TYPE;

1239: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1240: l_cr_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
1241: l_inv_rec_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1242: l_id_dummy ar_receivable_applications.code_combination_id%TYPE;
1243: l_bill_to_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1244: l_cb_activity_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1245: l_actual_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1246: --Bug2979254
1247: l_ev_rec arp_xla_events.xla_events_type;

Line 1255: l_rct_le_id ar_cash_receipts.legal_entity_id%TYPE; /* R12 LE uptake */

1251: ln_adr_tmp NUMBER;
1252: ln_acctd_adr_tmp NUMBER;
1253: l_acctd_amount NUMBER;
1254: l_term_end_date DATE; /*5084781*/
1255: l_rct_le_id ar_cash_receipts.legal_entity_id%TYPE; /* R12 LE uptake */
1256: ln_trx_number VARCHAR2(20);/*bug 5550153*/
1257: --Ajay : raising the business event for chargeback creation
1258:
1259: CURSOR get_parent_ps (p_cust_trx_id IN NUMBER) IS

Line 1431: ar_cash_receipts cr

1427: , l_receipt_method_id
1428: , l_remit_bank_acct_use_id
1429: , l_rct_le_id /* R12 LE uptake */
1430: FROM
1431: ar_cash_receipts cr
1432: WHERE
1433: cr.cash_receipt_id = p_cash_receipt_id;
1434: EXCEPTION
1435: WHEN OTHERS THEN