Search Results get_defined_balance_by_type

Overview

HR_US_REPORTS is an Oracle EBS PL/SQL package owned by the APPS schema that declares functions and procedures used to return values for the US Payroll reports originally authored in Oracle Reports (srw2) release 10. Per its header specification (source file pyuslrep.pkh, version 120.0.12010000.2), the package exists solely to supply report-level data retrieval logic for legislative US payroll and human resources reporting. Its API classification within ETRM is OTHER, indicating it is not a public, supported business API but a reporting support package whose entry points are consumed by report definitions rather than called directly by end users.

The package is closely tied to US legislative reporting requirements, including Equal Employment Opportunity (EEO) reporting, tax reporting, COBRA benefit administration reporting, and payroll payment reporting. The change list demonstrates that the package evolved incrementally from its initial creation in September 1993, with functionality added release by release as new federal and legislative reporting obligations were incorporated. Despite the search term "uno crm report," this package has no relationship to CRM modules; it belongs to the Oracle Payroll (PY) and Human Resources (HR) product family.

Key Procedures and Functions

The package exposes 33 documented procedures and functions. Their purposes fall into several functional groupings:

• Payroll and payment data: GET_SALARY retrieves salary information for reporting; FNC_GET_PAYEE returns payee details; GET_PAYMENT_TYPE_NAME resolves payment type descriptions; GET_PAYROLL_ACTION returns payroll action information; GET_CONSOLIDATION_SET returns the applicable consolidation set.
• Balance and element data: GET_DEFINED_BALANCE_ID, GET_STARTUP_DEFINED_BALANCE, and GET_DEFINED_BALANCE_BY_TYPE return defined balance identifiers and definitions for balance-based reporting; GET_ELEMENT_TYPE_NAME returns element type names.
• Person and address data: GET_PERSON_NAME returns formatted person names; GET_ADDRESS, GET_EMPLOYEE_ADDRESS, and GET_COUNTY_ADDRESS return address information, with the county address retrieval explicitly added for EEO and tax reports.
• Legislative and organizational data: GET_LEGISLATION_CODE returns the legislation code; GET_TAX_UNIT returns tax unit information; GET_ACTIVITY supports EEO reporting; GET_ORG_NAME and related organization hierarchy functions (documented in the change list) support organizational reporting.
• Benefits and COBRA data: GET_BEN_CLASS_NAME returns benefit classification names; GET_COBRA_QUALIFYING_EVENT and GET_COBRA_STATUS support COBRA eligibility and status reporting.
• New hire data: GET_NEW_HIRE_CONTACT returns new hire contact information.

Tables Accessed

The package reads data through APPS synonyms across several product schemas:

• Payroll tables: PAY_DEFINED_BALANCES, PAY_BALANCE_TYPES, PAY_BALANCE_DIMENSIONS, PAY_CONSOLIDATION_SETS, PAY_ELEMENT_CLASSIFICATIONS, PAY_ASSIGNMENT_ACTIONS, PAY_ELEMENT_ENTRIES_F, and PAY_ELEMENT_ENTRY_VALUES_F — used for balance, element, assignment action, and consolidation set reporting.
• HR tables: HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, HR_ASSIGNMENT_SETS, HR_LOCATIONS_ALL, HR_LOCATION_EXTRA_INFO, and HR_SOFT_CODING_KEYFLEX — used for organizational hierarchy, location, address, and soft coding retrieval.
• Benefits tables: BEN_BENEFIT_CLASSIFICATIONS — used for benefit classification name resolution in COBRA and benefits reporting.

Usage Notes

HR_US_REPORTS is invoked by report definitions — historically Oracle Reports (srw2) executables — as a data source for report-level queries and formatting logic. It is referenced by ten other packages, indicating that some of its functions are reused as building blocks by additional reporting or processing packages. Developers and report authors should treat this package as a reporting utility layer rather than a transaction API: its routines return descriptive values for display or filter purposes and do not represent a supported interface for creating or updating payroll or HR data. Customizations or extensions requiring similar values should call the underlying documented APIs or query the base tables directly, since this package carries a restricted-use copyright notice and is subject to change between releases.