Search Results get_position_agency_code_pos

Overview

APPS.GHR_API is a public API package belonging to the Oracle E-Business Suite Human Resources (GHR) product family. The package encapsulates the business logic required to retrieve and manipulate position-related descriptive attributes, assignment extra information, and workflow-driven HR transactions. In Oracle EBS 12.1.1 and 12.2.2, GHR_API functions as a centralized access layer for federal and public-sector HR configurations, where positions carry statutory descriptors—such as position title, position description number, position sequence number, and agency code—that are regulated by government reporting standards. The package abstracts the underlying PER_ALL_POSITIONS, PER_JOBS, and related definition tables so that forms and concurrent programs do not query these tables directly, preserving a consistent validation and security model.

The package is classified as an API in the ETRM repository with owner APPS, and it is referenced by 75 other packages, indicating broad adoption across HR, Payroll, and workflow-dependent components.

Key Procedures and Functions

The documented interface exposes 17 procedures and functions:

• GET_POSITION_DESCRIPTION_NO — Retrieves the position description number associated with a position; the function for which the user query "get_position_description_no" was issued.
• GET_POSITION_DESC_NO_POS — Positional variant of the description number lookup, returning the value by positional binding.
• GET_POSITION_TITLE and GET_POSITION_TITLE_POS — Return the title of a position, with the positional form supporting ordered parameter binding.
• GET_POSITION_SEQUENCE_NO and GET_POSITION_SEQUENCE_NO_POS — Return the position sequence number used for ordering positions within a classification.
• GET_POSITION_AGENCY_CODE and GET_POSITION_AGENCY_CODE_POS — Return the agency code assigned to a position.
• GET_JOB_OCCUPATIONAL_SERIES and GET_JOB_OCC_SERIES_JOB — Return occupational series information at the job level.
• RETRIEVE_ELEMENT_ENTRY_VALUE — Fetches a payroll element entry value from the element entry and input value tables.
• RETURN_SPECIAL_INFORMATION — Returns special information associated with an assignment or position.
• RETURN_EDUCATION_DETAILS — Returns education-related details for an assignment.
• RETURN_UPD_HR_DML_STATUS — Returns the DML status of the last HR API operation, supporting error handling in custom code.
• SF52_FROM_DATA_ELEMENTS — Supports generation of Standard Form 52 data from underlying data elements.
• CALL_WORKFLOW — Initiates a workflow process from within the HR API context.
• RESTRICTED_ATTRIBUTE — Evaluates whether an attribute is restricted under the current security rules.

Tables Accessed

GHR_API reads and writes through APPS synonyms across several core HR and Payroll tables. Position data is sourced from PER_ALL_POSITIONS, PER_JOBS, and PER_JOB_DEFINITIONS, while grade information is drawn from PER_GRADE_DEFINITIONS. Assignment-level descriptive flexfield values are stored and retrieved via PER_ASSIGNMENT_EXTRA_INFO. Payroll element data is accessed through PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_TYPES_F, and PAY_INPUT_VALUES_F. Workflow and request tracking use GHR_PA_REQUESTS, GHR_PA_REQUEST_EXTRA_INFO, and GHR_PA_ROUTING_HISTORY. Group security is enforced through GHR_GROUPBOXES and GHR_GROUPBOX_USERS, and HR location details are read from HR_LOCATION_EXTRA_INFO. PER_ANALYSIS_CRITERIA supports criteria-based retrieval of position attributes.

Usage Notes

GHR_API is typically invoked from Oracle Forms (notably the Position and Assignment forms), from concurrent programs that generate federal HR reports and Standard Form 52 output, and from custom PL/SQL code that must respect the same derivation rules as the standard product. Because the package is a public API, callers should use the documented procedures rather than querying the underlying tables directly. The positional variants (those suffixed _POS) exist to support forms and integrations requiring fixed argument ordering. Developers should verify the current DML status after write operations by calling RETURN_UPD_HR_DML_STATUS, and should account for group security restrictions when retrieving position attributes.