Search Results cs_get_contracts_pub




Overview
Explore in AI Chat

Overview

CS_GET_CONTRACTS_PUB is a public PL/SQL package in the APPS schema of Oracle E-Business Suite, owned by the Service (CS) module and classified as a published API (filename suffix _PUB). Its business purpose is to retrieve and expose service contract and coverage information held in the CS foundation tables so that it can be consumed by callers outside the package — ranging from Oracle Service forms and concurrent programs to customer-written extensions. The package provides the read-and-transform layer for contract data: it queries contracts, their statuses, coverages, cover-level hierarchies and covered products, then either returns that data directly to the calling program or migrates it into a caller-supplied staging structure.

In the context of the user search term cs_cp_services_all, this package is one of the documented references to CS_CP_SERVICES_ALL. CS_CP_SERVICES_ALL is the multi-org view over the CS_CP_SERVICES base table, and it stores the service lines attached to a contract or service entitlement — that is, the specific services a customer is entitled to under a given contract line. Because CS_GET_CONTRACTS_PUB reads CS_CP_SERVICES and CS_CP_SERVICES_ALL, any contract-extraction activity driven by this API will surface the service-line detail, not just contract headers, and will be subject to the operating-unit (org) security enforced by the _ALL view.

Key Procedures and Functions

The ETRM documentation for release 12.2.2 records seven procedures and functions. Four of the principal documented entry points are:

  • GET_LIST_OF_CONTRACTS — The primary retrieval routine. It accepts filter criteria, executes the contract query against CS_CONTRACTS and its supporting tables, and returns the matching set of contracts (typically as a list of contract identifiers) to the caller.
  • COUNT_AND_GET — A combined counting and retrieval routine. It returns the total number of contracts matching the caller's criteria and, in the same invocation, fetches the corresponding contract records. This is useful for pagination and for UI grids that display a result count ahead of the rows.
  • MIGRATE_TO_TABLE — Transforms the in-memory result set produced by the retrieval logic into rows of a database table supplied or implied by the caller, enabling bulk persistence of extracted contract data.
  • MIGRATE_TO_OUT_VARIABLES — Projects the retrieved contract data into OUT parameters so that the caller receives the values directly in PL/SQL variables rather than through a table or collection.

The remaining documented units are companion procedures and functions that support these four, handling query construction, data marshalling and result handling. Parameter lists are not reproduced here; callers must consult the package specification in the APPS schema for exact signatures.

Tables Accessed

The package reads and depends on the following documented objects:

  • CS_CONTRACTS — the service contract header table; the core source of contract rows returned by the retrieval routines.
  • CS_CONTRACT_STATUSES — supplies contract status values used for filtering and for decoding status identifiers into meaningful descriptions.
  • CS_COVERAGES and CS_CONTRACT_COV_LEVELS — coverage definitions and their level hierarchies, describing what is covered and at which level.
  • CS_COVERAGE_TXN_GROUPS — groups of transactions associated with a coverage, used to determine entitlement eligibility.
  • CS_CP_SERVICES and CS_CP_SERVICES_ALL — the base table and multi-org view holding the service lines attached to contract/coverage records.
  • CS_COVERED_PRODUCTS — the inventory items covered under a contract.
  • MTL_SYSTEM_ITEMS_KFV — the key-flexfield view of inventory items, joined to resolve item descriptions and concatenated key segments for covered products.

The package also calls FND_API, the standard Oracle Application Object Library error-handling and message API, which implies that failures are reported through the standard FND message stack rather than raw exceptions.

Usage Notes

CS_GET_CONTRACTS_PUB is a public API and, per the metadata, is referenced by zero other packages in the documented dependency set, so it is intended to be called directly rather than as an internal helper. Typical invocation points include Service (CS) forms that display contract and coverage information, concurrent programs that extract contract or entitlement data for reporting and interfaces, and custom PL/SQL that needs a supported, upgrade-safe alternative to querying CS_CONTRACTS and CS_CP_SERVICES_ALL directly. Because the package depends on FND_API and on the _ALL view of the service lines, callers should expect operating-unit context to be applied and should initialize the FND message stack where error feedback is required. Use the API in preference to the underlying tables to remain insulated from schema changes across 12.1.1 and 12.2.2.