8: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
9:
10: PROCEDURE create_ci_type (
11: p_api_version IN NUMBER := 1.0,
12: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
13: p_commit IN VARCHAR2 := FND_API.g_false,
14: p_validate_only IN VARCHAR2 := FND_API.g_true,
15: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
16: p_name IN VARCHAR2,
9:
10: PROCEDURE create_ci_type (
11: p_api_version IN NUMBER := 1.0,
12: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
13: p_commit IN VARCHAR2 := FND_API.g_false,
14: p_validate_only IN VARCHAR2 := FND_API.g_true,
15: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
16: p_name IN VARCHAR2,
17: p_short_name IN VARCHAR2,
10: PROCEDURE create_ci_type (
11: p_api_version IN NUMBER := 1.0,
12: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
13: p_commit IN VARCHAR2 := FND_API.g_false,
14: p_validate_only IN VARCHAR2 := FND_API.g_true,
15: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
16: p_name IN VARCHAR2,
17: p_short_name IN VARCHAR2,
18: p_description IN VARCHAR2,
11: p_api_version IN NUMBER := 1.0,
12: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
13: p_commit IN VARCHAR2 := FND_API.g_false,
14: p_validate_only IN VARCHAR2 := FND_API.g_true,
15: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
16: p_name IN VARCHAR2,
17: p_short_name IN VARCHAR2,
18: p_description IN VARCHAR2,
19: p_ci_type_class_code IN VARCHAR2,
68: );
69:
70: PROCEDURE update_ci_type (
71: p_api_version IN NUMBER := 1.0,
72: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
73: p_commit IN VARCHAR2 := FND_API.g_false,
74: p_validate_only IN VARCHAR2 := FND_API.g_true,
75: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
76: p_ci_type_id IN NUMBER,
69:
70: PROCEDURE update_ci_type (
71: p_api_version IN NUMBER := 1.0,
72: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
73: p_commit IN VARCHAR2 := FND_API.g_false,
74: p_validate_only IN VARCHAR2 := FND_API.g_true,
75: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
76: p_ci_type_id IN NUMBER,
77: p_name IN VARCHAR2,
70: PROCEDURE update_ci_type (
71: p_api_version IN NUMBER := 1.0,
72: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
73: p_commit IN VARCHAR2 := FND_API.g_false,
74: p_validate_only IN VARCHAR2 := FND_API.g_true,
75: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
76: p_ci_type_id IN NUMBER,
77: p_name IN VARCHAR2,
78: p_short_name IN VARCHAR2,
71: p_api_version IN NUMBER := 1.0,
72: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
73: p_commit IN VARCHAR2 := FND_API.g_false,
74: p_validate_only IN VARCHAR2 := FND_API.g_true,
75: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
76: p_ci_type_id IN NUMBER,
77: p_name IN VARCHAR2,
78: p_short_name IN VARCHAR2,
79: p_description IN VARCHAR2,
129: );
130:
131: PROCEDURE delete_ci_type (
132: p_api_version IN NUMBER := 1.0,
133: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
134: p_commit IN VARCHAR2 := FND_API.g_false,
135: p_validate_only IN VARCHAR2 := FND_API.g_true,
136: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
137: p_ci_type_id IN NUMBER,
130:
131: PROCEDURE delete_ci_type (
132: p_api_version IN NUMBER := 1.0,
133: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
134: p_commit IN VARCHAR2 := FND_API.g_false,
135: p_validate_only IN VARCHAR2 := FND_API.g_true,
136: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
137: p_ci_type_id IN NUMBER,
138: p_record_version_number IN NUMBER,
131: PROCEDURE delete_ci_type (
132: p_api_version IN NUMBER := 1.0,
133: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
134: p_commit IN VARCHAR2 := FND_API.g_false,
135: p_validate_only IN VARCHAR2 := FND_API.g_true,
136: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
137: p_ci_type_id IN NUMBER,
138: p_record_version_number IN NUMBER,
139: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
132: p_api_version IN NUMBER := 1.0,
133: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
134: p_commit IN VARCHAR2 := FND_API.g_false,
135: p_validate_only IN VARCHAR2 := FND_API.g_true,
136: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
137: p_ci_type_id IN NUMBER,
138: p_record_version_number IN NUMBER,
139: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
140: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895