Search Results get_version

Overview

APPS.PAY_GB_ROLLBACK_PKG is a United Kingdom localizations package within the Oracle E-Business Suite Payroll (PAY) module. Its documented purpose is to support rollback processing for UK payroll runs, including functionality tied to Real Time Information (RTI) submissions and the End of Year (EOY/EAS) reporting cycle. The package history indicates an initial creation in September 2012 and subsequent revisions through early 2013 that added rollback behavior for the EAS process, orphaned data cleanup in the FPS details table, and corrections to RTI sent flags across PAYE aggregation assignments.

Rollback in this context refers to the reversal of payroll processing state: resetting flags and identifiers that indicate data has already been reported or submitted, so that a payroll action or assignment can be reprocessed cleanly. The package is classified as a UK-specific utility rather than a general-purpose payroll API.

Key Procedures and Functions

The ETRM metadata documents a single packaged program, GB_ROLLBACK, which serves as the primary rollback routine for the package. Because the metadata records only one documented unit, the additional functions visible in the source excerpt are treated as internal helpers.

The most relevant internal helper is get_version, whose purpose is to retrieve the object version number and the assignment extra information identifier for a given assignment and information type, returning the version number to the caller and returning the extra information ID through an OUT parameter. A companion helper, get_report_type, derives a report type from a payroll action identifier. Both are declared as private functions within the package body and are not part of the published interface.

No parameter lists are reproduced here, as the documented interface for GB_ROLLBACK is not itemized in the available metadata.

Tables Accessed

The package references the following tables through APPS synonyms, each serving a distinct role in rollback processing:

• PER_ASSIGNMENT_EXTRA_INFO — stores assignment-level extra information used to hold RTI and reporting state; queried by get_version for object version and extra information identifiers.
• PAY_GB_FPS_DETAILS — the UK Full Payment Submission detail table; rollback logic deletes orphaned rows here, particularly for National Insurance only aggregation cases.
• PAY_PAYROLL_ACTIONS — the payroll action definition driving report type resolution.
• PAY_ASSIGNMENT_ACTIONS — action-level assignment state that must be reversed.
• PAY_ACTION_INFORMATION — action information records that hold reporting flags and identifiers.
• PER_ALL_ASSIGNMENTS_F — the effective-dated assignment entity providing assignment context.
• HR_SOFT_CODING_KEYFLEX — key flexfield soft coding referenced during reversal processing.
• DUAL — used for singleton selection and unconditional evaluations.

Usage Notes

PAY_GB_ROLLBACK_PKG is invoked internally by UK payroll processing flows rather than being directly exposed to end users. The metadata records no other packages referencing it, which indicates it is called from within the PAY schema's own localization logic or from concurrent program and form execution paths associated with RTI and EOY rollback.

Typical invocation occurs when a UK payroll run, FPS submission, or EAS submission must be reversed. The package resets RTI sent indicators, removes orphaned FPS detail rows, and re-establishes record versioning so that downstream resubmission produces accurate RTI output. Because the shipped header indicates the package was built at the 12.0.12020000 file level with compatibility annotations, it is applicable to both 12.1.1 and 12.2.2 environments carrying the UK payroll localization.

Customizations should not call GB_ROLLBACK directly. Instead, rollback should be initiated through the supported payroll reversal or purge concurrent programs, letting the UK localization layer manage state through this package and its helpers.