1 PACKAGE CS_KB_SOLN_CATEGORIES_PVT AUTHID CURRENT_USER AS
2 /* $Header: csvcats.pls 120.0 2005/06/01 09:48:07 appldev noship $ */
3
4 INDEX_SYNC_FAILED EXCEPTION;
5 CG_MEMBER_DEL_FAILED EXCEPTION;
6
7 -- this API is used by JTT, obsoleted
8 procedure createCategory
9 (
10 p_api_version in number,
11 p_init_msg_list in varchar2 := FND_API.G_FALSE,
12 p_commit in varchar2 := FND_API.G_FALSE,
13 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
14 x_return_status OUT NOCOPY varchar2,
15 x_msg_count OUT NOCOPY number,
16 x_msg_data OUT NOCOPY varchar2,
17 p_parent_category_id in number,
18 p_name in varchar2,
19 p_description in varchar2,
20 x_category_id OUT NOCOPY number
21 );
22
23 -- this new API is called from OA, core should use this one instead
24 procedure createCategory
25 (
26 p_category_id in number,
27 p_api_version in number,
28 p_init_msg_list in varchar2 := FND_API.G_FALSE,
29 p_commit in varchar2 := FND_API.G_FALSE,
30 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
31 x_return_status OUT NOCOPY varchar2,
32 x_msg_count OUT NOCOPY number,
33 x_msg_data OUT NOCOPY varchar2,
34 p_parent_category_id in number,
35 p_name in varchar2,
36 p_description in varchar2,
37 x_category_id OUT NOCOPY number,
38 p_visibility_id in number
39 );
40
41 procedure removeCategory
42 (
43 p_api_version in number,
44 p_init_msg_list in varchar2 := FND_API.G_FALSE,
45 p_commit in varchar2 := FND_API.G_FALSE,
46 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
47 x_return_status OUT NOCOPY varchar2,
48 x_msg_count OUT NOCOPY number,
49 x_msg_data OUT NOCOPY varchar2,
50 p_category_id in number
51 );
52
53 procedure removeCategoryCascade
54 (
55 p_api_version in number,
56 p_category_id in number,
57 p_init_msg_list in varchar2 := FND_API.G_FALSE,
58 p_commit in varchar2 := FND_API.G_FALSE,
59 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
60 x_return_status OUT NOCOPY varchar2,
61 x_msg_count OUT NOCOPY number,
62 x_msg_data OUT NOCOPY varchar2
63 );
64
65 -- this new API is called from OA, core should use this one instead
66 procedure updateCategory
67 (
68 p_api_version in number,
69 p_init_msg_list in varchar2 := FND_API.G_FALSE,
70 p_commit in varchar2 := FND_API.G_FALSE,
71 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
72 x_return_status OUT NOCOPY varchar2,
73 x_msg_count OUT NOCOPY number,
74 x_msg_data OUT NOCOPY varchar2,
75 p_category_id in number,
76 p_parent_category_id in number,
77 p_name in varchar2,
78 p_description in varchar2,
79 p_visibility_id in number
80 );
81
82 -- this API is used by JTT, obsoleted
83 procedure updateCategory
84 (
85 p_api_version in number,
86 p_init_msg_list in varchar2 := FND_API.G_FALSE,
87 p_commit in varchar2 := FND_API.G_FALSE,
88 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
89 x_return_status OUT NOCOPY varchar2,
90 x_msg_count OUT NOCOPY number,
91 x_msg_data OUT NOCOPY varchar2,
92 p_category_id in number,
93 p_parent_category_id in number,
94 p_name in varchar2,
95 p_description in varchar2
96 );
97
98 procedure addSolutionToCategory
99 (
100 p_api_version in number,
101 p_init_msg_list in varchar2 := FND_API.G_FALSE,
102 p_commit in varchar2 := FND_API.G_FALSE,
103 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
104 x_return_status OUT NOCOPY varchar2,
105 x_msg_count OUT NOCOPY number,
106 x_msg_data OUT NOCOPY varchar2,
107 p_solution_id in number,
108 p_category_id in number,
109 x_soln_category_link_id OUT NOCOPY number
110 );
111
112 procedure removeSolutionFromCategory
113 (
114 p_api_version in number,
115 p_init_msg_list in varchar2 := FND_API.G_FALSE,
116 p_commit in varchar2 := FND_API.G_FALSE,
117 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
118 x_return_status OUT NOCOPY varchar2,
119 x_msg_count OUT NOCOPY number,
120 x_msg_data OUT NOCOPY varchar2,
121 p_solution_id in number,
122 p_category_id in number
123 );
124
125 function secure_cat_fullpath_names( category_id number, separator varchar2 ) return varchar2;
126 function admin_cat_fullpath_names ( category_id number, separator varchar2 ) return varchar2;
127 function admin_cat_fullpath_ids ( category_id number ) return varchar2;
128 function has_pub_wip_descendents ( category_id number) return varchar2;
129
130 END CS_KB_SOLN_CATEGORIES_PVT;