4302: ELSIF (p_foreign_database_object_name = 'OE_AK_DEMAND_CLASS_V') THEN
4303: IF NVL(p_record.DEMAND_CLASS_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4304: RETURN NULL;
4305: END IF;
4306: IF ONT_DEM_CLASS_Def_Util.Sync_DEM_CLASS_Cache
4307: (p_DEMAND_CLASS_CODE => p_record.DEMAND_CLASS_CODE) = 1 then
4308: RETURN ONT_DEM_CLASS_Def_Util.Get_Attr_Val_Varchar2
4309: (p_foreign_attr_code,ONT_DEM_CLASS_Def_Util.g_cached_record);
4310: END IF;
4304: RETURN NULL;
4305: END IF;
4306: IF ONT_DEM_CLASS_Def_Util.Sync_DEM_CLASS_Cache
4307: (p_DEMAND_CLASS_CODE => p_record.DEMAND_CLASS_CODE) = 1 then
4308: RETURN ONT_DEM_CLASS_Def_Util.Get_Attr_Val_Varchar2
4309: (p_foreign_attr_code,ONT_DEM_CLASS_Def_Util.g_cached_record);
4310: END IF;
4311:
4312: ELSIF (p_foreign_database_object_name = 'OE_AK_FOB_POINT_V') THEN
4305: END IF;
4306: IF ONT_DEM_CLASS_Def_Util.Sync_DEM_CLASS_Cache
4307: (p_DEMAND_CLASS_CODE => p_record.DEMAND_CLASS_CODE) = 1 then
4308: RETURN ONT_DEM_CLASS_Def_Util.Get_Attr_Val_Varchar2
4309: (p_foreign_attr_code,ONT_DEM_CLASS_Def_Util.g_cached_record);
4310: END IF;
4311:
4312: ELSIF (p_foreign_database_object_name = 'OE_AK_FOB_POINT_V') THEN
4313: IF NVL(p_record.FOB_POINT_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4858: ELSIF (p_foreign_database_object_name = 'OE_AK_DEMAND_CLASS_V') THEN
4859: IF NVL(p_record.DEMAND_CLASS_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4860: RETURN NULL;
4861: END IF;
4862: IF ONT_DEM_CLASS_Def_Util.Sync_DEM_CLASS_Cache
4863: (p_DEMAND_CLASS_CODE => p_record.DEMAND_CLASS_CODE) = 1 then
4864: RETURN ONT_DEM_CLASS_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_DEM_CLASS_Def_Util.g_cached_record);
4865: END IF;
4866:
4860: RETURN NULL;
4861: END IF;
4862: IF ONT_DEM_CLASS_Def_Util.Sync_DEM_CLASS_Cache
4863: (p_DEMAND_CLASS_CODE => p_record.DEMAND_CLASS_CODE) = 1 then
4864: RETURN ONT_DEM_CLASS_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_DEM_CLASS_Def_Util.g_cached_record);
4865: END IF;
4866:
4867: ELSIF (p_foreign_database_object_name = 'OE_AK_FOB_POINT_V') THEN
4868: IF NVL(p_record.FOB_POINT_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN