8: -- Return Value : N/A
9:
10: PROCEDURE UPDATE_ADDITIONAL_STAFF_INFO
11: (p_api_version IN NUMBER := 1.0 ,
12: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
13: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
14: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
15: p_project_id IN NUMBER ,
16: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
9:
10: PROCEDURE UPDATE_ADDITIONAL_STAFF_INFO
11: (p_api_version IN NUMBER := 1.0 ,
12: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
13: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
14: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
15: p_project_id IN NUMBER ,
16: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
17: p_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
10: PROCEDURE UPDATE_ADDITIONAL_STAFF_INFO
11: (p_api_version IN NUMBER := 1.0 ,
12: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
13: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
14: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
15: p_project_id IN NUMBER ,
16: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
17: p_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
18: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
12: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
13: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
14: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
15: p_project_id IN NUMBER ,
16: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
17: p_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
18: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
19: p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM ,
20: p_adv_action_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
13: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
14: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
15: p_project_id IN NUMBER ,
16: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
17: p_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
18: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
19: p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM ,
20: p_adv_action_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
21: p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
14: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
15: p_project_id IN NUMBER ,
16: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
17: p_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
18: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
19: p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM ,
20: p_adv_action_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
21: p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
22: p_record_version_number IN NUMBER ,
15: p_project_id IN NUMBER ,
16: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
17: p_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
18: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
19: p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM ,
20: p_adv_action_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
21: p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
22: p_record_version_number IN NUMBER ,
23: p_initial_team_template_id IN NUMBER := FND_API.G_MISS_NUM , -- added for bug 2607631
16: p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
17: p_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
18: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
19: p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM ,
20: p_adv_action_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
21: p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
22: p_record_version_number IN NUMBER ,
23: p_initial_team_template_id IN NUMBER := FND_API.G_MISS_NUM , -- added for bug 2607631
24: p_proj_req_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
17: p_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
18: p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
19: p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM ,
20: p_adv_action_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
21: p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
22: p_record_version_number IN NUMBER ,
23: p_initial_team_template_id IN NUMBER := FND_API.G_MISS_NUM , -- added for bug 2607631
24: p_proj_req_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
25: p_proj_asgmt_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
19: p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM ,
20: p_adv_action_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
21: p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
22: p_record_version_number IN NUMBER ,
23: p_initial_team_template_id IN NUMBER := FND_API.G_MISS_NUM , -- added for bug 2607631
24: p_proj_req_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
25: p_proj_asgmt_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
27: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
20: p_adv_action_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
21: p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
22: p_record_version_number IN NUMBER ,
23: p_initial_team_template_id IN NUMBER := FND_API.G_MISS_NUM , -- added for bug 2607631
24: p_proj_req_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
25: p_proj_asgmt_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
27: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
28: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
21: p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
22: p_record_version_number IN NUMBER ,
23: p_initial_team_template_id IN NUMBER := FND_API.G_MISS_NUM , -- added for bug 2607631
24: p_proj_req_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
25: p_proj_asgmt_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
27: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
28: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
29: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22: p_record_version_number IN NUMBER ,
23: p_initial_team_template_id IN NUMBER := FND_API.G_MISS_NUM , -- added for bug 2607631
24: p_proj_req_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
25: p_proj_asgmt_res_format_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
27: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
28: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
29: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
30: );