28:
29: PROCEDURE Flatten_Focus_Node
30: (
31: p_api_version IN NUMBER ,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
35: x_return_status OUT NOCOPY VARCHAR2 ,
36: x_msg_count OUT NOCOPY NUMBER ,
29: PROCEDURE Flatten_Focus_Node
30: (
31: p_api_version IN NUMBER ,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
35: x_return_status OUT NOCOPY VARCHAR2 ,
36: x_msg_count OUT NOCOPY NUMBER ,
37: x_msg_data OUT NOCOPY VARCHAR2 ,
30: (
31: p_api_version IN NUMBER ,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
35: x_return_status OUT NOCOPY VARCHAR2 ,
36: x_msg_count OUT NOCOPY NUMBER ,
37: x_msg_data OUT NOCOPY VARCHAR2 ,
38: --
44:
45: PROCEDURE Unflatten_Focus_Node_Tree
46: (
47: p_api_version IN NUMBER ,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
51: x_return_status OUT NOCOPY VARCHAR2 ,
52: x_msg_count OUT NOCOPY NUMBER ,
45: PROCEDURE Unflatten_Focus_Node_Tree
46: (
47: p_api_version IN NUMBER ,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
51: x_return_status OUT NOCOPY VARCHAR2 ,
52: x_msg_count OUT NOCOPY NUMBER ,
53: x_msg_data OUT NOCOPY VARCHAR2 ,
46: (
47: p_api_version IN NUMBER ,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
51: x_return_status OUT NOCOPY VARCHAR2 ,
52: x_msg_count OUT NOCOPY NUMBER ,
53: x_msg_data OUT NOCOPY VARCHAR2 ,
54: --
65:
66: PROCEDURE Flatten_Focus_Node_Tree
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 Flatten_Focus_Node_Tree
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: --
81:
82: PROCEDURE Flatten_Whole_Hier_Version
83: (
84: p_api_version IN NUMBER ,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
88: x_return_status OUT NOCOPY VARCHAR2 ,
89: x_msg_count OUT NOCOPY NUMBER ,
82: PROCEDURE Flatten_Whole_Hier_Version
83: (
84: p_api_version IN NUMBER ,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
88: x_return_status OUT NOCOPY VARCHAR2 ,
89: x_msg_count OUT NOCOPY NUMBER ,
90: x_msg_data OUT NOCOPY VARCHAR2 ,
83: (
84: p_api_version IN NUMBER ,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
88: x_return_status OUT NOCOPY VARCHAR2 ,
89: x_msg_count OUT NOCOPY NUMBER ,
90: x_msg_data OUT NOCOPY VARCHAR2 ,
91: --
119: );
120:
121: PROCEDURE insert_root_node (
122: p_api_version IN NUMBER ,
123: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
124: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
125: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
126: p_return_status OUT NOCOPY VARCHAR2 ,
127: p_msg_count OUT NOCOPY NUMBER ,
120:
121: PROCEDURE insert_root_node (
122: p_api_version IN NUMBER ,
123: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
124: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
125: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
126: p_return_status OUT NOCOPY VARCHAR2 ,
127: p_msg_count OUT NOCOPY NUMBER ,
128: p_msg_data OUT NOCOPY VARCHAR2 ,
121: PROCEDURE insert_root_node (
122: p_api_version IN NUMBER ,
123: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
124: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
125: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
126: p_return_status OUT NOCOPY VARCHAR2 ,
127: p_msg_count OUT NOCOPY NUMBER ,
128: p_msg_data OUT NOCOPY VARCHAR2 ,
129: p_rowid IN OUT NOCOPY VARCHAR2,
154: p_dest_end_date IN VARCHAR2);
155:
156: PROCEDURE duplicate_hierarchy (
157: p_api_version IN NUMBER ,
158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
159: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
161: p_return_status OUT NOCOPY VARCHAR2 ,
162: p_msg_count OUT NOCOPY NUMBER ,
155:
156: PROCEDURE duplicate_hierarchy (
157: p_api_version IN NUMBER ,
158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
159: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
161: p_return_status OUT NOCOPY VARCHAR2 ,
162: p_msg_count OUT NOCOPY NUMBER ,
163: p_msg_data OUT NOCOPY VARCHAR2 ,
156: PROCEDURE duplicate_hierarchy (
157: p_api_version IN NUMBER ,
158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
159: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
161: p_return_status OUT NOCOPY VARCHAR2 ,
162: p_msg_count OUT NOCOPY NUMBER ,
163: p_msg_data OUT NOCOPY VARCHAR2 ,
164: p_hier_table_name IN VARCHAR2,
185:
186:
187: PROCEDURE duplicate_hier_version(
188: p_api_version IN NUMBER ,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
192: p_return_status OUT NOCOPY VARCHAR2 ,
193: p_msg_count OUT NOCOPY NUMBER ,
186:
187: PROCEDURE duplicate_hier_version(
188: p_api_version IN NUMBER ,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
192: p_return_status OUT NOCOPY VARCHAR2 ,
193: p_msg_count OUT NOCOPY NUMBER ,
194: p_msg_data OUT NOCOPY VARCHAR2 ,
187: PROCEDURE duplicate_hier_version(
188: p_api_version IN NUMBER ,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
192: p_return_status OUT NOCOPY VARCHAR2 ,
193: p_msg_count OUT NOCOPY NUMBER ,
194: p_msg_data OUT NOCOPY VARCHAR2 ,
195: p_hier_table_name IN VARCHAR2,
207: p_hier_obj_id IN NUMBER);
208:
209: PROCEDURE delete_hierarchy(
210: p_api_version IN NUMBER ,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
214: p_return_status OUT NOCOPY VARCHAR2 ,
215: p_msg_count OUT NOCOPY NUMBER ,
208:
209: PROCEDURE delete_hierarchy(
210: p_api_version IN NUMBER ,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
214: p_return_status OUT NOCOPY VARCHAR2 ,
215: p_msg_count OUT NOCOPY NUMBER ,
216: p_msg_data OUT NOCOPY VARCHAR2 ,
209: PROCEDURE delete_hierarchy(
210: p_api_version IN NUMBER ,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
214: p_return_status OUT NOCOPY VARCHAR2 ,
215: p_msg_count OUT NOCOPY NUMBER ,
216: p_msg_data OUT NOCOPY VARCHAR2 ,
217: p_hier_table_name IN VARCHAR2,
224: p_hier_version_id IN NUMBER);
225:
226: PROCEDURE delete_hier_version(
227: p_api_version IN NUMBER ,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
229: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
230: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
231: p_return_status OUT NOCOPY VARCHAR2 ,
232: p_msg_count OUT NOCOPY NUMBER ,
225:
226: PROCEDURE delete_hier_version(
227: p_api_version IN NUMBER ,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
229: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
230: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
231: p_return_status OUT NOCOPY VARCHAR2 ,
232: p_msg_count OUT NOCOPY NUMBER ,
233: p_msg_data OUT NOCOPY VARCHAR2 ,
226: PROCEDURE delete_hier_version(
227: p_api_version IN NUMBER ,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
229: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
230: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
231: p_return_status OUT NOCOPY VARCHAR2 ,
232: p_msg_count OUT NOCOPY NUMBER ,
233: p_msg_data OUT NOCOPY VARCHAR2 ,
234: p_hier_table_name IN VARCHAR2,
237:
238: PROCEDURE Remove_Nodes
239: (
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
242: p_commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,
238: PROCEDURE Remove_Nodes
239: (
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
242: p_commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2,
239: (
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
242: p_commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2,
247: --
256:
257: PROCEDURE Move_Nodes
258: (
259: p_api_version IN NUMBER,
260: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
261: p_commit IN VARCHAR2 := FND_API.G_FALSE,
262: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
257: PROCEDURE Move_Nodes
258: (
259: p_api_version IN NUMBER,
260: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
261: p_commit IN VARCHAR2 := FND_API.G_FALSE,
262: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2,
258: (
259: p_api_version IN NUMBER,
260: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
261: p_commit IN VARCHAR2 := FND_API.G_FALSE,
262: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2,
266: --
277:
278: PROCEDURE Add_Nodes
279: (
280: p_api_version IN NUMBER,
281: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
282: p_commit IN VARCHAR2 := FND_API.G_FALSE,
283: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,
278: PROCEDURE Add_Nodes
279: (
280: p_api_version IN NUMBER,
281: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
282: p_commit IN VARCHAR2 := FND_API.G_FALSE,
283: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,
286: x_msg_data OUT NOCOPY VARCHAR2,
279: (
280: p_api_version IN NUMBER,
281: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
282: p_commit IN VARCHAR2 := FND_API.G_FALSE,
283: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,
286: x_msg_data OUT NOCOPY VARCHAR2,
287: --
297:
298: PROCEDURE Add_Root_Nodes
299: (
300: p_api_version IN NUMBER,
301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
302: p_commit IN VARCHAR2 := FND_API.G_FALSE,
303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
304: x_return_status OUT NOCOPY VARCHAR2,
305: x_msg_count OUT NOCOPY NUMBER,
298: PROCEDURE Add_Root_Nodes
299: (
300: p_api_version IN NUMBER,
301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
302: p_commit IN VARCHAR2 := FND_API.G_FALSE,
303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
304: x_return_status OUT NOCOPY VARCHAR2,
305: x_msg_count OUT NOCOPY NUMBER,
306: x_msg_data OUT NOCOPY VARCHAR2,
299: (
300: p_api_version IN NUMBER,
301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
302: p_commit IN VARCHAR2 := FND_API.G_FALSE,
303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
304: x_return_status OUT NOCOPY VARCHAR2,
305: x_msg_count OUT NOCOPY NUMBER,
306: x_msg_data OUT NOCOPY VARCHAR2,
307: --
313: );
314:
315: procedure Hier_Member_Sequence_Update (
316: p_api_version IN NUMBER ,
317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
318: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
320: p_return_status OUT NOCOPY VARCHAR2 ,
321: p_msg_count OUT NOCOPY NUMBER ,
314:
315: procedure Hier_Member_Sequence_Update (
316: p_api_version IN NUMBER ,
317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
318: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
320: p_return_status OUT NOCOPY VARCHAR2 ,
321: p_msg_count OUT NOCOPY NUMBER ,
322: p_msg_data OUT NOCOPY VARCHAR2 ,
315: procedure Hier_Member_Sequence_Update (
316: p_api_version IN NUMBER ,
317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
318: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
320: p_return_status OUT NOCOPY VARCHAR2 ,
321: p_msg_count OUT NOCOPY NUMBER ,
322: p_msg_data OUT NOCOPY VARCHAR2 ,
323: --
357: RETURN VARCHAR2;
358:
359: PROCEDURE Add_Relation(
360: p_api_version IN NUMBER,
361: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
362: p_commit IN VARCHAR2 := FND_API.G_FALSE,
363: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
364: x_return_status OUT NOCOPY VARCHAR2,
365: x_msg_count OUT NOCOPY NUMBER,
358:
359: PROCEDURE Add_Relation(
360: p_api_version IN NUMBER,
361: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
362: p_commit IN VARCHAR2 := FND_API.G_FALSE,
363: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
364: x_return_status OUT NOCOPY VARCHAR2,
365: x_msg_count OUT NOCOPY NUMBER,
366: x_msg_data OUT NOCOPY VARCHAR2,
359: PROCEDURE Add_Relation(
360: p_api_version IN NUMBER,
361: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
362: p_commit IN VARCHAR2 := FND_API.G_FALSE,
363: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
364: x_return_status OUT NOCOPY VARCHAR2,
365: x_msg_count OUT NOCOPY NUMBER,
366: x_msg_data OUT NOCOPY VARCHAR2,
367: --
378: );
379:
380: PROCEDURE Add_Relations(
381: p_api_version IN NUMBER,
382: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
383: p_commit IN VARCHAR2 := FND_API.G_FALSE,
384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
385: x_return_status OUT NOCOPY VARCHAR2,
386: x_msg_count OUT NOCOPY NUMBER,
379:
380: PROCEDURE Add_Relations(
381: p_api_version IN NUMBER,
382: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
383: p_commit IN VARCHAR2 := FND_API.G_FALSE,
384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
385: x_return_status OUT NOCOPY VARCHAR2,
386: x_msg_count OUT NOCOPY NUMBER,
387: x_msg_data OUT NOCOPY VARCHAR2,
380: PROCEDURE Add_Relations(
381: p_api_version IN NUMBER,
382: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
383: p_commit IN VARCHAR2 := FND_API.G_FALSE,
384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
385: x_return_status OUT NOCOPY VARCHAR2,
386: x_msg_count OUT NOCOPY NUMBER,
387: x_msg_data OUT NOCOPY VARCHAR2,
388: --
393: );
394:
395: PROCEDURE Update_Relation(
396: p_api_version IN NUMBER,
397: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
398: p_commit IN VARCHAR2 := FND_API.G_FALSE,
399: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_msg_count OUT NOCOPY NUMBER,
394:
395: PROCEDURE Update_Relation(
396: p_api_version IN NUMBER,
397: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
398: p_commit IN VARCHAR2 := FND_API.G_FALSE,
399: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_msg_count OUT NOCOPY NUMBER,
402: x_msg_data OUT NOCOPY VARCHAR2,
395: PROCEDURE Update_Relation(
396: p_api_version IN NUMBER,
397: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
398: p_commit IN VARCHAR2 := FND_API.G_FALSE,
399: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_msg_count OUT NOCOPY NUMBER,
402: x_msg_data OUT NOCOPY VARCHAR2,
403: --
415: );
416:
417: PROCEDURE Update_Relations(
418: p_api_version IN NUMBER,
419: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
420: p_commit IN VARCHAR2 := FND_API.G_FALSE,
421: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
422: x_return_status OUT NOCOPY VARCHAR2,
423: x_msg_count OUT NOCOPY NUMBER,
416:
417: PROCEDURE Update_Relations(
418: p_api_version IN NUMBER,
419: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
420: p_commit IN VARCHAR2 := FND_API.G_FALSE,
421: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
422: x_return_status OUT NOCOPY VARCHAR2,
423: x_msg_count OUT NOCOPY NUMBER,
424: x_msg_data OUT NOCOPY VARCHAR2,
417: PROCEDURE Update_Relations(
418: p_api_version IN NUMBER,
419: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
420: p_commit IN VARCHAR2 := FND_API.G_FALSE,
421: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
422: x_return_status OUT NOCOPY VARCHAR2,
423: x_msg_count OUT NOCOPY NUMBER,
424: x_msg_data OUT NOCOPY VARCHAR2,
425: --
430: );
431:
432: PROCEDURE Remove_Relation(
433: p_api_version IN NUMBER,
434: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
435: p_commit IN VARCHAR2 := FND_API.G_FALSE,
436: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,
431:
432: PROCEDURE Remove_Relation(
433: p_api_version IN NUMBER,
434: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
435: p_commit IN VARCHAR2 := FND_API.G_FALSE,
436: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,
439: x_msg_data OUT NOCOPY VARCHAR2,
432: PROCEDURE Remove_Relation(
433: p_api_version IN NUMBER,
434: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
435: p_commit IN VARCHAR2 := FND_API.G_FALSE,
436: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,
439: x_msg_data OUT NOCOPY VARCHAR2,
440: --
448:
449:
450: PROCEDURE Move_Relation(
451: p_api_version IN NUMBER,
452: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
453: p_commit IN VARCHAR2 := FND_API.G_FALSE,
454: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
455: x_return_status OUT NOCOPY VARCHAR2,
456: x_msg_count OUT NOCOPY NUMBER,
449:
450: PROCEDURE Move_Relation(
451: p_api_version IN NUMBER,
452: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
453: p_commit IN VARCHAR2 := FND_API.G_FALSE,
454: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
455: x_return_status OUT NOCOPY VARCHAR2,
456: x_msg_count OUT NOCOPY NUMBER,
457: x_msg_data OUT NOCOPY VARCHAR2,
450: PROCEDURE Move_Relation(
451: p_api_version IN NUMBER,
452: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
453: p_commit IN VARCHAR2 := FND_API.G_FALSE,
454: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
455: x_return_status OUT NOCOPY VARCHAR2,
456: x_msg_count OUT NOCOPY NUMBER,
457: x_msg_data OUT NOCOPY VARCHAR2,
458: --