972: x_end_no_mgr_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
973: x_error_occured OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
974: l_error_occured VARCHAR2(50);
975: l_proj_status pa_projects_all.project_status_code%TYPE;
976: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
977: l_proj_type pa_project_types_all.project_type%TYPE; -- Added for bug#5098966
978: l_proj_start_date pa_projects_all.start_date%TYPE;
979: l_proj_end_date pa_projects_all.completion_date%TYPE;
980: l_person_id pa_project_players.person_id%TYPE;
973: x_error_occured OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
974: l_error_occured VARCHAR2(50);
975: l_proj_status pa_projects_all.project_status_code%TYPE;
976: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
977: l_proj_type pa_project_types_all.project_type%TYPE; -- Added for bug#5098966
978: l_proj_start_date pa_projects_all.start_date%TYPE;
979: l_proj_end_date pa_projects_all.completion_date%TYPE;
980: l_person_id pa_project_players.person_id%TYPE;
981: l_party_id pa_project_parties.project_party_id%TYPE;
1200: where project_id = p_project_id
1201: and project_role_id = 1;
1202:
1203: l_proj_status pa_projects_all.project_status_code%TYPE;
1204: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
1205: l_prj_mgr_count NUMBER := 0;
1206: l_start_no_mgr_date DATE;
1207: l_end_no_mgr_date DATE;
1208: