Search Results emp_promotions




Overview
Explore in AI Chat

Overview

APPS.PER_CA_EMP_EQUITY_PKG is a Canadian localization package within Oracle Human Resources (PER) that supports the statutory Employment Equity reporting requirements mandated by Human Resources and Skills Development Canada. Its primary business function is the generation of the tab-delimited text files required for the Employment Equity Report, specifically the employee.txt, promot.txt, term.txt, and excep.txt output files. These files are submitted to the federal government as part of an employer's annual employment equity compliance obligation.

The package header, last updated under version 120.0 in May 2006, identifies its purpose explicitly: producing these tab-delimited extracts from the underlying HR data model. The package is classified as OTHER in the ETRM metadata, indicating it is an internal localization utility rather than a public, published API. It is not referenced by any other package, confirming it sits at the top of its call stack as a report-generation routine.

Key Procedures and Functions

The ETRM metadata documents six procedures and functions within this package:

  • EMPLOYEE_DTLS — Generates the employee.txt tab-delimited file, extracting the employee detail rows required for the Employment Equity Report. It accepts the business group and reporting period inputs along with the NAIC code, and returns a standard concurrent-program errbuf and retcode.
  • EMP_PROMOTIONS — Produces the promot.txt file, capturing employee promotion activity across the reporting period for employment equity analysis.
  • COUNT_TERM — Supports the termination reporting extract (term.txt), counting or assembling terminated-employee records for the reporting period.
  • EXCEP_REPORT — Generates the excep.txt exception report, which surfaces records that fail validation or fall outside expected employment equity criteria.
  • JOB_EXISTS — A validation helper that determines whether a given job definition exists, typically used to guard processing against missing or stale job references.
  • PERSON_TYPE_EXISTS — A validation helper that confirms whether a person type is defined. This function is the object most relevant to searches for the "person_type_exists" identifier, since it lets calling logic verify person-type validity before inclusion in the employment equity extract.

No parameter lists are documented beyond those shown for EMPLOYEE_DTLS; the remaining routines should be treated as internal helpers invoked by the main extraction flow.

Tables Accessed

The package reads from a representative set of HR tables, all accessed through APPS synonyms. Core person and assignment data is drawn from PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F. Person type validation for PERSON_TYPE_EXISTS relies on PER_PERSON_TYPES. Job information for JOB_EXISTS is sourced from PER_JOBS. Location, organization, and costing details come from HR_LOCATIONS_ALL, HR_ORGANIZATION_INFORMATION, and HR_SOFT_CODING_KEYFLEX. Assignment status, pay basis, and period-of-service data are drawn from PER_ASSIGNMENT_STATUS_TYPES, PER_PAY_BASES, and PER_PERIODS_OF_SERVICE. Output or staging data is held in PER_CA_EE_REPORT_LINES. The package also references DUAL and the PL/SQL table utility PLITBLM, and declares collection types over PER_JOBS and PER_PERSON_TYPES for bulk processing.

Usage Notes

PER_CA_EMP_EQUITY_PKG is typically invoked by the Canadian Employment Equity Report concurrent program, which passes the business group, reporting year, and NAIC code and captures the generated text files from the concurrent manager output. Because it is classified as an internal (non-public) API with no downstream dependents, it should not be called directly from custom code without understanding its file-generation side effects. Custom extensions requiring person-type or job validation are better served by the underlying validation queries against PER_PERSON_TYPES and PER_JOBS rather than by invoking PERSON_TYPE_EXISTS or JOB_EXISTS from this localization package. The behavior is consistent across EBS 12.1.1 and 12.2.2, as the package header predates both releases.