Search Results deinit_code

Overview

PAY_SG_IRAS_ARCHIVE_SETUP is a Singaporean payroll localization package that supports the IRAS (Inland Revenue Authority of Singapore) income tax archival process. Specifically, it defines the assignment-set selection logic and archive routines used when an organization produces the annual employee income tax return data, commonly known as the IR8A/IR21 submission, for a given legal entity and basis year. In the context of Oracle EBS 12.1.1 and 12.2.2, this package body belongs to the APPS schema and is classified under the ETRM "OTHER" API category, indicating it is a supporting localization utility rather than a public, supported API surface.

The package operates within the standard Oracle Payroll action and assignment-action framework. It provides the query and filter logic that determines which persons and assignments must be processed, whether an assignment action should be created for archival, and whether the archive/magtape file should be generated. It contains no independent means of execution; it is invoked as part of a larger payroll archival flow.

Key Procedures and Functions

• RANGE_CODE — Defines the SQL statement that returns the distinct person identifiers to be processed by the archive process. As documented in the source excerpt, it builds a query joining PER_PEOPLE_F and PAY_PAYROLL_ACTIONS on the business group and payroll action, ordered by person ID. Oracle Payroll guidance notes that this select should carry minimal restrictions, allowing the driving process to enumerate the relevant population.
• ASSIGNMENT_ACTION_CODE — Restricts and performs creation of Assignment Actions. The cursor selects assignments that have had payroll processing for the legal entity within the basis year, and applies eligibility filters. A person must not have the "IR21 Run Date" set, since that indicates the form was already issued and the person should not appear in the archive/magtape. A person must also not already have a magtape file produced for the same business group, legal entity, and basis year. Where re-archiving is required, the operator must first roll back the magtape or use the standard retry/rollback payroll process.
• ARCHIVE_CODE — Produces the archive/magtape output for the selected population, writing the income tax data file required for IRAS submission.
• DEINIT_CODE — Performs end-of-process cleanup and deinitialization once the archive action completes.

Tables Accessed

The package references, via APPS synonyms: PAY_PAYROLL_ACTIONS for the driving payroll action and business group context; PAY_ASSIGNMENT_ACTIONS and PAY_ASSIGNMENT_ACTIONS_S for creating and querying assignment action records; PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F for person and assignment details; and PER_PEOPLE_EXTRA_INFO to evaluate the "IR21 Run Date" attribute. PAY_ACTION_INFORMATION and its _S variant store action-level parameter and status information, while DUAL and the PL/SQL table type PLITBLM support internal query construction and processing mechanics.

Usage Notes

PAY_SG_IRAS_ARCHIVE_SETUP is not invoked directly by end users through a form or standalone concurrent program; it is called by the Singapore IRAS archive concurrent process during the annual tax reporting cycle. It is also documented as referenced by zero other packages, confirming it sits at the edge of the localization call graph. Customizations should avoid modifying this package body, because its logic is tied to the statutory exclusion rules for IR21-form recipients and previously archived records. Developers extending the IRAS archive flow should treat RANGE_CODE and ASSIGNMENT_ACTION_CODE as the points where population filtering occurs, and should respect the rollback requirement before attempting to re-archive any person.