7: -- last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
8:
9:
10: PROCEDURE CREATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
11: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
12: p_commit IN VARCHAR2 := FND_API.G_FALSE,
13: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
14: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
15: p_debug_mode IN VARCHAR2 default 'N',
8:
9:
10: PROCEDURE CREATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
11: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
12: p_commit IN VARCHAR2 := FND_API.G_FALSE,
13: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
14: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
15: p_debug_mode IN VARCHAR2 default 'N',
16: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
9:
10: PROCEDURE CREATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
11: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
12: p_commit IN VARCHAR2 := FND_API.G_FALSE,
13: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
14: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
15: p_debug_mode IN VARCHAR2 default 'N',
16: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
17: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
10: PROCEDURE CREATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
11: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
12: p_commit IN VARCHAR2 := FND_API.G_FALSE,
13: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
14: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
15: p_debug_mode IN VARCHAR2 default 'N',
16: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
17: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
12: p_commit IN VARCHAR2 := FND_API.G_FALSE,
13: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
14: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
15: p_debug_mode IN VARCHAR2 default 'N',
16: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
17: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
19: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
13: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
14: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
15: p_debug_mode IN VARCHAR2 default 'N',
16: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
17: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
19: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
21: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
14: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
15: p_debug_mode IN VARCHAR2 default 'N',
16: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
17: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
19: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
21: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: p_debug_mode IN VARCHAR2 default 'N',
16: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
17: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
19: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
21: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
17: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
19: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
21: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
24: p_scheduled_flag IN VARCHAR2 := 'N',
25: p_calling_module IN VARCHAR2,
18: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
19: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
21: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
24: p_scheduled_flag IN VARCHAR2 := 'N',
25: p_calling_module IN VARCHAR2,
26: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
19: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
21: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
24: p_scheduled_flag IN VARCHAR2 := 'N',
25: p_calling_module IN VARCHAR2,
26: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
27: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
22: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
24: p_scheduled_flag IN VARCHAR2 := 'N',
25: p_calling_module IN VARCHAR2,
26: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
27: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
28: p_mgr_validation_type IN VARCHAR2 default 'FORM',/*Added for bug 2111806*/
29: p_end_date_active IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
30: x_project_party_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
23: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
24: p_scheduled_flag IN VARCHAR2 := 'N',
25: p_calling_module IN VARCHAR2,
26: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
27: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
28: p_mgr_validation_type IN VARCHAR2 default 'FORM',/*Added for bug 2111806*/
29: p_end_date_active IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
30: x_project_party_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
31: x_resource_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
37: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
38: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
39:
40: PROCEDURE UPDATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
44: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
45: p_debug_mode IN VARCHAR2 default 'N',
38: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
39:
40: PROCEDURE UPDATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
44: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
45: p_debug_mode IN VARCHAR2 default 'N',
46: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
39:
40: PROCEDURE UPDATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
44: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
45: p_debug_mode IN VARCHAR2 default 'N',
46: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
47: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: PROCEDURE UPDATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
44: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
45: p_debug_mode IN VARCHAR2 default 'N',
46: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
47: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_project_role_id IN NUMBER,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
44: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
45: p_debug_mode IN VARCHAR2 default 'N',
46: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
47: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_project_role_id IN NUMBER,
49: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
43: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
44: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
45: p_debug_mode IN VARCHAR2 default 'N',
46: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
47: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_project_role_id IN NUMBER,
49: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
51: p_resource_source_id IN NUMBER,
45: p_debug_mode IN VARCHAR2 default 'N',
46: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
47: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_project_role_id IN NUMBER,
49: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
51: p_resource_source_id IN NUMBER,
52: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_project_role_id IN NUMBER,
49: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
51: p_resource_source_id IN NUMBER,
52: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
54: p_start_date_active IN DATE,
55: p_scheduled_flag IN VARCHAR2 := 'N',
56: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
49: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
51: p_resource_source_id IN NUMBER,
52: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
54: p_start_date_active IN DATE,
55: p_scheduled_flag IN VARCHAR2 := 'N',
56: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
57: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
54: p_start_date_active IN DATE,
55: p_scheduled_flag IN VARCHAR2 := 'N',
56: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
57: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
59: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
60: p_project_party_id IN NUMBER,
53: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
54: p_start_date_active IN DATE,
55: p_scheduled_flag IN VARCHAR2 := 'N',
56: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
57: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
59: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
60: p_project_party_id IN NUMBER,
61: p_assignment_id IN NUMBER := 0,
54: p_start_date_active IN DATE,
55: p_scheduled_flag IN VARCHAR2 := 'N',
56: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
57: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
59: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
60: p_project_party_id IN NUMBER,
61: p_assignment_id IN NUMBER := 0,
62: p_assign_record_version_number IN NUMBER := 0,
55: p_scheduled_flag IN VARCHAR2 := 'N',
56: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
57: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
59: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
60: p_project_party_id IN NUMBER,
61: p_assignment_id IN NUMBER := 0,
62: p_assign_record_version_number IN NUMBER := 0,
63: p_mgr_validation_type IN VARCHAR2 default 'FORM',/*Added for bug 2111806*/
70: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
71: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
72:
73: PROCEDURE DELETE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78: p_debug_mode IN VARCHAR2 default 'N',
71: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
72:
73: PROCEDURE DELETE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78: p_debug_mode IN VARCHAR2 default 'N',
79: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
72:
73: PROCEDURE DELETE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78: p_debug_mode IN VARCHAR2 default 'N',
79: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
80: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: PROCEDURE DELETE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78: p_debug_mode IN VARCHAR2 default 'N',
79: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
80: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78: p_debug_mode IN VARCHAR2 default 'N',
79: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
80: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
82: p_project_party_id IN NUMBER := FND_API.G_MISS_NUM,
83: p_scheduled_flag IN VARCHAR2 default 'N',
76: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78: p_debug_mode IN VARCHAR2 default 'N',
79: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
80: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
82: p_project_party_id IN NUMBER := FND_API.G_MISS_NUM,
83: p_scheduled_flag IN VARCHAR2 default 'N',
84: p_assignment_id IN NUMBER := 0,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78: p_debug_mode IN VARCHAR2 default 'N',
79: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
80: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
82: p_project_party_id IN NUMBER := FND_API.G_MISS_NUM,
83: p_scheduled_flag IN VARCHAR2 default 'N',
84: p_assignment_id IN NUMBER := 0,
85: p_assign_record_version_number IN NUMBER := 0,
78: p_debug_mode IN VARCHAR2 default 'N',
79: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
80: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
82: p_project_party_id IN NUMBER := FND_API.G_MISS_NUM,
83: p_scheduled_flag IN VARCHAR2 default 'N',
84: p_assignment_id IN NUMBER := 0,
85: p_assign_record_version_number IN NUMBER := 0,
86: p_mgr_validation_type IN VARCHAR2 default 'FORM',/*Added for bug 2111806*/
122: This api is used as a wrapper API to CREATE_PROJECT_PARTY
123: ==============================================================================*/
124:
125: PROCEDURE CREATE_PROJECT_PARTY_WRP( p_api_version IN NUMBER := 1.0,
126: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
127: p_commit IN VARCHAR2 := FND_API.G_FALSE,
128: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: p_debug_mode IN VARCHAR2 default 'N',
123: ==============================================================================*/
124:
125: PROCEDURE CREATE_PROJECT_PARTY_WRP( p_api_version IN NUMBER := 1.0,
126: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
127: p_commit IN VARCHAR2 := FND_API.G_FALSE,
128: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: p_debug_mode IN VARCHAR2 default 'N',
131: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
124:
125: PROCEDURE CREATE_PROJECT_PARTY_WRP( p_api_version IN NUMBER := 1.0,
126: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
127: p_commit IN VARCHAR2 := FND_API.G_FALSE,
128: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: p_debug_mode IN VARCHAR2 default 'N',
131: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
132: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: PROCEDURE CREATE_PROJECT_PARTY_WRP( p_api_version IN NUMBER := 1.0,
126: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
127: p_commit IN VARCHAR2 := FND_API.G_FALSE,
128: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: p_debug_mode IN VARCHAR2 default 'N',
131: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
132: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
127: p_commit IN VARCHAR2 := FND_API.G_FALSE,
128: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: p_debug_mode IN VARCHAR2 default 'N',
131: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
132: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
134: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
128: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: p_debug_mode IN VARCHAR2 default 'N',
131: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
132: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
134: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
136: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: p_debug_mode IN VARCHAR2 default 'N',
131: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
132: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
134: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
136: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
137: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_debug_mode IN VARCHAR2 default 'N',
131: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
132: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
134: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
136: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
137: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
132: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
134: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
136: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
137: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
139: p_scheduled_flag IN VARCHAR2 := 'N',
140: p_calling_module IN VARCHAR2,
133: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
134: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
136: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
137: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
139: p_scheduled_flag IN VARCHAR2 := 'N',
140: p_calling_module IN VARCHAR2,
141: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
134: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
136: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
137: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
139: p_scheduled_flag IN VARCHAR2 := 'N',
140: p_calling_module IN VARCHAR2,
141: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
142: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
137: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
139: p_scheduled_flag IN VARCHAR2 := 'N',
140: p_calling_module IN VARCHAR2,
141: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
142: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
143: p_mgr_validation_type IN VARCHAR2 default 'FORM',/*Added for bug 2111806*/
144: p_end_date_active IN OUT NOCOPY DATE,
145: x_project_party_id OUT NOCOPY NUMBER,
138: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
139: p_scheduled_flag IN VARCHAR2 := 'N',
140: p_calling_module IN VARCHAR2,
141: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
142: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
143: p_mgr_validation_type IN VARCHAR2 default 'FORM',/*Added for bug 2111806*/
144: p_end_date_active IN OUT NOCOPY DATE,
145: x_project_party_id OUT NOCOPY NUMBER,
146: x_resource_id OUT NOCOPY NUMBER,