Results for “get_job”

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

Overview

PAY_PAYFV_ELEMENT_ENTRIES_PKG is an Oracle EBS PL/SQL package owned by the APPS schema that supports the Payroll FastFormula (PAYFV) element entries infrastructure. Its role is to provide runtime resolution services for employee assignments and payroll attributes that are required when Payroll FastFormula element entries are processed. In the Oracle Payroll and Human Resources architecture, FastFormula calculations frequently require contextual values — such as an employee's job, position, grade, work location, pay basis, or payroll — that are not stored directly on the element entry record. This package supplies those values through discrete accessor functions, shielding calling code from the underlying multi-table joins against HR and Payroll base entities.

The package status is documented as VALID in the ETRM metadata for both EBS 12.1.1 and 12.2.2, and it is classified as OTHER, meaning it is not a public open-interface API intended for external integration, but rather an internal utility package used by Oracle's own Payroll FastFormula components.

Key Procedures and Functions

The ETRM documents six accessor routines within this package. Their names reflect the payroll and HR attribute each one resolves for a given element entry context:

• GET_JOB — Returns the job associated with the employee assignment context for the element entry being evaluated.
• GET_POSITION — Returns the position associated with the assignment context.
• GET_GRADE — Returns the grade associated with the assignment context.
• GET_LOCATION — Returns the work location associated with the assignment context, resolving against the location tables.
• GET_PAY_BASIS — Returns the pay basis applicable to the element entry, resolving against the pay basis reference table.
• GET_PAYROLL — Returns the payroll to which the assignment belongs for the element entry context.

These routines are invoked individually to supply FastFormula input values or element entry validation logic. Parameter signatures are not enumerated here; callers should reference the package specification via a descriptor query against ALL_ARGUMENTS or the ETRM "show dependent code" link for exact argument lists.

Tables Accessed

The documented table references are relatively narrow relative to the breadth of the accessor functions, indicating that many of the routines derive their values through joins or through parent packages rather than direct SQL against base tables. The ETRM lists:

• PER_PAY_BASES — The base table underlying the payroll pay basis definition, used by GET_PAY_BASIS to resolve the pay basis code or identifier linked to the element entry.
• HR_LOCATIONS_ALL_TL — The translatable location table, used by GET_LOCATION to return the location name or identifier in the appropriate language for the resolving context.

Other attributes such as job, position, grade, and payroll are typically resolved indirectly through Human Resources and Payroll views or through referenced packages, which is consistent with the dependency list showing references to the SYS.STANDARD package and being referenced by PAYFV_ELEMENT_ENTRIES and by the package itself.

Usage Notes

PAY_PAYFV_ELEMENT_ENTRIES_PKG is an internal supporting package. It is referenced by the PAYFV_ELEMENT_ENTRIES object and by one other package within APPS, meaning it is normally invoked transitively during element entry processing rather than being called directly from forms menus or concurrent program definitions. In practice, it executes within the context of Payroll FastFormula evaluation — for example when element entry rules, formula results, or payroll run processing require HR attribute resolution for an assignment.

Customizations should not call this package directly for new integrations; Oracle does not expose it as a supported open API. Where equivalent attribute resolution is needed in custom code, the recommended path is to use documented HR and Payroll open interfaces or the underlying HR_ and PER_ views directly. Any dependency on this package should be treated as subject to change across patch levels, and a descriptor query is recommended before adoption. Validated as VALID in both 12.1.1 and 12.2.2, the package remains stable but its ETRM classification against OTHER confirms it is a background dependency rather than a public interface.