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 122: p_payment_type_code ar_receipt_methods.payment_type_code%type;

118: cr_return_status VARCHAR2(1);
119: l_return_status VARCHAR2(1);
120:
121:
122: p_payment_type_code ar_receipt_methods.payment_type_code%type;
123: p_sob_id ar_batches.set_of_books_id%type;
124:
125: l_last_updated_by NUMBER;
126: l_created_by NUMBER;

Line 136: l_instrument_type ar_receipt_methods.payment_channel_code%type;

132: l_batch_applied_status ar_batches.batch_applied_status%type;
133: pl_return_status VARCHAR2(1);
134: pl_msg_count NUMBER;
135: pl_msg_data VARCHAR2(240);
136: l_instrument_type ar_receipt_methods.payment_channel_code%type;
137: BEGIN
138: --arp_standard.enable_debug;
139: --arp_standard.enable_file_debug('/appslog/fin_top/utl/finixud/out','chat67.log');
140:

Line 381: from ar_receipt_methods rm,

377:
378: if l_receipt_method_id is not null then /* bug7173199: subsituted p_payment_method_id with l_receipt_method_id*/
379: select rm.payment_channel_code,b.set_of_books_id
380: into p_payment_type_code, p_sob_id
381: from ar_receipt_methods rm,
382: ar_batches b
383: where rm.receipt_method_id = l_receipt_method_id /* bug7173199: subsituted p_payment_method_id with l_receipt_method_id*/
384: and b.receipt_method_id = rm.receipt_method_id
385: and b.batch_id = o_batch_id;

Line 455: from ar_receipt_methods rm,

451:
452: if l_receipt_method_id is not null then /* bug7173199: subsituted p_payment_method_id with l_receipt_method_id*/
453: select rm.payment_channel_code,b.set_of_books_id
454: into p_payment_type_code, p_sob_id
455: from ar_receipt_methods rm,
456: ar_batches b
457: where rm.receipt_method_id = l_receipt_method_id /* bug7173199: subsituted p_payment_method_id with l_receipt_method_id*/
458: and b.receipt_method_id = rm.receipt_method_id
459: and b.batch_id = o_batch_id;

Line 548: from ar_receipt_methods rm,

544:
545: if l_receipt_method_id is not null then /* bug7173199: subsituted p_payment_method_id with l_receipt_method_id*/
546: select rm.payment_channel_code,b.set_of_books_id
547: into p_payment_type_code, p_sob_id
548: from ar_receipt_methods rm,
549: ar_batches b
550: where b.receipt_method_id = rm.receipt_method_id
551: and b.batch_id = o_batch_id;
552: else

Line 606: from ar_receipt_methods rm,

602:
603: if l_receipt_method_id is not null then /* bug7173199: subsituted p_payment_method_id with l_receipt_method_id*/
604: select rm.payment_channel_code,b.set_of_books_id
605: into p_payment_type_code, p_sob_id
606: from ar_receipt_methods rm,
607: ar_batches b
608: where b.receipt_method_id = rm.receipt_method_id
609: and b.batch_id = o_batch_id;
610: else

Line 825: FROM AR_RECEIPT_METHODS RM, IBY_FNDCPT_PMT_CHNNLS_B PC

821:
822: /* Bug 7639165 - Changes Begin. */
823: BEGIN
824: SELECT PC.INSTRUMENT_TYPE INTO l_instrument_type
825: FROM AR_RECEIPT_METHODS RM, IBY_FNDCPT_PMT_CHNNLS_B PC
826: WHERE RECEIPT_METHOD_ID = l_receipt_method_id
827: AND RM.PAYMENT_CHANNEL_CODE = PC.PAYMENT_CHANNEL_CODE;
828: EXCEPTION
829: WHEN NO_DATA_FOUND THEN -- Bug 9096913

Line 1005: p_payment_type_code ar_receipt_methods.payment_type_code%type;

1001: /* bug 7352164*/
1002: l_control_count number;
1003: l_control_amount number;
1004:
1005: p_payment_type_code ar_receipt_methods.payment_type_code%type;
1006: p_sob_id ar_batches.set_of_books_id%type;
1007:
1008: TYPE req_status_typ IS RECORD (
1009: request_id NUMBER(15),

Line 1170: from ar_receipt_methods rm,

1166: );
1167: if p_payment_method_id is not null then
1168: select rm.payment_channel_code,b.set_of_books_id
1169: into p_payment_type_code, p_sob_id
1170: from ar_receipt_methods rm,
1171: ar_batches b
1172: where rm.receipt_method_id = p_payment_method_id
1173: and b.receipt_method_id = rm.receipt_method_id
1174: and b.batch_id = o_batch_id;

Line 1332: ar_receipt_methods rm,

1328: --MOD(CEIL(cr.cash_receipt_id/10000), p_total_workers) + 1
1329: MOD(CEIL((DENSE_RANK() over(order by crh.cash_receipt_id))/5000), :b_total_workers) + 1
1330: FROM ar_rem_cr_id_gtt gtt,
1331: ar_cash_receipts cr,
1332: ar_receipt_methods rm,
1333: ar_receipt_classes rc,
1334: hz_cust_accounts hca,
1335: hz_parties party,
1336: /*ar_remit_gt g,*/

Line 1509: p_payment_method_id IN ar_receipt_methods.receipt_method_id%TYPE,

1505: p_format_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
1506: p_currency_code IN ar_batches.currency_code%TYPE,
1507: p_remmitance_method IN ar_batches.remit_method_code%TYPE,
1508: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE,
1509: p_payment_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
1510: p_remmitance_bank_branch_id IN ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL,
1511: p_remmitance_bank_account_id IN ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL,
1512: p_remit_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE DEFAULT NULL, --bug12924584
1513: p_batch_id OUT NOCOPY NUMBER

Line 1814: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;

1810: sel_receipts INTEGER;
1811: /* declare the cursor variables */
1812:
1813: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
1814: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;
1815: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
1816: p_currency_code ar_cash_receipts.currency_code%TYPE;
1817: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
1818: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;

Line 1815: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;

1811: /* declare the cursor variables */
1812:
1813: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
1814: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;
1815: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
1816: p_currency_code ar_cash_receipts.currency_code%TYPE;
1817: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
1818: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
1819: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 1963: ar_receipt_methods rm,

1959: cr.unique_reference ),
1960: cr.customer_bank_account_id,
1961: cr.payment_trxn_extension_id
1962: FROM ar_cash_receipts cr, ar_cash_receipt_history crh,
1963: ar_receipt_methods rm,
1964: ar_batches bat,
1965: ar_receipt_method_accounts rma,
1966: ar_payment_schedules ps,
1967: ar_distributions d

Line 2595: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;

2591: sel_receipts INTEGER;
2592: /* declare the cursor variables */
2593:
2594: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
2595: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;
2596: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
2597: p_currency_code ar_cash_receipts.currency_code%TYPE;
2598: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
2599: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;

Line 2596: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;

2592: /* declare the cursor variables */
2593:
2594: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
2595: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;
2596: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
2597: p_currency_code ar_cash_receipts.currency_code%TYPE;
2598: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
2599: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
2600: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 3373: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,

3369: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
3370: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
3371: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
3372: p_batch_id IN ar_batches.batch_id%TYPE,
3373: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
3374: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
3375: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,
3376: p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,
3377: p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,

Line 3375: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,

3371: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
3372: p_batch_id IN ar_batches.batch_id%TYPE,
3373: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
3374: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
3375: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,
3376: p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,
3377: p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,
3378: p_remit_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE,
3379: p_return_status OUT NOCOPY VARCHAR2

Line 3389: p_payment_method_id ar_receipt_methods.receipt_method_id%TYPE;

3385: l_rows_fetched INTEGER;
3386: p_cash_receipt_id NUMBER(15);
3387: p_amount ar_cash_receipts.amount%TYPE;
3388: l_amount ar_cash_receipts.amount%TYPE; --14798599
3389: p_payment_method_id ar_receipt_methods.receipt_method_id%TYPE;
3390: cash_receipt_id_array dbms_sql.Number_Table;
3391: cr_id_array dbms_sql.Number_Table;
3392: amt_array dbms_sql.Number_Table;
3393: ins_recs INTEGER;

Line 3494: ar_receipt_methods rm,

3490: l_sel_stmt := l_sel_stmt || ' ar_cash_receipt_history crh1,
3491: ar_cash_receipts cr,
3492: ar_payment_schedules ps,
3493: ar_receipt_classes rclass,
3494: ar_receipt_methods rm,
3495: ar_receipt_method_accounts rma1,
3496: ar_receipt_method_accounts rma2
3497: WHERE crh1.status = ''CONFIRMED''
3498: AND crh1.current_record_flag = ''Y'' ';

Line 3928: ar_receipt_methods rm,

3924: cr.selected_remittance_batch_id,
3925: cr.receipt_date,
3926: pr.home_country
3927: FROM ar_cash_receipts cr,
3928: ar_receipt_methods rm,
3929: ar_receipt_classes rc,
3930: hz_cust_accounts hca,
3931: hz_parties party,
3932: ar_remit_gt g,