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 171: l_receipt_method_name ar_receipt_methods.name%TYPE;

167: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
168: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
169: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
170: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
171: l_receipt_method_name ar_receipt_methods.name%TYPE;
172: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
173: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
174: l_state VARCHAR2(30);
175: l_cr_id NUMBER;

Line 206: l_rec_creation_rule_code ar_receipt_methods.receipt_creation_rule_code%TYPE;

202: l_create_msg_count NUMBER;
203: l_create_msg_data VARCHAR2(2000);
204: l_create_pmt_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
205: l_default_site_use VARCHAR2(1); --bug4448307-4509459
206: l_rec_creation_rule_code ar_receipt_methods.receipt_creation_rule_code%TYPE;
207:
208: BEGIN
209:
210: --assignment to local variables

Line 572: from AR_RECEIPT_METHODS

568:
569:
570: select nvl(RECEIPT_CREATION_RULE_CODE,'MANUAL')
571: into l_rec_creation_rule_code
572: from AR_RECEIPT_METHODS
573: where receipt_method_id = l_receipt_method_id;
574:
575:
576:

Line 1032: l_receipt_method_name ar_receipt_methods.name%TYPE;

1028: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1029: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1030: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
1031: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1032: l_receipt_method_name ar_receipt_methods.name%TYPE;
1033: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
1034: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
1035: l_state VARCHAR2(30);
1036: l_cr_id NUMBER;

Line 3390: ar_receipt_methods rm,

3386: ba.bank_account_name,
3387: ba.inactive_date,
3388: cr.unique_reference --bug 3672953
3389: FROM ar_cash_receipts cr,
3390: ar_receipt_methods rm,
3391: ar_receipt_classes rc,
3392: ap_bank_accounts ba
3393: WHERE cr.cash_receipt_id = p_cash_receipt_id
3394: AND cr.customer_bank_account_id = ba.bank_account_id

Line 3786: ar_receipt_methods rm,

3782: cr.customer_site_use_id,
3783: cr.payment_trxn_extension_id,
3784: cr.receipt_date
3785: FROM ar_cash_receipts_all cr,
3786: ar_receipt_methods rm,
3787: ar_receipt_classes rc,
3788: hz_cust_accounts hca,
3789: hz_parties party
3790: WHERE cr.cash_receipt_id = p_cash_receipt_id

Line 4327: from ar_receipt_methods

4323: AND hca.cust_account_id = l_customer_id ;
4324:
4325: SELECT payment_channel_code
4326: INTO l_pmt_channel_code
4327: from ar_receipt_methods
4328: where receipt_method_id = l_receipt_method_id;
4329:
4330: SELECT INSTR_ASSIGNMENT_ID
4331: INTO l_assignment_id

Line 4463: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;

4459: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
4460: l_org_id ra_customer_trx.org_id%type;
4461: l_party_id hz_parties.party_id%type;
4462: l_trx_number ra_customer_trx.trx_number%type;
4463: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;
4464: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
4465:
4466:
4467: BEGIN

Line 4489: from ar_receipt_methods

4485: AND hca.cust_account_id = l_customer_id ;
4486:
4487: SELECT payment_channel_code
4488: INTO l_payment_channel_code
4489: from ar_receipt_methods
4490: where receipt_method_id = p_receipt_method_id;
4491:
4492:
4493: /* pouplate values into the variables */

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

4625: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
4626: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
4627: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
4628: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
4629: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
4630: p_doc_sequence_value IN NUMBER DEFAULT NULL,
4631: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
4632: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
4633: p_called_from IN VARCHAR2 DEFAULT NULL,

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

4953: p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
4954: p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
4955: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
4956: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
4957: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
4958: p_doc_sequence_value IN NUMBER DEFAULT NULL,
4959: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
4960: DEFAULT NULL,
4961: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE