DBA Data[Home] [Help]

APPS.FEM_HIER_UTILS_PVT dependencies on FND_API

Line 32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 33: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

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: --

Line 48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 49: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

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: --

Line 69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 70: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 71: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

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: --

Line 85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 86: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

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: --

Line 123: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 124: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 125: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

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,

Line 158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 159: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

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,

Line 189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 190: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

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,

Line 211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 212: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

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,

Line 228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 229: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 230: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

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,

Line 241: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 242: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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: --

Line 260: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 261: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 262: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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: --

Line 281: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 282: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 283: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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: --

Line 301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 302: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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: --

Line 317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 318: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

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: --

Line 361: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 362: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 363: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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: --

Line 382: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 383: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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: --

Line 397: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 398: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 399: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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: --

Line 419: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 420: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 421: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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: --

Line 434: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 435: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 436: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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: --

Line 452: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 453: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 454: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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: --