APPS.EAM_WO_IMPORT_DS_PVT dependencies on EAM_RESOURCE_USAGE_IMPORT

Line 257: UPDATE EAM_RESOURCE_USAGE_IMPORT

253: AND (serial_number = p_eam_res_inst_tbl(counter_res_ins).serial_number OR serial_number IS NULL);
254: END LOOP;
255:
256: FOR counter_res_usg IN 1..p_eam_res_usage_tbl.count LOOP
257: UPDATE EAM_RESOURCE_USAGE_IMPORT
258: SET return_status = p_eam_res_usage_tbl(counter_res_usg).return_status,
259: last_update_date = sysdate,
260: last_updated_by = fnd_global.user_id,
261: last_update_login = fnd_global.login_id

Line 425: FROM EAM_RESOURCE_USAGE_IMPORT ERUI

421: AND eri.wip_entity_id = l_wip_entity_id;
422:
423: CURSOR import_wo_resource_usage_cur (l_group_id NUMBER,l_wip_entity_id NUMBER) IS
424: SELECT *
425: FROM EAM_RESOURCE_USAGE_IMPORT ERUI
426: WHERE erui.group_id = l_group_id
427: AND erui.wip_entity_id = l_wip_entity_id;
428:
429: CURSOR import_wo_res_instance_cur (l_group_id NUMBER,l_wip_entity_id NUMBER) IS

Line 599: FROM EAM_RESOURCE_USAGE_IMPORT

595: AND top_wip_entity_id = l_old_top_wip_entity_id
596: );
597:
598: DELETE
599: FROM EAM_RESOURCE_USAGE_IMPORT
600: WHERE group_id = l_group_id
601: AND wip_entity_id IN (
602: SELECT wip_entity_id
603: FROM EAM_WORK_ORDER_IMPORT

Line 1034: FROM EAM_RESOURCE_USAGE_IMPORT

1030: WHERE group_id = l_group_id
1031: AND wip_entity_id = l_import_wo_record.wip_entity_id;
1032:
1033: DELETE
1034: FROM EAM_RESOURCE_USAGE_IMPORT
1035: WHERE group_id = l_group_id
1036: AND wip_entity_id = l_import_wo_record.wip_entity_id;
1037:
1038: DELETE