Search Results is_element_updated_dup




Overview
Explore in AI Chat

Overview

The APPS.CS_KB_ELEMENTS_AUDIT_PKG package is a PL/SQL API belonging to the Oracle E-Business Suite knowledge management and customer service schema (the CS_KB family). It provides the audited, controlled entry point for creating, updating, and deleting knowledge base "elements" — the discrete content units (articles, statements, and similar constructs) that make up the Knowledge Base used by Oracle iSupport, TeleService, and related modules. The package encapsulates the business rules, version tracking, duplicate detection, and audit (WHO column) management that must accompany every mutation of a knowledge element. It is classified as an OTHER API in the ETRM registry for release 12.1.1 and 12.2.2, reflecting that it is a supporting programmatic interface rather than a seeded concurrent program or form-bound trigger.

Key Procedures and Functions

The package exposes sixteen documented routines balancing validation helpers, mutation procedures, and CLOB-oriented operations:

  • IS_ELEMENT_CREATED_DUP — determines whether a newly created element duplicates an existing record, keyed by element identifier.
  • IS_ELEMENT_DUP — checks for duplication using element number, access level, type, name, and description, supporting the "create_clob" search path where description content is supplied as a CLOB.
  • IS_ELEMENT_UPDATED_DUP — duplicate validation applied when an existing element is being changed.
  • GET_ELEMENT_NUMBER — retrieves the element number associated with a given element identifier.
  • GET_LATEST_VERSION_ID — returns the current version identifier for a supplied element number, underpinning the versioning model.
  • GET_WHO — populates the audit WHO columns (system date, user id, login id) used consistently across insert and update operations.
  • CREATE_ELEMENT / CREATE_ELEMENT_CLOB — insert a knowledge element, with the CLOB variant handling large textual content such as the element description.
  • UPDATE_ELEMENT / UPDATE_ELEMENT_CLOB — modify an existing element, again with a CLOB-specific variant.
  • DELETE_ELEMENT — removes an element and its associated records.
  • CREATE_STATEMENT / CREATE_CLOB — the "create_clob" routine creates knowledge statements and CLOB payloads, the latter being the object referenced by the user's search.
  • UPDATE_STATEMENT / UPDATE_STATEMENT_ADMIN — modify statements, with an administrative variant for privileged changes.
  • OBSOLETE_UNUSED_STATEMENTS — marks orphaned statements obsolete as part of cleanup and lifecycle maintenance.

Tables Accessed

The package operates against the principal knowledge base tables via APPS synonyms. CS_KB_ELEMENTS_B, CS_KB_ELEMENTS_TL, and CS_KB_ELEMENTS_S hold the base, translated, and version/security records for elements. CS_KB_ELEMENT_NUMBER_S supplies element numbering, and CS_KB_ELEMENT_TYPES_B defines valid element types. Association and grouping data are drawn from CS_KB_ELEMENT_LINKS, CS_KB_SETS_B, CS_KB_SET_ELES, CS_KB_SET_CATEGORIES, and the denormalized CS_KB_CAT_GROUP_DENORM. Large object storage is mediated through DBMS_LOB, and DUAL is used for simple scalar retrieval.

Usage Notes

This package is typically invoked by Oracle Knowledge Base forms and programmatic integrations rather than directly by end users or concurrent programs. In EBS 12.1.1 and 12.2.2 it is called from the Customer Support HTML and earlier framework layers, and is referenced by three other packages in the schema. Custom development should call the CLOB variants (CREATE_CLOB, CREATE_ELEMENT_CLOB, UPDATE_ELEMENT_CLOB) when supplying rich text content, since the search term "create_clob" corresponds to that specialized path. Because the package enforces audit and duplicate rules internally, callers should not bypass it with direct DML on the underlying CS_KB tables.