APPS.AR_AUTOREC_API dependencies on AR_AUTOREC_EXCEPTIONS

Line 2158: INSERT INTO ar_autorec_exceptions

2154: arp_debug.debug('l_program_application_id '|| to_char(pg_program_application_id) );
2155: arp_debug.debug('l_program_id '|| to_char(pg_program_id) );
2156: END IF;
2157:
2158: INSERT INTO ar_autorec_exceptions
2159: (batch_id,
2160: request_id,
2161: cash_receipt_id,
2162: payment_schedule_id,

Line 2366: delete from ar_autorec_exceptions

2362: IF PG_DEBUG in ('Y', 'C') THEN
2363: fnd_file.put_line(FND_FILE.LOG,'receipt rows updated to reset cc_error_flag : '||sql%rowcount);
2364: END IF;
2365:
2366: delete from ar_autorec_exceptions
2367: where cash_receipt_id in
2368: ( SELECT /*+ LEADING(R) INDEX (R, AR_RECEIPTS_GT_N1) USE_NL(R, CR) */ cr.cash_receipt_id
2369: FROM ar_receipts_gt r,
2370: ar_cash_receipts cr,

Line 2395: fnd_file.put_line(FND_FILE.LOG,'rows deleted from ar_autorec_exceptions: '||sql%rowcount);

2391: )
2392: and request_id = pg_request_id;
2393:
2394: IF PG_DEBUG in ('Y', 'C') THEN
2395: fnd_file.put_line(FND_FILE.LOG,'rows deleted from ar_autorec_exceptions: '||sql%rowcount);
2396: END IF;
2397:
2398: /* Note here - the apply process was succesful but auth failed so here we have to unapply the
2399: payment_schedule_id before going in for the delete */

Line 2558: from ar_autorec_exceptions

2554: and xe.entity_id = xte.entity_id
2555: and xte.ledger_id = ARP_STANDARD.sysparm.set_of_books_id
2556: and NVL(xte.source_id_int_1, -99) IN
2557: (select distinct cash_receipt_id
2558: from ar_autorec_exceptions
2559: where request_id = pg_request_id));
2560:
2561: IF PG_DEBUG in ('Y','C') THEN
2562: arp_debug.debug ( 'rows inserted into xla gt table = '|| sql%rowcount);

Line 2603: from ar_autorec_exceptions ex,

2599: delete
2600: from ar_payment_schedules
2601: where cash_receipt_id
2602: in ( select distinct ex.cash_receipt_id
2603: from ar_autorec_exceptions ex,
2604: ar_receipts_gt r
2605: where r.gt_id = p_gt_id
2606: AND r.cash_receipt_id = ex.cash_receipt_id);
2607:

Line 2620: from ar_autorec_exceptions ex,

2616: ( select cash_receipt_history_id
2617: from ar_cash_receipt_history
2618: where cash_receipt_id in
2619: ( select distinct ex.cash_receipt_id
2620: from ar_autorec_exceptions ex,
2621: ar_receipts_gt r
2622: where r.gt_id = p_gt_id
2623: AND r.cash_receipt_id = ex.cash_receipt_id
2624: )

Line 2639: from ar_autorec_exceptions ex,

2635: ( select receivable_application_id
2636: from ar_receivable_applications
2637: where cash_receipt_id in
2638: ( select distinct ex.cash_receipt_id
2639: from ar_autorec_exceptions ex,
2640: ar_receipts_gt r
2641: where r.gt_id = p_gt_id
2642: AND r.cash_receipt_id = ex.cash_receipt_id
2643: )

Line 2654: from ar_autorec_exceptions ex,

2650: delete
2651: from ar_receivable_applications
2652: where cash_receipt_id in
2653: ( select distinct ex.cash_receipt_id
2654: from ar_autorec_exceptions ex,
2655: ar_receipts_gt r
2656: where r.gt_id = p_gt_id
2657: AND r.cash_receipt_id = ex.cash_receipt_id);
2658:

Line 2667: from ar_autorec_exceptions ex,

2663: delete
2664: from ar_cash_receipt_history
2665: where cash_receipt_id in
2666: ( select distinct ex.cash_receipt_id
2667: from ar_autorec_exceptions ex,
2668: ar_receipts_gt r
2669: where r.gt_id = p_gt_id
2670: AND r.cash_receipt_id = ex.cash_receipt_id);
2671:

Line 2679: from ar_autorec_exceptions ex,

2675:
2676: delete from ar_cash_receipts
2677: where cash_receipt_id in
2678: ( select distinct ex.cash_receipt_id
2679: from ar_autorec_exceptions ex,
2680: ar_receipts_gt r
2681: where r.gt_id = p_gt_id
2682: AND r.cash_receipt_id = ex.cash_receipt_id);
2683:

Line 5222: INSERT INTO ar_autorec_exceptions

5218: );
5219:
5220: if sql%rowcount > 0 then
5221: g_auth_fail := 'Y';
5222: INSERT INTO ar_autorec_exceptions
5223: (batch_id,
5224: request_id,
5225: payment_schedule_id,
5226: cash_receipt_id,