APPS.EAM_WO_IMPORT_DS_PVT dependencies on EAM_RESOURCE_INSTANCE_IMPORT

Line 245: UPDATE EAM_RESOURCE_INSTANCE_IMPORT

241: -- Following code loops through the out tables from work order API and updates the status
242: -- of corresponding import tables.It also updates the who columns
243:
244: FOR counter_res_ins IN 1..p_eam_res_inst_tbl.count LOOP
245: UPDATE EAM_RESOURCE_INSTANCE_IMPORT
246: SET return_status = p_eam_res_inst_tbl(counter_res_ins).return_status,
247: last_update_date = sysdate,
248: last_updated_by = fnd_global.user_id,
249: last_update_login = fnd_global.login_id

Line 431: FROM EAM_RESOURCE_INSTANCE_IMPORT ERIM

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
430: SELECT *
431: FROM EAM_RESOURCE_INSTANCE_IMPORT ERIM
432: WHERE erim.group_id = l_group_id
433: AND erim.wip_entity_id = l_wip_entity_id;
434:
435: BEGIN

Line 589: FROM EAM_RESOURCE_INSTANCE_IMPORT

585: fnd_file.put_line(FND_FILE.LOG,'Status Sucess for work order --' || log_counter.wip_entity_id);
586: END LOOP;
587:
588: DELETE
589: FROM EAM_RESOURCE_INSTANCE_IMPORT
590: WHERE group_id = l_group_id
591: AND wip_entity_id IN (
592: SELECT wip_entity_id
593: FROM EAM_WORK_ORDER_IMPORT

Line 1029: FROM EAM_RESOURCE_INSTANCE_IMPORT

1025:
1026: fnd_file.put_line(FND_FILE.LOG,'Status Sucess for work order --' || l_import_wo_record.wip_entity_id);
1027:
1028: DELETE
1029: FROM EAM_RESOURCE_INSTANCE_IMPORT
1030: WHERE group_id = l_group_id
1031: AND wip_entity_id = l_import_wo_record.wip_entity_id;
1032:
1033: DELETE