Search Results pqp_riw_enroll_wrapper




Overview
Explore in AI Chat

Overview

PQP_RIW_ENROLL_WRAPPER is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. Its name encodes its role: it wraps enrollment processing logic for the RIW (Retirement, Insurance, and Wellness, in the Oracle Advanced Benefits / OAB context of the PQP product family) functionality and couples that logic to delegate-booking maintenance. In practice the package acts as a controlled integration point between the benefits enrollment engine and Oracle Time and Labor delegate booking records. The package body holds the implementation while a companion package specification exposes the callable entry points to forms, concurrent programs, or other PL/SQL code. It is classified as OTHER under the ETRM API classification, meaning it is not a public, supported business API in the sense of an Oracle-published interface; it is an internal wrapper used by the application. Its status is VALID, confirming the compiled body is present and resolvable against its declared dependencies in both 12.1.1 and 12.2.2.

Key Procedures and Functions

  • INSUPD_ENROLL — The principal enrollment handler, performing insert-or-update enrollment processing. The name convention (INSUPD) indicates the routine detects whether an enrollment record already exists and routes to an insert or an update accordingly, driving the wrapper's central business transaction.
  • CREATE_DELEGATE_BOOKING — Creates a delegate booking record, coordinating with the OTA delegate booking APIs so an enrollment event is reflected as a booking entry for a delegate.
  • UPDATE_DELEGATE_BOOKING — Maintains an existing delegate booking when enrollment data changes, keeping the booking aligned with the current enrollment state.

No parameter lists are documented for these units; their exact signatures are not asserted here.

Tables Accessed

  • OTA_DELEGATE_BOOKINGS — the primary delegate booking store, read and written by the create/update booking routines, and manipulated through the OTA_DELEGATE_BOOKING_API and OTA_TDB_INS dependencies.
  • PER_PERSON_TYPES — used to resolve person type classification, gating which enrollments or bookings are applicable.
  • BNE_INTERFACE_COLS_B — the base interface-columns table, referenced when the wrapper interacts with concurrent/interface processing metadata.
  • Additional person and assignment context is obtained via PER_PEOPLE_F and PER_ASSIGNMENTS_F, the effective-dated person and assignment views, invoked rather than directly written.

Usage Notes

The package shell is reached indirectly. It references HR_API, HR_MULTI_MESSAGE, HR_UTILITY, OTA_DELEGATE_BOOKINGS, OTA_DELEGATE_BOOKING_API, OTA_TDB_INS, PER_ASSIGNMENTS_F, PER_PEOPLE_F, PER_PERSON_TYPES, and STANDARD, indicating it relies on HR error/message handling and Time and Labor delegate APIs. It is not referenced by any other database object, so no package calls into it; it must be invoked from an Oracle Forms benefits page, an OAB enrollment concurrent process, or custom code. For 12.1.1 and 12.2.2 the object remains VALID and should be treated as internal, unsupported-for-direct-call code: callers should not bypass it, and customizations should favor the supported enrollment APIs.