Search Results per_jbr_bus




Overview
Explore in AI Chat

Overview

APPS.PER_JBR_BUS is a business-layer PL/SQL package body within the Oracle E-Business Suite human resources (PER) schema. It supports the Job Requirements functionality of Oracle HRMS, providing the validation logic that governs the association between jobs and their defined requirements, such as competencies, qualifications, and other analysis criteria. The suffix "_BUS" indicates that the package belongs to the business rule layer of the Oracle HRMS API architecture, sitting between the user interface and the underlying table-handling logic. Its role is to enforce business rules before data is committed to the base requirement tables, ensuring referential integrity and consistency for job requirement records maintained through the standard HRMS forms and APIs.

The package body is reported as VALID and is owned by the APPS schema, which is consistent with the standard Oracle EBS convention of compiling shared application logic under the APPS account and exposing it to forms, concurrent programs, and other packages.

Key Procedures and Functions

The documented package body exposes three validation procedures, each mapped to a corresponding DML action performed on job requirement data.

  • INSERT_VALIDATE — Executed when a new job requirement record is created. It verifies that the proposed row satisfies the business rules required before insertion, such as the validity of the associated job, requirement, and analysis criteria references.
  • UPDATE_VALIDATE — Invoked when an existing job requirement record is modified. It checks that the amended values remain consistent with the defined business constraints prior to the update being applied.
  • DELETE_VALIDATE — Called before a job requirement record is removed. It confirms that deletion of the row does not violate any established dependency or business rule, thereby protecting the integrity of related HR data.

No parameter lists are recorded in the available metadata; each procedure should be treated as a validation entry point invoked by the surrounding API framework rather than called directly.

Tables Accessed

The package resolves its data through APPS synonyms. The documented base tables referenced are PER_JOB_REQUIREMENTS, which stores the requirement records attached to jobs, and PER_ANALYSIS_CRITERIA, which defines the criteria against which job requirements are evaluated. Additional dependencies visible in the ETRM dependency listing include HR_LOOKUPS for validating lookup values, HR_POSITIONS_F, PER_JOBS_V, and PER_ANALYSIS_CRITERIA, together with HR_API, HR_DFLEX_UTILITY, HR_UTILITY, and PER_JBR_SHD. These supporting objects supply the flexible-date and utility routines, shadow-table handling, and validation services that the _BUS layer relies upon.

Usage Notes

PER_JBR_BUS is not referenced by any other database object according to the ETRM metadata, and it is best understood as an internal business-rule component invoked indirectly. In practice it is called by the Job Requirements maintenance form within Oracle HRMS and by the surrounding job requirement API stack whenever requirements are inserted, updated, or deleted. The documented API classification is OTHER, and the package is referenced by three other packages, indicating that it is consumed by higher-level HR APIs rather than by custom code directly. Developers extending job requirement functionality should invoke the supported public HR APIs instead of calling INSERT_VALIDATE, UPDATE_VALIDATE, or DELETE_VALIDATE explicitly, allowing this package to perform its validation in the correct sequence.