Search Results set_ei

Overview

The APPS.GHR_NON_SF52_EXTRA_INFO package body is a component of the Oracle E-Business Suite HRMS (GHR) module, responsible for managing the "Extra Information" (EI) records associated with Non-SF52 nature-of-action (NOA) processing within the GHR_PA_REQUESTS personnel action framework. In Oracle EBS 12.1.1 and 12.2.2, the GHR schema supports statutory and administrative reporting requirements — most notably the SF52 (Standard Form 52, Request for Personnel Action) and its related Non-SF52 flows — and this package encapsulates the DML and retrieval logic for maintaining extra information attributes that accompany those actions.

The business purpose of this package is to allow the application to attach, refresh, and retrieve configurable data elements (Information 1 through Information N) to personnel actions, people, or NOA-specific contexts, without hard-coding business logic into individual forms or concurrent programs. It acts as a shared data-definition utility used across the GHR personnel action stack.

Key Procedures and Functions

The package exposes ten documented program units that were identified via the search term set_ei:

• POPULATE_NOA_SPEC_EXTRA_INFO — writes extra information records that are specific to a given nature of action.
• FETCH_NOA_SPEC_EXTRA_INFO — retrieves NOA-specific extra information for display or downstream processing.
• FETCH_GENERIC_EXTRA_INFO — retrieves non-NOA-specific (generic) extra information records.
• GET_INFORMATION_TYPE — resolves the information type definition governing an EI element.
• DETERMINE_OPERATION — evaluates the current row state to determine whether an insert, update, or delete operation is required.
• GENERIC_POPULATE_EXTRA_INFO — persists generic (non-NOA-specific) extra information.
• SET_EI — the central setter routine for extra information values; this is the entry point most commonly referenced by callers.
• DUAL_EXTRA_INFO_REFRESH — refreshes EI data across both shadow and primary EI tables.
• SET_DUAL_EI — writes EI values to both the primary and shadow structures in a coordinated manner.
• DELETE_EXTRA_INFO_REC — removes an extra information record.

The public procedure TERM_RET_GRADE also appears in the source excerpt, invoking grade-retention logic using cursors such as GET_ASSIGNEMNT_ID and C_702.

Tables Accessed

The package reads from and writes to:

• GHR_PA_REQUEST_EXTRA_INFO — the primary EI store for personnel action requests.
• GHR_PA_REQUEST_EI_SHADOW — a shadow table used during dual-write refreshes.
• GHR_NATURE_OF_ACTIONS and GHR_NOA_FAMILIES — to identify the NOA code driving EI requirements.
• GHR_PA_REQUESTS, GHR_PA_REQUEST_INFO_TYPES, GHR_FAMILIES, GHR_PAY_PLANS — for request context and classification.
• PER_PEOPLE_EXTRA_INFO and PER_ALL_ASSIGNMENTS_F — person-level EI and assignment lookups.
• PAY_ tables (element entries, input values, user tables) — used when grades or payroll elements are affected.
• FND_APPLICATION and FND_RESPONSIBILITY — for responsibility-based access control.

Usage Notes

This package is typically invoked from the GHR Personnel Action forms, from the SF52/Non-SF52 concurrent request flows, and from custom code extending the personnel action framework. It is referenced by five other packages, indicating shared reuse. Callers should treat SET_EI and SET_DUAL_EI as the primary mutation APIs and FETCH_* routines as the read APIs. Because the package performs DML without an autonomous commit in the excerpted code, callers are responsible for transaction control.