Search Results name_resolve

Overview

OWAPUB.OWA_UTIL is the public synonym for the Oracle-supplied PL/SQL package body OWA_UTIL, owned by SYS and classified within the ETRM repository as a utility API. Its purpose is to provide the foundational HTML-generation and Web Toolkit helper routines used by the Oracle Web Agent (OWA) framework and by Oracle Application Framework components throughout Oracle E-Business Suite 12.1.1 and 12.2.2. The package is not an EBS business application API; rather, it is a low-level infrastructure package that EBS forms, JSP pages, mod_plsql handlers, and custom PL/SQL callers rely upon when producing HTTP responses, resolving objects within the database dictionary, and emitting formatted HTML output such as tables and CGI environment diagnostics.

The metadata identifies 55 documented procedures and functions grouped under the UTIL classification, and shows that the package is referenced by eight other packages, confirming its role as a shared dependency in the EBS technology stack.

Key Procedures and Functions

The most relevant function from the user's search term is NAME_RESOLVE, which resolves an object name into its owning schema and object identifier by interrogating the data dictionary — a prerequisite for building dynamic SQL and for validating object references at runtime. Because the source excerpt confirms that helper functions such as is_table and is_view use DBMS_SQL together with sys.dbms_sys_sql.parse_as_user against ALL_TABLES, NAME_RESOLVE follows the same dictionary-query pattern to translate unqualified names into qualified owner/name pairs.

Additional documented procedures include:

• SHOWSOURCE and SIGNATURE — display the PL/SQL source and identifying signature of a stored object.
• SHOWPAGE, GET_CGI_ENV, PRINT_CGI_ENV — render diagnostic HTML pages and expose/print CGI environment variables.
• MIME_HEADER, REDIRECT_URL, STATUS_LINE, HTTP_HEADER_CLOSE, GET_OWA_SERVICE_PATH — construct HTTP response headers, redirects, status lines, and resolve the service path used by mod_plsql.
• SHOW_QUERY_COLUMNS, TABLEPRINT, TABLEOPEN, TABLECAPTION, TABLEHEADERROWOPEN, TABLEHEADER, TABLEHEADERROWCLOSE, TABLEROWOPEN — assemble HTML tables from a cursor via a progressive open/row/close sequence.
• COMMA_TO_IDENT_ARR — parse a comma-delimited identifier string into a PL/SQL associative array.

Tables Accessed

The ETRM metadata does not list any tables referenced through APPS synonyms, and the source excerpt shows that the package queries ALL_TABLES directly for object existence checks. NAME_RESOLVE and related dictionary helpers similarly read static data dictionary views such as ALL_OBJECTS and ALL_SYNONYMS to translate and validate names. No application tables belonging to EBS products are read or written.

Usage Notes

OWA_UTIL is normally invoked implicitly by the mod_plsql/OWA runtime and by OAF pages rather than being called directly from EBS Forms or concurrent programs. Custom PL/SQL that must emit HTML, resolve an object name against the dictionary, or build dynamic table output will call these routines directly. Because it is a SYS-owned, publicly synonymed package, custom code should reference it as OWA_UTIL and rely on the installed EBS patch level rather than attempting to recompile the body.