Results for “other_non_separate_check”

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

Overview

HR_US_FF_UDFS is an Oracle EBS Applications (APPS) schema PL/SQL package that provides a shared library of "user-defined functions" (UDFs) and utility routines supporting United States payroll processing and Oracle FastFormula evaluation. The package resides in the APPS schema with VALID status and is classified as an OTHER API, meaning it is an internal support package rather than a formally published public API. Its name reflects its role: HR (Human Resources), US (United States localization), FF (FastFormula), and UDFS (user-defined functions).

In practice, HR_US_FF_UDFS consolidates reusable logic that FastFormulas, payroll processes, and other US payroll packages call when they require standardized answers to common questions — determining hours worked, validating jurisdictions, resolving deduction frequencies, identifying separate checks, or computing overtime base rates. By centralizing these rules, Oracle ensures consistent behavior across the many US payroll elements, formulas, and reports that depend on them.

Key Procedures and Functions

ETRM documents 18 procedures and functions in the package. Notable members include:

• CONVERT_PERIOD_TYPE — translates a period type value into the representation expected by payroll frequency logic.
• STANDARD_HOURS_WORKED — returns the standard hours worked for an assignment, supporting element and formula calculations.
• WORK_SCHEDULE_TOTAL_HOURS — derives total scheduled hours from a work schedule, frequently used in accrual and proration logic.
• CHAINED_ELEMENT_EXISTS — checks whether a chained element exists for a given context, allowing formulas to branch conditionally.
• US_JURISDICTION_VAL — validates a US jurisdiction (state, locality, or tax authority) value.
• GET_PROCESS_RUN_FLAG — retrieves a flag indicating the state of a payroll process run.
• CHECK_DEDN_FREQ and DEDN_FREQ_FACTOR — validate deduction frequencies and return the associated frequency factor used in arrears and proration calculations.
• SEPARATE_CHECK_SKIP and OTHER_NON_SEPARATE_CHECK — support logic for separate and non-separate payment handling within a payroll run.
• OT_BASE_RATE — determines the base rate used for overtime calculations.
• ARREARAGE — supports arrears processing logic for deductions and balances.
• ADDR_VAL — validates address-related data used in US payroll and tax processing.
• PAY_US_COUNTRY — returns or validates the country context for US payroll operations.
• CATCHUP_TYPE_DETAILS — returns details related to catch-up contribution processing.
• DIRECT_FED_DATA_ARCHIVED — indicates whether direct federal data has been archived, relevant to tax reporting.

Parameter lists are intentionally omitted; callers should reference the installed package specification for exact signatures.

Tables Accessed

The package reads and writes a defined set of tables through APPS synonyms, primarily payroll and FastFormula metadata. FF_FORMULAS_F, FF_DATABASE_ITEMS, and FF_ARCHIVE_ITEMS support FastFormula definition and archival lookups. PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_CLASSIFICATIONS, PAY_ELEMENT_ENTRIES_F, and PAY_ELEMENT_ENTRY_VALUES_F provide element configuration and entry value access. PAY_ELE_PAYROLL_FREQ_RULES, PAY_FREQ_RULE_PERIODS, and PAY_ASSIGNMENT_ACTIONS support frequency, period, and assignment-level processing. HR_SOFT_CODING_KEYFLEX, HR_ORGANIZATION_INFORMATION, FND_TERRITORIES_TL, and FND_SESSIONS supply key flexfield, organization, territory, and session context data.

Usage Notes

HR_US_FF_UDFS is referenced by 21 other packages, including HR_US_FF_UDF1, HR_US_PYZIPCHK, HR_US_REPORTS, PAY_AC_UTILITY, PAY_PAYMIX_LINE_INSERT, PAY_US_CITY_PKG, PAY_US_EMP_TAX_RULES_PKG, PAY_US_INV_DED_FORMULAS, PAY_US_ITERATIVE_VALUES, PAY_US_MMREF_FUNCTION_PKG, PAY_US_RULES, PAY_US_SQWL_ERROR, PAY_US_TAX_BALS_ADJ_API, and PAY_US_TAX_BALS_ADJ_PKG. It is invoked from US payroll FastFormulas, concurrent payroll processes, and custom code that requires standardized US payroll utility logic. Because it is an internal package rather than a formally published API, customizations should call it with caution and validate behavior against each patch level in 12.1.1 or 12.2.2.