Search Results g_max_end_date

Overview

APPS.PAY_DB_PAY_US_GROSS is a PL/SQL package in the Oracle EBS Payroll (PAY) application, declared with AUTHID CURRENT_USER. It supports the payroll gross-up and indirect element feature set used by US payroll processing. Gross-up functionality is employed when an employer absorbs an employee's tax liability on a payment, requiring the system to compute additional earnings so that the net disbursement reaches a specified target after tax deductions. The package creates and maintains the element, formula, input value, result rule, and status processing rule definitions that make this calculation possible. Version history in the header dates to 1996, with later error-handling additions, reflecting the package's long-standing role in the payroll data model.

The package also declares several public constants and types. These include g_default_start_date, g_todays_date, g_max_end_date, g_max_elnum, and collection types such as ElemTabType, InputTabType, ResultTabType, UOMTabType, and RsltPrefixType. The constant g_max_end_date, set to 31/12/4712, represents the standard EBS "end of time" date used whenever a definition is created with no finite effective end date. The variable the user searched for—g_max_end_date—is therefore a global constant rather than a procedure parameter.

Key Procedures and Functions

The documented API surface consists of seven callable objects:

• CREATE_VERTEX_ELEMENT_NAMES — a procedure that populates the internal collection holding Vertex gross-up element names, alongside associated input value, result rule, and unit of measure names used by subsequent processing.
• CREATE_GROSS_UP — a function that constructs a gross-up definition for a specified element, classification, reporting name, formula, and priority, accepting business group and effective date parameters. It returns a numeric status.
• DELETE_GROSS_UP — a procedure that removes an existing gross-up definition, identified by business group and element name.
• CREATE_LINKED_ELEMENTS — a function that creates the linked element definitions associated with a gross-up, operating in a mode that defaults to 'Grossup'.
• CREATE_INDIRECT_LINK — a procedure that establishes indirect element links, enabling one element's results to drive the processing of another.
• CREATE_STATUS_PROC_RULE — a procedure that defines status processing rules, controlling how payroll run results are processed for the created elements.
• CREATE_RESULT_RULE — a procedure that creates formula result rules, mapping formula outputs back to element input values or balances.

Tables Accessed

The package operates across the core payroll definition tables: PAY_ELEMENT_TYPES_F, PAY_ELEMENT_TYPES_F_TL, PAY_INPUT_VALUES_F, PAY_INPUT_VALUES_F_TL, PAY_FORMULA_RESULT_RULES_F, PAY_FORMULA_RESULT_RULES_S, PAY_STATUS_PROCESSING_RULES_F, and PAY_STATUS_PROCESSING_RULES_S. It also references FF_FORMULAS_F and FF_FORMULA_TYPES for formula definitions, and PER_ASSIGNMENT_STATUS_TYPES for assignment status handling. These tables are reached through APPS synonyms. Writes are concentrated in the element, input value, and rule tables, which carry the definitions the gross-up calculation requires.

Usage Notes

PAY_DB_PAY_US_GROSS is not referenced by any other documented package, indicating it is an entry-point API rather than a shared library. It is typically invoked during payroll setup or by custom code that programmatically provisions gross-up elements, rather than from a standard concurrent program or form. The presence of both g_default_start_date and g_max_end_date confirms that definitions created through the API are dated with wide effective ranges unless explicitly bounded. Implementers integrating with this package should treat g_max_end_date and the other globals as read-only constants, since they are declared without setters and are intended to supply default date boundaries for the creation routines.