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_TASK_PVT1 dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 278: from pa_proj_elem_ver_structure

274: CURSOR cur_pub_versions is
275: select 'Y' from dual
276: where EXISTS
277: ( select 'xyz'
278: from pa_proj_elem_ver_structure
279: where proj_element_id = p_structure_id
280: AND project_id = p_project_id
281: and STATUS_CODE = 'STRUCTURE_PUBLISHED');
282:

Line 290: from pa_proj_elem_ver_structure

286: --bug 3074706
287: --need to include project_id to use index
288: CURSOR cur_pub_versions2 is
289: select 'Y'
290: from pa_proj_elem_ver_structure
291: where element_version_id = p_structure_version_id
292: and project_id = p_project_id
293: and STATUS_CODE = 'STRUCTURE_PUBLISHED';
294: --end bug 3074706

Line 1215: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure

1211: END IF;
1212: end 3459905 */
1213: /*SELECT nvl( wbs_record_version_number, 1 )
1214: INTO l_wbs_record_version_number
1215: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
1216: FROM pa_proj_elem_ver_structure
1217: -- HY FROM pa_projects_all
1218: WHERE project_id = p_project_id
1219: AND element_version_id = p_structure_version_id;*/

Line 1216: FROM pa_proj_elem_ver_structure

1212: end 3459905 */
1213: /*SELECT nvl( wbs_record_version_number, 1 )
1214: INTO l_wbs_record_version_number
1215: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
1216: FROM pa_proj_elem_ver_structure
1217: -- HY FROM pa_projects_all
1218: WHERE project_id = p_project_id
1219: AND element_version_id = p_structure_version_id;*/
1220: l_wbs_record_version_number := 1; --temporarily

Line 1789: from pa_proj_elem_ver_structure

1785: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
1786: select 'Y' from dual
1787: where exists
1788: (select 'xyz'
1789: from pa_proj_elem_ver_structure
1790: where proj_element_id = c_structure_id
1791: AND project_id = c_project_id
1792: and STATUS_CODE = 'STRUCTURE_PUBLISHED');
1793:

Line 1815: pa_proj_elem_ver_structure c

1811: cursor get_latest_task_ver_id IS
1812: select b.parent_structure_version_id, b.element_version_id
1813: from pa_proj_elements a,
1814: pa_proj_element_versions b,
1815: pa_proj_elem_ver_structure c
1816: where a.proj_element_id = p_task_id
1817: and a.project_id = b.project_id
1818: and a.proj_element_id = b.proj_element_id
1819: and b.project_id = c.project_id

Line 1848: pa_proj_elem_ver_structure ppevs

1844: --Bug 3475920
1845: CURSOR get_task_versions_id(cp_task_id NUMBER,cp_project_id NUMBER) IS
1846: SELECT ppev.element_Version_id
1847: FROM pa_proj_element_versions ppev,
1848: pa_proj_elem_ver_structure ppevs
1849: WHERE ppev.project_id = cp_project_id
1850: and ppev.proj_element_id = cp_task_id
1851: and ppev.project_id = ppevs.project_id
1852: and ppevs.element_version_id = ppev.parent_structure_version_id

Line 1858: pa_proj_elem_ver_structure ppevs

1854: --
1855: CURSOR get_task_versions_id2(cp_task_id NUMBER,cp_project_id NUMBER) IS
1856: SELECT ppev.element_Version_id
1857: FROM pa_proj_element_versions ppev,
1858: pa_proj_elem_ver_structure ppevs
1859: WHERE ppev.project_id = cp_project_id
1860: and ppev.proj_element_id = cp_task_id
1861: and ppev.project_id = ppevs.project_id
1862: and ppevs.element_version_id = ppev.parent_structure_version_id

Line 2241: UPDATE pa_proj_elem_ver_structure

2237: FETCH cur_proj_tmp INTO l_template_flag;
2238: CLOSE cur_proj_tmp;
2239: IF NVL( l_versioned, 'N' ) = 'N' OR NVl( l_template_flag, 'N' ) = 'Y'
2240: THEN
2241: UPDATE pa_proj_elem_ver_structure
2242: SET process_update_wbs_flag = 'Y'
2243: WHERE project_id = l_project_id
2244: AND proj_element_id = l_structure_id;
2245: ELSIF NVL( l_versioned, 'N' ) = 'Y'

Line 2247: UPDATE pa_proj_elem_ver_structure

2243: WHERE project_id = l_project_id
2244: AND proj_element_id = l_structure_id;
2245: ELSIF NVL( l_versioned, 'N' ) = 'Y'
2246: THEN
2247: UPDATE pa_proj_elem_ver_structure
2248: SET process_update_wbs_flag = 'Y'
2249: WHERE project_id = l_project_id
2250: AND proj_element_id = l_structure_id
2251: AND status_code = 'STRUCTURE_WORKING';

Line 5393: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure

5389:
5390: CURSOR cur_pa_projs( p_project_id NUMBER )
5391: IS
5392: SELECT wbs_record_version_number
5393: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
5394: FROM pa_proj_elem_ver_structure
5395: -- HY FROM pa_projects_all
5396: WHERE project_id = p_project_id;
5397:

Line 5394: FROM pa_proj_elem_ver_structure

5390: CURSOR cur_pa_projs( p_project_id NUMBER )
5391: IS
5392: SELECT wbs_record_version_number
5393: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
5394: FROM pa_proj_elem_ver_structure
5395: -- HY FROM pa_projects_all
5396: WHERE project_id = p_project_id;
5397:
5398: CURSOR cur_pa_tasks( p_task_id NUMBER )

Line 5482: pa_proj_elem_ver_structure c

5478: --hsiu task status changes
5479: cursor get_latest_task_ver_id IS
5480: select b.parent_structure_version_id, b.element_version_id
5481: from pa_proj_element_versions b,
5482: pa_proj_elem_ver_structure c
5483: where b.element_version_id = p_task_version_id
5484: and b.project_id = c.project_id
5485: and b.parent_structure_version_id = c.element_version_id
5486: and c.LATEST_EFF_PUBLISHED_FLAG = 'Y';

Line 9629: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure

9625:
9626: CURSOR cur_pa_projs( p_project_id NUMBER )
9627: IS
9628: SELECT wbs_record_version_number
9629: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
9630: FROM pa_proj_elem_ver_structure
9631: -- HY FROM pa_projects_all
9632: WHERE project_id = p_project_id;
9633:

Line 9630: FROM pa_proj_elem_ver_structure

9626: CURSOR cur_pa_projs( p_project_id NUMBER )
9627: IS
9628: SELECT wbs_record_version_number
9629: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
9630: FROM pa_proj_elem_ver_structure
9631: -- HY FROM pa_projects_all
9632: WHERE project_id = p_project_id;
9633:
9634: CURSOR cur_pa_tasks( p_task_id NUMBER )

Line 9712: pa_proj_elem_ver_structure c

9708: --hsiu task status changes
9709: cursor get_latest_task_ver_id IS
9710: select b.parent_structure_version_id, b.element_version_id
9711: from pa_proj_element_versions b,
9712: pa_proj_elem_ver_structure c
9713: where b.element_version_id = p_task_version_id
9714: and b.project_id = c.project_id
9715: and b.parent_structure_version_id = c.element_version_id
9716: and c.LATEST_EFF_PUBLISHED_FLAG = 'Y';

Line 10444: pa_proj_elem_ver_structure b,

10440: IS
10441: CURSOR get_working_ver(c_option NUMBER) IS
10442: select a.element_version_id, c.object_id_from1
10443: from pa_proj_element_versions a,
10444: pa_proj_elem_ver_structure b,
10445: pa_object_relationships c
10446: where a.parent_structure_version_id = b.element_version_id
10447: and a.project_id = b.project_id
10448: and a.proj_element_id = p_task_id

Line 10457: pa_proj_elem_ver_structure b,

10453: and 1 = c_option
10454: UNION
10455: select a.element_version_id, c.object_id_from1
10456: from pa_proj_element_versions a,
10457: pa_proj_elem_ver_structure b,
10458: pa_object_relationships c
10459: where a.parent_structure_version_id = b.element_version_id
10460: and a.project_id = b.project_id
10461: and a.proj_element_id = p_task_id

Line 10568: FROM pa_proj_elem_ver_structure

10564:
10565: CURSOR cur_all_wrkng_str_ver
10566: IS
10567: SELECT element_version_id
10568: FROM pa_proj_elem_ver_structure
10569: WHERE project_id = p_project_id
10570: AND status_code <> 'STRUCTURE_PUBLISHED';
10571:
10572: CURSOR cur_task_ver_ids( c_parent_structure_version_id NUMBER )