Search Results pay_shadow_formula_rules_s

Overview

The APPS.PAY_SFR_INS package body is a component of the Oracle E-Business Suite Payroll (PAY) module, responsible for managing shadow formula rules within the Oracle Payroll formula infrastructure. In Oracle EBS 12.1.1 and 12.2.2, shadow formula rules form the backbone of the rules-based processing engine that payroll administrators configure to control how elements, balances, and calculations are evaluated for employee assignments. The PAY_SFR_INS package provides the insertion logic that writes new shadow formula rule definitions into the underlying payroll data model.

The object is documented as VALID and classified as OTHER under the APPS schema. It serves as a lower-level data access and validation package, sitting beneath the higher-level business logic implemented in PAY_SFR_BUS. Its primary role is to persist shadow formula rule records and their associated definition rows, ensuring referential integrity and consistency with the shadow formula rules metadata.

Key Procedures and Functions

The ETRM documentation records one procedure within this package body:

• INS — The insertion routine. This procedure creates new shadow formula rule records within the payroll data structures. It encapsulates the write operations required to add a shadow formula rule definition, binding the rule to its associated formula and access context. It is the entry point through which the business-layer package PAY_SFR_BUS delegates persistence, keeping database write logic centralized and isolated.

Because the documented metadata does not expose parameter signatures, parameter lists are intentionally omitted. The procedure functions as the canonical insert handler for shadow formula rules, and callers should not assume behavior beyond the documented insertion responsibility.

Tables Accessed

The package references two tables, accessed through APPS synonyms:

• PAY_SHADOW_FORMULA_RULES — The primary table storing shadow formula rule definitions. The INS procedure writes new rows here, capturing the rule identity, its associated formula, and the criteria that determine when the rule applies during payroll run processing.
• PAY_SHADOW_FORMULA_RULES_S — The shadow (translation) table that stores language-specific or descriptive text associated with each rule definition in PAY_SHADOW_FORMULA_RULES. Writes to the base table are typically accompanied by corresponding inserts into this table to maintain the mapping between a rule and its display text.

These two tables are tightly coupled; consistent data requires that each insert into PAY_SHADOW_FORMULA_RULES be matched by an insert into PAY_SHADOW_FORMULA_RULES_S for each supported language, which is why both appear within the same package body.

Usage Notes

PAY_SFR_INS is not intended for direct invocation by end users. It is called programmatically by the business-layer package PAY_SFR_BUS, which in turn is exposed through the Oracle Payroll setup forms and concurrent processes that administrators use to define and maintain shadow formula rules. The dependency chain documented in the ETRM metadata—PAY_SFR_BUS referencing PAY_SFR_INS, with supporting calls into PAY_SFR_SHD, HR_API, and HR_UTILITY—confirms this layered design.

The package is documented as referenced by four other packages, reflecting its shared utility role. Customizations and extensions should invoke PAY_SFR_BUS or the supported public APIs rather than calling PAY_SFR_INS directly, since the package is considered internal implementation detail and is not referenced by any database object outside the Payroll schema. Direct writes to the underlying tables bypass the validation and derivation logic embedded in this package and risk producing inconsistent shadow formula rule data.