APPS.AR_AUTOREC_API dependencies on AR_AUTOREC_EXCEPTIONS

Line 4212: INTO ar_autorec_exceptions

4208: END IF;
4209:
4210:
4211: INSERT
4212: INTO ar_autorec_exceptions
4213: (batch_id,
4214: request_id,
4215: cash_receipt_id,
4216: payment_schedule_id,

Line 4407: INSERT INTO ar_autorec_exceptions

4403: );
4404:
4405: if sql%rowcount > 0 then
4406: g_auth_fail := 'Y';
4407: INSERT INTO ar_autorec_exceptions
4408: (batch_id,
4409: request_id,
4410: cash_receipt_id,
4411: paying_customer_id,

Line 4516: delete from ar_autorec_exceptions

4512: ) AND cc_error_flag = 'Y';
4513:
4514: fnd_file.put_line(FND_FILE.LOG,'receipt rows updated to reset cc_error_flag : '||sql%rowcount);
4515:
4516: delete from ar_autorec_exceptions
4517: where cash_receipt_id in (
4518: SELECT
4519: cr.cash_receipt_id
4520: FROM ar_cash_receipts cr,

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

4533: AND summ.reqtype in ('ORAPMTREQ','ORAPMTBATCHREQ')
4534: AND summ.status IN(0, 11, 100))
4535: ) and request_id = l_request_id;
4536:
4537: fnd_file.put_line(FND_FILE.LOG,'rows deleted from ar_autorec_exceptions: '||sql%rowcount);
4538:
4539:
4540: /* start unapply */
4541:

Line 4724: from ar_autorec_exceptions

4720: and xe.entity_id = xte.entity_id
4721: and xte.ledger_id = ARP_STANDARD.sysparm.set_of_books_id
4722: and NVL(xte.source_id_int_1, -99) IN
4723: (select distinct cash_receipt_id
4724: from ar_autorec_exceptions
4725: where request_id = l_request_id));
4726:
4727: IF PG_DEBUG in ('Y','C') THEN
4728: arp_standard.debug ( 'rows inserted into xla gt table = '|| sql%rowcount);

Line 4765: from ar_autorec_exceptions

4761: END IF;
4762:
4763: delete from ar_payment_schedules
4764: where cash_receipt_id in (select distinct cash_receipt_id
4765: from ar_autorec_exceptions
4766: where request_id = l_request_id);
4767:
4768: IF PG_DEBUG in ('Y','C') THEN
4769: arp_standard.debug ( ' rows DELETED PS = ' || SQL%ROWCOUNT );

Line 4777: from ar_autorec_exceptions

4773: where source_table = 'CRH'
4774: and source_id in ( select cash_receipt_history_id
4775: from ar_cash_receipt_history
4776: where cash_receipt_id in ( select distinct cash_receipt_id
4777: from ar_autorec_exceptions
4778: where request_id = l_request_id));
4779:
4780: IF PG_DEBUG in ('Y','C') THEN
4781: arp_standard.debug ( ' rows DELETED AR_DIST = ' || SQL%ROWCOUNT );

Line 4789: from ar_autorec_exceptions

4785: where source_table = 'RA'
4786: and source_id in ( select receivable_application_id
4787: from ar_receivable_applications
4788: where cash_receipt_id in ( select distinct cash_receipt_id
4789: from ar_autorec_exceptions
4790: where request_id = l_request_id));
4791:
4792: IF PG_DEBUG in ('Y','C') THEN
4793: arp_standard.debug ( ' rows DELETED AR_DIST2 = ' || SQL%ROWCOUNT );

Line 4798: from ar_autorec_exceptions

4794: END IF;
4795:
4796: delete from ar_receivable_applications
4797: where cash_receipt_id in ( select distinct cash_receipt_id
4798: from ar_autorec_exceptions
4799: where request_id = l_request_id);
4800:
4801: IF PG_DEBUG in ('Y','C') THEN
4802: arp_standard.debug ( ' rows DELETED REC_APPS = ' || SQL%ROWCOUNT );

Line 4806: from ar_autorec_exceptions

4802: arp_standard.debug ( ' rows DELETED REC_APPS = ' || SQL%ROWCOUNT );
4803: END IF;
4804: delete from ar_cash_receipt_history
4805: where cash_receipt_id in ( select distinct cash_receipt_id
4806: from ar_autorec_exceptions
4807: where request_id = l_request_id);
4808:
4809: IF PG_DEBUG in ('Y','C') THEN
4810: arp_standard.debug ( ' rows DELETED CRH = ' || SQL%ROWCOUNT );

Line 4815: from ar_autorec_exceptions

4811: END IF;
4812:
4813: delete from ar_cash_receipts
4814: where cash_receipt_id in ( select distinct cash_receipt_id
4815: from ar_autorec_exceptions
4816: where request_id = l_request_id);
4817:
4818: IF PG_DEBUG in ('Y','C') THEN
4819: arp_standard.debug ( ' rows DELETED CR = ' || SQL%ROWCOUNT );