DBA Data[Home] [Help]

APPS.AHL_UC_INSTANCE_PUB dependencies on CSI_ITEM_INSTANCES

Line 85: FROM csi_item_instances

81: x_return_status OUT NOCOPY VARCHAR2)
82: IS
83: CURSOR get_instance_id IS
84: SELECT instance_id
85: FROM csi_item_instances
86: WHERE instance_number = p_instance_num;
87: CURSOR check_instance_id IS
88: SELECT instance_id
89: FROM csi_item_instances

Line 89: FROM csi_item_instances

85: FROM csi_item_instances
86: WHERE instance_number = p_instance_num;
87: CURSOR check_instance_id IS
88: SELECT instance_id
89: FROM csi_item_instances
90: WHERE instance_id = p_instance_id;
91:
92: BEGIN
93: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 598: -- This API is used to create a new instance in csi_item_instances and assign it

594: p_data => x_msg_data);
595: END update_instance;
596:
597: -- Define procedure create_install_instance
598: -- This API is used to create a new instance in csi_item_instances and assign it
599: -- to a UC node. And if the UC node happens to be the root node of a sub-unit, then
600: -- it also create the corresponding sub UC header record as well.
601: PROCEDURE create_install_instance(
602: p_api_version IN NUMBER := 1.0,

Line 1113: -- This API is used to create a new instance in csi_item_instances as an extra

1109: END swap_instance;
1110:
1111: -- SATHAPLI::FP ER 6504147, 18-Nov-2008
1112: -- Define procedure create_unassigned_instance.
1113: -- This API is used to create a new instance in csi_item_instances as an extra
1114: -- instance attached to the root node.
1115: PROCEDURE create_unassigned_instance(
1116: p_api_version IN NUMBER := 1.0,
1117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,