DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on EGO_AML_INTF

Line 2390: FROM EGO_AML_INTF

2386:
2387:
2388: BEGIN
2389: SELECT 'S' INTO l_return_status
2390: FROM EGO_AML_INTF
2391: WHERE DATA_SET_ID = p_batch_id
2392: AND PROCESS_FLAG = G_CM_TO_BE_PROCESSED
2393: AND ROWNUM = 1;
2394: EXCEPTION

Line 2405: UPDATE ego_aml_intf intf

2401: END;
2402:
2403:
2404: -- Pre-Processing for Pending Change Data Poplulation
2405: UPDATE ego_aml_intf intf
2406: SET intf.process_flag = G_CM_DATA_POPULATION
2407: WHERE intf.data_set_id = p_batch_id
2408: AND intf.process_flag = G_CM_TO_BE_PROCESSED
2409: AND EXISTS ( SELECT 'x'

Line 2458: UPDATE ego_aml_intf intf

2454:
2455: Write_Debug('Populate intf table with prod data for UPDATE done ' );
2456:
2457:
2458: UPDATE ego_aml_intf intf
2459: SET (intf.mrp_planning_code
2460: ,intf.description
2461: ,intf.first_article_status
2462: ,intf.approval_status