Search Results get_element_details

Overview

PAY_FI_ARCHIVE_PSTA is the body of a PL/SQL package owned by APPS that supports the Finnish (FI) localization of Oracle Payroll for archival processing. Its central purpose is to identify, extract, and preserve payroll results and related legislative data for a completed payroll period so that statutory records are retained and can be reported or audited after normal purge activity. The header comment ($Header: pyfipsta.pkb 120.1 2010/10/27) confirms the package is a localization component rather than a core payroll engine object.

Architecturally the package follows the standard Oracle Payroll "payroll action" model. It exposes range, assignment action, initialization, and archive entry points that a report or concurrent program calls in sequence, together with helper functions for retrieving legislative parameters, resolving country names, and reading balance values. Global variables declared at the top of the body (g_business_group_id, g_legal_employer_id, g_payroll_id, g_pay_period_id, g_element_details-related context values, and so on) carry state across those phases within a single session.

The object is classified in ETRM as OTHER and is referenced by zero other packages, indicating it is not a general-purpose API consumed by the rest of the application, but rather a self-contained archival utility.

Key Procedures and Functions

• GET_PARAMETER — Retrieves a single named token from the legislative parameter string of a payroll action, with an optional segment number to select a positional value from a delimited string.
• GET_ALL_PARAMETERS — Populates all global parameter variables from the payroll action's legislative parameters in one pass.
• RANGE_CODE — Executes during the range phase of the payroll action, establishing the set of assignments (or other driving rows) the archive run must process.
• ASSIGNMENT_ACTION_CODE — Executes per assignment action, applying the archive logic to the payroll results of an individual assignment.
• INITIALIZATION_CODE — Performs one-time setup for the archive run, validating parameters and initializing globals before processing begins.
• ARCHIVE_CODE — Provides the main archive driver, coordinating the sequence of archival steps.
• ARCHIVE_DATA — Writes the extracted payroll and legislative data to the archive structures.
• ARCHIVE_PERSON_ADDRESS_DETAILS — Archives address information for the persons in scope, which is required for Finnish statutory reporting.
• GET_COUNTRY_NAME — Returns the country name for a given country code, used to populate archived output.
• GET_BALANCE_VALUE — Reads the value of a specified balance for an assignment or element entry at the time of archival.

Tables Accessed

The package reads and writes against a defined set of tables, all reached through APPS synonyms:

• HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, HR_SOFT_CODING_KEYFLEX — resolve legal employer and local unit identity, names, and Finnish business identifiers such as the employer number.
• PAY_ALL_PAYROLLS_F — supplies payroll and payroll type information for the period being archived.
• PAY_ASSIGNMENT_ACTIONS and PAY_ASSIGNMENT_ACTIONS_S — hold the assignment-level payroll run results that the archive extracts.
• PAY_ACTION_INFORMATION and PAY_ACTION_INTERLOCKS — store run metadata and control interlocking between concurrent payroll actions.
• PAY_BALANCE_TYPES, PAY_BALANCE_CATEGORIES_F, PAY_BALANCE_DIMENSIONS, PAY_DEFINED_BALANCES — support balance definition lookup and the GET_BALANCE_VALUE function.
• PAY_ELEMENT_CLASSIFICATIONS — used with element detail resolution.
• FF_DATABASE_ITEMS and FF_GLOBALS_F — provide Fast Formula database item and global value metadata.

These tables collectively allow the package to translate an internal payroll run into a fully described statutory archive record.

Usage Notes

PAY_FI_ARCHIVE_PSTA is invoked as part of an Oracle Payroll payroll action, typically initiated from a Finnish statutory archival concurrent program. The concurrent program submits a payroll action, and the Oracle Payroll action framework calls RANGE_CODE, ASSIGNMENT_ACTION_CODE, INITIALIZATION_CODE, and ARCHIVE_CODE at the appropriate points in the action lifecycle. Because the package is not referenced by any other package in ETRM, it is not intended as a reusable API for custom code; customizations should call it only through the same payroll action mechanism.

Debug tracing is controlled by HR_UTILITY.DEBUG_ENABLED, with locations written via HR_UTILITY.SET_LOCATION. In EBS 12.1.1 and 12.2.2 the package behaves identically; the 12.2 online patching editioning model has no separate edition-specific version noted for this object. When investigating the "get_element_details" search term, note that no procedure of that exact name exists in the documented interface — element detail resolution is handled inside the ARCHIVE_DATA and GET_BALANCE_VALUE logic using PAY_ELEMENT_CLASSIFICATIONS and the Fast Formula tables.