5: -- Type : Public
6: -- Pre-reqs : None.
7: -- Parameters :
8: -- p_api_version IN NUMBER Required Default = 1.0
9: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
10: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
11: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
12: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
6: -- Pre-reqs : None.
7: -- Parameters :
8: -- p_api_version IN NUMBER Required Default = 1.0
9: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
10: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
11: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
12: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
14: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
7: -- Parameters :
8: -- p_api_version IN NUMBER Required Default = 1.0
9: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
10: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
11: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
12: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
14: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
15: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
8: -- p_api_version IN NUMBER Required Default = 1.0
9: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
10: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
11: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
12: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
14: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
15: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
16: -- p_project_id IN NUMBER Required
11: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
12: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
14: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
15: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
16: -- p_project_id IN NUMBER Required
17: -- x_return_status OUT VARCHAR2 Required
18: -- x_msg_count OUT NUMBER Required
19: -- x_msg_data OUT VARCHAR2 Optional
19: -- x_msg_data OUT VARCHAR2 Optional
20:
21: PROCEDURE COPY_PROJECT_DATES
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
27: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
20:
21: PROCEDURE COPY_PROJECT_DATES
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
27: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
28: ,p_debug_mode IN VARCHAR2 := 'N'
21: PROCEDURE COPY_PROJECT_DATES
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
27: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
28: ,p_debug_mode IN VARCHAR2 := 'N'
29: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
27: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
28: ,p_debug_mode IN VARCHAR2 := 'N'
29: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
30: ,p_project_id IN NUMBER
25: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
26: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
27: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
28: ,p_debug_mode IN VARCHAR2 := 'N'
29: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
30: ,p_project_id IN NUMBER
31: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
33: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
38: -- Type : Public
39: -- Pre-reqs : None.
40: -- Parameters :
41: -- p_api_version IN NUMBER Required Default = 1.0
42: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
43: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
44: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
45: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
46: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
39: -- Pre-reqs : None.
40: -- Parameters :
41: -- p_api_version IN NUMBER Required Default = 1.0
42: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
43: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
44: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
45: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
46: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
47: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
40: -- Parameters :
41: -- p_api_version IN NUMBER Required Default = 1.0
42: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
43: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
44: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
45: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
46: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
47: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
48: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
41: -- p_api_version IN NUMBER Required Default = 1.0
42: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
43: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
44: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
45: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
46: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
47: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
48: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
49: -- p_project_id IN NUMBER Required
44: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
45: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
46: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
47: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
48: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
49: -- p_project_id IN NUMBER Required
50: -- p_date_type IN VARCHAR2 Required
51: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
52: -- p_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE
47: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
48: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
49: -- p_project_id IN NUMBER Required
50: -- p_date_type IN VARCHAR2 Required
51: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
52: -- p_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE
53: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
54: -- x_return_status OUT VARCHAR2 Required
55: -- x_msg_count OUT NUMBER Required
48: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
49: -- p_project_id IN NUMBER Required
50: -- p_date_type IN VARCHAR2 Required
51: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
52: -- p_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE
53: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
54: -- x_return_status OUT VARCHAR2 Required
55: -- x_msg_count OUT NUMBER Required
56: -- x_msg_data OUT VARCHAR2 Optional
49: -- p_project_id IN NUMBER Required
50: -- p_date_type IN VARCHAR2 Required
51: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
52: -- p_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE
53: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
54: -- x_return_status OUT VARCHAR2 Required
55: -- x_msg_count OUT NUMBER Required
56: -- x_msg_data OUT VARCHAR2 Optional
57:
56: -- x_msg_data OUT VARCHAR2 Optional
57:
58: PROCEDURE UPDATE_PROJECT_DATES
59: ( p_api_version IN NUMBER := 1.0
60: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
61: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
62: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
63: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
64: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
57:
58: PROCEDURE UPDATE_PROJECT_DATES
59: ( p_api_version IN NUMBER := 1.0
60: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
61: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
62: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
63: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
64: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
65: ,p_debug_mode IN VARCHAR2 := 'N'
58: PROCEDURE UPDATE_PROJECT_DATES
59: ( p_api_version IN NUMBER := 1.0
60: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
61: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
62: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
63: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
64: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
65: ,p_debug_mode IN VARCHAR2 := 'N'
66: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
59: ( p_api_version IN NUMBER := 1.0
60: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
61: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
62: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
63: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
64: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
65: ,p_debug_mode IN VARCHAR2 := 'N'
66: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
67: ,p_project_id IN NUMBER
62: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
63: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
64: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
65: ,p_debug_mode IN VARCHAR2 := 'N'
66: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
67: ,p_project_id IN NUMBER
68: ,p_date_type IN VARCHAR2
69: ,p_start_date IN DATE := FND_API.G_MISS_DATE
70: ,p_finish_date IN DATE := FND_API.G_MISS_DATE
65: ,p_debug_mode IN VARCHAR2 := 'N'
66: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
67: ,p_project_id IN NUMBER
68: ,p_date_type IN VARCHAR2
69: ,p_start_date IN DATE := FND_API.G_MISS_DATE
70: ,p_finish_date IN DATE := FND_API.G_MISS_DATE
71: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
72: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
73: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
66: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
67: ,p_project_id IN NUMBER
68: ,p_date_type IN VARCHAR2
69: ,p_start_date IN DATE := FND_API.G_MISS_DATE
70: ,p_finish_date IN DATE := FND_API.G_MISS_DATE
71: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
72: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
73: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
74: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
67: ,p_project_id IN NUMBER
68: ,p_date_type IN VARCHAR2
69: ,p_start_date IN DATE := FND_API.G_MISS_DATE
70: ,p_finish_date IN DATE := FND_API.G_MISS_DATE
71: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
72: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
73: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
74: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
75: );