Search Results ent_contract_tab

Overview

The APPS.CS_CONT_GET_DETAILS_PVT package is a private (PVT classification) PL/SQL API belonging to the Service (CS) application in Oracle E-Business Suite. It functions as an internal helper package that retrieves contract and entitlement details required for service request processing, contract coverage validation, and reaction-time calculation. The package header carries a revision identifier of csvscgds.pls 120.0, indicating it is a shipped, non-customized object registered with the standard Applications schema.

The package declares standard internal constants — G_PKG_NAME, G_APP_NAME (set to 'CS'), and G_API_VERSION (set to 1) — which are conventional markers of an EBS private API. It also defines several local data structures that support its lookups, including subtypes aliased to OKS_ENTITLEMENTS_PUB collection types (Ent_contract_tab, Ent_contact_tab) and a locally declared inc_contact_tab associative array of inc_contact_rec records holding contact_id and valid_contact.

Key Procedures and Functions

• GET_CONTRACT_LINES — The principal procedure exposed by the package. It accepts a large set of input parameters describing a service request context (contract number, service line, customer, site, account, system, inventory item, customer product, request date, business process, severity, and time zone), together with validation and calculation flags. Its most relevant parameter for the user's search is P_DATES_IN_INPUT_TZ, a VARCHAR2 flag defaulting to 'N', which controls whether date values supplied to (and possibly returned by) the procedure are interpreted in the caller's input time zone rather than the database/session time zone. The procedure returns an X_ENT_CONTRACTS output collection of entitlement contracts, along with the standard EBS concurrent-style out parameters X_RETURN_STATUS, X_MSG_COUNT, and X_MSG_DATA.
• GET_REACTION_TIME — Retrieves or derives reaction-time information associated with contract coverage, typically used to determine service-level response expectations for a given entitlement.
• VALIDATE_CONTACT — Validates whether a contact is associated with and valid for the contract or entitlement under consideration, using the inc_contact_tab structure to hold contact identifiers and their validity flags.

Because this is a PVT package, its procedures are not part of the public API surface and are not intended for direct customer invocation.

Tables Accessed

• OKC_K_HEADERS_B — The base table for contract headers in the Contracts (OKC) schema. The package reads CONTRACT_NUMBER and related header information to resolve a contract before extracting entitlement lines.
• PLITBLM — The standard Applications message repository, used to retrieve message text for the return-status and message-data out parameters.

Usage Notes

As a private package, CS_CONT_GET_DETAILS_PVT is invoked internally by other Service application components and is not referenced by any other package according to the ETRM metadata. It is typically called from service request forms, service request business logic, or the entitlement/coverage validation layers that operate beneath the public OKS_ENTITLEMENTS_PUB API. When diagnosing date-handling behavior — the likely reason a user would search for P_DATES_IN_INPUT_TZ — the flag should be read in conjunction with P_TIME_ZONE_ID: setting P_DATES_IN_INPUT_TZ to 'Y' instructs the routine to treat supplied dates as being expressed in the caller's P_TIME_ZONE_ID rather than the session default. Custom code should avoid calling this package directly, since its signature and availability may change across patch levels and are not covered by Oracle's public API commitment.