Search Results maintain_contracts

Overview

The APPS.HR_CONTRACT_API package body is a server-side PL/SQL API that manages the contract records attached to an employee's assignment and period of service within Oracle EBS Human Resources. Contracts in Oracle HRMS represent the contractual terms under which a person is engaged, including their start and end dates, contract type, and linkage to a period of service. This API provides the supported programmatic interface for creating, updating, and deleting those contract records, shielding callers from the underlying business logic and table-level operations performed by the shadow and insert/update/delete packages (PER_CTC_INS, PER_CTC_UPD, PER_CTC_DEL, and PER_CTC_SHD).

In both Oracle EBS 12.1.1 and 12.2.2, the package is owned by the APPS schema and is reported as VALID. It is classified as an API, and the ETRM metadata records that it is referenced by 21 other database objects, confirming its role as a foundational component reused across the HRMS data model rather than an isolated utility.

Key Procedures and Functions

• CREATE_CONTRACT — Inserts a new contract record, applying HR validation rules and defaulting logic before the row is persisted.
• UPDATE_CONTRACT — Modifies attributes of an existing contract record while maintaining date-tracked history and validity checks.
• DELETE_CONTRACT — Removes a contract record, invoking the appropriate delete logic and dependent processing.
• LCK — A locking routine used to serialize access and enforce optimistic or pessimistic concurrency control during contract maintenance.
• MAINTAIN_CONTRACTS — The primary orchestration routine that drives contract creation, update, or deletion based on the supplied business operation, coordinating the lower-level insert, update, and delete steps.
• GET_PPS_START_DATE and GET_PPS_END_DATE — Functions that return the start and end dates of the associated period of service, used to align contract dates with the person's continuous service record.
• GET_ACTIVE_START_DATE and GET_ACTIVE_END_DATE — Functions that return the effective active date bounds for the contract, supporting date-effective querying.
• GET_MEANING — A lookup-based function that resolves a stored lookup code into its translatable meaning, typically for contract type or status display.

Tables Accessed

• PER_CONTRACTS_F — The primary contract table; the API reads and writes contract rows here.
• PER_ALL_ASSIGNMENTS_F — Supplies and validates the assignment to which a contract is linked.
• PER_ALL_PEOPLE_F — Provides the person record and person-level context for the contract.
• PER_PERIODS_OF_SERVICE — Establishes and validates the period of service associated with the contract term.

All four objects are referenced through APPS synonyms, consistent with the schema ownership model.

Usage Notes

HR_CONTRACT_API is normally invoked indirectly rather than through direct end-user action. It is called by the Oracle HRMS forms that maintain employee contract information, by concurrent programs performing bulk contract processing, and by other PL/SQL packages. The dependency list confirms dependencies on HR_API, HR_GENERAL, HR_UTILITY, HR_LOOKUPS, and the shadow/insert/update/delete packages, and that the package is itself referenced by 21 objects. Custom code implementing contract maintenance should call this API rather than manipulate PER_CONTRACTS_F directly, because the API encapsulates validation, date-effectivity handling, lookup resolution, and locking.