Search Results oa_html

Overview

The APPS.POS_ASL_MASTER_PKG package body is a server-side PL/SQL component of the Oracle iProcurement / Purchasing module (POS product family) in Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal responsibility is the generation of the HTML frameset that frames the Approved Supplier List (ASL) maintenance and search user interface. Rather than performing business transactions itself, the package acts as a presentation controller: it initializes the web session, resolves session and security context values through the ICX security API, opens the HTML document, attaches the appropriate stylesheets and JavaScript libraries, and then emits the nested frameset markup that arranges the toolbar, banner, search, results, and lower-banner regions of the page.

In the context of the search term oa_html, this package is directly relevant because it emits references to the Oracle Applications HTML web directory — for example the POSSTYLE.css stylesheet and the JavaScript files POSCUTIL.js, POSWUTIL.js, POSEVENT.js, and posaslet.js — all of which are served from the /OA_HTML/ virtual path. This makes the package a typical example of the older HTML-generation style of Oracle EBS self-service pages (using htp and owa_util rather than the later OAF/HTMLDB frameworks).

Key Procedures and Functions

• SHOWFRAMESET — The single documented procedure in this package. It accepts a responsibility identifier (p_respID) as input, though the exact signature should be confirmed in the source. The procedure calls POS_INIT_SESSION_PKG.InitSession to establish the web session, retrieves the current session ID, org ID, language code, web user ID, and script name via the icx_sec package, and then builds the response. It emits the opening HTML and head tags, sets the page title from the FND message POS_ASL_ATTRIBUTES, links the ASL stylesheet, includes the standard and ASL-specific JavaScript libraries from /OA_HTML/, and finally writes the nested frameset that defines the visible page layout. The procedure is essentially a rendering routine and contains no documented business logic or database persistence operations.

Tables Accessed

The ETRM metadata records references to the HTP and OWA_UTIL packages (exposed via APPS synonyms). These are Oracle-supplied PL/SQL utility packages rather than application tables: HTP is used to write HTML tags to the HTTP output buffer, and OWA_UTIL is used to retrieve CGI environment variables such as SCRIPT_NAME. The package also references icx_sec for session and security values, fnd_message for translated message text, pos_global_vars_sv for JavaScript global variable initialization, and icx_util for the copyright footer. No application data tables are read or written by the documented procedure; the package's role is confined to page framing and session bootstrap.

Usage Notes

SHOWFRAMESET is typically invoked as the entry point for the ASL search and maintenance web page — that is, when a user navigates to the ASL attributes function from an iProcurement or Purchasing responsibility. The browser request is routed through the Oracle Applications framework to the PL/SQL gateway, which calls this procedure to produce the outer frameset; the individual frames then invoke separate procedures and JavaScript handlers. Because the procedure is designed for the self-service HTML flow, it depends on a valid ICX session being established and on the /OA_HTML/ resources being available from the application tier. It is not a general-purpose API and is not referenced by any other documented packages (reference count: 0), so customizations should treat it as an internal presentation helper rather than an integration point.