4263: OR ( NVL(p_record.INVENTORY_ITEM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )
4264: THEN
4265: RETURN NULL;
4266: END IF;
4267: IF ONT_TOL_CUST_ITEM_Def_Util.Sync_TOL_CUST_ITEM_Cache(p_CUSTOMER_ID => p_record.SOLD_TO_ORG_ID,
4268: p_INTERNAL_ITEM_ID => p_record.INVENTORY_ITEM_ID) =1 then
4269: RETURN ONT_TOL_CUST_ITEM_Def_Util.Get_Attr_Val_Varchar2(p_foreign_attr_code,ONT_TOL_CUST_ITEM_Def_Util.g_cached_record);
4270: END IF;
4271:
4265: RETURN NULL;
4266: END IF;
4267: IF ONT_TOL_CUST_ITEM_Def_Util.Sync_TOL_CUST_ITEM_Cache(p_CUSTOMER_ID => p_record.SOLD_TO_ORG_ID,
4268: p_INTERNAL_ITEM_ID => p_record.INVENTORY_ITEM_ID) =1 then
4269: RETURN ONT_TOL_CUST_ITEM_Def_Util.Get_Attr_Val_Varchar2(p_foreign_attr_code,ONT_TOL_CUST_ITEM_Def_Util.g_cached_record);
4270: END IF;
4271:
4272: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIPPING_METHOD_V') THEN
4273: IF NVL(p_record.SHIPPING_METHOD_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4822: OR ( NVL(p_record.INVENTORY_ITEM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )
4823: THEN
4824: RETURN NULL;
4825: END IF;
4826: IF ONT_TOL_CUST_ITEM_Def_Util.Sync_TOL_CUST_ITEM_Cache(p_CUSTOMER_ID => p_record.SOLD_TO_ORG_ID,
4827: p_INTERNAL_ITEM_ID => p_record.INVENTORY_ITEM_ID) =1 then
4828: RETURN ONT_TOL_CUST_ITEM_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_TOL_CUST_ITEM_Def_Util.g_cached_record);
4829: END IF;
4830:
4824: RETURN NULL;
4825: END IF;
4826: IF ONT_TOL_CUST_ITEM_Def_Util.Sync_TOL_CUST_ITEM_Cache(p_CUSTOMER_ID => p_record.SOLD_TO_ORG_ID,
4827: p_INTERNAL_ITEM_ID => p_record.INVENTORY_ITEM_ID) =1 then
4828: RETURN ONT_TOL_CUST_ITEM_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_TOL_CUST_ITEM_Def_Util.g_cached_record);
4829: END IF;
4830:
4831: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIPPING_METHOD_V') THEN
4832: IF NVL(p_record.SHIPPING_METHOD_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN