Search Results okl_am_system_params_pvt




Overview
Explore in AI Chat

Overview

OKL_SYP_PVT is a private PL/SQL package in the APPS schema that encapsulates the core business logic for managing Oracle Lease and Finance Management (OLFM/ETRM) system parameters. The package name derives from "System Parameters — Private," and it functions as the implementation layer behind the publicly callable OKL_SYSTEM_PARAMS_ALL_PUB and OKL_AM_SYSTEM_PARAMS_PUB interfaces. Its primary responsibility is to maintain the configuration records stored in the OKL_SYSTEM_PARAMS and OKL_SYSTEM_PARAMS_ALL tables, which govern default behavior for lease origination, booking, asset management, and accounting across the ETRM application.

The package is classified as PVT, meaning it is not intended for direct invocation by customers or external integrations. It provides the transactional and validation engine that public APIs, forms, and concurrent programs call when defaults, profile-style settings, or system-level parameters must be created, changed, or copied.

Key Procedures and Functions

The documented API surface comprises 18 procedures and functions grouped into functional categories:

  • QC — a query/check routine used internally for retrieval or conditional evaluation of parameter data.
  • CHANGE_VERSION — manages version control and concurrency stamping on parameter records, ensuring callers operate against consistent data. The version column supports optimistic locking.
  • API_COPY — replicates an existing set of system parameters into a new context, supporting rapid setup of new operating units or leasing scenarios based on proven configurations.
  • INSERT_ROW — creates new parameter records with defaults and mandatory column derivation.
  • LOCK_ROW — acquires a row-level lock (typically via SELECT FOR UPDATE) prior to modification, protecting against concurrent updates.
  • UPDATE_ROW — applies changes to existing parameter records.
  • DELETE_ROW — removes parameter records that are no longer required.
  • VALIDATE_ROW — enforces business rules and referential integrity against lookup values and related tables before a row is committed.

Together these procedures form the standard private-API pattern: lock, validate, insert/update/delete, with version management layered on top.

Tables Accessed

OKL_SYP_PVT reads and writes OKL_SYSTEM_PARAMS and OKL_SYSTEM_PARAMS_ALL through APPS synonyms; these are the principal persistence tables for OLFM system parameters. Validation logic also touches a broad set of reference tables, including FND_LOOKUP_VALUES for lookup-code verification; OKL_FORMULAE_B and OKL_STRM_TYPE_B for formula and stream-type definitions; QP_LIST_HEADERS_TL for pricing list references; and a range of Oracle Assets and Inventory tables (FA_ASSET_KEYWORDS, FA_BOOK_CONTROLS, FA_LOCATIONS, MTL_CATEGORY_SETS, MTL_ITEM_CATEGORIES, MTL_ITEM_TEMPLATES, MTL_SECONDARY_INVENTORIES) to validate default asset and item attributes. The PLITBLM table and related standard APIs (FND_API, OKC_API, OKL_API) supply the standard EBS API infrastructure used for message handling and error propagation.

Usage Notes

OKL_SYP_PVT is not invoked directly by end users. It is called by the public wrapper packages OKL_AM_SYSTEM_PARAMS_PUB, OKL_SYSTEM_PARAMS_ALL_PUB, and the corresponding private wrappers (OKL_AM_SYSTEM_PARAMS_PVT, OKL_SYP_PVT, and their _W variants). Forms in the Leasing Management responsibility (for example, the System Parameters setup form) call the public APIs, which delegate to this package. Concurrent programs that initialize or migrate leasing setups also route through it. The package is referenced by seven other packages in the ETRM schema. Because it operates within the APPS schema under the standard API error-handling conventions, custom code should always target the public *_PUB interfaces rather than calling OKL_SYP_PVT directly. The presence of OKL_AM_SYSTEM_PARAMS_PVT and OKL_SYP_PVT in the referenced-by list is expected, since these names correspond to the same private implementation tier across OLFM and the core ETRM modules.