Search Results hr_payments




Overview
Explore in AI Chat

Overview

APPS.HR_PAYMENTS is a PL/SQL package body in the Oracle E-Business Suite (EBS) APPS schema that provides utility and validation logic supporting payment processing within the Oracle Payroll and Oracle Human Resources modules. In releases 12.1.1 and 12.2.2, the package serves as an internal helper library invoked during payroll payment setup, prepayment handling, and payment method configuration. It centralises reusable checks for currency, accounts, balances, and prepayments so that higher-level payroll processes and forms present consistent validation and derivation behaviour. The object is marked VALID and classified as OTHER in ETRM documentation, indicating it is not a public open interface or standard business API but rather a supporting internal package. It is referenced by six other packages, confirming its role as a downstream dependency for payment-related processing logic.

Key Procedures and Functions

The documented package exposes thirteen procedures and functions. Their names indicate validation and derivation responsibilities:

  • PPT_BRUI — supports payment type related processing, likely validating or deriving payment type attributes.
  • MATCH_CURRENCY — verifies currency consistency across payment-related entities.
  • CHECK_ACCOUNT — validates external or organisational payment accounts.
  • CHECK_CURRENCY — performs currency validation against defined currency rules.
  • GEN_BALANCE — derives or generates balance information used in payment evaluation.
  • CHECK_PREPAY — validates prepayment records and their eligibility.
  • CHECK_PPM — checks personal payment method configuration.
  • CHECK_DEFAULT — identifies or validates default payment method and account settings.
  • CHECK_AMT — validates payment amounts against defined thresholds or rules.
  • MT_CHECKS — groups multiple validation checks, likely for multi-record or multi-currency scenarios.
  • UNIQUE_PRIORITY — ensures payment method priorities remain unique.
  • CHECK_PP — validates payroll payment or prepayment parameters.

These routines are invoked internally to enforce data integrity before payment records are committed.

Tables Accessed

HR_PAYMENTS reads from a set of PAY schema tables accessed through APPS synonyms, including PAY_ASSIGNMENT_ACTIONS, PAY_BALANCE_DIMENSIONS, PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES, PAY_EXTERNAL_ACCOUNTS, PAY_ORG_PAYMENT_METHODS_F, PAY_PAYMENT_TYPES, PAY_PAYROLL_ACTIONS, PAY_PERSONAL_PAYMENT_METHODS_F, PAY_PRE_PAYMENTS, and PAY_PSS_TRANSACTION_STEPS. It also references DUAL for scalar evaluation and utility packages FND_DATE, FND_MESSAGE, HR_UTILITY, HR_PAYMENTS (self-reference), and STANDARD. The payment method and account tables supply configuration data for validation, while balance and defined balance tables support amount and balance checks. Prepayment and transaction step tables underpin prepayment validation logic.

Usage Notes

HR_PAYMENTS is not intended for direct external invocation. It is typically called from Oracle Payroll forms, concurrent programs, and other payroll packages that manage payment methods, external accounts, and prepayments. Customisations should avoid calling this package directly and instead rely on supported public APIs, since internal signatures may change between releases and patches. Administrators reviewing payment validation errors should treat this package as part of the underlying payroll engine, with its dependencies on FND_MESSAGE indicating user-facing error messaging during validation failures.