Search Results c_end_date_p

Overview

PAY_PAYCABPS_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM metadata as "OTHER." It functions as the server-side program unit generated for the Oracle Payroll concurrent program report PAYCABPS, a Canadian payroll supplementary reporting process. The package follows the standard Oracle Reports XML Publisher (XMLP) integration pattern, in which the report's data model parameters, formula columns, and group filters are declared and implemented as PL/SQL constructs inside a package that is bound to the report definition. Its role is to populate report-level and formula-level values—report title, reporting period, province and location descriptors, and headcount and hour calculations—so that the concurrent program's output XML is rendered correctly by the XML Publisher template engine.

The package is declared with AUTHID CURRENT_USER, meaning its SQL statements resolve objects using the privileges of the invoking user rather than the definer, and it is compiled under the APPS schema against the EBS 12.1.1 and 12.2.2 data model.

Key Procedures and Functions

The package exposes 24 documented procedures and functions. The report lifecycle hooks are BEFOREREPORT, AFTERPFORM, and AFTERREPORT; these execute at the corresponding Oracle Reports trigger points to initialize session context, resolve parameter values, and perform post-processing cleanup.

The computational functions implement the report's formula columns:

• L_ALL_EMP_AVG_HRSFORMULA — computes average hours worked for all employees over the reporting period.
• CF_FEEDFORMULA — derives a feed or remittance value from province/location and group remittance entity (GRE) name inputs.
• G_PAYMENTSGROUPFILTER — a group filter that suppresses payment records based on hourly, salaried, and other paid amounts.
• CF_EMP_COUNTFORMULA and CF_PARTTIME_EMP_COUNTFORMULA — derive employee headcounts, distinguishing part-time employees, using pay basis, GRE, and payroll name.
• CF_TOTAL_HOURSFORMULA — sums overtime and regular hours worked.

The remaining documented members are value-returning accessors whose names mirror package globals with a trailing _P suffix: CP_PROVINCE_P, CP_LOCATION_P, CP_LOCATION_CODE_P, CP_GRE_NAME_P, C_BUSINESS_GROUP_NAME_P, C_REPORT_SUBTITLE_P, C_START_DATE_P, C_END_DATE_P, C_PROVINCE_NAME_P, C_LOCATION_CODE_P, and C_GRE_NAME_P. Notably, the user search term "c_start_date_p" corresponds directly to the C_START_DATE_P accessor, which returns the report's formatted start date global (declared as C_START_DATE VARCHAR2(11)).

Tables Accessed

The package queries thirteen base tables through APPS synonyms. Payroll and assignment data are read from PAY_PAYROLL_ACTIONS, PAY_RUN_TYPES_F, PAY_ALL_PAYROLLS_F, and PAY_ASSIGNMENT_ACTIONS, which provide payroll run context and process dates. Employee and assignment attributes come from PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, PER_PAY_BASES, and PER_TIME_PERIODS. Organization and location descriptors—used to resolve province and location parameters—are sourced from HR_ALL_ORGANIZATION_UNITS, HR_LOCATIONS_ALL, and HR_ORGANIZATION_INFORMATION. Balance attribute metadata is obtained from PAY_BAL_ATTRIBUTE_DEFINITIONS, and DUAL is used for single-row computations. These accesses are read-only; the package functions purely as a reporting layer.

Usage Notes

This package is not intended for direct invocation. It is bound to the PAYCABPS Oracle Reports/XML Publisher concurrent program definition and is executed by the concurrent manager when the report is submitted. Parameters such as P_BUSINESS_GROUP_ID, P_SESSION_DATE, P_REFERENCE_MONTH, P_GRE, P_PROVINCE, and P_LOCATION are supplied from the concurrent program's parameter form and consumed by the report triggers. Custom code should not call these functions outside the report context, as they depend on session-level global state initialized by BEFOREREPORT. No other packages reference it, confirming its role as a report-specific, self-contained unit.