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: ,p_ci_type_id IN NUMBER
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: ,p_ci_type_id IN NUMBER
12: ,p_summary IN VARCHAR2
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: ,p_ci_type_id IN NUMBER
12: ,p_summary IN VARCHAR2
13: ,p_status_code 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: ,p_ci_type_id IN NUMBER
12: ,p_summary IN VARCHAR2
13: ,p_status_code IN VARCHAR2
14: ,p_owner_id IN NUMBER
79:
80:
81: procedure UPDATE_CONTROL_ITEM (
82: p_api_version IN NUMBER := 1.0
83: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
84: ,p_commit IN VARCHAR2 := FND_API.g_false
85: ,p_validate_only IN VARCHAR2 := FND_API.g_true
86: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
87:
80:
81: procedure UPDATE_CONTROL_ITEM (
82: p_api_version IN NUMBER := 1.0
83: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
84: ,p_commit IN VARCHAR2 := FND_API.g_false
85: ,p_validate_only IN VARCHAR2 := FND_API.g_true
86: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
87:
88: ,p_ci_id IN NUMBER
81: procedure UPDATE_CONTROL_ITEM (
82: p_api_version IN NUMBER := 1.0
83: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
84: ,p_commit IN VARCHAR2 := FND_API.g_false
85: ,p_validate_only IN VARCHAR2 := FND_API.g_true
86: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
87:
88: ,p_ci_id IN NUMBER
89: ,p_ci_type_id IN NUMBER
82: p_api_version IN NUMBER := 1.0
83: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
84: ,p_commit IN VARCHAR2 := FND_API.g_false
85: ,p_validate_only IN VARCHAR2 := FND_API.g_true
86: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
87:
88: ,p_ci_id IN NUMBER
89: ,p_ci_type_id IN NUMBER
90: ,p_summary IN VARCHAR2
157: );
158:
159: procedure DELETE_CONTROL_ITEM (
160: p_api_version IN NUMBER := 1.0
161: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
162: ,p_commit IN VARCHAR2 := FND_API.g_false
163: ,p_validate_only IN VARCHAR2 := FND_API.g_true
164: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
165:
158:
159: procedure DELETE_CONTROL_ITEM (
160: p_api_version IN NUMBER := 1.0
161: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
162: ,p_commit IN VARCHAR2 := FND_API.g_false
163: ,p_validate_only IN VARCHAR2 := FND_API.g_true
164: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
165:
166: ,p_ci_id IN NUMBER
159: procedure DELETE_CONTROL_ITEM (
160: p_api_version IN NUMBER := 1.0
161: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
162: ,p_commit IN VARCHAR2 := FND_API.g_false
163: ,p_validate_only IN VARCHAR2 := FND_API.g_true
164: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
165:
166: ,p_ci_id IN NUMBER
167: ,p_record_version_number IN NUMBER
160: p_api_version IN NUMBER := 1.0
161: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
162: ,p_commit IN VARCHAR2 := FND_API.g_false
163: ,p_validate_only IN VARCHAR2 := FND_API.g_true
164: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
165:
166: ,p_ci_id IN NUMBER
167: ,p_record_version_number IN NUMBER
168: ,x_return_status OUT NOCOPY VARCHAR2
171: );
172:
173: procedure DELETE_ALL_CONTROL_ITEMS(
174: p_api_version IN NUMBER := 1.0
175: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
176: ,p_commit IN VARCHAR2 := FND_API.g_false
177: ,p_validate_only IN VARCHAR2 := FND_API.g_true
178: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
179:
172:
173: procedure DELETE_ALL_CONTROL_ITEMS(
174: p_api_version IN NUMBER := 1.0
175: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
176: ,p_commit IN VARCHAR2 := FND_API.g_false
177: ,p_validate_only IN VARCHAR2 := FND_API.g_true
178: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
179:
180: ,p_project_id IN NUMBER
173: procedure DELETE_ALL_CONTROL_ITEMS(
174: p_api_version IN NUMBER := 1.0
175: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
176: ,p_commit IN VARCHAR2 := FND_API.g_false
177: ,p_validate_only IN VARCHAR2 := FND_API.g_true
178: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
179:
180: ,p_project_id IN NUMBER
181: ,x_return_status OUT NOCOPY VARCHAR2
174: p_api_version IN NUMBER := 1.0
175: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
176: ,p_commit IN VARCHAR2 := FND_API.g_false
177: ,p_validate_only IN VARCHAR2 := FND_API.g_true
178: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
179:
180: ,p_project_id IN NUMBER
181: ,x_return_status OUT NOCOPY VARCHAR2
182: ,x_msg_count OUT NOCOPY NUMBER
184: );
185:
186: procedure COPY_CONTROL_ITEM (
187: p_api_version IN NUMBER := 1.0
188: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
189: ,p_commit IN VARCHAR2 := FND_API.g_false
190: ,p_validate_only IN VARCHAR2 := FND_API.g_true
191: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
192:
185:
186: procedure COPY_CONTROL_ITEM (
187: p_api_version IN NUMBER := 1.0
188: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
189: ,p_commit IN VARCHAR2 := FND_API.g_false
190: ,p_validate_only IN VARCHAR2 := FND_API.g_true
191: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
192:
193: ,p_project_id IN NUMBER
186: procedure COPY_CONTROL_ITEM (
187: p_api_version IN NUMBER := 1.0
188: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
189: ,p_commit IN VARCHAR2 := FND_API.g_false
190: ,p_validate_only IN VARCHAR2 := FND_API.g_true
191: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
192:
193: ,p_project_id IN NUMBER
194: ,p_ci_id_from IN NUMBER -- copy from this
187: p_api_version IN NUMBER := 1.0
188: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
189: ,p_commit IN VARCHAR2 := FND_API.g_false
190: ,p_validate_only IN VARCHAR2 := FND_API.g_true
191: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
192:
193: ,p_project_id IN NUMBER
194: ,p_ci_id_from IN NUMBER -- copy from this
195: ,p_ci_type_id IN NUMBER -- copy to this
206: );
207:
208: procedure INCLUDE_CONTROL_ITEM(
209: p_api_version IN NUMBER := 1.0
210: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
211: ,p_commit IN VARCHAR2 := FND_API.g_false
212: ,p_validate_only IN VARCHAR2 := FND_API.g_true
213: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
214:
207:
208: procedure INCLUDE_CONTROL_ITEM(
209: p_api_version IN NUMBER := 1.0
210: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
211: ,p_commit IN VARCHAR2 := FND_API.g_false
212: ,p_validate_only IN VARCHAR2 := FND_API.g_true
213: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
214:
215: ,p_from_ci_id IN NUMBER
208: procedure INCLUDE_CONTROL_ITEM(
209: p_api_version IN NUMBER := 1.0
210: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
211: ,p_commit IN VARCHAR2 := FND_API.g_false
212: ,p_validate_only IN VARCHAR2 := FND_API.g_true
213: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
214:
215: ,p_from_ci_id IN NUMBER
216: ,p_to_ci_id IN NUMBER
209: p_api_version IN NUMBER := 1.0
210: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
211: ,p_commit IN VARCHAR2 := FND_API.g_false
212: ,p_validate_only IN VARCHAR2 := FND_API.g_true
213: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
214:
215: ,p_from_ci_id IN NUMBER
216: ,p_to_ci_id IN NUMBER
217: ,p_record_version_number_to IN NUMBER
222: );
223:
224: procedure UPDATE_NUMBER_OF_ACTIONS (
225: p_api_version IN NUMBER := 1.0
226: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
227: ,p_commit IN VARCHAR2 := FND_API.g_false
228: ,p_validate_only IN VARCHAR2 := FND_API.g_true
229: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
230:
223:
224: procedure UPDATE_NUMBER_OF_ACTIONS (
225: p_api_version IN NUMBER := 1.0
226: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
227: ,p_commit IN VARCHAR2 := FND_API.g_false
228: ,p_validate_only IN VARCHAR2 := FND_API.g_true
229: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
230:
231: ,p_ci_id IN NUMBER
224: procedure UPDATE_NUMBER_OF_ACTIONS (
225: p_api_version IN NUMBER := 1.0
226: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
227: ,p_commit IN VARCHAR2 := FND_API.g_false
228: ,p_validate_only IN VARCHAR2 := FND_API.g_true
229: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
230:
231: ,p_ci_id IN NUMBER
232: ,p_num_of_actions IN NUMBER
225: p_api_version IN NUMBER := 1.0
226: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
227: ,p_commit IN VARCHAR2 := FND_API.g_false
228: ,p_validate_only IN VARCHAR2 := FND_API.g_true
229: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
230:
231: ,p_ci_id IN NUMBER
232: ,p_num_of_actions IN NUMBER
233: ,p_record_version_number IN NUMBER
242: );
243:
244: procedure UPDATE_CONTROL_ITEM_STATUS (
245: p_api_version IN NUMBER := 1.0
246: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
247: ,p_commit IN VARCHAR2 := FND_API.g_false
248: ,p_validate_only IN VARCHAR2 := FND_API.g_true
249: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
250:
243:
244: procedure UPDATE_CONTROL_ITEM_STATUS (
245: p_api_version IN NUMBER := 1.0
246: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
247: ,p_commit IN VARCHAR2 := FND_API.g_false
248: ,p_validate_only IN VARCHAR2 := FND_API.g_true
249: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
250:
251: ,p_ci_id IN NUMBER
244: procedure UPDATE_CONTROL_ITEM_STATUS (
245: p_api_version IN NUMBER := 1.0
246: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
247: ,p_commit IN VARCHAR2 := FND_API.g_false
248: ,p_validate_only IN VARCHAR2 := FND_API.g_true
249: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
250:
251: ,p_ci_id IN NUMBER
252: ,p_status_code IN VARCHAR2
245: p_api_version IN NUMBER := 1.0
246: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
247: ,p_commit IN VARCHAR2 := FND_API.g_false
248: ,p_validate_only IN VARCHAR2 := FND_API.g_true
249: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
250:
251: ,p_ci_id IN NUMBER
252: ,p_status_code IN VARCHAR2
253: ,p_record_version_number IN NUMBER
292: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
293:
294: PROCEDURE add_related_item (
295: p_api_version IN NUMBER := 1.0,
296: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
297: p_commit IN VARCHAR2 := FND_API.g_false,
298: p_validate_only IN VARCHAR2 := FND_API.g_true,
299: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
300: p_ci_id IN NUMBER,
293:
294: PROCEDURE add_related_item (
295: p_api_version IN NUMBER := 1.0,
296: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
297: p_commit IN VARCHAR2 := FND_API.g_false,
298: p_validate_only IN VARCHAR2 := FND_API.g_true,
299: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
300: p_ci_id IN NUMBER,
301: p_related_ci_id IN NUMBER,
294: PROCEDURE add_related_item (
295: p_api_version IN NUMBER := 1.0,
296: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
297: p_commit IN VARCHAR2 := FND_API.g_false,
298: p_validate_only IN VARCHAR2 := FND_API.g_true,
299: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
300: p_ci_id IN NUMBER,
301: p_related_ci_id IN NUMBER,
302: x_return_status OUT NOCOPY VARCHAR2,
295: p_api_version IN NUMBER := 1.0,
296: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
297: p_commit IN VARCHAR2 := FND_API.g_false,
298: p_validate_only IN VARCHAR2 := FND_API.g_true,
299: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
300: p_ci_id IN NUMBER,
301: p_related_ci_id IN NUMBER,
302: x_return_status OUT NOCOPY VARCHAR2,
303: x_msg_count OUT NOCOPY NUMBER,
305: );
306:
307: PROCEDURE delete_related_item (
308: p_api_version IN NUMBER := 1.0,
309: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
310: p_commit IN VARCHAR2 := FND_API.g_false,
311: p_validate_only IN VARCHAR2 := FND_API.g_true,
312: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
313: p_ci_id IN NUMBER,
306:
307: PROCEDURE delete_related_item (
308: p_api_version IN NUMBER := 1.0,
309: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
310: p_commit IN VARCHAR2 := FND_API.g_false,
311: p_validate_only IN VARCHAR2 := FND_API.g_true,
312: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
313: p_ci_id IN NUMBER,
314: p_related_ci_id IN NUMBER,
307: PROCEDURE delete_related_item (
308: p_api_version IN NUMBER := 1.0,
309: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
310: p_commit IN VARCHAR2 := FND_API.g_false,
311: p_validate_only IN VARCHAR2 := FND_API.g_true,
312: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
313: p_ci_id IN NUMBER,
314: p_related_ci_id IN NUMBER,
315: x_return_status OUT NOCOPY VARCHAR2,
308: p_api_version IN NUMBER := 1.0,
309: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
310: p_commit IN VARCHAR2 := FND_API.g_false,
311: p_validate_only IN VARCHAR2 := FND_API.g_true,
312: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
313: p_ci_id IN NUMBER,
314: p_related_ci_id IN NUMBER,
315: x_return_status OUT NOCOPY VARCHAR2,
316: x_msg_count OUT NOCOPY NUMBER,
318: );
319:
320: PROCEDURE delete_all_related_items (
321: p_api_version IN NUMBER := 1.0,
322: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
323: p_commit IN VARCHAR2 := FND_API.g_false,
324: p_validate_only IN VARCHAR2 := FND_API.g_true,
325: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
326: p_ci_id IN NUMBER,
319:
320: PROCEDURE delete_all_related_items (
321: p_api_version IN NUMBER := 1.0,
322: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
323: p_commit IN VARCHAR2 := FND_API.g_false,
324: p_validate_only IN VARCHAR2 := FND_API.g_true,
325: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
326: p_ci_id IN NUMBER,
327: x_return_status OUT NOCOPY VARCHAR2,
320: PROCEDURE delete_all_related_items (
321: p_api_version IN NUMBER := 1.0,
322: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
323: p_commit IN VARCHAR2 := FND_API.g_false,
324: p_validate_only IN VARCHAR2 := FND_API.g_true,
325: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
326: p_ci_id IN NUMBER,
327: x_return_status OUT NOCOPY VARCHAR2,
328: x_msg_count OUT NOCOPY NUMBER,
321: p_api_version IN NUMBER := 1.0,
322: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
323: p_commit IN VARCHAR2 := FND_API.g_false,
324: p_validate_only IN VARCHAR2 := FND_API.g_true,
325: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
326: p_ci_id IN NUMBER,
327: x_return_status OUT NOCOPY VARCHAR2,
328: x_msg_count OUT NOCOPY NUMBER,
329: x_msg_data OUT NOCOPY VARCHAR2
330: );
331:
332: PROCEDURE copy_related_items (
333: p_api_version IN NUMBER := 1.0,
334: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
335: p_commit IN VARCHAR2 := FND_API.g_false,
336: p_validate_only IN VARCHAR2 := FND_API.g_true,
337: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
338: p_from_ci_id IN NUMBER,
331:
332: PROCEDURE copy_related_items (
333: p_api_version IN NUMBER := 1.0,
334: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
335: p_commit IN VARCHAR2 := FND_API.g_false,
336: p_validate_only IN VARCHAR2 := FND_API.g_true,
337: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
338: p_from_ci_id IN NUMBER,
339: p_to_ci_id IN NUMBER,
332: PROCEDURE copy_related_items (
333: p_api_version IN NUMBER := 1.0,
334: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
335: p_commit IN VARCHAR2 := FND_API.g_false,
336: p_validate_only IN VARCHAR2 := FND_API.g_true,
337: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
338: p_from_ci_id IN NUMBER,
339: p_to_ci_id IN NUMBER,
340: x_return_status OUT NOCOPY VARCHAR2,
333: p_api_version IN NUMBER := 1.0,
334: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
335: p_commit IN VARCHAR2 := FND_API.g_false,
336: p_validate_only IN VARCHAR2 := FND_API.g_true,
337: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
338: p_from_ci_id IN NUMBER,
339: p_to_ci_id IN NUMBER,
340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,
343: );
344:
345: PROCEDURE delete_all_included_crs (
346: p_api_version IN NUMBER := 1.0,
347: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
348: p_commit IN VARCHAR2 := FND_API.g_false,
349: p_validate_only IN VARCHAR2 := FND_API.g_true,
350: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
351: p_ci_id IN NUMBER,
344:
345: PROCEDURE delete_all_included_crs (
346: p_api_version IN NUMBER := 1.0,
347: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
348: p_commit IN VARCHAR2 := FND_API.g_false,
349: p_validate_only IN VARCHAR2 := FND_API.g_true,
350: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
351: p_ci_id IN NUMBER,
352: x_return_status OUT NOCOPY VARCHAR2,
345: PROCEDURE delete_all_included_crs (
346: p_api_version IN NUMBER := 1.0,
347: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
348: p_commit IN VARCHAR2 := FND_API.g_false,
349: p_validate_only IN VARCHAR2 := FND_API.g_true,
350: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
351: p_ci_id IN NUMBER,
352: x_return_status OUT NOCOPY VARCHAR2,
353: x_msg_count OUT NOCOPY NUMBER,
346: p_api_version IN NUMBER := 1.0,
347: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
348: p_commit IN VARCHAR2 := FND_API.g_false,
349: p_validate_only IN VARCHAR2 := FND_API.g_true,
350: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
351: p_ci_id IN NUMBER,
352: x_return_status OUT NOCOPY VARCHAR2,
353: x_msg_count OUT NOCOPY NUMBER,
354: x_msg_data OUT NOCOPY VARCHAR2);
356:
357: -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
358: procedure LOCK_CONTROL_ITEM (
359: p_api_version IN NUMBER := 1.0
360: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
361: ,p_commit IN VARCHAR2 := FND_API.g_false
362: ,p_validate_only IN VARCHAR2 := FND_API.g_true
363: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
364: ,p_ci_id IN NUMBER
357: -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
358: procedure LOCK_CONTROL_ITEM (
359: p_api_version IN NUMBER := 1.0
360: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
361: ,p_commit IN VARCHAR2 := FND_API.g_false
362: ,p_validate_only IN VARCHAR2 := FND_API.g_true
363: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
364: ,p_ci_id IN NUMBER
365: ,x_return_status OUT NOCOPY VARCHAR2
358: procedure LOCK_CONTROL_ITEM (
359: p_api_version IN NUMBER := 1.0
360: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
361: ,p_commit IN VARCHAR2 := FND_API.g_false
362: ,p_validate_only IN VARCHAR2 := FND_API.g_true
363: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
364: ,p_ci_id IN NUMBER
365: ,x_return_status OUT NOCOPY VARCHAR2
366: ,x_msg_count OUT NOCOPY NUMBER
359: p_api_version IN NUMBER := 1.0
360: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
361: ,p_commit IN VARCHAR2 := FND_API.g_false
362: ,p_validate_only IN VARCHAR2 := FND_API.g_true
363: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
364: ,p_ci_id IN NUMBER
365: ,x_return_status OUT NOCOPY VARCHAR2
366: ,x_msg_count OUT NOCOPY NUMBER
367: ,x_msg_data OUT NOCOPY VARCHAR2