Search Results core_hr_app_id

Overview

HR_GENERAL is a foundational PL/SQL utility package in the Oracle E-Business Suite HRMS (Human Resources Management System) schema, owned by APPS. Its stated purpose, per the package header, is "to provide widely used functions in a single shared area," consolidating common routines so they can be referenced consistently across the many HR modules that depend on them. Originally created in March 1994 and maintained through numerous releases up to 12.1.1 and 12.2.2, the package is classified as an "OTHER" API type rather than a business object API. It is one of the most heavily referenced packages in the EBS codebase, cited by 4,762 other packages, which underscores its role as a shared infrastructure layer supporting both delivered HR functionality and customer extensions.

Key Procedures and Functions

The package exposes 56 documented procedures and functions. These fall into several functional categories:

• Type conversion utilities: CHAR_TO_BOOL and BOOL_TO_CHAR convert between character representations and PL/SQL Boolean values, while ASSERT_CONDITION provides a general assertion mechanism used for validation.
• Application and context resolution: GET_BUSINESS_GROUP_ID, CHK_APPLICATION_ID, CORE_HR_APP_ID, VERTICAL_APP_ID, HRMS_OBJECT, and GET_APPLICATION_SHORT_NAME retrieve identifiers and application context information.
• Date and period helpers: EFFECTIVE_DATE, START_OF_TIME, and END_OF_TIME supply standard date boundaries used in effective-dated HR queries.
• Payroll and currency utilities: PAY_VALUE, MONEY_UNIT, and the overloaded DEFAULT_CURRENCY_CODE (the latter taking a business group identifier in one version) resolve payroll values and currency defaults.
• Validation and decoding: LOCATION_VALID, DECODE_LOOKUP, DECODE_FND_COMM_LOOKUP, DECODE_GRADE, and DECODE_GRADE_LADDER translate lookup codes, grade identifiers, and grade ladder values into human-readable or internal forms. These decode routines were introduced historically to eliminate outer joins in assignment folders and improve query performance (Bug 343096).
• Contact retrieval: GET_WORK_PHONE and GET_HOME_PHONE return phone numbers associated with a person, optimized for efficiency.
• Form initialization: INIT_FORMS establishes session context, accepting a session date and business group attributes in earlier overloaded versions.

Tables Accessed

The package references multiple tables through APPS synonyms. Core HR tables include HR_ALL_ORGANIZATION_UNITS_TL, HR_ALL_POSITIONS_F, and HR_ALL_POSITIONS_F_TL, supporting organization and position lookups. Payroll-related access covers PAY_ALL_PAYROLLS_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_LEGISLATION_RULES, PAY_LEGISLATIVE_FIELD_INFO, and PAY_PEOPLE_GROUPS. Application metadata is drawn from FND_APPLICATION, FND_CURRENCIES, FND_PRODUCT_INSTALLATIONS, and FND_SESSIONS. Benefit program data is read from BEN_PGM_F, and DBMS_DESCRIBE provides dynamic package introspection. These accesses support decode operations, currency default resolution, and session context determination.

Usage Notes

HR_GENERAL is typically invoked from HRMS forms, concurrent programs, and custom PL/SQL code rather than being called directly by end users. Form-level calls to INIT_FORMS set up session and business group context at runtime, while decode functions such as DECODE_GRADE and DECODE_LOOKUP are embedded in views and folder queries to translate codes without costly outer joins. Because 4,762 packages reference it, modifications carry broad impact, and any customization must respect the documented function signatures. The "decode_position" search term aligns with this package's decode family, which resolves position and grade identifiers into displayable values across HRMS reporting and assignment forms. Developers extending Oracle EBS 12.1.1 or 12.2.2 should treat HR_GENERAL as a stable shared utility rather than a business API.