Search Results create_dimension_pre

Overview

CN_MULTI_RATE_SCHEDULES_VUHK is an internal helper package in the APPS schema that supports the public multi-rate schedule API used by Oracle E-Business Suite. Its name indicates it is a "validation/user hook" companion (the VUHK suffix) to the public package APPS.CN_MULTI_RATE_SCHEDULES_PUB. Where the _PUB package exposes the supported, callable interface for creating and maintaining multi-rate schedules, dimensions, dimension assignments, and rate tiers, the _VUHK package encapsulates the pre- and post-processing logic that Oracle's own business logic executes around each public API call. It is classified as OTHER in the ETRM metadata, meaning it is not itself a formal public API, but rather a supporting component that the public APIs delegate to internally.

The package is therefore best understood as part of the implementation behind the multi-rate scheduling feature set in Oracle Incentive Compensation / Channel Revenue Management related pricing and rate configuration, rather than as an entry point that customers are expected to call directly.

Key Procedures and Functions

The ETRM metadata documents 26 procedures and functions, predominantly paired PRE/POST variants that bracket the corresponding public API operations. Documented entries include:

• CREATE_SCHEDULE_PRE and CREATE_SCHEDULE_POST - bracket the creation of a rate schedule header, performing validation and setup before the write and any follow-up processing after it.
• UPDATE_SCHEDULE_PRE and UPDATE_SCHEDULE_POST - bracket updates to an existing rate schedule.
• DELETE_SCHEDULE_PRE and DELETE_SCHEDULE_POST - bracket the removal of a rate schedule and its related data.
• CREATE_DIMENSION_ASSIGN_PRE and CREATE_DIMENSION_ASSIGN_POST - validate and finalize assignment of a rate dimension to a schedule.
• UPDATE_DIMENSION_ASSIGN_PRE and UPDATE_DIMENSION_ASSIGN_POST - support modification of dimension assignments.
• DELETE_DIMENSION_ASSIGN_PRE and DELETE_DIMENSION_ASSIGN_POST - support removal of dimension assignments.
• UPDATE_RATE_PRE and UPDATE_RATE_POST - bracket updates to rate and tier values.
• CREATE_DIMENSION_PRE, CREATE_DIMENSION_POST, UPDATE_DIMENSION_PRE, UPDATE_DIMENSION_POST, DELETE_DIMENSION_PRE, and DELETE_DIMENSION_POST - bracket the lifecycle of individual rate dimensions.

The PRE routines typically enforce business rules, check prerequisites, and prepare derived values, while the POST routines perform cascade updates, cleanup, or consistency enforcement once the primary write has completed.

Tables Accessed

The package operates against the core multi-rate scheduling data model via APPS synonyms:

• CN_RATE_SCHEDULES - the schedule header, holding the overall rate schedule definition.
• CN_RATE_SCH_DIMS - the association of dimensions to a schedule.
• CN_RATE_DIMENSIONS - the individual rate dimension definitions.
• CN_RATE_DIM_TIERS - tier definitions belonging to each dimension.
• CN_RATE_TIERS - the rate/tier values applied within the schedule.

These tables are read and written to persist validated schedule, dimension, assignment, and tier data as part of each bracketed API operation.

Usage Notes

CN_MULTI_RATE_SCHEDULES_VUHK is not intended to be invoked directly by customers. It is referenced by, and exists to serve, APPS.CN_MULTI_RATE_SCHEDULES_PUB, which the ETRM metadata confirms as both a dependency and a referencing package. In practice it is exercised whenever the public multi-rate schedule APIs run - typically from Oracle Forms within the pricing/rate configuration UI, from concurrent programs that load or maintain rate schedules, and from custom extensions that legitimately call CN_MULTI_RATE_SCHEDULES_PUB. Users who searched for cn_multi_rate_schedules_pub should treat that _PUB package as their supported integration point; CN_MULTI_RATE_SCHEDULES_VUHK is an internal implementation detail subject to change and should not be called or modified directly.