eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_PARTIES_UTILS dependencies on PA_PROJECT_TYPES

Line 979: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;

975: x_end_no_mgr_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
976: x_error_occured OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
977: l_error_occured VARCHAR2(50);
978: l_proj_status pa_projects_all.project_status_code%TYPE;
979: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
980: l_proj_type pa_project_types_all.project_type%TYPE; -- Added for bug#5098966
981: l_proj_start_date pa_projects_all.start_date%TYPE;
982: l_proj_end_date pa_projects_all.completion_date%TYPE;
983: l_person_id pa_project_players.person_id%TYPE;

Line 980: l_proj_type pa_project_types_all.project_type%TYPE; -- Added for bug#5098966

976: x_error_occured OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
977: l_error_occured VARCHAR2(50);
978: l_proj_status pa_projects_all.project_status_code%TYPE;
979: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
980: l_proj_type pa_project_types_all.project_type%TYPE; -- Added for bug#5098966
981: l_proj_start_date pa_projects_all.start_date%TYPE;
982: l_proj_end_date pa_projects_all.completion_date%TYPE;
983: l_person_id pa_project_players.person_id%TYPE;
984: l_party_id pa_project_parties.project_party_id%TYPE;

Line 998: ,pa_project_types type

994: ,trunc(proj.start_date)
995: ,trunc(proj.completion_date)
996: from pa_projects_all proj
997: ,pa_project_statuses ps
998: ,pa_project_types type
999: where proj.project_status_code = ps.project_status_code
1000: and proj.project_type = type.project_type
1001: and proj.project_id = p_project_id
1002: and ps.STATUS_TYPE = 'PROJECT';

Line 1204: ,pa_project_types type

1200: select ps.project_system_status_code
1201: ,type.project_type_class_code
1202: from pa_projects_all proj
1203: ,pa_project_statuses ps
1204: ,pa_project_types type
1205: where proj.project_status_code = ps.project_status_code
1206: and proj.project_type=type.project_type
1207: and proj.project_id = p_project_id
1208: and ps.STATUS_TYPE ='PROJECT';

Line 1218: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;

1214: where project_id = p_project_id
1215: and project_role_id = 1;
1216:
1217: l_proj_status pa_projects_all.project_status_code%TYPE;
1218: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
1219: l_prj_mgr_count NUMBER := 0;
1220: l_start_no_mgr_date DATE;
1221: l_end_no_mgr_date DATE;
1222: