Search Results get_source_element_type

Overview

PAY_RETRO_PKG is the core PL/SQL package body that implements Oracle Payroll's retroprocessing engine in Oracle E-Business Suite 12.1.1 and 12.2.2. Retroprocessing occurs when a payroll event is processed for a past period that has already been closed; the payroll engine must recalculate the affected assignment's pay, identify the difference between what was originally paid and what should now be paid, and generate the appropriate balance adjustments. PAY_RETRO_PKG provides the procedural logic that drives this cycle, from creating the retro run and its assignment-level entries through to writing adjustment run results and maintaining the retro assignment and retro entry records that persist this history.

The package is classified as OTHER in the ETRM metadata and exposes twenty-seven documented procedures and functions. It is referenced by four other packages, indicating a foundational role within the payroll processing stack rather than an end-user-facing API. The documented revision history shows active maintenance around Bug 7335351 (2008) covering recorded-date processing and overlap adjustments, and around Bug 5747560 (2006–2007) for GET_SOURCE_ELEMENT_TYPE, the object most directly associated with the user's search term.

Key Procedures and Functions

• RETRO_RUN_PROC / RETRO_END_PROC — Entry and termination points for a retro run, establishing and closing out the retro processing context for the payroll action.
• PROCESS_RETRO_ENTRY / PROCESS_VALUE / PROCESS_RETRO_VALUE — Logic that reads and computes values for retro entries and their associated entry values.
• IS_RETRO_ENTRY / IS_RETRO_RR — Predicate functions determining whether a given entry or run result is retro-related.
• GET_RR_SOURCE_ID / GET_RR_SOURCE_TYPE — Return the source identifier and source type for a retro run result, linking the adjustment back to its originating entry.
• GET_REPROCESS_TYPE / GET_RETRO_PROCESS_TYPE — Classify the reprocessing and retro process type; the revision history notes GET_REPROCESS_TYPE was changed to use PAY_PROC_ENVIRONMENT business group and legislation context.
• GET_SOURCE_ELEMENT_TYPE — Identifies the element type of the source element that generated the retro adjustment. This function underwent multiple revisions (Bugs 5747560 and others in 2006–2007) to correctly resolve element classification for retro calculations.
• GET_RETRO_ELEMENT / GET_RETRO_COMPONENT_ID — Resolve the retro element and its retro component identifier used to drive the adjustment.
• GET_EE_OVERLAP_DATE — Determines the overlap date for an employee where multiple assignments exist; a 2006 fix corrected its join to the retro assignments table in multi-assignment environments.
• LATEST_REPLACE_OVL_EE / LATEST_REPLACE_OVL_DEL_EE — Manage replacement and deletion of the latest overlap employee records.
• MAINTAIN_RETRO_ENTRY — Creates and maintains retro entry rows, including updates to RETRO_COMPONENT_ID.
• MERGE_RETRO_ASSIGNMENTS — Consolidates retro assignment records.
• GENERATE_OBJ_GRP_ACTIONS — Generates the object group actions required to drive retro processing through the payroll action framework.

Tables Accessed

The package operates across the payroll and element entry data model. It reads and writes PAY_RETRO_ASSIGNMENTS to track assignments subject to retroprocessing, and PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_ENTRY_VALUES_F to obtain and adjust element entry values. PAY_ELEMENT_TYPES_F, PAY_ELEMENT_TYPE_RULES, PAY_ELE_CLASSIFICATION_RULES and PAY_INPUT_VALUES_F supply element definitions, classification and input value rules used by GET_SOURCE_ELEMENT_TYPE and related resolution logic. PAY_ELEMENT_SPAN_USAGES and PAY_ENTRY_PROCESS_DETAILS support span and process-detail determination. Payroll action and assignment action context is drawn from PAY_PAYROLL_ACTIONS, PAY_PAYROLL_ACTIONS_S, PAY_ASSIGNMENT_ACTIONS and PAY_ASSIGNMENT_ACTIONS_S, while PAY_OBJECT_GROUPS supports group generation. PAY_RECORDED_REQUESTS is used by reset_recorded_request and process_recorded_date logic, with the revision history noting a TO_CHAR conversion on assignment ID to enable index usage.

Usage Notes

PAY_RETRO_PKG is invoked internally by the Oracle Payroll processing engine during retro runs, typically triggered through the payroll run concurrent programs and the payroll action framework rather than called directly by end users. It supports the retro processing flow initiated from Payroll forms and from scheduled payroll runs. Customizations should avoid direct calls to its procedures; instead, integrations should rely on supported payroll APIs. When troubleshooting retro issues, GET_SOURCE_ELEMENT_TYPE and the process_recorded_date routines are frequent diagnostic points, as evidenced by the volume of bug fixes applied across 2006–2008.