2: /* $Header: PACITUPS.pls 120.1 2005/08/19 16:18:51 mwasowic noship $ */
3:
4: PROCEDURE create_ci_type_usage (
5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_project_type IN VARCHAR2 := NULL,
3:
4: PROCEDURE create_ci_type_usage (
5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_project_type IN VARCHAR2 := NULL,
11: p_project_type_id IN NUMBER := NULL,
4: PROCEDURE create_ci_type_usage (
5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_project_type IN VARCHAR2 := NULL,
11: p_project_type_id IN NUMBER := NULL,
12: p_ci_type_name IN VARCHAR2 := NULL,
5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_project_type IN VARCHAR2 := NULL,
11: p_project_type_id IN NUMBER := NULL,
12: p_ci_type_name IN VARCHAR2 := NULL,
13: p_ci_type_id IN NUMBER := NULL,
21: );
22:
23: PROCEDURE update_ci_type_usage (
24: p_api_version IN NUMBER := 1.0,
25: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
26: p_commit IN VARCHAR2 := FND_API.g_false,
27: p_validate_only IN VARCHAR2 := FND_API.g_true,
28: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
29: p_ci_type_usage_id IN NUMBER,
22:
23: PROCEDURE update_ci_type_usage (
24: p_api_version IN NUMBER := 1.0,
25: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
26: p_commit IN VARCHAR2 := FND_API.g_false,
27: p_validate_only IN VARCHAR2 := FND_API.g_true,
28: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
29: p_ci_type_usage_id IN NUMBER,
30: p_project_type IN VARCHAR2 := NULL,
23: PROCEDURE update_ci_type_usage (
24: p_api_version IN NUMBER := 1.0,
25: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
26: p_commit IN VARCHAR2 := FND_API.g_false,
27: p_validate_only IN VARCHAR2 := FND_API.g_true,
28: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
29: p_ci_type_usage_id IN NUMBER,
30: p_project_type IN VARCHAR2 := NULL,
31: p_project_type_id IN NUMBER := NULL,
24: p_api_version IN NUMBER := 1.0,
25: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
26: p_commit IN VARCHAR2 := FND_API.g_false,
27: p_validate_only IN VARCHAR2 := FND_API.g_true,
28: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
29: p_ci_type_usage_id IN NUMBER,
30: p_project_type IN VARCHAR2 := NULL,
31: p_project_type_id IN NUMBER := NULL,
32: p_ci_type_name IN VARCHAR2 := NULL,
40: );
41:
42: PROCEDURE delete_ci_type_usage (
43: p_api_version IN NUMBER := 1.0,
44: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
45: p_commit IN VARCHAR2 := FND_API.g_false,
46: p_validate_only IN VARCHAR2 := FND_API.g_true,
47: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
48: p_ci_type_usage_id IN NUMBER,
41:
42: PROCEDURE delete_ci_type_usage (
43: p_api_version IN NUMBER := 1.0,
44: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
45: p_commit IN VARCHAR2 := FND_API.g_false,
46: p_validate_only IN VARCHAR2 := FND_API.g_true,
47: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
48: p_ci_type_usage_id IN NUMBER,
49: p_project_type IN VARCHAR2 := NULL,
42: PROCEDURE delete_ci_type_usage (
43: p_api_version IN NUMBER := 1.0,
44: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
45: p_commit IN VARCHAR2 := FND_API.g_false,
46: p_validate_only IN VARCHAR2 := FND_API.g_true,
47: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
48: p_ci_type_usage_id IN NUMBER,
49: p_project_type IN VARCHAR2 := NULL,
50: p_project_type_id IN NUMBER := NULL,
43: p_api_version IN NUMBER := 1.0,
44: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
45: p_commit IN VARCHAR2 := FND_API.g_false,
46: p_validate_only IN VARCHAR2 := FND_API.g_true,
47: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
48: p_ci_type_usage_id IN NUMBER,
49: p_project_type IN VARCHAR2 := NULL,
50: p_project_type_id IN NUMBER := NULL,
51: p_ci_type_name IN VARCHAR2 := NULL,