Search Results p_conc_request_id

Overview

APPS.PER_PERCAEER_XMLP_PKG is the packaged backend for the Oracle EBS HRMS report commonly identified as the Canadian Employment Equity Report (Annual/Corporate). The package body encapsulates the report's BeforeReport trigger logic and the formula functions used by the XML Publisher (XMLP) report definition. Its primary business purpose is to perform pre-execution validation of the business group, confirm that Government Reporting Entity (GRE) records are complete (in particular that the NAIC code is present), drive the extraction of employee data into the reporting work tables via the PER_CA_EE_EXTRACT_PKG, and update those records once the extract is complete. The naming prefix "PER" indicates the Oracle Human Resources (Payroll/PER) schema family, and the "_XMLP_PKG" suffix indicates the object is generated for an XML Publisher concurrent program.

Key Procedures and Functions

The documented API classification is "OTHER," and the package exposes thirty documented procedures and functions.

• BEFOREREPORT — The report initialization function. It derives the formatted session date, assigns the concurrent request ID from the FND global, obtains the business group name, runs the GRE/NAIC validation through per_ca_ee_extract_pkg.check_gre_without_naic, and, on success, calls the extraction routines form1, form2n, form2 through form6, and update_rec within per_ca_ee_extract_pkg.
• CF_F5_N_* group — A set of numeric summary formulas used by the report layout: CF_F5_N_PROMPTFORMULA, CF_F5_N_TOTALFORMULA, CF_F5_N_TOTMAFORMULA, CF_F5_N_TOTFEFORMULA, CF_F5_N_TOTABFORMULA, CF_F5_N_MAABFORMULA, CF_F5_N_FEABFORMULA, CF_F5_N_TOTVIFORMULA, CF_F5_N_MAVIFORMULA, CF_F5_N_FEVIFORMULA, CF_F5_N_TOTDIFORMULA, CF_F5_N_MADIFORMULA, and CF_F5_N_FEDIFORMULA. These compute totals for the main ("MA"), female ("FE"), aboriginal ("AB"), visible minority ("VI"), and disabled ("DI") categories, plus the overall total and the prompt value.
• CF_F5_P_* group — The parallel set of formulas for the "P" (reporting-year or prior/current period) section: CF_F5_P_TOTALFORMULA, CF_F5_P_TOTMAFORMULA, CF_F5_P_TOTFEFORMULA, CF_F5_P_TOTABFORMULA, CF_F5_P_MAABFORMULA, and CF_F5_P_FEABFORMULA.

These formula functions are invoked by the XML Publisher report template to resolve summary column values; they do not carry business-critical validation logic themselves.

Tables Accessed

• PER_CA_EE_REPORT_LINES — The Canadian Employment Equity report lines table. The report reads and writes this table to populate the extracted workforce data used in the output layout.
• DUAL — Used for standard SQL evaluation, typically to return a single value such as the concurrent request ID or formatted date.
• PLITBLM — A PL/SQL internal table type referenced during extraction/totals handling.

The extraction logic also manipulates data through PER_CA_EE_EXTRACT_PKG procedures, which write the intermediate rows consumed by the report.

Usage Notes

PER_PERCAEER_XMLP_PKG is invoked indirectly through the concurrent program that runs the Canadian Employment Equity XML Publisher report. When the concurrent manager submits the request, FND assigns a concurrent request ID; BEFOREREPORT captures this via fnd_global.CONC_REQUEST_ID and stores it in the P_CONC_REQUEST_ID package variable. This value is then passed to each form1/form2/form3/form4/form5/form6/form2n extraction call and to update_rec, ensuring all extracted rows are tagged to the correct concurrent request. The user's search term "p_conc_request_id" therefore corresponds to this critical parameter: it is the linkage key that binds the report run to its extracted data set.

The package is referenced by no other packages, confirming it is a terminal report package rather than a shared utility. It is not intended for direct calls from custom code; customizations should target the underlying PER_CA_EE_EXTRACT_PKG or the report definition itself. Organizations must ensure the required business group parameters and NAIC codes are configured, because the report returns FALSE and aborts without invoking the extraction when check_gre_without_naic detects missing NAIC data.