3950: ELSIF (p_foreign_database_object_name = 'OE_PRICE_LISTS_V') THEN
3951: IF NVL(p_record.PRICE_LIST_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
3952: RETURN NULL;
3953: END IF;
3954: IF ONT_PRICE_LIST_Def_Util.Sync_PRICE_LIST_Cache
3955: (p_PRICE_LIST_ID => p_record.PRICE_LIST_ID) = 1 then
3956: RETURN ONT_PRICE_LIST_Def_Util.Get_Attr_Val_Varchar2
3957: (p_foreign_attr_code,ONT_PRICE_LIST_Def_Util.g_cached_record);
3958: END IF;
3952: RETURN NULL;
3953: END IF;
3954: IF ONT_PRICE_LIST_Def_Util.Sync_PRICE_LIST_Cache
3955: (p_PRICE_LIST_ID => p_record.PRICE_LIST_ID) = 1 then
3956: RETURN ONT_PRICE_LIST_Def_Util.Get_Attr_Val_Varchar2
3957: (p_foreign_attr_code,ONT_PRICE_LIST_Def_Util.g_cached_record);
3958: END IF;
3959:
3960: ELSIF (p_foreign_database_object_name = 'OE_AK_PRIMARY_UOM_V') THEN
3953: END IF;
3954: IF ONT_PRICE_LIST_Def_Util.Sync_PRICE_LIST_Cache
3955: (p_PRICE_LIST_ID => p_record.PRICE_LIST_ID) = 1 then
3956: RETURN ONT_PRICE_LIST_Def_Util.Get_Attr_Val_Varchar2
3957: (p_foreign_attr_code,ONT_PRICE_LIST_Def_Util.g_cached_record);
3958: END IF;
3959:
3960: ELSIF (p_foreign_database_object_name = 'OE_AK_PRIMARY_UOM_V') THEN
3961: IF NVL(p_record.ORDER_QUANTITY_UOM,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4533: ELSIF (p_foreign_database_object_name = 'OE_PRICE_LISTS_V') THEN
4534: IF NVL(p_record.PRICE_LIST_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4535: RETURN NULL;
4536: END IF;
4537: IF ONT_PRICE_LIST_Def_Util.Sync_PRICE_LIST_Cache
4538: (p_PRICE_LIST_ID => p_record.PRICE_LIST_ID) = 1 then
4539: RETURN ONT_PRICE_LIST_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_PRICE_LIST_Def_Util.g_cached_record);
4540: END IF;
4541:
4535: RETURN NULL;
4536: END IF;
4537: IF ONT_PRICE_LIST_Def_Util.Sync_PRICE_LIST_Cache
4538: (p_PRICE_LIST_ID => p_record.PRICE_LIST_ID) = 1 then
4539: RETURN ONT_PRICE_LIST_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_PRICE_LIST_Def_Util.g_cached_record);
4540: END IF;
4541:
4542: ELSIF (p_foreign_database_object_name = 'OE_AK_PRIMARY_UOM_V') THEN
4543: IF NVL(p_record.ORDER_QUANTITY_UOM,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN