Search Results load_hac_row

Overview

The APPS.HXC_HAC_UPLOAD_PKG package body is an Oracle E-Business Suite technical component resident in the Applications (APPS) schema and classified as an OTHER API within ETRM 12.2.2. Its business function is to upload and persist Homepage Approval Configuration (HAC) data used by Oracle Time and Labor and the related self-service approval workflow infrastructure. Specifically, the package materialises rows into the approval component model, resolving human-readable names supplied on an upload interface into the internal surrogate identifiers required by the underlying base tables. The package header comment identifies the source file as hxchacupl.pkb, version 115.7, last modified 2002/06/10, placing the implementation within the mature OTL approval configuration layer that remains in use across EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented public interface exposes a single procedure, as recorded in the ETRM metadata:

• LOAD_HAC_ROW — the entry point for uploading a single Homepage Approval Configuration row. It accepts a set of descriptive attributes covering the approval style name, time recipient, approval order, approval mechanism and mechanism name, workflow item type and workflow name, the effective start and end dates, the owner, and a custom mode indicator. The procedure resolves the approval style name to an approval_style_id, delegates time recipient resolution to hxc_ret_upload_pkg.get_time_recipient_id, and — when the approval mechanism begins with the token FORMULA — resolves the associated mechanism name to a mechanism identifier via an internal private function, GET_FORMULA_ID. It then proceeds to select the corresponding approval_comp_id from HXC_APPROVAL_COMPS and complete the row load.

The metadata records one documented procedure in total, with GET_FORMULA_ID and GET_APPROVAL_STYLE_ID operating as private helpers encapsulated within the package body rather than as part of the published API surface. GET_FORMULA_ID returns the surrogate key for a given formula name, and is the object most relevant to the user search term "get_formula_id".

Tables Accessed

The package reads and writes the following tables, referenced through APPS synonyms:

• FF_FORMULAS_F — the Oracle FastFormula definition table. It is queried by GET_FORMULA_ID to translate a formula name into its formula_id, which populates the approval mechanism identifier when a FORMULA-based approval mechanism is configured.
• HXC_APPROVAL_STYLES — the approval style definition table. It supplies the approval_style_id and the object_version_number used for optimistic locking during the load.
• HXC_APPROVAL_COMPS — the approval component table, which holds the assembled approval configuration rows. The procedure selects existing approval_comp_id values and inserts or updates component records keyed by approval style, time recipient, and mechanism.
• HXC_TIME_RECIPIENTS — the time recipient definition table, used to validate and resolve the recipient supplied on upload.

Usage Notes

HXC_HAC_UPLOAD_PKG is an internal configuration utility rather than an end-user-facing API. It is typically invoked by administrator-driven upload flows — concurrent programs, Oracle Forms-based configuration screens, or controlled custom code written by implementers migrating approval setups between environments. Because the package performs direct DML against the OTL approval configuration tables and depends on hxc_ret_upload_pkg, callers should invoke it within a transaction that can be rolled back on failure and should honour the object version number check on HXC_APPROVAL_STYLES. The package is referenced by zero other packages per the ETRM metadata, confirming it is an upstream entry point rather than a shared subroutine. The private GET_FORMULA_ID helper cannot be called directly from outside the package body; external code requiring formula identifier resolution must use supported FastFormula APIs instead.