APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on WIP_ENTITIES

Line 742: /* Fix for bug 3661250. Added the following SQL to update primary_item_id in WIP_ENTITIES if it has been changed.

738: END IF;
739:
740: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.primary_item_id,p_old_flow_schedule_rec.primary_item_id)
741: THEN
742: /* Fix for bug 3661250. Added the following SQL to update primary_item_id in WIP_ENTITIES if it has been changed.
743: */
744: UPDATE WIP_ENTITIES
745: SET primary_item_id = p_flow_schedule_rec.primary_item_id
746: WHERE wip_entity_id = p_flow_schedule_rec.wip_entity_id

Line 744: UPDATE WIP_ENTITIES

740: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.primary_item_id,p_old_flow_schedule_rec.primary_item_id)
741: THEN
742: /* Fix for bug 3661250. Added the following SQL to update primary_item_id in WIP_ENTITIES if it has been changed.
743: */
744: UPDATE WIP_ENTITIES
745: SET primary_item_id = p_flow_schedule_rec.primary_item_id
746: WHERE wip_entity_id = p_flow_schedule_rec.wip_entity_id
747: AND organization_id = p_flow_schedule_rec.organization_id;
748:

Line 824: UPDATE wip_entities

820: END IF;
821:
822: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.schedule_number,p_old_flow_schedule_rec.schedule_number)
823: THEN
824: UPDATE wip_entities
825: SET wip_entity_name = p_flow_schedule_rec.schedule_number
826: WHERE wip_entity_id = p_flow_schedule_rec.wip_entity_id;
827: END IF;
828:

Line 7511: UPDATE wip_entities

7507: UPDATE wip_flow_schedules
7508: SET schedule_number = l_schedule_number_out
7509: WHERE wip_entity_id = l_wip_entity_id;
7510:
7511: UPDATE wip_entities
7512: SET wip_entity_name = l_schedule_number_out
7513: WHERE wip_entity_id = l_wip_entity_id;
7514: ELSE
7515: RAISE FND_API.G_EXC_ERROR;