Search Results get_last_signed_revision

Overview

OKC_PO_INT_GRP is a PL/SQL package body in the APPS schema belonging to the Oracle Contracts (OKC) module of Oracle E-Business Suite. It is classified as a Group (GRP) style API, meaning it aggregates related utility logic rather than exposing a single transactional interface. Its role is to support the Contract Terms and Conditions authoring and revision process, specifically in resolving variable values, detecting changes between revisions, and preparing content for the Contracts Expert authoring framework.

The package declares a standard set of global constants reused across OKC APIs, including message tokens, FND_API return status codes (G_RET_STS_SUCCESS, G_RET_STS_ERROR, G_RET_STS_UNEXP_ERROR), and the convention G_PKG_NAME := 'OKC_PO_INT_GRP'. It also defines logging level globals — G_DBG_LEVEL, G_PROC_LEVEL, and G_EXCP_LEVEL (the latter initialized to FND_LOG.LEVEL_EXCEPTION) — which the user's search term "g_excp_level" refers to. These globals allow procedures to write exception-severity entries to the FND_LOG debug log when AFLOG_ENABLED is set.

Key Procedures and Functions

• GET_ARTICLE_VARIABLE_VALUES — Populates an in-memory table of system variable values associated with a given document, accepting the document identifier and an API version, and returning the resolved variable value collection. This is the entry point for resolving runtime variables used inside contract articles.
• GET_CHANGED_VARIABLES — Identifies which variables have changed between a prior state and the current state, enabling the calling process to propagate or re-evaluate only affected terms.
• GET_ITEM_DTL_FOR_EXPERT — Retrieves item-level detail required by the Contracts Expert (Oracle Contracts for Procurement/Sales authoring) to generate or refresh contract content.
• OK_TO_COMMIT — A validation routine that indicates whether the calling process may safely commit its work, consistent with the FND_API savepoint convention used throughout OKC APIs.
• GET_LAST_SIGNED_REVISION — Returns the most recently signed revision of a contract document, allowing downstream processes to anchor variable evaluation and change detection to the legally effective version.

Tables Accessed

The package reads and writes through APPS synonyms. OKC_DELIVERABLES holds deliverable definitions tied to contract terms and is consulted to resolve item and article context. OKC_TEMPLATE_USAGES records where contract templates have been applied, which the Expert-detail and variable routines rely on to determine the applicable clause set. DUAL is used for simple scalar queries and administrative checks. PLITBLM is the standard FND table used for PL/SQL-in-Table-Name (table-of-varchar) processing, supporting the in-memory collections returned by the variable routines.

Usage Notes

OKC_PO_INT_GRP is not typically called directly from a form; it is invoked by higher-level OKC contract APIs and by concurrent programs that generate or refresh contract documents. The ETRM metadata records that three other packages reference it, confirming its position as a shared group utility layer. Custom code extending contract authoring should call these procedures rather than querying OKC_DELIVERABLES or OKC_TEMPLATE_USAGES directly, so that variable resolution and change detection remain consistent with standard behavior. Debug output is controlled by the AFLOG_ENABLED profile option and the FND_LOG level globals, with G_EXCP_LEVEL used to classify exception-severity messages. Because the header dates to 120.1 (2005) and is marked noship, the package has been stable across 12.1.1 and 12.2.2, though the 12.2 file system deployment differs.