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.PJI_LAUNCH_UPP_MAIN dependencies on PA_PROJECT_UTILS

Line 1685: where PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'

1681: FROM (SELECT a.project_id ,
1682: SUM (a.total_accrued_amount) total_rev
1683: FROM pa_summary_project_fundings a,
1684: pa_projects_all ppa
1685: where PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'
1686: and a.project_id = ppa.project_id
1687: GROUP BY a.project_id
1688: )
1689: base_rev,

Line 1698: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'

1694: ,pa_project_customers cust,
1695: pa_projects_all ppa
1696: WHERE 1=1
1697: and pf.project_id = ppa.project_id
1698: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'
1699: AND pf.agreement_id = agr.agreement_id
1700: AND pf.project_id = cust.project_id
1701: AND pf.BUDGET_TYPE_CODE = 'BASELINE'
1702: AND agr.customer_id = cust.customer_id

Line 1715: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'

1711: + funding_adjustment_amount) total_fund
1712: FROM pji_ac_xbs_accum_f f,
1713: pa_projects_all ppa
1714: WHERE f.project_id = ppa.project_id
1715: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'
1716: AND f.currency_code = ppa.projfunc_currency_code
1717: AND time_id = -1
1718: AND wbs_rollup_flag = 'N'
1719: AND initial_funding_amount IS NOT NULL

Line 1748: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'

1744: FROM pa_budget_versions ver,
1745: pa_projects_all ppa
1746: WHERE ver.budget_status_code = 'B'
1747: and ver.project_id = ppa.project_id
1748: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'
1749: AND ver.current_flag = 'Y'
1750: AND ver.fin_plan_type_id IN (SELECT fin_plan_type_id
1751: FROM pa_fin_plan_types_b
1752: WHERE approved_cost_plan_type_flag ='Y')

Line 1760: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(p.project_status_code,'STATUS_REPORTING') = 'Y'

1756: Sum(brdn_cost) cost
1757: FROM pji_fp_xbs_accum_f f,
1758: pa_projects_all p
1759: WHERE plan_version_id = -3
1760: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(p.project_status_code,'STATUS_REPORTING') = 'Y'
1761: AND rbs_aggr_level = 'T'
1762: AND wbs_rollup_flag = 'Y'
1763: AND calendar_type = 'A'
1764: AND time_id = -1

Line 1793: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'

1789: FROM pa_budget_versions ver,
1790: pa_projects_all ppa
1791: WHERE ver.budget_status_code = 'B'
1792: and ver.project_id = ppa.project_id
1793: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'
1794: AND ver.current_flag = 'Y'
1795: AND ver.fin_plan_type_id IN (SELECT fin_plan_type_id
1796: FROM pa_fin_plan_types_b
1797: WHERE approved_rev_plan_type_flag ='Y')

Line 1805: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(p.project_status_code,'STATUS_REPORTING') = 'Y'

1801: Sum(revenue) revenue
1802: FROM pji_fp_xbs_accum_f f,
1803: pa_projects_all p
1804: WHERE plan_version_id = -3
1805: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(p.project_status_code,'STATUS_REPORTING') = 'Y'
1806: AND rbs_aggr_level = 'T'
1807: AND wbs_rollup_flag = 'Y'
1808: AND calendar_type = 'A'
1809: AND time_id = -1

Line 1836: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(pa.project_status_code,'STATUS_REPORTING') = 'Y'

1832: pa.project_id
1833: FROM pa_projects_all pa,
1834: pa_cost_distribution_lines_all cdl
1835: WHERE pa.template_flag = 'N'
1836: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(pa.project_status_code,'STATUS_REPORTING') = 'Y'
1837: AND pa.project_id = cdl.project_id
1838: AND cdl.line_type = 'R'
1839: AND cdl.pji_summarized_flag IS NULL
1840: AND pa.org_id = nvl(p_operating_unit, pa.org_id )

Line 1850: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(p.project_status_code,'STATUS_REPORTING') = 'Y'

1846: f.project_id
1847: FROM pa_projects_all p ,
1848: pji_fp_xbs_accum_f f
1849: WHERE p.project_id = f.project_id
1850: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(p.project_status_code,'STATUS_REPORTING') = 'Y'
1851: AND f.currency_code = p.projfunc_currency_code
1852: AND f.plan_type_id = -1
1853: AND f.rbs_version_id = -1
1854: AND f.calendar_type = 'A'

Line 1913: AND PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED (p1.project_status_code,

1909: AND bl.resource_assignment_id = res.resource_assignment_id
1910: GROUP BY res.project_id) base
1911: WHERE base.project_id = rep.project_id(+)
1912: AND p1.project_id = base.project_id
1913: AND PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED (p1.project_status_code,
1914: 'STATUS_REPORTING') = 'Y'
1915: AND p1.template_flag = 'N'
1916: AND (base.act_ppl_effort <> nvl(rep.act_ppl_effort,0)
1917: OR base.act_eq_effort <> nvl(rep.act_eq_effort,0)

Line 1961: AND PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED (p1.project_status_code, 'STATUS_REPORTING') = 'Y'

1957: AND bl.resource_assignment_id = res.resource_assignment_id
1958: GROUP BY res.project_id) base
1959: WHERE base.project_id = rep.project_id(+)
1960: AND p1.project_id = base.project_id
1961: AND PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED (p1.project_status_code, 'STATUS_REPORTING') = 'Y'
1962: AND p1.template_flag = 'N'
1963: AND (base.act_ppl_effort <> nvl(rep.act_ppl_effort,0)
1964: OR base.act_eq_effort <> nvl(rep.act_eq_effort,0)
1965: OR base.act_raw_cost <> nvl(rep.act_raw_cost,0)