Search Results get_permissions

Overview

The APPS.CS_KB_WF_PKG package is a workflow-enablement utility within the Oracle E-Business Suite Knowledge Base (Knowledge Management) module. Its primary business function is to manage the interaction between Knowledge Base solutions and the Oracle Workflow engine, governing how knowledge articles move through configurable approval, review, and publication flows. The package exposes the workflow definitions, steps, actions, groups, and permissions that Knowledge Base uses to route solutions through their lifecycle. Because it is owned by the APPS schema and marked VALID in both 12.1.1 and 12.2.2, it is a supported, persistent component of the Knowledge Management architecture rather than a transient utility.

Key Procedures and Functions

The 33 documented procedures and functions fall into several functional clusters, all serving workflow configuration and permission resolution:

• Flow metadata: GET_FLOWS, GET_FLOW_DETAILS, GET_FLOWID, and GET_ALL_STEPS retrieve workflow definitions and the individual steps that constitute each flow.
• Step and group navigation: GET_ALL_GROUPS, GET_STEP_LIST, and GETSTEPGROUP resolve the workflow step-to-group relationships used to determine routing and approver assignment.
• Action handling: GET_ACTIONS and GETACTIONNAME expose the actions (for example, approve or reject) available within a given workflow context.
• Permission and membership checks: HASPERMISSION, ISMEMBER, GET_PERMISSIONS, and GET_PERMISSIONS_FOR_PUB_SOLN determine whether a user or resource group is authorized to act on a solution at a given step, including permissions tied specifically to published solutions.
• Eligibility helpers: INCATEGORY and INPRODUCT test whether a solution falls within defined sets, categories, or product assignments, feeding into flow-selection logic.
• Lifecycle control: GETSTATUS, ENABLE_FLOW, END_WF, EXPIRE_FLOW, and EXPIRE_DETAIL read and manipulate the state of an active workflow instance, including closing or expiring flows and their detail records.

These routines are commonly overloaded to accept JTF_NUMBER_TABLE and JTF_VARCHAR2_TABLE_100 collection types, enabling bulk processing of multiple identifiers in a single call.

Tables Accessed

The package touches a structured set of Knowledge Base and shared reference tables through APPS synonyms:

• Workflow definition tables: CS_KB_WF_FLOWS_B, CS_KB_WF_FLOWS_S, and CS_KB_WF_FLOWS_TL hold base, sequence, and translated flow header data; CS_KB_WF_FLOW_DETAILS and CS_KB_WF_FLOW_DETAILS_S store the constituent steps and actions.
• Solution set tables: CS_KB_SETS_B, CS_KB_SETS_TL, CS_KB_SET_CATEGORIES, and CS_KB_SET_PRODUCTS define which solutions are eligible for which flows, supporting INCATEGORY and INPRODUCT.
• Security and group tables: FND_USER, JTF_RS_GROUPS_TL, and JTF_RS_GROUP_MEMBERS resolve approver identities and resource-group membership for permission checks.
• Reference and profile tables: FND_LANGUAGES, FND_PROFILE_OPTIONS, and FND_PROFILE_OPTION_VALUES supply localization and profile-driven behavior.

Usage Notes

CS_KB_WF_PKG is an internal supporting package; users do not invoke it directly. It is called by CS_KB_SOLN_IN_PROGRESS_PKG and CS_KB_SOLUTION_PVT, which are the public entry points for solution workflow operations triggered from Knowledge Base forms and Oracle Workflow activities. Customizations that need to inspect flow definitions, evaluate approver permissions, or drive workflow state transitions should call the public packages rather than this one, though direct calls are technically possible. Because it depends on the Workflow and resource-group schemas, its behavior is consistent across 12.1.1 and 12.2.2 with no documented functional difference between releases.