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 7: PROCEDURE SUBMIT_FORMAT ( 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: PG_APPEND varchar2(1) := NVL(FND_PROFILE.value('AR_USE_APPEND_HINT'), 'Y');
7: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE);
8: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE);
9:
10: G_ERROR varchar2(1) := 'N';
11: TOTAL_WORKERS NUMBER := 0;

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

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: PG_APPEND varchar2(1) := NVL(FND_PROFILE.value('AR_USE_APPEND_HINT'), 'Y');
7: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE);
8: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE);
9:
10: G_ERROR varchar2(1) := 'N';
11: TOTAL_WORKERS NUMBER := 0;
12: WORKER_NUMBER NUMBER := 0;

Line 123: p_sob_id ar_batches.set_of_books_id%type;

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

Line 132: l_batch_applied_status ar_batches.batch_applied_status%type;

128: l_program_application_id NUMBER;
129: l_program_id NUMBER;
130:
131:
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;

Line 331: from AR_BATCHES

327: select batch_date ,gl_date , remit_method_code, currency_code,
328: receipt_method_id, REMITTANCE_BANK_BRANCH_ID,REMIT_BANK_ACCT_USE_ID
329: into l_batch_date,l_gl_date,l_remittance_method,l_currency_code,
330: l_receipt_method_id,l_remittance_bank_branch_id,l_remittance_bank_account_id
331: from AR_BATCHES
332: where batch_id = p_batch_id;
333:
334: IF PG_DEBUG in ('Y','C') THEN
335: fnd_file.put_line(FND_FILE.LOG, 'For l_flow2 and l_flow3');

Line 382: ar_batches b

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

Line 390: from ar_batches b

386: else
387: p_payment_type_code := null;
388: select b.set_of_books_id
389: into p_sob_id
390: from ar_batches b
391: where b.batch_id = o_batch_id;
392: end if;
393:
394:

Line 456: ar_batches b

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

Line 464: from ar_batches b

460: else
461: p_payment_type_code := null;
462: select b.set_of_books_id
463: into p_sob_id
464: from ar_batches b
465: where b.batch_id = o_batch_id;
466: end if;
467:
468:

Line 549: ar_batches b

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

Line 556: from ar_batches b

552: else
553: p_payment_type_code := null;
554: select b.set_of_books_id
555: into p_sob_id
556: from ar_batches b
557: where b.batch_id = o_batch_id;
558: end if;
559:
560:

Line 607: ar_batches b

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

Line 614: from ar_batches b

610: else
611: p_payment_type_code := null;
612: select b.set_of_books_id
613: into p_sob_id
614: from ar_batches b
615: where b.batch_id = o_batch_id;
616: end if;
617:
618: IF p_create_flag = 'Y' THEN

Line 771: update ar_batches

767: l_control_count
768: FROM ar_cash_receipts cr
769: WHERE cr.selected_remittance_batch_id = o_batch_id;
770:
771: update ar_batches
772: SET batch_applied_status = l_batch_applied_status,
773: control_count = l_control_count,
774: control_amount= l_control_amount
775: where batch_id = o_batch_id;

Line 788: update ar_batches

784: WHERE crh.batch_id = o_batch_id
785: AND crh.status = 'REMITTED'
786: AND crh.current_record_flag = 'Y';
787:
788: update ar_batches
789: SET batch_applied_status = l_batch_applied_status,
790: control_count = l_control_count,
791: control_amount= l_control_amount
792: where batch_id = o_batch_id;

Line 795: update ar_batches

791: control_amount= l_control_amount
792: where batch_id = o_batch_id;
793: ELSE
794: /* No need to update counts if the batch is submitted for format only */
795: update ar_batches
796: SET batch_applied_status = l_batch_applied_status
797: where batch_id = o_batch_id;
798: END IF;
799: END IF;

Line 995: l_batch_applied_status ar_batches.batch_applied_status%TYPE;

991: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
992: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
993: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;
994: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;
995: l_batch_applied_status ar_batches.batch_applied_status%TYPE;
996: l_return_status VARCHAR2(1);
997: o_batch_id NUMBER;
998: l_ins_stmt VARCHAR2(5000);
999: ins_rec INTEGER;

Line 1006: p_sob_id ar_batches.set_of_books_id%type;

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

Line 1116: FROM ar_batches

1112: -- These validations should ideally be performed at form level.
1113: IF p_batch_id IS NOT NULL THEN
1114: SELECT batch_applied_status
1115: INTO l_batch_applied_status
1116: FROM ar_batches
1117: WHERE batch_id = p_batch_id;
1118:
1119: fnd_file.put_line( FND_FILE.LOG, 'Batch_Applied_Status : ' || l_batch_applied_status);
1120:

Line 1171: ar_batches b

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

Line 1179: from ar_batches b

1175: else
1176: p_payment_type_code := null;
1177: select b.set_of_books_id
1178: into p_sob_id
1179: from ar_batches b
1180: where b.batch_id = o_batch_id;
1181: end if;
1182: select_update_rec(
1183: p_customer_number_l=> p_customer_number_l,

Line 1338: ar_batches bat,

1334: hz_cust_accounts hca,
1335: hz_parties party,
1336: /*ar_remit_gt g,*/
1337: ar_cash_receipt_history crh,
1338: ar_batches bat,
1339: ar_receipt_method_accounts rma,
1340: ar_distributions d
1341: WHERE cr.selected_remittance_batch_id = :b_batch_id
1342: AND cr.REMIT_BANK_ACCT_USE_ID = rma.REMIT_BANK_ACCT_USE_ID

Line 1426: UPDATE ar_batches

1422: l_control_count
1423: FROM ar_cash_receipts cr
1424: WHERE cr.selected_remittance_batch_id = o_batch_id;
1425:
1426: UPDATE ar_batches
1427: SET batch_applied_status = l_batch_applied_status,
1428: control_count = l_control_count,
1429: control_amount= l_control_amount
1430: WHERE batch_id = o_batch_id;

Line 1443: UPDATE ar_batches

1439: WHERE crh.batch_id = o_batch_id
1440: AND crh.status = 'REMITTED'
1441: AND crh.current_record_flag = 'Y';
1442:
1443: UPDATE ar_batches
1444: SET batch_applied_status = l_batch_applied_status,
1445: control_count = l_control_count,
1446: control_amount= l_control_amount
1447: WHERE batch_id = o_batch_id;

Line 1450: UPDATE ar_batches

1446: control_amount= l_control_amount
1447: WHERE batch_id = o_batch_id;
1448: ELSE
1449: /* No need to update counts if the batch is submitted for format only */
1450: UPDATE ar_batches
1451: SET batch_applied_status = l_batch_applied_status
1452: WHERE batch_id = o_batch_id;
1453: END IF;
1454:

Line 1506: p_currency_code IN ar_batches.currency_code%TYPE,

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

Line 1507: p_remmitance_method IN ar_batches.remit_method_code%TYPE,

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

Line 1512: p_remit_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE DEFAULT NULL, --bug12924584

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
1514: ) IS
1515: l_batch_rec ar_batches%ROWTYPE;
1516: l_row_id VARCHAR2(50);

Line 1515: l_batch_rec ar_batches%ROWTYPE;

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
1514: ) IS
1515: l_batch_rec ar_batches%ROWTYPE;
1516: l_row_id VARCHAR2(50);
1517: l_batch_id NUMBER := NULL;
1518: l_batch_name VARCHAR2(30);
1519: l_batch_applied_status VARCHAR2(30);

Line 1744: ar_batches ab

1740: pfunctional_currency,
1741: pacc_method
1742: FROM ar_system_parameters asp,
1743: gl_sets_of_books gsob,
1744: ar_batches ab
1745: WHERE ab.batch_id = p_batch_id
1746: AND ab.set_of_books_id = gsob.set_of_books_id
1747: AND gsob.set_of_books_id = asp.set_of_books_id;
1748: EXCEPTION

Line 1920: from ar_batches

1916: END IF;
1917:
1918: select decode(remit_method_code, 'FACTORING', 'Y', 'N')
1919: into l_factor_flag
1920: from ar_batches
1921: where batch_id = p_batch_id;
1922:
1923:
1924: l_request_id := arp_standard.profile.request_id;

Line 1964: ar_batches bat,

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

Line 2701: from ar_batches

2697: END IF;
2698:
2699: select decode(remit_method_code, 'FACTORING', 'Y', 'N')
2700: into l_factor_flag
2701: from ar_batches
2702: where batch_id = p_batch_id;
2703:
2704: l_request_id := arp_standard.profile.request_id;
2705: l_last_updated_by := arp_standard.profile.user_id ;

Line 3372: p_batch_id IN ar_batches.batch_id%TYPE,

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

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

5430: | Date Author Description of Changes |
5431: | 16-JUL-2005 bichatte Created |
5432: *=========================================================================*/
5433: PROCEDURE insert_exceptions(
5434: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
5435: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
5436: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5437: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
5438: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

Line 5584: p_batch_id ar_batches.batch_id%TYPE,

5580: | 16-JUL-2005 bichatte Created |
5581: *=========================================================================*/
5582:
5583: PROCEDURE SUBMIT_REPORT (
5584: p_batch_id ar_batches.batch_id%TYPE,
5585: p_request_id ar_cash_receipts.request_id%TYPE
5586: ) IS
5587:
5588: l_reqid NUMBER(15);

Line 5611: from ar_batches_all

5607: if l_org_id is null then
5608:
5609: BEGIN
5610: select org_id into l_org_id
5611: from ar_batches_all
5612: where batch_id = p_batch_id;
5613: EXCEPTION
5614: when others then
5615: arp_util.debug('ar_autorem_api.submit Report ...OTHERS');

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

5660: END SUBMIT_REPORT;
5661:
5662:
5663: /* START SUBMIT_FORMAT */
5664: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE
5665: ) IS
5666:
5667: l_org_id NUMBER;
5668: l_reqid NUMBER;

Line 5685: from ar_batches_all

5681: if l_org_id is null then
5682: BEGIN
5683:
5684: select org_id into l_org_id
5685: from ar_batches_all
5686: where batch_id = p_batch_id;
5687: EXCEPTION
5688: when others then
5689: arp_util.debug('ar_autorem_api.submit Report ...OTHERS');

Line 5699: from ar_batches ab,

5695: fnd_request.set_org_id(l_org_id);
5696:
5697: select nvl(decode(ab.remit_method_code,'FACTORING',appfactor.program_name,appremit.program_name),'ARXAPFRM')
5698: into l_prog_name
5699: from ar_batches ab,
5700: ar_receipt_method_accounts rma,
5701: ap_payment_programs appremit,
5702: ap_payment_programs appfactor
5703: where ab.type = 'REMITTANCE'

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

5733: /* END SUBMIT_FORMAT */
5734:
5735:
5736: /* START CONTROL_CHECK */
5737: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE
5738: ) IS
5739: l_request_id NUMBER;
5740: l_last_updated_by NUMBER;
5741: l_created_by NUMBER;