Search Results tmp_var2_p




Overview
Explore in AI Chat

Overview

APPS.PQH_PQIPED6_XMLP_PKG is a report-support package bound to an Oracle EBS Public Sector / Human Resources BI Publisher (XML Publisher) report. The suffix "PQIPED6" identifies it as the sixth report definition in the PQIPED series (Public Sector Payroll / Position Information reporting), and the "_XMLP_PKG" suffix confirms that the package functions as the PL/SQL data model and formatting layer behind an XML Publisher concurrent program. The package is compiled with AUTHID CURRENT_USER and carries the standard EBS header stamp $Header: PQIPED6S.pls 120.2 2007/12/21 17:27:44 vjaganat noship $, indicating a shipped, non-customized source file first delivered in Release 12.1.1 and carried forward unchanged in 12.2.2.

Functionally, the package assembles a full-time employee statistical summary. Its constants reference an ordered sequence of line numbers (18, 26, 34, 42, 48, 54, 60, 66) and a closing total line (67), and the report title string confirms the business purpose: "Total All Full-Time Employees." The report is therefore a payroll headcount/statistics roll-up that groups employees by job code and organization unit, presenting subtotals and a grand total on a fixed, printed form layout.

Key Procedures and Functions

The package exposes five "computational" functions and ten accessor ("_p") functions, the latter serving the XML Publisher template binding layer.

  • LINE1FORMULA — returns a numeric value used for the first report line, typically an opening subtotal or count placeholder.
  • CF_GROUPTOTTITLEFORMULA — accepts a JobCode and returns character data: the dynamic group/subtotal heading text for each job code block.
  • CF_GROUP_LINENOFORMULA — accepts a JobCode and returns the calculated report line number for that job code group.
  • BEFOREREPORT — standard XML Publisher/Reports trigger; initializes session state, derives P_REPORT_DATE and related parameters, and sets CP_* buffer values before the data query executes.
  • AFTERREPORT — post-processing trigger, invoked after report output is generated.
  • LINE_NUM_P, CP_FR_P, CP_FT_P, CP_PR_P, CP_PT_P, CP_LASTLINENO_P, CP_REPORTTOTTITLE_P, TMP_VAR_P, TMP_VAR1_P, TMP_VAR2_P — accessor functions returning the current values of the correspondingly named package variables. TMP_VAR_P returns tmp_var (initialized to 49), TMP_VAR1_P returns tmp_var1 (54), and TMP_VAR2_P returns tmp_var2 (61); these three are counter anchors for successive salary bands. CP_FR_P and CP_FT_P expose full-time regular and full-time temporary subtotal strings; CP_PR_P and CP_PT_P expose part-time regular and part-time temporary equivalents. CP_REPORTTOTTITLE_P exposes the fixed grand-total caption.

Tables Accessed

  • PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F — the primary employee and assignment datable sources, supplying the population counted by the report.
  • PER_ASSIGNMENT_STATUS_TYPES — filters the assignment set (for example, active assignments only).
  • PER_JOBS — resolves job codes and drives the group-title and group-line-number formulas above.
  • PER_PAY_BASES and PER_PAY_PROPOSALS — payroll basis and pay proposal lines, used to classify full-time/part-time and regular/temporary categories.
  • HR_ALL_ORGANIZATION_UNITS — supplies the organization/business group hierarchy used to segment the report.
  • PAY_US_RPT_TOTALS — the US payroll reporting totals table, supplying stored period totals that are compared or reconciled against the computed figures.

Usage Notes

This package is not called directly by other PL/SQL packages; the ETRM metadata records zero dependent packages. It is invoked exclusively by its parent XML Publisher concurrent program, which supplies P_CONC_REQUEST_ID, P_BUSINESS_GROUP_ID, and P_REPORT_DATE at runtime. The _p accessor functions are referenced from the report's RTF or eText template to surface computed line numbers, subtotal captions, and category totals into the printed output.

Customizations should be avoided in the shipped package body: because the file version is marked "noship" with a fixed 2007 release stamp, modifications in 12.2.2 may be overwritten by future patches. The supported extension point is a new XML Publisher template or a wrapper package that calls the public functions. Administrators should also confirm that the tmp_var, tmp_var1, and tmp_var2 line anchors (49, 54, 61) remain consistent with any adjusted report layout, since these values determine the vertical position of the computed totals.