Search Results update_perd_row

Overview

OKL_PERD_STATUS_PVT is a private (PVT) API package in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It encapsulates the period-status validation and synchronization logic that the OKL application relies upon when interacting with General Ledger accounting periods. The package declares the AUTHID CURRENT_USER directive, meaning its SQL statements execute with the privileges of the calling schema rather than the package owner, a design typical of private helper packages designed to be called from within the OKL application stack.

The package exposes a strongly typed PL/SQL record (period_rec_type) and a corresponding collection type (period_tbl_type) that mirror the structure of GL_PERIOD_STATUSES. This record structure is central to the package's operation, as it provides a canonical in-memory representation of a period row that can be passed between the package's internal procedures and its callers. The presence of the G_MISS_* default markers on virtually every field, drawn from OKL_API, indicates that the package follows the standard Oracle Applications API design convention: each attribute carries a sentinel value until explicitly populated by the caller.

Key Procedures and Functions

• SEARCH_PERIOD_STATUS — Queries period status information, likely returning a set of period records (as period_tbl_type) matching the supplied search criteria. It supports the OKL application in identifying which GL periods are open, closed, or in a pending state for a given set of books.
• UPDATE_PERIOD_STATUS — Performs the primary update of a period status row, applying the values contained in a period_rec_type structure to the underlying GL_PERIOD_STATUSES record. This is the higher-level entry point for period-status maintenance.
• UPDATE_PERD_ROW — The procedure the user specifically searched for. It operates on a single period row, updating the record identified by the supplied key values. In the OKL workflow, UPDATE_PERD_ROW is the lower-level worker procedure invoked by UPDATE_PERIOD_STATUS and by other OKL packages (the package is referenced by three other packages) to persist individual period-status changes, including closing status, adjustment-period flag, and elimination-confirmed flag.

Tables Accessed

• GL_PERIOD_STATUSES — The primary table. Its columns define the period_rec_type record, and the package reads and writes rows here to maintain accounting period state.
• XLA_EVENTS — Referenced to align OKL subledger events with the period in which they post, ensuring period-status changes do not orphan accounting events.
• XLA_TRANSACTION_ENTITIES — Used to associate transaction entities with the relevant period for subledger accounting purposes.
• PLITBLM — A standard Oracle Applications table used for storing and retrieving PL/SQL table (collection) data, consistent with the package's use of period_tbl_type collections.

Usage Notes

OKL_PERD_STATUS_PVT is classified as PVT (private), which means it is not intended as a public integration API. Custom code should not call it directly; the supported public APIs live elsewhere in the OKL API family. Within the EBS 12.1.1 and 12.2.2 codebase, it is invoked from the OKL forms and concurrent programs that manage lease accounting period close and open activities. Because it declares AUTHID CURRENT_USER, any caller must have appropriate privileges on GL_PERIOD_STATUSES and the XLA tables. Developers troubleshooting period-status errors should trace the call stack from the public OKL API down into UPDATE_PERD_ROW to understand how a period-row update was applied.