Search Results init_st_end_date_glob
Overview
PQP_GB_PSI_FUNCTIONS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM "OTHER" API category. It supports the United Kingdom pension scheme interface (PSI) processing used by Oracle Payroll and Oracle Advanced Benefits. The package header declares several debug control globals — including g_debug, g_debug_timestamps, g_debug_entry_exits_only, and g_debug_flag — and is bound with AUTHID CURRENT_USER, meaning all SQL executes under the privileges of the calling schema. The header carries a source control stamp acknowledging the 12.1.1/12.2.2 code line, confirming it is a long-standing component rather than a recent addition.
Key Procedures and Functions
The package exposes roughly fifty documented procedures and functions. The debug group — CHECK_DEBUG, DEBUG, DEBUG_ENTER, DEBUG_EXIT, and DEBUG_OTHERS — is the most relevant to users searching for "check_debug". CHECK_DEBUG inspects the session's debug state and the global debug flag; DEBUG emits a formatted message; DEBUG_ENTER and DEBUG_EXIT bracket procedure calls with nest-level tracing; and DEBUG_OTHERS records an unexpected exception so that it surfaces in the debug stream rather than failing silently. Together they provide the instrumentation layer for the rest of the package.
Date and contract handling is performed by INIT_ST_END_DATE_GLOB, GET_START_END_DATE, and GET_CONTRACT_TYPE. Pay values are returned by GET_NOTIONAL_PAY and GET_ACTUAL_PAY. Eligibility and scheme setup are resolved through CHECK_EMPLOYEE_ELIGIBILITY, CHK_PENSERVER_BASIC_CRITERIA, and GET_CONFIG_TYPE_VALUES. The driving extract process is PQP_PENSERVER_EXTRACT, supported by SET_SHARED_GLOBALS, and by the exception routines STORE_EXTRACT_EXCEPTIONS and RAISE_EXTRACT_EXCEPTIONS. The helper routines ALTKEY, PAYPOINT, and EMPLOYER_CODE return the specific identifiers that the pension scheme interface requires.
Tables Accessed
The package reads and writes across several EBS schemas via APPS synonyms. Extract definition and results come from BEN_EXT_DFN, BEN_EXT_RSLT, and BEN_BENEFIT_ACTIONS. Employee and assignment data are drawn from PER_ALL_ASSIGNMENTS_F and the assignment actions table PAY_ASSIGNMENT_ACTIONS. Payroll elements and their inputs are read from PAY_ELEMENT_TYPES_F, PAY_ELEMENT_TYPE_EXTRA_INFO, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_ENTRIES_F, PAY_INPUT_VALUES_F, and PAY_RUN_RESULTS / PAY_RUN_RESULT_VALUES. Run control is obtained from PAY_PAYROLL_ACTIONS, and concurrent program information from FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_REQUESTS.
Usage Notes
The package is typically invoked from the Penserver extract concurrent program and from related payroll processes. Because CHECK_DEBUG reads session state, its output depends on the caller's environment — the debug flag is not persisted in the database, so results differ between concurrent runs, forms sessions, and ad hoc SQL*Plus calls. Thirteen dependent packages call these routines, so changes to signatures should be treated as API-level modifications. Developers extending the extract should enable tracing through CHECK_DEBUG before adding custom logic, and should let DEBUG_OTHERS capture unhandled exceptions to preserve the stack trace.