Search Results ghr_assignment_api




Overview
Explore in AI Chat

Overview

APPS.GHR_ASSIGNMENT_API is a public PL/SQL API package in the Oracle E-Business Suite Applications (APPS) schema, classified in the ETRM repository as an API. It belongs to the Oracle Human Resources (HRMS/HR) product family; the "GHR" prefix denotes the global HR layer of the applications, which provides the business logic that sits beneath product-specific forms and concurrent programs. Its documented status is VALID, and it exposes both a package specification and a package body.

The package serves as a programmatic interface for the creation and maintenance of assignment records. In Oracle HRMS an assignment links an employee or applicant to a payroll, organization, job, position, and grade, and carries the effective-dated attributes that drive payroll processing, benefits eligibility, and reporting. The GHR_ASSIGNMENT_API exists so that datetracked assignment changes can be performed through supported, validated business logic rather than by direct DML against the underlying HR tables. This preserves datetrack integrity, fires the appropriate business rules, and keeps assignment history consistent across the application.

Key Procedures and Functions

The ETRM metadata documents a single entry point for this package:

  • ACCEPT_APL_ASG — The sole documented procedure. Its name indicates the acceptance of an applicant assignment, that is, the processing step in which an assignment associated with an applicant is accepted and converted or carried into an active employee assignment context within Oracle HRMS. Invoking this procedure routes the operation through the package's internal validation and datetrack handling rather than performing the state change directly.

No additional procedures or functions are recorded in the ETRM documentation for this object, and no public parameter lists are published in the available metadata. Consult the package specification in the database (for example, via ALL_ARGUMENTS or the package source in the APPS schema) before coding a call.

Tables Accessed

The documentation excerpt does not enumerate the base tables read or written by GHR_ASSIGNMENT_API; the only dependency recorded at the package level is the shared HR_API package (APPS.HR_API), together with the SYS.STANDARD package. Because the package operates on assignment data via the HR_API layer, the physical tables it affects are the standard HRMS datetracked entities — principally PER_ALL_ASSIGNMENTS_F, with supporting access to PER_ALL_PEOPLE_F, PER_JOBS, PER_POSITIONS, and related lookup and organization tables — all referenced through APPS synonyms. Practically, any table listed in this section should be treated as read/written indirectly through the HR_API business layer rather than by the GHR package itself.

Usage Notes

GHR_ASSIGNMENT_API is an internal-to-APPS API. According to the ETRM dependency data, the object is referenced only by itself within the APPS schema and by no other packages, which indicates that it is not designed as a general integration surface for third-party or customer code. It is typically invoked from Oracle HRMS forms and from standard concurrent programs that need to accept or reprocess applicant assignments, and it is not intended to be called directly from custom PL/SQL unless no higher-level public API is available.

Because the documented API classification is API and the package depends on HR_API, any custom invocation should follow normal Oracle HRMS extension practice: call the procedure within a properly initialized HR session, provide the required business group context, and commit only after the returned status confirms success. Where a higher-level, product-specific API exists for the same operation, that API should be preferred, since the GHR layer is subject to change between releases such as 12.1.1 and 12.2.2 and is not covered by the same compatibility guarantees as the documented public HR APIs.