Search Results ff_functions_bk1

Overview

APPS.FF_FUNCTIONS_BK1 is a generated PL/SQL package body belonging to the Oracle FastFormula infrastructure within Oracle E-Business Suite. It is part of the API hook pre-processor architecture that Oracle HRMS employs to wrap and stage calls to the underlying business-layer APIs for the FF_FUNCTIONS entity, which stores the definition of FastFormula functions (name, class, datatype, alias, definition text, and related attributes). The package body is a companion artifact: the _BK1 suffix identifies it as the first-stage "hook" or backward-compatibility stub generated by the Oracle HRMS API Hook Pre-processor, as confirmed by the source header comment "Code generated by the Oracle HRMS API Hook Pre-processor." It holds no business logic of its own; instead, it exists to declare and expose entry points that other layers (typically the FF_FUNCTIONS_API package and its related hook packages) invoke during the create lifecycle of a FastFormula function.

The header records a generation timestamp of 2012/11/27 and an RCS identifier of ffffnapi.pkb 120.0, consistent with the 12.1.1 and 12.2.2 codeline release level supplied by Oracle Support. The package is classified as OTHER rather than as a public customer API, meaning it is not intended for direct external invocation.

Key Procedures and Functions

The package body documents two procedures:

• CREATE_FUNCTION_A — The primary create entry point. It accepts the full attribute set for a FastFormula function, including effective date, name, class, business group, legislation code, alias name, data type, definition, description, function identifier, and object version number. The presence of the function identifier and object version number parameters indicates it supports the standard HRMS row-versioning and surrogate-key conventions.
• CREATE_FUNCTION_B — A sibling create entry point with the same core attribute set, but without the function identifier and object version number. This variant corresponds to the generation pattern in which one procedure supplies explicit key/version values while the other relies on the framework to derive or default them.

Both procedures contain only paired hr_utility.set_location trace calls marking entry and exit. No SQL or assignment logic is present in the body, which is characteristic of pre-processor-generated hook stubs: the real work is delegated onward through the surrounding API package chain, and the stubs preserve the call signature and traceability required by the HRMS API framework.

Tables Accessed

The documented metadata lists no tables referenced through APPS synonyms for this package body. This is consistent with its role as a signature-only hook layer: all persistence against the FastFormula function repository (the FF_FUNCTIONS base table and its associated descriptive and translation tables) is performed by the downstream API implementation that these stubs front. Any table activity attributed to the create-function operation occurs outside FF_FUNCTIONS_BK1 itself.

Usage Notes

FF_FUNCTIONS_BK1 is not a customer-facing API and should not be called directly from custom code. It is referenced by one other package within the ETRM inventory, reflecting the normal hook chaining in which an outer API or a higher-numbered hook package invokes these procedures as part of the FastFormula function creation flow. Typical invocation paths are the FastFormula maintenance forms and the HRMS API layer that supports formula function setup and migration.

Because the procedures are generated and contain no logic, they are overwritten by the API Hook Pre-processor whenever patches or upgrades regenerate the FastFormula API set. Customizations must therefore never be applied inside this package; supported extension points lie in the underlying FF_FUNCTIONS_API layer and its documented hooks. During 12.1.1 to 12.2.2 upgrades, the package is recompiled and regenerated as part of the HRMS/FF product patch cycle, and it carries no editioning or online-patching concerns beyond those of the standard APPS schema object set.