Results for “pos_asl_master_pkg”

22 results




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

Overview

POS_ASL_MASTER_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite and is classified in the ETRM repository with an API classification of OTHER. The package is defined with AUTHID CURRENT_USER, meaning its unqualified database object references are resolved using the privileges of the invoking user rather than the package owner, a common convention for utility packages that must respect the caller's schema context.

Functionally, the package belongs to the Oracle Purchasing family of server-side modules. Its name associates it with Approved Supplier List (ASL) master data, and the single documented entry point, ShowFrameSet, indicates that the package is a presentation-layer helper used to render a frame set for the ASL maintenance user interface. It is therefore not a business-data API that creates or updates ASL records; rather, it is a supporting component of the HTML-based (Oracle Web Applications Dictionary, or OWA) UI infrastructure used in earlier EBS releases.

The header comment in the source references a 2001 revision, which confirms that this object originated in the pre-11i/11i era of the E-Business Suite and has been carried forward through 12.1.1 and 12.2.2 without significant functional change. The package body is not separately documented in the ETRM extract, and the specification exposes only one procedure.

Key Procedures and Functions

  • ShowFrameSet — The sole documented procedure in the package. Its parameter is a responsibility identifier (p_respID), supplied as a VARCHAR2. The procedure is responsible for emitting the HTML frame-set markup that composes the ASL maintenance page layout for the supplied responsibility. Consistent with the documented dependencies, the procedure relies on HTP and OWA_UTIL to generate and escape the markup rather than returning a value to the caller. No parameter list beyond the responsibility identifier should be assumed; the ETRM metadata documents no additional arguments, defaults, or return values.

Because ShowFrameSet is the only exposed subprogram, the package offers no general-purpose CRUD operations, validation routines, or concurrency-handling logic. Any behavior beyond rendering the frame set is internal to the (undocumented) package body and should not be treated as a supported interface.

Tables Accessed

The ETRM metadata records no application tables referenced by this package. The only documented dependencies are the PL/SQL toolkit packages HTP and OWA_UTIL, resolved through APPS synonyms. HTP provides the procedures that write HTML tags to the mod_plsql output buffer, and OWA_UTIL supplies utilities such as URL escaping and redirect handling. Consequently, the package performs no direct queries or DML against ASL tables such as PO_APPROVED_SUPPLIER_LIST or PO_ASL_ATTRIBUTES; any responsibility or site context needed to build the page is passed in as the p_respID argument or derived from the caller's session environment rather than read from the database within this package.

Usage Notes

POS_ASL_MASTER_PKG is invoked from the Oracle Purchasing ASL maintenance flow in the HTML (Self-Service/Web) user interface, where the frame set defines the navigational structure of the page presented to the buyer or supplier administrator. It is not intended for direct invocation from Forms-based responsibilities, concurrent programs, or custom integration code. No other package in the documented set references it, so its callers are UI entry points rather than inter-package dependencies.

Because the package is compiled AUTHID CURRENT_USER and is restricted to presentation markup, customizations should not extend or call it as an integration point. Oracle's documented convention is that such UI helpers are internal and may change without notice between releases. Developers requiring ASL data manipulation should instead use the supported ASL business APIs and the underlying PO_ASL_% tables, treating POS_ASL_MASTER_PKG strictly as an internal page-rendering artifact of the EBS 12.1.1 and 12.2.2 Purchasing module.