Search Results validate_update

Overview

PAY_GB_PAYROLL_RULES is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that encapsulates the legislative payroll validation rules specific to the United Kingdom localization of Oracle Payroll. Its principal business function is to enforce statutory and configuration integrity on the PAY_ALL_PAYROLLS_F payroll definition before payroll processing activity is permitted. The package is classified as OTHER in the ETRM repository, indicating that it is a supporting validation utility rather than a fully published public API. It is invoked primarily as a datetracked validation hook during insert, update, and delete operations against UK payroll records, ensuring that payroll definitions cannot be modified in a manner that would violate UK legislative or referential constraints.

Key Procedures and Functions

The package exposes two documented procedures, both oriented around date-effective (datetrack) validation of payroll definitions.

• VALIDATE_UPDATE — Confirms that a proposed update to a UK payroll definition is permissible. It receives the effective date, the datetrack mode, the payroll identifier and name, and a soft coding keyflex identifier, and returns an error when the change would breach UK payroll rules or leave the payroll in an invalid configuration.
• VALIDATE_DELETE — Confirms that a payroll definition may be deleted or end-dated at the supplied effective date under the specified datetrack mode, raising an error when dependent payroll data or statutory conditions prohibit removal.

No public functions are documented in the ETRM metadata; the package specification contains only these two procedures.

Tables Accessed

The package operates across a focused set of payroll and HR tables, referenced through APPS synonyms:

• PAY_ALL_PAYROLLS_F — the payroll definition itself, which is the subject of the update and delete validations.
• PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS — payroll and assignment level processing actions used to determine whether payroll activity exists that would block a definition change or deletion.
• PER_ALL_ASSIGNMENTS_F and PER_ASSIGNMENT_STATUS_TYPES — assignment and status information used to identify employees currently attached to the payroll.
• PER_TIME_PERIODS — payroll period definitions used to establish effective-date context for UK payroll calendars.
• HR_SOFT_CODING_KEYFLEX — validates the soft coding keyflex identifier supplied to VALIDATE_UPDATE.

Usage Notes

PAY_GB_PAYROLL_RULES is a localization-layer package and is not intended for direct invocation by end users. It is normally called from the payroll definition maintenance forms and from the datetracked validation infrastructure of Oracle Payroll whenever a UK payroll record is created, altered, or removed. The two documented procedures correspond to the standard datetrack validation contract, so custom code that performs DML against PAY_ALL_PAYROLLS_F for a UK business group should call VALIDATE_UPDATE and VALIDATE_DELETE at the appropriate points to preserve legislative compliance. The ETRM metadata records that the package is referenced by two other packages, confirming its role as a shared validation dependency. Because the header identifies the file as restricted (noship) and proprietary, the package should be treated as internal Oracle code; extensions should wrap rather than modify it, and any custom calls must respect the datetrack mode and effective-date semantics defined by the payroll localization.