Search Results is_template_expired

Overview

PON_CONTERMS_UTL_PVT is a private PL/SQL utility package in the APPS schema that supports the Oracle E-Business Suite Sourcing and Procurement family of modules, specifically the Oracle Sourcing (PON) negotiation and auction functionality. Its name reflects its purpose: it provides "contract terms" utility logic for negotiations. The package operates as an internal (PVT, or private) API layer, meaning it is not published for direct external invocation but is called by other PON packages and programmatic flows. It centralizes reusable operations such as determining negotiation and response document types, checking feature enablement, resolving deliverable actions, and validating contract term conditions. In EBS 12.1.1 and 12.2.2 the package is documented with STATUS VALID and an API classification of Private.

Key Procedures and Functions

The package exposes roughly thirty documented procedures and functions. Representative members include:

• IS_CONTRACTS_INSTALLED — returns whether the Contracts module is installed, gating contract-related logic.
• GET_RESPONSE_DOC_TYPE and GET_NEGOTIATION_DOC_TYPE — return the document type identifiers for supplier responses and negotiations respectively.
• IS_DEVIATIONS_ENABLED — indicates whether deviation handling is active for the negotiation.
• GET_CONCATENATED_ADDRESS — assembles a formatted address string, typically from location and territory data.
• GET_AUCTION_HEADER_ID — retrieves the auction header identifier for a negotiation context.
• ACTIVATEDELIVERABLES, UPDATEDELIVERABLES, CANCELDELIVERABLES, RESOLVEDELIVERABLES, DISQUALIFYDELIVERABLES, DISABLEDELIVERABLES — a family of routines that transition or resolve negotiation deliverables (contract term line items) between states.
• DELETE_DOC — removes a document associated with a negotiation.
• COPYRESPONSEDOC — duplicates a supplier response document.
• CONTRACT_TERMS_EXIST, CONTRACT_TERMS_OR_DEL_EXIST, CONTRACT_DELIVERABLES_EXIST — existence predicates used to branch processing depending on whether terms or deliverables are present.
• IS_ARTICLE_ATTACHED, IS_ARTICLE_AMENDED, IS_TEMPLATE_EXPIRED — validation predicates for terms articles and templates.

Tables Accessed

The package references several APPS synonyms. PON_AUCTION_HEADERS_ALL is the primary negotiation header table and is used to resolve header identifiers and document context. PON_AUC_DOCTYPES supplies document type definitions used by the document-type getters. PON_BID_HEADERS supports response/bid document handling. FND_TERRITORIES_TL and HR_LOCATIONS_ALL underpin the concatenated address logic, supplying territory names and location records. These accesses are predominantly read-oriented, with deliverable state transitions representing the principal write activity.

Usage Notes

Because it is a private package, PON_CONTERMS_UTL_PVT is not invoked directly from forms or concurrent programs. It is consumed by eleven higher-level packages, including PON_AUCTION_CREATE_PO_PKG, PON_AUCTION_HEADERS_PKG, PON_CONTERMS_UTL_GRP, PON_NEGOTIATION_COPY_GRP, PON_NEGOTIATION_HELPER_PVT, PON_NEGOTIATION_PUBLISH_PVT, PON_PRINTING_PKG, PON_SOURCING_OPENAPI_GRP, and PON_VENDORMERGE_GRP. Customizations should target the public group (GRP) or public (PUB) APIs rather than this private layer, since its signature may change across releases. When debugging sourcing behavior in 12.1.1 or 12.2.2, this package is a useful trace point for deliverable management and contract-term validation logic.