Search Results per_ctc_bus




Overview
Explore in AI Chat

Overview

PER_CTC_BUS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that encapsulates the core business logic for the Contract Information (CTC) module within Oracle Human Resources. The package name follows the standard EBS naming convention, where "PER" denotes the Human Resources product, "CTC" identifies the Contracts component, and "_BUS" indicates a business logic layer that sits between the user-facing forms or APIs and the underlying database tables. In EBS 12.1.1 and 12.2.2, this package is classified as OTHER in the ETRM API registry, and it carries a VALID status.

Its primary role is to provide reusable validation and derivation routines for records stored in the PER_CONTRACTS_F table, which holds employee contract information. Rather than forcing every caller to duplicate business rules, the package centralizes the checks that determine whether a contract insert, update, or delete is permissible, and it derives context-sensitive values such as the relevant legislation code. This design enforces consistent data integrity across all entry points that touch contract data.

Key Procedures and Functions

The package exposes five documented procedures and functions:

  • INSERT_VALIDATE — Performs the business rule checks required before a new contract record can be created in PER_CONTRACTS_F. Callers invoke it to confirm the proposed data satisfies organizational and legislative constraints prior to the actual insert.
  • UPDATE_VALIDATE — Applies the equivalent validation logic for modifications to existing contract rows, ensuring that changes do not violate the same rules enforced at creation time.
  • DELETE_VALIDATE — Determines whether an existing contract record may be removed. This likely checks for dependent assignment data before allowing deletion.
  • CHK_ASSIGNMENT_EXISTS — Tests for the presence of a related assignment record, most probably by querying PER_ALL_ASSIGNMENTS_F. This check supports contract-to-assignment integrity and feeds the delete validation path.
  • RETURN_LEGISLATION_CODE — Derives and returns the applicable legislation code for a given contract context, which governs which statutory rules and lookups apply to that employee's contract.

Tables Accessed

The documented tables referenced through APPS synonyms are:

  • PER_CONTRACTS_F — The primary transactional table for contract information. The validate routines read and assess rows here, and the package is also referenced by the contract table's insert, update, and delete handlers (PER_CTC_INS, PER_CTC_UPD, PER_CTC_DEL) and by HR_CONTRACT_BK2.
  • PER_ALL_ASSIGNMENTS_F — Used chiefly by CHK_ASSIGNMENT_EXISTS to verify that an employee assignment is linked to the contract under examination.
  • ALL_TABLES — Queried for metadata purposes, typically to confirm object existence or drive dynamic behavior.

PER_CTC_SHD, the contract table's shadow (audit) table, is also listed among the package's dependencies, consistent with the standard EBS pattern where business logic participates in the WHO-column and shadow-row bookkeeping associated with date-tracked tables.

Usage Notes

PER_CTC_BUS is not intended for direct invocation by end users. It is called internally by the contract table handlers — PER_CTC_INS, PER_CTC_UPD, and PER_CTC_DEL — which are the row-level triggers or API wrappers on PER_CONTRACTS_F, and by the HR_CONTRACT_BK2 package. Consequently, any form, concurrent program, or custom PL/SQL routine that inserts, updates, or deletes contract records through the supported handlers automatically benefits from these validations. Developers writing custom code against PER_CONTRACTS_F should route changes through the standard handlers rather than manipulating the table directly, so that the business rules in PER_CTC_BUS are applied. Because the package also depends on STANDARD (the EBS error-handling utility), validation failures are raised through the standard message stack.