Search Results pay_no_advance_pay

Overview

APPS.PAY_NO_ADVANCE_PAY is a PL/SQL package body in the Oracle E-Business Suite (EBS) Payroll (PAY) module, valid in both 12.1.1 and 12.2.2. Its business function is to implement the "no advance pay" rule logic that governs whether an employee is permitted to receive advance payments during a payroll run. Advance pay is the practice of paying an employee prior to the normal payroll processing date, and organizations frequently need to suppress or skip that payment based on eligibility, assignment status, or other payroll criteria. This package encapsulates the decision rule used to skip advance payment, positioning it as a rule-enforcement utility rather than a general-purpose payroll API.

The package is classified as OTHER in the ETRM documentation, meaning it is not a published, supported public API but an internal component used by payroll processing. It depends on PAY_ADVANCE_PAY_ELE_PKG, indicating it integrates with the advance pay element handling logic, and it is not referenced by any other database object, confirming its role as a leaf-level rule implementation invoked internally.

Key Procedures and Functions

The documented package exposes a single procedure or function: ADV_PAYMENT_SKIP_RULE. Consistent with the ETRM metadata, its purpose is to evaluate and apply the rule that determines whether an advance payment should be skipped. It embodies the "no advance pay" condition — when the rule evaluates such that advance pay is disallowed, the payment is bypassed. Because no parameter list is documented, the exact signature should not be assumed; the procedure is invoked as part of the advance pay processing flow and works together with the element entry and payroll action records to reach its determination. No other procedures or functions are documented for this package.

Tables Accessed

The package references two documented base tables through APPS synonyms:

• PAY_ELEMENT_ENTRIES_F — the element entries table, which stores the payroll element entries assigned to employees. ADV_PAYMENT_SKIP_RULE reads this table to inspect existing advance pay element entries and determine whether an advance payment is present or pending, supporting the skip decision.
• PAY_PAYROLL_ACTIONS — the payroll actions table, which records payroll run actions and their status. The rule consults payroll action context to associate the advance pay decision with the correct payroll run or action.

It additionally depends on the APPS.PAY_ADVANCE_PAY_ELE_PKG package, which supports advance pay element processing, and on SYS.STANDARD for standard PL/SQL constructs.

Usage Notes

PAY_NO_ADVANCE_PAY is an internal payroll component. It is not referenced by any other database object, so it is not exposed as a callable API for external or custom code. In practice, it is invoked within the Oracle Payroll advance pay processing flow, typically triggered when a payroll run or QuickPay processes advance payments and the system must evaluate whether the advance pay rule prohibits payment. Administrators do not call this package directly from forms; rather, its logic is reached through the standard payroll processing path that relies on advance pay element handling. When troubleshooting advance pay behavior — for example, an employee who should not have received an advance payment but did — this package and its ADV_PAYMENT_SKIP_RULE procedure are relevant diagnostic objects. Because it is classified OTHER and is undocumented as a public interface, customizations should not call it directly; instead, the supported extension points in Oracle Payroll should be used. Any change to this package body would be applied through a patch or customization and should be treated as a modification to core payroll rule logic.