47: -- End of Comments --
48: /*
49: PROCEDURE get_immediate_children(
50: p_api_version IN NUMBER := 1.0,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
48: /*
49: PROCEDURE get_immediate_children(
50: p_api_version IN NUMBER := 1.0,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
56: x_msg_data OUT NOCOPY VARCHAR2,
49: PROCEDURE get_immediate_children(
50: p_api_version IN NUMBER := 1.0,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
56: x_msg_data OUT NOCOPY VARCHAR2,
57: p_uc_parent_rec IN uc_child_rec_type,
74: --
75: -- End of Comments --
76: PROCEDURE get_whole_uc_tree(
77: p_api_version IN NUMBER := 1.0,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
79: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
75: -- End of Comments --
76: PROCEDURE get_whole_uc_tree(
77: p_api_version IN NUMBER := 1.0,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
79: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
76: PROCEDURE get_whole_uc_tree(
77: p_api_version IN NUMBER := 1.0,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
79: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: p_uc_header_id IN NUMBER,
103: --
104: -- End of Comments --
105: PROCEDURE migrate_uc_tree(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
104: -- End of Comments --
105: PROCEDURE migrate_uc_tree(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
105: PROCEDURE migrate_uc_tree(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
113: p_uc_header_id IN NUMBER,
133: --
134: -- End of Comments --
135: PROCEDURE remap_uc_subtree(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
134: -- End of Comments --
135: PROCEDURE remap_uc_subtree(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
135: PROCEDURE remap_uc_subtree(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_instance_id IN NUMBER,