Search Results full_char




Overview
Explore in AI Chat

Overview

PAY_GB_EOY_MAGTAPE is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an "OTHER" API within the ETRM repository. As its name implies, the package supports the United Kingdom legislative requirement for End-of-Year (EOY) magnetic media reporting, historically known as the Magnetic Media or "Magtape" submission process to HM Revenue & Customs (HMRC). The package encapsulates control logic, validation routines, and payroll version interrogation used during the generation of statutory year-end returns for GB payrolls.

The package header alone exposes the public interface; the body contains the implementation that coordinates with Oracle Payroll and Oracle HR foundation tables. It is referenced by sixteen other packages, indicating it forms part of a broader dependency chain within the GB payroll legislative solution rather than being an isolated utility.

Key Procedures and Functions

  • EOY_CONTROL — A procedure that acts as the primary driver for end-of-year processing within this package. It orchestrates the control flow of the magnetic media generation, typically invoked as the entry point from a concurrent program or another payroll process.
  • VALIDATE_INPUT — A function that validates a supplied input value, with an optional validation mode parameter defaulting to 'FULL_CHAR'. This supports character-level and format checking of data prior to submission, ensuring that only well-formed values are passed downstream.
  • VALIDATE_TAX_CODE — A function that validates a GB tax code against an effective date and an assignment identifier. This is the routine most closely associated with the user search term "validate_tax_code". It returns a VARCHAR2 result, permitting the caller to receive a descriptive outcome rather than a simple boolean.
  • VALIDATE_TAX_CODE_YRFIL — A related function that validates a tax code in the context of a specific assignment action and, as the "yrfil" suffix suggests, in relation to year-end filing (YRF) data. It performs a similar check to VALIDATE_TAX_CODE but keyed on the assignment action rather than the assignment plus effective date.
  • GET_PAYROLL_VERSION — A function returning a VARCHAR2 value that supplies the payroll version string, used to identify the applicable legislative or product version driving the EOY submission.

Tables Accessed

The package references a set of tables via APPS synonyms that span payroll processing, HR assignment data, and Oracle Applications file registration. The payroll core tables include PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, and PAY_ALL_PAYROLLS_F, which hold payroll run and assignment action context needed to determine which assignments and payroll actions are in scope for year-end processing. PER_ALL_ASSIGNMENTS_F provides the assignment records against which tax codes are validated.

Oracle HR tables include HR_ORGANIZATION_INFORMATION and HR_SOFT_CODING_KEYFLEX, supporting organisation-level and costing context. Fast Formula infrastructure is represented by FF_FORMULAS_F, FF_FORMULA_TYPES, FF_GLOBALS_F, FF_USER_ENTITIES, and FF_ARCHIVE_ITEMS. File and version control for the transmitted magnetic media uses AD_FILES and AD_FILE_VERSIONS. FND_CONCURRENT_REQUESTS supplies concurrent request context, and DUAL is used for singleton queries.

Usage Notes

PAY_GB_EOY_MAGTAPE is typically invoked indirectly through the GB end-of-year concurrent programs rather than being called directly by end users. Its validation functions, particularly VALIDATE_TAX_CODE and VALIDATE_TAX_CODE_YRFIL, may be called from custom code or from other payroll packages that must confirm tax code correctness before submission. Because the package forms part of the legislative dependency chain referenced by sixteen other packages, modifications should be assessed carefully for regression impact. All invocations occur within Oracle Payroll, and callers should pass a valid assignment or assignment action identifier and effective date to obtain meaningful validation results.