2: /* $Header: PACITUVS.pls 120.1 2005/08/19 16:19:07 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_id IN NUMBER,
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_id IN NUMBER,
11: p_ci_type_id IN NUMBER,
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_id IN NUMBER,
11: p_ci_type_id IN NUMBER,
12: p_created_by IN NUMBER DEFAULT fnd_global.user_id,
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_id IN NUMBER,
11: p_ci_type_id IN NUMBER,
12: p_created_by IN NUMBER DEFAULT fnd_global.user_id,
13: p_creation_date IN DATE DEFAULT SYSDATE,
19: );
20:
21: PROCEDURE update_ci_type_usage (
22: p_api_version IN NUMBER := 1.0,
23: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
24: p_commit IN VARCHAR2 := FND_API.g_false,
25: p_validate_only IN VARCHAR2 := FND_API.g_true,
26: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
27: p_ci_type_usage_id IN NUMBER,
20:
21: PROCEDURE update_ci_type_usage (
22: p_api_version IN NUMBER := 1.0,
23: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
24: p_commit IN VARCHAR2 := FND_API.g_false,
25: p_validate_only IN VARCHAR2 := FND_API.g_true,
26: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
27: p_ci_type_usage_id IN NUMBER,
28: p_project_type_id IN NUMBER,
21: PROCEDURE update_ci_type_usage (
22: p_api_version IN NUMBER := 1.0,
23: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
24: p_commit IN VARCHAR2 := FND_API.g_false,
25: p_validate_only IN VARCHAR2 := FND_API.g_true,
26: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
27: p_ci_type_usage_id IN NUMBER,
28: p_project_type_id IN NUMBER,
29: p_ci_type_id IN NUMBER,
22: p_api_version IN NUMBER := 1.0,
23: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
24: p_commit IN VARCHAR2 := FND_API.g_false,
25: p_validate_only IN VARCHAR2 := FND_API.g_true,
26: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
27: p_ci_type_usage_id IN NUMBER,
28: p_project_type_id IN NUMBER,
29: p_ci_type_id IN NUMBER,
30: p_last_updated_by IN NUMBER DEFAULT fnd_global.user_id,
36: ) ;
37:
38: PROCEDURE delete_ci_type_usage (
39: p_api_version IN NUMBER := 1.0,
40: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
41: p_commit IN VARCHAR2 := FND_API.g_false,
42: p_validate_only IN VARCHAR2 := FND_API.g_true,
43: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
44: p_ci_type_usage_id IN NUMBER,
37:
38: PROCEDURE delete_ci_type_usage (
39: p_api_version IN NUMBER := 1.0,
40: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
41: p_commit IN VARCHAR2 := FND_API.g_false,
42: p_validate_only IN VARCHAR2 := FND_API.g_true,
43: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
44: p_ci_type_usage_id IN NUMBER,
45: p_project_type_id IN NUMBER,
38: PROCEDURE delete_ci_type_usage (
39: p_api_version IN NUMBER := 1.0,
40: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
41: p_commit IN VARCHAR2 := FND_API.g_false,
42: p_validate_only IN VARCHAR2 := FND_API.g_true,
43: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
44: p_ci_type_usage_id IN NUMBER,
45: p_project_type_id IN NUMBER,
46: p_ci_type_id IN NUMBER,
39: p_api_version IN NUMBER := 1.0,
40: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
41: p_commit IN VARCHAR2 := FND_API.g_false,
42: p_validate_only IN VARCHAR2 := FND_API.g_true,
43: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
44: p_ci_type_usage_id IN NUMBER,
45: p_project_type_id IN NUMBER,
46: p_ci_type_id IN NUMBER,
47: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895