APPS.ARP_PROCESS_PAYINFO dependencies on RA_INTERFACE_ERRORS

Line 71: SELECT /*+ leading(L) use_nl_with_index(E, RA_INTERFACE_ERRORS_N1) */ 1

67: inv.request_id = fnd_global.conc_request_id
68: AND inv.payment_attributes IS NOT NULL
69: AND inv.paying_customer_id = cus.cust_account_id
70: AND NOT EXISTS (
71: SELECT /*+ leading(L) use_nl_with_index(E, RA_INTERFACE_ERRORS_N1) */ 1
72: FROM ra_customer_trx_lines l, ra_interface_errors e
73: WHERE l.customer_trx_id = inv.customer_trx_id
74: AND l.customer_trx_line_id = e.interface_line_id
75: AND l.request_id = FND_GLOBAL.CONC_REQUEST_ID); -- 7039838

Line 72: FROM ra_customer_trx_lines l, ra_interface_errors e

68: AND inv.payment_attributes IS NOT NULL
69: AND inv.paying_customer_id = cus.cust_account_id
70: AND NOT EXISTS (
71: SELECT /*+ leading(L) use_nl_with_index(E, RA_INTERFACE_ERRORS_N1) */ 1
72: FROM ra_customer_trx_lines l, ra_interface_errors e
73: WHERE l.customer_trx_id = inv.customer_trx_id
74: AND l.customer_trx_line_id = e.interface_line_id
75: AND l.request_id = FND_GLOBAL.CONC_REQUEST_ID); -- 7039838
76:

Line 79: l_msg RA_INTERFACE_ERRORS.MESSAGE_TEXT%TYPE;

75: AND l.request_id = FND_GLOBAL.CONC_REQUEST_ID); -- 7039838
76:
77:
78: l_ext_entity_tab IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
79: l_msg RA_INTERFACE_ERRORS.MESSAGE_TEXT%TYPE;
80: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
81: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
82: l_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
83:

Line 207: INSERT INTO ra_interface_errors

203: IF PG_DEBUG in ('Y', 'C') THEN
204: arp_standard.debug('Inserting into errors...');
205: END IF;
206: --
207: INSERT INTO ra_interface_errors
208: (
209: org_id,
210: interface_line_id,
211: message_text,

Line 392: INSERT INTO RA_INTERFACE_ERRORS

388: --
389: -- Validate payment_trxn_ext_id
390: --
391: -- 7039838 - perf tuning
392: INSERT INTO RA_INTERFACE_ERRORS
393: (INTERFACE_LINE_ID,
394: MESSAGE_TEXT,
395: INVALID_VALUE,
396: ORG_ID)