Search Results cp_end_date_p

Overview

APPS.PAY_PYCAROEP_XMLP_PKG is a PL/SQL package associated with the Oracle Payroll Record of Employment (ROE) concurrent program and its XML Publisher report definition. In Oracle E-Business Suite 12.1.1 and 12.2.2, this package supports the generation of the Canadian Record of Employment (ROE) report output, a statutory document required for employees who experience an interruption of earnings. The package encapsulates the report's bind parameters, global variables, group-level formula functions, and lifecycle hooks (before/after report and after-form triggers) used by the XML Publisher engine during concurrent request execution. The header comment dates to 2007 and identifies the object as a shared, non-shippable (noship) source file, which is consistent with internal EBS report packages generated by Oracle Reports to XML Publisher migration tooling.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions. BEFOREREPORT and AFTERREPORT serve as standard report lifecycle hooks invoked at the start and completion of report execution, respectively, typically performing initialization and cleanup. AFTERPFORM executes after the parameter form or parameter structure is processed, allowing late binding of derived values.

Two group-level formula functions drive formatted output. CF_LANGUAGEFORMULA derives a correspondence language value from the ROE correspondence language and the final pay period end date inputs. CF_ROE_PAY_PERIOD_TYPEFORMULA is the function most relevant to the user's search term; it consumes the ROE_PAY_PERIOD_TYPE value and returns a formatted character string for display on the ROE output. It functions as a lookup or translation layer, converting the raw period-type code into the printed ROE pay period type designation.

The remaining documented functions are parameter accessors: C_BUSINESS_GROUP_NAME_P, C_REPORT_SUBTITLE_P, CP_PERSON_P, CP_EFFECTIVE_DATE_P, CP_ASSIGNMENT_SET_NAME_P, CP_SELECTION_TYPE_P, CP_START_DATE_P, and CP_END_DATE_P. These return the business group name, report subtitle, person, effective date, assignment set name, selection type, and start/end dates used by the report's data model and layout templates. Package-level variables such as P_BUSINESS_GROUP_ID, P_CONC_REQUEST_ID, P_START_DATE, P_END_DATE, P_PERSON_ID, P_ASSIGNMENT_SET, and P_SELECTION_TYPE hold the runtime parameters passed by the concurrent request.

Tables Accessed

The package references three underlying tables through APPS synonyms. HR_ASSIGNMENT_SETS provides assignment set definitions used when the report is run against a grouped population of assignments. PER_ALL_PEOPLE_F supplies person records, including effective-dated personal information required for ROE header and employee details. PER_TIME_PERIOD_TYPES_TL supplies translated time period type descriptions, which support the ROE pay period type value rendered by CF_ROE_PAY_PERIOD_TYPEFORMULA. The package is documented as referenced by zero other packages, indicating it is a terminal report module rather than a shared library.

Usage Notes

This package is invoked indirectly by the Payroll ROE XML Publisher concurrent program through the report definition and template. It is not intended for direct invocation from forms or custom code, and its parameter accessors are called by the XML Publisher data model rather than by external applications. Personalization or extension should be performed through the report template or by wrapping the concurrent program, not by modifying the package, since changes to generated report packages may be overwritten by patching. The cf_roe_pay_period_typeformula function specifically governs how pay period type codes appear on the printed ROE and is the appropriate point of investigation when the rendered period type is incorrect or blank.