Search Results cs_contractltmpl_pvt




Overview
Explore in AI Chat

Overview

CS_CONTRACTLTMPL_PVT is a private PL/SQL package owned by the APPS schema within Oracle E-Business Suite. It forms part of the Service Contracts (CS) module's contract template framework, specifically addressing contract line template maintenance. The package carries an API classification of "PVT," denoting that it is a private implementation package rather than a public, externally callable API. In Oracle EBS architecture, PVT packages typically encapsulate the lower-level validation, locking, insert, update, and delete logic that public packages and TAPI layers invoke on their behalf. This separation shields direct table manipulation from external consumers while enforcing the API development standards promoted by FND_API and the TAPI development kit, on which this package depends.

The package operates on contract line templates — reusable definitions that pre-populate lines, coverages, and related attributes when users create service contracts. By centralizing row-level maintenance logic here, Oracle ensures consistent validation and concurrency handling across every entry point that manages template lines.

Key Procedures and Functions

The package exposes a set of documented procedures following the standard Oracle TAPI (Table API) pattern. Parameter lists are intentionally omitted here in accordance with documentation scope, but the functional intent of each is as follows:

  • INSERT_ROW — Creates a new contract line template record. It applies the standard TAPI insert sequence, populating mandatory columns and firing the associated validation before committing the row to the underlying table.
  • LOCK_ROW — Acquires a row-level lock on an existing template line record. This supports optimistic and pessimistic concurrency control patterns so that subsequent update or delete operations act on a stable version of the data.
  • UPDATE_ROW — Modifies an existing contract line template record. It re-runs validation logic and manages WHO-column auditing (created/updated by and date fields) consistent with EBS standards.
  • DELETE_ROW — Removes a contract line template record, typically subject to validation that prevents deletion of referenced or protected rows.
  • VALIDATE_ROW — Performs the business-rule checks required before a row may be inserted or updated, ensuring data integrity across required attributes, foreign key relationships, and template-specific constraints.

Although eight procedures and functions are documented in total for this package, the five above constitute the core maintenance surface; the remaining members are supporting routines.

Tables Accessed

The package reads and writes several Service Contracts tables through APPS synonyms:

  • CS_CONTRACT_LINE_TPLTS — The primary transaction table holding contract line template definitions. The insert, update, delete, and lock operations act directly on this table.
  • CS_CONTRACT_LINE_TPLTS_S — The companion sequence/identifier table used to generate unique primary keys for new template line records during INSERT_ROW.
  • CS_CONTRACT_TEMPLATES — The parent contract template table, referenced to validate the template to which a line belongs and to maintain hierarchical integrity.
  • CS_COVERAGES — The coverage definitions table, consulted during validation to confirm that coverage references attached to a line template are valid.

Usage Notes

As a PVT package, CS_CONTRACTLTMPL_PVT is not intended for direct invocation by end users or external integrations. It is referenced by the public package CS_CONTRACT_TPL_PUB, which supplies the sanctioned entry point for contract template operations. In practice, the package is invoked indirectly through Service Contracts forms and concurrent programs that create or modify contract templates, and through custom code that calls the public API layer. Developers extending Service Contracts should call CS_CONTRACT_TPL_PUB rather than this private package to remain upgrade-safe. The package is VALID in both 12.1.1 and 12.2.2 and depends on FND_API and TAPI_DEV_KIT, confirming adherence to Oracle's standard API development framework.