Search Results ff_functions_bk2

Overview

APPS.FF_FUNCTIONS_BK2 is a generated PL/SQL package body belonging to the Oracle E-Business Suite (EBS) HRMS/FastFormula infrastructure. It is part of the Oracle Function management APIs used by the Oracle FastFormula engine, which supports user-defined formulas in modules such as Payroll, Benefits, Compensation, and Human Resources. The "_BK2" suffix indicates this is a private, generated stub package created by the Oracle HRMS API Hook Pre-processor, as denoted in the header comment ("Code generated by the Oracle HRMS API Hook Pre-processor").

The package's role is to provide "before" processing stubs invoked from the standard FF_FUNCTIONS API flow. In Oracle HRMS, business APIs typically support pre-process and post-process hooks (A and B variants) that allow Oracle or customers to insert custom validation or enrichment logic without modifying the core API. This package contains the "B" hook stubs for the UPDATE_FUNCTION operation. In EBS 12.1.1 and 12.2.2, this object is compiled into the APPS schema and relies on the ff_functions base table, though no table access is documented in this stub.

Key Procedures and Functions

The package exposes two documented procedures, both of which are essentially empty hook implementations:

• UPDATE_FUNCTION_A — The "A" variant hook for updating an Oracle FastFormula function definition (columns such as name, class, alias, data type, definition, and description). It accepts an effective date, function identifier, object version number, and changeable attributes. The body solely sets entry and exit trace locations via hr_utility.set_location and performs no business logic.
• UPDATE_FUNCTION_B — The "B" variant hook for the same update operation, sharing an identical signature and behavior. It also only records trace locations at entry and exit.

Because both procedures are stubs, their function is to provide a safe, named extension point that the HRMS API flow can call without affecting standard processing. Any custom logic a customer or Oracle patch requires can be placed in these hooks.

Tables Accessed

No tables are referenced directly by the documented procedures in this package. The actual Data Manipulation Language (DML) against the FastFormula functions entity (ff_functions) is performed by the primary API package, FF_FUNCTIONS_API (or its associated API package), not by this hook stub. The parameters supplied to these hooks (function ID, object version number, name, class, alias, data type, definition, description, effective date) correspond to the attributes of the fast formula function record that the parent API writes.

Usage Notes

FF_FUNCTIONS_BK2 is not intended to be invoked directly by end users, forms, concurrent programs, or external code. It is called internally by the FF_FUNCTIONS API after Oracle's pre-processor generated the hook package. Customers and partners who need to extend the standard update-function behavior (for example, to enforce additional validation or to synchronize data to another repository) may modify the procedure bodies to include their custom logic, preserving the original signature so the calling API continues to operate. Because the package is generated and listed as proprietary/confidential by Oracle, customizations should be applied through supported extension mechanisms and re-applied after patching, as Oracle may regenerate the stub during EBS upgrade or patching in 12.1.1 or 12.2.2. The current implementation is trace-only and carries no functional risk by itself.