Search Results next_month

Overview

APPS.PAY_SG_EXC is a payroll legislation package body within Oracle E-Business Suite 12.1.1 and 12.2.2 that supports Singapore (SG) statutory payroll processing. Its documented purpose is to contain the expiry checking code associated with the Singapore balance dimensions. Following Oracle's transition to the latest balance functionality, the expiry checking routines that were formerly embedded in balance definitions were migrated into packaged procedures so that they could be invoked consistently by the payroll engine rather than duplicated across balance dimension logic.

The package header comment identifies it as a payroll (Oracle*Payroll) component, originally authored to mirror the equivalent US legislation package PAYUSEXC. It exposes no public functions in the traditional API sense; instead, the documented entry points are called by the payroll calculation engine and by other balance-related components. The package is classified in ETRM as an OTHER API type and is referenced by two other packages, confirming it is an internal supporting library rather than a standalone business API.

Key Procedures and Functions

The documented executable units include helper date functions and the exported expiry-checking routines:

• next_month — Given a date, returns the date of the first day of the next month. Implemented as trunc(add_months(p_date,1),'MM'). This function was the subject of the user's search and is used to advance a date to the beginning of the following month when computing expiry boundaries for monthly balance dimensions.
• next_period — Given a date and a payroll action identifier, returns the date of the day immediately following the end of the pay period that contains the supplied date. It derives this by joining PER_TIME_PERIODS to PAY_PAYROLL_ACTIONS on payroll_id and payroll_action_id.
• next_quarter — Given a date, returns the first day of the next calendar quarter, computed by adding three months and truncating to the month boundary.
• DATE_EC — The documented expiry-checking entry point associated with SG balance dimensions. It evaluates a supplied date against the relevant expiry rule for the Singapore legislation and returns the result consumed by balance processing.
• GET_EXPIRY_DATE — Retrieves the applicable expiry date for a Singapore balance dimension, resolving the dimension and defined balance configuration to determine when accumulated balances cease to be valid.
• CALCULATED_VALUE — Returns the calculated expiry or balance value used by the balance dimension definition, encapsulating the numeric derivation logic that would otherwise reside in the balance definition itself.

Tables Accessed

The package reads from the following documented tables through APPS synonyms:

• PER_TIME_PERIODS — Supplies pay period start and end dates used by next_period to locate the containing period for a given date and payroll action.
• PAY_PAYROLL_ACTIONS — Links a payroll action identifier to its payroll, enabling the period lookup in next_period.
• PAY_BALANCE_DIMENSIONS — Provides the Singapore balance dimension definitions whose expiry rules are being evaluated.
• PAY_DEFINED_BALANCES — Provides defined balance configuration referenced when resolving the expiry date for a dimension.
• PAY_ASSIGNMENT_ACTIONS — Supports assignment-level context for expiry evaluation during payroll runs.
• HR_ORGANIZATION_INFORMATION — Supplies organization-level legislative or configuration information relevant to SG payroll processing.

Usage Notes

PAY_SG_EXC is not a user-facing API and is not invoked from a form or concurrent program directly. It is called by the payroll balance engine and by the two packages documented as referencing it, typically during balance dimension expiry evaluation at the time a payroll run, balance adjustment, or balance initialization is processed for Singapore legislation. Because the routines are packaged rather than embedded in the balance definition, any custom code or extension that needs to align with Oracle's native SG expiry behaviour should call the packaged functions rather than reimplement the date arithmetic. The next_month helper in particular is a straightforward date utility that custom developers frequently reference when building SG-specific expiry logic of their own.