DBA Data[Home] [Help]

APPS.CS_KB_SOLN_CATEGORIES_PVT dependencies on CS_KB_SECURITY_PVT

Line 99: cs_kb_security_pvt.ADD_CATEGORY_TO_DENORM (

95: X_VISIBILITY_ID => p_visibility_id
96: );
97: x_category_id := l_category_id;
98:
99: cs_kb_security_pvt.ADD_CATEGORY_TO_DENORM (
100: P_CATEGORY_ID => x_category_id,
101: P_PARENT_CATEGORY_ID => p_parent_category_id,
102: P_VISIBILITY_ID => p_visibility_id,
103: X_RETURN_STATUS => x_return_status,

Line 179: cs_kb_security_pvt.REMOVE_CATEGORY_FROM_CAT_GROUP(

175: */
176: -- Delete this leaf category
177: cs_kb_soln_categories_pkg.delete_row( p_category_id );
178:
179: cs_kb_security_pvt.REMOVE_CATEGORY_FROM_CAT_GROUP(
180: P_CATEGORY_ID => p_category_id,
181: X_RETURN_STATUS => x_return_status,
182: X_MSG_DATA => x_msg_data,
183: X_MSG_COUNT => x_msg_count

Line 405: cs_kb_security_pvt.UPDATE_CATEGORY_TO_DENORM (

401: X_LAST_UPDATE_LOGIN => l_current_login_id,
402: X_VISIBILITY_ID => p_visibility_id
403: );
404:
405: cs_kb_security_pvt.UPDATE_CATEGORY_TO_DENORM (
406: P_CATEGORY_ID => p_category_id,
407: P_VISIBILITY_ID => p_visibility_id,
408: X_RETURN_STATUS => x_return_status,
409: X_MSG_DATA => x_msg_data,

Line 433: CS_KB_SECURITY_PVT.delete_category_group_member(

429:
430: IF l_original_parent_category_id <> p_parent_category_id THEN
431: for x in Get_Moved_Categories loop
432: for y in GET_DUP_CG_MEMBERSHIP(x.category_id) loop
433: CS_KB_SECURITY_PVT.delete_category_group_member(
434: p_category_group_id => y.category_group_id,
435: p_category_id => x.category_id,
436: X_RETURN_STATUS => x_return_status,
437: X_MSG_DATA => x_msg_data,

Line 448: cs_kb_security_pvt.MOVE_CATEGORY_IN_DENORM (

444: end loop;
445:
446:
447: -- Update denorm table.
448: cs_kb_security_pvt.MOVE_CATEGORY_IN_DENORM (
449: P_CATEGORY_ID => p_category_id,
450: X_RETURN_STATUS => x_return_status,
451: X_MSG_DATA => x_msg_data,
452: X_MSG_COUNT => x_msg_count

Line 661: l_category_group_id := cs_kb_security_pvt.Get_Category_Group_Id;

657: type t_varchar_arr is table of varchar2( 80 );
658: l_catnames_arr t_varchar_arr;
659: fullpath_name VARCHAR2( 2000 );
660: begin
661: l_category_group_id := cs_kb_security_pvt.Get_Category_Group_Id;
662: l_soln_visibility_position := cs_kb_security_pvt.Get_Soln_Visibility_Position;
663:
664: open c_fullpath_names( category_id,
665: l_category_group_id,

Line 662: l_soln_visibility_position := cs_kb_security_pvt.Get_Soln_Visibility_Position;

658: l_catnames_arr t_varchar_arr;
659: fullpath_name VARCHAR2( 2000 );
660: begin
661: l_category_group_id := cs_kb_security_pvt.Get_Category_Group_Id;
662: l_soln_visibility_position := cs_kb_security_pvt.Get_Soln_Visibility_Position;
663:
664: open c_fullpath_names( category_id,
665: l_category_group_id,
666: l_soln_visibility_position );