Search Results adv_ee_subpriority




Overview
Explore in AI Chat

Overview

PAY_ADVANCE_PAY_ELE_PKG is a supporting PL/SQL package in the Oracle E-Business Suite Payroll (PAY) module. Its business purpose is to resolve the subpriority value assigned to element entry records when those entries represent advance or deduction processing. Within Oracle Payroll, element entries are written to PAY_ELEMENT_ENTRIES_F with a subpriority that governs the order in which entries are processed during a payroll run. Advance and deduction entries require special ordering rules that can differ by legislation, and this package centralizes the logic that determines the correct subpriority for such entries.

The package is classified in ETRM as an "OTHER" API, meaning it is an internal utility rather than a public, supported extension interface. It is referenced by three other packages, indicating that it is a shared dependency invoked by higher-level payroll processing code rather than being called directly by end users or external integrations.

Key Procedures and Functions

  • GET_SUBPRIORITY — The single documented function in the package. It returns the subpriority value to be used for an element entry. The function accepts a legislation code, a creator type, and a fallback subpriority value, and it determines the applicable subpriority according to the following rules:
    • If the creator type is not 'AE' (advance entry) or 'AD' (deduction entry), the passed-in subpriority is returned unchanged. This preserves standard ordering for ordinary element entries.
    • If the legislation code matches the cached legislation code, the previously derived and cached subpriority is returned without re-querying. This caching avoids repeated lookups during processing of many entries for the same legislation.
    • Otherwise, the value is derived by querying the legislation rules and is then cached along with the legislation code for reuse.
    • If no matching rule is found, the passed-in subpriority is returned as the default.

The function therefore implements both legislation-specific rule resolution and a simple in-session cache keyed on legislation code.

Tables Accessed

  • PAY_LEGISLATION_RULES — Read by the internal cursor that resolves the subpriority. The package queries this table filtering on the legislation code and on a rule type of 'ADV_EE_SUBPRIORITY', converting the rule's RULE_MODE value into a numeric subpriority. This is the table from which the functional configuration is derived.
  • PAY_ELEMENT_ENTRIES_F — Referenced as the source of the SUBPRIORITY datatype returned by the function. The function's return type is anchored to pay_element_entries_f.subpriority%TYPE, ensuring the returned value is type-compatible with the element entries table that ultimately consumes it.

Only PAY_LEGISLATION_RULES is actually queried; PAY_ELEMENT_ENTRIES_F is used for datatype anchoring rather than data access.

Usage Notes

This package is invoked internally during payroll element entry creation and processing, particularly when advance or deduction entries are generated and their subpriority must be aligned with legislation-specific rules. Because the function caches values in package-level globals (the legislation code and derived subpriority), it is best suited to a session that processes many entries for a common legislation, which is typical of a payroll run or a bulk element entry load.

Typical invocation contexts include payroll processing packages and element entry creation routines that are among the three packages referencing this one. The package is not exposed as a form-level or concurrent program API. Developers customizing payroll element entry logic should treat it as an internal utility, respecting the 'AE' and 'AD' creator-type conventions and the ADV_EE_SUBPRIORITY rule type configured in PAY_LEGISLATION_RULES. Because the value is cached after the first derivation for a given legislation, changes to the legislation rule during the same session will not be reflected.