Search Results okl_poolconc_pvt_w




Overview
Explore in AI Chat

Overview

OKL_POOLCONC_PVT_W is a private PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the pool content maintenance functionality within Oracle Lease and Finance Management (OKL/ETRM). The package is declared with AUTHID CURRENT_USER, meaning that its procedures execute with the privileges of the invoker rather than the definer, a common convention in EBS for packages that participate in a calling user's session context. Its source header indicates a last modification date of 2007, placing it within the original development lineage of the Lease Management pool feature set.

The business function of this package centers on managing the contents of lease pools. A pool in ETRM represents a grouping of lease contracts or streams that are aggregated for accounting, securitization, or investor reporting purposes. The package exposes a web/UI-oriented API layer used by the ETRM HTML-based (JTT / Rosetta) screens to add and remove individual instruments from a pool.

Key Procedures and Functions

  • ROSETTA_TABLE_COPY_IN_P74 — A utility procedure that copies an inbound JTF_VARCHAR2_TABLE_2000 PL/SQL table into the package's typed structure okl_poolconc_pvt.error_message_type. The "_p74" suffix reflects the generated Rosetta/JTT binding used to marshal multi-row data between the middle-tier Java layer and PL/SQL. It is used to transport error messages or returned tables into the API.
  • ROSETTA_TABLE_COPY_OUT_P74 — The inverse of the copy-in routine. It copies the error_message_type structure out to a JTF_VARCHAR2_TABLE_2000 for return to the calling UI layer, allowing the web tier to display validation or processing messages back to the user.
  • ADD_POOL_CONTENTS_UI — The primary UI entry point for adding content to a pool. It accepts the standard EBS API parameter set (p_api_version, p_init_msg_list, x_return_status, x_msg_count, x_msg_data) plus a request identifier (x_request_id) and the pool/stream identifiers (p_sty_id1, p_sty_id2) and stream subclass and multi-org context. The remaining p6_a0 through p6_a32 parameters are generated attribute slots bound to the JTT screen fields, following the Rosetta generator convention. The procedure validates and inserts the selected pool contents.
  • CLEANUP_POOL_CONTENTS_UI — The counterpart routine that removes or clears contents previously associated with a pool. This is the procedure the user searched for and is the complement to the add routine.

Tables Accessed

The documented metadata lists a single referenced table, PLITBLM, accessed via an APPS synonym. PLITBLM is an EBS table used to hold temporary or interface data for lease/pool processing, and it is likely read or written during the add/cleanup pool content operations to stage rows before committing them to the underlying pool tables.

Usage Notes

The "_W" suffix and the Rosetta copy-in/copy-out helpers indicate this package is invoked from the ETRM HTML UI (JTT/Rosetta screens), not from a concurrent program directly. The _UI procedures are typically called through the EBS framework when a user adds or removes pool content on a lease pool form. The package is not referenced by any other documented package, so it sits at the top of the call stack as a UI-facing API. When troubleshooting issues with pool content cleanup, the CLEANUP_POOL_CONTENTS_UI procedure is the relevant entry point to trace.