3889: ELSIF (p_foreign_database_object_name = 'OE_AK_ACC_RULES_V') THEN
3890: IF NVL(p_record.ACCOUNTING_RULE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
3891: RETURN NULL;
3892: END IF;
3893: IF ONT_ACC_RULE_Def_Util.Sync_ACC_RULE_Cache
3894: (p_ACCOUNTING_RULE_ID => p_record.ACCOUNTING_RULE_ID) = 1 then
3895: RETURN ONT_ACC_RULE_Def_Util.Get_Attr_Val_Varchar2
3896: (p_foreign_attr_code,ONT_ACC_RULE_Def_Util.g_cached_record);
3897: END IF;
3891: RETURN NULL;
3892: END IF;
3893: IF ONT_ACC_RULE_Def_Util.Sync_ACC_RULE_Cache
3894: (p_ACCOUNTING_RULE_ID => p_record.ACCOUNTING_RULE_ID) = 1 then
3895: RETURN ONT_ACC_RULE_Def_Util.Get_Attr_Val_Varchar2
3896: (p_foreign_attr_code,ONT_ACC_RULE_Def_Util.g_cached_record);
3897: END IF;
3898:
3899: ELSIF (p_foreign_database_object_name = 'OE_AK_INVENTORY_ITEMS_V') THEN
3892: END IF;
3893: IF ONT_ACC_RULE_Def_Util.Sync_ACC_RULE_Cache
3894: (p_ACCOUNTING_RULE_ID => p_record.ACCOUNTING_RULE_ID) = 1 then
3895: RETURN ONT_ACC_RULE_Def_Util.Get_Attr_Val_Varchar2
3896: (p_foreign_attr_code,ONT_ACC_RULE_Def_Util.g_cached_record);
3897: END IF;
3898:
3899: ELSIF (p_foreign_database_object_name = 'OE_AK_INVENTORY_ITEMS_V') THEN
3900: IF ( NVL(p_record.INVENTORY_ITEM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )
4477: ELSIF (p_foreign_database_object_name = 'OE_AK_ACC_RULES_V') THEN
4478: IF NVL(p_record.ACCOUNTING_RULE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4479: RETURN NULL;
4480: END IF;
4481: IF ONT_ACC_RULE_Def_Util.Sync_ACC_RULE_Cache
4482: (p_ACCOUNTING_RULE_ID => p_record.ACCOUNTING_RULE_ID) = 1 then
4483: RETURN ONT_ACC_RULE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ACC_RULE_Def_Util.g_cached_record);
4484: END IF;
4485:
4479: RETURN NULL;
4480: END IF;
4481: IF ONT_ACC_RULE_Def_Util.Sync_ACC_RULE_Cache
4482: (p_ACCOUNTING_RULE_ID => p_record.ACCOUNTING_RULE_ID) = 1 then
4483: RETURN ONT_ACC_RULE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ACC_RULE_Def_Util.g_cached_record);
4484: END IF;
4485:
4486: ELSIF (p_foreign_database_object_name = 'OE_AK_INVENTORY_ITEMS_V') THEN
4487: IF ( NVL(p_record.INVENTORY_ITEM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )