Search Results check_soln_in_progress




Overview
Explore in AI Chat

Overview

The CS_KB_SOLN_IN_PROGRESS_PKG package is an Oracle Applications (APPS) PL/SQL package within the Oracle E-Business Suite Service (CS) module, specifically serving the Knowledge Base (KB) functionality. The package is defined with AUTHID CURRENT_USER, meaning its stored procedures execute with the privileges of the invoking user rather than the package owner, deferring privilege resolution to runtime. Based on the $Header comment, the package was created in August 2003 and is designated noship, indicating it is a supporting internal object rather than a separately shipped or customer-facing deliverable.

The package addresses solution lifecycle management within the Knowledge Base. Its singular purpose is to determine whether a given knowledge solution is currently "in progress"—that is, whether the solution is still within an active workflow or review state rather than being finalized and published. This classification governs downstream behavior such as edit permissions, publication eligibility, and workflow progression.

Key Procedures and Functions

The ETRM metadata documents a single procedure within this package:

  • CHECK_SOLN_IN_PROGRESS — The sole documented entry point. It accepts two OUT NOCOPY standard concurrent-program parameters: ERRBUF (error buffer for returning messages) and RETCODE (return code). The NOCOPY hint on these OUT parameters improves performance by passing them by reference rather than by value. The procedure evaluates whether a solution remains in an in-progress state and communicates the result through its output parameters. No documented parameter lists beyond these are to be assumed; the procedure signature confirms it is intended for invocation in a concurrent-program or callable context.

No additional procedures or functions are documented in the ETRM record for this package.

Tables Accessed

The package references two underlying tables through APPS synonyms:

  • CS_KB_SETS_B — A base table storing Knowledge Base solution sets. Because the "_B" suffix denotes a base/header entity, this table likely holds solution-level records whose status must be inspected to determine whether a solution is in progress.
  • CS_KB_WF_FLOW_DETAILS — This table stores workflow flow details associated with Knowledge Base solutions. "WF" indicates the Oracle Workflow integration used for solution approval and publication routing. The procedure reads this table to determine the solution's current workflow stage, which is the primary signal for whether the solution is still considered in progress.

The combination of a solution-set base table and a workflow-details table indicates the procedure correlates solution identity with its active workflow state to reach its determination.

Usage Notes

Given its structure—a single AUTHID CURRENT_USER procedure exposing standard ERRBUF/RETCODE concurrent-program parameters—CS_KB_SOLN_IN_PROGRESS_PKG is most typically invoked from a concurrent program, an Oracle Forms event or button, or custom PL/SQL code that requires a programmatic answer to the question of whether a solution is currently in progress. It is not referenced by any other documented packages (referenced by 0 other packages), confirming it is a top-level utility rather than a shared dependency.

Because no separate parameter list for solution identification beyond the two OUT parameters is documented in the available metadata, the exact input mechanism (for example, a session context or global variable) is not captured in the ETRM record. Implementers integrating with this package should treat it as an internal, noship, single-purpose validator and verify the calling convention against the live 12.1.1 or 12.2.2 instance before relying on it in custom code.