8: -- Pre-reqs : None.
9: -- Parameters :
10: -- IN
11: -- p_api_version_number IN NUMBER Required
12: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
13: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
14: -- p_kb_category_id NUMBER:=FND_API.G_MISS_NUM,
15: -- p_kb_parent_category_id IN VARCHAR2,
16: -- p_display_name IN VARCHAR2,
9: -- Parameters :
10: -- IN
11: -- p_api_version_number IN NUMBER Required
12: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
13: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
14: -- p_kb_category_id NUMBER:=FND_API.G_MISS_NUM,
15: -- p_kb_parent_category_id IN VARCHAR2,
16: -- p_display_name IN VARCHAR2,
17: -- p_category_code IN VARCHAR2,
10: -- IN
11: -- p_api_version_number IN NUMBER Required
12: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
13: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
14: -- p_kb_category_id NUMBER:=FND_API.G_MISS_NUM,
15: -- p_kb_parent_category_id IN VARCHAR2,
16: -- p_display_name IN VARCHAR2,
17: -- p_category_code IN VARCHAR2,
18: -- p_is_repos IN VARCHAR2,
16: -- p_display_name IN VARCHAR2,
17: -- p_category_code IN VARCHAR2,
18: -- p_is_repos IN VARCHAR2,
19: -- p_category_order IN NUMBER,
20: -- p_category_desc IN varchar2:=FND_API.G_MISS_CHAR,
21: --
22: -- OUT
23: -- x_return_status OUT VARCHAR2
24: -- x_msg_count OUT NUMBER
30: -- End of comments
31: -- **********************************************************
32:
33: PROCEDURE create_item (p_api_version_number IN NUMBER,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE,
36: p_kb_category_id NUMBER,
37: p_kb_parent_category_id IN NUMBER,
38: p_display_name IN VARCHAR2,
31: -- **********************************************************
32:
33: PROCEDURE create_item (p_api_version_number IN NUMBER,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE,
36: p_kb_category_id NUMBER,
37: p_kb_parent_category_id IN NUMBER,
38: p_display_name IN VARCHAR2,
39: p_category_code IN VARCHAR2,
72: -- Pre-reqs : None.
73: -- Parameters :
74: -- IN
75: -- p_api_version_number IN NUMBER Required
76: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
77: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
78: -- p_kb_category_id in NUMBER:=FND_API.G_MISS_NUM,
79: -- p_kb_parent_category_id IN NUMBER:=FND_API.G_MISS_NUM,
80: -- p_display_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
73: -- Parameters :
74: -- IN
75: -- p_api_version_number IN NUMBER Required
76: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
77: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
78: -- p_kb_category_id in NUMBER:=FND_API.G_MISS_NUM,
79: -- p_kb_parent_category_id IN NUMBER:=FND_API.G_MISS_NUM,
80: -- p_display_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
81: --
74: -- IN
75: -- p_api_version_number IN NUMBER Required
76: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
77: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
78: -- p_kb_category_id in NUMBER:=FND_API.G_MISS_NUM,
79: -- p_kb_parent_category_id IN NUMBER:=FND_API.G_MISS_NUM,
80: -- p_display_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
81: --
82: -- OUT
75: -- p_api_version_number IN NUMBER Required
76: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
77: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
78: -- p_kb_category_id in NUMBER:=FND_API.G_MISS_NUM,
79: -- p_kb_parent_category_id IN NUMBER:=FND_API.G_MISS_NUM,
80: -- p_display_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
81: --
82: -- OUT
83: -- x_return_status OUT VARCHAR2
76: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
77: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
78: -- p_kb_category_id in NUMBER:=FND_API.G_MISS_NUM,
79: -- p_kb_parent_category_id IN NUMBER:=FND_API.G_MISS_NUM,
80: -- p_display_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
81: --
82: -- OUT
83: -- x_return_status OUT VARCHAR2
84: -- x_msg_count OUT NUMBER
90: -- End of comments
91: -- **********************************************************
92:
93: PROCEDURE delete_item (p_api_version_number IN NUMBER,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_kb_category_id in NUMBER,
97: p_kb_parent_category_id IN NUMBER,
98: p_display_name IN VARCHAR2 ,
91: -- **********************************************************
92:
93: PROCEDURE delete_item (p_api_version_number IN NUMBER,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_kb_category_id in NUMBER,
97: p_kb_parent_category_id IN NUMBER,
98: p_display_name IN VARCHAR2 ,
99: x_return_status OUT NOCOPY VARCHAR2,
107: -- Pre-reqs : None.
108: -- Parameters :
109: -- IN
110: -- p_api_version_number IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_kb_category_id IN NUMBER:=FND_API.G_MISS_NUM,
114: -- p_kb_parent_category_id IN number:=FND_API.G_MISS_NUM,
115: -- p_display_name IN varchar2:=FND_API.G_MISS_CHAR,
108: -- Parameters :
109: -- IN
110: -- p_api_version_number IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_kb_category_id IN NUMBER:=FND_API.G_MISS_NUM,
114: -- p_kb_parent_category_id IN number:=FND_API.G_MISS_NUM,
115: -- p_display_name IN varchar2:=FND_API.G_MISS_CHAR,
116: -- p_category_code IN varchar2:=FND_API.G_MISS_CHAR,
109: -- IN
110: -- p_api_version_number IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_kb_category_id IN NUMBER:=FND_API.G_MISS_NUM,
114: -- p_kb_parent_category_id IN number:=FND_API.G_MISS_NUM,
115: -- p_display_name IN varchar2:=FND_API.G_MISS_CHAR,
116: -- p_category_code IN varchar2:=FND_API.G_MISS_CHAR,
117: -- p_is_repos IN VARCHAR2:=FND_API.G_MISS_CHAR,
110: -- p_api_version_number IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_kb_category_id IN NUMBER:=FND_API.G_MISS_NUM,
114: -- p_kb_parent_category_id IN number:=FND_API.G_MISS_NUM,
115: -- p_display_name IN varchar2:=FND_API.G_MISS_CHAR,
116: -- p_category_code IN varchar2:=FND_API.G_MISS_CHAR,
117: -- p_is_repos IN VARCHAR2:=FND_API.G_MISS_CHAR,
118: -- p_category_order IN number:=FND_API.G_MISS_CHAR,
111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_kb_category_id IN NUMBER:=FND_API.G_MISS_NUM,
114: -- p_kb_parent_category_id IN number:=FND_API.G_MISS_NUM,
115: -- p_display_name IN varchar2:=FND_API.G_MISS_CHAR,
116: -- p_category_code IN varchar2:=FND_API.G_MISS_CHAR,
117: -- p_is_repos IN VARCHAR2:=FND_API.G_MISS_CHAR,
118: -- p_category_order IN number:=FND_API.G_MISS_CHAR,
119: -- p_category_desc varchar2:=FND_API.G_MISS_CHAR,
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_kb_category_id IN NUMBER:=FND_API.G_MISS_NUM,
114: -- p_kb_parent_category_id IN number:=FND_API.G_MISS_NUM,
115: -- p_display_name IN varchar2:=FND_API.G_MISS_CHAR,
116: -- p_category_code IN varchar2:=FND_API.G_MISS_CHAR,
117: -- p_is_repos IN VARCHAR2:=FND_API.G_MISS_CHAR,
118: -- p_category_order IN number:=FND_API.G_MISS_CHAR,
119: -- p_category_desc varchar2:=FND_API.G_MISS_CHAR,
120: --
113: -- p_kb_category_id IN NUMBER:=FND_API.G_MISS_NUM,
114: -- p_kb_parent_category_id IN number:=FND_API.G_MISS_NUM,
115: -- p_display_name IN varchar2:=FND_API.G_MISS_CHAR,
116: -- p_category_code IN varchar2:=FND_API.G_MISS_CHAR,
117: -- p_is_repos IN VARCHAR2:=FND_API.G_MISS_CHAR,
118: -- p_category_order IN number:=FND_API.G_MISS_CHAR,
119: -- p_category_desc varchar2:=FND_API.G_MISS_CHAR,
120: --
121: -- OUT
114: -- p_kb_parent_category_id IN number:=FND_API.G_MISS_NUM,
115: -- p_display_name IN varchar2:=FND_API.G_MISS_CHAR,
116: -- p_category_code IN varchar2:=FND_API.G_MISS_CHAR,
117: -- p_is_repos IN VARCHAR2:=FND_API.G_MISS_CHAR,
118: -- p_category_order IN number:=FND_API.G_MISS_CHAR,
119: -- p_category_desc varchar2:=FND_API.G_MISS_CHAR,
120: --
121: -- OUT
122: -- x_return_status OUT VARCHAR2
115: -- p_display_name IN varchar2:=FND_API.G_MISS_CHAR,
116: -- p_category_code IN varchar2:=FND_API.G_MISS_CHAR,
117: -- p_is_repos IN VARCHAR2:=FND_API.G_MISS_CHAR,
118: -- p_category_order IN number:=FND_API.G_MISS_CHAR,
119: -- p_category_desc varchar2:=FND_API.G_MISS_CHAR,
120: --
121: -- OUT
122: -- x_return_status OUT VARCHAR2
123: -- x_msg_count OUT NUMBER
129: -- End of comments
130: -- **********************************************************
131:
132: PROCEDURE update_item (p_api_version_number IN NUMBER,
133: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
134: p_commit IN VARCHAR2 := FND_API.G_FALSE,
135: p_kb_category_id IN NUMBER,
136: p_kb_parent_category_id IN number,
137: p_display_name IN varchar2,
130: -- **********************************************************
131:
132: PROCEDURE update_item (p_api_version_number IN NUMBER,
133: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
134: p_commit IN VARCHAR2 := FND_API.G_FALSE,
135: p_kb_category_id IN NUMBER,
136: p_kb_parent_category_id IN number,
137: p_display_name IN varchar2,
138: p_category_code IN varchar2,