Search Results update_sel_flg

Overview

GHR_MASS_SEL_NOA is an Oracle EBS HRMS package owned by APPS that supports the mass processing of Nature of Action (NOA) records within the Oracle Public Sector / Federal HRMS footprint. It coordinates the selection, preview, validation, and application of personnel actions against a population of employees identified through mass salary processing criteria. The package is declared AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the calling user rather than the defining user, and raises a package-level exception, mnoa_error, to signal business-rule failures during mass NOA execution.

The package name reflects its functional scope: mass selection (MASS_SEL) of employees for Nature of Action processing. It bridges concurrent-program execution with the underlying HR datastructures for assignments, positions, grades, duty stations, extra information, and PA request history. As defined, it is not referenced by any other package, indicating that it functions as a top-level driver rather than a shared library routine.

Key Procedures and Functions

• EXECUTE_MNOA — Primary entry point for mass NOA processing. Receives the mass salary identifier and an action code, and returns standard concurrent-program status parameters (errbuf, retcode).
• EXECUTE_MCANCEL — Counterpart to EXECUTE_MNOA introduced under Bug 14467215, handling cancellation of mass processing for a given mass salary identifier and action.
• FETCH_AND_VALIDATE_EMP — Retrieves employee and assignment attributes (name, national identifier, employee number, assignment, person, position, grade, business group, location, organization, duty station, personnel office, and related NOA fields) and validates them for eligibility. Includes OUT parameters for resolved personnel office, organization structure, position title, position number, and sequence number.
• UPDATE_SEL_FLG — Updates the selection flag that marks which employees or records are included in the mass NOA transaction; this is the routine most directly related to the user's search term.
• CHECK_SELECT_FLG — Validates the state of the selection flag, supporting decision logic before the flag is consumed or reset.
• REFRESH_EI_DETAILS — Refreshes extra information (EI) detail rows associated with PA requests, keeping shadow and live extra-information records synchronized.
• GET_EXTRA_INFO_COMMENTS — Retrieves comments stored against extra information records for inclusion in generated actions or previews.
• INS_UPD_PER_EXTRA_INFO — Inserts or updates person-level extra information records.
• GET_LAC_DTLS — Returns legal authority code (LAC) detail information used in constructing the NOA.
• PURGE_PROCESSED_NOA_RECS — Cleans up previously processed NOA records, typically as a maintenance step following successful completion.
• PR — Internal helper procedure referenced in the documented procedure list.

Tables Accessed

The package reads and writes through APPS synonyms. Mass processing metadata is drawn from GHR_MASS_SALARIES and GHR_MASS_SALARY_CRITERIA, with preview rows managed in GHR_MASS_NOA_PREVIEW and GHR_MASS_NOA_PREVIEW_S. Employee and assignment context is resolved from GHR_DUTY_STATIONS_F in addition to the PER_* assignment and people views implied by the parameter anchors. Nature-of-action and family reference data come from GHR_NATURE_OF_ACTIONS, GHR_NOA_FAMILIES, GHR_FAMILIES, and GHR_GROUPBOXES.

Transaction and history records are held in GHR_PA_REQUESTS and GHR_PA_HISTORY, while extra information and its shadow copies reside in GHR_PA_REQUEST_EXTRA_INFO, GHR_PA_REQUEST_EXTRA_INFO_S, and GHR_PA_REQUEST_EI_SHADOW. FND_SESSIONS provides session context for concurrency and change tracking.

Usage Notes

GHR_MASS_SEL_NOA is typically invoked from a concurrent program registered against EXECUTE_MNOA or EXECUTE_MCANCEL, where the mass salary identifier and action are passed as submission parameters. It may also be called from Oracle Forms-based mass NOA or mass salary selection windows that manipulate the selection flag through UPDATE_SEL_FLG and CHECK_SELECT_FLG. Custom extensions should call the package entry points rather than the internal procedures, and must observe the package exception mnoa_error to capture business validation failures. Because EXECUTE_MCANCEL arrived via Bug 14467215, environments below that patch level will not expose the cancellation path.