591: THEN
592: SELECT ORGANIZATION_CODE INTO l_org_code
593: FROM MTL_PARAMETERS
594: WHERE ORGANIZATION_ID = p_organization_id;
595: EGO_WF_WRAPPER_PVT.Raise_Item_Create_Update_Event(
596: p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_UPDATE_EVENT
597: ,p_Organization_Id => p_Organization_Id
598: ,p_organization_code => l_org_code
599: ,p_Inventory_Item_Id => p_inventory_item_id
592: SELECT ORGANIZATION_CODE INTO l_org_code
593: FROM MTL_PARAMETERS
594: WHERE ORGANIZATION_ID = p_organization_id;
595: EGO_WF_WRAPPER_PVT.Raise_Item_Create_Update_Event(
596: p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_UPDATE_EVENT
597: ,p_Organization_Id => p_Organization_Id
598: ,p_organization_code => l_org_code
599: ,p_Inventory_Item_Id => p_inventory_item_id
600: ,p_item_number => l_item_number
878: FROM mtl_system_items_kfv
879: WHERE inventory_item_id = p_inventory_item_id
880: AND organization_id = p_organization_id;
881:
882: EGO_WF_WRAPPER_PVT.Raise_Item_Create_Update_Event(
883: p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_UPDATE_EVENT
884: ,p_Inventory_Item_Id => p_inventory_item_id
885: ,p_Organization_Id => p_Organization_Id
886: ,p_organization_code => l_org_code
879: WHERE inventory_item_id = p_inventory_item_id
880: AND organization_id = p_organization_id;
881:
882: EGO_WF_WRAPPER_PVT.Raise_Item_Create_Update_Event(
883: p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_UPDATE_EVENT
884: ,p_Inventory_Item_Id => p_inventory_item_id
885: ,p_Organization_Id => p_Organization_Id
886: ,p_organization_code => l_org_code
887: ,p_item_number => l_item_number