Search Results cs_contract_tpl_pub




Overview
Explore in AI Chat

Overview

The APPS.CS_CONTRACT_TPL_PUB package is a public (PUB) API within the Oracle E-Business Suite Service (CS) module, providing a supported programmatic interface for converting between service contracts and contract templates. In EBS 12.1.1 and 12.2.2, this package enables applications and extensions to create reusable templates from existing contracts and to instantiate new contracts from predefined templates without directly manipulating the underlying contract schema.

The package follows Oracle's standard PL/SQL API conventions, declaring the AUTHID CURRENT_USER directive so that execution privileges are resolved against the calling user. The header carries the original revision marker csctptps.pls 115.0, indicating the package has been a stable component of the Service Contracts foundation since the late 1990s and remains in place through the 12.x releases. Both documented procedures accept the standard API framework parameters p_api_version, p_init_msg_list, and p_commit, and return the conventional x_return_status, x_msg_count, and x_msg_data outputs used for error and message handling via FND_API and FND_MSG_PUB.

Key Procedures and Functions

  • CONTRACT_TO_TEMPLATE — Converts an existing contract into a reusable contract template. The caller supplies a contract identifier and a desired template name; the procedure creates the template and returns its generated identifier through the x_template_id output parameter. This procedure supports the business requirement of capturing a proven contract structure as a repeatable template for future use.
  • TEMPLATE_TO_CONTRACT — Instantiates a new contract from an existing template. The caller provides the source template identifier together with the customer, contract number, bill-to and ship-to site use identifiers, and effective start and end dates. The procedure returns the newly created contract identifier through the x_contract_id output parameter.

The two procedures are complementary, forming a bidirectional conversion mechanism. The package header declares a package name constant G_PKG_NAME and a set of local variables, including l_api_type, which reflects the standard _PUB API wrapping pattern used throughout EBS.

Tables Accessed

  • CS_CONTRACT_TEMPLATES — Stores the template header records created by CONTRACT_TO_TEMPLATE and read by TEMPLATE_TO_CONTRACT. This table holds the template name, identifier, and defining attributes persisted when a contract is converted into a template.
  • CS_CONTRACT_LINE_TPLTS — Stores line-level template definitions associated with contract templates. It supports the transfer of contract line structure into template form and its reconstitution when a template is applied to a new contract.

Both objects are referenced through APPS synonyms, consistent with the package's execution under the APPS schema in a multi-org environment.

Usage Notes

This package is typically invoked from the Service Contracts forms interface when a user chooses to save or apply a contract template, from custom Forms personalizations, or from custom PL/SQL code and concurrent programs that automate bulk contract generation. Because it is classified as a PUB API, it is the supported entry point for programmatic template-to-contract and contract-to-template operations; direct DML against the underlying template tables is not recommended.

Callers should follow standard EBS API invocation practice: initialize the message list, supply a valid API version, and inspect x_return_status and the message outputs before committing. The package is not referenced by any other documented package, meaning it functions as a top-level entry point rather than an internal dependency. Its stable presence across 12.1.1 and 12.2.2 makes it suitable for reusable extension code, though developers should validate behavior in their specific patch level, as the documented excerpt reflects an early revision of the source file.