Search Results get_job_details

Overview

PER_FR_WORK_CERT is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM as an "OTHER" API. Its name and header comment (pefrwkct.pkh, dated 2003) indicate that it supports the French (FR) statutory requirement for a certificat de travail — the work certificate an employer must issue to an employee upon termination of the employment relationship under French labour law.

The package is declared with AUTHID CURRENT_USER, meaning its SQL and PL/SQL execute with the privileges of the invoking user rather than with the definer's privileges. In the EBS context this is typical for utility packages invoked from Oracle Forms or from concurrent processing under a specific responsibility, where the effective privileges are determined at runtime. The package exposes a single public function, GET_JOB_DETAILS, and depends on core HR tables to derive the job and assignment information printed on the certificate.

Key Procedures and Functions

• GET_JOB_DETAILS — the only documented program unit in the package. It is a function returning VARCHAR2 and accepts a person identifier together with a period-of-service identifier. Its purpose is to assemble and return the job-related textual details required for the work certificate, resolving the relevant assignment and job information for the specified person and service period. The returned string is the concatenated or formatted description consumed by the calling form or report when the certificate is generated.

No other procedures or functions are documented in the ETRM extract. The package specification terminates immediately after this function, confirming that GET_JOB_DETAILS is the sole public entry point in the documented release.

Tables Accessed

The ETRM identifies three base tables, accessed through APPS synonyms:

• PER_ALL_ASSIGNMENTS_F — the primary assignment datestamp table. The function reads the assignment rows effective for the person and period of service in order to determine the position, organization, and effective dates that underpin the certified employment details.
• PER_JOBS — the job definition table, supplying the job name or code associated with the assignment records retrieved.
• PER_JOBS_TL — the translated (language) table for jobs, providing the job name in the session or territory language. This is significant for a France-specific certificate, since the document must present job titles in the correct local language.

All three references are read-only in the documented design; the package is a query utility rather than a maintenance API.

Usage Notes

PER_FR_WORK_CERT is referenced by two other packages, indicating that it sits below a higher-level French HR statutory reporting component rather than being called directly by end users. Typical invocation patterns are:

• Indirectly, from a French HR termination or work-certificate report or concurrent program that produces the printed certificat de travail.
• From the responsible Oracle Forms screen used to record employee terminations, where the certificate details are previewed or generated.
• From custom code extending the delivered French localisation, in which case the standard APPS synonym privileges apply and the caller must supply a valid person_id and period_of_service_id.

Because the function depends on effective-dated assignment data, callers should ensure the period-of-service identifier corresponds to periods already recorded for the person; otherwise the function returns no job detail. A relevant search term such as "dev certificat ecam" reflects a developer seeking the certification logic behind this object. As with all undocumented or "OTHER" classified APIs, the package is subject to change between 12.1.1 and 12.2.2 and should be validated against the target instance before use in custom development.