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 6: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE);

2: /* $Header: ARATRECB.pls 120.40.12010000.12 2009/01/04 14:17:01 nemani ship $ */
3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5: G_ERROR varchar2(1) := '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: g_auth_fail varchar2(1) := 'N';
9: g_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
10: g_format_flag ar_cash_receipts.confirmed_flag%TYPE ;

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: G_ERROR varchar2(1) := '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: g_auth_fail varchar2(1) := 'N';
9: g_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
10: g_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
11: g_create_flag ar_cash_receipts.confirmed_flag%TYPE ;

Line 245: from AR_BATCHES

241: o_batch_id := p_batch_id;
242:
243: select batch_date ,gl_date , currency_code, receipt_method_id
244: into l_batch_date,l_gl_date,l_currency_code, l_receipt_method_id
245: from AR_BATCHES
246: where batch_id = p_batch_id;
247:
248: IF PG_DEBUG in ('Y','C') THEN
249: arp_standard.debug( 'value batch_date' || l_batch_date);

Line 345: update ar_batches SET

341: arp_standard.debug (' COMMITING WORK ');
342: arp_standard.debug ( 'NO of PS rows updated = '|| to_char(SQL%ROWCOUNT));
343: END IF;
344:
345: update ar_batches SET
346: batch_applied_status = 'COMPLETED_CREATION'
347: where batch_id = o_batch_id;
348:
349: COMMIT;

Line 410: update ar_batches SET

406: where payment_schedule_id in (select PAYMENT_SCHEDULE_ID from AR_RECEIPTS_GT);
407:
408: arp_standard.debug ( 'NO of PS rows updated = '|| to_char(SQL%ROWCOUNT));
409:
410: update ar_batches SET
411: batch_applied_status = 'COMPLETED_CREATION'
412: where batch_id = o_batch_id;
413:
414: else -- Only for approval

Line 815: update ar_batches SET

811: l_program_application_id := arp_standard.application_id ;
812: l_program_id := arp_standard.profile.program_id;
813:
814:
815: update ar_batches SET
816: batch_applied_status = 'COMPLETED_APPROVAL'
817: where batch_id = o_batch_id;
818:
819:

Line 1005: l_batch_rec ar_batches%ROWTYPE;

1001: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1002: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1003: p_batch_id OUT NOCOPY NUMBER
1004: ) IS
1005: l_batch_rec ar_batches%ROWTYPE;
1006: l_row_id VARCHAR2(50);
1007: l_batch_id NUMBER := NULL;
1008: l_batch_name VARCHAR2(30);
1009: l_batch_applied_status VARCHAR2(30);

Line 1131: ar_batches ab

1127: pfunctional_currency,
1128: pacc_method
1129: FROM ar_system_parameters asp,
1130: gl_sets_of_books gsob,
1131: ar_batches ab
1132: WHERE ab.batch_id = p_batch_id
1133: AND ab.set_of_books_id = gsob.set_of_books_id
1134: AND gsob.set_of_books_id = asp.set_of_books_id;
1135: EXCEPTION

Line 1199: p_batch_id IN ar_batches.batch_id%TYPE,

1195: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1196: p_customer_number_h IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1197: p_customer_name_l IN hz_parties.party_name%TYPE, --Bug6734688
1198: p_customer_name_h IN hz_parties.party_name%TYPE, --Bug6734688
1199: p_batch_id IN ar_batches.batch_id%TYPE,
1200: p_approve_only_flag IN VARCHAR2 ,--Bug5344405
1201: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
1202: p_payment_schedule_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE,
1203: p_customer_trx_id OUT NOCOPY ar_payment_schedules.customer_trx_id%TYPE,

Line 1262: from ar_batches b,

1258: INTO p_currency_code,
1259: p_batch_date,
1260: p_lead_days,
1261: p_creation_rule
1262: from ar_batches b,
1263: ar_receipt_methods r
1264: WHERE b.batch_id = p_batch_id
1265: AND b.receipt_method_id = r.receipt_method_id
1266: AND r.receipt_method_id = p_receipt_method_id;

Line 1763: p_batch_id IN ar_batches.batch_id%TYPE

1759: *=========================================================================*/
1760:
1761: PROCEDURE group_val_create_receipts(
1762: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
1763: p_batch_id IN ar_batches.batch_id%TYPE
1764: ) IS
1765:
1766: p_creation_rule VARCHAR2(40);
1767: l_status NUMBER;

Line 1770: p_set_of_books_id ar_batches.set_of_books_id%TYPE;

1766: p_creation_rule VARCHAR2(40);
1767: l_status NUMBER;
1768: l_doc_sequence_value ra_customer_trx.doc_sequence_value%TYPE;
1769: l_doc_sequence_id ra_customer_trx.doc_sequence_id%TYPE;
1770: p_set_of_books_id ar_batches.set_of_books_id%TYPE;
1771: p_name ar_receipt_methods.name%TYPE;
1772: p_batch_date ar_batches.batch_date%TYPE;
1773: p_currency_code ar_batches.currency_code%TYPE;
1774: p_exchange_rate ar_batches.exchange_rate%TYPE; -- Added for Bug 7313058

Line 1772: p_batch_date ar_batches.batch_date%TYPE;

1768: l_doc_sequence_value ra_customer_trx.doc_sequence_value%TYPE;
1769: l_doc_sequence_id ra_customer_trx.doc_sequence_id%TYPE;
1770: p_set_of_books_id ar_batches.set_of_books_id%TYPE;
1771: p_name ar_receipt_methods.name%TYPE;
1772: p_batch_date ar_batches.batch_date%TYPE;
1773: p_currency_code ar_batches.currency_code%TYPE;
1774: p_exchange_rate ar_batches.exchange_rate%TYPE; -- Added for Bug 7313058
1775: p_exchange_date ar_batches.exchange_date%TYPE; -- Added for Bug 7313058
1776: p_exchange_rate_type ar_batches.exchange_rate_type%TYPE; -- Added for Bug 7313058

Line 1773: p_currency_code ar_batches.currency_code%TYPE;

1769: l_doc_sequence_id ra_customer_trx.doc_sequence_id%TYPE;
1770: p_set_of_books_id ar_batches.set_of_books_id%TYPE;
1771: p_name ar_receipt_methods.name%TYPE;
1772: p_batch_date ar_batches.batch_date%TYPE;
1773: p_currency_code ar_batches.currency_code%TYPE;
1774: p_exchange_rate ar_batches.exchange_rate%TYPE; -- Added for Bug 7313058
1775: p_exchange_date ar_batches.exchange_date%TYPE; -- Added for Bug 7313058
1776: p_exchange_rate_type ar_batches.exchange_rate_type%TYPE; -- Added for Bug 7313058
1777: p_number_of_remit_accts NUMBER;

Line 1774: p_exchange_rate ar_batches.exchange_rate%TYPE; -- Added for Bug 7313058

1770: p_set_of_books_id ar_batches.set_of_books_id%TYPE;
1771: p_name ar_receipt_methods.name%TYPE;
1772: p_batch_date ar_batches.batch_date%TYPE;
1773: p_currency_code ar_batches.currency_code%TYPE;
1774: p_exchange_rate ar_batches.exchange_rate%TYPE; -- Added for Bug 7313058
1775: p_exchange_date ar_batches.exchange_date%TYPE; -- Added for Bug 7313058
1776: p_exchange_rate_type ar_batches.exchange_rate_type%TYPE; -- Added for Bug 7313058
1777: p_number_of_remit_accts NUMBER;
1778: l_require_confirmation VARCHAR2(1);

Line 1775: p_exchange_date ar_batches.exchange_date%TYPE; -- Added for Bug 7313058

1771: p_name ar_receipt_methods.name%TYPE;
1772: p_batch_date ar_batches.batch_date%TYPE;
1773: p_currency_code ar_batches.currency_code%TYPE;
1774: p_exchange_rate ar_batches.exchange_rate%TYPE; -- Added for Bug 7313058
1775: p_exchange_date ar_batches.exchange_date%TYPE; -- Added for Bug 7313058
1776: p_exchange_rate_type ar_batches.exchange_rate_type%TYPE; -- Added for Bug 7313058
1777: p_number_of_remit_accts NUMBER;
1778: l_require_confirmation VARCHAR2(1);
1779: l_rec_inher_inv_num_flag VARCHAR2(1);

Line 1776: p_exchange_rate_type ar_batches.exchange_rate_type%TYPE; -- Added for Bug 7313058

1772: p_batch_date ar_batches.batch_date%TYPE;
1773: p_currency_code ar_batches.currency_code%TYPE;
1774: p_exchange_rate ar_batches.exchange_rate%TYPE; -- Added for Bug 7313058
1775: p_exchange_date ar_batches.exchange_date%TYPE; -- Added for Bug 7313058
1776: p_exchange_rate_type ar_batches.exchange_rate_type%TYPE; -- Added for Bug 7313058
1777: p_number_of_remit_accts NUMBER;
1778: l_require_confirmation VARCHAR2(1);
1779: l_rec_inher_inv_num_flag VARCHAR2(1);
1780: l_receipt_class_id NUMBER(15);

Line 1864: from ar_batches b,

1860: ,p_exchange_date
1861: ,p_exchange_rate_type
1862: /** Changes for Bug 7313058 End Here **/
1863: ,l_rec_inher_inv_num_flag
1864: from ar_batches b,
1865: ar_receipt_methods r
1866: where b.batch_id = p_batch_id
1867: and r.receipt_method_id = p_receipt_method_id
1868: and b.receipt_method_id = r.receipt_method_id;

Line 2169: from ar_batches b,

2165: ,p_exchange_rate
2166: ,p_exchange_date
2167: ,p_exchange_rate_type
2168: /** Changes for Bug 7313058 End Here **/
2169: from ar_batches b,
2170: ar_receipt_methods r
2171: where b.batch_id = p_batch_id
2172: and r.receipt_method_id = p_receipt_method_id
2173: and b.receipt_method_id = r.receipt_method_id;

Line 2455: from ar_batches b,

2451: ,p_exchange_rate
2452: ,p_exchange_date
2453: ,p_exchange_rate_type
2454: /** Changes for Bug 7313058 End Here **/
2455: from ar_batches b,
2456: ar_receipt_methods r
2457: where b.batch_id = p_batch_id
2458: and r.receipt_method_id = p_receipt_method_id
2459: and b.receipt_method_id = r.receipt_method_id;

Line 2747: from ar_batches b,

2743: ,p_exchange_rate
2744: ,p_exchange_date
2745: ,p_exchange_rate_type
2746: /** Changes for Bug 7313058 End Here **/
2747: from ar_batches b,
2748: ar_receipt_methods r
2749: where b.batch_id = p_batch_id
2750: and r.receipt_method_id = p_receipt_method_id
2751: and b.receipt_method_id = r.receipt_method_id;

Line 3040: from ar_batches b,

3036: ,p_exchange_rate
3037: ,p_exchange_date
3038: ,p_exchange_rate_type
3039: /** Changes for Bug 7313058 End Here **/
3040: from ar_batches b,
3041: ar_receipt_methods r
3042: where b.batch_id = p_batch_id
3043: and r.receipt_method_id = p_receipt_method_id
3044: and b.receipt_method_id = r.receipt_method_id;

Line 3327: from ar_batches b,

3323: ,p_exchange_rate
3324: ,p_exchange_date
3325: ,p_exchange_rate_type
3326: /** Changes for Bug 7313058 End Here **/
3327: from ar_batches b,
3328: ar_receipt_methods r
3329: where b.batch_id = p_batch_id
3330: and r.receipt_method_id = p_receipt_method_id
3331: and b.receipt_method_id = r.receipt_method_id;

Line 3593: from ar_batches b,

3589: ,p_exchange_rate
3590: ,p_exchange_date
3591: ,p_exchange_rate_type
3592: /** Changes for Bug 7313058 End Here **/
3593: from ar_batches b,
3594: ar_receipt_methods r
3595: where b.batch_id = p_batch_id
3596: and r.receipt_method_id = p_receipt_method_id
3597: and b.receipt_method_id = r.receipt_method_id;

Line 3858: from ar_batches b,

3854: ,p_exchange_rate
3855: ,p_exchange_date
3856: ,p_exchange_rate_type
3857: /** Changes for Bug 7313058 End Here **/
3858: from ar_batches b,
3859: ar_receipt_methods r
3860: where b.batch_id = p_batch_id
3861: and r.receipt_method_id = p_receipt_method_id
3862: and b.receipt_method_id = r.receipt_method_id;

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

4132: | Date Author Description of Changes |
4133: | 16-JUL-2005 bichatte Created |
4134: *=========================================================================*/
4135: PROCEDURE insert_exceptions(
4136: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
4137: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
4138: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
4139: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4140: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

Line 4291: p_batch_id ar_batches.batch_id%TYPE,

4287: | 16-JUL-2005 bichatte Created |
4288: *=========================================================================*/
4289:
4290: PROCEDURE SUBMIT_REPORT (
4291: p_batch_id ar_batches.batch_id%TYPE,
4292: p_request_id ar_cash_receipts.request_id%TYPE
4293: ) IS
4294:
4295: l_reqid NUMBER(15);

Line 4312: from ar_batches_all

4308: if l_org_id is null then
4309:
4310: BEGIN
4311: select org_id into l_org_id
4312: from ar_batches_all
4313: where batch_id = p_batch_id;
4314: EXCEPTION
4315: when others then
4316: arp_util.debug('Submit Report ...OTHERS');

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

4349: END SUBMIT_REPORT;
4350:
4351:
4352: /* START CONTROL_CHECK */
4353: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE
4354: ) IS
4355: l_request_id NUMBER;
4356: l_last_updated_by NUMBER;
4357: l_created_by NUMBER;

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

4833:
4834: END rec_reset;
4835:
4836: /* START SUBMIT_FORMAT */
4837: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE
4838: ) IS
4839:
4840: l_org_id NUMBER;
4841: l_reqid NUMBER;

Line 4862: from ar_batches_all

4858: if l_org_id is null then
4859:
4860: BEGIN
4861: select org_id into l_org_id
4862: from ar_batches_all
4863: where batch_id = p_batch_id;
4864: EXCEPTION
4865: when others then
4866: arp_util.debug('Submit Format ...OTHERS');

Line 4892: update ar_batches SET

4888: message =>message);
4889:
4890: IF dev_phase <> 'COMPLETE' THEN
4891: arp_util.debug('Format Program has a phase '||dev_phase);
4892: update ar_batches SET
4893: batch_applied_status = 'COMPLETED_APPROVAL'
4894: where batch_id = p_batch_id;
4895: ELSIF dev_phase = 'COMPLETE'
4896: AND dev_status <> 'NORMAL' THEN

Line 4898: update ar_batches SET

4894: where batch_id = p_batch_id;
4895: ELSIF dev_phase = 'COMPLETE'
4896: AND dev_status <> 'NORMAL' THEN
4897: arp_util.debug('Format Program completed with status '||dev_status);
4898: update ar_batches SET
4899: batch_applied_status = 'COMPLETED_APPROVAL'
4900: where batch_id = p_batch_id;
4901: ELSE
4902: arp_util.debug('Format Program completed successfully');

Line 4903: update ar_batches SET

4899: batch_applied_status = 'COMPLETED_APPROVAL'
4900: where batch_id = p_batch_id;
4901: ELSE
4902: arp_util.debug('Format Program completed successfully');
4903: update ar_batches SET
4904: batch_applied_status = 'COMPLETED_FORMAT'
4905: where batch_id = p_batch_id;
4906: END IF;
4907: