Search Results get_acc_periods

Overview

CN_ACC_PERIODS_PVT_W is a private PL/SQL wrapper package owned by the APPS schema in Oracle E-Business Suite. Its name follows the Oracle "PVT_W" convention, indicating that it is a generated or internally layered wrapper that fronts the core private package CN_ACC_PERIODS_PVT. The package belongs to the Oracle Enterprise Asset Management / property and calendar management domain, and its central purpose is to expose and manipulate accounting period definitions through a controlled, table-driven interface.

The wrapper pattern is significant: rather than binding directly to scalar parameter lists, the procedures accept and return data as sets of parallel JTF collection types (JTF_VARCHAR2_TABLE_100, JTF_NUMBER_TABLE, and JTF_DATE_TABLE). This design supports bulk, multi-row operations and allows the calling layer — typically an OAF-based business service or a Business Event subscription — to pass entire result sets in a single call. The package therefore acts as the bridge between the EBS business layer and the underlying accounting period data model.

Key Procedures and Functions

• ROSETTA_TABLE_COPY_IN_P1 — Converts the parallel JTF collection arrays supplied by the caller into the strongly typed PL/SQL record table CN_ACC_PERIODS_PVT.ACC_PERIOD_TBL_TYPE. It is the inbound marshalling routine used before any write or validation processing occurs.
• ROSETTA_TABLE_COPY_OUT_P1 — Performs the inverse transformation, unpacking the internal ACC_PERIOD_TBL_TYPE structure back into the individual JTF collections so results can be returned across the API boundary.
• UPDATE_ACC_PERIODS — The primary DML entry point. It accepts the standard EBS API control parameters (API version, initialization of the message list, commit flag, and validation level), the marshalled period collection, and an organization identifier. It returns the standard return status, message count, and message data out parameters that conform to the EBS API error-handling model.
• GET_ACC_PERIODS — The query counterpart, keyed by accounting year. It returns period rows through the JTF collection parameters together with three descriptive out parameters: system status, calendar, and period type.

Tables Accessed

The documented table reference for this package is the APPS synonym PLITBLM, which is a generic PL/SQL internal table used by the Oracle Tool and Forms infrastructure. No application data table such as GL_PERIODS or FND_CALENDARS is directly documented, which is consistent with the wrapper's role: actual persistence is delegated to the underlying CN_ACC_PERIODS_PVT package and the accounting period schema, while this layer handles only parameter marshalling and API envelope handling.

Usage Notes

CN_ACC_PERIODS_PVT_W is not intended for direct invocation by end users or by customer-written concurrent programs. It is an internal layer, and the ETRM metadata records zero dependent packages, confirming that it is a leaf-level utility rather than a shared foundation component. Typical invocation occurs from Oracle Application Framework pages and enterprise asset management forms that need to populate or refresh an accounting-period list for a given year, or from internal business flows that maintain period attributes. Because procedures are overloaded through the JTF table types, callers must supply all collection arrays in matching cardinality and must honor the p_commit and p_validation_level semantics when invoking UPDATE_ACC_PERIODS. Custom code should call the corresponding public API rather than this private wrapper to remain upgrade-safe across EBS 12.1.1 and 12.2.2.