Search Results pay_ca_roe_selection_type

Overview

PAY_PYCAROEP_XMLP_PKG is an Oracle E-Business Suite PL/SQL package body owned by APPS and classified under the OTHER API category. It is the concurrent program library backing the Canadian Record of Employment (ROE) XML Publisher report (PYCAROEP). The package is responsible for supplying runtime parameters, derived labels, and formatted values to the XML Publisher template at the moment the concurrent request executes. Its header comment dates the source to December 2007, consistent with the release 12.0/12.1 code line carried forward into 12.2.2.

The package operates entirely as a report trigger library. It reads concurrent program parameters such as employee, assignment set, selection type, effective date, and payroll period, resolves them into readable descriptions, and publishes those values through global package variables consumed by the report layout. It performs no transactional DML.

Key Procedures and Functions

• BEFOREREPORT — The principal entry point. It resolves the business group name, derives the person full name from PER_ALL_PEOPLE_F, derives the assignment set name from HR_ASSIGNMENT_SETS using the p_assignment_set parameter, translates the selection type through the PAY_CA_ROE_SELECTION_TYPE lookup, and initializes the start and end date globals.
• AFTERPFORM — Post-parameter form trigger used to finalize parameter-derived values after the user submits the concurrent request.
• AFTERREPORT — Cleanup trigger executed after report output is produced.
• CF_LANGUAGEFORMULA — Formatting function that returns the language value applied to report output.
• CF_ROE_PAY_PERIOD_TYPEFORMULA — Formatting function that resolves the ROE pay period type description, drawing on PER_TIME_PERIOD_TYPES_TL.
• C_BUSINESS_GROUP_NAME_P, C_REPORT_SUBTITLE_P — Accessor functions exposing the cached business group name and report subtitle to the template.
• CP_PERSON_P, CP_EFFECTIVE_DATE_P, CP_ASSIGNMENT_SET_NAME_P, CP_SELECTION_TYPE_P, CP_START_DATE_P, CP_END_DATE_P — Accessor functions returning the corresponding cached global values resolved during BEFOREREPORT.

The p_assignment_set parameter is central to this package. In BEFOREREPORT it is canonicalized with FND_NUMBER.CANONICAL_TO_NUMBER and passed to the csr_get_asg_set cursor, which selects assignment_set_name from HR_ASSIGNMENT_SETS. The resulting name is stored in l_asg_set and exposed as CP_assignment_set_name.

Tables Accessed

• HR_ASSIGNMENT_SETS — Read to translate the p_assignment_set identifier into a display name.
• PER_ALL_PEOPLE_F — Read to obtain the full name of the person identified by the P_PERSON_ID parameter.
• PER_TIME_PERIOD_TYPES_TL — Read to resolve translated pay period type descriptions for the ROE layout.

The package also reads PAY_ACTION_PARAMETERS for the TRACE setting and HR_LOOKUPS for the PAY_CA_ROE_SELECTION_TYPE meaning, and calls the HR_REPORTS utility to fetch the business group name. All access is read-only.

Usage Notes

The package is invoked exclusively by the concurrent manager when the Canadian ROE XML Publisher program is submitted. It is not referenced by any other package, confirming its role as a terminal report library. Parameters supplied by the user on the concurrent program parameter form drive the cursor logic; the assignment set parameter must resolve to a valid HR_ASSIGNMENT_SETS row or the display name global remains null. Customizations should avoid modifying this shipped package directly and instead use a copy, since the source is protected by the standard Oracle support policy.