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_BATCHES

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

2: /* $Header: ARATREMB.pls 120.23.12010000.13 2009/01/26 19:40:06 nemani ship $ */
3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5: PG_PARALLEL varchar2(1) := NVL(FND_PROFILE.value('AR_USE_PARALLEL_HINT'), 'N');
6: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE);
7: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE);
8:
9: G_ERROR varchar2(1) := 'N';
10: TOTAL_WORKERS NUMBER := 0;

Line 7: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE);

3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5: PG_PARALLEL varchar2(1) := NVL(FND_PROFILE.value('AR_USE_PARALLEL_HINT'), 'N');
6: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE);
7: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE);
8:
9: G_ERROR varchar2(1) := 'N';
10: TOTAL_WORKERS NUMBER := 0;
11: WORKER_NUMBER NUMBER := 0;

Line 119: p_sob_id ar_batches.set_of_books_id%type;

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;
123: l_last_update_login NUMBER;

Line 128: l_batch_applied_status ar_batches.batch_applied_status%type;

124: l_program_application_id NUMBER;
125: l_program_id NUMBER;
126:
127:
128: l_batch_applied_status ar_batches.batch_applied_status%type;
129: pl_return_status VARCHAR2(1);
130: pl_msg_count NUMBER;
131: pl_msg_data VARCHAR2(240);
132: BEGIN

Line 323: from AR_BATCHES

319: select batch_date ,gl_date , remit_method_code, currency_code,
320: receipt_method_id, REMITTANCE_BANK_BRANCH_ID,REMIT_BANK_ACCT_USE_ID
321: into l_batch_date,l_gl_date,l_remittance_method,l_currency_code,
322: l_receipt_method_id,l_remittance_bank_branch_id,l_remittance_bank_account_id
323: from AR_BATCHES
324: where batch_id = p_batch_id;
325:
326: IF PG_DEBUG in ('Y','C') THEN
327: fnd_file.put_line(FND_FILE.LOG, 'For l_flow2 and l_flow3');

Line 373: ar_batches b

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;
377: else

Line 381: from ar_batches b

377: else
378: p_payment_type_code := null;
379: select b.set_of_books_id
380: into p_sob_id
381: from ar_batches b
382: where b.batch_id = o_batch_id;
383: end if;
384:
385:

Line 442: ar_batches b

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;
446: else

Line 450: from ar_batches b

446: else
447: p_payment_type_code := null;
448: select b.set_of_books_id
449: into p_sob_id
450: from ar_batches b
451: where b.batch_id = o_batch_id;
452: end if;
453:
454:

Line 531: ar_batches b

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
535: p_payment_type_code := null;

Line 538: from ar_batches b

534: else
535: p_payment_type_code := null;
536: select b.set_of_books_id
537: into p_sob_id
538: from ar_batches b
539: where b.batch_id = o_batch_id;
540: end if;
541:
542:

Line 585: ar_batches b

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
589: p_payment_type_code := null;

Line 592: from ar_batches b

588: else
589: p_payment_type_code := null;
590: select b.set_of_books_id
591: into p_sob_id
592: from ar_batches b
593: where b.batch_id = o_batch_id;
594: end if;
595:
596: IF p_create_flag = 'Y' THEN

Line 745: update ar_batches

741: l_control_count
742: FROM ar_cash_receipts cr
743: WHERE cr.selected_remittance_batch_id = o_batch_id;
744:
745: update ar_batches
746: SET batch_applied_status = l_batch_applied_status,
747: control_count = l_control_count,
748: control_amount= l_control_amount
749: where batch_id = o_batch_id;

Line 762: update ar_batches

758: WHERE crh.batch_id = o_batch_id
759: AND crh.status = 'REMITTED'
760: AND crh.current_record_flag = 'Y';
761:
762: update ar_batches
763: SET batch_applied_status = l_batch_applied_status,
764: control_count = l_control_count,
765: control_amount= l_control_amount
766: where batch_id = o_batch_id;

Line 769: update ar_batches

765: control_amount= l_control_amount
766: where batch_id = o_batch_id;
767: ELSE
768: /* No need to update counts if the batch is submitted for format only */
769: update ar_batches
770: SET batch_applied_status = l_batch_applied_status
771: where batch_id = o_batch_id;
772: END IF;
773: END IF;

Line 946: l_batch_applied_status ar_batches.batch_applied_status%TYPE;

942: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
943: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
944: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;
945: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;
946: l_batch_applied_status ar_batches.batch_applied_status%TYPE;
947: l_return_status VARCHAR2(1);
948: o_batch_id NUMBER;
949: l_ins_stmt VARCHAR2(5000);
950: ins_rec INTEGER;

Line 957: p_sob_id ar_batches.set_of_books_id%type;

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),
961: dev_phase VARCHAR2(255),

Line 1064: FROM ar_batches

1060: -- These validations should ideally be performed at form level.
1061: IF p_batch_id IS NOT NULL THEN
1062: SELECT batch_applied_status
1063: INTO l_batch_applied_status
1064: FROM ar_batches
1065: WHERE batch_id = p_batch_id;
1066:
1067: fnd_file.put_line( FND_FILE.LOG, 'Batch_Applied_Status : ' || l_batch_applied_status);
1068:

Line 1118: ar_batches b

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;
1122: else

Line 1126: from ar_batches b

1122: else
1123: p_payment_type_code := null;
1124: select b.set_of_books_id
1125: into p_sob_id
1126: from ar_batches b
1127: where b.batch_id = o_batch_id;
1128: end if;
1129: select_update_rec(
1130: p_customer_number_l=> p_customer_number_l,

Line 1274: ar_batches bat,

1270: hz_cust_accounts hca,
1271: hz_parties party,
1272: /*ar_remit_gt g,*/
1273: ar_cash_receipt_history crh,
1274: ar_batches bat,
1275: ar_receipt_method_accounts rma,
1276: ar_payment_schedules ps,
1277: ar_distributions d
1278: WHERE cr.selected_remittance_batch_id = :b_batch_id

Line 1363: UPDATE ar_batches

1359: l_control_count
1360: FROM ar_cash_receipts cr
1361: WHERE cr.selected_remittance_batch_id = o_batch_id;
1362:
1363: UPDATE ar_batches
1364: SET batch_applied_status = l_batch_applied_status,
1365: control_count = l_control_count,
1366: control_amount= l_control_amount
1367: WHERE batch_id = o_batch_id;

Line 1380: UPDATE ar_batches

1376: WHERE crh.batch_id = o_batch_id
1377: AND crh.status = 'REMITTED'
1378: AND crh.current_record_flag = 'Y';
1379:
1380: UPDATE ar_batches
1381: SET batch_applied_status = l_batch_applied_status,
1382: control_count = l_control_count,
1383: control_amount= l_control_amount
1384: WHERE batch_id = o_batch_id;

Line 1387: UPDATE ar_batches

1383: control_amount= l_control_amount
1384: WHERE batch_id = o_batch_id;
1385: ELSE
1386: /* No need to update counts if the batch is submitted for format only */
1387: UPDATE ar_batches
1388: SET batch_applied_status = l_batch_applied_status
1389: WHERE batch_id = o_batch_id;
1390: END IF;
1391:

Line 1443: p_currency_code IN ar_batches.currency_code%TYPE,

1439: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1440: p_batch_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1441: p_approve_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
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,

Line 1444: p_remmitance_method IN ar_batches.remit_method_code%TYPE,

1440: p_batch_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1441: p_approve_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
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,

Line 1451: l_batch_rec ar_batches%ROWTYPE;

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
1451: l_batch_rec ar_batches%ROWTYPE;
1452: l_row_id VARCHAR2(50);
1453: l_batch_id NUMBER := NULL;
1454: l_batch_name VARCHAR2(30);
1455: l_batch_applied_status VARCHAR2(30);

Line 1680: ar_batches ab

1676: pfunctional_currency,
1677: pacc_method
1678: FROM ar_system_parameters asp,
1679: gl_sets_of_books gsob,
1680: ar_batches ab
1681: WHERE ab.batch_id = p_batch_id
1682: AND ab.set_of_books_id = gsob.set_of_books_id
1683: AND gsob.set_of_books_id = asp.set_of_books_id;
1684: EXCEPTION

Line 1856: from ar_batches

1852: END IF;
1853:
1854: select decode(remit_method_code, 'FACTORING', 'Y', 'N')
1855: into l_factor_flag
1856: from ar_batches
1857: where batch_id = p_batch_id;
1858:
1859:
1860: l_request_id := arp_standard.profile.request_id;

Line 1900: ar_batches bat,

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
1904: WHERE cr.selected_remittance_batch_id = :ab_batch_id

Line 2637: from ar_batches

2633: END IF;
2634:
2635: select decode(remit_method_code, 'FACTORING', 'Y', 'N')
2636: into l_factor_flag
2637: from ar_batches
2638: where batch_id = p_batch_id;
2639:
2640: l_request_id := arp_standard.profile.request_id;
2641: l_last_updated_by := arp_standard.profile.last_update_login ;

Line 3290: p_batch_id IN ar_batches.batch_id%TYPE,

3286: p_trx_num_l IN ar_payment_schedules.trx_number%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,

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

5153: | Date Author Description of Changes |
5154: | 16-JUL-2005 bichatte Created |
5155: *=========================================================================*/
5156: PROCEDURE insert_exceptions(
5157: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
5158: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
5159: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5160: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
5161: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

Line 5307: p_batch_id ar_batches.batch_id%TYPE,

5303: | 16-JUL-2005 bichatte Created |
5304: *=========================================================================*/
5305:
5306: PROCEDURE SUBMIT_REPORT (
5307: p_batch_id ar_batches.batch_id%TYPE,
5308: p_request_id ar_cash_receipts.request_id%TYPE
5309: ) IS
5310:
5311: l_reqid NUMBER(15);

Line 5328: from ar_batches_all

5324: if l_org_id is null then
5325:
5326: BEGIN
5327: select org_id into l_org_id
5328: from ar_batches_all
5329: where batch_id = p_batch_id;
5330: EXCEPTION
5331: when others then
5332: arp_util.debug('ar_autorem_api.submit Report ...OTHERS');

Line 5371: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE

5367: END SUBMIT_REPORT;
5368:
5369:
5370: /* START SUBMIT_FORMAT */
5371: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE
5372: ) IS
5373:
5374: l_org_id NUMBER;
5375: l_reqid NUMBER;

Line 5391: from ar_batches_all

5387: if l_org_id is null then
5388: BEGIN
5389:
5390: select org_id into l_org_id
5391: from ar_batches_all
5392: where batch_id = p_batch_id;
5393: EXCEPTION
5394: when others then
5395: arp_util.debug('ar_autorem_api.submit Report ...OTHERS');

Line 5430: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE

5426: /* END SUBMIT_FORMAT */
5427:
5428:
5429: /* START CONTROL_CHECK */
5430: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE
5431: ) IS
5432: l_request_id NUMBER;
5433: l_last_updated_by NUMBER;
5434: l_created_by NUMBER;