3940: ELSIF (p_foreign_database_object_name = 'OE_AK_PAYMENT_TERM_V') THEN
3941: IF NVL(p_record.PAYMENT_TERM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
3942: RETURN NULL;
3943: END IF;
3944: IF ONT_PAY_TERM_Def_Util.Sync_PAY_TERM_Cache
3945: (p_PAYMENT_TERM_ID => p_record.PAYMENT_TERM_ID) = 1 then
3946: RETURN ONT_PAY_TERM_Def_Util.Get_Attr_Val_Varchar2
3947: (p_foreign_attr_code,ONT_PAY_TERM_Def_Util.g_cached_record);
3948: END IF;
3942: RETURN NULL;
3943: END IF;
3944: IF ONT_PAY_TERM_Def_Util.Sync_PAY_TERM_Cache
3945: (p_PAYMENT_TERM_ID => p_record.PAYMENT_TERM_ID) = 1 then
3946: RETURN ONT_PAY_TERM_Def_Util.Get_Attr_Val_Varchar2
3947: (p_foreign_attr_code,ONT_PAY_TERM_Def_Util.g_cached_record);
3948: END IF;
3949:
3950: ELSIF (p_foreign_database_object_name = 'OE_PRICE_LISTS_V') THEN
3943: END IF;
3944: IF ONT_PAY_TERM_Def_Util.Sync_PAY_TERM_Cache
3945: (p_PAYMENT_TERM_ID => p_record.PAYMENT_TERM_ID) = 1 then
3946: RETURN ONT_PAY_TERM_Def_Util.Get_Attr_Val_Varchar2
3947: (p_foreign_attr_code,ONT_PAY_TERM_Def_Util.g_cached_record);
3948: END IF;
3949:
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
4524: ELSIF (p_foreign_database_object_name = 'OE_AK_PAYMENT_TERM_V') THEN
4525: IF NVL(p_record.PAYMENT_TERM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4526: RETURN NULL;
4527: END IF;
4528: IF ONT_PAY_TERM_Def_Util.Sync_PAY_TERM_Cache
4529: (p_PAYMENT_TERM_ID => p_record.PAYMENT_TERM_ID) = 1 then
4530: RETURN ONT_PAY_TERM_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_PAY_TERM_Def_Util.g_cached_record);
4531: END IF;
4532:
4526: RETURN NULL;
4527: END IF;
4528: IF ONT_PAY_TERM_Def_Util.Sync_PAY_TERM_Cache
4529: (p_PAYMENT_TERM_ID => p_record.PAYMENT_TERM_ID) = 1 then
4530: RETURN ONT_PAY_TERM_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_PAY_TERM_Def_Util.g_cached_record);
4531: END IF;
4532:
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