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_EXCEPTION_ENGINE_PKG dependencies on PA_PROJECTS_ALL

Line 38: FROM pa_perf_bz_object ppbo, pa_projects_all ppa

34: Get the project_id from interface table based on business event and request_id */
35: CURSOR get_project_id(l_perf_txn_set_id IN VARCHAR2, l_proj_from IN NUMBER,
36: l_proj_to IN NUMBER, l_proj IN NUMBER) IS
37: SELECT DISTINCT object_id
38: FROM pa_perf_bz_object ppbo, pa_projects_all ppa
39: WHERE ppbo.object_type = 'PA_PROJECTS'
40: AND ppbo.perf_txn_set_id = l_perf_txn_set_id
41: AND ppa.segment1 between nvl((select segment1 from pa_projects_all where project_id = l_proj_from),' ') and
42: nvl((select segment1 from pa_projects_all where project_id = l_proj_to),ppa.segment1)

Line 41: AND ppa.segment1 between nvl((select segment1 from pa_projects_all where project_id = l_proj_from),' ') and

37: SELECT DISTINCT object_id
38: FROM pa_perf_bz_object ppbo, pa_projects_all ppa
39: WHERE ppbo.object_type = 'PA_PROJECTS'
40: AND ppbo.perf_txn_set_id = l_perf_txn_set_id
41: AND ppa.segment1 between nvl((select segment1 from pa_projects_all where project_id = l_proj_from),' ') and
42: nvl((select segment1 from pa_projects_all where project_id = l_proj_to),ppa.segment1)
43: AND ppa.project_id = ppbo.object_id
44: ORDER BY object_id;
45:

Line 42: nvl((select segment1 from pa_projects_all where project_id = l_proj_to),ppa.segment1)

38: FROM pa_perf_bz_object ppbo, pa_projects_all ppa
39: WHERE ppbo.object_type = 'PA_PROJECTS'
40: AND ppbo.perf_txn_set_id = l_perf_txn_set_id
41: AND ppa.segment1 between nvl((select segment1 from pa_projects_all where project_id = l_proj_from),' ') and
42: nvl((select segment1 from pa_projects_all where project_id = l_proj_to),ppa.segment1)
43: AND ppa.project_id = ppbo.object_id
44: ORDER BY object_id;
45:
46: /* This cursor is for p_project_manager not null */

Line 55: FROM pa_projects_all ppa,

51: l_proj_from IN NUMBER,
52: l_proj_to IN NUMBER,
53: l_proj IN NUMBER) IS
54: SELECT DISTINCT ppa.project_id
55: FROM pa_projects_all ppa,
56: pa_project_parties ppp,
57: pa_project_types_all ppt,
58: pa_project_statuses pps -- Added for Bug 4338924
59: WHERE ppa.project_id = ppp.project_id

Line 64: AND ppa.segment1 BETWEEN NVL((select segment1 from pa_projects_all where project_id = l_proj_from),' ') AND

60: AND ppp.object_type = 'PA_PROJECTS'
61: AND ppa.project_status_code = pps.project_status_code -- Added for Bug 4338924
62: AND pps.status_type = 'PROJECT' -- Added for Bug 4338924
63: AND pps.project_system_status_code NOT IN ('CLOSED', 'PURGED') -- Added for Bug 4338924
64: AND ppa.segment1 BETWEEN NVL((select segment1 from pa_projects_all where project_id = l_proj_from),' ') AND
65: NVL((select segment1 from pa_projects_all where project_id = l_proj_to), ppa.segment1)
66: AND ppa.project_id = ppp.project_id
67: AND ppp.resource_source_id = nvl(l_project_manager,ppp.resource_source_id)
68: AND ppa.carrying_out_organization_id = nvl(l_project_ou, ppa.carrying_out_organization_id)

Line 65: NVL((select segment1 from pa_projects_all where project_id = l_proj_to), ppa.segment1)

61: AND ppa.project_status_code = pps.project_status_code -- Added for Bug 4338924
62: AND pps.status_type = 'PROJECT' -- Added for Bug 4338924
63: AND pps.project_system_status_code NOT IN ('CLOSED', 'PURGED') -- Added for Bug 4338924
64: AND ppa.segment1 BETWEEN NVL((select segment1 from pa_projects_all where project_id = l_proj_from),' ') AND
65: NVL((select segment1 from pa_projects_all where project_id = l_proj_to), ppa.segment1)
66: AND ppa.project_id = ppp.project_id
67: AND ppp.resource_source_id = nvl(l_project_manager,ppp.resource_source_id)
68: AND ppa.carrying_out_organization_id = nvl(l_project_ou, ppa.carrying_out_organization_id)
69: AND ppa.org_id = nvl(l_project_org, ppa.org_id)

Line 84: FROM pa_projects_all ppa,

80: l_proj_from IN NUMBER,
81: l_proj_to IN NUMBER,
82: l_proj IN NUMBER) IS
83: SELECT distinct ppa.project_id
84: FROM pa_projects_all ppa,
85: pa_project_types_all ppt,
86: pa_project_statuses pps -- Added for Bug 4338924
87: WHERE ppa.carrying_out_organization_id = nvl(l_project_ou, ppa.carrying_out_organization_id)
88: AND ppa.org_id = nvl(l_project_org, ppa.org_id)

Line 92: AND ppa.segment1 between nvl((select segment1 from pa_projects_all where project_id = l_proj_from),' ') and

88: AND ppa.org_id = nvl(l_project_org, ppa.org_id)
89: AND ppa.project_status_code = pps.project_status_code -- Added for Bug 4338924
90: AND pps.status_type = 'PROJECT' -- Added for Bug 4338924
91: AND pps.project_system_status_code NOT IN ('CLOSED', 'PURGED') -- Added for Bug 4338924
92: AND ppa.segment1 between nvl((select segment1 from pa_projects_all where project_id = l_proj_from),' ') and
93: nvl((select segment1 from pa_projects_all where project_id = l_proj_to), ppa.segment1)
94: AND ppa.project_type = nvl(l_proj_type, ppt.project_type)
95: and ppt.org_id = ppa.org_id
96: ORDER BY ppa.project_id;

Line 93: nvl((select segment1 from pa_projects_all where project_id = l_proj_to), ppa.segment1)

89: AND ppa.project_status_code = pps.project_status_code -- Added for Bug 4338924
90: AND pps.status_type = 'PROJECT' -- Added for Bug 4338924
91: AND pps.project_system_status_code NOT IN ('CLOSED', 'PURGED') -- Added for Bug 4338924
92: AND ppa.segment1 between nvl((select segment1 from pa_projects_all where project_id = l_proj_from),' ') and
93: nvl((select segment1 from pa_projects_all where project_id = l_proj_to), ppa.segment1)
94: AND ppa.project_type = nvl(l_proj_type, ppt.project_type)
95: and ppt.org_id = ppa.org_id
96: ORDER BY ppa.project_id;
97: