740: END IF;
741:
742: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.primary_item_id,p_old_flow_schedule_rec.primary_item_id)
743: THEN
744: /* Fix for bug 3661250. Added the following SQL to update primary_item_id in WIP_ENTITIES if it has been changed.
745: */
746: UPDATE WIP_ENTITIES
747: SET primary_item_id = p_flow_schedule_rec.primary_item_id
748: WHERE wip_entity_id = p_flow_schedule_rec.wip_entity_id
742: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.primary_item_id,p_old_flow_schedule_rec.primary_item_id)
743: THEN
744: /* Fix for bug 3661250. Added the following SQL to update primary_item_id in WIP_ENTITIES if it has been changed.
745: */
746: UPDATE WIP_ENTITIES
747: SET primary_item_id = p_flow_schedule_rec.primary_item_id
748: WHERE wip_entity_id = p_flow_schedule_rec.wip_entity_id
749: AND organization_id = p_flow_schedule_rec.organization_id;
750:
822: END IF;
823:
824: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.schedule_number,p_old_flow_schedule_rec.schedule_number)
825: THEN
826: UPDATE wip_entities
827: SET wip_entity_name = p_flow_schedule_rec.schedule_number
828: WHERE wip_entity_id = p_flow_schedule_rec.wip_entity_id;
829: END IF;
830:
7059:
7060:
7061: -- Added for bug 8899708.
7062: FORALL i IN 1..l_loop_count
7063: UPDATE wip_entities
7064: SET wip_entity_name =('?*?'||oldFSSchNum(i))
7065: WHERE wip_entity_id=oldFSWipId(i)
7066: AND organization_id=p_organization_id;
7067:
7065: WHERE wip_entity_id=oldFSWipId(i)
7066: AND organization_id=p_organization_id;
7067:
7068: FORALL i IN 1..l_loop_count
7069: UPDATE wip_entities
7070: SET wip_entity_name =oldFSSchNum(i)
7071: WHERE wip_entity_id=newFSWipId(i)
7072: AND organization_id=p_organization_id;
7073:
7071: WHERE wip_entity_id=newFSWipId(i)
7072: AND organization_id=p_organization_id;
7073:
7074: FORALL i IN 1..l_loop_count
7075: UPDATE wip_entities
7076: SET wip_entity_name =newFSSchNum(i)
7077: WHERE wip_entity_id=oldFSWipId(i)
7078: AND organization_id=p_organization_id;
7079:
7532: UPDATE wip_flow_schedules
7533: SET schedule_number = l_schedule_number_out
7534: WHERE wip_entity_id = l_wip_entity_id;
7535:
7536: UPDATE wip_entities
7537: SET wip_entity_name = l_schedule_number_out
7538: WHERE wip_entity_id = l_wip_entity_id;
7539: ELSE
7540: RAISE FND_API.G_EXC_ERROR;