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_CLASSES

Line 150: ar_receipt_classes rc

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
154: and ra.status = 'APP'

Line 405: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;

401: l_total_workers NUMBER;
402: l_request_id ar_cash_receipts.request_id%TYPE;
403: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
404: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
405: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
406: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
407: l_currency_code ar_cash_receipts.currency_code%TYPE;
408: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
409: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;

Line 992: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;

988:
989: l_request_id ar_cash_receipts.request_id%TYPE;
990: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
991: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
992: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
993: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
994: l_currency_code ar_cash_receipts.currency_code%TYPE;
995: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
996: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;

Line 1374: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,

1370:
1371: PROCEDURE insert_batch(
1372: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1373: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1374: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
1375: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
1376: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1377: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1378: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,

Line 3887: l_creation_method_code ar_receipt_classes.creation_method_code%type;

3883: l_amt_applied NUMBER;
3884: l_cust_site_min_rec_amt NUMBER;
3885: l_rec_method_min_rec_amt NUMBER;
3886: l_min_rec_amount_allowed NUMBER;
3887: l_creation_method_code ar_receipt_classes.creation_method_code%type;
3888: l_remittance_bank_account_id ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE;
3889: l_state ar_receipt_classes.creation_status%TYPE;
3890: l_old_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
3891:

Line 3889: l_state ar_receipt_classes.creation_status%TYPE;

3885: l_rec_method_min_rec_amt NUMBER;
3886: l_min_rec_amount_allowed NUMBER;
3887: l_creation_method_code ar_receipt_classes.creation_method_code%type;
3888: l_remittance_bank_account_id ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE;
3889: l_state ar_receipt_classes.creation_status%TYPE;
3890: l_old_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
3891:
3892: l_paying_customer_id_array DBMS_SQL.NUMBER_TABLE;
3893: l_paying_site_use_id_array DBMS_SQL.NUMBER_TABLE;

Line 4100: FROM ar_receipt_classes rc,

4096: nvl(rm.receipt_inherit_inv_num_flag,'N')
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: