Search Results per_requisitions_be3




Overview
Explore in AI Chat

Overview

APPS.PER_REQUISITIONS_BE3 is a server-side PL/SQL package within the Oracle E-Business Suite (EBS) Human Resources (PER) product family. It belongs to the family of business-entity (BE) "wrapper" packages that Oracle Forms generates around the TCA/HR entity APIs. The package implements the pre- and post-processing logic — the "business events" layer — that surrounds the underlying entity-handler calls, and it is declared AUTHID CURRENT_USER so that it executes with the privileges of the calling schema rather than the defining schema. In the context of EBS 12.1.1 and 12.2.2, this package participates in requisition processing for Oracle iRecruitment, where a "requisition" represents a job posting or vacancy record tied to recruitment activity. The documented header indicates the source was auto-generated (dated 03/01/2007) from an HR API wrapper template (hrapiwfe.pkb), which confirms its role as a generated Forms-driven wrapper rather than a hand-authored business API. Its declared API classification is "OTHER," meaning it is not one of the primary public HR APIs and is intended principally for internal use by the Forms runtime and the entity-handler infrastructure.

Key Procedures and Functions

The documented package exposes exactly one procedure:

  • DELETE_REQUISITION_A — The "delete" business-event procedure for the requisition entity. It is invoked by the Forms/entity-handler layer to remove a requisition record. Consistent with Oracle's wrapper naming convention, the _A suffix signals the "agent" or pre-processing branch of the delete business event, which runs before the underlying entity-handler delete logic. This procedure is the counterpart to the create and update wrapper procedures that would exist in sibling packages (e.g., the BE1/BE2 variants), with BE3 typically handling a specific event such as delete.

No parameter lists are reproduced here because the documented metadata does not publish them; per ETRM conventions, parameter details remain internal to the generated code.

Tables Accessed

The documented dependencies, resolved through APPS synonyms, are:

  • PER_WF_EVENTS_S — the HR workflow-events sequence, used to obtain surrogate identifiers for workflow event records raised during requisition processing.
  • DBMS_LOB — the Oracle-supplied large-object package, invoked where requisition-related attributes (such as descriptive or attachment content) must be handled as LOB data.
  • DUAL — the standard single-row pseudo-table, used for scalar evaluations and sequence/function calls within the generated logic.

These references indicate the package primarily orchestrates workflow-event bookkeeping and LOB handling rather than directly manipulating the core requisition table.

Usage Notes

PER_REQUISITIONS_BE3 is not intended to be called directly by custom code. It is normally invoked by the Oracle iRecruitment requisition form (or the related Forms block) through the entity-handler/business-event framework, which routes delete operations to DELETE_REQUISITION_A. Because it is a generated wrapper, the supported customization path is to extend the underlying entity handler or to register additional business-event subscriptions, not to modify the package. In 12.1.1 and 12.2.2 the object remains in the APPS schema and is referenced by one other package, so any customization should preserve this calling contract. Direct invocation should be avoided to prevent bypassing validation and workflow-event generation.