APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on RA_INTERFACE_ERRORS

Line 197: FROM ra_interface_errors_all ie

193: AND ct.term_id = tl.term_id
194: AND NVL(ctl.deferral_exclusion_flag, 'N') = 'N'
195: AND NOT EXISTS
196: (SELECT 'errors'
197: FROM ra_interface_errors_all ie
198: WHERE ie.interface_line_id = ctl.customer_trx_line_id)
199: AND NOT EXISTS
200: (SELECT 'prevent duplicate contingency'
201: FROM ar_line_conts_all alc

Line 431: FROM ra_interface_errors_all ie

427: AND ar_revenue_management_pvt.creditworthy
428: (ct.bill_to_customer_id, ct.bill_to_site_use_id)= 0
429: AND NOT EXISTS
430: (SELECT 'errors'
431: FROM ra_interface_errors_all ie
432: WHERE ie.interface_line_id = ctl.customer_trx_line_id)
433: AND NOT EXISTS
434: (SELECT 'prevent duplicate contingency'
435: FROM ar_line_conts_all alc

Line 1365: FROM ra_interface_errors ie

1361: DELETE
1362: FROM ar_line_conts
1363: WHERE customer_trx_line_id IN
1364: (SELECT ie.interface_line_id
1365: FROM ra_interface_errors ie
1366: WHERE request_id = p_request_id);
1367:
1368: END IF;
1369:

Line 2096: FROM ra_interface_errors ie

2092: AND ctl.customer_trx_line_id = ic.interface_line_id
2093: AND ic.contingency_id = dr.contingency_id
2094: AND NOT EXISTS
2095: (SELECT 'errors'
2096: FROM ra_interface_errors ie
2097: WHERE ie.interface_line_id = ctl.customer_trx_line_id);
2098:
2099: debug('itf contingencies inserted: ' || SQL%ROWCOUNT);
2100: debug('insert_contingencies_from_itf()-');

Line 2650: INSERT INTO ra_interface_errors

2646:
2647: -- we will not validate against start and end date until we expose
2648: -- the table.
2649:
2650: INSERT INTO ra_interface_errors
2651: (
2652: interface_line_id,
2653: interface_contingency_id,
2654: message_text,

Line 2690: INSERT INTO ra_interface_errors

2686: contingencies. Complete ones should bypass this as
2687: we use the expiration_date to populate the
2688: event removal date */
2689:
2690: INSERT INTO ra_interface_errors
2691: (
2692: interface_line_id,
2693: interface_contingency_id,
2694: message_text,

Line 4933: FROM ra_interface_errors ie,

4929: FROM ar_deferred_lines
4930: WHERE customer_trx_id IN
4931: (
4932: SELECT DISTINCT il.customer_trx_id
4933: FROM ra_interface_errors ie,
4934: ra_interface_lines il
4935: WHERE ie.interface_line_id = il.interface_line_id
4936: AND il.request_id = p_request_id
4937: )

Line 4949: FROM ra_interface_errors ie,

4945: FROM ar_deferred_lines
4946: WHERE customer_trx_id IN
4947: (
4948: SELECT DISTINCT il.customer_trx_id
4949: FROM ra_interface_errors ie,
4950: ra_interface_lines il
4951: WHERE ie.interface_line_id = il.interface_line_id
4952: AND il.request_id = p_request_id
4953: );