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.AR_RECEIPT_API_PUB dependencies on AR_RECEIPT_METHODS

Line 177: l_receipt_method_name ar_receipt_methods.name%TYPE;

173: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
174: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
175: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
176: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
177: l_receipt_method_name ar_receipt_methods.name%TYPE;
178: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
179: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
180: l_state VARCHAR2(30);
181: l_cr_id NUMBER;

Line 212: l_rec_creation_rule_code ar_receipt_methods.receipt_creation_rule_code%TYPE;

208: l_create_msg_count NUMBER;
209: l_create_msg_data VARCHAR2(2000);
210: l_create_pmt_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
211: l_default_site_use VARCHAR2(1); --bug4448307-4509459
212: l_rec_creation_rule_code ar_receipt_methods.receipt_creation_rule_code%TYPE;
213:
214: BEGIN
215:
216: --assignment to local variables

Line 580: from AR_RECEIPT_METHODS

576:
577:
578: select nvl(RECEIPT_CREATION_RULE_CODE,'MANUAL')
579: into l_rec_creation_rule_code
580: from AR_RECEIPT_METHODS
581: where receipt_method_id = l_receipt_method_id;
582:
583:
584:

Line 1043: l_receipt_method_name ar_receipt_methods.name%TYPE;

1039: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1040: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1041: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
1042: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1043: l_receipt_method_name ar_receipt_methods.name%TYPE;
1044: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
1045: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
1046: l_state VARCHAR2(30);
1047: l_cr_id NUMBER;

Line 3436: ar_receipt_methods rm,

3432: ba.bank_account_name,
3433: ba.inactive_date,
3434: cr.unique_reference --bug 3672953
3435: FROM ar_cash_receipts cr,
3436: ar_receipt_methods rm,
3437: ar_receipt_classes rc,
3438: ap_bank_accounts ba
3439: WHERE cr.cash_receipt_id = p_cash_receipt_id
3440: AND cr.customer_bank_account_id = ba.bank_account_id

Line 3833: ar_receipt_methods rm,

3829: cr.payment_trxn_extension_id,
3830: cr.receipt_date,
3831: pr.home_country
3832: FROM ar_cash_receipts_all cr,
3833: ar_receipt_methods rm,
3834: ar_receipt_classes rc,
3835: hz_cust_accounts hca,
3836: hz_parties party,
3837: /* Need to pass country code for SEPA specific receipts */

Line 4590: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;

4586: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
4587: l_org_id ra_customer_trx.org_id%type;
4588: l_party_id hz_parties.party_id%type;
4589: l_trx_number ra_customer_trx.trx_number%type;
4590: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;
4591: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
4592:
4593: l_start_date DATE ;
4594: l_end_date DATE ;

Line 4618: from ar_receipt_methods

4614: AND hca.cust_account_id = l_customer_id ;
4615:
4616: SELECT payment_channel_code
4617: INTO l_payment_channel_code
4618: from ar_receipt_methods
4619: where receipt_method_id = p_receipt_method_id;
4620:
4621:
4622: /* Start - Bug 13056525 : Get start and end date for instrument assignment. */

Line 4802: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,

4798: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
4799: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
4800: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
4801: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
4802: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
4803: p_doc_sequence_value IN NUMBER DEFAULT NULL,
4804: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
4805: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
4806: p_called_from IN VARCHAR2 DEFAULT NULL,

Line 5130: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,

5126: p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
5127: p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
5128: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
5129: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
5130: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
5131: p_doc_sequence_value IN NUMBER DEFAULT NULL,
5132: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
5133: DEFAULT NULL,
5134: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE