Search Results per_hu_emp_cert_archive




Overview
Explore in AI Chat

Overview

APPS.PER_HU_EMP_CERT_ARCHIVE is a PL/SQL package declared with AUTHID CURRENT_USER, indicating that its SQL executes under the privileges of the invoking schema rather than the package owner. The package belongs to the Human Resources (PER) product family and, based on its name and procedure set, supports the Hungarian localizations for employee certification archiving. It is a business-group-aware archival utility that gathers payroll action context, derives a set of person and assignment records within a specified effective-date range, resolves employee address information, and writes the resulting extract data into the archive tables associated with a payroll action. The package header identifies a version dating from 2004, confirming that it is a legacy HRMS component retained for backward compatibility across EBS 12.1.1 and 12.2.2. It is classified under the ETRM "OTHER" API classification, meaning it is not a public, supported extension point; it is an internal implementation package invoked by the Hungarian employee certification concurrent program and associated payroll processes.

Key Procedures and Functions

The package exposes seven documented program units. GET_PARAMETER is a function that parses a delimited parameter string and returns the value of a named token, providing the generic parameter-decoding capability used throughout the payroll action framework. GET_ALL_PARAMETERS is a procedure that accepts a payroll action identifier and returns, as output parameters, the business group, start and end dates, payroll identifier, and issue date that define the scope of an archival run. RANGE_CODE is a procedure that receives an action identifier and returns a SQL fragment used to constrain the population of persons processed by the action. ACTION_CREATION_CODE is a procedure that creates the assignment action rows for a payroll action across a chunked range of persons, bounded by start and end person identifiers.

ARCHIVE_CODE is the main archival driver, accepting an assignment action identifier and an effective date to perform the actual extraction and storage of certification data. GET_PERSON_ADDRESS is a procedure that, given a person identifier, assignment action identifier, assignment identifier, termination date, and effective date, resolves and processes the address information for the employee being archived. GET_EMPLOYEE_DATA is a procedure that, for a given assignment action identifier and effective date, returns the assignment identifier, person identifier, and end date, serving as the row-level data fetch that feeds the archival logic. Together these units implement a standard Oracle HRMS payroll action lifecycle: parameter resolution, range selection, action creation, and archiving.

Tables Accessed

The package reads and writes a broad set of HRMS and payroll tables through APPS synonyms. Organizational data is drawn from HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, HR_LOCATIONS_ALL, and HR_SOFT_CODING_KEYFLEX, supporting the resolution of employing legal entity, location, and key flexflexfield context. Payroll action and assignment processing uses PAY_PAYROLL_ACTIONS, PAY_ACTION_INFORMATION, PAY_ASSIGNMENT_ACTIONS, and PAY_ASSIGNMENT_ACTIONS_S. Element and entry data comes from PAY_ELEMENT_TYPES_F, PAY_ELEMENT_TYPE_EXTRA_INFO, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, and PAY_INPUT_VALUES_F. Payment and external account details are sourced from PAY_PERSONAL_PAYMENT_METHODS_F and PAY_EXTERNAL_ACCOUNTS. These tables collectively provide the employee, assignment, payroll, element, and payment context required to produce a complete certification archive record.

Usage Notes

PER_HU_EMP_CERT_ARCHIVE is not intended for direct invocation from custom code. It is called by the Hungarian employee certification archival concurrent program, which supplies the payroll action identifier that drives GET_ALL_PARAMETERS, RANGE_CODE, ACTION_CREATION_CODE, and ultimately ARCHIVE_CODE. Because the package is declared AUTHID CURRENT_USER and is classified as OTHER rather than a public API, Oracle does not guarantee its signature across releases; implementers who reference the package directly, particularly GET_PERSON_ADDRESS in address-related customizations, should treat the header as version-specific and validate against the installed 12.1.1 or 12.2.2 patch level before relying on it.