Search Results cn_period_sets




Overview
Explore in AI Chat

Overview

CN_SYSTEM_PARAMETERS_PVT is a private PL/SQL package body in the APPS schema that supports Oracle EBS Channel Revenue Management (formerly Oracle Trade Management / CN modules). It provides centralized access to a single row of system-level configuration held in CN_REPOSITORIES, the repository table that stores the active "CN" application setup. The package exposes a read interface (GET_DATA) and a maintenance interface (UPDATE_DATA) so that forms, concurrent programs, and internal APIs can consistently retrieve or persist channel management operating parameters — such as the set of books, revenue class hierarchy, batch sizing, clawback grace period, payables and payroll flags, and usage indicators — without embedding direct SQL against CN_REPOSITORIES throughout the application. The "PVT" classification indicates this is an internal, non-public API intended for use by other CN packages rather than directly by customer extensions.

Key Procedures and Functions

  • GET_DATA — Retrieves the current channel management system parameters row from CN_REPOSITORIES (where application_type = 'CN' and repository_id > 0). It returns a comprehensive set of OUT parameters covering identification (name, status), financial setup (set of books id, name, currency, calendar, and period type), processing controls (system/batch sizes, transfer batch size, clawback grace days, salesperson and rule batch sizes), flags (payables, payroll, usage, managerial rollup), CCID level, income planner disclaimer, latest processed date, and the object version number. Null values are normalized to defaults (e.g., batch size defaults to 5000, hierarchy id to -1) to avoid propagating NULLs to callers.
  • UPDATE_DATA — The counterpart maintenance procedure. It persists changes to the same configuration attributes back into CN_REPOSITORIES, maintaining the object_version_number for optimistic concurrency control. This is the procedure most relevant to the user's search term "update_data," and it is the only documented write path for CN system parameters exposed by this package.

Tables Accessed

  • CN_REPOSITORIES — The primary table read by GET_DATA and written by UPDATE_DATA. It holds the single active CN configuration row including all batch sizes, flags, set of books reference, hierarchy reference, and version number.
  • CN_PERIOD_SETS — Referenced to resolve period-set information associated with the set of books/calendar configuration.
  • CN_PERIOD_TYPES — Referenced to resolve the accounting period type used in channel revenue processing.

Usage Notes

Because the API classification is PVT and it is not referenced by any other documented packages, invocation is normally indirect: CN application forms and concurrent programs call this package (or a thin public wrapper) to load configuration into form blocks on query, and to validate and save edits on commit via UPDATE_DATA. Custom code should generally avoid calling PVT APIs directly, since the interface can change between point releases; the recommended approach is to drive changes through the supported Channel Revenue Management setup form. When direct invocation is unavoidable in Oracle EBS 12.1.1 or 12.2.2, callers should honor the returned object_version_number to detect concurrent updates, and should treat OUT values from GET_DATA as the authoritative defaults, since the procedure applies NVL-based substitution for NULL configuration columns.