Results for “okl_atl_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_ATL_PVT is a private PL/SQL package in the Oracle E-Business Suite Lease Management (OKL) module, declared with AUTHID CURRENT_USER and belonging to the ETRM (Enterprise Territory and Lease Management) technical stack. Its name derives from "ATL," which in this context refers to the Account Template Lines functionality within Oracle Lease Management, and the "_PVT" suffix indicates that this is a private, internal-use package rather than a public API exposed for customer extension. The package provides the procedural infrastructure that supports the definition, validation, and maintenance of account template line records—the structured data that governs how lease accounting entries are generated, segmented, and posted to the General Ledger.

Account templates in Oracle Lease Management allow organizations to predefine accounting rules for contracts, including the code combinations, percentage splits, and account builder logic that determine how lease-related transactions are journalized. The OKL_ATL_PVT package operates on the underlying data structures that store these template lines, ensuring that each line record carries a valid chart of accounts reference, correct line type assignment, and consistent attribute values before it is committed to the database. This is of particular relevance in multi-organization deployments, where the ORG_ID column and the flexible attribute columns (ATTRIBUTE1 through ATTRIBUTE15) allow global templates to be localized for specific business entities or regulatory environments.

Key Procedures and Functions

The documented interface of OKL_ATL_PVT comprises eight procedures and functions, reflecting a standard ETRM private-package pattern centered on record lifecycle management and concurrency control:

• INSERT_ROW — Creates a new account template line record, populating the target table from the ATL_REC_TYPE record structure and initializing audit and object-versioning columns.
• UPDATE_ROW — Modifies an existing account template line, applying changed values while preserving the integrity of the record's primary key and version information.
• DELETE_ROW — Physically or logically removes an account template line record from the underlying table.
• LOCK_ROW — Obtains a row-level lock on a template line record to prevent concurrent modification during an update or validation cycle.
• VALIDATE_ROW — Performs the business-rule validation checks applied to a template line before it is inserted or updated, including account builder and code combination consistency.
• CHANGE_VERSION — Manages the OBJECT_VERSION_NUMBER column used by the Oracle framework for optimistic locking and change detection.
• API_COPY — Duplicates an existing account template line (or set of lines), supporting the common business requirement of cloning a template and then adjusting its accounting rules for a new contract or organization.
• QC — A quality-control routine that verifies data consistency for account template lines, typically invoked during concurrent processing or upgrade validation to detect orphaned or malformed records.

Tables Accessed

The package operates primarily against OKL_AE_TMPT_LNES, the base table storing individual account template lines. Columns referenced include ACCOUNT_BUILDER_YN, CRD_CODE, DESCRIPTION, the ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 flexfields, and the CODE_COMBINATION_ID that links each line to a valid GL account. OKL_AE_TEMPLATES serves as the parent header table, providing the template context to which each line belongs. PLITBLM is the standard Oracle Applications multi-organization (MO) security table used to enforce operating unit access restrictions, confirming that OKL_ATL_PVT honors the MOAC model.

Usage Notes

As a private package, OKL_ATL_PVT is not intended for direct invocation by custom code. It is called internally by the account template line public APIs and their supporting packages; the metadata records that it is referenced by eleven other packages within the OKL schema. It is typically triggered indirectly through the Lease Management accounting template setup forms, through concurrent programs that generate or copy account templates, and during the accounting generation process when template lines are applied to lease contracts. During upgrades or data migrations, the QC routine may be invoked to validate existing template line data. The relevance of this package to any given contract—such as a United Aviation Services FZCO ATC contract—lies in whether that contract's accounting derives from a lease accounting template whose lines are maintained through this package.