Search Results pay_shadow_formulas_s

Overview

PAY_SF_INS is a PL/SQL package body owned by the APPS schema that supports the Oracle EBS Payroll "Shadow Formula" (SF) infrastructure. The "SF" naming convention corresponds to the Shadow Formula feature, which provides a parallel, optimized evaluation engine for payroll formulas used during payroll run processing. The package resides in the PAY_SF_* family of objects — including PAY_SF_BUS (business logic), PAY_SF_SHD (shadow layer), and PAY_SF_INS itself — and is classified in the ETRM as API classification "OTHER," indicating it is an internal utility rather than a public, customer-facing API. Its status is VALID in the documented 12.1.1 / 12.2.2 environments. The package's principal responsibility is the insertion of shadow-formula data records that the shadow engine consumes during payroll processing. Because it references HR_API and HR_UTILITY, it participates in the broader HR/Payroll object ecosystem and observes standard HR API conventions such as consistent error handling and business-group context.

Key Procedures and Functions

ETRM documents two procedures or functions on this package, the primary one being INS. Consistent with its name, INS performs insert operations against the shadow-formula tables, creating the rows required by the shadow evaluation layer. It is the documented entry point through which callers populate shadow-formula data. The second documented entity is not separately named in the excerpt beyond the package itself. No parameter signatures are published in the ETRM metadata, so parameter lists are intentionally not reproduced here; developers requiring exact signatures should inspect the package specification in the target instance. By design, INS encapsulates validation and insert logic so that calling packages — notably PAY_SF_BUS and PAY_SF_SHD — need not embed direct DML against the shadow tables.

Tables Accessed

The package references two documented tables through APPS synonyms: PAY_SHADOW_FORMULAS and PAY_SHADOW_FORMULAS_S. PAY_SHADOW_FORMULAS holds shadow-formula definitions, and the "_S" suffixed table is the corresponding translated or descriptive companion table, following the standard EBS "_S" convention for seeded or translatable entities. The INS procedure writes rows into these structures as part of the shadow-formula setup and refresh cycle. Additional dependencies include APPS.HR_API and APPS.HR_UTILITY for shared HR utility calls, APPS.PAY_SF_BUS and APPS.PAY_SF_SHD for package-to-package orchestration, and the SYS objects DUAL and STANDARD for basic SQL constructs.

Usage Notes

PAY_SF_INS is not referenced by any database object according to the ETRM dependency listing; however, the documented metadata states it is referenced by four other packages, and it is itself invoked from within the PAY_SF_* package family. It is therefore an internal, implementation-level package rather than a supported public API. Typical invocation occurs through the shadow-formula business logic during payroll formula setup, concurrent processing of payroll runs, or when the shadow engine refreshes its cached formula definitions. Developers performing customizations, diagnostics, or upgrades of the shadow-formula mechanism may examine or call this package in a development instance, but direct production invocation outside the supported payroll code paths is not recommended. Because it relies on HR_API conventions, callers should ensure the appropriate HR business group and session context are initialized before execution.