Search Results get_asg_status

Overview

PAY_RETRO_NOTIF_PKG is an Oracle E-Business Suite payroll package owned by the APPS schema and classified under the ETRM "OTHER" API category. Its business purpose is to support retroactive pay notification processing within Oracle Payroll. When an element entry or payroll run is back-dated and a retroactive recalculation is triggered, the payroll engine must be able to identify affected assignments, resolve the applicable element and event information, and notify or report on the resulting retroactive adjustments. This package provides the procedural infrastructure for that workflow, including the assignment-level entry point, the cursor and action-creation routines required for a payroll action (batch) driver, and helper functions that retrieve assignment and element attributes at a given report date.

The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than as definer, so callers must themselves hold the necessary privileges on the referenced PAY and HR objects. The header ($Header: payretno.pkh 120.2 2011/10/11) confirms the package was maintained through the 12.1.x release family and carried forward into 12.2.x.

Key Procedures and Functions

• RUN_ASG_ADV_RETRONOT — The primary public entry point. It drives retroactive notification processing for a single assignment within a business group, accepting a start timestamp and an optional event group.
• RUN_DEBUG — A diagnostic variant that runs the same processing over a date range for a given business group and assignment, exposing row-count and advance-flag controls for troubleshooting.
• GET_ASG_INFO — Returns assignment status and person name for a given assignment, report date, business group, and legislation code.
• GET_ELE_INFO — Returns the element name associated with an element entry at a specified report date.
• GET_PERSON_NAME and GET_ASG_STATUS — Individual accessors for the person name and assignment status attributes surfaced by GET_ASG_INFO.
• RANGE_CURSOR — Builds the SQL cursor string used by the payroll action driver to select the population for processing.
• ACTION_CREATION — Creates the assignment action rows for a chunk of the selected population, bounded by start and end person identifiers.
• ARCHINIT — Initialises archive/working structures for a given payroll action identifier.
• PROCESS_ACTION — Processes a single assignment action at a supplied effective date.
• DEINITIALISE — Cleans up package state for a payroll action on completion.
• GENERATE_DATES_AND_PROCESS — Introduced under Bug 13083098 (Quick-Retropay changes) to generate retroactive date ranges and process the assignment accordingly.
• INITIALISE_GLOBALS — Also introduced under Bug 13083098, this procedure sets package-level global variables for an event group before the Quick-Retropay processing path is executed. It is the routine most frequently referenced when searching for this package, because it establishes the shared state used by the subsequent date-generation and processing logic.

Tables Accessed

The package reads and writes payroll and HR tables through APPS synonyms. PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, and PAY_ASSIGNMENT_ACTIONS_S underpin the payroll action driver (RANGE_CURSOR, ACTION_CREATION, ARCHINIT, PROCESS_ACTION, DEINITIALISE). PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F, and PAY_ELEMENT_TYPES_F_TL supply element entry, link, and translated element name data used by GET_ELE_INFO. PAY_EVENT_GROUPS, PAY_EVENT_UPDATES, PAY_DATETRACKED_EVENTS, and PAY_DATED_TABLES support event-group scoping, datetracking, and the INITIALISE_GLOBALS state used by Quick-Retropay. HR_ASSIGNMENT_SETS, HR_ASSIGNMENT_SETS_S, and HR_ASSIGNMENT_SET_AMENDMENTS define the assignment populations selected by the action driver, while FND_CONCURRENT_REQUESTS links processing to the concurrent request that initiated it.

Usage Notes

PAY_RETRO_NOTIF_PKG is not a general-purpose public API; it is invoked internally by the payroll action framework and by retroactive notification concurrent programs. The RANGE_CURSOR / ACTION_CREATION / PROCESS_ACTION / DEINITIALISE quartet is the standard Oracle Payroll batch-driver idiom, meaning these procedures are called by the payroll action processing engine rather than directly by end users. RUN_ASG_ADV_RETRONOT and RUN_DEBUG provide assignment-level and diagnostic invocation points, typically from a concurrent program or a supporting form. Because the package is AUTHID CURRENT_USER and referenced by zero other packages in the ETRM inventory, custom code invoking it directly must supply valid assignment, business group, and event group identifiers and must respect the payroll action context. The Bug 13083098 procedures (GENERATE_DATES_AND_PROCESS and INITIALISE_GLOBALS) are specific to the Quick-Retropay enhancement and should be treated as the current processing path in 12.1.1 and 12.2.2 installations where that fix has been applied.