Search Results get_published_set_id

Overview

CS_KB_SETS_AUDIT_PKG is an Oracle Applications (APPS) package owned by the E-Business Suite knowledge management content, specifically the Oracle Knowledge Base module used within the Service (TeleService) and iSupport product families. The package body is classified in ETRM as an OTHER API rather than a public or private standard API, meaning it is maintained primarily for internal use and is not published as a supported integration interface. Its overall business function is to provide auditing and lookup services against solution "sets" — the container objects that group Knowledge Base solutions for publication, review, and audience assignment. The header history indicates that this package once carried broader responsibilities, including the create_set and update_set routines referenced in the 2002 and 2003 change entries, along with solution submission, checkout, and security access logic introduced for the 11.5.10 release. The final cleanup entry (28-AUG-2003) records that private solution APIs were migrated to CS_KB_SOLUTION_PVT and table handlers to CS_KB_SETS_PKG, leaving the audit package with a narrower, utility-oriented role.

Key Procedures and Functions

ETRM documents a single public program unit in this package: GET_PUBLISHED_SET_ID. It is a function returning a NUMBER and is intended to resolve a published solution set identifier from a caller-supplied set number. Internally it selects the maximum set_id from the base table where the set_number matches and the row status is 'PUB' (published). If no qualifying row exists, the function raises NO_DATA_FOUND and, through its exception handler, returns ERROR_STATUS rather than propagating the exception. This design allows calling code to test for a sentinel value instead of trapping an error, which is convenient in Forms and concurrent code that must degrade gracefully when a set has not yet been published.

The historical header records several routines that are no longer part of this body in the documented version, notably Create_Set, Update_Set, Submit_Solution, Update_Solution, Is_Status_Valid, Get_User_Soln_Access, and CheckOut_Solution. Although a user searching for "create_set" will surface this package through the historical comment "Add logic in create_set and update_set to validate solution_type," the current implementation delegates creation logic elsewhere. Developers should treat those references as documentation of past behaviour and not as callable entry points in 12.1.1 or 12.2.2.

Tables Accessed

The only documented table reference is CS_KB_SETS_B, accessed through its APPS synonym. This is the base (non-translated) table holding solution set definitions, including set_number, set_id, and status. GET_PUBLISHED_SET_ID reads from this table exclusively, filtering on set_number and status = 'PUB' and aggregating with MAX to obtain the single published identifier. No inserts, updates, or deletes are performed in the documented code path, which is consistent with the package's audit/read-only orientation.

Usage Notes

Because the package is classified as OTHER and is referenced by zero other packages in the ETRM inventory, it is not a dependency of standard Oracle application code in the documented release. It is typically invoked from Oracle Forms or PL/SQL batch routines that need the published set identifier for a known set number — for example, rendering a published knowledge set in a self-service or agent-facing page. Callers must check the return value against ERROR_STATUS before use, since a missing or unpublished set returns that sentinel rather than raising to the caller. Customizations should prefer CS_KB_SETS_PKG for set maintenance and CS_KB_SOLUTION_PVT for solution lifecycle operations, reserving this package for published-set lookups only.