3819: ELSIF (p_foreign_database_object_name = 'OE_AGREEMENTS_V') THEN
3820: IF NVL(p_record.AGREEMENT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
3821: RETURN NULL;
3822: END IF;
3823: IF ONT_AGREEMENT_Def_Util.Sync_AGREEMENT_Cache
3824: (p_AGREEMENT_ID => p_record.AGREEMENT_ID) = 1 then
3825: RETURN ONT_AGREEMENT_Def_Util.Get_Attr_Val_Varchar2
3826: (p_foreign_attr_code,ONT_AGREEMENT_Def_Util.g_cached_record);
3827: END IF;
3821: RETURN NULL;
3822: END IF;
3823: IF ONT_AGREEMENT_Def_Util.Sync_AGREEMENT_Cache
3824: (p_AGREEMENT_ID => p_record.AGREEMENT_ID) = 1 then
3825: RETURN ONT_AGREEMENT_Def_Util.Get_Attr_Val_Varchar2
3826: (p_foreign_attr_code,ONT_AGREEMENT_Def_Util.g_cached_record);
3827: END IF;
3828:
3829: ELSIF (p_foreign_database_object_name = 'OE_AK_DEL_TO_CONTACT_V') THEN
3822: END IF;
3823: IF ONT_AGREEMENT_Def_Util.Sync_AGREEMENT_Cache
3824: (p_AGREEMENT_ID => p_record.AGREEMENT_ID) = 1 then
3825: RETURN ONT_AGREEMENT_Def_Util.Get_Attr_Val_Varchar2
3826: (p_foreign_attr_code,ONT_AGREEMENT_Def_Util.g_cached_record);
3827: END IF;
3828:
3829: ELSIF (p_foreign_database_object_name = 'OE_AK_DEL_TO_CONTACT_V') THEN
3830: IF NVL(p_record.DELIVER_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4414: ELSIF (p_foreign_database_object_name = 'OE_AGREEMENTS_V') THEN
4415: IF NVL(p_record.AGREEMENT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4416: RETURN NULL;
4417: END IF;
4418: IF ONT_AGREEMENT_Def_Util.Sync_AGREEMENT_Cache
4419: (p_AGREEMENT_ID => p_record.AGREEMENT_ID) = 1 then
4420: RETURN ONT_AGREEMENT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_AGREEMENT_Def_Util.g_cached_record);
4421: END IF;
4422:
4416: RETURN NULL;
4417: END IF;
4418: IF ONT_AGREEMENT_Def_Util.Sync_AGREEMENT_Cache
4419: (p_AGREEMENT_ID => p_record.AGREEMENT_ID) = 1 then
4420: RETURN ONT_AGREEMENT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_AGREEMENT_Def_Util.g_cached_record);
4421: END IF;
4422:
4423: ELSIF (p_foreign_database_object_name = 'OE_AK_DEL_TO_CONTACT_V') THEN
4424: IF NVL(p_record.DELIVER_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN