4060: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TOL_BELOW_V') THEN
4061: IF NVL(p_record.SHIP_TOLERANCE_BELOW,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4062: RETURN NULL;
4063: END IF;
4064: IF ONT_S_TOL_BELOW_Def_Util.Sync_S_TOL_BELOW_Cache
4065: (p_SHIP_TOLERANCE_BELOW => p_record.SHIP_TOLERANCE_BELOW) = 1 then
4066: RETURN ONT_S_TOL_BELOW_Def_Util.Get_Attr_Val_Varchar2
4067: (p_foreign_attr_code,ONT_S_TOL_BELOW_Def_Util.g_cached_record);
4068: END IF;
4062: RETURN NULL;
4063: END IF;
4064: IF ONT_S_TOL_BELOW_Def_Util.Sync_S_TOL_BELOW_Cache
4065: (p_SHIP_TOLERANCE_BELOW => p_record.SHIP_TOLERANCE_BELOW) = 1 then
4066: RETURN ONT_S_TOL_BELOW_Def_Util.Get_Attr_Val_Varchar2
4067: (p_foreign_attr_code,ONT_S_TOL_BELOW_Def_Util.g_cached_record);
4068: END IF;
4069:
4070: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TO_CONTACT_V') THEN
4063: END IF;
4064: IF ONT_S_TOL_BELOW_Def_Util.Sync_S_TOL_BELOW_Cache
4065: (p_SHIP_TOLERANCE_BELOW => p_record.SHIP_TOLERANCE_BELOW) = 1 then
4066: RETURN ONT_S_TOL_BELOW_Def_Util.Get_Attr_Val_Varchar2
4067: (p_foreign_attr_code,ONT_S_TOL_BELOW_Def_Util.g_cached_record);
4068: END IF;
4069:
4070: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TO_CONTACT_V') THEN
4071: IF NVL(p_record.SHIP_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4632: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TOL_BELOW_V') THEN
4633: IF NVL(p_record.SHIP_TOLERANCE_BELOW,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4634: RETURN NULL;
4635: END IF;
4636: IF ONT_S_TOL_BELOW_Def_Util.Sync_S_TOL_BELOW_Cache
4637: (p_SHIP_TOLERANCE_BELOW => p_record.SHIP_TOLERANCE_BELOW) = 1 then
4638: RETURN ONT_S_TOL_BELOW_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_S_TOL_BELOW_Def_Util.g_cached_record);
4639: END IF;
4640:
4634: RETURN NULL;
4635: END IF;
4636: IF ONT_S_TOL_BELOW_Def_Util.Sync_S_TOL_BELOW_Cache
4637: (p_SHIP_TOLERANCE_BELOW => p_record.SHIP_TOLERANCE_BELOW) = 1 then
4638: RETURN ONT_S_TOL_BELOW_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_S_TOL_BELOW_Def_Util.g_cached_record);
4639: END IF;
4640:
4641: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TO_CONTACT_V') THEN
4642: IF NVL(p_record.SHIP_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN