Search Results oa_media




Overview
Explore in AI Chat

Overview

POS_CONTROL_REGION_SV is a server-side PL/SQL package in the APPS schema that generates the HTML control-region banner used by Oracle EBS Self-Service Web Applications (notably the Oracle iProcurement and Oracle Purchasing web UI family). Its single documented entry point, PAINTCONTROLREGION, emits the navigational bar that carries the Cancel, Back, Next, Submit, and road-map controls rendered above and below a self-service web page. The package belongs to the ETRM API classification OTHER, meaning it is an internal rendering utility rather than a published integration API. It is written entirely against the PL/SQL Web Toolkit (the HTP package) and has no dependency on application database tables.

The source header ($Header: POSCTRLB.pls 115.0 99/08/20 11:09:18 porting sh $) shows the object was first ported in 1999 from a client/server or early web code line, and it has been retained unchanged through the 12.1.1 and 12.2.2 releases for backward compatibility with the procured self-service flows that still reference it.

Key Procedures and Functions

ETRM documents one public procedure for this package body:

  • PAINTCONTROLREGION — The public entry point. It opens the control-region markup, invokes the private painting routines in sequence, and closes the region. Its parameter list is not published in ETRM.

The package body additionally declares a set of private procedures that implement the rendering. These are not part of the documented interface but explain the observable behavior:

  • InitializeRegion — Opens the outer tables and writes the top separator strip.
  • CloseRegion — Emits the closing table tags for the region opened by InitializeRegion.
  • PaintButtons and PaintButtonTops — Build the button container and its top edge, applying position-dependent layout.
  • PaintCancelButton, PaintBackButton, PaintNextButton, PaintSubmitbutton — Render the individual navigation controls.
  • PaintRoadMap — Renders the multi-step progress indicator.
  • PaintButtonBottoms — Closes the button table structure.

Tables Accessed

ETRM records a single referenced object, listed via APPS synonyms: HTP. HTP is the Oracle PL/SQL Web Toolkit package used to write HTML into the mod_plsql response buffer; it is not a data table. The package therefore performs no DML and reads no application or transactional data. Every visible element — separators, button borders, road-map graphics — is emitted as literal markup through htp.p calls. No database tables are queried or modified.

Usage Notes

POS_CONTROL_REGION_SV is invoked from PL/SQL server-side web pages, typically the procedure-based pages served through mod_plsql (Apache PL/SQL gateway) in the self-service applications. A page calls PAINTCONTROLREGION to place the standard navigation banner around its content, complementing the header and footer emitted by the corresponding POS_CONTROL_* rendering packages. It is not called from Oracle Forms, concurrent programs, or Java-based OAF pages.

Because the procedure emits static HTML referencing hard-coded image paths, its output depends on the OA_MEDIA virtual directory being configured and on the standard EBS icons being present. In 12.2.x, mod_plsql-based self-service pages were progressively superseded by Oracle Application Framework pages, so this package is encountered mainly during maintenance of legacy iProcurement and Purchasing web procedures. Custom code should not depend on this package as an API; it is an internal presentation utility with no documented parameter contract and no external referents.