Search Results cs_services_pvt




Overview
Explore in AI Chat

Overview

CS_CONTRACT_TPL_PUB is a public API package in the Oracle E-Business Oracle Service (CS) module. It provides the supported programmatic interface for converting between service contracts and contract templates. In Oracle EBS 12.1.1 and 12.2.2, service contract templates are reusable definitions that pre-populate contract header and line attributes, allowing organizations to standardize terms, coverage, billing, and entitlement structures across many service agreements. The CS_CONTRACT_TPL_PUB package exposes the two core directions of that relationship: taking a fully authored contract and abstracting it into a reusable template, and instantiating a new contract from an existing template.

As indicated by the _PUB suffix and the ETRM classification (PUB), this is a public, supported API intended for external invocation rather than internal-only use. It sits above the private implementation layer, delegating to packages such as CS_CONTRACT_PVT, CS_CONTRACTTMPL_PVT, CS_CONTRACTLTMPL_PVT, and CS_CONTRACTS for the underlying business logic. Because reference metadata shows that no other database object references CS_CONTRACT_TPL_PUB, it serves as an entry point called by forms, concurrent programs, or custom extensions rather than as a utility consumed by other server-side code.

Key Procedures and Functions

  • CONTRACT_TO_TEMPLATE — Converts an existing service contract into a contract template, deriving a reusable template structure from the source contract's header and line attribute definitions so that similar contracts may be created in the future.
  • TEMPLATE_TO_CONTRACT — Creates a new service contract from a given contract template, applying the template's predefined header and line attributes to initialize the new agreement.

Both procedures follow the Oracle Application Object Library API conventions, relying on FND_API for return status and FND_MSG_PUB for message handling. Standard parameters typically include a result indicator (RETURN_STATUS) and an error message buffer (X_MSG_DATA / X_MSG_COUNT) along with the relevant identifiers for the contract or template. The documented metadata lists the procedures by name only; refer to the actual package specification for exact parameter signatures.

Tables Accessed

  • CS_CONTRACT_TEMPLATES — Stores the template header definitions. Written during CONTRACT_TO_TEMPLATE and read during TEMPLATE_TO_CONTRACT.
  • CS_CONTRACT_LINE_TPLTS — Stores template line-level definitions. Populated or consumed alongside the header to preserve entitlement and line detail structure.

The package also references CS_CONTRACTS, CS_CONTRACT_LINE_TPLTS, and CS_CP_SERVICES for reading source contract data and writing contract records. Supporting packages such as CS_SERVICES_PVT and CS_CONTRACT_PVT perform the actual contract and service manipulation, while FND_GLOBAL, FND_PROFILE, and FND_MESSAGE supply environment context and messaging.

Usage Notes

This package is the recommended integration point whenever contract-to-template or template-to-contract conversion must be automated. It is commonly invoked from the Service Contracts authoring forms when a user selects an action to save a contract as a template or to create a contract from a template. It may also be called from concurrent programs that bulk-generate contracts from standard templates, or from custom PL/SQL extensions performing data migration or mass setup. Invocations should occur within the standard Oracle API calling pattern: initialize the message stack, call the procedure, check the return status, and process any resulting messages. Because the package depends on _PVT private packages, direct calls to those private objects are unsupported; custom code must always target CS_CONTRACT_TPL_PUB, which remains VALID in both 12.1.1 and 12.2.2.