Search Results delete_ie_paye_details

Overview

APPS.PAY_IE_PAYE_API is an Oracle E-Business Suite Application Programming Interface (API) package that encapsulates the Irish PAYE (Pay As You Earn) statutory reporting functionality for payroll. It provides a controlled, validated entry point for creating, maintaining, and removing PAYE-related details held against employee assignments within the Irish legislative context. The package isolates the business rules that govern how PAYE data is written to and read from the underlying payroll tables, ensuring that tax-related information originating from documents such as the P45, P46, and P60 is captured consistently and in a form that downstream payroll processing and statutory reporting can consume.

The package body (source header pyipdapi.pkb, version 120.4) is owned by APPS and is classified as an API in the ETRM metadata for release 12.2.2, with equivalent availability in 12.1.1. Its design reflects the standard EBS API pattern: callers pass an effective date and assignment context, and the package resolves the appropriate element type, input values, and element entries internally, shielding external code from the physical data model. The private helper procedure create_p46 visible in the package body illustrates this pattern, resolving the IE P45P3_P46 Information element type and its associated input values before writing payroll data. Two other packages reference this API, indicating that it is invoked as part of a broader Irish payroll or legislative reporting flow.

Key Procedures and Functions

• CREATE_IE_PAYE_DETAILS — Creates a new Irish PAYE detail record. This is the procedure most commonly identified by the search term "create_ie_paye_details." It establishes the PAYE information for a given assignment, driving the creation of the corresponding element entries and run result values that hold the statutory tax data.
• UPDATE_IE_PAYE_DETAILS — Modifies an existing Irish PAYE detail record. It supports correction and maintenance of PAYE values already captured for an assignment, preserving the effective-dated history of the underlying payroll entities.
• DELETE_IE_PAYE_DETAILS — Removes an Irish PAYE detail record, reversing the element entries and related data created by the create operation.

No public parameter signatures are documented in the ETRM metadata; callers should therefore validate the exact argument list against the installed package specification in their environment before invoking these procedures directly.

Tables Accessed

The package reads and writes a defined set of payroll tables, referenced through APPS synonyms:

• PAY_IE_PAYE_DETAILS_F — The primary Irish PAYE detail entity, holding the statutory PAYE attributes maintained by this API.
• PAY_ELEMENT_TYPES_F and PAY_INPUT_VALUES_F — Resolved to locate the IE P45P3_P46 Information element type and its input values for the effective date.
• PAY_ELEMENT_LINKS_F and PAY_ELEMENT_ENTRIES_F — Used to validate element eligibility and to create or remove the element entries that carry the PAYE data onto the assignment.
• PAY_RUN_RESULTS and PAY_RUN_RESULT_VALUES — Store the calculated input values produced during payroll processing.
• PAY_ASSIGNMENT_ACTIONS, PAY_PAYROLL_ACTIONS, and PER_ALL_ASSIGNMENTS_F — Provide the assignment, action, and payroll context required to place the entries correctly and maintain date-tracked integrity.

Usage Notes

PAY_IE_PAYE_API is typically invoked from the Irish payroll legislative forms and from concurrent processes that manage PAYE reporting, and it is referenced by two other packages within the application. Custom or extension code should call these procedures rather than inserting directly into the underlying tables, because the API enforces effective-date handling, element eligibility, and validation of the Irish legislation context. Because the object is an API, Oracle supports its documented entry points across 12.1.1 and 12.2.2, but not the internal procedures or the physical table structures. Direct database manipulation bypasses the business rules and can corrupt PAYE history.