Search Results update_plan_element

Overview

CN_PLAN_ELEMENT_PVT is a private (PVT) PL/SQL package in the Oracle EBS Incentive Compensation (CN) module. Its business function is to provide the internal application programming interface for maintaining plan elements, which are stored in the CN_QUOTAS table and represent the individual quota, incentive, and compensation components that make up a compensation plan. Each plan element record carries a quota name and description, quota type, target and performance goal, payment amount, incentive type, start and end dates, credit type, interval type, calculation formula, liability and expense account assignments, vesting flag, quota and payment group codes, and the full set of descriptive flexfield attribute columns (attribute_category and attribute1 through attribute15).

The package encapsulates the record structure, plan_element_rec_type, that describes one such element, and exposes a controlled set of create, update, delete, duplicate, and validation entry points used by the Incentive Compensation setup and administration flows. As a PVT package it is not a public API; it is called by other CN packages and by the forms and concurrent programs that manage compensation plans and quota assignment.

Key Procedures and Functions

• IS_VALID_ORG — Validation function that verifies the organization context supplied by a caller is valid for the plan element operation being performed.
• CREATE_PLAN_ELEMENT — Creates a new plan element, populating the CN_QUOTAS record from the supplied plan element record type and persisting it.
• UPDATE_PLAN_ELEMENT — Modifies an existing plan element, applying changed attributes such as targets, formulas, accounts, and descriptive flexfield values.
• DELETE_PLAN_ELEMENT — Removes a plan element (the quota record) and manages related definition and assignment data, which is the routine most commonly sought by users searching for "delete_plan_element".
• DUPLICATE_PLAN_ELEMENT — Copies an existing plan element to create a new one, typically used when building similar quota or incentive components across plans.
• VALIDATE_PLAN_ELEMENT — Performs consistency and business-rule checks on a plan element before it is created or updated.

The package also exposes the plan_element_rec_type record definition, which mirrors the CN_QUOTAS columns and includes the account concatenation fields liability_account_cc and expense_account_cc.

Tables Accessed

• CN_QUOTAS / CN_QUOTAS_ALL / CN_QUOTAS_S — Primary storage of plan element definitions; the base table, the multi-org view, and the sequence.
• CN_CALC_FORMULAS, CN_CALC_SQL_EXPS, CN_FORMULA_INPUTS — Calculation formula definitions used by plan elements.
• CN_COMP_PLANS — Compensation plans to which elements belong.
• CN_CREDIT_TYPES, CN_INTERVAL_TYPES — Credit and interval reference data referenced by element attributes.
• CN_QUOTA_ASSIGNS, CN_QUOTA_RULES, CN_QUOTA_RULES_ALL, CN_QUOTA_RULE_UPLIFTS — Assignment and rule data linked to quotas.
• CN_RATE_DIMENSIONS, CN_RATE_SCHEDULES — Rate structures used in plan element calculation.

Usage Notes

CN_PLAN_ELEMENT_PVT is invoked by Incentive Compensation plan setup forms and by concurrent programs that import or maintain compensation plans, as well as by other CN packages (it is referenced by five packages). Deletion of a plan element should be driven through DELETE_PLAN_ELEMENT rather than direct DML against CN_QUOTAS, because the package enforces validation and reference handling. The package header carries a $Header revision date of 2007, indicating long-standing stability across EBS 12.1.1 and 12.2.2; behavior is consistent across both releases, with multi-org access handled through the _ALL view and sequence.