DBA Data[Home] [Help]

APPS.AR_AUTOREC_API dependencies on RA_CUSTOMER_TRX_ALL

Line 2330: UPDATE /*+ index(ct ra_customer_trx_u1) */ ra_customer_trx_all ct

2326:
2327:
2328: IF p_pay_process_fail = 'Y' THEN
2329:
2330: UPDATE /*+ index(ct ra_customer_trx_u1) */ ra_customer_trx_all ct
2331: SET cc_error_flag = null,
2332: cc_error_code = null,
2333: cc_error_text = null
2334: WHERE customer_trx_id in

Line 5181: UPDATE /*+ index(ct ra_customer_trx_u1) */ ra_customer_trx_all ct

5177: fnd_file.put_line(FND_FILE.LOG,'control_check()+');
5178: fnd_file.put_line(FND_FILE.LOG,'Detect receipts with Auth failure');
5179: END IF;
5180:
5181: UPDATE /*+ index(ct ra_customer_trx_u1) */ ra_customer_trx_all ct
5182: SET cc_error_flag = 'Y',
5183: last_updated_by = pg_last_updated_by,
5184: last_update_date = sysdate,
5185: last_update_login = pg_last_update_login,