Search Results get_formula_segment_value

Overview

HXC_FF_DICT is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that provides the formula dictionary infrastructure for Oracle Time and Labor (OTL). Its primary business function is to bridge Oracle FastFormula definitions and the Time and Labor rules engine, allowing administrators to define time entry, approval, and calculation logic using a formula language that is evaluated at runtime against timecard data. In the context of the user's search for hxc_time_entry_rules_utils_pkg, HXC_FF_DICT is a closely coupled companion: it appears in the dependency list of HXC_TIME_ENTRY_RULES_UTILS_PKG and is itself referenced by that package, indicating that formula lookup, segment decoding, and formula execution logic are shared between the two.

Key Procedures and Functions

The documented package exposes four procedures and functions:

• FORMULA — The core routine that resolves and returns the active FastFormula associated with a time entry rule or related configuration record. It abstracts the lookup of the compiled formula so that calling code does not need to query the FastFormula tables directly.
• DECODE_FORMULA_SEGMENTS — Parses and interprets the segment structure embedded in a formula definition or time entry rule, translating stored token or segment identifiers into meaningful values for evaluation and display.
• EXECUTE_APPROVAL_FORMULA — Invokes an approval-related formula so that its result determines whether a timecard, time entry rule, or approval action should proceed. This supports configurable, formula-driven approval routing in Time and Labor.
• GET_FORMULA_SEGMENT_VALUE — Returns the value of an individual formula segment, enabling callers to retrieve specific pieces of formula output or configuration without executing the full formula.

All four routines are classified as OTHER (not a public API) and should be treated as internal implementation logic. Parameter lists are intentionally not documented here.

Tables Accessed

The package reads and/or writes the following tables through APPS synonyms:

• FF_FORMULAS_F and FF_EXEC — FastFormula definition and execution infrastructure used to compile and run formulas.
• HXC_TIME_ENTRY_RULES — The rule definitions whose associated formulas are resolved and executed.
• HXC_RECURRING_PERIODS and HXC_TIME_CATEGORIES — Supporting Time and Labor configuration that provides context for formula evaluation.
• PAY_ACCRUAL_PLANS — Accrual plan data used when formulas reference accrual balances.
• FND_DESCR_FLEX_COLUMN_USAGES — Descriptive flexfield column usage metadata, relevant to segment decoding.
• PLITBLM — A standard Oracle PL/SQL index-by table type used internally for in-memory collections.

Additionally, HXC_SELF_SERVICE_TIME_DEPOSIT appears among the objects referenced by HXC_FF_DICT, indicating interaction with self-service timecard deposit processing.

Usage Notes

HXC_FF_DICT is typically invoked indirectly rather than called directly by end users. It is referenced by HXC_APPROVAL_WF_PKG, which drives Time and Labor approval workflow, and by HXC_TIME_ENTRY_RULES_UTILS_PKG, the utility package the user searched for. When a timecard is submitted or approved, the rules utilities call into HXC_FF_DICT to resolve the applicable formula and evaluate approval or rule conditions. It is also self-referential, meaning internal routines call other procedures within the same package. Because it is classified as OTHER and is not a certified public API, customizations should avoid calling it directly; instead, extend behavior through supported FastFormula definitions and the documented Time and Labor setup. This package is valid and present in both EBS 12.1.1 and 12.2.2.