Search Results global_run_id

Overview

APPS.PSP_MATRIX_DRIVER_PKG is a PL/SQL package body that supports the PSP (Payroll Scheduling and Payments) Matrix Driver form in Oracle E-Business Suite 12.1.1 and 12.2.2. It is part of the Oracle Time and Labor / Payroll scheduling infrastructure used to drive a dynamic matrix display in the Schedule Matrix form. The package maintains a session-scoped working set of schedule rows in the PSP_MATRIX_DRIVER temporary table, keyed by a run identifier, so that multiple concurrent form sessions do not collide. The user search term "global_run_id" refers to the package-level global variable declared at the top of the body, populated by SET_RUNID from the PSP_LS_RUNID_S sequence, and used throughout to isolate each session's rows. The package also computes the beginning and ending time periods displayed across the matrix columns and exposes formatting helpers that return prompt and total strings to the form.

Key Procedures and Functions

• SET_RUNID — obtains the next value from the PSP_LS_RUNID_S sequence into the global run identifier that tags every row inserted by the current session.
• CLEAR_TABLE — removes all rows from PSP_MATRIX_DRIVER matching the current global run identifier; on the POST-FORM event it issues a COMMIT.
• SET_START_PERIOD / GET_START_PERIOD / GET_END_PERIOD — maintain and return the lower and upper bounds of the periods rendered in the dynamic matrix view.
• GET_MAX_PERIODS — returns the count of distinct schedule chunks, and by extension the number of columns in the matrix.
• GET_RUN_ID — exposes the current global run identifier to the form.
• GET_DYNAMIC_PROMPT — formats the start and end period of a given schedule chunk into the string displayed in the corresponding column prompt.
• GET_DYNAMIC_TOTALS — returns the dynamic total values shown in the matrix.
• LOAD_ORG_SCHEDULE / LOAD_TABLE_SCHEDULE / LOAD_TABLE / LOAD_ORGANIZATIONS — populate the temporary matrix driver table from organization, schedule, and payroll hierarchy sources.
• PURGE_TABLE — removes stale rows from the driver table.
• CHECK_EXCEEDENCE / CHECK_EXCEEDENCE_SC_COPY / CHECK_SCH_HIERARCHY — validate exceedence conditions and schedule hierarchy relationships before the matrix is displayed or processed.

Tables Accessed

The package reads and writes PSP_MATRIX_DRIVER, the temporary staging table holding session-specific matrix rows tagged by the global run identifier. PSP_LS_RUNID_S supplies the unique run identifier. Time period definitions come from PER_TIME_PERIODS, and schedule definitions and hierarchy relationships are resolved through PSP_DEFAULT_LABOR_SCHEDULES, PSP_SCHEDULE_HIERARCHY, and PSP_SCHEDULE_LINES. Payroll control and line data are read from PSP_PAYROLL_CONTROLS and PSP_PAYROLL_LINES. DUAL is used by SET_RUNID, and PLITBLM supports PL/SQL table operations used to carry period and type arrays in memory.

Usage Notes

The package is invoked primarily by the Oracle Payroll Schedule Matrix form, which calls SET_RUNID when the session begins, LOAD_* to populate the driver table, and then repeated calls to the GET_* helpers while rendering the dynamic matrix. CLEAR_TABLE with the POST-FORM event releases the session's rows and issues a commit. Because the global run identifier is session-scoped, concurrent users do not interfere with each other's matrix data. The package is also referenced by four other packages in the same product family, which may call the exceedence and hierarchy validation routines. Customizations that need matrix period boundaries or the current run identifier should call GET_RUN_ID, GET_START_PERIOD, and GET_END_PERIOD rather than reading the temporary table directly, since the run identifier is not exposed outside the package.