Search Results pier_yeer

Overview

PAY_CA_YEER_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified in the ETRM repository as a standalone (OTHER) API rather than a conventional public interface. Its stated purpose is the generation of the Elements Reports for Canadian payroll, producing output directly in a user-selectable format. The supported output formats are HTML and CSV. The package is defined with AUTHID CURRENT_USER, so all unqualified object references resolve against the privileges of the invoking schema. The header file carrying the source is pycayeer.pkh, and the version shipped for the 12.1.1 / 12.2.2 code lines is 120.0.12020000.4. The change history shows sustained evolution from its creation in November 2000 through a November 2012 revision that introduced the parameters for the PIER_YEER procedure.

Key Procedures and Functions

Two program units are documented for this package.

• PIER_YEER — The primary report driver. It is a procedure that returns the standard concurrent program status pair through errbuf and retcode, both declared as OUT NOCOPY parameters, and accepts at least a reporting year and a PIER/YEER input parameter. Its purpose is to assemble and emit the elements report output in the format requested by the caller. The procedure was modified in version 115.9 (bug 4344652) to add the parameters required for the PIER/YEER report, and earlier in version 115.6 to pass p_pre in place of p_qin; version 115.2 added the dbdrv directive used by the deployment utility.
• VALIDATESIN — A function introduced in version 115.8 (bug 6773615) that validates the Social Insurance Number of an employee. It provides the SIN format and check-digit verification used when the report or its callers must confirm that a Canadian employee identifier is well-formed before the record is processed.

Earlier revisions also added package-level plumbing that supports both units: a SET VERIFY OFF directive at the top of the script, an OSERROR command, and a NOCOPY OUT parameter convention. A table type, tab_cpp_date, was added in version 115.7 (bug 13542043) to carry CPP Election Date and CPP Revocation Date values through the report logic.

Tables Accessed

The package reads its payroll data through APPS synonyms rather than direct schema references. Balance and element metadata come from PAY_BALANCE_TYPES and PAY_BALANCE_TYPES_TL. Payroll processing and archive activity are read from PAY_ASSIGNMENT_ACTIONS, PAY_ACTION_INFORMATION, FF_ARCHIVE_ITEMS and FF_ARCHIVE_ITEM_CONTEXTS, with FF_DATABASE_ITEMS, FF_CONTEXTS and HR_SOFT_CODING_KEYFLEX supplying the Fast Formula and key flexfield context used to interpret element definitions. Organization and location information used to identify and sort Canadian business entities is drawn from HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION and HR_LOCATIONS_ALL. Canadian statutory data, specifically federal tax information, is read from PAY_CA_EMP_FED_TAX_INFO_F. Report labels and lookup-driven values are obtained from FND_LOOKUP_TYPES and FND_LOOKUP_VALUES. The package is not referenced by any other documented package, so it sits at the outer edge of the dependency graph.

Usage Notes

PAY_CA_YEER_PKG is invoked as the executable of a concurrent program rather than called interactively. Because PIER_YEER follows the standard concurrent program signature with errbuf and retcode, it can be registered in the Oracle Payroll responsibility and submitted with a reporting year and the PIER/YEER selection as concurrent program parameters. The caller selects HTML or CSV as the desired output format, and the package writes the report to the file location associated with the concurrent request. Custom code may call VALIDATESIN directly where SIN validation is required before data submission. Sites should be aware that because the package is AUTHID CURRENT_USER, grants on the underlying payroll and HR tables must be in place for the invoking account, and that the AUTHID CURRENT_USER setting is confirmed by the package specification header.