APPS.PA_PROJECT_PARTIES_PVT dependencies on FND_API

Line 7: PROCEDURE CREATE_PROJECT_PARTY( p_commit IN VARCHAR2 := FND_API.G_FALSE,

3:
4: -- l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
5: l_delete_proj_party VARCHAR2(1) := 'Y';
6:
7: PROCEDURE CREATE_PROJECT_PARTY( p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_debug_mode IN VARCHAR2 default 'N',
11: p_object_id IN NUMBER := FND_API.G_MISS_NUM,

Line 8: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

4: -- l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
5: l_delete_proj_party VARCHAR2(1) := 'Y';
6:
7: PROCEDURE CREATE_PROJECT_PARTY( p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_debug_mode IN VARCHAR2 default 'N',
11: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
12: p_OBJECT_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

5: l_delete_proj_party VARCHAR2(1) := 'Y';
6:
7: PROCEDURE CREATE_PROJECT_PARTY( p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_debug_mode IN VARCHAR2 default 'N',
11: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
12: p_OBJECT_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: p_RESOURCE_TYPE_ID IN NUMBER := 101,

Line 11: p_object_id IN NUMBER := FND_API.G_MISS_NUM,

7: PROCEDURE CREATE_PROJECT_PARTY( p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_debug_mode IN VARCHAR2 default 'N',
11: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
12: p_OBJECT_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: p_RESOURCE_TYPE_ID IN NUMBER := 101,
14: p_project_role_id IN NUMBER,
15: p_resource_source_id IN NUMBER,

Line 12: p_OBJECT_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,

8: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_debug_mode IN VARCHAR2 default 'N',
11: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
12: p_OBJECT_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: p_RESOURCE_TYPE_ID IN NUMBER := 101,
14: p_project_role_id IN NUMBER,
15: p_resource_source_id IN NUMBER,
16: p_start_date_active IN DATE,

Line 19: p_project_id IN NUMBER := FND_API.G_MISS_NUM,

15: p_resource_source_id IN NUMBER,
16: p_start_date_active IN DATE,
17: p_scheduled_flag IN VARCHAR2 := 'N',
18: p_calling_module IN VARCHAR2,
19: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
20: p_project_end_date IN DATE,
21: p_mgr_validation_type IN VARCHAR2 := FND_API.G_MISS_CHAR,/*Added for bug 2111806*/
22: p_end_date_active IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
23: x_project_party_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 21: p_mgr_validation_type IN VARCHAR2 := FND_API.G_MISS_CHAR,/*Added for bug 2111806*/

17: p_scheduled_flag IN VARCHAR2 := 'N',
18: p_calling_module IN VARCHAR2,
19: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
20: p_project_end_date IN DATE,
21: p_mgr_validation_type IN VARCHAR2 := FND_API.G_MISS_CHAR,/*Added for bug 2111806*/
22: p_end_date_active IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
23: x_project_party_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
24: x_resource_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
25: x_assignment_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 33: PROCEDURE UPDATE_PROJECT_PARTY( p_commit IN VARCHAR2 := FND_API.G_FALSE,

29: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
30: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
31: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
32:
33: PROCEDURE UPDATE_PROJECT_PARTY( p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36: p_debug_mode IN VARCHAR2 default 'N',
37: p_object_id IN NUMBER := FND_API.G_MISS_NUM,

Line 34: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

30: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
31: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
32:
33: PROCEDURE UPDATE_PROJECT_PARTY( p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36: p_debug_mode IN VARCHAR2 default 'N',
37: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

31: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
32:
33: PROCEDURE UPDATE_PROJECT_PARTY( p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36: p_debug_mode IN VARCHAR2 default 'N',
37: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_project_role_id IN NUMBER,

Line 37: p_object_id IN NUMBER := FND_API.G_MISS_NUM,

33: PROCEDURE UPDATE_PROJECT_PARTY( p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36: p_debug_mode IN VARCHAR2 default 'N',
37: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_project_role_id IN NUMBER,
40: p_resource_type_id IN NUMBER := 101,
41: p_resource_source_id IN NUMBER,

Line 38: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

34: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36: p_debug_mode IN VARCHAR2 default 'N',
37: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_project_role_id IN NUMBER,
40: p_resource_type_id IN NUMBER := 101,
41: p_resource_source_id IN NUMBER,
42: p_resource_id IN NUMBER,

Line 45: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,

41: p_resource_source_id IN NUMBER,
42: p_resource_id IN NUMBER,
43: p_start_date_active IN DATE,
44: p_scheduled_flag IN VARCHAR2 := 'N',
45: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
46: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_project_end_date IN DATE,
49: p_project_party_id IN NUMBER,

Line 46: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,

42: p_resource_id IN NUMBER,
43: p_start_date_active IN DATE,
44: p_scheduled_flag IN VARCHAR2 := 'N',
45: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
46: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_project_end_date IN DATE,
49: p_project_party_id IN NUMBER,
50: p_assignment_id IN NUMBER,

Line 47: p_project_id IN NUMBER := FND_API.G_MISS_NUM,

43: p_start_date_active IN DATE,
44: p_scheduled_flag IN VARCHAR2 := 'N',
45: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
46: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_project_end_date IN DATE,
49: p_project_party_id IN NUMBER,
50: p_assignment_id IN NUMBER,
51: p_assign_record_version_number IN NUMBER,

Line 52: p_mgr_validation_type IN VARCHAR2 := FND_API.G_MISS_CHAR,/*Added for bug 2111806*/

48: p_project_end_date IN DATE,
49: p_project_party_id IN NUMBER,
50: p_assignment_id IN NUMBER,
51: p_assign_record_version_number IN NUMBER,
52: p_mgr_validation_type IN VARCHAR2 := FND_API.G_MISS_CHAR,/*Added for bug 2111806*/
53: p_end_date_active IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
54: x_assignment_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
55: x_wf_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
56: x_wf_item_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 62: PROCEDURE DELETE_PROJECT_PARTY( p_commit IN VARCHAR2 := FND_API.G_FALSE,

58: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
59: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
60: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
61:
62: PROCEDURE DELETE_PROJECT_PARTY( p_commit IN VARCHAR2 := FND_API.G_FALSE,
63: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: p_debug_mode IN VARCHAR2 default 'N',
66: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,

Line 63: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

59: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
60: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
61:
62: PROCEDURE DELETE_PROJECT_PARTY( p_commit IN VARCHAR2 := FND_API.G_FALSE,
63: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: p_debug_mode IN VARCHAR2 default 'N',
66: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
67: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

60: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
61:
62: PROCEDURE DELETE_PROJECT_PARTY( p_commit IN VARCHAR2 := FND_API.G_FALSE,
63: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: p_debug_mode IN VARCHAR2 default 'N',
66: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
67: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_project_id IN NUMBER := FND_API.G_MISS_NUM,

Line 66: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,

62: PROCEDURE DELETE_PROJECT_PARTY( p_commit IN VARCHAR2 := FND_API.G_FALSE,
63: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: p_debug_mode IN VARCHAR2 default 'N',
66: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
67: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
69: p_project_party_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_scheduled_flag IN VARCHAR2 := 'N',

Line 67: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,

63: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: p_debug_mode IN VARCHAR2 default 'N',
66: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
67: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
69: p_project_party_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_scheduled_flag IN VARCHAR2 := 'N',
71: p_assignment_id IN NUMBER := 0,

Line 68: p_project_id IN NUMBER := FND_API.G_MISS_NUM,

64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: p_debug_mode IN VARCHAR2 default 'N',
66: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
67: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
69: p_project_party_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_scheduled_flag IN VARCHAR2 := 'N',
71: p_assignment_id IN NUMBER := 0,
72: p_assign_record_version_number IN NUMBER := 0,

Line 69: p_project_party_id IN NUMBER := FND_API.G_MISS_NUM,

65: p_debug_mode IN VARCHAR2 default 'N',
66: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
67: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
69: p_project_party_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_scheduled_flag IN VARCHAR2 := 'N',
71: p_assignment_id IN NUMBER := 0,
72: p_assign_record_version_number IN NUMBER := 0,
73: p_mgr_validation_type IN VARCHAR2 := FND_API.G_MISS_CHAR,/*Added for bug 2111806*/

Line 73: p_mgr_validation_type IN VARCHAR2 := FND_API.G_MISS_CHAR,/*Added for bug 2111806*/

69: p_project_party_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_scheduled_flag IN VARCHAR2 := 'N',
71: p_assignment_id IN NUMBER := 0,
72: p_assign_record_version_number IN NUMBER := 0,
73: p_mgr_validation_type IN VARCHAR2 := FND_API.G_MISS_CHAR,/*Added for bug 2111806*/
74: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
75: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
76: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
77: