Search Results g_date_format

Overview

AST_OFL_TERR_MISS_ACC_PARAM is an Oracle Applications (APPS) PL/SQL package body that belongs to the Oracle Sales and TeleSales (AST) schema family, specifically the Oracle Field Sales / Territory Management module commonly referenced under the "OFL" (Oracle Field Library) namespace. Its core business purpose is to generate the HTML-based parameter entry form for a diagnostic report titled "Territories - No Accesses Report." This report identifies sales territories that have no associated resource accesses defined, a common data-integrity check performed by sales administrators during territory setup and maintenance.

The package is not a business logic engine; rather it is a server-side HTML generation utility that leverages the PL/SQL Web Toolkit (the HTP and HTF packages) to render the user interface that collects report submission criteria. In EBS 12.1.1 and 12.2.2 the package is registered as an "OTHER" classification API within the ETRM repository, meaning it is a supporting/plumbing package rather than a public business API. The header comment references a version and date of 115.6 (2002), indicating this is legacy code that has remained stable across many EBS releases.

Key Procedures and Functions

• TERR_MISS_ACC_PARAM — The main entry point that renders the parameter form used to collect submission criteria for the "Territories - No Accesses Report." It orchestrates the output of the HTML page, invoking the header and footer routines to frame the parameter selection controls presented to the user.
• HEADER — Generates the descriptive header of the parameter form. As shown in the source, it opens the HTML document, emits the page title "Territories - No Accesses Report," applies a background color and font styling, and displays the current system date. It also prints the instruction text prompting the user to specify criteria and select OK.
• FOOTER — Closes the HTML page structure generated by the package, completing the well-formed HTML output required by the PL/SQL Web Toolkit. It is the counterpart to HEADER and ensures the browser renders the form correctly.

As these routines are internal to the package body, their exact parameter signatures are not part of the documented public contract and are deliberately omitted here.

Tables Accessed

The package references a small set of objects, primarily through APPS synonyms and the PL/SQL Web Toolkit rather than business data tables:

• DUAL — Used in the HEADER procedure to obtain the current date via a SELECT from SYSDATE, formatted using the G_DATE_FORMAT constant ('MM/DD/YY').
• HTP — The PL/SQL Web Toolkit HTML generation package, used to emit HTML tags such as htmlopen, headOpen, bodyopen, tableOpen, and tableData.
• HTF — The HTML forms/tag helper package, used for formatting functions such as bold.
• OWA_UTIL — The Oracle Web Agent utility package, typically used for URL redirection or parameter retrieval within the generated page.

No business tables relating to territories or accesses are queried by this package; the actual report data collection is handled by the report or concurrent program that this parameter form feeds into.

Usage Notes

AST_OFL_TERR_MISS_ACC_PARAM is invoked as a server-side HTML generator, most likely registered as a function- or procedure-based concurrent program parameter page or a Self-Service web page accessed through the standard EBS login session. Because the package neither reads nor writes sales data and is not referenced by any other package (0 dependents per ETRM), it functions as a leaf-level UI helper. It is typically called immediately before the "Territories - No Accesses Report" is executed, presenting the criteria form so the user can filter results before submission. Administrators invoking the report from the Territory Management responsibility rely on this page to set selection parameters. Customizations should be avoided, as the package participates in the standard HTML rendering chain and any modification could break the parameter collection page in EBS 12.1.1 or 12.2.2.