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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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
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: );
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,