4233: ELSIF (p_foreign_database_object_name = 'OE_AK_CHARGE_PERIODICITY_V') THEN
4234: IF NVL(p_record.CHARGE_PERIODICITY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4235: RETURN NULL;
4236: END IF;
4237: IF ONT_CHG_PRDCTY_CODE_Def_Util.Sync_CHG_PRDCTY_CODE_Cache
4238: (p_UOM_CODE => p_record.CHARGE_PERIODICITY_CODE) = 1 then
4239: RETURN ONT_CHG_PRDCTY_CODE_Def_Util.Get_Attr_Val_Varchar2
4240: (p_foreign_attr_code,ONT_CHG_PRDCTY_CODE_Def_Util.g_cached_record);
4241: END IF;
4235: RETURN NULL;
4236: END IF;
4237: IF ONT_CHG_PRDCTY_CODE_Def_Util.Sync_CHG_PRDCTY_CODE_Cache
4238: (p_UOM_CODE => p_record.CHARGE_PERIODICITY_CODE) = 1 then
4239: RETURN ONT_CHG_PRDCTY_CODE_Def_Util.Get_Attr_Val_Varchar2
4240: (p_foreign_attr_code,ONT_CHG_PRDCTY_CODE_Def_Util.g_cached_record);
4241: END IF;
4242:
4243: ELSIF (p_foreign_database_object_name = 'OE_AK_SRV_DURATION_V') THEN
4236: END IF;
4237: IF ONT_CHG_PRDCTY_CODE_Def_Util.Sync_CHG_PRDCTY_CODE_Cache
4238: (p_UOM_CODE => p_record.CHARGE_PERIODICITY_CODE) = 1 then
4239: RETURN ONT_CHG_PRDCTY_CODE_Def_Util.Get_Attr_Val_Varchar2
4240: (p_foreign_attr_code,ONT_CHG_PRDCTY_CODE_Def_Util.g_cached_record);
4241: END IF;
4242:
4243: ELSIF (p_foreign_database_object_name = 'OE_AK_SRV_DURATION_V') THEN
4244: IF NVL(p_record.SERVICE_DURATION,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4791: ELSIF (p_foreign_database_object_name = 'OE_AK_CHARGE_PERIODICITY_V') THEN
4792: IF NVL(p_record.CHARGE_PERIODICITY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4793: RETURN NULL;
4794: END IF;
4795: IF ONT_CHG_PRDCTY_CODE_Def_Util.Sync_CHG_PRDCTY_CODE_Cache
4796: (p_UOM_CODE => p_record.CHARGE_PERIODICITY_CODE) = 1 then
4797: RETURN ONT_CHG_PRDCTY_CODE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_CHG_PRDCTY_CODE_Def_Util.g_cached_record);
4798: END IF;
4799:
4793: RETURN NULL;
4794: END IF;
4795: IF ONT_CHG_PRDCTY_CODE_Def_Util.Sync_CHG_PRDCTY_CODE_Cache
4796: (p_UOM_CODE => p_record.CHARGE_PERIODICITY_CODE) = 1 then
4797: RETURN ONT_CHG_PRDCTY_CODE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_CHG_PRDCTY_CODE_Def_Util.g_cached_record);
4798: END IF;
4799:
4800: ELSIF (p_foreign_database_object_name = 'OE_AK_SRV_DURATION_V') THEN
4801: IF NVL(p_record.SERVICE_DURATION,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN