Search Results pay_formula_result_rules_s




Overview
Explore in AI Chat

Overview

PAY_FORMULA_RESULTS is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. It forms part of the Oracle Payroll formula processing infrastructure, whose purpose is to evaluate payroll formulas and persist their outcomes as formula results that downstream payroll processes can consume. The package operates against the formula result data model, which records the computed output of a formula evaluation together with the rules that govern how those results are assigned to result rules and processing statuses.

The package is classified by ETRM as an OTHER API, indicating that it is an internal component rather than a public, externally supported interface. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2, and it is referenced by thirteen other packages within the application, confirming that it sits within a dependency chain relied upon by the wider payroll engine rather than being an isolated utility.

Key Procedures and Functions

ETRM documents two procedures or functions within this package body:

  • INS_STAT_PROC_RULE — Inserts a status processing rule record. Given the naming convention, this procedure writes a row into the status processing rules data structure, establishing the linkage between a formula result and the status processing rule that governs how that result is handled during payroll processing.
  • INS_FORM_RES_RULE — Inserts a formula result rule record. This procedure creates the association between a formula result and the result rules that determine where and how the computed result value is written or applied.

Both procedures are insert-oriented, consistent with the package's role as a mechanism for seeding or maintaining the rule linkages required for formula result processing. Parameter lists are not exposed in the ETRM metadata and are deliberately not reproduced here.

Tables Accessed

The package body resolves the following tables through APPS synonyms:

  • PAY_FORMULA_RESULT_RULES_F / PAY_FORMULA_RESULT_RULES_S — the base table and its translation (TL) counterpart for formula result rules; these store the rules that map formula results to their destinations.
  • PAY_INPUT_VALUES_F — the base table holding formula input values, consulted to validate or resolve inputs associated with the results being processed.
  • PAY_STATUS_PROCESSING_RULES_F / PAY_STATUS_PROCESSING_RULES_S — the base table and translation table for status processing rules; these define the processing status transitions applied to payroll results. The user's search term, pay_status_processing_rules_s, corresponds to the translation table in this pair.

The presence of both _F and _S variants indicates that the package writes or reads translated rule definitions, ensuring that rule descriptions are available in the session language.

Usage Notes

PAY_FORMULA_RESULTS is not referenced by any database object according to the ETRM documentation, meaning it is not invoked from within the database by triggers, views, or other PL/SQL units tracked in the dependency graph. Instead, it is presumed to be called by the thirteen dependent packages that reference it, and ultimately driven by Oracle Payroll forms and concurrent programs during formula result setup and maintenance. Typical invocation points include the formula result rules and status processing rules setup forms, where a user defines how a formula's output should be classified and processed, and batch payroll processing runs that materialize those rules.

Because the package is classified as OTHER and is an internal component, customizations should avoid calling it directly. Developers extending payroll formula result behavior should use supported public APIs or extend the underlying rule tables rather than invoking INS_STAT_PROC_RULE or INS_FORM_RES_RULE outside their intended context, as the package carries no documented public contract.