Search Results synch_rate

Overview

CN_SRP_RATE_ASSIGNS_PKG is an Oracle EBS Advanced Compensation (formerly Incentive Compensation / Sales Repository, SRP) PL/SQL package owned by the APPS schema. Its primary business function is to manage the association between salesrep rate assignments, quota assignments, rate schedules, and rate tiers within a compensation plan. The package encapsulates the table-handler logic required to maintain the CN_SRP_RATE_ASSIGNS_ALL entity, which stores the commission rate, commission amount, and tier-level information that drives incentive compensation calculations for each salesperson enrolled in a plan.

The header declares the package with AUTHID CURRENT_USER, indicating that it executes with the privileges of the invoking schema rather than the definer, which is typical for EBS table handlers invoked from Oracle Forms. The package was originally created in January 1994 and last modified in January 2002 per the embedded header, reflecting its long-standing role as a foundational component of the compensation module.

Key Procedures and Functions

The package exposes five procedures, all of which are documented in the ETRM metadata:

• INSERT_RECORD — Creates a new rate-assignment row. It accepts identifiers for the plan assignment, quota assignment, rate assignment, quota, rate schedule, rate tier, and RT quota assignment, along with commission rate, commission amount, discount-rate-table flag, and rate sequence. It is the form-level insert handler for the rate_assign block.
• LOCK_RECORD — Obtains a row-level lock on an existing rate-assignment record, using the plan assignment, quota assignment, rate assignment, rate tier, commission rate, and commission amount as the identifying and validation criteria. It supports Oracle Forms' optimistic-locking pattern.
• UPDATE_RECORD — Modifies an existing rate-assignment row. It receives both new and old values for commission rate and commission amount, plus start period, salesrep, and audit columns (last update date, updated by, update login) to perform a consistent, change-tracked update.
• DELETE_RECORD — Removes a rate-assignment row based on the plan assignment, rate assignment, quota, rate schedule, RT quota assignment, and rate tier identifiers.
• SYNCH_RATE — Synchronizes rate information across the assignment hierarchy. It takes the plan assignment, quota assignment, rate schedule, rate tier, commission rate, salesrep, start period, and commission amount as inputs and propagates rate values so that dependent records remain consistent. This is the procedure users typically reach when searching for "synch_rate."

Tables Accessed

The package operates against the following tables through APPS synonyms:

• CN_SRP_RATE_ASSIGNS_ALL — The primary entity maintained by the insert, update, delete, lock, and synchronize operations.
• CN_SRP_RATE_ASSIGNS_S — The sequence/denormalized companion used to generate rate-assignment identifiers.
• CN_SRP_QUOTA_ASSIGNS_ALL — Provides the quota-assignment context that rate assignments reference.
• CN_RT_QUOTA_ASGNS_ALL — Relates rate tiers to quota assignments, supporting tier-level rate derivation.
• CN_RATE_TIERS_ALL — Supplies rate tier definitions used when validating and synchronizing commission rates.

Usage Notes

This package is primarily invoked from the Oracle Forms module cnsrmt (block rate_assign), as noted in the package header, and secondarily from cnpldf. It is also referenced by three other packages within the compensation module, which call its procedures for shared rate-assignment maintenance. Typical invocation scenarios include creating or amending a salesrep's rate assignment during plan setup, locking records during form-based editing, and running SYNCH_RATE when rate schedules or tiers change and dependent assignment records must be brought into alignment. Because it is a table handler rather than a public API, customizations should call it cautiously and respect the audit and locking conventions built into its procedures.