Search Results p_type

Overview

PAY_GB_EDI_ROLLBACK is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite (Release 12.1.1 and 12.2.2) that controls the rollback process for United Kingdom statutory and electronic data interchange (EDI) reporting outputs. Its documented purpose is to manage rollback logic for the following UK legislative returns: P45, P45(3), P46, P46 Car, P46PENNOT, WNU (Works Number Update), and P11D. These forms are submitted to HM Revenue & Customs (HMRC) and are tightly regulated, so the ability to reliably reverse a submission or restore prior state is a critical compliance requirement.

The package header comment (header revision 120.2.12010000.2, dated 11-Aug-2008) records its origin: created 15-JUN-2006 by K.Thampan as version 115.0, with subsequent fixes through version 115.3. Notably, version 115.3 (bug 7208046) added logic to handle EDI rollback for the P46 EDI process version 5. The package is classified as OTHER in the ETRM repository, indicating it is not a public, supported API surface but an internal utility.

Key Procedures and Functions

The ETRM metadata documents a single entry point, EDI_ROLLBACK. Because the package is intended to reverse previously generated UK EDI/statutory outputs, EDI_ROLLBACK is the procedural anchor that orchestrates the rollback for the supported report types (P45, P46, P46 Car, P46PENNOT, WNU, P11D). The exact parameter list is not reproduced in the documentation and is therefore not asserted here.

Within the package body, an internal helper function get_version is defined. It accepts an assignment identifier, a p_type value (the information type), and an out parameter for the assignment extra info identifier. It queries PER_ASSIGNMENT_EXTRA_INFO to retrieve the object version number and assignment_extra_info_id for the matching assignment and information type. The p_type parameter is central: it distinguishes which statutory report type is being processed, driving the correct rollback path. A companion private procedure, restored, accepts p_type and a p_pactid parameter and handles the post-rollback restoration of state, including assignment-level context introduced for bug 7208046.

Tables Accessed

Three tables are referenced through APPS synonyms:

• PER_ASSIGNMENT_EXTRA_INFO — Stores extra information attached to assignments. get_version reads object_version_number and assignment_extra_info_id here using p_type as the information_type filter. This supports optimistic locking and precise identification of the record to roll back.
• PAY_ASSIGNMENT_ACTIONS — Records actions applied to assignments. The package uses it to identify and reverse payroll actions associated with the EDI submission.
• PAY_ACTION_INFORMATION — Holds information linked to payroll actions, used to trace the generated output and restore or remove related data during rollback.

Usage Notes

PAY_GB_EDI_ROLLBACK is not a published API (classification: OTHER) and is referenced by zero other packages per the ETRM metadata. It is therefore invoked indirectly, typically from the Oracle HRMS UK statutory reporting forms or their underlying concurrent programs when a user requests rollback of a P45, P46, WNU, or P11D submission. Custom code should not call it directly unless the supporting forms interface and data state are fully understood, as the package relies on object version numbers and assignment action history to maintain data integrity. Because the rollback touches assignment extra information and payroll action records, any invocation should occur within a controlled, transactional context, and the p_type value passed must match the information type used when the original EDI record was created.