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_BATCHES

Line 10: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE,p_gt_id NUMBER);

6: PG_PARALLEL varchar2(1) := NVL(FND_PROFILE.value('AR_USE_PARALLEL_HINT'), 'N');
7:
8: G_ERROR varchar2(1) := 'N';
9:
10: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE,p_gt_id NUMBER);
11:
12: g_auth_fail varchar2(1) := 'N';
13:
14: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE);

Line 14: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE);

10: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE,p_gt_id NUMBER);
11:
12: g_auth_fail varchar2(1) := 'N';
13:
14: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE);
15:
16: PROCEDURE process_selected_receipts(
17: p_receipt_method_id in ar_cash_receipts.receipt_method_id%type default null,
18: p_batch_id in ar_batches.batch_id%type,

Line 18: p_batch_id in ar_batches.batch_id%type,

14: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE);
15:
16: PROCEDURE process_selected_receipts(
17: p_receipt_method_id in ar_cash_receipts.receipt_method_id%type default null,
18: p_batch_id in ar_batches.batch_id%type,
19: p_approval_mode IN VARCHAR2 DEFAULT 'APPROVE'
20: );
21:
22: g_rcpt_info_rec receipt_info_rec;

Line 291: l_receipt_method_id ar_batches.receipt_method_id%type;

287: END dump_ar_receipts_gt;
288:
289:
290: PROCEDURE process_incomplete_receipts(p_batch_id NUMBER) IS
291: l_receipt_method_id ar_batches.receipt_method_id%type;
292:
293: BEGIN
294: IF PG_DEBUG in ('Y', 'C') THEN
295: arp_debug.debug('process_incomplete_receipts()+');

Line 301: from ar_batches

297: END IF;
298:
299: select receipt_method_id
300: into l_receipt_method_id
301: from ar_batches
302: where batch_id = p_batch_id;
303:
304: --process partial receipts created during previous run
305: process_selected_receipts( p_receipt_method_id => l_receipt_method_id,

Line 609: from AR_BATCHES

605: l_gl_date,
606: l_currency_code,
607: l_receipt_method_id,
608: l_batch_app_status
609: from AR_BATCHES
610: where batch_id = p_batch_id;
611:
612: IF PG_DEBUG in ('Y','C') THEN
613: arp_debug.debug('batch_date '|| l_batch_date);

Line 754: UPDATE ar_batches

750: END IF;
751:
752: IF l_total_workers = 0 THEN
753: IF p_approve_flag = 'Y' THEN
754: UPDATE ar_batches
755: SET batch_applied_status = 'STARTED_APPROVAL'
756: WHERE batch_id = o_batch_id;
757: ELSIF p_create_flag = 'Y' THEN
758: UPDATE ar_batches

Line 758: UPDATE ar_batches

754: UPDATE ar_batches
755: SET batch_applied_status = 'STARTED_APPROVAL'
756: WHERE batch_id = o_batch_id;
757: ELSIF p_create_flag = 'Y' THEN
758: UPDATE ar_batches
759: SET batch_applied_status = 'COMPLETED_CREATION'
760: WHERE batch_id = o_batch_id;
761: END IF;
762:

Line 791: update ar_batches

787:
788: --If the current run is with only single worker then set the batch status else
789: --this is done in the master program
790: IF l_total_workers = 0 AND G_ERROR = 'N' THEN
791: update ar_batches
792: set batch_applied_status = 'COMPLETED_APPROVAL'
793: where batch_id = o_batch_id;
794:
795: IF PG_DEBUG in ('Y', 'C') THEN

Line 1003: l_batch_app_status ar_batches.batch_applied_status%TYPE;

999: o_batch_id NUMBER;
1000: l_batch_lock_msg VARCHAR2(200);
1001: l_batch_lock_flag BOOLEAN;
1002: l_batch_lock_excp EXCEPTION;
1003: l_batch_app_status ar_batches.batch_applied_status%TYPE;
1004:
1005: /* Bug 7639165 - Declaration Begin. */
1006: l_instrument_type VARCHAR2(30);
1007: /* Bug 7639165 - Declaration End. */

Line 1195: FROM ar_batches

1191: IF p_approve_flag = 'Y' THEN
1192: BEGIN
1193: SELECT batch_applied_status
1194: INTO l_batch_app_status
1195: FROM ar_batches
1196: WHERE batch_id = o_batch_id;
1197: EXCEPTION
1198: WHEN OTHERS THEN
1199: NULL;

Line 1232: UPDATE ar_batches

1228: END IF;
1229:
1230: IF p_approve_flag = 'Y' AND
1231: NVL(l_batch_app_status,'NONE') <> 'STARTED_APPROVAL' THEN
1232: UPDATE ar_batches
1233: SET batch_applied_status = 'STARTED_APPROVAL'
1234: WHERE batch_id = o_batch_id;
1235:
1236: ELSIF p_create_flag = 'Y' THEN

Line 1237: UPDATE ar_batches

1233: SET batch_applied_status = 'STARTED_APPROVAL'
1234: WHERE batch_id = o_batch_id;
1235:
1236: ELSIF p_create_flag = 'Y' THEN
1237: UPDATE ar_batches
1238: SET batch_applied_status = 'COMPLETED_CREATION'
1239: WHERE batch_id = o_batch_id;
1240: END IF;
1241:

Line 1281: UPDATE ar_batches

1277: END IF;
1278: END LOOP;
1279:
1280: IF P_RETCODE = 0 THEN
1281: UPDATE ar_batches
1282: SET batch_applied_status = 'COMPLETED_APPROVAL'
1283: WHERE batch_id = o_batch_id;
1284: END IF;
1285: END IF;

Line 1380: p_exchange_date IN ar_batches.exchange_date%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,
1379: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1380: p_exchange_date IN ar_batches.exchange_date%TYPE DEFAULT NULL,
1381: p_exchange_rate IN ar_batches.exchange_rate%TYPE DEFAULT NULL,
1382: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE DEFAULT NULL,
1383: p_batch_id OUT NOCOPY NUMBER
1384: ) IS

Line 1381: p_exchange_rate IN ar_batches.exchange_rate%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,
1379: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1380: p_exchange_date IN ar_batches.exchange_date%TYPE DEFAULT NULL,
1381: p_exchange_rate IN ar_batches.exchange_rate%TYPE DEFAULT NULL,
1382: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE DEFAULT NULL,
1383: p_batch_id OUT NOCOPY NUMBER
1384: ) IS
1385: l_batch_rec ar_batches%ROWTYPE;

Line 1382: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE DEFAULT NULL,

1378: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1379: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1380: p_exchange_date IN ar_batches.exchange_date%TYPE DEFAULT NULL,
1381: p_exchange_rate IN ar_batches.exchange_rate%TYPE DEFAULT NULL,
1382: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE DEFAULT NULL,
1383: p_batch_id OUT NOCOPY NUMBER
1384: ) IS
1385: l_batch_rec ar_batches%ROWTYPE;
1386: l_row_id VARCHAR2(50);

Line 1385: l_batch_rec ar_batches%ROWTYPE;

1381: p_exchange_rate IN ar_batches.exchange_rate%TYPE DEFAULT NULL,
1382: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE DEFAULT NULL,
1383: p_batch_id OUT NOCOPY NUMBER
1384: ) IS
1385: l_batch_rec ar_batches%ROWTYPE;
1386: l_row_id VARCHAR2(50);
1387: l_batch_id NUMBER := NULL;
1388: l_request_id NUMBER;
1389: l_batch_name VARCHAR2(30);

Line 1507: ar_batches ab

1503: pfunctional_currency,
1504: pacc_method
1505: FROM ar_system_parameters asp,
1506: gl_sets_of_books gsob,
1507: ar_batches ab
1508: WHERE ab.batch_id = p_batch_id
1509: AND ab.set_of_books_id = gsob.set_of_books_id
1510: AND gsob.set_of_books_id = asp.set_of_books_id;
1511:

Line 1574: p_batch_id IN ar_batches.batch_id%TYPE,

1570: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1571: p_customer_number_h IN hz_cust_accounts.account_number%TYPE, --Bug6734688
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

Line 1642: from ar_batches b,

1638: INTO p_currency_code,
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;

Line 2106: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,

2102: | Date Author Description of Changes |
2103: | 16-JUL-2005 bichatte Created |
2104: *=========================================================================*/
2105: PROCEDURE insert_exceptions(
2106: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
2107: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
2108: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
2109: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
2110: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

Line 2237: PROCEDURE SUBMIT_REPORT ( p_batch_id ar_batches.batch_id%TYPE,

2233: | Date Author Description of Changes |
2234: | 16-JUL-2005 bichatte Created |
2235: *=========================================================================*/
2236:
2237: PROCEDURE SUBMIT_REPORT ( p_batch_id ar_batches.batch_id%TYPE,
2238: p_request_id ar_cash_receipts.request_id%TYPE ) IS
2239:
2240: l_reqid NUMBER(15);
2241: l_org_id NUMBER;

Line 2262: from ar_batches_all

2258:
2259: if l_org_id is null then
2260: BEGIN
2261: select org_id into l_org_id
2262: from ar_batches_all
2263: where batch_id = p_batch_id;
2264: EXCEPTION
2265: when others then
2266: arp_debug.debug('Submit Report ...OTHERS');

Line 2708: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE ) IS

2704: END rec_reset;
2705:
2706:
2707: /* START SUBMIT_FORMAT */
2708: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE ) IS
2709: l_org_id NUMBER;
2710: l_reqid NUMBER;
2711: dev_phase VARCHAR2(255);
2712: dev_status VARCHAR2(255);

Line 2718: l_batch_app_status ar_batches.batch_applied_status%TYPE;

2714: phase VARCHAR2(255);
2715: status VARCHAR2(255);
2716: l_complete BOOLEAN := FALSE;
2717: l_program_name ap_payment_programs.program_name%TYPE;
2718: l_batch_app_status ar_batches.batch_applied_status%TYPE;
2719: l_xml_output BOOLEAN;
2720: l_iso_language FND_LANGUAGES.iso_language%TYPE;
2721: l_iso_territory FND_LANGUAGES.iso_territory%TYPE;
2722:

Line 2736: from ar_batches_all

2732: IF l_org_id IS NULL THEN
2733: BEGIN
2734: select org_id
2735: into l_org_id
2736: from ar_batches_all
2737: where batch_id = p_batch_id;
2738: EXCEPTION
2739: WHEN OTHERS THEN
2740: arp_debug.debug('Submit Format ...OTHERS');

Line 2759: FROM ar_batches bat,

2755: SELECT bat.batch_applied_status,
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

Line 2819: update ar_batches

2815: message =>message);
2816:
2817: IF dev_phase <> 'COMPLETE' THEN
2818: arp_debug.debug('Format Program has a phase '||dev_phase);
2819: update ar_batches
2820: SET batch_applied_status = 'COMPLETED_APPROVAL'
2821: where batch_id = p_batch_id;
2822: ELSIF dev_phase = 'COMPLETE' AND
2823: dev_status <> 'NORMAL' THEN

Line 2825: update ar_batches

2821: where batch_id = p_batch_id;
2822: ELSIF dev_phase = 'COMPLETE' AND
2823: dev_status <> 'NORMAL' THEN
2824: arp_debug.debug('Format Program completed with status '||dev_status);
2825: update ar_batches
2826: SET batch_applied_status = 'COMPLETED_APPROVAL'
2827: where batch_id = p_batch_id;
2828: ELSE
2829: arp_debug.debug('Format Program completed successfully');

Line 2830: update ar_batches

2826: SET batch_applied_status = 'COMPLETED_APPROVAL'
2827: where batch_id = p_batch_id;
2828: ELSE
2829: arp_debug.debug('Format Program completed successfully');
2830: update ar_batches
2831: SET batch_applied_status = 'COMPLETED_FORMAT'
2832: where batch_id = p_batch_id;
2833: END IF;
2834:

Line 2863: p_exchange_rate IN ar_batches.exchange_rate%TYPE,

2859: p_pmt_trxn_ext_id IN RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE,
2860: p_called_from IN VARCHAR2,
2861: p_request_id IN NUMBER,
2862: p_batch_id IN NUMBER,
2863: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
2864: p_exchange_date IN ar_batches.exchange_date%TYPE,
2865: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
2866: p_currency_code IN VARCHAR2,
2867: p_remittance_bank_account_id IN ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE,

Line 2864: p_exchange_date IN ar_batches.exchange_date%TYPE,

2860: p_called_from IN VARCHAR2,
2861: p_request_id IN NUMBER,
2862: p_batch_id IN NUMBER,
2863: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
2864: p_exchange_date IN ar_batches.exchange_date%TYPE,
2865: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
2866: p_currency_code IN VARCHAR2,
2867: p_remittance_bank_account_id IN ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE,
2868: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

Line 2865: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,

2861: p_request_id IN NUMBER,
2862: p_batch_id IN NUMBER,
2863: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
2864: p_exchange_date IN ar_batches.exchange_date%TYPE,
2865: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
2866: p_currency_code IN VARCHAR2,
2867: p_remittance_bank_account_id IN ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE,
2868: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
2869: p_return_status OUT NOCOPY VARCHAR2,

Line 3787: p_sob_id IN ar_batches.set_of_books_id%TYPE,

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,
3791: p_count IN NUMBER) IS

Line 3858: p_batch_id IN ar_batches.batch_id%TYPE,

3854:
3855:
3856:
3857: PROCEDURE process_selected_receipts( p_receipt_method_id IN ar_cash_receipts.receipt_method_id%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;

Line 3861: l_set_of_books_id ar_batches.set_of_books_id%TYPE;

3857: PROCEDURE process_selected_receipts( p_receipt_method_id IN ar_cash_receipts.receipt_method_id%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;

Line 3863: l_batch_date ar_batches.batch_date%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;
3867: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

Line 3864: l_gl_date ar_batches.gl_date%TYPE;

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;
3867: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
3868: l_called_from VARCHAR2(15);

Line 3865: l_currency_code ar_batches.currency_code%TYPE;

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;
3867: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
3868: l_called_from VARCHAR2(15);
3869: l_cash_receipt_id NUMBER(15);

Line 3914: l_exchange_rate ar_batches.exchange_rate%TYPE;

3910: l_cc_err_text_array DBMS_SQL.VARCHAR2_TABLE;
3911:
3912: l_apply_fail VARCHAR2(1) := 'N';
3913: l_pay_process_fail VARCHAR2(1) := 'N';
3914: l_exchange_rate ar_batches.exchange_rate%TYPE;
3915: l_exchange_date ar_batches.exchange_date%TYPE;
3916: l_exchange_rate_type ar_batches.exchange_rate_type%TYPE;
3917: l_rec_inher_inv_num_flag VARCHAR2(1) := 'N';
3918:

Line 3915: l_exchange_date ar_batches.exchange_date%TYPE;

3911:
3912: l_apply_fail VARCHAR2(1) := 'N';
3913: l_pay_process_fail VARCHAR2(1) := 'N';
3914: l_exchange_rate ar_batches.exchange_rate%TYPE;
3915: l_exchange_date ar_batches.exchange_date%TYPE;
3916: l_exchange_rate_type ar_batches.exchange_rate_type%TYPE;
3917: l_rec_inher_inv_num_flag VARCHAR2(1) := 'N';
3918:
3919: l_cc_error_code VARCHAR2(30);

Line 3916: l_exchange_rate_type ar_batches.exchange_rate_type%TYPE;

3912: l_apply_fail VARCHAR2(1) := 'N';
3913: l_pay_process_fail VARCHAR2(1) := 'N';
3914: l_exchange_rate ar_batches.exchange_rate%TYPE;
3915: l_exchange_date ar_batches.exchange_date%TYPE;
3916: l_exchange_rate_type ar_batches.exchange_rate_type%TYPE;
3917: l_rec_inher_inv_num_flag VARCHAR2(1) := 'N';
3918:
3919: l_cc_error_code VARCHAR2(30);
3920: l_cc_error_text VARCHAR2(2000);

Line 4121: FROM ar_batches b,

4117: l_currency_code,
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;

Line 5172: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE,

5168: END process_selected_receipts;
5169:
5170:
5171: /* START CONTROL_CHECK */
5172: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE,
5173: p_gt_id NUMBER ) IS
5174:
5175: BEGIN
5176: IF PG_DEBUG in ('Y', 'C') THEN