Search Results per_requisitions_api




Overview
Explore in AI Chat

Overview

APPS.PER_REQUISITIONS_API is a public PL/SQL API package in the Oracle E-Business Suite 12.1.1 and 12.2.2 releases that encapsulates the business logic for maintaining personnel requisitions — the recruitment records that define an open position, its staffing attributes, and the hiring demand against which applicants and offers are tracked. The package is owned by the APPS schema and reported with Status VALID in the ETRM repository. It is classified as an API, meaning that it forms part of the sanctioned programmatic interface for the Oracle Human Resources (PER) product rather than an internal, private utility.

The package provides a supported alternative to the Oracle Forms user interface for creating, amending, and removing requisition data. By routing all data manipulation through the API, Oracle preserves the validation, business rules, and derived column maintenance that the forms-based flow would otherwise enforce, thereby protecting data integrity when requisitions are loaded or synchronized from external systems.

Key Procedures and Functions

The ETRM metadata documents three procedures for this package. No parameter lists are published in the metadata, and none should be assumed; callers should inspect the live package specification in the target instance.

  • CREATE_REQUISITION — Inserts a new personnel requisition record. It is the entry point for registering an open position or vacancy in the recruitment module, applying the standard validation and defaulting logic before the row is committed.
  • UPDATE_REQUISITION — Modifies an existing requisition. It supports changes to requisition attributes that the business permits to be maintained after creation, such as status, staffing details, or associated date information.
  • DELETE_REQUISITION — Removes a requisition record. Because requisitions may be referenced by downstream recruitment objects such as applicants and offers, this procedure is subject to the referential and business-rule constraints enforced by the API.

Tables Accessed

The documented dependency information for PER_REQUISITIONS_API lists references to APPS.HR_API and to the SYS.STANDARD package, but does not enumerate specific base tables accessed through APPS synonyms. The metadata excerpt therefore provides no authoritative table list, and no table names should be asserted beyond those documented. In practice, the API operates on the PER requisition schema for the Oracle HRMS recruitment entities, and it delegates common date-tracking, who-column, and validation behaviour to HR_API, which is consistent with the dependency recorded in the repository.

Usage Notes

PER_REQUISITIONS_API is referenced by one other package, PER_REQUISITIONS_SWI. The presence of a SWI (server-side web interface) wrapper indicates that the API is consumed by the Oracle self-service recruitment flows in addition to being available for direct invocation. Custom integrations, conversions, and batch loads that need to populate or maintain requisitions should call this API rather than inserting into the underlying tables, so that HR_API validation and business logic are applied consistently.

Callers should ensure their environment is at a supported 12.1.1 or 12.2.2 patch level, use the MO or a similarly privileged APPS-based session as required by HRMS security, and perform an explicit commit according to the API's documented transaction semantics. Because the ETRM extract exposes only procedure names and dependency edges, the authoritative parameter signatures and error-handling conventions must be confirmed against the deployed package specification and the Oracle HRMS API documentation for the specific release.