DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on FLM_EXE_OPERATIONS

Line 3705: delete from flm_exe_operations

3701: l_msg_count, l_msg_data);
3702: END IF;
3703:
3704: -- Added for Flow Execution Workstation. Deleting from execution table
3705: delete from flm_exe_operations
3706: where organization_id = p_organization_id and wip_entity_id = l_wip_entity_id;
3707: delete from flm_exe_req_operations
3708: where organization_id = p_organization_id and wip_entity_id = l_wip_entity_id;
3709: delete from flm_exe_lot_numbers

Line 7084: UPDATE flm_exe_operations

7080:
7081:
7082: --Update the detail record in execution to point to new schedule number.
7083: FORALL i IN 1..l_loop_count
7084: UPDATE flm_exe_operations
7085: SET wip_entity_id=newFSWipId(i)
7086: WHERE wip_entity_id=oldFSWipId(i)
7087: AND organization_id=p_organization_id;
7088: FORALL i IN 1..l_loop_count