Search Results process_family




Overview
Explore in AI Chat

Overview

GHR_SF52_DO_UPDATE is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite and declared with AUTHID CURRENT_USER. It belongs to the Oracle Human Resources (GHR/HRMS) product family and forms part of the Standard Form 52 (SF52) processing infrastructure used by U.S. federal agencies. SF52 is the U.S. Office of Personnel Management form used to request personnel actions such as hires, promotions, reassignments, and separations. Within Oracle EBS, the SF52-related GHR packages support the generation, submission, and processing of these personnel action requests against an underlying HRMS data model.

This particular package is oriented toward updating and processing SF52-related data records. It is invoked as part of the broader personnel action request lifecycle, where a request captured in GHR_PA_REQUESTS flows through validation, extra information collection, and family-specific processing. The package coordinates the population of request data, extra information attributes, salary and non-salary components, and the application of the appropriate processing method for a given nature of action family.

The package header references shared record and array types declared in GHR_API, including ASG_SF52_TYPE, ASG_NON_SF52_TYPE, ASG_NTE_DATES_TYPE, PER_SF52_TYPE, PER_GROUP1_TYPE, PER_GROUP2_TYPE, PER_SCD_INFO_TYPE, PER_RETAINED_GRADE_TYPE, PER_PROBATIONS_TYPE, PER_SEP_RETIRE_TYPE, PER_SECURITY_TYPE, PER_SERVICE_OBLIG_TYPE, PER_CONVERSIONS_TYPE, PER_BENEFIT_INFO_TYPE, PER_UNIFORMED_SERVICES_TYPE, POS_OBLIG_TYPE, POS_GRP1_TYPE, POS_GRP2_TYPE, POS_VALID_GRADE_TYPE, POS_CAR_PROG_TYPE, PERFORMANCE_APPRAISAL_TYPE, CONDUCT_PERFORMANCE_TYPE, and LOC_INFO_TYPE. These correspond to assignments, persons, positions, and location information that make up an SF52 request.

Key Procedures and Functions

  • PROCESS_FAMILY — Drives processing for a specific nature of action family. It accepts an in/out record of GHR_PA_REQUESTS%ROWTYPE and an agency code, allowing family-level rules to be applied to the request being updated.
  • CALL_EXTRA_INFO_API — Invokes the extra information API, passing the request record together with the many SF52, non-SF52, person, position, and location typed parameters. It serves as the bridge between the request and the GHR_PA_REQUEST_EXTRA_INFO structure and remark data.
  • PROCESS_SALARY_INFO — Handles the salary components of an SF52 request, including pay plan and waiting period related data.
  • PROCESS_NON_SALARY_INFO — Handles the non-salary components of an SF52 request, complementing the salary processing path.
  • GET_WGI_DATES — Retrieves Within-Grade Increase (WGI) dates, which are required for determining eligibility and effective dates of certain personnel actions.
  • GENERIC_UPDATE_SIT — Performs generic updates associated with the SF52 processing flow, based on the request and its associated family processing method.

Tables Accessed

The package references several APPS synonyms. GHR_PA_REQUESTS is the parent personnel action request table and is read and updated throughout. GHR_FAMILIES, GHR_NATURE_OF_ACTIONS, GHR_NOA_FAMILIES, and GHR_NOA_FAM_PROC_METHODS define the nature of action families and the processing methods applied to each, supporting the PROCESS_FAMILY logic. GHR_PA_DATA_FIELDS, GHR_PA_HISTORY, GHR_PA_INCENTIVES, GHR_PA_REMARKS, GHR_PA_REQUEST_EXTRA_INFO, and GHR_REMARKS store the detailed attributes, history, incentives, and remarks attached to a request. GHR_PAY_PLANS and GHR_PAY_PLAN_WAITING_PERIODS supply pay plan configuration and waiting period rules used during salary processing. FND_ID_FLEX_STRUCTURES and FND_ID_FLEX_STRUCTURES_TL provide key flexfield structure metadata, often required when validating or populating descriptive flexfield segments on request records.

Usage Notes

GHR_SF52_DO_UPDATE is typically invoked indirectly rather than by end users directly. It is called from the SF52 request processing flow, which may be launched through the Federal HR forms or through concurrent programs that submit personnel actions for processing. Because the package depends on shared GHR_API types and expects a populated GHR_PA_REQUESTS record, custom code should only call it after a valid request row exists and after the necessary extra information and family context have been established. The package is referenced by at least one other package within the application, confirming its role as a subordinate processing unit. Site-specific extensions should respect the AUTHID CURRENT_USER declaration and the expected in/out parameter conventions to avoid corrupting request or history data.