Search Results pe_jei_shd




Overview
Explore in AI Chat

Overview

PE_JEI_SHD is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. In the context of the Oracle Human Resources (HR) and Oracle Payroll product families, the "PE_" prefix denotes objects belonging to the People/HR datamodel, while the "JEI" token relates to Job Extra Information. The package therefore serves as a database-side helper for maintaining and validating the Job Extra Information flexfield data stored against job definitions. Job Extra Information is the descriptive flexfield (DFF) structure that allows implementers to capture customer-specific attributes on a job, such as grade band, competency requirements, union codes, or other client-defined fields beyond the delivered job attributes.

Functionally, the package encapsulates the low-level logic that surrounds the PER_JOB_EXTRA_INFO table. It provides the plumbing that the Job Extra Information maintenance screen, and the supporting APIs, rely upon when records are inserted, queried, or changed. Because the object is registered in ETRM with an API classification of OTHER, it is not a publicly supported integration API in the way that a formally named PL/SQL API would be; rather, it is an internal implementation package whose entry points exist to support the surrounding HR forms and API stack.

Key Procedures and Functions

The documented package exposes four units. No parameter signatures are published, so the descriptions below are limited to purpose.

  • CONSTRAINT_ERROR — A handler for constraint-related error conditions. It is used to detect and raise or translate database constraint violations that occur when Job Extra Information records are written, allowing the calling code to present a meaningful message instead of a raw Oracle error.
  • API_UPDATING — A control routine that signals that an update is in progress. It governs the mode of operation for the package, ensuring that validation and synchronization logic behave correctly when an existing Job Extra Information row is being modified rather than created.
  • LCK — A locking routine. It obtains the required row or table locks so that concurrent updates to Job Extra Information for the same job cannot collide, preserving data integrity during maintenance transactions.
  • CONVERT_ARGS — An argument-conversion utility. It normalises or transforms the values passed into the package, which is characteristic of flexfield handling where identifiers, context values, and descriptive segment values must be cast or mapped before use.

Tables Accessed

  • PER_JOB_EXTRA_INFO — The core table for Job Extra Information. This is the primary read/write target: the package stores, retrieves, and validates the extra attributes attached to a job through this table.
  • ALL_CONSTRAINTS — Queried to inspect constraint definitions at runtime. This supports the CONSTRAINT_ERROR logic by allowing the package to identify which constraint was violated and respond appropriately.

Usage Notes

PE_JEI_SHD is referenced by seven other packages in the E-Business Suite, indicating that it is a shared internal dependency rather than a standalone entry point. It is typically reached indirectly: the Job Extra Information form and higher-level HR APIs call into the packages that depend on PE_JEI_SHD, and those in turn use its locking, updating, conversion, and error-handling routines. In this respect it is a supporting layer, and direct invocation from custom code is discouraged.

The package depends on HR_API and HR_UTILITY for shared HR utilities, and on the standard SYS.STANDARD package. Because it is an internal, unsupported package, its bodies should not be modified, and customisations should be confined to the documented configuration of the Job Extra Information flexfield itself. The object status is VALID in the documented environment, confirming that it compiles cleanly and remains in active use on both EBS 12.1.1 and 12.2.2.