Search Results per_job_bus




Overview
Explore in AI Chat

Overview

APPS.PER_JOB_BUS is a PL/SQL business logic package within the Oracle E-Business Suite Human Resources (PER) product family. Its name follows the standard Oracle naming convention in which the _BUS suffix designates a package that encapsulates business rules and validations for a particular entity, in this case the Job (PER_JOBS and its date-tracked shadow table PER_JOB_SHD). Working alongside the HR_JOB_API public API, PER_JOB_BUS serves as the validation and business-rule engine called during insert, update, and delete operations against job definitions. Rather than exposing an end-user interface itself, the package provides internal procedures that other API layers, table handlers, and triggering packages invoke to enforce data integrity before database changes are committed. It also supports the DateTrack model, central to Oracle HRMS, in which records are versioned by effective dates and multiple validation passes are required to correctly interpret insert, update, and delete intent against the current and future dates of a job definition.

Key Procedures and Functions

The package exposes fifteen documented procedures and functions. These fall into three broad validation categories:

Tables Accessed

PER_JOB_BUS operates primarily against PER_JOBS and its shadow table PER_JOB_SHD, which hold current and versioned job records respectively. It also references a broader set of HRMS tables through APPS synonyms, including PER_ALL_ASSIGNMENTS_F (to determine whether a job is in use and therefore protects against unsafe deletes), HR_ALL_POSITIONS_F (position-to-job relationships), PER_VALID_GRADES and PER_JOB_GROUPS (grade and group validation), PER_JOB_EVALUATIONS, PER_JOB_REQUIREMENTS, PER_JOB_DEFINITIONS, PER_CAREER_PATH_ELEMENTS, PER_BUDGET_ELEMENTS, and PER_ROLES (supporting job attributes such as evaluations, requirements, career paths, budgeting and role linkage), and PAY_ELEMENT_LINKS_F (payroll element linkage). DBMS_SQL is referenced for dynamic validation, and the SYS.STANDARD package is used for standard PL/SQL functionality.

Usage Notes

PER_JOB_BUS is not normally invoked directly by end users. It is called by the PER_JOB_INS, PER_JOB_UPD, PER_JOB_DEL table handlers and by the HR_JOB_API public API, which in turn are consumed by the Job definition form in the Oracle HRMS Manager responsibility, by concurrent programs that load or migrate job data, and by custom code that creates or maintains jobs. Because the package is referenced by HR_JOB_API and by the date-tracked insert/update/delete handlers, any customization that bypasses these entry points risks circumventing validations such as uniqueness of job name and delete eligibility. As with all APPS schema packages, custom code should invoke the documented API layer rather than calling PER_JOB_BUS procedures directly, so that Oracle's internal business rules remain intact across upgrades. The package is VALID in both 12.1.1 and 12.2.2 environments, reflecting consistent behaviour across those releases.