Results for “get_payroll_name”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PAY_AC_UTIL is a utility package body in the Oracle E-Business Suite Payroll (PAY) module. It supplies a collection of reusable PL/SQL helper functions and procedures that support ad hoc reporting and analytic queries against payroll, legislative, and geographic reference data. The package header traces its origin to October 2003, with a revision in February 2004 that added gross-to-net ad hoc support functions, including GET_DEF_BAL_FOR_SEEDED_BAL and GET_VALUE. Its stated purpose is to contain functions and procedures used by Oracle Discoverer, meaning it functions as a back-end library for ad hoc query tools rather than as a transactional business API.

The package is classified as type UTIL, and it exposes nine documented procedures and functions. It is referenced by five other packages, indicating that it is embedded in the payroll reporting and inquiry toolchain. It reads rather than writes business data, and the metadata reflects that it operates primarily as a lookup and formatting layer over core payroll tables.

Key Procedures and Functions

The nine documented entry points can be grouped by purpose:

• GET_LEGIS_PARAMETER — Parses a named parameter out of a payroll action's legislative parameter string. The body locates the token by name, determines the delimited value, and returns it as a number.
• GET_JURISDICTION_NAME — Resolves a jurisdiction identifier to its display name, supporting geographic reporting. This is the object most commonly associated with the search term referenced by users.
• GET_STATE_ABBREV — Returns the abbreviated form of a state, used to present compact geographic labels in reports.
• GET_FORMAT_VALUE — Applies formatting to a supplied value for consistent presentation in ad hoc output.
• GET_CONSOLIDATION_SET — Returns the consolidation set associated with a payroll or assignment context.
• GET_PAYROLL_NAME — Resolves a payroll identifier to its descriptive name.
• FORMAT_TO_DATE — Converts a value into a date representation for reporting purposes.
• GET_DEF_BAL_FOR_SEEDED_BAL — Maps a seeded (delivered) balance to its corresponding defined balance, added to support gross-to-net ad hoc reporting.
• GET_VALUE — A generic value-retrieval utility used by the other functions and by Discoverer queries to fetch a required attribute.

Tables Accessed

The package reads from the following tables through APPS synonyms:

• PAY_PAYROLL_ACTIONS — Source of legislative parameter strings parsed by GET_LEGIS_PARAMETER.
• PAY_ALL_PAYROLLS_F — Payroll definitions used by GET_PAYROLL_NAME.
• PAY_DEFINED_BALANCES and PAY_BALANCE_TYPES — Balance definition metadata supporting GET_DEF_BAL_FOR_SEEDED_BAL and GET_VALUE.
• PAY_BALANCE_DIMENSIONS — Dimensional context for balance lookups.
• PAY_CONSOLIDATION_SETS — Consolidation set definitions used by GET_CONSOLIDATION_SET.
• HR_ORGANIZATION_INFORMATION — Organization-level attributes for contextual resolution.
• PAY_US_STATES, PAY_US_CITY_NAMES, and PAY_US_COUNTIES — United States geographic reference data used for jurisdiction and state name resolution.
• PLITBLM — The PL/SQL integer table type used for in-memory list handling within the package logic.

Usage Notes

PAY_AC_UTIL is not an end-user API and is not invoked directly from standard payroll forms. Its documented consumers are Oracle Discoverer workbooks and ad hoc reporting queries, where the functions are called inline within SQL SELECT lists to resolve codes into names, format dates, and map balances. Because the package is referenced by five other packages, customizations that extend or call these functions should treat the signatures as stable but note that the body dates from an early release lineage; behavior should be validated during upgrade from 12.1.1 to 12.2.2. Any custom code calling GET_JURISDICTION_NAME or the related geographic functions must supply valid US jurisdiction references, as the underlying lookups are limited to the US geographic tables. Direct DML is not performed by this package.