Search Results get_arc_bal_value

Overview

PAY_IE_P45_ARCHIVE is an Oracle E-Business Suite payroll package owned by the APPS schema and classified under the "OTHER" API category. It supports the Irish (IE) statutory P45 processing requirement, which governs the documentation issued to an employee when employment ends. In the Republic of Ireland, an employer must produce a P45 that summarises the employee's pay, tax, PRSI and universal social charge figures for the current tax year and carries forward cumulative details to any subsequent employer. This package provides the archival and reporting machinery that allows Oracle Payroll to assemble, store and reproduce those P45 records.

The package operates as a set of entry points invoked by the P45 archive concurrent process rather than as a general-purpose business API. Its responsibilities include initialisation of the archive run, selection of the assignments to be processed, creation of the payroll actions that hold the P45 data, extraction of balance values, decoding of lookup meanings for display, and generation of the final XML output. The current header revision, pyiep45.pkh 120.2.12010000.1, dates from 2008 and reflects the stabilised 11i/12.1 lineage that carries forward into 12.2.2.

Key Procedures and Functions

• ARCHINIT — Initialises the archive process for a given payroll action, establishing the context in which subsequent archiving steps execute.
• RANGE_CURSOR — Builds the driving SQL cursor that determines which assignments fall within the scope of the payroll action being archived.
• ACTION_CREATION — Creates the assignment actions for the selected range of people, binding each person to the P45 archive action so that balances can be captured against them.
• ARCHIVE_CODE — Performs the core archival work, writing the P45 data for an assignment action at the supplied effective date.
• ARCHIVE_DEINIT — Added under reference 4468864 in July 2005, this procedure de-initialises the archive, releasing context and performing the clean-up that pairs with ARCHINIT at the end of the run.
• GET_LOOKUP_MEANING — Resolves a lookup code within a lookup type to its display meaning, used to render coded P45 values in human-readable form.
• GET_ARC_BAL_VALUE — Returns the archived value of a named balance for an assignment action. Its signature was revised under reference 5005788 in February 2006 to accept the payroll action identifier as well, improving performance.
• GENERATE_XML — Produces the XML rendering of the archived P45, returning standard concurrent program error buffer and return code outputs. It accepts a P45 archive process identifier and an assignment identifier.

Tables Accessed

The package reads and writes payroll processing tables through APPS synonyms. PAY_ASSIGNMENT_ACTIONS and its _S variant hold the per-assignment action rows that carry P45 results; PAY_ACTION_INFORMATION and PAY_ACTION_CONTEXTS store the parameter and context values for those actions; PAY_ACTION_INTERLOCKS coordinates concurrent processing of the action. PAY_ALL_PAYROLLS_F identifies the payroll being processed. Balance retrieval relies on PAY_DEFINED_BALANCES, PAY_BALANCE_TYPES and PAY_BALANCE_DIMENSIONS. Organisational and legislative attributes come from HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, HR_LOCATIONS_ALL and HR_SOFT_CODING_KEYFLEX. FF_CONTEXTS supplies flexfield context data, and FND_LOOKUP_VALUES backs the lookup meaning lookups.

Usage Notes

PAY_IE_P45_ARCHIVE is normally invoked indirectly through the Irish P45 archive concurrent program rather than being called from forms. The standard sequence is ARCHINIT, RANGE_CURSOR, ACTION_CREATION, ARCHIVE_CODE and ARCHIVE_DEINIT, with GENERATE_XML producing the deliverable output. Because the package is classified as OTHER and not as a supported public API, custom code should avoid direct calls; integrations requiring P45 data should consume the generated XML or the archived action rows instead. The package is referenced by five other packages, confirming that some internal reuse exists within the Irish payroll modules. When troubleshooting a P45 archive run in 12.1.1 or 12.2.2, the concurrent request log and the PAY_ACTION_INFORMATION rows for the action provide the primary diagnostic trail.