Search Results ghr_process_log_s

Overview

GHR_MASS_AWARDS_PKG is a VALID PL/SQL package body owned by the APPS schema in Oracle EBS 12.1.1 and 12.2.2. It supports the Oracle HRMS (GHR) mass awards business process, which allows an organization to grant the same or similar awards — special act or service awards, time-off awards, or similar recognition actions — to a large group of employees in a single administrative operation. The package orchestrates the end-to-end processing of a mass award request: it evaluates employee eligibility, materializes award detail rows, computes award amounts and leave accrual (LAC) values, writes the resulting personnel action (PA) requests and shadow records, and logs processing outcomes.

The mass awards flow is a companion to the broader GHR mass actions infrastructure. It depends on the GHR_MASS_ACTIONS_PKG, GHR_API, and GHR_PA_REQUESTS_PKG families, and it writes to processing log and request shadow tables so that the resulting PA requests can be reviewed, routed, and approved through the standard HRMS personnel action framework.

Key Procedures and Functions

The package exposes 19 documented procedures and functions. Their responsibilities fall into several groups:

Setup and lookup helpers: GET_NOA_CODE_DESC, GET_NOA_ID, GET_BUSINESS_GROUP, and GET_PA_REQUEST_ID_OVN resolve reference data — nature of action (NOA) codes and IDs, the business group context, and existing PA request identifiers — needed to build award requests.
Award detail builders: GET_AWARD_DETAILS, GET_AWARD_LAC, and GET_AWARD_DETAILS_SHADOW retrieve or construct the award amounts, leave accrual calculations, and shadow representations for each eligible employee. REFRESH_AWARD_DETAILS recalculates detail rows after changes.
Eligibility management: UPD_ELIG_FLAG_BEF_SELECTION sets the eligibility flag before selection, and DEL_ELIG_FLAG_AFT_SELECTION clears it after the awards have been generated, keeping the eligibility staging data clean.
Core processing: MAIN_AWARDS is the principal driver that executes the mass award run. MARPA_PROCESS and BUILD_RPA_FOR_MASS_AWARDS build the resulting personnel action requests for the selected population. MASS_AWARDS_ERROR_HANDLING centralizes error capture and logging. CHECK_AWARD_AMOUNT validates award amounts against applicable rules.
Shadow and remark handling: CREATE_SHADOW_ROW and UPDATE_SHADOW_ROW maintain the shadow copies of PA requests and their extra information. SET_EI populates extra information segments, and CREATE_REMARKS writes remarks to the PA remarks table.

Tables Accessed

The package reads and writes only through APPS synonyms. It writes award and eligibility staging data to GHR_MASS_AWARDS. It creates and updates personnel action requests in GHR_PA_REQUESTS and maintains mirror copies in GHR_PA_REQUEST_SHADOW, GHR_PA_REQUEST_EI_SHADOW, and GHR_PA_REQUEST_EXTRA_INFO (with sequence GHR_PA_REQUEST_EXTRA_INFO_S). Remarks are written to GHR_PA_REMARKS, routing history to GHR_PA_ROUTING_HISTORY, and processing log entries to GHR_PROCESS_LOG_S — the object frequently resolved when users search for "ghr_process_log_s". Reference data is read from GHR_NATURE_OF_ACTIONS and GHR_GROUPBOXES, and assignment-level extra information is read from PER_ASSIGNMENT_EXTRA_INFO. Dependencies also reference HR_LOCATIONS, PER_ASSIGNMENTS_F, PER_PEOPLE_F, HR_POSITIONS_F, GHR_DUTY_STATIONS_V, GHR_PAR_EXTRA_INFO_API, GHR_PAR_UPD, GHR_PAY_CALC, GHR_PA_REMARKS_API, GHR_SF52_API, GHR_WGI_PKG, and HR_API.

Usage Notes

GHR_MASS_AWARDS_PKG is not referenced by any other database object and is typically invoked from the HRMS mass awards form or a concurrent program that drives a mass award run. It should not be called directly from custom code unless the full personnel action lifecycle — eligibility staging, shadow row creation, PA request generation, and process logging — is respected, since partial invocation will leave orphaned rows in GHR_MASS_AWARDS, GHR_PA_REQUEST_SHADOW, and GHR_PROCESS_LOG_S. Because the package is VALID and proprietary, modifications should be applied only through Oracle-supported patching.

SEQUENCE: HR.GHR_PROCESS_LOG_S 12.2.2
owner:HR, object_type:SEQUENCE, object_name:GHR_PROCESS_LOG_S, status:VALID,
SYNONYM: APPS.GHR_PROCESS_LOG_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:GHR_PROCESS_LOG_S, status:VALID,
SEQUENCE: HR.GHR_PROCESS_LOG_S 12.1.1
owner:HR, object_type:SEQUENCE, object_name:GHR_PROCESS_LOG_S, status:VALID,
SYNONYM: APPS.GHR_PROCESS_LOG_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:GHR_PROCESS_LOG_S, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.GHR_MASS_AWARDS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GHR_MASS_AWARDS_PKG, status:VALID,
PACKAGE BODY: APPS.GHR_PROC_FUT_MT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GHR_PROC_FUT_MT, status:VALID,
PACKAGE BODY: APPS.GHR_MTO_INT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GHR_MTO_INT, status:VALID,
PACKAGE BODY: APPS.GHR_PROC_FUT_MT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GHR_PROC_FUT_MT, status:VALID,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.GHR_MTO_INT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GHR_MTO_INT, status:VALID,
PACKAGE BODY: APPS.GHR_MASS_AWARDS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GHR_MASS_AWARDS_PKG, status:VALID,
PACKAGE BODY: APPS.GHR_WGI_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GHR_WGI_PKG, status:VALID,
PACKAGE BODY: APPS.GHR_PROCESS_SF52 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GHR_PROCESS_SF52, status:VALID,
PACKAGE BODY: APPS.GHR_WGI_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GHR_WGI_PKG, status:VALID,
TABLE: HR.GHR_PROCESS_LOG 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:GHR.GHR_PROCESS_LOG, object_name:GHR_PROCESS_LOG, status:VALID,
TABLE: HR.GHR_PROCESS_LOG 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:GHR.GHR_PROCESS_LOG, object_name:GHR_PROCESS_LOG, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.GHR_PROCESS_SF52 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GHR_PROCESS_SF52, status:VALID,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
APPS.GHR_MASS_AWARDS_PKG dependencies on GHR_PROCESS_LOG_S 12.1.1
APPS.GHR_PROCESS_SF52 dependencies on GHR_PROCESS_LOG_S 12.2.2
APPS.GHR_PROCESS_SF52 dependencies on GHR_PROCESS_LOG_S 12.1.1
APPS.GHR_WGI_PKG dependencies on GHR_PROCESS_LOG_S 12.2.2
APPS.GHR_MASS_AWARDS_PKG dependencies on GHR_PROCESS_LOG_S 12.2.2
APPS.GHR_PROC_FUT_MT dependencies on GHR_PROCESS_LOG_S 12.1.1
APPS.GHR_MTO_INT dependencies on GHR_PROCESS_LOG_S 12.1.1
APPS.GHR_WGI_PKG dependencies on GHR_PROCESS_LOG_S 12.1.1
APPS.GHR_MTO_INT dependencies on GHR_PROCESS_LOG_S 12.2.2
APPS.GHR_PROC_FUT_MT dependencies on GHR_PROCESS_LOG_S 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
eTRM - GHR Tables and Views 12.2.2
description: Routing List members detail ,
eTRM - GHR Tables and Views 12.1.1
description: Routing List members detail ,