Search Results insert_node_record




Overview
Explore in AI Chat

Overview

APPS.CN_RT_QUOTA_ASGNS_PKG is a table handler package in the Oracle EBS Incentive Compensation (CN) module. Its stated purpose, as recorded in the source header, is to serve as the "Table Handler for cn_rt_quota_asgns." Its header comment identifies creation by Kumar Sivasankaran in March 1999, with the source revision at 120.2 dated 11 July 2005. The package is declared AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the calling session rather than the definer, a standard convention for EBS packages invoked from Oracle Forms.

Functionally, the package manages quota assignment records — the association of a quota to a calculation formula and related rate or formula assignment data, bounded by effective start and end dates. Quota assignments in Incentive Compensation determine how quota values are distributed or transformed through calculation formulas before being attributed to sales resources. The package provides the DML orchestration that a form-based maintenance UI requires: record initialization, insertion, hierarchical or dependent node insertion, and deletion.

Key Procedures and Functions

The documented interface consists of four procedures:

  • BEGIN_RECORD — Initializes a quota assignment record for form-level processing. It accepts the organization identifier, an operation indicator, and the full set of descriptive columns including quota, calculation formula, rate schedule, effective dates, the fifteen descriptive flexfield attribute columns, and the standard WHO audit columns (last update date and user, creation date and user, last update login). It also carries a program type discriminator and an object version number, with row identifier, primary key, and version number passed as IN OUT NOCOPY parameters. This is the standard Forms "begin record" pattern that seeds a record buffer before insert.
  • INSERT_RECORD — Performs insertion of a quota assignment record. Its documented parameters are the calculation formula identifier and the quota identifier.
  • INSERT_NODE_RECORD — Inserts a node-level record, handling the hierarchical or dependent aspects of quota assignment data that relate to formula inputs or calculation edges. This is the procedure most directly associated with the search term "insert_node_record."
  • DELETE_RECORD — Removes an existing quota assignment record.

No parameter lists beyond those shown in the excerpt are documented; the four procedures should be treated as the complete public surface.

Tables Accessed

The package operates against the following APPS synonyms:

  • CN_RT_QUOTA_ASGNS and CN_RT_QUOTA_ASGNS_ALL — the base and multi-org views of the quota assignment entity, the primary insert, update, and delete targets.
  • CN_RT_QUOTA_ASGNS_S — the sequence used to generate quota assignment primary keys.
  • CN_QUOTAS_ALL — the quota definition, validated when binding an assignment to a quota.
  • CN_CALC_FORMULAS and CN_CALC_EDGES — calculation formula definitions and the edges of the calculation graph, used to resolve formula relationships during node insertion.
  • CN_FORMULA_INPUTS and CN_RT_FORMULA_ASGNS_ALL — formula input metadata and runtime formula assignments that supply parameters for the inserted assignment.
  • DUAL — used for scalar evaluations and sequence retrieval.
  • PLITBLM — the standard EBS PL/SQL integer table type used for bulk or list-based processing.

Usage Notes

Given its AUTHID CURRENT_USER declaration and the begin/insert/delete triad, this package is designed to be called from an Oracle Forms application maintaining quota assignments. A form block invokes BEGIN_RECORD when the user initiates a new row, INSERT_RECORD or INSERT_NODE_RECORD when the row is committed, and DELETE_RECORD when a row is removed. Because the package is referenced by five other packages, it also participates in programmatic quota assignment maintenance from batch or setup code. The presence of PLITBLM and CN_CALC_EDGES suggests node insertion may process a collection of formula or edge identifiers rather than a single row. Customizations should call the documented procedures rather than issuing direct DML on CN_RT_QUOTA_ASGNS_ALL, so that sequence allocation, audit columns, and object version numbers remain consistent. The package is available in both EBS 12.1.1 and 12.2.2; the source revision predates both releases, indicating a stable interface across the 12.x line.