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

Line 149: ar_receipt_methods rm,

145: ( select /*+ unnest */ r.payment_schedule_id
146: from ar_receipts_gt r,
147: ar_receivable_applications ra,
148: ra_customer_trx ct,
149: ar_receipt_methods rm,
150: ar_receipt_classes rc
151: where r.gt_id = p_gt_id
152: and ra.applied_customer_trx_id = r.customer_trx_id
153: and ra.request_id = pg_request_id

Line 456: l_rec_creation_rule_code ar_receipt_methods.receipt_creation_rule_code%TYPE;

452:
453: /* reset variables */
454: l_apply_fail VARCHAR2(1);
455: l_pay_process_fail VARCHAR2(1);
456: l_rec_creation_rule_code ar_receipt_methods.receipt_creation_rule_code%TYPE;
457:
458: /* Bug 7639165 - Declaration Begin. */
459: l_instrument_type VARCHAR2(30);
460: /* Bug 7639165 - Declaration End. */

Line 837: FROM AR_RECEIPT_METHODS RM,

833: /* Bug 7639165 - Changes Begin. */
834: BEGIN
835: SELECT PC.INSTRUMENT_TYPE
836: INTO l_instrument_type
837: FROM AR_RECEIPT_METHODS RM,
838: IBY_FNDCPT_PMT_CHNNLS_B PC
839: WHERE RECEIPT_METHOD_ID = l_receipt_method_id
840: AND RM.PAYMENT_CHANNEL_CODE = PC.PAYMENT_CHANNEL_CODE;
841:

Line 1299: FROM AR_RECEIPT_METHODS RM,

1295: /* Bug 7639165 - Changes Begin. */
1296: BEGIN
1297: SELECT PC.INSTRUMENT_TYPE
1298: INTO l_instrument_type
1299: FROM AR_RECEIPT_METHODS RM,
1300: IBY_FNDCPT_PMT_CHNNLS_B PC
1301: WHERE RECEIPT_METHOD_ID = l_receipt_method_id
1302: AND RM.PAYMENT_CHANNEL_CODE = PC.PAYMENT_CHANNEL_CODE;
1303:

Line 1576: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,

1572: p_customer_name_l IN hz_parties.party_name%TYPE, --Bug6734688
1573: p_customer_name_h IN hz_parties.party_name%TYPE, --Bug6734688
1574: p_batch_id IN ar_batches.batch_id%TYPE,
1575: p_approve_only_flag IN VARCHAR2 ,--Bug5344405
1576: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
1577: p_total_workers IN NUMBER DEFAULT 1
1578: ) IS
1579:
1580: trx_invoices INTEGER;

Line 1586: p_creation_rule ar_receipt_methods.receipt_creation_rule_code%TYPE;

1582: l_rows_fetched INTEGER;
1583: l_sel_stmt long;
1584: p_lead_days NUMBER;
1585: p_batch_date DATE;
1586: p_creation_rule ar_receipt_methods.receipt_creation_rule_code%TYPE;
1587: p_currency_code VARCHAR2(20);
1588:
1589: l_total_workers NUMBER;
1590:

Line 1643: ar_receipt_methods r

1639: p_batch_date,
1640: p_lead_days,
1641: p_creation_rule
1642: from ar_batches b,
1643: ar_receipt_methods r
1644: WHERE b.batch_id = p_batch_id
1645: AND b.receipt_method_id = r.receipt_method_id
1646: AND r.receipt_method_id = p_receipt_method_id;
1647:

Line 2760: ar_receipt_methods rm,

2756: app.program_name
2757: INTO l_batch_app_status,
2758: l_program_name
2759: FROM ar_batches bat,
2760: ar_receipt_methods rm,
2761: ap_payment_programs app
2762: WHERE bat.batch_id = p_batch_id
2763: AND bat.receipt_method_id = rm.receipt_method_id
2764: AND rm.auto_print_program_id = app.program_id;

Line 3276: PROCEDURE build_queries(p_creation_rule IN ar_receipt_methods.receipt_creation_rule_code%TYPE,

3272:
3273: END update_ar_receipts_gt;
3274:
3275:
3276: PROCEDURE build_queries(p_creation_rule IN ar_receipt_methods.receipt_creation_rule_code%TYPE,
3277: p_approval_mode IN VARCHAR2,
3278: p_create_query OUT NOCOPY VARCHAR2,
3279: p_update_stmt OUT NOCOPY VARCHAR2,
3280: p_inv_rct_mp_qry OUT NOCOPY VARCHAR2 ) IS

Line 3786: PROCEDURE populate_receipt_numbers( p_rcpt_method_name IN ar_receipt_methods.name%TYPE,

3782:
3783:
3784:
3785: --validate and populate the receipt numbers
3786: PROCEDURE populate_receipt_numbers( p_rcpt_method_name IN ar_receipt_methods.name%TYPE,
3787: p_sob_id IN ar_batches.set_of_books_id%TYPE,
3788: p_batch_date IN DATE,
3789: p_receipt_method_id IN NUMBER,
3790: p_receipt_num_array OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,

Line 3862: l_name ar_receipt_methods.name%TYPE;

3858: p_batch_id IN ar_batches.batch_id%TYPE,
3859: p_approval_mode IN VARCHAR2 DEFAULT 'APPROVE' ) IS
3860:
3861: l_set_of_books_id ar_batches.set_of_books_id%TYPE;
3862: l_name ar_receipt_methods.name%TYPE;
3863: l_batch_date ar_batches.batch_date%TYPE;
3864: l_gl_date ar_batches.gl_date%TYPE;
3865: l_currency_code ar_batches.currency_code%TYPE;
3866: l_rec_creation_rule_code ar_receipt_methods.receipt_creation_rule_code%TYPE;

Line 3866: l_rec_creation_rule_code ar_receipt_methods.receipt_creation_rule_code%TYPE;

3862: l_name ar_receipt_methods.name%TYPE;
3863: l_batch_date ar_batches.batch_date%TYPE;
3864: l_gl_date ar_batches.gl_date%TYPE;
3865: l_currency_code ar_batches.currency_code%TYPE;
3866: l_rec_creation_rule_code ar_receipt_methods.receipt_creation_rule_code%TYPE;
3867: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
3868: l_called_from VARCHAR2(15);
3869: l_cash_receipt_id NUMBER(15);
3870: l_installment NUMBER;

Line 4101: ar_receipt_methods rm

4097: INTO l_called_from,
4098: l_rec_creation_rule_code,
4099: l_rec_inher_inv_num_flag
4100: FROM ar_receipt_classes rc,
4101: ar_receipt_methods rm
4102: WHERE rm.receipt_method_id = p_receipt_method_id
4103: AND rm.receipt_class_id = rc.receipt_class_id;
4104:
4105: SELECT b.set_of_books_id,

Line 4122: ar_receipt_methods r

4118: l_exchange_rate,
4119: l_exchange_date,
4120: l_exchange_rate_type
4121: FROM ar_batches b,
4122: ar_receipt_methods r
4123: WHERE b.batch_id = p_batch_id
4124: AND r.receipt_method_id = p_receipt_method_id
4125: AND b.receipt_method_id = r.receipt_method_id;
4126: