3:
4:
5: procedure ADD_CONTROL_ITEM (
6: p_api_version IN NUMBER := 1.0
7: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
8: ,p_commit IN VARCHAR2 := FND_API.g_false
9: ,p_validate_only IN VARCHAR2 := FND_API.g_true
10: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
11:
4:
5: procedure ADD_CONTROL_ITEM (
6: p_api_version IN NUMBER := 1.0
7: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
8: ,p_commit IN VARCHAR2 := FND_API.g_false
9: ,p_validate_only IN VARCHAR2 := FND_API.g_true
10: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
11:
12: ,p_ci_type_id IN NUMBER
5: procedure ADD_CONTROL_ITEM (
6: p_api_version IN NUMBER := 1.0
7: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
8: ,p_commit IN VARCHAR2 := FND_API.g_false
9: ,p_validate_only IN VARCHAR2 := FND_API.g_true
10: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
11:
12: ,p_ci_type_id IN NUMBER
13: ,p_summary IN VARCHAR2
6: p_api_version IN NUMBER := 1.0
7: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
8: ,p_commit IN VARCHAR2 := FND_API.g_false
9: ,p_validate_only IN VARCHAR2 := FND_API.g_true
10: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
11:
12: ,p_ci_type_id IN NUMBER
13: ,p_summary IN VARCHAR2
14: ,p_status_code IN VARCHAR2
85:
86:
87: procedure UPDATE_CONTROL_ITEM (
88: p_api_version IN NUMBER := 1.0
89: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
90: ,p_commit IN VARCHAR2 := FND_API.g_false
91: ,p_validate_only IN VARCHAR2 := FND_API.g_true
92: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
93:
86:
87: procedure UPDATE_CONTROL_ITEM (
88: p_api_version IN NUMBER := 1.0
89: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
90: ,p_commit IN VARCHAR2 := FND_API.g_false
91: ,p_validate_only IN VARCHAR2 := FND_API.g_true
92: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
93:
94: ,p_ci_id IN NUMBER
87: procedure UPDATE_CONTROL_ITEM (
88: p_api_version IN NUMBER := 1.0
89: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
90: ,p_commit IN VARCHAR2 := FND_API.g_false
91: ,p_validate_only IN VARCHAR2 := FND_API.g_true
92: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
93:
94: ,p_ci_id IN NUMBER
95: ,p_ci_type_id IN NUMBER
88: p_api_version IN NUMBER := 1.0
89: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
90: ,p_commit IN VARCHAR2 := FND_API.g_false
91: ,p_validate_only IN VARCHAR2 := FND_API.g_true
92: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
93:
94: ,p_ci_id IN NUMBER
95: ,p_ci_type_id IN NUMBER
96: ,p_summary IN VARCHAR2
166: );
167:
168: procedure DELETE_CONTROL_ITEM (
169: p_api_version IN NUMBER := 1.0
170: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
171: ,p_commit IN VARCHAR2 := FND_API.g_false
172: ,p_validate_only IN VARCHAR2 := FND_API.g_true
173: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
174:
167:
168: procedure DELETE_CONTROL_ITEM (
169: p_api_version IN NUMBER := 1.0
170: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
171: ,p_commit IN VARCHAR2 := FND_API.g_false
172: ,p_validate_only IN VARCHAR2 := FND_API.g_true
173: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
174:
175: ,p_ci_id IN NUMBER
168: procedure DELETE_CONTROL_ITEM (
169: p_api_version IN NUMBER := 1.0
170: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
171: ,p_commit IN VARCHAR2 := FND_API.g_false
172: ,p_validate_only IN VARCHAR2 := FND_API.g_true
173: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
174:
175: ,p_ci_id IN NUMBER
176: ,p_record_version_number IN NUMBER
169: p_api_version IN NUMBER := 1.0
170: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
171: ,p_commit IN VARCHAR2 := FND_API.g_false
172: ,p_validate_only IN VARCHAR2 := FND_API.g_true
173: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
174:
175: ,p_ci_id IN NUMBER
176: ,p_record_version_number IN NUMBER
177: ,x_return_status OUT NOCOPY VARCHAR2
179: ,x_msg_data OUT NOCOPY VARCHAR2
180: );
181: procedure INCLUDE_CONTROL_ITEM(
182: p_api_version IN NUMBER := 1.0
183: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
184: ,p_commit IN VARCHAR2 := FND_API.g_false
185: ,p_validate_only IN VARCHAR2 := FND_API.g_true
186: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
187:
180: );
181: procedure INCLUDE_CONTROL_ITEM(
182: p_api_version IN NUMBER := 1.0
183: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
184: ,p_commit IN VARCHAR2 := FND_API.g_false
185: ,p_validate_only IN VARCHAR2 := FND_API.g_true
186: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
187:
188: ,p_from_ci_id IN NUMBER
181: procedure INCLUDE_CONTROL_ITEM(
182: p_api_version IN NUMBER := 1.0
183: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
184: ,p_commit IN VARCHAR2 := FND_API.g_false
185: ,p_validate_only IN VARCHAR2 := FND_API.g_true
186: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
187:
188: ,p_from_ci_id IN NUMBER
189: ,p_to_ci_id IN NUMBER
182: p_api_version IN NUMBER := 1.0
183: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
184: ,p_commit IN VARCHAR2 := FND_API.g_false
185: ,p_validate_only IN VARCHAR2 := FND_API.g_true
186: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
187:
188: ,p_from_ci_id IN NUMBER
189: ,p_to_ci_id IN NUMBER
190: ,p_record_version_number_to IN NUMBER
196:
197:
198: procedure COPY_CONTROL_ITEM (
199: p_api_version IN NUMBER := 1.0
200: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
201: ,p_commit IN VARCHAR2 := FND_API.g_false
202: ,p_validate_only IN VARCHAR2 := FND_API.g_true
203: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
204:
197:
198: procedure COPY_CONTROL_ITEM (
199: p_api_version IN NUMBER := 1.0
200: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
201: ,p_commit IN VARCHAR2 := FND_API.g_false
202: ,p_validate_only IN VARCHAR2 := FND_API.g_true
203: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
204:
205: ,p_project_id IN NUMBER
198: procedure COPY_CONTROL_ITEM (
199: p_api_version IN NUMBER := 1.0
200: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
201: ,p_commit IN VARCHAR2 := FND_API.g_false
202: ,p_validate_only IN VARCHAR2 := FND_API.g_true
203: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
204:
205: ,p_project_id IN NUMBER
206: ,p_ci_id_from IN NUMBER
199: p_api_version IN NUMBER := 1.0
200: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
201: ,p_commit IN VARCHAR2 := FND_API.g_false
202: ,p_validate_only IN VARCHAR2 := FND_API.g_true
203: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
204:
205: ,p_project_id IN NUMBER
206: ,p_ci_id_from IN NUMBER
207: ,p_ci_type_id IN NUMBER
223:
224: -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
225: procedure LOCK_CONTROL_ITEM (
226: p_api_version IN NUMBER := 1.0
227: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
228: ,p_commit IN VARCHAR2 := FND_API.g_false
229: ,p_validate_only IN VARCHAR2 := FND_API.g_true
230: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
231: ,p_ci_id IN NUMBER
224: -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
225: procedure LOCK_CONTROL_ITEM (
226: p_api_version IN NUMBER := 1.0
227: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
228: ,p_commit IN VARCHAR2 := FND_API.g_false
229: ,p_validate_only IN VARCHAR2 := FND_API.g_true
230: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
231: ,p_ci_id IN NUMBER
232: ,x_return_status OUT NOCOPY VARCHAR2
225: procedure LOCK_CONTROL_ITEM (
226: p_api_version IN NUMBER := 1.0
227: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
228: ,p_commit IN VARCHAR2 := FND_API.g_false
229: ,p_validate_only IN VARCHAR2 := FND_API.g_true
230: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
231: ,p_ci_id IN NUMBER
232: ,x_return_status OUT NOCOPY VARCHAR2
233: ,x_msg_count OUT NOCOPY NUMBER
226: p_api_version IN NUMBER := 1.0
227: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
228: ,p_commit IN VARCHAR2 := FND_API.g_false
229: ,p_validate_only IN VARCHAR2 := FND_API.g_true
230: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
231: ,p_ci_id IN NUMBER
232: ,x_return_status OUT NOCOPY VARCHAR2
233: ,x_msg_count OUT NOCOPY NUMBER
234: ,x_msg_data OUT NOCOPY VARCHAR2