Search Results cn_period_types




Overview
Explore in AI Chat

Overview

CN_ACC_PERIODS_PVT is a private PL/SQL package in the APPS schema that provides the internal period-management engine for Oracle E-Business Suite's Channel Revenue Management (formerly Oracle Trade Management) accounting calendar. It governs the opening, status tracking, and retrieval of accounting periods used to recognize channel accruals, claims, and trade promotion liabilities. The _PVT suffix denotes a private API classification: the package is not intended as a published integration interface, but rather supplies the core logic consumed by the public wrapper package CN_ACC_PERIODS_PVT_W, which exposes procedures to forms, concurrent programs, and dependent applications. In EBS 12.1.1 and 12.2.2, the package remains VALID and is a supporting member of the CN (Channel) application's period close and accrual processing infrastructure.

Key Procedures and Functions

The package exposes four documented subprograms. Because the ETRM metadata does not publish parameter signatures, only their functional roles are described below.

  • OPEN_PERIOD — Transitions a channel accounting period from a closed/unopened state into an open status. It validates the period against the CN period set and period type definitions before permitting recognition activity.
  • START_REQUEST — Initiates a period-related request, typically for period open/close batch processing or a concurrent-program invocation that drives downstream status updates.
  • UPDATE_ACC_PERIODS — Applies status changes to accounting period records, updating CN_PERIOD_STATUSES and coordinating with the general ledger period statuses where channel activity must align with GL open periods.
  • GET_ACC_PERIODS — Retrieves accounting period information for the calling process, returning the period definitions and status data used by forms and validation logic.

Tables Accessed

The package references the following tables through APPS synonyms:

  • CN_PERIOD_SETS — Defines the grouping of periods that constitutes a channel accounting calendar; read to resolve which periods belong to a given set.
  • CN_PERIOD_STATUSES — The primary transactional store of period state (open/closed/pending); both read and updated by the package.
  • CN_PERIOD_TYPES — Supplies the period-type classification that the user query cn_period_types targets; used to determine whether a period is of the appropriate type for the requested operation, such as accrual versus recognition periods.
  • GL_PERIOD_STATUSES — Read to synchronize channel period open/close actions with the General Ledger calendar statuses.
  • CN_REPOSITORIES — Read to resolve repository context associated with channel period configuration.
  • PLITBLM — The EBS standard PL/SQL message/lookup table, used for message resolution and error handling.
  • CN_LOOKUPS and GL_LOOKUPS — Lookup views referenced for code validation and descriptive values.

Usage Notes

CN_ACC_PERIODS_PVT should not be called directly by custom code. Oracle packages it as a private implementation layer beneath CN_ACC_PERIODS_PVT_W, which is the supported entry point invoked from Channel Revenue Management setup forms (period open/close), concurrent programs that manage channel period maintenance, and internal accrual processing routines. When the user searches for cn_period_types, the relevant dependency is the CN_PERIOD_TYPES table, which this package reads to classify periods during OPEN_PERIOD and UPDATE_ACC_PERIODS. Customizations that must enumerate or validate channel period types should query CN_PERIOD_TYPES directly or call the public wrapper rather than referencing the private package. Because it is referenced by only one other package, its footprint is narrow, and any change to it carries correspondingly limited but tightly coupled impact on channel period functionality.