APPS.EAM_WO_IMPORT_DS_PVT dependencies on EAM_OPERATION_IMPORT

Line 290: UPDATE EAM_OPERATION_IMPORT

286: AND inventory_item_id = p_eam_mat_req_tbl(counter_mat).inventory_item_id;
287: END LOOP;
288:
289: FOR counter_op IN 1..p_eam_op_tbl.count LOOP
290: UPDATE EAM_OPERATION_IMPORT
291: SET return_status = p_eam_op_tbl(counter_op).return_status,
292: last_update_date = sysdate,
293: last_updated_by = fnd_global.user_id,
294: last_update_login = fnd_global.login_id

Line 407: FROM EAM_OPERATION_IMPORT EOI

403: l_msg_data VARCHAR2(4000);
404:
405: CURSOR import_wo_oper_cur (l_group_id NUMBER,l_wip_entity_id NUMBER) IS
406: SELECT *
407: FROM EAM_OPERATION_IMPORT EOI
408: WHERE eoi.group_id = l_group_id
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

Line 629: FROM EAM_OPERATION_IMPORT

625: AND top_wip_entity_id = l_old_top_wip_entity_id
626: );
627:
628: DELETE
629: FROM EAM_OPERATION_IMPORT
630: WHERE group_id = l_group_id
631: AND wip_entity_id IN (
632: SELECT wip_entity_id
633: FROM EAM_WORK_ORDER_IMPORT

Line 1049: FROM EAM_OPERATION_IMPORT

1045: WHERE group_id = l_group_id
1046: AND wip_entity_id = l_import_wo_record.wip_entity_id;
1047:
1048: DELETE
1049: FROM EAM_OPERATION_IMPORT
1050: WHERE group_id = l_group_id
1051: AND wip_entity_id = l_import_wo_record.wip_entity_id;
1052:
1053: DELETE