Results for “g_t”

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

Overview

FF_WRAPPER_PKG is a low-level Oracle EBS wrapper package that supports the FastFormula execution engine. FastFormula is the flexible expression and calculation language used throughout Oracle Applications — by Payroll, Benefits, Compensation, Advanced Pricing, OTL, and many other modules — to let customers express business rules without modifying source code. When a formula is compiled, Oracle generates a dedicated PL/SQL package whose name is stored in the formula definition. FF_WRAPPER_PKG provides a uniform, stable calling interface that the runtime engine uses to invoke that generated package, insulating callers from the exact signature of each formula-specific package.

The header carries an identifying comment of $Header: ffwrppkg.pkh 115.1 2003/11/26 ...$, indicating the specification dates back to the 11.5 code line and remains unchanged in 12.1.1 and 12.2.2. The package is declared AUTHID CURRENT_USER, so it executes with the privileges of the invoking session under the APPS schema rather than as a definer-rights unit. It is owned by APPS and classified as OTHER in the ETRM repository.

Key Procedures and Functions

• FORMULA — The single documented program unit. It accepts the formula name, the name of the generated formula package, and the five standard FastFormula data arrays (dates, numbers, text, and numeric identifiers), plus the error code, error line, and error message outputs. Its purpose is to dispatch control to the generated p_ff_package_name and return the resulting database items, inputs, and any compilation or runtime error diagnostics back to the engine. The P_FFERC* parameters carry back the FastFormula error code, error line number, and error text respectively. Detailed parameter semantics beyond those documented are not defined here.

Tables Accessed

The ETRM metadata records no tables referenced through APPS synonyms for this package. This is consistent with its role: FF_WRAPPER_PKG is a pure dispatcher. It does not read or write formula definitions, database items, or globals directly through SQL. Persistence of formula definitions and compilations is handled by other FastFormula objects (for example, FF_FORMULAS_F and related packages). The wrapper only forwards the in-memory arrays supplied by the caller.

Usage Notes

The package is invoked internally by the FastFormula runtime whenever a formula must be executed, and it is referenced by two other packages as noted in the ETRM inventory. Typical callers are the payroll, benefits, and general FastFormula execution routines, as well as forms and concurrent programs that trigger formula-based calculations such as payroll runs, benefit eligibility, and rate determination. The globally declared collections — g_d, g_n, g_t, g_i — and globals such as g_ffercd, g_fferln, and g_ffermt exist to hold formula data when the wrapper package has not yet been generated or when a formula is executed before its generated package is available. The g_t global is the text-array holder commonly examined when diagnosing FastFormula execution problems; it holds the intermediate text values passed into or returned from the formula call. Because the interface is essentially fixed and version-stable, EBS rarely exposes it in released documentation, but it is fundamental to how FastFormula bridges its generated code and the calling application modules.