APPS.ARP_PROCESS_CHARGEBACK dependencies on AR_RECEIPT_METHODS

Line 1260: l_payment_method_name ar_receipt_methods.name%type;

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;
1262: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;
1263: l_instrument_type iby_trxn_extensions_v.instrument_type%type;
1264: l_instr_assignment_id iby_trxn_extensions_v.instr_assignment_id%type;

Line 1262: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;

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;
1262: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;
1263: l_instrument_type iby_trxn_extensions_v.instrument_type%type;
1264: l_instr_assignment_id iby_trxn_extensions_v.instr_assignment_id%type;
1265: l_org_id ra_customer_trx.org_id%type;
1266: l_create_msg_count NUMBER;

Line 1663: FROM ar_receipt_methods

1659: 'CREDIT_CARD',
1660: 'CREDITCARD',
1661: 'BANKACCOUNT')
1662: INTO l_payment_channel_code, l_instrument_type
1663: FROM ar_receipt_methods
1664: WHERE receipt_method_id = l_ct_row.receipt_method_id;
1665:
1666: SELECT org_id
1667: INTO l_org_id

Line 2661: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;

2657: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
2658: l_org_id ra_customer_trx.org_id%type;
2659: l_party_id hz_parties.party_id%type;
2660: l_trx_number ra_customer_trx.trx_number%type;
2661: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;
2662: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
2663:
2664: l_start_date DATE;
2665: l_end_date DATE;

Line 2691: from ar_receipt_methods

2687: arp_standard.debug('l_party_id: '|| l_party_id);
2688:
2689: SELECT payment_channel_code
2690: INTO l_payment_channel_code
2691: from ar_receipt_methods
2692: where receipt_method_id = p_receipt_method_id;
2693:
2694: arp_standard.debug('l_payment_channel_code: '|| l_payment_channel_code);
2695: