Results for “c_from_date”

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

Overview

GHR_462 is an APPS-owned PL/SQL package in the Oracle E-Business Suite that supports regulatory complaint and equal employment opportunity (EEO) reporting. The package is defined with AUTHID CURRENT_USER, meaning execution privileges are resolved against the invoking schema rather than the defining schema. Its central entry point, populate_sum, accepts a concurrent request identifier, an agency code, a fiscal year, a from-date and to-date range, and returns an output file name. This signature indicates that GHR_462 is designed to run as a concurrent program that gathers complaint data across a specified reporting period and produces a structured output file, most likely XML.

The internal type declarations confirm this purpose. The record types XMLRec and collection type tXMLTable describe name/value pairs intended for XML serialization, while P4Matrix and t_P4Matrix model a Part 4 data matrix covering claims, bases, base values, and field names. The package therefore serves as the reporting engine for a multi-part complaint summary, producing output consumed by downstream reporting, archiving, or submission processes.

Key Procedures and Functions

The documented interface exposes thirteen procedures. POPULATE_SUM is the master driver that orchestrates the report, populating each report part in sequence and returning the generated output file name. POPULATE_PART1 populates the pre-complaint phase section, while POPULATE_PART2 handles the formal complaint phase. POPULATE_PART4 populates the bases and issues section, and POPULATEPART4MATRIX builds the corresponding matrix of claims, bases, and base values used within that section.

Closure analyses are handled by POPULATE_PART5 (closures by statute), POPULATE_PART6 (closures by category), and POPULATE_PART7 (complaints closed with corrective action). POPULATE_PART8 summarizes pending complaints. The remaining procedures, POPULATE_PART10 and POPULATE_PART11, extend the report with additional summary sections. Output generation is delegated to WRITETOXML and WRITEXMLVALUES, which serialize the collected data using the tXMLTable structure.

Tables Accessed

The package reads and writes complaint data through several GHR tables referenced via APPS synonyms. GHR_COMPLAINTS2 is the primary complaint repository; GHR_COMPL_CLAIMS, GHR_COMPL_BASES, and the related tables GHR_COMPL_APPEALS and GHR_COMPL_AGENCY_APPEALS supply claim, basis, and appeal details. Corrective action data is sourced from GHR_COMPL_CA_HEADERS and GHR_COMPL_CA_DETAILS, while GHR_COMPL_ADRS provides address information. UTL_FILE is used to write the generated output file, and V$PARAMETER is queried to determine database or environment settings such as the output directory. PLITBLM supports internal PL/SQL table handling.

Usage Notes

GHR_462 is typically invoked through a concurrent program, consistent with the p_request_id and p_output_fname parameters of populate_sum. The ETRM metadata records no packages referencing GHR_462, so it is not a shared utility API; it stands at the top of its call stack. Users submit it with an agency code, fiscal year, and date range to generate the complaint summary file, which is consumed by regulatory reporting or archival processes. Direct invocation from forms or custom code is possible but is not the intended use; the package should be called in the concurrent manager context so that request logging and file output behave as designed.