Search Results pqp_riw_offering_wrapper




Overview
Explore in AI Chat

Overview

APPS.PQP_RIW_OFFERING_WRAPPER is a PL/SQL package residing in the APPS schema that acts as a wrapper layer over the offering-related tables used by Oracle's Learning Management and iRecruitment / Recruitment offering functionality. Its name comprises the PQP prefix (Payroll/People product family in Oracle E-Business Suite) combined with the "RIW" and "OFFERING" tokens, indicating it belongs to the recruitment/offering integration subsystem and that it wraps lower-level offering DML operations behind a controlled, reusable interface. In EBS 12.1.1 and 12.2.2, offering records define the catalog of courses, events, and related items that can be assigned to persons, applicants, or employees. By encapsulating the insert and update logic for these offerings, the package shields callers from the physical structure of the underlying tables and centralizes validation and audit handling.

The package is documented with a status of VALID and an API classification of OTHER in the ETRM 12.2.2 metadata. It depends on APPS.HR_API (the standard HR_ API wrapper layer) and on the SYS.STANDARD package, the latter being an implicit PL/SQL dependency present in virtually every compiled unit. The presence of HR_API in the dependency chain confirms that the package invokes Oracle HRMS business logic during its processing, rather than performing raw inserts against HR tables.

Key Procedures and Functions

The ETRM metadata documents a single entry point:

  • INSUPD_OFFERING — The name is a contraction of "Insert or Update Offering." As its identifier implies, this is the sole documented procedure exposed by the package, providing both insert and update semantics for offering records. It is the primary functional entry point through which callers create new offerings or maintain existing ones. Consistent with the documented dependency on HR_API, the procedure delegates the actual persistence of HR-relevant data to the HRMS API layer while handling offering-specific logic itself. No parameter list is published in the available metadata; consumers should obtain the exact signature from the package specification in the database rather than assuming an interface.

No additional procedures or functions are documented for this package, and the ETRM record reports zero other packages that reference it, indicating a relatively narrow internal usage footprint in the dependency graph.

Tables Accessed

The package references four tables through APPS synonyms:

  • OTA_OFFERINGS — The primary catalog table for offerings. INSUPD_OFFERING inserts new offering rows into this table and updates existing ones.
  • OTA_EVENTS — The base events table. Offerings are frequently associated with, or derived from, events, so the procedure reads this table to resolve and validate event linkage.
  • OTA_EVENTS_TL — The translation (multi-language) table for events, consulted to retrieve the language-specific event names and descriptive text that accompany an offering.
  • BNE_INTERFACE_COLS_B — A base interface column definition table from the BNE (Web Applications/Personalization) product. Its presence suggests the package consults interface column definitions, most likely to support personalization, defaulting, or display metadata associated with the offering transaction.

Usage Notes

This package is an internal wrapper rather than a public, customer-facing API. It is typically invoked indirectly by higher-level Learning Management or recruitment/offering processes, and the metadata records no other packages as dependent on it, reinforcing its role as a leaf-level utility called from forms logic, concurrent processing, or product-specific code paths. Direct calls from custom code are technically possible by invoking APPS.PQP_RIW_OFFERING_WRAPPER.INSUPD_OFFERING, but such usage should be undertaken cautiously: the procedure performs DML on core OTA offering tables, and the customary EBS recommendation is to use the documented public HRMS and product APIs instead of internal wrappers. Because the package depends on HR_API, any invocation must run in a session with the correct HR security context and valid FND global settings. On upgrade from 12.1.1 to 12.2.2 the package is recompiled and revalidated; the ETRM metadata for 12.2.2 shows a VALID status, confirming it remains operational in the Online Patching edition.