Search Results pe_jei_bus




Overview
Explore in AI Chat

Overview

PE_JEI_BUS is a server-side PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. The name follows Oracle's business logic naming convention (_BUS), which denotes that this package encodes validation and enforcement rules rather than acting as the primary data-manipulation API. It operates against the Job Extra Information (JEI) schema objects — PER_JOB_EXTRA_INFO, PER_JOB_INFO_TYPES, and PER_JOBS — which underpin the descriptive flexfield "Extra Information" regions attached to jobs in Oracle HRMS and Oracle Payroll.

In Oracle EBS, "Extra Information Types" (EITs) allow customers to define additional, customer-specific attributes on jobs without altering the seeded job entity. Each EIT is registered in PER_JOB_INFO_TYPES, while the values a user enters for a given job populate PER_JOB_EXTRA_INFO. PE_JEI_BUS centralises the business rules that govern whether such a record may be created, changed, or removed, and it validates those rules consistently across every entry point to the EIT data.

Key Procedures and Functions

The package body exposes eight documented program units, divided into helper checks and the core DML validators.

  • INSERT_VALIDATE — The primary validation routine invoked before a new Job Extra Information row is inserted.
  • UPDATE_VALIDATE — The counterpart validator for modifications to an existing JEI row.
  • DELETE_VALIDATE — The validator for removal of a JEI record.
  • CHK_JOB_INFO_TYPE — Confirms that the supplied Job Information Type is valid and usable for the job in context.
  • CHK_JOB_ID — Confirms that the supplied Job identifier exists and is legitimate.
  • CHK_MULTIPLE_OCCURENCES_FLAG — Enforces the Multiple Occurrences setting defined on the information type, preventing duplicate instances when the type permits only a single occurrence.
  • CHK_NON_UPDATEABLE_ARGS — Provides shared validation logic for arguments that may not be modified once set, reused by the validate routines.
  • RETURN_LEGISLATION_CODE — Resolves and returns the applicable legislation code, which localises and constrains the behaviour of the other checks.

Together these units constitute a complete insert/update/delete validation layer that is applied by the DML procedures elsewhere in the JEI stack.

Tables Accessed

The package works with three HRMS job tables. PER_JOBS supplies the job identity that is being validated by CHK_JOB_ID and anchors the foreign-key relationship. PER_JOB_INFO_TYPES holds the Extra Information Type definitions, providing the metadata — particularly the multiple-occurrences flag — consumed by CHK_JOB_INFO_TYPE and CHK_MULTIPLE_OCCURENCES_FLAG. PER_JOB_EXTRA_INFO is the transactional detail table holding the actual job-level extra information records that INSERT_VALIDATE, UPDATE_VALIDATE, and DELETE_VALIDATE scrutinise before the row is committed or removed.

Usage Notes

PE_JEI_BUS is not referenced by any database object, indicating that it is invoked directly by application-level callers. Typical callers include the EIT maintenance form handlers in Oracle HRMS and the Datetracked update pathway; the dependency on PE_JEI_SHD (a shadow-table package) and HR_DFLEX_UTILITY confirms that the package participates in descriptive flexfield and date-tracked update processing. The presence of FND_MESSAGE indicates that failures are surfaced as standard Oracle Forms messages, and the HR_API, HR_UTILITY, and HR_BUSINESS_GROUPS dependencies reflect the routine use of HR security and utility routines. Custom code that inserts or modifies Job Extra Information records should route its validations through this package rather than duplicating the ruleset.