181: --
182: -- End of Comments --
183: PROCEDURE unassociate_instance_pos (
184: p_api_version IN NUMBER := 1.0,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
182: -- End of Comments --
183: PROCEDURE unassociate_instance_pos (
184: p_api_version IN NUMBER := 1.0,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
183: PROCEDURE unassociate_instance_pos (
184: p_api_version IN NUMBER := 1.0,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_uc_header_id IN NUMBER,
213: --
214: -- End of Comments --
215: PROCEDURE remove_instance (
216: p_api_version IN NUMBER := 1.0,
217: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
218: p_commit IN VARCHAR2 := FND_API.G_FALSE,
219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
214: -- End of Comments --
215: PROCEDURE remove_instance (
216: p_api_version IN NUMBER := 1.0,
217: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
218: p_commit IN VARCHAR2 := FND_API.G_FALSE,
219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
215: PROCEDURE remove_instance (
216: p_api_version IN NUMBER := 1.0,
217: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
218: p_commit IN VARCHAR2 := FND_API.G_FALSE,
219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_uc_header_id IN NUMBER,
245: --
246: -- End of Comments --
247: PROCEDURE update_instance_attr(
248: p_api_version IN NUMBER := 1.0,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
246: -- End of Comments --
247: PROCEDURE update_instance_attr(
248: p_api_version IN NUMBER := 1.0,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
247: PROCEDURE update_instance_attr(
248: p_api_version IN NUMBER := 1.0,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
255: p_uc_header_id IN NUMBER,
283: --
284: -- End of Comments --
285: PROCEDURE install_new_instance(
286: p_api_version IN NUMBER := 1.0,
287: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
288: p_commit IN VARCHAR2 := FND_API.G_FALSE,
289: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
290: x_return_status OUT NOCOPY VARCHAR2,
291: x_msg_count OUT NOCOPY NUMBER,
284: -- End of Comments --
285: PROCEDURE install_new_instance(
286: p_api_version IN NUMBER := 1.0,
287: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
288: p_commit IN VARCHAR2 := FND_API.G_FALSE,
289: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
290: x_return_status OUT NOCOPY VARCHAR2,
291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
285: PROCEDURE install_new_instance(
286: p_api_version IN NUMBER := 1.0,
287: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
288: p_commit IN VARCHAR2 := FND_API.G_FALSE,
289: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
290: x_return_status OUT NOCOPY VARCHAR2,
291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_uc_header_id IN NUMBER,
318: --
319: -- End of Comments --
320: PROCEDURE install_existing_instance(
321: p_api_version IN NUMBER := 1.0,
322: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
323: p_commit IN VARCHAR2 := FND_API.G_FALSE,
324: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_msg_count OUT NOCOPY NUMBER,
319: -- End of Comments --
320: PROCEDURE install_existing_instance(
321: p_api_version IN NUMBER := 1.0,
322: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
323: p_commit IN VARCHAR2 := FND_API.G_FALSE,
324: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_msg_count OUT NOCOPY NUMBER,
327: x_msg_data OUT NOCOPY VARCHAR2,
320: PROCEDURE install_existing_instance(
321: p_api_version IN NUMBER := 1.0,
322: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
323: p_commit IN VARCHAR2 := FND_API.G_FALSE,
324: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_msg_count OUT NOCOPY NUMBER,
327: x_msg_data OUT NOCOPY VARCHAR2,
328: p_uc_header_id IN NUMBER,
332: p_relationship_id IN NUMBER,
333: p_csi_ii_ovn IN NUMBER,
334: p_prod_user_flag IN VARCHAR2,
335: -- SURRKUMA :: 13694898 :: Flag to bypass the validation of position completeness, 29-FEB-2012
336: p_validate_rule_flag IN VARCHAR2 := FND_API.G_TRUE,
337: x_warning_msg_tbl OUT NOCOPY ahl_uc_validation_pub.error_tbl_type);
338:
339: -- Start of Comments --
340: -- Define procedure swap_instances
357: --
358: -- End of Comments --
359: PROCEDURE swap_instance(
360: p_api_version IN NUMBER := 1.0,
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: -- End of Comments --
359: PROCEDURE swap_instance(
360: p_api_version IN NUMBER := 1.0,
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 swap_instance(
360: p_api_version IN NUMBER := 1.0,
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: p_uc_header_id IN NUMBER,
391: --
392: -- End of Comments --
393: PROCEDURE get_available_instances(
394: p_api_version IN NUMBER := 1.0,
395: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
396: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
397: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
398: x_return_status OUT NOCOPY VARCHAR2,
399: x_msg_count OUT NOCOPY NUMBER,
392: -- End of Comments --
393: PROCEDURE get_available_instances(
394: p_api_version IN NUMBER := 1.0,
395: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
396: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
397: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
398: x_return_status OUT NOCOPY VARCHAR2,
399: x_msg_count OUT NOCOPY NUMBER,
400: x_msg_data OUT NOCOPY VARCHAR2,
393: PROCEDURE get_available_instances(
394: p_api_version IN NUMBER := 1.0,
395: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
396: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
397: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
398: x_return_status OUT NOCOPY VARCHAR2,
399: x_msg_count OUT NOCOPY NUMBER,
400: x_msg_data OUT NOCOPY VARCHAR2,
401: p_parent_instance_id IN NUMBER, --in order to include the extra siblings
415: -- Balaji added for OGMA issue # 86
416: --****************************************************************************
417: PROCEDURE Get_Avail_Subinv_Instances(
418: p_api_version IN NUMBER := 1.0,
419: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
420: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
421: x_return_status OUT NOCOPY VARCHAR2,
422: x_msg_count OUT NOCOPY NUMBER,
423: x_msg_data OUT NOCOPY VARCHAR2,
416: --****************************************************************************
417: PROCEDURE Get_Avail_Subinv_Instances(
418: p_api_version IN NUMBER := 1.0,
419: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
420: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
421: x_return_status OUT NOCOPY VARCHAR2,
422: x_msg_count OUT NOCOPY NUMBER,
423: x_msg_data OUT NOCOPY VARCHAR2,
424: p_relationship_id IN NUMBER,
453: --
454: -- End of Comments --
455: PROCEDURE create_unassigned_instance(
456: p_api_version IN NUMBER := 1.0,
457: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
458: p_commit IN VARCHAR2 := FND_API.G_FALSE,
459: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
460: x_return_status OUT NOCOPY VARCHAR2,
461: x_msg_count OUT NOCOPY NUMBER,
454: -- End of Comments --
455: PROCEDURE create_unassigned_instance(
456: p_api_version IN NUMBER := 1.0,
457: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
458: p_commit IN VARCHAR2 := FND_API.G_FALSE,
459: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
460: x_return_status OUT NOCOPY VARCHAR2,
461: x_msg_count OUT NOCOPY NUMBER,
462: x_msg_data OUT NOCOPY VARCHAR2,
455: PROCEDURE create_unassigned_instance(
456: p_api_version IN NUMBER := 1.0,
457: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
458: p_commit IN VARCHAR2 := FND_API.G_FALSE,
459: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
460: x_return_status OUT NOCOPY VARCHAR2,
461: x_msg_count OUT NOCOPY NUMBER,
462: x_msg_data OUT NOCOPY VARCHAR2,
463: p_uc_header_id IN NUMBER,
489: --
490: -- End of Comments --
491: PROCEDURE get_instances_for_req(
492: p_api_version IN NUMBER := 1.0,
493: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
494: x_return_status OUT NOCOPY VARCHAR2,
495: x_msg_count OUT NOCOPY NUMBER,
496: x_msg_data OUT NOCOPY VARCHAR2,
497: p_schedule_material_id IN NUMBER,