DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on FLM_EXE_OPERATIONS

Line 3702: delete from flm_exe_operations

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

Line 7059: UPDATE flm_exe_operations

7055: AND organization_id=p_organization_id;
7056:
7057: --Update the detail record in execution to point to new schedule number.
7058: FORALL i IN 1..l_loop_count
7059: UPDATE flm_exe_operations
7060: SET wip_entity_id=newFSWipId(i)
7061: WHERE wip_entity_id=oldFSWipId(i)
7062: AND organization_id=p_organization_id;
7063: FORALL i IN 1..l_loop_count