Search Results chk_basic_data_cutover_crit

Overview

PQP_GB_PSI_BASIC_DATA is a GB-localized PL/SQL package that supports the Pensions Service Interface (PSI) extract process for the United Kingdom legislative context. It assembles the basic data payload required by pension scheme reporting, drawing person, assignment, bank and payment details from the HRMS and Payroll schema. The package explicitly pins its legislation context via g_legislation_code per_business_groups.legislation_code%TYPE := 'GB' and maintains an internal effective date and extract type to drive period- and cutover-based selection criteria.

The package is classified in ETRM as an OTHER API, meaning it is not published as a general integration entry point but is instead an internal engine invoked by the broader PSI extraction and post-processing flow. It exposes global state used by its own processing routines, including g_business_group_id and g_assignment_id (both deliberately initialised NULL), g_person_id, person and assignment rowtype buffers, and reporting flags such as g_bank_detail_report_y_n and g_bank_details_found. The header comment for the shared global setter notes that values such as g_paypoint, g_cutover_date and g_ext_dfn_id are established by the internal set_shared_globals routine before extraction begins.

Key Procedures and Functions

• BASIC_EXTRACT_MAIN — the primary driver that orchestrates the basic data extract, iterating the relevant population and emitting the PSI output rows.
• CHK_BASIC_DATA_CUTOVER_CRIT — evaluates cutover-specific criteria to determine whether a record qualifies for extraction at the cutover point.
• CHK_BASIC_DATA_PERIODIC_CRIT — evaluates periodic criteria for the standard recurring extract cycle.
• BASIC_DATA_POST_PROCESSING — performs follow-up handling after the main extract, applying any adjustments or derivations required before output is finalised.
• DEBUG, DEBUG_ENTER, DEBUG_EXIT, DEBUG_OTHERS — instrumentation routines gated by hr_utility.debug_enabled, used to trace entry, exit and exception paths during diagnostics.

Tables Accessed

The package reads (and in places writes) through APPS synonyms:

• PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F — core person and assignment records, with date-effective filtering bounded by the extract effective date.
• PER_CONTACT_RELATIONSHIPS — associated contact/relationship data relevant to scheme membership.
• PAY_EXTERNAL_ACCOUNTS and PAY_PERSONAL_PAYMENT_METHODS_F — bank and payment method details, driving the bank detail reporting flags.
• HR_LOCATION_EXTRA_INFO — source of location codes via the PQP_GB_PENSERV_LOCATION_INFO information type.
• PLITBLM — the standard EBS PL/SQL table used for bulk DML and message handling.

Usage Notes

PQP_GB_PSI_BASIC_DATA is invoked indirectly as part of the UK pensions PSI concurrent and post-processing flow rather than being called from a form. It is referenced by no other documented packages, confirming its role as a leaf-level implementation package. Custom code should not call the API routines directly; instead, values such as g_paypoint, g_cutover_date and g_ext_dfn_id are established internally through set_shared_globals prior to execution. Debug output is available by enabling hr_utility.debug_enabled, which activates the DEBUG family of routines through the g_debug global.