Search Results per_ctc_ins




Overview
Explore in AI Chat

Overview

PER_CTC_INS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM API classification of OTHER. The package forms one component of the Contract Information (CTC) subsystem within Oracle Human Resources, which governs the storage and lifecycle of employee contract data held in the PER_CONTRACTS_F and PER_CONTRACTS_S tables. In EBS 12.1.1 and 12.2.2 the contract subsystem is split across a small family of packages—PER_CTC_INS, PER_CTC_UPD, and the shared shadow package PER_CTC_SHD—each handling a distinct data manipulation concern. As the name indicates, PER_CTC_INS is the insert-side worker: it encapsulates the logic required to create new contract records and their associated date-tracked rows without requiring the calling code to manipulate the underlying tables directly. Its status is documented as VALID, and it is formally recorded in the ETRM repository as an APPS-owned package with a defined dependency footprint.

Key Procedures and Functions

The documented interface exposes three procedures or functions, identified in the metadata as INSERT_DML, INS, and a third entry that completes the package interface. INSERT_DML performs the low-level DML insert operation against the contract data model, encapsulating the row-level insert semantics—including the handling of the date-tracked effective-date columns—so that the surrounding API layer need not embed raw SQL. INS serves as the higher-level insertion entry point, providing the contract creation service that callers invoke when a new contract must be established for an employee. The naming convention mirrors the wider HR API family, in which an action verb prefixed identifier maps to a single business event on the entity. The ETRM record does not publish formal parameter lists for these units, and none should be assumed; integrators should resolve the call signature from the package specification in the target instance before use.

Tables Accessed

Through APPS synonyms the package operates on two documented base tables. PER_CONTRACTS_F is the core contract entity table, holding the primary contract attributes such as contract type, contractual terms, and reference information for each employee assignment. PER_CONTRACTS_S is the corresponding date-tracked secondary table, storing the effective-dated rows that allow contract details to vary across time. This F/S pairing is the standard Oracle HR datetrack pattern: the _F table carries the row that is current, while the _S table preserves the historical and future-dated versions. PER_CTC_INS therefore writes to both structures in a coordinated manner when a new contract is created. The package also depends on PER_CTC_SHD, the shared package used to apply datetrack shadow-row logic, ensuring that insert operations remain consistent with the surrounding contract maintenance framework.

Usage Notes

PER_CTC_INS is not intended as an end-user entry point. It is a dependency of HR_CONTRACT_API, the public API most commonly called by forms, concurrent programs, and custom extensions when contracts are created or amended through supported interfaces. It is additionally referenced by PER_CTC_UPD, the update counterpart, and by itself, reflecting internal recursion or shared helper usage. Custom code should invoke HR_CONTRACT_API rather than calling PER_CTC_INS directly, since direct calls bypass validation and datetrack enforcement. When troubleshooting contract creation failures in EBS 12.1.1 or 12.2.2, PER_CTC_INS is a relevant object to inspect, as errors raised here surface through the public API stack. Any modification to the package is unsupported and would invalidate dependent objects, requiring recompilation across the affected dependency chain.