Search Results text_query_rewrite_post

Overview

CS_KNOWLEDGE_CUHK is a PL/SQL package owned by the APPS schema within Oracle E-Business Suite, classified under the OTHER API category in the ETRM repository. It belongs to the Service (CS) product family and supports the Oracle Knowledge Management and customer support infrastructure, specifically the creation and maintenance of knowledge sets and their constituent elements. The suffix "CUHK" denotes a customization or extension variant of the base CS_Knowledge package, and the header comment referencing a "noship" designation indicates this object is not shipped as part of the standard product, but rather installed or retained for a specific deployment. The package participates in the CS_Knowledge public API layer, as evidenced by its use of shared record and table types defined in CS_Knowledge_PUB, including set_def_rec_type, ele_def_tbl_type, and number15_tbl_type.

Key Procedures and Functions

The package exposes five documented procedures and functions through which EBS components interact with knowledge set definitions.

• CREATE_SET_AND_ELEMENTS_PRE — Operates as the pre-processing portion of the knowledge set creation workflow, validating input and preparing set definition and element definition structures before persistence.
• CREATE_SET_AND_ELEMENTS_POST — Complements the pre procedure, performing the post-processing sequence that finalizes creation of a knowledge set together with its associated elements, returning the generated set and element identifiers.
• TEXT_QUERY_REWRITE_POST — Rewrites raw user-entered query text into a processed text query suitable for the knowledge search engine, applying the specified search option and returning a customized query string. This is the procedure referenced in the user's search.
• OK_TO_LAUNCH_WORKFLOW — A Boolean function that determines whether a workflow process may be launched for a given set definition and element collection, acting as a gate for downstream Oracle Workflow integration.
• OK_TO_GENERATE_MSG — A Boolean function that evaluates whether a message may be generated for the supplied set and element definitions, controlling notification and messaging behavior.

All procedures follow the standard EBS API convention, accepting an API version, initialization flag, commit flag, and validation level, and returning the standard x_return_status, x_msg_count, and x_msg_data outputs.

Tables Accessed

The ETRM metadata for this object does not enumerate specific base tables accessed via APPS synonyms. Functionally, the package operates against the CS Knowledge repository structures that back CS_Knowledge_PUB—the knowledge set and element definition tables that store set metadata, element attributes, and search configuration. Because the package manipulates set and element records through the PUBLIC type layer, direct table references are abstracted behind the CS_Knowledge_PUB API rather than being hard-coded within this unit.

Usage Notes

CS_KNOWLEDGE_CUHK is typically invoked programmatically rather than from a concurrent program submission screen. The ETRM documentation confirms it is referenced by two other packages, indicating that it serves as a helper or extension layer called by higher-level CS_Knowledge processing units. The CREATE_SET_AND_ELEMENTS_PRE and _POST pair is ordinarily invoked in sequence during knowledge set definition from a form or an integration program, with the pre routine performing validation and the post routine committing results. TEXT_QUERY_REWRITE_POST would be called by search-related components whenever user query text requires normalization. The two Boolean functions—OK_TO_LAUNCH_WORKFLOW and OK_TO_GENERATE_MSG—are consulted conditionally by callers before initiating workflow or message generation, allowing deployment-specific business rules to suppress those actions. As a noship customization, any upgrade to 12.1.1 or 12.2.2 should verify continued compatibility with CS_Knowledge_PUB and re-apply the package if the underlying public types change.