APPS.EAM_WO_IMPORT_DS_PVT dependencies on EAM_MATERIAL_IMPORT

Line 279: UPDATE EAM_MATERIAL_IMPORT

275: AND resource_seq_num = p_eam_res_tbl(counter_res).resource_seq_num;
276: END LOOP;
277:
278: FOR counter_mat IN 1..p_eam_mat_req_tbl.count LOOP
279: UPDATE EAM_MATERIAL_IMPORT
280: SET return_status = p_eam_mat_req_tbl(counter_mat).return_status,
281: last_update_date = sysdate,
282: last_updated_by = fnd_global.user_id,
283: last_update_login = fnd_global.login_id

Line 413: FROM EAM_MATERIAL_IMPORT EMI

409: AND eoi.wip_entity_id = l_wip_entity_id;
410:
411: CURSOR import_wo_material_cur (l_group_id NUMBER,l_wip_entity_id NUMBER) IS
412: SELECT *
413: FROM EAM_MATERIAL_IMPORT EMI
414: WHERE emi.group_id = l_group_id
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

Line 619: FROM EAM_MATERIAL_IMPORT

615: AND top_wip_entity_id = l_old_top_wip_entity_id
616: );
617:
618: DELETE
619: FROM EAM_MATERIAL_IMPORT
620: WHERE group_id = l_group_id
621: AND wip_entity_id IN (
622: SELECT wip_entity_id
623: FROM EAM_WORK_ORDER_IMPORT

Line 1044: FROM EAM_MATERIAL_IMPORT

1040: WHERE group_id = l_group_id
1041: AND wip_entity_id = l_import_wo_record.wip_entity_id;
1042:
1043: DELETE
1044: FROM EAM_MATERIAL_IMPORT
1045: WHERE group_id = l_group_id
1046: AND wip_entity_id = l_import_wo_record.wip_entity_id;
1047:
1048: DELETE