Search Results iby_disburse_ui_api_pub_pkg_w




Overview
Explore in AI Chat

Overview

The APPS.IBY_DISBURSE_UI_API_PUB_PKG_W package body is the wrapper variant of the Oracle Payments disbursement user interface public API. It resides in the APPS schema and is classified under the IBY (Oracle Payments) product family. Its principal business purpose is to expose the disbursement UI application programming interface to calling components — most notably Oracle E-Business Suite Forms, which operate in a client-server context and cannot call a server-side PL/SQL package directly without a wrapper layer. The "_W" suffix convention in Oracle EBS denotes that the package is intended as a callable interface shim that bridges the Forms runtime environment and the underlying business logic implemented in IBY_DISBURSE_UI_API_PUB_PKG.

The package is recorded with a status of VALID in the ETRM repository and falls under the API classification of OTHER, indicating it is a supporting infrastructure package rather than a formal, externally documented public API. It is not referenced by any other database object, which confirms its role as a terminal entry point invoked from the presentation layer rather than from other PL/SQL units.

Key Procedures and Functions

The package body exposes thirty-three documented procedures. These divide into two functional groups. The first and larger group consists of paired conversion routines used for transferring tabular data between the Forms client and the database server:

The term "Rosetta" reflects the translation role these routines perform between the two runtime environments. The numbered suffixes (P0 through P8) correspond to distinct table parameters or distinct call scenarios, each handling a separate data collection.

The second group comprises two business-action procedures:

  • REMOVE_DOCUMENTS_PAYABLE — removes documents payable records within the context of a disbursement UI operation.
  • REMOVE_PAYMENTS — removes payment records as part of the same disbursement workflow.

Both removal procedures serve the UI-level cancellation or rollback of payment and document-payable selections. Parameter lists are not documented in the ETRM metadata and are not inferred here.

Tables Accessed

The only table documented as referenced through APPS synonyms is PLITBLM. This is a standard Oracle EBS PL/SQL interoperability table used to pass large collections of data between the Forms client and the database server. The package reads and writes PLITBLM as the transport buffer underpinning the Rosetta copy-in and copy-out procedures, allowing bulk data such as selected documents payable and payment identifiers to cross the client-server boundary within the constraints of the Forms environment. The actual disbursement and payment records manipulated by REMOVE_DOCUMENTS_PAYABLE and REMOVE_PAYMENTS are handled through the underlying IBY_DISBURSE_UI_API_PUB_PKG package, on which this wrapper depends.

Usage Notes

IBY_DISBURSE_UI_API_PUB_PKG_W is invoked from Oracle Payments Forms-based user interfaces, principally those supporting payment processing and disbursement review. Because Forms cannot directly invoke server-side PL/SQL packages that use modern collection types, this wrapper converts Forms record groups into JTF_NUMBER_TABLE and JTF_VARCHAR2_TABLE_100 collections — both of which appear in the dependency list — before delegating to IBY_DISBURSE_UI_API_PUB_PKG. Customizations should target the underlying public API package rather than this wrapper, since the wrapper exists solely for Forms interoperability and is not referenced by any other database object. It is not intended for use by concurrent programs, which can call the underlying package directly.