Search Results pay_siv_upd




Overview
Explore in AI Chat

Overview

PAY_SIV_UPD is a PL/SQL package owned by the APPS schema that supports maintenance of Oracle Payroll's shadow input values infrastructure. Shadow input values are the mechanism by which Oracle HRMS and Payroll store processed or derived values associated with a payroll run, assignment, or element entry outside of the standard input value tables. The package name reflects its role: "SIV" denotes Shadow Input Value, and "UPD" denotes the update operation performed on those records. In Oracle EBS 12.1.1 and 12.2.2, PAY_SIV_UPD is classified as an OTHER API in ETRM, indicating it is a procedural utility rather than a formally versioned public interface such as an HR_API business process API. Its status is VALID, confirming it is a supported, compiled object within the APPS schema.

Key Procedures and Functions

ETRM documents two procedures or functions in this package, with the primary documented identifier being UPD. The UPD procedure performs the core update operation against shadow input value data. Its exact parameter list is not published in the documented metadata, and consumers should not assume a public signature; the procedure is intended to be invoked internally or by tightly coupled payroll packages rather than by third-party custom code. The second documented procedure is a companion routine in the same package body whose role, consistent with the package's single-purpose design, is to support the update workflow. Because the metadata does not enumerate named parameters, integrators should treat UPD as an implementation-level routine and reference the package body for exact calling conventions prior to any extension.

Tables Accessed

The documented table reference for this package is PAY_SHADOW_INPUT_VALUES, accessed through an APPS synonym. This table stores the shadow input values generated and maintained during payroll processing, and PAY_SIV_UPD writes to and reads from it as part of the update operation. No other base tables are documented in the ETRM dependency extract. The package also depends on HR_API and PAY_SIV_SHD, indicating that it works in conjunction with the shared shadow value handling routines in PAY_SIV_SHD and, where applicable, HR_API validation or utility logic. The presence of PAY_SIV_SHD as a dependency suggests a deliberate separation between shadow input value maintenance (this package) and shadow value retrieval or display logic (PAY_SIV_SHD).

Usage Notes

PAY_SIV_UPD is invoked by three documented dependent packages: PQP_GB_STAKEHOLDER_TEMPLATE, PQP_UK_UNION_TEMPLATE, and PQP_UK_VEHICLE_TEMPLATE. These are Oracle Payroll statutory template packages for the United Kingdom, covering stakeholder pensions, union deductions, and vehicle-related processing respectively. This dependency pattern confirms that PAY_SIV_UPD is called from within country-specific payroll template logic to write shadow input values generated during legislative calculations. It is not typically invoked directly from Oracle Forms or from a standalone concurrent program. Custom code should avoid calling this package directly; instead, extensions should use the supported payroll business process APIs in HR_API, which will in turn manage shadow input values appropriately. Direct modification of shadow input values risks inconsistency with payroll run results and is not a supported integration pattern.