Search Results get_pay_value

Overview

APPS.PQP_PENSION_EXTRACTS is a PL/SQL package that supports the extraction of pension-related data from Oracle E-Business Suite for external reporting, regulatory filing, and third-party pension administration. It forms part of the Oracle Payroll legislative framework, primarily oriented toward the pension extract functionality delivered for specific localizations such as the United Kingdom and Ireland. The package collates assignment, payroll action, balance, and element entry information and formats it into extract records that conform to a definable extract structure.

The package spec declares several global variables that carry processing context across subprogram calls, including the concurrent request ID (g_conc_request_id), legislation code, assignment action ID, action effective date and type, balance dimension ID, extract record ID, business group, person ID, and a counter for total detail lines. It also defines a ValTabTyp collection type for handling value columns drawn from ben_ext_rslt_dtl, and an extract_params record type capturing the full parameter set passed from the concurrent program, including dates, element and payroll identifiers, organization, and benefit action context. These structures reflect a design that balances driver-driven extracts with a session-based parameter store.

Key Procedures and Functions

The documented interface exposes seventeen named subprograms. Their purpose, as documented, is summarised below.

• PENSION_EXTRACT_PROCESS — The primary driver procedure that orchestrates the end-to-end pension extract, invoking the supporting getters and writing output to the result tables.
• GET_ELEMENT_ENTRY_VALUE — Retrieves element entry values for an assignment, supplying the payroll inputs required for pension eligibility and contribution calculations.
• GET_SIT_SEGMENT — Returns the State/Insurance/Other third-party or legislative segment value associated with the extract, used to populate segment-specific output fields.
• GET_DDF_DF_VALUE — Resolves a value from a defined balance or data definition factor, feeding derived figures into the extract.
• GET_BALANCE_VALUE — Fetches payroll balance values for the participant over the extract period.
• GET_CONCPROG_INFORMATION — Obtains the concurrent program parameter information supplied by the user at submission.
• GET_PARTICIPANT_STATUS_CODE — Derives the participant status code used to classify the person within the pension scheme.
• GET_PAY_VALUE — Returns a monetary value from the payroll calculation relevant to the extract line.
• GET_DATA_ELEMENTS — Gathers the data elements that define the extract layout and content.
• GET_PAYROLL_DATE — Determines the payroll run or period date applicable to the assignment action.
• CHECK_ASG_ACTIONS — Validates that the assignment has the required payroll actions for inclusion in the extract.
• CHK_PERSON_ASG — Confirms the person and assignment combination is valid and eligible.
• PENSION_CRITERIA_FULL_PROFILE — Applies the full-profile eligibility criteria against the participant.
• DEL_SERVICE_DETAIL_RECS — Removes prior service detail records to prevent duplication before re-processing.
• GET_CURRENT_EXTRACT_RESULT — Returns the current extract result header record.
• GET_CURRENT_EXTRACT_PERSON — Returns the current person being processed within the extract run.
• RAISE_EXTRACT_WARNING — Emits a warning, typically by writing to the concurrent request log and result output, when non-fatal issues are encountered.

Tables Accessed

The package reads and writes through APPS synonyms. Extract definition and record metadata reside in BEN_EXT_DFN, BEN_EXT_RCD, and BEN_PERSON_ACTIONS, while output is persisted in BEN_EXT_RSLT and BEN_EXT_RSLT_DTL. Person, assignment, and organizational context comes from HR_ALL_ORGANIZATION_UNITS and HR_LOCATIONS_ALL. Payroll inputs are sourced from PAY_ASSIGNMENT_ACTIONS, PAY_BALANCE_DIMENSIONS, PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES, PAY_CONSOLIDATION_SETS, PAY_ELEMENT_SETS, PAY_ELEMENT_TYPES_F, and PAY_INPUT_VALUES_F.

Usage Notes

PQP_PENSION_EXTRACTS is normally invoked indirectly by the pension extract concurrent program rather than called directly from forms. Developers extending or troubleshooting extracts should invoke the driver procedure through the concurrent manager so that request ID, legislation, and parameter context are populated correctly. Custom code may call individual getter functions such as GET_SIT_SEGMENT or GET_BALANCE_VALUE, but must initialise the relevant globals and the g_extract_params collection first. No other packages are documented as referencing this package, confirming its role as a top-level consumer.