Search Results update_job

Overview

APPS.HR_JOB_SWI is a public API package body within the Oracle E-Business Suite Human Resources (HR) module. The suffix "SWI" designates it as a "Server Web Interface" wrapper, a naming convention used throughout Oracle EBS to expose validated, business-rule-enforcing entry points that sit on top of the underlying base tables and business logic of a given entity. In this case, the entity is the Job (HR_JOBS), a core Oracle HRMS object that defines the roles and positions an enterprise uses to organize its workforce. Jobs are foundational to HRMS because they drive position hierarchies, salary structures, grade mappings, and applicant tracking.

The package encapsulates the application logic required to create and modify job definitions while enforcing data validation, security, and defaulting rules. Rather than allowing direct DML against the HR_JOBS table, Oracle exposes HR_JOB_SWI so that both internal and external callers can perform supported operations in a controlled manner.

Key Procedures and Functions

The ETRM documentation records two documented procedures for this package: CREATE_JOB and UPDATE_JOB.

• CREATE_JOB — Creates a new job record. Its parameter list includes business group, effective dates, job group, benchmark job indicators, approval authority, employment rights flag, and a large set of descriptive flexfield attribute columns (attribute1 through attribute20) plus job information flexfield values. The routine validates the input, applies defaults, and inserts the new job definition.
• UPDATE_JOB — The procedure corresponding to the user's "update_job" search. It updates an existing job record, allowing changes to the job's effective dates, name, group, benchmark status, approval authority, rights flag, and flexfield attributes. Like CREATE_JOB, it performs validation and date-tracked updates consistent with HRMS effective-dating rules.

Both procedures accept a validation-mode flag (p_validate) allowing callers to run the logic in a rollback-only test mode before committing real data.

Tables Accessed

The ETRM metadata excerpt did not list explicit base table references, but based on the API's purpose and Oracle HRMS architecture, the package operates against the HR_JOBS table (the job definition table) and supporting HR_LOOKUPS and flexfield structures. Referenced synonym tables are accessed through the APPS schema, and the package relies on HR_JOBS for storage of the job record and effective-dated segments. Job group and business group validations reference HR_JOB_GROUPS and HR_ORGANIZATION_UNITS as appropriate. The remaining logic is delegated to internal HR validation and date-track utilities. No other package references HR_JOB_SWI, indicating it is a top-level entry point rather than an internal utility.

Usage Notes

HR_JOB_SWI is typically invoked from Oracle Forms (the Job window of the HRMS People/Work Structures forms), from concurrent programs that bulk-load job definitions, and from custom PL/SQL integrations that need to create or maintain jobs programmatically. Custom code should always call the SWI procedures rather than issuing direct DML against HR_JOBS, because the wrapper enforces business group validation, effective-date logic, flexfield validation, and audit columns. Using p_validate => HR_API.G_TRUE is recommended during development and unit testing. In Oracle EBS 12.1.1 and 12.2.2, the package is unchanged in API classification (OTHER), and callers should confirm the job group and business group context are set before invocation to avoid validation errors.