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 272: from pa_proj_elem_ver_structure

268: CURSOR cur_pub_versions is
269: select 'Y' from dual
270: where EXISTS
271: ( select 'xyz'
272: from pa_proj_elem_ver_structure
273: where proj_element_id = p_structure_id
274: AND project_id = p_project_id
275: and STATUS_CODE = 'STRUCTURE_PUBLISHED');
276:

Line 284: from pa_proj_elem_ver_structure

280: --bug 3074706
281: --need to include project_id to use index
282: CURSOR cur_pub_versions2 is
283: select 'Y'
284: from pa_proj_elem_ver_structure
285: where element_version_id = p_structure_version_id
286: and project_id = p_project_id
287: and STATUS_CODE = 'STRUCTURE_PUBLISHED';
288: --end bug 3074706

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

1103: END IF;
1104: end 3459905 */
1105: /*SELECT nvl( wbs_record_version_number, 1 )
1106: INTO l_wbs_record_version_number
1107: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
1108: FROM pa_proj_elem_ver_structure
1109: -- HY FROM pa_projects_all
1110: WHERE project_id = p_project_id
1111: AND element_version_id = p_structure_version_id;*/

Line 1108: FROM pa_proj_elem_ver_structure

1104: end 3459905 */
1105: /*SELECT nvl( wbs_record_version_number, 1 )
1106: INTO l_wbs_record_version_number
1107: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
1108: FROM pa_proj_elem_ver_structure
1109: -- HY FROM pa_projects_all
1110: WHERE project_id = p_project_id
1111: AND element_version_id = p_structure_version_id;*/
1112: l_wbs_record_version_number := 1; --temporarily

Line 1675: from pa_proj_elem_ver_structure

1671: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
1672: select 'Y' from dual
1673: where exists
1674: (select 'xyz'
1675: from pa_proj_elem_ver_structure
1676: where proj_element_id = c_structure_id
1677: AND project_id = c_project_id
1678: and STATUS_CODE = 'STRUCTURE_PUBLISHED');
1679:

Line 1701: pa_proj_elem_ver_structure c

1697: cursor get_latest_task_ver_id IS
1698: select b.parent_structure_version_id, b.element_version_id
1699: from pa_proj_elements a,
1700: pa_proj_element_versions b,
1701: pa_proj_elem_ver_structure c
1702: where a.proj_element_id = p_task_id
1703: and a.project_id = b.project_id
1704: and a.proj_element_id = b.proj_element_id
1705: and b.project_id = c.project_id

Line 1734: pa_proj_elem_ver_structure ppevs

1730: --Bug 3475920
1731: CURSOR get_task_versions_id(cp_task_id NUMBER,cp_project_id NUMBER) IS
1732: SELECT ppev.element_Version_id
1733: FROM pa_proj_element_versions ppev,
1734: pa_proj_elem_ver_structure ppevs
1735: WHERE ppev.project_id = cp_project_id
1736: and ppev.proj_element_id = cp_task_id
1737: and ppev.project_id = ppevs.project_id
1738: and ppevs.element_version_id = ppev.parent_structure_version_id

Line 1744: pa_proj_elem_ver_structure ppevs

1740: --
1741: CURSOR get_task_versions_id2(cp_task_id NUMBER,cp_project_id NUMBER) IS
1742: SELECT ppev.element_Version_id
1743: FROM pa_proj_element_versions ppev,
1744: pa_proj_elem_ver_structure ppevs
1745: WHERE ppev.project_id = cp_project_id
1746: and ppev.proj_element_id = cp_task_id
1747: and ppev.project_id = ppevs.project_id
1748: and ppevs.element_version_id = ppev.parent_structure_version_id

Line 2122: UPDATE pa_proj_elem_ver_structure

2118: FETCH cur_proj_tmp INTO l_template_flag;
2119: CLOSE cur_proj_tmp;
2120: IF NVL( l_versioned, 'N' ) = 'N' OR NVl( l_template_flag, 'N' ) = 'Y'
2121: THEN
2122: UPDATE pa_proj_elem_ver_structure
2123: SET process_update_wbs_flag = 'Y'
2124: WHERE project_id = l_project_id
2125: AND proj_element_id = l_structure_id;
2126: ELSIF NVL( l_versioned, 'N' ) = 'Y'

Line 2128: UPDATE pa_proj_elem_ver_structure

2124: WHERE project_id = l_project_id
2125: AND proj_element_id = l_structure_id;
2126: ELSIF NVL( l_versioned, 'N' ) = 'Y'
2127: THEN
2128: UPDATE pa_proj_elem_ver_structure
2129: SET process_update_wbs_flag = 'Y'
2130: WHERE project_id = l_project_id
2131: AND proj_element_id = l_structure_id
2132: AND status_code = 'STRUCTURE_WORKING';

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

4889:
4890: CURSOR cur_pa_projs( p_project_id NUMBER )
4891: IS
4892: SELECT wbs_record_version_number
4893: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
4894: FROM pa_proj_elem_ver_structure
4895: -- HY FROM pa_projects_all
4896: WHERE project_id = p_project_id;
4897:

Line 4894: FROM pa_proj_elem_ver_structure

4890: CURSOR cur_pa_projs( p_project_id NUMBER )
4891: IS
4892: SELECT wbs_record_version_number
4893: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
4894: FROM pa_proj_elem_ver_structure
4895: -- HY FROM pa_projects_all
4896: WHERE project_id = p_project_id;
4897:
4898: CURSOR cur_pa_tasks( p_task_id NUMBER )

Line 4982: pa_proj_elem_ver_structure c

4978: --hsiu task status changes
4979: cursor get_latest_task_ver_id IS
4980: select b.parent_structure_version_id, b.element_version_id
4981: from pa_proj_element_versions b,
4982: pa_proj_elem_ver_structure c
4983: where b.element_version_id = p_task_version_id
4984: and b.project_id = c.project_id
4985: and b.parent_structure_version_id = c.element_version_id
4986: and c.LATEST_EFF_PUBLISHED_FLAG = 'Y';

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

8879:
8880: CURSOR cur_pa_projs( p_project_id NUMBER )
8881: IS
8882: SELECT wbs_record_version_number
8883: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
8884: FROM pa_proj_elem_ver_structure
8885: -- HY FROM pa_projects_all
8886: WHERE project_id = p_project_id;
8887:

Line 8884: FROM pa_proj_elem_ver_structure

8880: CURSOR cur_pa_projs( p_project_id NUMBER )
8881: IS
8882: SELECT wbs_record_version_number
8883: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
8884: FROM pa_proj_elem_ver_structure
8885: -- HY FROM pa_projects_all
8886: WHERE project_id = p_project_id;
8887:
8888: CURSOR cur_pa_tasks( p_task_id NUMBER )

Line 8966: pa_proj_elem_ver_structure c

8962: --hsiu task status changes
8963: cursor get_latest_task_ver_id IS
8964: select b.parent_structure_version_id, b.element_version_id
8965: from pa_proj_element_versions b,
8966: pa_proj_elem_ver_structure c
8967: where b.element_version_id = p_task_version_id
8968: and b.project_id = c.project_id
8969: and b.parent_structure_version_id = c.element_version_id
8970: and c.LATEST_EFF_PUBLISHED_FLAG = 'Y';

Line 9687: pa_proj_elem_ver_structure b,

9683: IS
9684: CURSOR get_working_ver(c_option NUMBER) IS
9685: select a.element_version_id, c.object_id_from1
9686: from pa_proj_element_versions a,
9687: pa_proj_elem_ver_structure b,
9688: pa_object_relationships c
9689: where a.parent_structure_version_id = b.element_version_id
9690: and a.project_id = b.project_id
9691: and a.proj_element_id = p_task_id

Line 9700: pa_proj_elem_ver_structure b,

9696: and 1 = c_option
9697: UNION
9698: select a.element_version_id, c.object_id_from1
9699: from pa_proj_element_versions a,
9700: pa_proj_elem_ver_structure b,
9701: pa_object_relationships c
9702: where a.parent_structure_version_id = b.element_version_id
9703: and a.project_id = b.project_id
9704: and a.proj_element_id = p_task_id

Line 9811: FROM pa_proj_elem_ver_structure

9807:
9808: CURSOR cur_all_wrkng_str_ver
9809: IS
9810: SELECT element_version_id
9811: FROM pa_proj_elem_ver_structure
9812: WHERE project_id = p_project_id
9813: AND status_code <> 'STRUCTURE_PUBLISHED';
9814:
9815: CURSOR cur_task_ver_ids( c_parent_structure_version_id NUMBER )