Search Results c_end_date

Overview

CN_OVER_ASSIGN_PVT is a private (PVT) PL/SQL package body owned by the APPS schema within Oracle E-Business CRM. It supports the compensation and quota management functionality of Oracle Territory Manager / Channel Revenue Management by calculating over-assignments against sales representative (SRP) quota allocations. The package encapsulates internal logic that determines how much quota has already been committed or assigned relative to the amounts defined for a given sales representative role and quota category.

The source header identifies the package as cn_over_assign_pvt backed by the file cnvoasgb.pls (version 115.15). Because the classification is PVT, the package is not intended as a public integration surface; it is consumed internally by the over-assignment validation logic exposed through the application's quota assignment UI.

Key Procedures and Functions

• GET_OVERASSIGN — The single documented program unit in this package. It serves as the entry point for retrieving over-assignment information for a sales representative role and quota category. It aggregates quota amounts, planning amounts, and prorated amounts to determine the quantity that has been over-assigned.
• add_quota (private helper, per source excerpt) — An internal procedure that accumulates quota records into an in-memory PL/SQL table (quota_amount_tbl_type). It accepts a role identifier and a start/end date range, resolves the SRP role details, and fetches matching quota amounts from cn_srp_quota_cates. This helper feeds the date-range logic that the c_start_date reference implies.

Users searching for c_start_date are encountering the private cursor or variable naming convention inside this package body. The documented source shows an SRP role info cursor that selects Trunc(start_date) and Nvl(Trunc(end_date), p_end_date), which is the mechanism by which assigned periods are bounded when evaluating quota against a request.

Tables Accessed

• CN_SRP_QUOTA_CATES — Stores quota category amounts, planning amounts, and prorated amounts per SRP role. Read to obtain the baseline quota figures used in the over-assignment calculation.
• CN_QUOTA_CATEGORIES — Defines the quota categories used to classify and group quota allocations.
• CN_SRP_ROLE_DTLS — Holds sales representative role detail records, including effective start and end dates that drive the period logic.
• DUAL — Used for single-row seed or utility selections.
• PLITBLM — The standard PL/SQL table/index-by helper used for in-memory collections, aligning with the quota_amount_tbl_type used by the private add_quota procedure.

Usage Notes

CN_OVER_ASSIGN_PVT is invoked from within the quota assignment flow, typically triggered when a user assigns or reallocates quota in the compensation forms and the application must verify how much has already been consumed. It is also reachable from concurrent processing that reconciles quota assignments. No other packages reference it directly per the documented dependency data, confirming its role as a private implementation detail behind the public quota management APIs.

Custom code should avoid calling this package directly; instead, use the public compensation APIs. Because the package relies on fnd_global.user_id and fnd_global.login_id for audit columns at initialization, it assumes a valid EBS session context. The date-bounded cursor behavior means results can vary depending on the start and end dates supplied by the calling context, which explains the prominence of c_start_date in user searches.