Search Results get_sub_element_code_pos_title

Overview

GHR_MLC_PKG is an Oracle EBS Human Resources package owned by the APPS schema and classified under ETRM as an OTHER API. Its name reflects its central role in supporting the Mass Labor Cost (MLC) and Mass Salary (MSL) processing flows within Oracle Human Resources and, by extension, Oracle Payroll. The package orchestrates the calculation, validation, and persistence of mass salary and labor cost adjustments applied to groups of employees identified through mass salary criteria and mass action preview records. It governs eligibility determination, extracts selection data from mass salary requests and personnel action requests, manages extra information comments stored against positions and persons, and submits concurrent requests to drive downstream processing. Because mass salary and mass labor cost adjustments frequently intersect with statutory benefits and consent-driven workflows — the context in which users search for the "non MLC consent form" — the package also handles eligibility checks that determine whether a person qualifies for a given pay plan or action before a salary mass update is committed.

Key Procedures and Functions

The package exposes 34 documented procedures and functions. The principal orchestrators are EXECUTE_MLC and EXECUTE_MSL_PAY, both of which accept a mass salary identifier and an action code and serve as the entry points for mass labor cost and mass salary payment processing respectively. SUBMIT_CONC_REQ provides a generic facility for submitting concurrent requests with argument passing, and PURGE_PROCESSED_RECS and PURGE_OLD_DATA remove stale or already-processed staging records. POP_DTLS_FROM_PA_REQ populates detail rows from personnel action requests. Inquiry functions include GET_PAY_PLAN_NAME, GET_USER_TABLE_NAME, GET_FROM_SF52_DATA_ELEMENTS, GET_SUB_ELEMENT_CODE_POS_TITLE, and GET_OTHER_DTLS_FOR_REP, which retrieve reference and reporting data. Eligibility logic is handled by CHECK_INIT_ELIGIBILITY, CHECK_ELIGIBILITY, CHECK_ELIGIBILITY_MTC, PERSON_IN_PA_REQ_1NOA, and PERSON_IN_PA_REQ_1NOA_MTC, along with CHECK_SELECT_FLG and UPDATE_SEL_FLG, which manage selection flag state. Extra information maintenance is provided by INS_UPD_PER_EXTRA_INFO and GET_EXTRA_INFO_COMMENTS. The package also declares the named exceptions mlc_error and mtc_error to signal processing failures within the mass labor cost and mass timecard streams.

Tables Accessed

The package reads and writes across a broad set of HR and payroll tables through APPS synonyms. The GHR_MASS_SALARIES, GHR_MASS_SALARY_CRITERIA, GHR_MASS_SALARY_CRITERIA_EXT, and GHR_MASS_ACTIONS_PREVIEW tables hold the mass salary definitions, selection criteria, and preview results that drive processing. GHR_PA_REQUESTS and GHR_PA_HISTORY support personnel action request integration. PER_POSITION_EXTRA_INFO stores the extra information comments managed by INS_UPD_PER_EXTRA_INFO and GET_EXTRA_INFO_COMMENTS. Reference and eligibility lookups draw on GHR_DUTY_STATIONS_F, GHR_FAMILIES, GHR_NOA_FAMILIES, GHR_NATURE_OF_ACTIONS, GHR_LOCALITY_PAY_AREAS_F, and GHR_PAY_PLANS, while PAY_USER_TABLES provides user-defined lookup values. GHR_PA_REMARKS and GHR_FAMILIES complete the set used for annotation and grouping.

Usage Notes

GHR_MLC_PKG is typically invoked from the Oracle HRMS mass salary and mass labor cost concurrent programs, from the associated self-service and professional forms that present eligibility and consent outcomes, and from custom PL/SQL that needs to validate or apply mass salary adjustments. Three other packages reference it, indicating reuse within the HR mass processing stack. It is not a public, supported API and should be treated as an internal implementation object; customizations should call the underlying concurrent programs or supported HR APIs wherever possible, and any direct invocation should be version-aware across 12.1.1 and 12.2.2.