Search Results per_contracts_s




Overview
Explore in AI Chat

Overview

APPS.PER_CTC_INS is a PL/SQL package body in the Oracle E-Business Suite Applications schema (APPS) that forms part of the Oracle HRMS Contract (CTC) API layer. Its primary business function is to support the insertion and creation of employee contract records within the PER_CONTRACTS tables. Contracts in Oracle HRMS define the terms and conditions of a person's employment, including start and end dates, contract type, and associated assignments; they are a foundational element for payroll processing, benefits eligibility, and workforce reporting.

The package body is classified as an "OTHER" API, meaning it does not conform to the standard HRMS DateTracked API pattern exposed to external callers but rather serves as an internal insertion helper. It delegates much of its business logic to PER_CTC_BUS (the contracts business logic package) and interacts directly with the PER_CONTRACTS_F and PER_CONTRACTS_S tables. Despite being a public package in the APPS schema, the ETRM metadata records that it is not referenced by any other database object, indicating that it is invoked dynamically or from within the contract API call stack rather than through static dependencies.

Key Procedures and Functions

The package exposes two documented procedures:

  • INS — The primary insertion entry point. It orchestrates the creation of a contract record, applying business validation and row-handling logic. INS acts as the outer wrapper that prepares context, defaults, and calls the underlying DML and business-rule routines.
  • INSERT_DML — The low-level data manipulation routine responsible for performing the actual insert of the contract row into the PER_CONTRACTS tables. It operates beneath INS and is separated so that the DML can be reused or invoked in controlled contexts while the surrounding business logic is handled by INS and PER_CTC_BUS.

The package also depends on PER_CTC_RKI (Row Key Information, providing primary key generation) and PER_CTC_SHD (the shadow/date-tracking table for contracts), consistent with DateTrack-aware contract maintenance.

Tables Accessed

The documented tables referenced by this package via APPS synonyms are:

  • PER_CONTRACTS_F — The base (current) contracts table. INSERT_DML writes the authoritative contract row here.
  • PER_CONTRACTS_S — The DateTrack shadow table that stores the historical version of each contract row. Any insert performed through the DateTrack-enabled helpers maintained in PER_CTC_SHD results in a corresponding shadow record so that contract history can be reconstructed.

These two tables are the core storage for the Contracts entity in Oracle HRMS. The package relies on HR_API, HR_UTILITY, FND_GLOBAL, and DT_API to establish session context, resolve DateTrack modes, and enforce HRMS business-group security during the insert.

Usage Notes

Because PER_CTC_INS is classified as an internal "OTHER" API and is not referenced statically by other objects, it is not intended for direct customer invocation. It is typically exercised indirectly through the HRMS Contracts form (Contracts window / Contract Details), through the supported PER_CTC_BUS business logic layer, or through Oracle-supplied concurrent processes and APIs that create contracts as part of hire, rehire, or contract-change flows. The appearance of the user search term "per_contracts_s" alongside this package reflects the close relationship between the package and the PER_CONTRACTS_S shadow table when diagnosing contract insertion issues.

In EBS 12.1.1 and 12.2.2, custom code should not call PER_CTC_INS directly; instead it should use the documented HRMS Contracts API or the Contracts form. Direct invocation without a valid HR_API initialization context (business group, DateTrack mode, effective date) will fail or corrupt date-tracked data. For troubleshooting, dependency tracing on PER_CTC_INS is useful when investigating how contract rows reach PER_CONTRACTS_F and PER_CONTRACTS_S via the APPS synonym layer.