Search Results cn_srp_rate_assigns_pkg




Overview
Explore in AI Chat

Overview

The package body APPS.CN_SRP_RATE_ASSIGNS_PKG is a stored PL/SQL program unit in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases, owned by the APPS schema and reported with a VALID status. It belongs to the Oracle Incentive Compensation (CN) product family, specifically the Sales Resource Planning (SRP) subsystem. Its business purpose is to manage the assignment of rate tiers to sales resources and quota assignments, providing the programmatic interface through which rate assignment records are created, maintained, locked, and kept synchronized with the underlying quota structures. In the ETRM classification this package is categorized as an OTHER API — that is, it is intended for controlled use rather than being a fully public, supported interface. The package is a cohesive unit that encapsulates the DML and validation logic for the CN_SRP_RATE_ASSIGNS entity, insulating forms and concurrent programs from the physical table layout and enforcing consistent behavior across all callers. It also maintains the sequence-driven surrogate keying for the entity and coordinates with quota-tier and rate-tier data to ensure that assignments remain internally consistent whenever quota information changes.

Key Procedures and Functions

The documented public interface comprises five procedures/functions:

  • INSERT_RECORD — Creates a new rate assignment record for a sales resource, populating the target table and generating the primary key from the associated sequence.
  • LOCK_RECORD — Acquires a row-level lock on an existing rate assignment, typically used to serialize concurrent updates and to validate the current state before modification.
  • UPDATE_RECORD — Modifies the attributes of an existing rate assignment record after it has been locked and validated.
  • DELETE_RECORD — Removes a rate assignment record from the entity table, subject to the package's internal integrity checks.
  • SYNCH_RATE — Reconciles rate assignment data with related quota and rate-tier information, ensuring that assignments reflect the current quota structure and applied rates.

No parameter lists are published in the documentation; parameter behavior is therefore not reproduced here.

Tables Accessed

The package performs DML and queries against the following documented tables through APPS synonyms:

  • CN_SRP_RATE_ASSIGNS_ALL — the primary transactional table holding rate assignment rows; target of INSERT_RECORD, UPDATE_RECORD, and DELETE_RECORD.
  • CN_SRP_RATE_ASSIGNS_S — the sequence used to generate unique identifiers for new assignment records.
  • CN_RATE_TIERS_ALL — the rate-tier definition table, read to validate and resolve the tier chosen for an assignment.
  • CN_RT_QUOTA_ASGNS_ALL — the rate/quota assignment table, consulted to align rate assignments with the applicable quota assignment.
  • CN_SRP_QUOTA_ASSIGNS_ALL — the SRP quota assignment table, used by SYNCH_RATE and the maintenance procedures to keep rate and quota assignments consistent.

Additional dependencies include the standard packages APP_EXCEPTION, FND_GLOBAL (for session and user context), and FND_MESSAGE (for translatable error messaging).

Usage Notes

Calls to this package originate from the SRP setup and maintenance forms and from concurrent programs that generate or refresh rate assignments. The typical invocation pattern is to lock first (LOCK_RECORD), then update or delete (UPDATE_RECORD, DELETE_RECORD), while INSERT_RECORD is used for new assignments. SYNCH_RATE is called when quota or rate-tier data changes and existing assignments must be recalculated. Because the package is classified as OTHER rather than a public API, custom code should call it only with caution and in consultation with Oracle support, and the dependency metadata states that the package is not referenced by any other database object, so its exposure surface is limited to its direct callers.