Search Results get_payroll

Overview

APPS.PAY_PAYFV_ELEMENT_ENTRIES_PKG is a supporting PL/SQL package body created for the Oracle E-Business Suite Payroll (PAY) product family. Its stated purpose, taken from the source header, is "to return non-id table information where needed to enhance the performance of the view." The package exists to service the BIS view PAY_PAYFV_ELEMENT_ENTRIES, which presents element entries with descriptive attributes resolved from their underlying identifier columns. Rather than forcing the view to perform repeated joins to translation and validation tables, the view delegates those lookups to lightweight functions inside this package, allowing each identification value to be converted to its user-facing name on demand.

The package was introduced in January 2001 and subsequently revised to comply with Multi-Org security and Multi-Language Support requirements. Revision 115.1 removed the "_all" suffix from table references so that the required row-level security is applied automatically, and revisions 115.2 and 115.3 enabled MLS translation for grade name and job name respectively. The object is classified under ETRM as "OTHER" rather than as a public or private API, reflecting its role as an internal view-support utility.

Key Procedures and Functions

ETRM documents six functions, all of which accept an identifier and return a descriptive string. Each function follows the same defensive pattern: the lookup is performed in a single SELECT, and any exception is trapped so that a NULL value is returned rather than propagating an error into the calling view.

• GET_JOB — Resolves a job identifier into the job name. It is implemented against PER_JOBS_VL, the MLS-enabled view, so that the name is returned in the session's language.
• GET_POSITION — Resolves a position identifier into the position name, reading from PER_POSITIONS.
• GET_GRADE — Resolves a grade identifier into the grade name, reading from PER_GRADES_VL, which is also MLS-enabled.
• GET_LOCATION — Resolves a location identifier into the location description.
• GET_PAY_BASIS — Returns the descriptive name of the pay basis associated with an element entry, translating the stored basis code into readable text.
• GET_PAYROLL — Returns the payroll name corresponding to a payroll identifier. This function is the object most frequently sought by users searching for "get_payroll," since it supplies the human-readable payroll label used by the PAY_PAYFV_ELEMENT_ENTRIES view.

Tables Accessed

ETRM records two tables accessed through APPS synonyms: HR_LOCATIONS_ALL_TL, which supplies the translated location description used by GET_LOCATION, and PER_PAY_BASES, which provides pay basis information for GET_PAY_BASIS. Consistent with the header note in revision 115.1, the remaining lookups are directed at security-enabled or MLS-enabled views — PER_JOBS_VL, PER_POSITIONS, and PER_GRADES_VL — rather than base tables, ensuring that row-level security and language translation are applied at the source. The package performs read-only access; it does not insert, update, or delete data, and it maintains no state between calls.

Usage Notes

PAY_PAYFV_ELEMENT_ENTRIES_PKG is not intended to be invoked directly by end users or external integrations. It is referenced by one other documented package and is consumed primarily as a function-based column source within the PAY_PAYFV_ELEMENT_ENTRIES view. In practice, the functions execute whenever that view is queried — for example by Oracle Payroll inquiry forms, BIS or HRMS reporting views, or custom SQL written against the view. Because every function traps exceptions and returns NULL, a missing or unsecured reference degrades to an empty column value rather than a runtime error, which keeps reporting queries resilient. Custom code should treat these functions as internal helpers and rely on the view itself; the functions remain available for pre-12.1.3-style view definitions but are not subject to the compatibility guarantees of a published PL/SQL API.