APPS.EAM_WO_IMPORT_DS_PVT dependencies on EAM_RESOURCE_IMPORT

Line 268: UPDATE EAM_RESOURCE_IMPORT

264: AND resource_seq_num = p_eam_res_usage_tbl(counter_res_usg).resource_seq_num;
265: END LOOP;
266:
267: FOR counter_res IN 1..p_eam_res_tbl.count LOOP
268: UPDATE EAM_RESOURCE_IMPORT
269: SET return_status = p_eam_res_tbl(counter_res).return_status,
270: last_update_date = sysdate,
271: last_updated_by = fnd_global.user_id,
272: last_update_login = fnd_global.login_id

Line 419: FROM EAM_RESOURCE_IMPORT ERI

415: AND emi.wip_entity_id = l_wip_entity_id;
416:
417: CURSOR import_wo_resource_cur (l_p_group_id NUMBER,l_wip_entity_id NUMBER) IS
418: SELECT *
419: FROM EAM_RESOURCE_IMPORT ERI
420: WHERE eri.group_id = l_group_id
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

Line 609: FROM EAM_RESOURCE_IMPORT

605: AND top_wip_entity_id = l_old_top_wip_entity_id
606: );
607:
608: DELETE
609: FROM EAM_RESOURCE_IMPORT
610: WHERE group_id = l_group_id
611: AND wip_entity_id IN (
612: SELECT wip_entity_id
613: FROM EAM_WORK_ORDER_IMPORT

Line 1039: FROM EAM_RESOURCE_IMPORT

1035: WHERE group_id = l_group_id
1036: AND wip_entity_id = l_import_wo_record.wip_entity_id;
1037:
1038: DELETE
1039: FROM EAM_RESOURCE_IMPORT
1040: WHERE group_id = l_group_id
1041: AND wip_entity_id = l_import_wo_record.wip_entity_id;
1042:
1043: DELETE