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_PROCESS_CHARGEBACK dependencies on AR_CASH_RECEIPTS

Line 1240: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;

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

Line 1241: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;

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

Line 1245: l_bill_to_customer_id ar_cash_receipts.pay_from_customer%TYPE;

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

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

1253: ln_adr_tmp NUMBER;
1254: ln_acctd_adr_tmp NUMBER;
1255: l_acctd_amount NUMBER;
1256: l_term_end_date DATE; /*5084781*/
1257: l_rct_le_id ar_cash_receipts.legal_entity_id%TYPE; /* R12 LE uptake */
1258: ln_trx_number VARCHAR2(20);/*bug 5550153*/
1259: /*Bug 13788971 - initialization of variables for Paying Customer details population - Start*/
1260: l_payment_method_name ar_receipt_methods.name%type;
1261: l_creation_method_code ar_receipt_classes.creation_method_code%type;

Line 1269: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;

1265: l_org_id ra_customer_trx.org_id%type;
1266: l_create_msg_count NUMBER;
1267: l_create_msg_data VARCHAR2(2000);
1268: l_create_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1269: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1270: /*Bug 13788971 - initialization of variables for Paying Customer details population - END*/
1271: --Ajay : raising the business event for chargeback creation
1272:
1273: CURSOR get_parent_ps (p_cust_trx_id IN NUMBER) IS

Line 1445: ar_cash_receipts cr

1441: , l_receipt_method_id
1442: , l_remit_bank_acct_use_id
1443: , l_rct_le_id /* R12 LE uptake */
1444: FROM
1445: ar_cash_receipts cr
1446: WHERE
1447: cr.cash_receipt_id = p_cash_receipt_id;
1448: EXCEPTION
1449: WHEN OTHERS THEN