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.PSP_XMLGEN dependencies on PA_PROJECTS_ALL

Line 886: || '(SELECT 1 FROM pa_projects_all ppa, gms_project_types_all gpta WHERE gpta.project_type = ppa.project_type AND '

882: || 'TRIM(TO_CHAR(SUM(NVL(pera.actual_cost_share, 0)), ''999G990D00'')) total_spon_actual_cost_share '
883: || 'FROM psp_eff_report_details perd, psp_eff_report_approvals pera '
884: || 'WHERE (perd.project_id IS NOT NULL OR perd.task_id IS NOT NULL OR perd.award_id '
885: || 'IS NOT NULL OR perd.expenditure_organization_id IS NOT NULL OR perd.expenditure_type IS NOT NULL) AND EXISTS '
886: || '(SELECT 1 FROM pa_projects_all ppa, gms_project_types_all gpta WHERE gpta.project_type = ppa.project_type AND '
887: || 'ppa.project_id = perd.project_id AND ppa.project_type <> ''AWARD_PROJECT'' AND NVL(gpta.sponsored_flag, ''N'') ='
888: || '''Y'') AND perd.effort_report_detail_id = pera.effort_report_detail_id (+) AND effort_report_id = '
889: || TO_CHAR(p_effort_report_id) || ' AND NVL(pera.approval_status, ''A'') IN (''P'', ''A'')' || l_assignment_check;
890: qryCtx1 := dbms_xmlgen.newContext(query1);

Line 908: || '(SELECT 1 FROM pa_projects_all ppa, gms_project_types_all gpta WHERE gpta.project_type (+) = ppa.project_type AND '

904: || 'TRIM(TO_CHAR(SUM(NVL(pera.actual_cost_share, 0)), ''999G990D00'')) total_nspon_actual_cost_share '
905: || 'FROM psp_eff_report_details perd, psp_eff_report_approvals pera '
906: || 'WHERE (perd.project_id IS NOT NULL OR perd.task_id IS NOT NULL OR perd.award_id '
907: || 'IS NOT NULL OR perd.expenditure_organization_id IS NOT NULL OR perd.expenditure_type IS NOT NULL) AND EXISTS '
908: || '(SELECT 1 FROM pa_projects_all ppa, gms_project_types_all gpta WHERE gpta.project_type (+) = ppa.project_type AND '
909: || 'ppa.project_id = perd.project_id AND ppa.project_type <> ''AWARD_PROJECT'' AND NVL(gpta.sponsored_flag, ''N'') ='
910: || '''N'') AND perd.effort_report_detail_id = pera.effort_report_detail_id (+) AND effort_report_id = '
911: || TO_CHAR(p_effort_report_id) || ' AND NVL(pera.approval_status, ''A'') IN (''P'', ''A'')' || l_assignment_check;
912: qryCtx1 := dbms_xmlgen.newContext(query1);

Line 959: || '(SELECT 1 FROM pa_projects_all ppa, gms_project_types_all gpta WHERE gpta.project_type = ppa.project_type AND '

955: || 'perd.*, TRIM(TO_CHAR(NVL(pera.overwritten_effort_percent, 0), ''999G990D00'')) overwritten_effort_percent, '
956: || 'TRIM(TO_CHAR(NVL(pera.actual_cost_share, 0), ''999G990D00'')) actual_cost_share FROM psp_eff_report_details perd, '
957: || 'psp_eff_report_approvals pera WHERE (perd.project_id IS NOT NULL OR perd.task_id IS NOT NULL OR perd.award_id '
958: || 'IS NOT NULL OR perd.expenditure_organization_id IS NOT NULL OR perd.expenditure_type IS NOT NULL) AND EXISTS '
959: || '(SELECT 1 FROM pa_projects_all ppa, gms_project_types_all gpta WHERE gpta.project_type = ppa.project_type AND '
960: || 'ppa.project_id = perd.project_id AND ppa.project_type <> ''AWARD_PROJECT'' AND NVL(gpta.sponsored_flag, ''N'') ='
961: || '''Y'') AND perd.effort_report_detail_id = pera.effort_report_detail_id (+) AND effort_report_id = '
962: || TO_CHAR(p_effort_report_id) || ' AND NVL(pera.approval_status, ''A'') IN (''P'', ''A'')' || l_assignment_check || l_sort_option1;
963: qryCtx1 := dbms_xmlgen.newContext(query1);

Line 984: || '(SELECT 1 FROM pa_projects_all ppa, gms_project_types_all gpta WHERE gpta.project_type(+) = ppa.project_type AND '

980: || 'perd.*, TRIM(TO_CHAR(NVL(pera.overwritten_effort_percent, 0), ''999G990D00'')) overwritten_effort_percent, '
981: || 'TRIM(TO_CHAR(NVL(pera.actual_cost_share, 0), ''999G990D00'')) actual_cost_share FROM psp_eff_report_details perd, '
982: || 'psp_eff_report_approvals pera WHERE (perd.project_id IS NOT NULL OR perd.task_id IS NOT NULL OR perd.award_id '
983: || 'IS NOT NULL OR perd.expenditure_organization_id IS NOT NULL OR perd.expenditure_type IS NOT NULL) AND EXISTS '
984: || '(SELECT 1 FROM pa_projects_all ppa, gms_project_types_all gpta WHERE gpta.project_type(+) = ppa.project_type AND '
985: || 'ppa.project_id = perd.project_id AND ppa.project_type <> ''AWARD_PROJECT'' AND NVL(gpta.sponsored_flag, ''N'') ='
986: || '''N'') AND perd.effort_report_detail_id = pera.effort_report_detail_id (+) AND effort_report_id = '
987: || TO_CHAR(p_effort_report_id) || ' AND NVL(pera.approval_status, ''A'') IN (''P'', ''A'')' || l_assignment_check || l_sort_option1;
988: qryCtx1 := dbms_xmlgen.newContext(query1);

Line 1731: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa

1727: SET assignment_number = (SELECT assignment_number FROM per_all_assignments_f paaf, psp_eff_reports per
1728: WHERE per.effort_report_id = perd.effort_report_id AND paaf.assignment_id = perd.assignment_id
1729: AND paaf.effective_start_date <= r_effort_report.r_end_date(I)
1730: AND paaf.effective_end_date >= r_effort_report.r_start_date(I) AND ROWNUM = 1),
1731: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
1732: WHERE paa.project_id = perd.project_id),
1733: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
1734: WHERE gaa.award_id = perd.award_id),
1735: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks pt WHERE pt.task_id = perd.task_id),

Line 1788: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa

1784: SET assignment_number = (SELECT assignment_number FROM per_all_assignments_f paaf, psp_eff_reports per
1785: WHERE per.effort_report_id = perd.effort_report_id AND paaf.assignment_id = perd.assignment_id
1786: AND paaf.effective_start_date <= r_effort_report.r_end_date(I)
1787: AND paaf.effective_end_date >= r_effort_report.r_start_date(I) AND ROWNUM = 1),
1788: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
1789: WHERE paa.project_id = perd.project_id),
1790: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
1791: WHERE gaa.award_id = perd.award_id),
1792: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks pt WHERE pt.task_id = perd.task_id),

Line 1820: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa

1816: SET assignment_number = (SELECT assignment_number FROM per_all_assignments_f paaf, psp_eff_reports per
1817: WHERE per.effort_report_id = perd.effort_report_id AND paaf.assignment_id = perd.assignment_id
1818: AND paaf.effective_start_date <= r_effort_report.r_end_date(I)
1819: AND paaf.effective_end_date >= r_effort_report.r_start_date(I) AND ROWNUM = 1),
1820: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
1821: WHERE paa.project_id = perd.project_id),
1822: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
1823: WHERE gaa.award_id = perd.award_id),
1824: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks pt WHERE pt.task_id = perd.task_id),

Line 1853: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa

1849: SET assignment_number = (SELECT assignment_number FROM per_all_assignments_f paaf, psp_eff_reports per
1850: WHERE per.effort_report_id = perd.effort_report_id AND paaf.assignment_id = perd.assignment_id
1851: AND paaf.effective_start_date <= per.end_date
1852: AND paaf.effective_end_date >= per.start_date AND ROWNUM = 1),
1853: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
1854: WHERE paa.project_id = perd.project_id),
1855: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
1856: WHERE gaa.award_id = perd.award_id),
1857: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks pt WHERE pt.task_id = perd.task_id),

Line 2141: AND EXISTS (SELECT 1 FROM pa_projects_all ppa, gms_project_types gpta -- Changed from gms_project_types_all for bug 5503605

2137: AND request_id = p_request_id
2138: AND ( perd.project_id IS NOT NULL OR perd.task_id IS NOT NULL
2139: OR perd.award_id IS NOT NULL OR perd.expenditure_organization_id IS NOT NULL
2140: OR perd.expenditure_type IS NOT NULL)
2141: AND EXISTS (SELECT 1 FROM pa_projects_all ppa, gms_project_types gpta -- Changed from gms_project_types_all for bug 5503605
2142: WHERE gpta.project_type = ppa.project_type
2143: AND ppa.project_id = perd.project_id
2144: AND ppa.project_type <> 'AWARD_PROJECT' AND NVL(gpta.sponsored_flag, 'N') ='Y');
2145:

Line 2156: AND EXISTS (SELECT 1 FROM pa_projects_all ppa, gms_project_types gpta -- Changed from gms_project_types_all for bug 5503605

2152: AND request_id = p_request_id
2153: AND ( perd.project_id IS NOT NULL OR perd.task_id IS NOT NULL
2154: OR perd.award_id IS NOT NULL OR perd.expenditure_organization_id IS NOT NULL
2155: OR perd.expenditure_type IS NOT NULL)
2156: AND EXISTS (SELECT 1 FROM pa_projects_all ppa, gms_project_types gpta -- Changed from gms_project_types_all for bug 5503605
2157: WHERE gpta.project_type(+) = ppa.project_type
2158: AND ppa.project_id = perd.project_id
2159: AND ppa.project_type <> 'AWARD_PROJECT' AND NVL(gpta.sponsored_flag, 'N') ='N');
2160: