Search Results per_requisitions_swi




Overview
Explore in AI Chat

Overview

PER_REQUISITIONS_SWI is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that encapsulates the business logic for managing requisitions within Oracle Human Resources (PER). The suffix "SWI" denotes a server-side workflow integration or surface-wrapper interface, indicating that the package exposes a controlled set of entry points that other Oracle EBS components — forms, concurrent programs, and workflow-enabled processes — can invoke without directly manipulating the underlying HR tables. In release 12.1.1 and 12.2.2 the package is classified under the ETRM API classification OTHER, distinguishing it from the fully documented public APIs such as HR_API. Its primary role is to provide create, update, and delete operations for requisition records that support recruitment, vacancy, and position-management flows, while delegating low-level validation and table maintenance to the established HR API layer.

Key Procedures and Functions

The ETRM metadata documents four callable entry points:

  • CREATE_REQUISITION — Inserts a new requisition record, applying the standard HR validation rules and deriving default values required for a requisition to be considered complete and valid within the PER schema.
  • UPDATE_REQUISITION — Modifies an existing requisition, preserving audit columns and enforcing the workflow and date-effectivity constraints that apply to requisition data.
  • DELETE_REQUISITION — Removes or logically terminates a requisition, subject to the referential and status checks required before a requisition may be retired.
  • PROCESS_API — A generic dispatcher that routes an inbound request to the appropriate create, update, or delete operation based on the action requested. This pattern allows callers to submit a single, uniform call, which is characteristic of SWI-style wrapper packages.

Parameter lists are not published in the ETRM excerpt and should be confirmed against the package specification in the target instance.

Tables Accessed

At the SQL layer, the package’s documented dependencies reference XMLDOM and XMLPARSER through APPS synonyms. These objects indicate that requisition payloads are processed as XML documents — the package parses inbound XML, traverses the resulting DOM, and maps the extracted values onto the requisition structures. The core requisition and HR records themselves are not manipulated directly by this package; instead, PER_REQUISITIONS_SWI depends on HR_API from the APPS schema, which performs the actual inserts, updates, and deletes against the PER base tables. This two-tier design keeps validation and business rules centralized in HR_API.

Usage Notes

PER_REQUISITIONS_SWI is typically invoked by other Oracle EBS packages rather than directly from end-user forms. The ETRM dependency listing shows it is referenced by IRC_VACANCY_COMMIT, the package that commits vacancy and recruitment data in Oracle iRecruitment, and by itself, indicating internal recursion or a wrapper call pattern. Because it is an OTHER-class API and manipulates HR data, any custom invocation should be performed only after the standard HR API validations and security checks have been satisfied. Custom code that calls the package directly should run through the APPS schema, supply well-formed XML where PROCESS_API is used, and commit explicitly, since these procedures do not commit on the caller’s behalf. Regression testing is advisable on both 12.1.1 and 12.2.2, as the underlying XML and HR API dependencies may differ between release levels.