Search Results per_job_ins




Overview
Explore in AI Chat

Overview

PER_JOB_INS is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It forms part of the Oracle Human Resources (PER) foundation layer that manages the Jobs entity, the setup object used to define valid job classifications assigned to positions, assignments, and employee records. Within the ETRM repository the package is classified with an API type of OTHER and is designated VALID, confirming that it compiles successfully against the current database and is available for use by dependent objects.

The package is fundamentally an internal insert-handler. Rather than representing a public, documented business API such as the HR_JOB_API family, PER_JOB_INS encapsulates the low-level row creation logic invoked by the Job business process layer. Its purpose is to centralise the insertion of job rows while providing base-key management to support the multi-tenant, business-group-keyed data model that underpins HRMS tables.

Key Procedures and Functions

The ETRM metadata documents three callable units within the package body:

  • SET_BASE_KEY_VALUE — Assigns or resolves the base key value associated with the job record being processed. In the HRMS data model, base keys support the Business Group partitioning mechanism (the business_group_id and related key columns) that isolates HR data by enterprise. This routine ensures the correct key context is established before a row is written.
  • INS — The primary insert routine. It performs the actual creation of the job row, applying the standard HRMS insert semantics. It is the entry point that the Job business logic layer invokes when a new job definition must be persisted.

The package exposes no other documented procedures or functions. Parameter lists are not published in the ETRM repository and are therefore not documented here.

Tables Accessed

The package references two core tables through APPS synonyms:

  • PER_JOBS — The primary Jobs table. PER_JOB_INS writes new job records here. Each row represents a distinct job definition within a business group, carrying attributes such as name, effective dates, and enabled flag.
  • PER_JOBS_S — The corresponding date-tracked (surrogate/audit) table used by the HRMS DateTrack framework. Whenever a job definition is created or modified, a shadow row is maintained to preserve historical versions. The package writes to this table alongside PER_JOBS to keep the datetracked consistency intact.

Both tables are addressed via the APPS synonym layer, allowing the package to operate on the base HR schema tables regardless of the connecting user.

Usage Notes

PER_JOB_INS is an internal implementation package rather than a standalone public API. It is invoked by the Job business layer, notably PER_JOB_BUS and related routing packages such as PER_JOB_RKI and PER_JOB_SHD, which orchestrate row-level inserts, row-key information handling, and shadow-table maintenance. The dependency listing confirms PER_JOB_INS calls HR_API, HR_UTILITY, and references DUAL and STANDARD from SYS, indicating it relies on the standard HR API infrastructure for error handling, validation, and utility operations.

The ETRM metadata further notes that PER_JOB_INS is not referenced by any other database object directly, and it is referenced by one other package — its immediate caller within the Job processing chain. Consequently, developers should not call PER_JOB_INS directly from forms, concurrent programs, or custom code. The supported integration route for creating or maintaining jobs is the published HR_JOB_API / HR_JOB_BUSINESS_GROUP_API layer, which in turn delegates to this internal routine. Direct invocation risks bypassing validation, DateTrack bookkeeping, and business-group key derivation, and could produce inconsistent job records. Customisations should target the public HR APIs and leave PER_JOB_INS to the delivered HRMS processing flow.