Results for “etrm_static”

40 results




Overview
Explore in AI Chat

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

Overview

APPS.ETRM_STATIC is a static-definition PL/SQL package belonging to the Oracle E-Business Suite Technical Reference (ETRM) subsystem. It is classified as an "OTHER" API, meaning it is not a business-facing or general-purpose public API but rather a supporting construct used internally by the ETRM reporting and documentation generation framework. The package does not perform transactional business logic. Instead, it centralizes the constant text, URLs, and HTML fragments that the ETRM tooling uses to render the Oracle eBusiness Suite Technical Reference reports and their associated pages.

In Oracle EBS 12.1.1 and 12.2.2, the ETRM module produces the Technical Reference documentation delivered to customers, which describes database objects, tables, views, and cross-application dependencies. ETRM_STATIC supplies the boilerplate content — navigation index URL, base URL, legal and copyright blocks, help text, home-page markup, and the explanatory text for the product dependency report — so that the generation logic in other ETRM packages can remain free of hard-coded strings.

Key Procedures and Functions

  • INDEX_URL — Returns the URL of the static ETRM index page used for navigation within the generated technical reference.
  • BASE_URL — Returns the base URL from which the static ETRM documentation resources are served.
  • LEGAL_TEXT — Returns the copyright and license legal text, including release-specific strings (for Release 11i and Release 12) and the Oracle copyright/restricted-use notice.
  • HELP_TEXT — Returns the help text displayed to the user in the ETRM documentation interface.
  • ETRM_HOME1 — Returns the first of the ETRM home-page HTML fragments used to render the ETRM landing page.
  • ETRM_HOME2 — Returns the second ETRM home-page HTML fragment, used in conjunction with ETRM_HOME1 to complete the landing page.
  • PRODUCT_DEPENDENCY_TEXT — Returns the descriptive HTML paragraph explaining the product dependency report, clarifying that it lists cross-application view and table dependencies while excluding file system objects and database objects not present in the Applications FND model.

These functions are getters returning static VARCHAR2 or VARCHAR content. No parameter lists are documented, and none should be assumed.

Tables Accessed

The package references the APPS synonym FND_PRODUCT_GROUPS. In the EBS data model, FND_PRODUCT_GROUPS identifies the installed Oracle E-Business Suite product groups and their release information. This access allows the ETRM generation logic to determine whether the output applies to Release 11i or Release 12, thereby selecting the appropriate legal text block supplied by LEGAL_TEXT. No other tables or views are documented as referenced through APPS synonyms, consistent with the package's role as a static content container rather than a data-processing unit.

Usage Notes

ETRM_STATIC is invoked internally by the ETRM framework during the generation and rendering of the Oracle EBS Technical Reference and related reports. It is not intended for direct invocation from application forms, concurrent program parameters, or custom business code. Three other ETRM packages reference it, relying on its functions to obtain the boilerplate URLs, legal notices, help text, home-page markup, and dependency-report explanation.

Because the package encapsulates environment-specific values such as the static and base URLs (shown in the source metadata as test host URLs), any change to the documentation hosting location is localized to this package. In 12.1.1 and 12.2.2 the same interface is preserved, with the Release 11i and Release 12 legal text variants coexisting to support the differing releases. Customizations should not modify this package; it is an Oracle-maintained ETRM component and is overwritten by patching.