2163: ELSIF (p_foreign_database_object_name = 'OE_AGREEMENTS_V') THEN
2164: IF NVL(p_record.AGREEMENT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2165: RETURN NULL;
2166: END IF;
2167: IF ONT_AGREEMENT_Def_Util.Sync_AGREEMENT_Cache
2168: (p_AGREEMENT_ID => p_record.AGREEMENT_ID) = 1 then
2169: RETURN ONT_AGREEMENT_Def_Util.Get_Attr_Val_Varchar2
2170: (p_foreign_attr_code,ONT_AGREEMENT_Def_Util.g_cached_record);
2171: END IF;
2165: RETURN NULL;
2166: END IF;
2167: IF ONT_AGREEMENT_Def_Util.Sync_AGREEMENT_Cache
2168: (p_AGREEMENT_ID => p_record.AGREEMENT_ID) = 1 then
2169: RETURN ONT_AGREEMENT_Def_Util.Get_Attr_Val_Varchar2
2170: (p_foreign_attr_code,ONT_AGREEMENT_Def_Util.g_cached_record);
2171: END IF;
2172:
2173: ELSIF (p_foreign_database_object_name = 'OE_AK_DEL_TO_CONTACT_V') THEN
2166: END IF;
2167: IF ONT_AGREEMENT_Def_Util.Sync_AGREEMENT_Cache
2168: (p_AGREEMENT_ID => p_record.AGREEMENT_ID) = 1 then
2169: RETURN ONT_AGREEMENT_Def_Util.Get_Attr_Val_Varchar2
2170: (p_foreign_attr_code,ONT_AGREEMENT_Def_Util.g_cached_record);
2171: END IF;
2172:
2173: ELSIF (p_foreign_database_object_name = 'OE_AK_DEL_TO_CONTACT_V') THEN
2174: IF NVL(p_record.DELIVER_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2720: ELSIF (p_foreign_database_object_name = 'OE_AGREEMENTS_V') THEN
2721: IF NVL(p_record.AGREEMENT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2722: RETURN NULL;
2723: END IF;
2724: IF ONT_AGREEMENT_Def_Util.Sync_AGREEMENT_Cache
2725: (p_AGREEMENT_ID => p_record.AGREEMENT_ID) = 1 then
2726: RETURN ONT_AGREEMENT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_AGREEMENT_Def_Util.g_cached_record);
2727: END IF;
2728:
2722: RETURN NULL;
2723: END IF;
2724: IF ONT_AGREEMENT_Def_Util.Sync_AGREEMENT_Cache
2725: (p_AGREEMENT_ID => p_record.AGREEMENT_ID) = 1 then
2726: RETURN ONT_AGREEMENT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_AGREEMENT_Def_Util.g_cached_record);
2727: END IF;
2728:
2729: ELSIF (p_foreign_database_object_name = 'OE_AK_DEL_TO_CONTACT_V') THEN
2730: IF NVL(p_record.DELIVER_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN