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_AUTOREM_API dependencies on AR_RECEIPT_METHODS

Line 118: p_payment_type_code ar_receipt_methods.payment_type_code%type;

114: cr_return_status VARCHAR2(1);
115: l_return_status VARCHAR2(1);
116:
117:
118: p_payment_type_code ar_receipt_methods.payment_type_code%type;
119: p_sob_id ar_batches.set_of_books_id%type;
120:
121: l_last_updated_by NUMBER;
122: l_created_by NUMBER;

Line 372: from ar_receipt_methods rm,

368:
369: if l_receipt_method_id is not null then /* bug7173199: subsituted p_payment_method_id with l_receipt_method_id*/
370: select rm.payment_channel_code,b.set_of_books_id
371: into p_payment_type_code, p_sob_id
372: from ar_receipt_methods rm,
373: ar_batches b
374: where rm.receipt_method_id = l_receipt_method_id /* bug7173199: subsituted p_payment_method_id with l_receipt_method_id*/
375: and b.receipt_method_id = rm.receipt_method_id
376: and b.batch_id = o_batch_id;

Line 441: from ar_receipt_methods rm,

437:
438: if l_receipt_method_id is not null then /* bug7173199: subsituted p_payment_method_id with l_receipt_method_id*/
439: select rm.payment_channel_code,b.set_of_books_id
440: into p_payment_type_code, p_sob_id
441: from ar_receipt_methods rm,
442: ar_batches b
443: where rm.receipt_method_id = l_receipt_method_id /* bug7173199: subsituted p_payment_method_id with l_receipt_method_id*/
444: and b.receipt_method_id = rm.receipt_method_id
445: and b.batch_id = o_batch_id;

Line 530: from ar_receipt_methods rm,

526:
527: if l_receipt_method_id is not null then /* bug7173199: subsituted p_payment_method_id with l_receipt_method_id*/
528: select rm.payment_channel_code,b.set_of_books_id
529: into p_payment_type_code, p_sob_id
530: from ar_receipt_methods rm,
531: ar_batches b
532: where b.receipt_method_id = rm.receipt_method_id
533: and b.batch_id = o_batch_id;
534: else

Line 584: from ar_receipt_methods rm,

580:
581: if l_receipt_method_id is not null then /* bug7173199: subsituted p_payment_method_id with l_receipt_method_id*/
582: select rm.payment_channel_code,b.set_of_books_id
583: into p_payment_type_code, p_sob_id
584: from ar_receipt_methods rm,
585: ar_batches b
586: where b.receipt_method_id = rm.receipt_method_id
587: and b.batch_id = o_batch_id;
588: else

Line 956: p_payment_type_code ar_receipt_methods.payment_type_code%type;

952: /* bug 7352164*/
953: l_control_count number;
954: l_control_amount number;
955:
956: p_payment_type_code ar_receipt_methods.payment_type_code%type;
957: p_sob_id ar_batches.set_of_books_id%type;
958:
959: TYPE req_status_typ IS RECORD (
960: request_id NUMBER(15),

Line 1117: from ar_receipt_methods rm,

1113: );
1114: if p_payment_method_id is not null then
1115: select rm.payment_channel_code,b.set_of_books_id
1116: into p_payment_type_code, p_sob_id
1117: from ar_receipt_methods rm,
1118: ar_batches b
1119: where rm.receipt_method_id = p_payment_method_id
1120: and b.receipt_method_id = rm.receipt_method_id
1121: and b.batch_id = o_batch_id;

Line 1268: ar_receipt_methods rm,

1264: --MOD(CEIL(cr.cash_receipt_id/10000), p_total_workers) + 1
1265: MOD(CEIL((DENSE_RANK() over(order by crh.cash_receipt_id))/5000), :b_total_workers) + 1
1266: FROM ar_rem_cr_id_gtt gtt,
1267: ar_cash_receipts cr,
1268: ar_receipt_methods rm,
1269: ar_receipt_classes rc,
1270: hz_cust_accounts hca,
1271: hz_parties party,
1272: /*ar_remit_gt g,*/

Line 1446: p_payment_method_id IN ar_receipt_methods.receipt_method_id%TYPE,

1442: p_format_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
1443: p_currency_code IN ar_batches.currency_code%TYPE,
1444: p_remmitance_method IN ar_batches.remit_method_code%TYPE,
1445: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE,
1446: p_payment_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
1447: p_remmitance_bank_branch_id IN ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL,
1448: p_remmitance_bank_account_id IN ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL,
1449: p_batch_id OUT NOCOPY NUMBER
1450: ) IS

Line 1750: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;

1746: sel_receipts INTEGER;
1747: /* declare the cursor variables */
1748:
1749: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
1750: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;
1751: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
1752: p_currency_code ar_cash_receipts.currency_code%TYPE;
1753: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
1754: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;

Line 1751: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;

1747: /* declare the cursor variables */
1748:
1749: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
1750: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;
1751: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
1752: p_currency_code ar_cash_receipts.currency_code%TYPE;
1753: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
1754: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
1755: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 1899: ar_receipt_methods rm,

1895: cr.unique_reference ),
1896: cr.customer_bank_account_id,
1897: cr.payment_trxn_extension_id
1898: FROM ar_cash_receipts cr, ar_cash_receipt_history crh,
1899: ar_receipt_methods rm,
1900: ar_batches bat,
1901: ar_receipt_method_accounts rma,
1902: ar_payment_schedules ps,
1903: ar_distributions d

Line 2531: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;

2527: sel_receipts INTEGER;
2528: /* declare the cursor variables */
2529:
2530: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
2531: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;
2532: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
2533: p_currency_code ar_cash_receipts.currency_code%TYPE;
2534: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
2535: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;

Line 2532: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;

2528: /* declare the cursor variables */
2529:
2530: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
2531: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;
2532: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
2533: p_currency_code ar_cash_receipts.currency_code%TYPE;
2534: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
2535: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
2536: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 3291: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,

3287: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
3288: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
3289: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
3290: p_batch_id IN ar_batches.batch_id%TYPE,
3291: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
3292: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
3293: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,
3294: p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,
3295: p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,

Line 3293: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,

3289: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
3290: p_batch_id IN ar_batches.batch_id%TYPE,
3291: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
3292: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
3293: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,
3294: p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,
3295: p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,
3296: p_remit_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE,
3297: p_return_status OUT NOCOPY VARCHAR2

Line 3306: p_payment_method_id ar_receipt_methods.receipt_method_id%TYPE;

3302: l_rows_processed INTEGER;
3303: l_rows_fetched INTEGER;
3304: p_cash_receipt_id NUMBER(15);
3305: p_amount ar_cash_receipts.amount%TYPE;
3306: p_payment_method_id ar_receipt_methods.receipt_method_id%TYPE;
3307: cash_receipt_id_array dbms_sql.Number_Table;
3308: cr_id_array dbms_sql.Number_Table;
3309: amt_array dbms_sql.Number_Table;
3310: ins_recs INTEGER;

Line 3387: ar_receipt_methods rm,

3383: ar_cash_receipt_history crh1,
3384: ar_cash_receipts cr,
3385: ar_payment_schedules ps,
3386: ar_receipt_classes rclass,
3387: ar_receipt_methods rm,
3388: ar_receipt_method_accounts rma1,
3389: ar_receipt_method_accounts rma2
3390: WHERE crh1.status = ''CONFIRMED''
3391: AND crh1.current_record_flag = ''Y''

Line 3643: ar_receipt_methods rm,

3639: cr.payment_trxn_extension_id,
3640: cr.selected_remittance_batch_id,
3641: cr.receipt_date
3642: FROM ar_cash_receipts cr,
3643: ar_receipt_methods rm,
3644: ar_receipt_classes rc,
3645: hz_cust_accounts hca,
3646: hz_parties party,
3647: ar_remit_gt g