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_PROJECT_STRUCTURE_UTILS dependencies on PA_PROJ_ELEMENTS

Line 141: select 1 from pa_proj_elements

137: ,p_project_id IN NUMBER
138: ) return VARCHAR2
139: IS
140: cursor c1 is
141: select 1 from pa_proj_elements
142: where project_id = p_project_id
143: and object_type = 'PA_STRUCTURES'
144: and name = p_structure_name;
145:

Line 147: select 1 from pa_proj_elements

143: and object_type = 'PA_STRUCTURES'
144: and name = p_structure_name;
145:
146: cursor c2 IS
147: select 1 from pa_proj_elements
148: where project_id = p_project_id
149: and object_type = 'PA_STRUCTURES'
150: and name = p_structure_name
151: and proj_element_id <> p_structure_id;

Line 287: from pa_proj_structure_types p, pa_proj_elements e, pa_structure_types t

283: l_dummy VARCHAR2(1);
284:
285: cursor c1 is
286: select '1'
287: from pa_proj_structure_types p, pa_proj_elements e, pa_structure_types t
288: where e.project_id = p_project_id
289: and e.proj_element_id = p.proj_element_id
290: and p.structure_type_id = t.structure_type_id
291: and t.structure_type_class_code = p_structure_type

Line 408: from pa_proj_structure_types p, pa_proj_elements e,

404: l_dummy VARCHAR2(1);
405:
406: cursor c1 is
407: select '1'
408: from pa_proj_structure_types p, pa_proj_elements e,
409: pa_structure_types t, pa_proj_element_versions v
410: where v.element_version_id = p_structure_version_id
411: and v.proj_element_id = e.proj_element_id
412: and e.proj_element_id = p.proj_element_id

Line 601: l_proj_element_id PA_PROJ_ELEMENTS.proj_element_id%TYPE;

597: l_name PA_PROJ_ELEM_VER_STRUCTURE.name%TYPE;
598: l_suffix NUMBER;
599: l_new_name PA_PROJ_ELEM_VER_STRUCTURE.name%TYPE;
600: l_project_id PA_PROJECTS_ALL.project_id%TYPE;
601: l_proj_element_id PA_PROJ_ELEMENTS.proj_element_id%TYPE;
602:
603: l_dummy VARCHAR2(1);
604:
605: cursor getname is

Line 613: p_structure_id PA_PROJ_ELEMENTS.proj_element_id%TYPE,

609: s.project_id = v.project_id and
610: s.element_version_id = v.element_version_id;
611:
612: cursor new_name_valid(p_project_id PA_PROJECTS_ALL.project_id%TYPE,
613: p_structure_id PA_PROJ_ELEMENTS.proj_element_id%TYPE,
614: p_new_name VARCHAR2) is
615: select '1'
616: from pa_proj_elem_ver_structure
617: where project_id = p_project_id

Line 745: -- pa_proj_elements pe

741: select pev.element_version_id
742: into x_structure_version_id
743: from pa_proj_element_versions pev
744: -- pa_proj_elem_ver_structure pevs,
745: -- pa_proj_elements pe
746: where
747: -- pe.proj_element_id = p_structure_id
748: pev.element_version_id = p_structure_version_id;
749: -- and pevs.project_id = pe.project_id

Line 759: pa_proj_elements pe

755: --get by name
756: select pevs.element_version_id
757: into x_structure_version_id
758: from pa_proj_elem_ver_structure pevs,
759: pa_proj_elements pe
760: where pe.proj_element_id = p_structure_id
761: and pevs.project_id = pe.project_id
762: and pevs.proj_element_id = pe.proj_element_id
763: and pevs.name = p_structure_version_name;

Line 828: from pa_proj_elements

824: IF (p_structure_id IS NOT NULL) THEN
825: IF (p_check_id_flag = 'Y') THEN
826: select proj_element_id
827: into x_structure_id
828: from pa_proj_elements
829: where proj_element_id = p_structure_id;
830: ELSE
831: x_structure_id := p_structure_id;
832: END IF;

Line 836: from pa_proj_elements

832: END IF;
833: ELSE
834: select proj_element_id
835: into x_structure_id
836: from pa_proj_elements
837: where project_id = p_project_id
838: and object_type = 'PA_STRUCTURES'
839: and name = p_structure_name;
840: END IF;

Line 1238: select proj_element_id from pa_proj_elements

1234: function Associated_Structure(p_project_id NUMBER)
1235: return varchar2
1236: IS
1237: cursor c1 IS
1238: select proj_element_id from pa_proj_elements
1239: where project_id = p_project_id
1240: and object_type = 'PA_STRUCTURES';
1241: c1_rec c1%ROWTYPE;
1242:

Line 1327: pa_proj_elements b,

1323:
1324: CURSOR c3 IS
1325: select '1'
1326: from pa_object_relationships a,
1327: pa_proj_elements b,
1328: pa_proj_element_versions c
1329: where a.object_id_from1 = p_element_version_id
1330: and a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
1331: and a.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')

Line 1419: pa_proj_elements b,

1415: CURSOR c1 IS
1416: /* Commented the following query for Performance Bug fix : 3968091
1417: select c.element_version_id
1418: from pa_proj_element_versions c,
1419: pa_proj_elements b,
1420: pa_proj_structure_types a,
1421: pa_structure_types d
1422: where d.structure_type_class_code = 'WORKPLAN'
1423: and d.structure_type_id = a.structure_type_id

Line 1485: pa_proj_elements b,

1481: CURSOR c1 IS
1482: /*Commented the following Query for Performance Bug fix : 3968091
1483: select c.element_version_id
1484: from pa_proj_element_versions c,
1485: pa_proj_elements b,
1486: pa_proj_structure_types a,
1487: pa_structure_types d
1488: where d.structure_type_class_code = 'FINANCIAL'
1489: and d.structure_type_id = a.structure_type_id

Line 1596: from pa_proj_elements

1592: and c.proj_element_id = a.proj_element_id);
1593:
1594: CURSOR get_task_name_num(c_project_id NUMBER, c_proj_element_id NUMBER) IS
1595: select name, element_number
1596: from pa_proj_elements
1597: where project_id = c_project_id
1598: and proj_element_id = c_proj_element_id;
1599:
1600: l_ret_stat VARCHAR2(1);

Line 1609: l_task_name PA_PROJ_ELEMENTS.NAME%TYPE;

1605: l_latest_struc_ver_id NUMBER;
1606: l_project_id NUMBER;
1607: l_proj_element_id NUMBER;
1608: l_elem_proj_id NUMBER;
1609: l_task_name PA_PROJ_ELEMENTS.NAME%TYPE;
1610: l_task_number PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE;
1611: BEGIN
1612: --check if new structure version missing tasks with transactions
1613: OPEN get_latest_pub_ver;

Line 1610: l_task_number PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE;

1606: l_project_id NUMBER;
1607: l_proj_element_id NUMBER;
1608: l_elem_proj_id NUMBER;
1609: l_task_name PA_PROJ_ELEMENTS.NAME%TYPE;
1610: l_task_number PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE;
1611: BEGIN
1612: --check if new structure version missing tasks with transactions
1613: OPEN get_latest_pub_ver;
1614: FETCH get_latest_pub_ver into l_latest_struc_ver_id;

Line 1642: IF PA_PROJ_ELEMENTS_UTILS.structure_type(

1638: --Add error message to stack
1639: END IF;
1640:
1641:
1642: IF PA_PROJ_ELEMENTS_UTILS.structure_type(
1643: p_structure_version_id => p_structure_version_id
1644: ,p_task_version_id => null
1645: ,p_structure_type => 'WORKPLAN'
1646: ) = 'Y'

Line 1664: IF PA_PROJ_ELEMENTS_UTILS.structure_type(

1660: END IF;
1661:
1662: END IF;
1663:
1664: IF PA_PROJ_ELEMENTS_UTILS.structure_type(
1665: p_structure_version_id => p_structure_version_id
1666: ,p_task_version_id => null
1667: ,p_structure_type => 'FINANCIAL'
1668: ) = 'Y' THEN

Line 1777: FROM pa_proj_elements a,

1773: ) return VARCHAR2
1774: IS
1775: CURSOR c1 IS
1776: SELECT 'Y'
1777: FROM pa_proj_elements a,
1778: pa_proj_structure_types b,
1779: pa_structure_types c
1780: WHERE c.structure_type_class_code = 'WORKPLAN'
1781: AND c.structure_type_id = b.structure_type_id

Line 1816: FROM pa_proj_elements a,

1812: ) return VARCHAR2
1813: IS
1814: CURSOR c1 IS
1815: SELECT 'Y'
1816: FROM pa_proj_elements a,
1817: pa_proj_structure_types b,
1818: pa_structure_types c
1819: WHERE c.structure_type_class_code = 'FINANCIAL'
1820: AND c.structure_type_id = b.structure_type_id

Line 1856: FROM pa_proj_elements a,

1852: ) return VARCHAR2
1853: IS
1854: CURSOR c1 IS
1855: SELECT 'Y'
1856: FROM pa_proj_elements a,
1857: pa_proj_structure_types b,
1858: pa_structure_types c,
1859: pa_proj_structure_types d,
1860: pa_structure_types e

Line 1970: from pa_proj_elements

1966: l_structure_id NUMBER;
1967: --Bug No 3692992 Performance fix
1968: /* CURSOR get_tasks IS
1969: SELECT proj_element_id
1970: from pa_proj_elements
1971: where project_id = p_project_id
1972: and object_type = 'PA_TASKS'
1973: and proj_element_id IN (
1974: select distinct ppev1.proj_element_id

Line 1996: from pa_proj_elements ppe,

1992: l_task_id NUMBER;
1993:
1994: CURSOR get_wp_id IS
1995: SELECT ppe.proj_element_id
1996: from pa_proj_elements ppe,
1997: pa_proj_structure_types ppst,
1998: pa_structure_types pst
1999: where ppe.project_id = p_project_id
2000: and ppe.proj_element_id = ppst.proj_element_id

Line 2063: from pa_proj_elements

2059: )
2060: IS
2061: CURSOR get_tasks IS
2062: SELECT proj_element_id
2063: from pa_proj_elements
2064: where project_id = p_project_id
2065: and object_type = 'PA_TASKS'
2066: and proj_element_id NOT IN (
2067: select task_id

Line 2074: from pa_proj_elements ppe,

2070: l_task_id NUMBER;
2071:
2072: CURSOR get_wp_id IS
2073: SELECT ppe.proj_element_id
2074: from pa_proj_elements ppe,
2075: pa_proj_structure_types ppst,
2076: pa_structure_types pst
2077: where ppe.project_id = p_project_id
2078: and ppe.proj_element_id = ppst.proj_element_id

Line 2144: from pa_proj_elements

2140: )
2141: IS
2142: CURSOR get_tasks IS
2143: SELECT proj_element_id
2144: from pa_proj_elements
2145: where project_id = p_project_id
2146: and object_type = 'PA_TASKS';
2147: l_task_id NUMBER;
2148: BEGIN

Line 2240: FROM pa_proj_elements

2236:
2237: -- Bug 3933576 : Added cursor c_get_project_id
2238: CURSOR c_get_project_id IS
2239: SELECT project_id
2240: FROM pa_proj_elements
2241: where proj_element_id = p_task_id;
2242:
2243: BEGIN
2244: --get API from Saima

Line 2282: pa_proj_elements ppe

2278: IS
2279: CURSOR c1 IS
2280: select str.element_version_id
2281: from pa_proj_elem_ver_structure str,
2282: pa_proj_elements ppe
2283: where ppe.proj_element_id = p_structure_id
2284: and ppe.project_id = str.project_id
2285: and ppe.proj_element_id = str.proj_element_id
2286: and str.CURRENT_WORKING_FLAG = 'Y';

Line 2370: FROM PA_PROJ_ELEMENTS

2366: )
2367: IS
2368: CURSOR get_project_id IS
2369: SELECT project_id
2370: FROM PA_PROJ_ELEMENTS
2371: WHERE proj_element_id = p_proj_element_id;
2372:
2373: l_project_id NUMBER;
2374: BEGIN

Line 2476: from pa_proj_elements a,

2472: ) return VARCHAR2
2473: IS
2474: CURSOR c1 IS
2475: select 1
2476: from pa_proj_elements a,
2477: pa_proj_elem_ver_structure b
2478: where a.proj_element_id = p_proj_element_id
2479: and a.project_id = b.project_id
2480: and a.proj_element_id = b.proj_element_id

Line 2593: from pa_proj_elements ppe,

2589: ) return NUMBER
2590: IS
2591: CURSOR c1 IS
2592: select ppe.proj_element_id
2593: from pa_proj_elements ppe,
2594: pa_proj_structure_types ppst,
2595: pa_structure_types pst
2596: where ppe.project_id = p_project_id
2597: and ppe.proj_element_id = ppst.proj_element_id

Line 2629: from pa_proj_elements ppe,

2625: ) return NUMBER
2626: IS
2627: CURSOR c1 IS
2628: select ppevs.element_version_id
2629: from pa_proj_elements ppe,
2630: pa_proj_structure_types ppst,
2631: pa_structure_types pst,
2632: pa_proj_elem_ver_structure ppevs
2633: where ppe.project_id = p_project_id

Line 2649: from pa_proj_elements ppe,

2645: l_structure_version_id NUMBER;
2646:
2647: CURSOR c2 IS
2648: select ppevs.element_version_id
2649: from pa_proj_elements ppe,
2650: pa_proj_structure_types ppst,
2651: pa_structure_types pst,
2652: pa_proj_elem_ver_structure ppevs
2653: where ppe.project_id = p_project_id

Line 2732: from pa_proj_elements ppe,

2728: ) return NUMBER
2729: IS
2730: CURSOR c1 IS
2731: select ppevs.element_version_id
2732: from pa_proj_elements ppe,
2733: pa_proj_structure_types ppst,
2734: pa_structure_types pst,
2735: pa_proj_elem_ver_structure ppevs
2736: where ppe.project_id = p_project_id

Line 2862: from pa_proj_elements

2858: --bug 4068736
2859:
2860: CURSOR get_task_name_num(c_proj_element_id NUMBER) IS
2861: select name, element_number
2862: from pa_proj_elements
2863: where proj_element_id = c_proj_element_id;
2864: l_task_name PA_PROJ_ELEMENTS.NAME%TYPE;
2865: l_task_number PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE;
2866: l_message_text VARCHAR2(2000);

Line 2864: l_task_name PA_PROJ_ELEMENTS.NAME%TYPE;

2860: CURSOR get_task_name_num(c_proj_element_id NUMBER) IS
2861: select name, element_number
2862: from pa_proj_elements
2863: where proj_element_id = c_proj_element_id;
2864: l_task_name PA_PROJ_ELEMENTS.NAME%TYPE;
2865: l_task_number PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE;
2866: l_message_text VARCHAR2(2000);
2867:
2868: l_dummy NUMBER;

Line 2865: l_task_number PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE;

2861: select name, element_number
2862: from pa_proj_elements
2863: where proj_element_id = c_proj_element_id;
2864: l_task_name PA_PROJ_ELEMENTS.NAME%TYPE;
2865: l_task_number PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE;
2866: l_message_text VARCHAR2(2000);
2867:
2868: l_dummy NUMBER;
2869: BEGIN

Line 2980: pa_proj_elements ppe

2976:
2977: CURSOR c2(c_proj_element_id NUMBER) IS
2978: select pps.project_system_status_code
2979: from pa_project_statuses pps,
2980: pa_proj_elements ppe
2981: where ppe.proj_element_id = c_proj_element_id
2982: and ppe.status_code = pps.project_status_code
2983: and pps.status_type = 'TASK'
2984: and pps.project_system_status_code = 'CANCELLED';

Line 2989: pa_proj_elements ppe,

2985:
2986: CURSOR c3(c_parent_task_ver_id NUMBER) IS
2987: select pps.project_system_status_code
2988: from pa_project_statuses pps,
2989: pa_proj_elements ppe,
2990: pa_proj_element_versions ppev,
2991: pa_object_relationships por
2992: where por.object_id_from1 = c_parent_task_ver_id
2993: and por.object_type_from = 'PA_TASKS'

Line 3008: from pa_proj_elements

3004: l_system_status_code pa_project_statuses.project_system_status_code%TYPE;
3005:
3006: CURSOR get_task_name_num(c_proj_element_id NUMBER) IS
3007: select name, element_number
3008: from pa_proj_elements
3009: where proj_element_id = c_proj_element_id;
3010: l_task_name PA_PROJ_ELEMENTS.NAME%TYPE;
3011: l_task_number PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE;
3012:

Line 3010: l_task_name PA_PROJ_ELEMENTS.NAME%TYPE;

3006: CURSOR get_task_name_num(c_proj_element_id NUMBER) IS
3007: select name, element_number
3008: from pa_proj_elements
3009: where proj_element_id = c_proj_element_id;
3010: l_task_name PA_PROJ_ELEMENTS.NAME%TYPE;
3011: l_task_number PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE;
3012:
3013: BEGIN
3014: OPEN c1;

Line 3011: l_task_number PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE;

3007: select name, element_number
3008: from pa_proj_elements
3009: where proj_element_id = c_proj_element_id;
3010: l_task_name PA_PROJ_ELEMENTS.NAME%TYPE;
3011: l_task_number PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE;
3012:
3013: BEGIN
3014: OPEN c1;
3015: LOOP

Line 3438: from pa_proj_element_versions pev, pa_proj_elements pe,

3434: l_struc_ver_id NUMBER;
3435: cursor getFinOnlyStrucVer(c_project_id NUMBER) IS
3436: /*Commented the Following SQL Query for Performance Bug fix : 3968091
3437: select pev.element_version_id
3438: from pa_proj_element_versions pev, pa_proj_elements pe,
3439: pa_proj_structure_types pst
3440: where pe.project_id = c_project_id
3441: and pe.project_id = pev.project_id
3442: and pe.proj_element_id = pev.proj_element_id

Line 3758: FROM pa_proj_elements a,

3754: ) Return VARCHAR2
3755: IS
3756: CURSOR c1 IS
3757: SELECT 'Y'
3758: FROM pa_proj_elements a,
3759: pa_proj_structure_types b,
3760: pa_structure_types c
3761: WHERE c.structure_type_class_code = 'DELIVERABLE'
3762: AND c.structure_type_id = b.structure_type_id

Line 3785: FROM pa_proj_elements ppe,

3781: RETURN NUMBER AS
3782: CURSOR cur_cwv
3783: IS
3784: SELECT ppevs.element_version_id
3785: FROM pa_proj_elements ppe,
3786: pa_proj_structure_types ppst,
3787: pa_structure_types pst,
3788: pa_proj_elem_ver_structure ppevs
3789: WHERE ppe.project_id = p_project_id

Line 4007: FROM pa_proj_elements ppe,

4003: IS
4004: --Bug No 3692992 Performance fix
4005: /* CURSOR get_baseline_wp_ver(cp_proj_id NUMBER) IS
4006: SELECT ppev.element_version_id
4007: FROM pa_proj_elements ppe,
4008: pa_proj_element_versions ppev,
4009: pa_proj_elem_ver_structure ppevs,
4010: pa_proj_structure_types ppst,
4011: pa_structure_types pst

Line 4024: FROM pa_proj_elements ppe,

4020: AND pst.structure_type_class_code = 'WORKPLAN';*/
4021:
4022: CURSOR get_baseline_wp_ver(cp_proj_id NUMBER) IS
4023: SELECT ppev.element_version_id
4024: FROM pa_proj_elements ppe,
4025: pa_proj_element_versions ppev,
4026: pa_proj_elem_ver_structure ppevs,
4027: pa_proj_structure_types ppst,
4028: pa_structure_types pst

Line 4142: pa_proj_elements ppe

4138: /*
4139: CURSOR chk_lnk_task(cp_structure_version_id NUMBER,cp_project_id NUMBER) IS
4140: SELECT '1'
4141: FROM pa_proj_element_versions ppev,
4142: pa_proj_elements ppe
4143: WHERE ppev.element_version_id = cp_structure_version_id
4144: AND ppev.project_id = cp_project_id
4145: AND ppev.project_id = ppe.project_id
4146: AND ppev.proj_element_id = ppe.parent_structure_id