Search Results update_shadow_row

Overview

GHR_MASS_CON_PROGRAM is a server-side PL/SQL package owned by the APPS schema within the Oracle E-Business Suite. It belongs to the Oracle Human Resources product family and supports mass processing of person and assignment-related statutory actions, most notably furlough and redundancy-related changes handled through the Government Human Resources (GHR) legislative framework. The package encapsulates the logic required to derive a nature-of-action driven process, resolve the appropriate legislative action codes (LAC) for a given pay plan and effective date, generate descriptive remarks on the underlying action requests, and orchestrate the work performed by a concurrent program. Its declaration uses AUTHID CURRENT_USER, meaning that at runtime all unqualified database object references execute with the privileges of the invoking schema rather than the package owner.

Key Procedures and Functions

The package exposes a set of documented procedures and functions that together perform the mass consultancy action lifecycle:

• GET_FURLOUGH_RTD_LAC — Returns the first-level legislative action codes and related information for furlough and related termination-of-employment scenarios, based on the nature of action, pay plan, and effective date supplied by the caller.
• CREATE_REMARKS — Builds and inserts the descriptive remarks associated with a person's action request, drawing on the person identifier, PA request, work schedule, and legislative parameters.
• MAIN_CONCURRENT_PROGRAM — The primary entry point invoked by the concurrent program. It receives the standard concurrent manager errbuf and retcode parameters together with the effective date and nature-of-action inputs, and controls the overall processing run.
• BUILD_RPA — Constructs the underlying human-resources action (RPA) records required to effect the requested change for each person in the mass process.
• GET_PA_REQUEST_ID_OVN — Resolves the identifier of the PA request associated with a given person or process context, supplying the key used by downstream remark and shadow-row logic.
• MARPA_PROCESS — Performs the comprehensive processing of the action request, coordinating the derivation, insertion, and updating steps of the mass run.
• CREATE_SHADOW_ROW — Inserts rows into the shadow tables that stage extra information prior to the final action submission.
• UPDATE_SHADOW_ROW — Modifies previously created shadow rows to reflect the resolved values for the person, element entry, or extra information record.

Tables Accessed

The package reads and writes the following documented tables through public synonyms. Nature-of-action and pay-plan configuration data is drawn from GHR_NATURE_OF_ACTIONS and GHR_PAY_PLANS. The core business records reside in GHR_PA_REQUESTS, GHR_GROUPBOXES, GHR_PA_REMARKS, and GHR_PA_ROUTING_HISTORY, with supporting staging handled by GHR_PA_REQUEST_SHADOW and GHR_PA_REQUEST_EI_SHADOW and their corresponding extra-information tables GHR_PA_REQUEST_EXTRA_INFO and GHR_PA_REQUEST_EXTRA_INFO_S. Payroll information is referenced through PAY_ELEMENT_ENTRY_VALUES_F. Person and assignment data is retrieved from PER_PERSON_TYPES, PER_ASSIGNMENT_STATUS_TYPES, PER_PEOPLE_EXTRA_INFO, and PER_ASSIGNMENT_EXTRA_INFO.

Usage Notes

GHR_MASS_CON_PROGRAM is normally invoked from the GHR mass-action concurrent program rather than called directly from forms. The concurrent manager supplies the effective date and nature-of-action arguments to MAIN_CONCURRENT_PROGRAM, which then drives the remaining procedures. The shadow-row procedures follow a create-then-update pattern that lets the process stage partial request data before final validation. Because the package is documented as referenced by zero other packages and is classified as OTHER, it is not a published public API; customizations that call it directly should treat it as an internal implementation and validate behaviour after any patch or upgrade, particularly across 12.1.1 and 12.2.2 where table and synonym definitions may differ.