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_PROJ_ELEMENTS_UTILS dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 224: FROM pa_proj_element_versions ppev,

220:
221: CURSOR cur_elem_ver
222: IS
223: SELECT ppe.name, ppe.element_number, ppev.parent_structure_version_id, ppe.project_id
224: FROM pa_proj_element_versions ppev,
225: pa_proj_elements ppe
226: WHERE ppe.proj_element_id = ppev.proj_element_id
227: AND ppev.element_version_id = p_element_version_id
228: AND ppev.object_type = 'PA_TASKS';

Line 231: The project_id is got from pa_proj_element_versions*/

227: AND ppev.element_version_id = p_element_version_id
228: AND ppev.object_type = 'PA_TASKS';
229:
230: /* Bug 2680486 -- Performance changes -- Added one more condition to compare project_id in the following cursor.
231: The project_id is got from pa_proj_element_versions*/
232:
233: CURSOR cur_elem_ver_stru( p_version_id NUMBER )
234: IS
235: SELECT ppevs.version_number, ppevs.name, ppe.element_number, ppe.name, ppe.proj_element_id, ppe.project_id

Line 241: from pa_proj_element_versions

237: pa_proj_elements ppe
238: WHERE ppevs.element_version_id = p_version_id
239: AND ppe.proj_element_id = ppevs.proj_element_id
240: AND ppevs.project_id = (select project_id
241: from pa_proj_element_versions
242: where element_version_id = p_version_id) ;
243:
244: CURSOR cur_lookups
245: IS

Line 382: FROM pa_proj_element_versions b,

378: c.pev_structure_id,
379: c.element_version_id,
380: c.name,
381: c.record_version_number
382: FROM pa_proj_element_versions b,
383: pa_proj_elem_ver_schedule a,
384: pa_proj_elem_ver_structure c,
385: pa_structure_types d ,
386: pa_proj_structure_types e

Line 617: FROM pa_object_relationships por, pa_proj_elements ppe, pa_proj_element_versions ppev

613: ) RETURN VARCHAR2 IS
614: CURSOR cur_obj_rel
615: IS
616: SELECT 'x'
617: FROM pa_object_relationships por, pa_proj_elements ppe, pa_proj_element_versions ppev
618: WHERE object_id_from1 = p_structure_version_id
619: AND relationship_type = 'S'
620: AND por.object_id_to1 = ppev.element_version_id
621: AND ppe.proj_element_id = ppev.proj_element_id

Line 828: from pa_proj_element_versions v, pa_proj_elem_ver_structure s

824: and f.user_id = p_user_id;
825:
826: cursor get_lock_user(p_person_id NUMBER) IS
827: select '1'
828: from pa_proj_element_versions v, pa_proj_elem_ver_structure s
829: where v.element_version_id = p_parent_structure_ver_id
830: and v.project_id = s.project_id
831: and v.element_version_id = s.element_version_id
832: and (locked_by_person_id IS NULL

Line 845: FROM pa_proj_element_versions

841:
842: CURSOR cur_chk_last_ver
843: IS
844: SELECT 'x'
845: FROM pa_proj_element_versions
846: WHERE proj_element_id = ( SELECT proj_element_id
847: FROM pa_proj_element_versions
848: WHERE element_version_id = p_task_version_id )
849: AND element_version_id <> p_task_version_id;

Line 847: FROM pa_proj_element_versions

843: IS
844: SELECT 'x'
845: FROM pa_proj_element_versions
846: WHERE proj_element_id = ( SELECT proj_element_id
847: FROM pa_proj_element_versions
848: WHERE element_version_id = p_task_version_id )
849: AND element_version_id <> p_task_version_id;
850:
851: CURSOR cur_proj_elem_ver

Line 854: FROM pa_proj_element_versions ppev, pa_tasks pt

850:
851: CURSOR cur_proj_elem_ver
852: IS
853: SELECT ppev.proj_element_id
854: FROM pa_proj_element_versions ppev, pa_tasks pt
855: WHERE ppev.element_version_id = p_task_version_id
856: and ppev.proj_element_id = pt.task_id;
857:
858: -- Bug 3933576 : Added cursor cur_wp_proj_elem_ver and variable l_wp_proj_elem_id

Line 862: FROM pa_proj_element_versions ppev

858: -- Bug 3933576 : Added cursor cur_wp_proj_elem_ver and variable l_wp_proj_elem_id
859: CURSOR cur_wp_proj_elem_ver
860: IS
861: SELECT ppev.proj_element_id
862: FROM pa_proj_element_versions ppev
863: WHERE ppev.element_version_id = p_task_version_id
864: ;
865:
866:

Line 1113: FROM pa_proj_element_versions

1109:
1110: CURSOR cur_proj_elem
1111: IS
1112: SELECT parent_structure_version_id
1113: FROM pa_proj_element_versions
1114: WHERE element_version_id = p_task_version_id
1115: AND object_type = 'PA_TASKS';
1116:
1117: CURSOR cur_struc_type( x_structure_version_id NUMBER )

Line 1120: FROM pa_proj_element_versions ppev

1116:
1117: CURSOR cur_struc_type( x_structure_version_id NUMBER )
1118: IS
1119: SELECT 'Y'
1120: FROM pa_proj_element_versions ppev
1121: ,pa_proj_structure_types ppst
1122: ,pa_structure_types pst
1123: WHERE ppev.element_version_id = x_structure_version_id
1124: AND ppev.proj_element_id = ppst.proj_element_id

Line 1183: pa_proj_element_versions pev,

1179: FROM DUAL
1180: WHERE EXISTS
1181: (SELECT NULL
1182: FROM pa_object_relationships por,
1183: pa_proj_element_versions pev,
1184: pa_proj_elements pe
1185: WHERE por.object_id_from1 = p_element_version_id
1186: AND por.object_type_from ='PA_TASKS'
1187: AND por.relationship_type = 'S'

Line 1360: from pa_proj_element_versions

1356: IF (p_task_version_id IS NOT NULL) THEN
1357: IF (p_check_id_flag = 'Y') THEN
1358: select element_version_id
1359: into x_task_version_id
1360: from pa_proj_element_versions
1361: where element_version_id = p_task_version_id;
1362: ELSE
1363: x_task_version_id := p_task_version_id;
1364: END IF;

Line 1368: from pa_proj_elements ppe, pa_proj_element_versions ppev

1364: END IF;
1365: ELSE
1366: select element_version_id
1367: into x_task_version_id
1368: from pa_proj_elements ppe, pa_proj_element_versions ppev
1369: where ppe.proj_element_id = ppev.proj_element_id
1370: AND ppe.name = p_task_name
1371: AND ppev.parent_structure_version_id = p_structure_version_id;
1372: null;

Line 1424: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel

1420: IS
1421: CURSOR TASK_INFO_CSR(c_task_id NUMBER)
1422: IS
1423: SELECT rel.object_id_from1 parent_task_id, pev.wbs_number
1424: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1425: WHERE pev.element_version_id = c_task_id
1426: AND pev.object_type = 'PA_TASKS'
1427: AND rel.object_id_to1 = pev.element_version_id
1428: AND rel.relationship_type = 'S'

Line 1434: FROM PA_PROJ_ELEMENT_VERSIONS

1430:
1431: CURSOR UPDATE_MASKED_TASKS_CSR (c_parent_structure_ver_id NUMBER, c_display_seq NUMBER, c_mask VARCHAR2)
1432: IS
1433: SELECT element_version_id task_id, wbs_number, display_sequence
1434: FROM PA_PROJ_ELEMENT_VERSIONS
1435: WHERE parent_structure_version_id = c_parent_structure_ver_id
1436: AND object_type = 'PA_TASKS'
1437: AND abs(display_sequence) >= abs(c_display_seq)
1438: AND display_sequence <> c_display_seq

Line 1446: FROM PA_PROJ_ELEMENT_VERSIONS

1442:
1443: CURSOR UPDATE_TASKS_CSR (c_parent_structure_ver_id NUMBER, c_display_seq NUMBER)
1444: IS
1445: SELECT element_version_id task_id, wbs_number, display_sequence
1446: FROM PA_PROJ_ELEMENT_VERSIONS
1447: WHERE parent_structure_version_id = c_parent_structure_ver_id
1448: AND object_type = 'PA_TASKS'
1449: AND abs(display_sequence) >= abs(c_display_seq)
1450: AND display_sequence <> c_display_seq

Line 1456: FROM PA_PROJ_ELEMENT_VERSIONS

1452:
1453: CURSOR GET_TASK_CSR (c_parent_structure_ver_id NUMBER, c_display_seq NUMBER)
1454: IS
1455: SELECT element_version_id task_id
1456: FROM PA_PROJ_ELEMENT_VERSIONS
1457: WHERE parent_structure_version_id = c_parent_structure_ver_id
1458: AND object_type = 'PA_TASKS'
1459: AND display_sequence = c_display_seq;
1460:

Line 1464: FROM PA_PROJ_ELEMENT_VERSIONS

1460:
1461: CURSOR GET_PREV_PEER_TASK_CSR(c_parent_structure_ver_id NUMBER, c_parent_task_id NUMBER, c_display_seq NUMBER)
1462: IS
1463: SELECT element_version_id task_id
1464: FROM PA_PROJ_ELEMENT_VERSIONS
1465: WHERE parent_structure_version_id = c_parent_structure_ver_id
1466: AND object_type = 'PA_TASKS'
1467: AND display_sequence =
1468: (SELECT max(pev.display_sequence)

Line 1469: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel

1465: WHERE parent_structure_version_id = c_parent_structure_ver_id
1466: AND object_type = 'PA_TASKS'
1467: AND display_sequence =
1468: (SELECT max(pev.display_sequence)
1469: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1470: WHERE rel.object_type_from = 'PA_TASKS'
1471: AND rel.object_id_from1 = c_parent_task_id
1472: AND rel.relationship_type = 'S'
1473: AND rel.object_type_to = 'PA_TASKS'

Line 1481: FROM PA_PROJ_ELEMENT_VERSIONS

1477:
1478: CURSOR GET_PREV_TOP_PEER_TASK_CSR(c_parent_structure_ver_id NUMBER, c_display_seq NUMBER)
1479: IS
1480: SELECT element_version_id task_id
1481: FROM PA_PROJ_ELEMENT_VERSIONS
1482: WHERE parent_structure_version_id = c_parent_structure_ver_id
1483: AND object_type = 'PA_TASKS'
1484: AND display_sequence =
1485: (SELECT max(pev.display_sequence)

Line 1486: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel

1482: WHERE parent_structure_version_id = c_parent_structure_ver_id
1483: AND object_type = 'PA_TASKS'
1484: AND display_sequence =
1485: (SELECT max(pev.display_sequence)
1486: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1487: WHERE rel.object_type_from = 'PA_STRUCTURES'
1488: AND rel.object_id_from1 = c_parent_structure_ver_id
1489: AND rel.relationship_type = 'S'
1490: AND rel.object_type_to = 'PA_TASKS'

Line 1541: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel

1537: -- Added the leading hint below for bug 3416314
1538: -- Smukka Merging branch 40 as of now with main branch
1539: SELECT /*+ LEADING (rel) */ count(pev.element_version_id)
1540: INTO l_count
1541: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1542: WHERE pev.parent_structure_version_id = p_parent_structure_ver_id
1543: AND pev.object_type = 'PA_TASKS'
1544: AND abs(pev.display_sequence) <= abs(p_display_seq)
1545: AND rel.object_id_to1 = pev.element_version_id

Line 1601: UPDATE PA_PROJ_ELEMENT_VERSIONS

1597: end if;
1598: end if; -- ig(l_task_rec.parent_task_id = p_parent_structure_ver_id) then
1599:
1600: -- Update the WBS number for the inserted task
1601: UPDATE PA_PROJ_ELEMENT_VERSIONS
1602: SET wbs_number = l_wbs_number
1603: WHERE element_version_id = p_task_id;
1604:
1605: -- Loop through tasks that have a greater display seq than the current

Line 1646: UPDATE PA_PROJ_ELEMENT_VERSIONS

1642:
1643: end if;
1644:
1645: -- Update the WBS number
1646: UPDATE PA_PROJ_ELEMENT_VERSIONS
1647: SET wbs_number = l_wbs_number
1648: WHERE element_version_id = l_update_task_rec.task_id;
1649: END LOOP;
1650:

Line 1695: UPDATE PA_PROJ_ELEMENT_VERSIONS

1691:
1692: --dbms_output.put_line('L_WBS_NUMBER: ' || l_wbs_number);
1693:
1694: -- Update the WBS number for the indented task
1695: UPDATE PA_PROJ_ELEMENT_VERSIONS
1696: SET wbs_number = l_wbs_number
1697: WHERE element_version_id = p_task_id;
1698:
1699: -- Find l_mask

Line 1781: UPDATE PA_PROJ_ELEMENT_VERSIONS

1777:
1778: end if;
1779:
1780: -- Update the WBS number
1781: UPDATE PA_PROJ_ELEMENT_VERSIONS
1782: SET wbs_number = l_loop_wbs_number
1783: WHERE element_version_id = l_update_task_rec.task_id;
1784: END LOOP;
1785:

Line 1850: UPDATE PA_PROJ_ELEMENT_VERSIONS

1846: l_mask2 := l_prev_task_rec.wbs_number;
1847: --dbms_output.put_line('L_MASK2: ' || l_mask2);
1848:
1849: -- Update the WBS number for the outdented task
1850: UPDATE PA_PROJ_ELEMENT_VERSIONS
1851: SET wbs_number = l_wbs_number
1852: WHERE element_version_id = p_task_id;
1853:
1854: --dbms_output.put_line('L_WBS_NUMBER: ' || l_wbs_number);

Line 1963: UPDATE PA_PROJ_ELEMENT_VERSIONS

1959:
1960: end if;
1961:
1962: -- Update the WBS number
1963: UPDATE PA_PROJ_ELEMENT_VERSIONS
1964: SET wbs_number = l_loop_wbs_number
1965: WHERE element_version_id = l_update_task_rec.task_id;
1966: END LOOP;
1967:

Line 2032: UPDATE PA_PROJ_ELEMENT_VERSIONS

2028: end if;
2029: end if;
2030:
2031: -- Update the WBS number
2032: UPDATE PA_PROJ_ELEMENT_VERSIONS
2033: SET wbs_number = l_wbs_number
2034: WHERE element_version_id = l_update_task_rec.task_id;
2035: END LOOP;
2036:

Line 2075: FROM pa_proj_element_versions

2071:
2072: CURSOR cur_ppev
2073: IS
2074: SELECT 'x'
2075: FROM pa_proj_element_versions
2076: WHERE element_version_id = p_task_version_id
2077: AND parent_structure_version_id = p_structure_version_id;
2078: l_dummy_char VARCHAR2(1);
2079: BEGIN

Line 2160: from pa_proj_element_versions

2156: p_task_version_id NUMBER)
2157: RETURN VARCHAR2 IS
2158: CURSOR c1 IS
2159: select '1'
2160: from pa_proj_element_versions
2161: where p_task_version_id = element_version_id
2162: and p_structure_version_id = parent_structure_version_id;
2163:
2164: l_dummy VARCHAR2(1);

Line 2212: -- pa_proj_element_versions pev

2208:
2209: -- CURSOR c1 IS
2210: -- select 1
2211: -- from pa_percent_completes ppc,
2212: -- pa_proj_element_versions pev
2213: -- where pev.element_version_id = p_element_version_id
2214: -- and pev.project_id = ppc.project_id
2215: -- and pev.proj_element_id = ppc.task_id
2216: -- and ppc.submitted_flag = 'Y'

Line 2240: pa_proj_element_versions ev

2236: IS
2237: CURSOR c1 IS
2238: select scheduled_start_date
2239: from pa_proj_elem_ver_schedule sch,
2240: pa_proj_element_versions ev
2241: where p_element_version_id = ev.element_version_id
2242: and ev.element_version_id = sch.element_version_id
2243: and ev.project_id = sch.project_id;
2244: l_date DATE;

Line 2266: pa_proj_element_versions ev

2262: IS
2263: CURSOR c1 IS
2264: select scheduled_finish_date
2265: from pa_proj_elem_ver_schedule sch,
2266: pa_proj_element_versions ev
2267: where p_element_version_id = ev.element_version_id
2268: and ev.element_version_id = sch.element_version_id
2269: and ev.project_id = sch.project_id;
2270: l_date DATE;

Line 2292: pa_proj_element_versions pev,

2288: IS
2289: CURSOR c1(c_project_id NUMBER, c_structure_version_id NUMBER) IS
2290: select sch.scheduled_start_date
2291: from pa_proj_elem_ver_schedule sch,
2292: pa_proj_element_versions pev,
2293: pa_proj_element_versions pev2
2294: where pev.project_id = c_project_id
2295: and pev.parent_structure_version_id = c_structure_version_id
2296: and pev.element_version_id = sch.element_version_id

Line 2293: pa_proj_element_versions pev2

2289: CURSOR c1(c_project_id NUMBER, c_structure_version_id NUMBER) IS
2290: select sch.scheduled_start_date
2291: from pa_proj_elem_ver_schedule sch,
2292: pa_proj_element_versions pev,
2293: pa_proj_element_versions pev2
2294: where pev.project_id = c_project_id
2295: and pev.parent_structure_version_id = c_structure_version_id
2296: and pev.element_version_id = sch.element_version_id
2297: and pev.project_id = sch.project_id

Line 2305: pa_proj_element_versions pev

2301:
2302: CURSOR c2 IS
2303: select str.project_id, str.element_version_id
2304: from pa_proj_elem_ver_structure str,
2305: pa_proj_element_versions pev
2306: where pev.element_version_id = p_parent_structure_version_id
2307: and pev.project_id = str.project_id
2308: and pev.proj_element_id = str.proj_element_id
2309: and str.LATEST_EFF_PUBLISHED_FLAG = 'Y';

Line 2338: pa_proj_element_versions pev,

2334: IS
2335: CURSOR c1(c_project_id NUMBER, c_structure_version_id NUMBER) IS
2336: select sch.scheduled_finish_date
2337: from pa_proj_elem_ver_schedule sch,
2338: pa_proj_element_versions pev,
2339: pa_proj_element_versions pev2
2340: where pev.project_id = c_project_id
2341: and pev.parent_structure_version_id = c_structure_version_id
2342: and pev.element_version_id = sch.element_version_id

Line 2339: pa_proj_element_versions pev2

2335: CURSOR c1(c_project_id NUMBER, c_structure_version_id NUMBER) IS
2336: select sch.scheduled_finish_date
2337: from pa_proj_elem_ver_schedule sch,
2338: pa_proj_element_versions pev,
2339: pa_proj_element_versions pev2
2340: where pev.project_id = c_project_id
2341: and pev.parent_structure_version_id = c_structure_version_id
2342: and pev.element_version_id = sch.element_version_id
2343: and pev.project_id = sch.project_id

Line 2351: pa_proj_element_versions pev

2347:
2348: CURSOR c2 IS
2349: select str.project_id, str.element_version_id
2350: from pa_proj_elem_ver_structure str,
2351: pa_proj_element_versions pev
2352: where pev.element_version_id = p_parent_structure_version_id
2353: and pev.project_id = str.project_id
2354: and pev.proj_element_id = str.proj_element_id
2355: and str.LATEST_EFF_PUBLISHED_FLAG = 'Y';

Line 2587: from pa_proj_element_versions ppev

2583: ) return NUMBER
2584: IS
2585: CURSOR c1(c_structure_version_id NUMBER) IS
2586: select ppev.element_version_id
2587: from pa_proj_element_versions ppev
2588: where parent_structure_version_id = c_structure_version_id
2589: and project_id = p_project_id
2590: and proj_element_id = p_task_id;
2591: l_structure_version_id NUMBER;

Line 2659: l_element_version_id pa_proj_element_versions.element_version_id%TYPE;

2655: p_task_id IN NUMBER
2656: ) RETURN NUMBER
2657: IS
2658:
2659: l_element_version_id pa_proj_element_versions.element_version_id%TYPE;
2660:
2661: CURSOR c1(p_task_id IN NUMBER) IS
2662: SELECT project_id
2663: FROM pa_tasks

Line 2670: FROM pa_proj_element_versions

2666: v_c1 c1%ROWTYPE;
2667:
2668: CURSOR c2 (p_proj_element_id IN NUMBER) IS
2669: SELECT element_version_id
2670: FROM pa_proj_element_versions
2671: WHERE proj_element_id = p_proj_element_id;
2672:
2673: v_c2 c2%ROWTYPE;
2674:

Line 2677: FROM pa_proj_element_versions

2673: v_c2 c2%ROWTYPE;
2674:
2675: CURSOR c3 (p_element_version_id IN NUMBER) IS
2676: SELECT display_sequence
2677: FROM pa_proj_element_versions
2678: WHERE element_version_id = p_element_version_id;
2679:
2680: v_c3 c3%ROWTYPE;
2681:

Line 2818: pa_proj_element_versions ppev

2814: CURSOR get_status IS
2815: select ppe.project_id, ppe.proj_element_id
2816: from pa_project_statuses pps,
2817: pa_proj_elements ppe,
2818: pa_proj_element_versions ppev
2819: where ppev.element_version_id = p_parent_task_ver_id
2820: and ppe.project_id = ppev.project_id
2821: and ppe.proj_element_id = ppev.proj_element_id
2822: and ppe.status_code = pps.project_status_code

Line 2830: from pa_proj_element_versions ppev

2826: l_proj_element_id NUMBER;
2827:
2828: CURSOR get_task_info IS
2829: select ppev.project_id, ppev.proj_element_id
2830: from pa_proj_element_versions ppev
2831: where ppev.element_version_id = p_parent_task_ver_id;
2832:
2833: CURSOR get_schedule_info IS
2834: select 1

Line 2836: pa_proj_element_versions ppev

2832:
2833: CURSOR get_schedule_info IS
2834: select 1
2835: from pa_proj_elem_ver_schedule ppvsch,
2836: pa_proj_element_versions ppev
2837: where ppev.element_version_id = p_parent_task_ver_id
2838: and ppev.project_id = ppvsch.project_id
2839: and ppev.proj_element_id = ppvsch.proj_element_id
2840: and ppev.element_version_id = ppvsch.element_version_id

Line 3073: pa_proj_element_versions ppev

3069: IS
3070: CURSOR l_exist_non_top_task_csr IS
3071: select 'N'
3072: from pa_proj_elements ppe,
3073: pa_proj_element_versions ppev
3074: where ppe.proj_element_id = p_proj_element_id
3075: and ppe.proj_element_id = ppev.proj_element_id
3076: and nvl(ppev.wbs_level, 0) <> 1;
3077:

Line 3156: pa_proj_element_versions b,

3152: IS
3153: CURSOR c1 is
3154: select 1 from
3155: pa_proj_elements a,
3156: pa_proj_element_versions b,
3157: pa_proj_elem_ver_structure c
3158: where a.proj_element_id = p_task_id
3159: and a.project_id = p_project_id
3160: and a.project_id = b.project_id

Line 3213: pa_proj_element_versions ppev

3209: CURSOR get_status IS
3210: select '1'
3211: from pa_project_statuses pps,
3212: pa_proj_elements ppe,
3213: pa_proj_element_versions ppev
3214: where ppev.element_version_id = p_task_ver_id
3215: and ppe.project_id = ppev.project_id
3216: and ppe.proj_element_id = ppev.proj_element_id
3217: and ppe.status_code = pps.project_status_code

Line 3270: from pa_proj_element_versions a,

3266: )
3267: IS
3268: CURSOR c1 IS
3269: select b.project_id, b.proj_element_id
3270: from pa_proj_element_versions a,
3271: pa_proj_elem_ver_structure b
3272: where a.element_version_id = p_task_version_id
3273: and a.parent_structure_version_id = b.element_version_id
3274: and a.project_id = b.project_id;

Line 3282: from pa_proj_element_versions ppe

3278: l_versioned VARCHAR2(1);
3279:
3280: CURSOR c2(c_project_id NUMBER, c_structure_id NUMBER) IS
3281: select distinct ppe.proj_element_id
3282: from pa_proj_element_versions ppe
3283: where ppe.element_version_id IN (
3284: select object_id_to1
3285: from pa_object_relationships
3286: where relationship_type = 'S'

Line 3289: from pa_proj_element_versions a,

3285: from pa_object_relationships
3286: where relationship_type = 'S'
3287: start with object_id_from1 IN (
3288: select a.element_version_id
3289: from pa_proj_element_versions a,
3290: pa_proj_elem_ver_structure b
3291: where b.project_id = c_project_id
3292: and b.proj_element_id = c_structure_id
3293: and b.status_code <> 'STRUCTURE_PUBLISHED'

Line 3302: from pa_proj_element_versions ppe

3298: and object_type_from = prior object_type_to
3299: and relationship_type = prior relationship_type)
3300: minus
3301: select ppe.proj_element_id
3302: from pa_proj_element_versions ppe
3303: where ppe.element_version_id IN (
3304: select object_id_to1
3305: from pa_object_relationships
3306: where relationship_type = 'S'

Line 3316: from pa_proj_element_Versions ppev,

3312: and relationship_type = prior relationship_type);
3313:
3314: CURSOR c3(c_project_id NUMBER, c_structure_id NUMBER, c_xtra_task_id NUMBER) IS
3315: select ppev.element_version_id, ppev.TASK_UNPUB_VER_STATUS_CODE
3316: from pa_proj_element_Versions ppev,
3317: pa_proj_elem_ver_structure ppevs
3318: where ppev.proj_element_id = c_xtra_task_id
3319: and ppev.project_id = c_project_id
3320: and ppev.parent_structure_version_id = ppevs.element_version_id

Line 3496: from pa_proj_element_versions

3492: l_element_version_Id NUMBER;
3493:
3494: cursor c_previous_task_id( c_project_id NUMBER, c_struct_version_id NUMBER, c_display_seq NUMBER) IS
3495: select element_version_id
3496: from pa_proj_element_versions
3497: where project_id = c_project_id
3498: and parent_structure_version_id = c_struct_version_id
3499: and display_sequence = (
3500: select max(display_sequence)

Line 3501: from pa_proj_element_versions

3497: where project_id = c_project_id
3498: and parent_structure_version_id = c_struct_version_id
3499: and display_sequence = (
3500: select max(display_sequence)
3501: from pa_proj_element_versions
3502: where project_id = c_project_id
3503: and parent_structure_version_id = c_struct_version_id
3504: and display_sequence < c_display_seq
3505: );

Line 3509: from pa_proj_element_versions

3505: );
3506:
3507: cursor c_next_task_id( c_project_id NUMBER, c_struct_version_id NUMBER, c_display_seq NUMBER) IS
3508: select element_version_id
3509: from pa_proj_element_versions
3510: where project_id = c_project_id
3511: and parent_structure_version_id = c_struct_version_id
3512: and display_sequence = (
3513: select min(display_sequence)

Line 3514: from pa_proj_element_versions

3510: where project_id = c_project_id
3511: and parent_structure_version_id = c_struct_version_id
3512: and display_sequence = (
3513: select min(display_sequence)
3514: from pa_proj_element_versions
3515: where project_id = c_project_id
3516: and parent_structure_version_id = c_struct_version_id
3517: and display_sequence > c_display_seq
3518: );

Line 3563: ,x_structure_version_id OUT NOCOPY pa_proj_element_versions.element_version_id%TYPE -- 4537865

3559: ,p_structure_type IN pa_structure_types.structure_type_class_code%TYPE
3560: ,p_structure_id IN pa_proj_elements.proj_element_id%TYPE
3561: ,p_is_wp_separate_from_fn IN VARCHAR2
3562: ,p_is_wp_versioning_enabled IN VARCHAR2
3563: ,x_structure_version_id OUT NOCOPY pa_proj_element_versions.element_version_id%TYPE -- 4537865
3564: ,x_task_unpub_ver_status_code OUT NOCOPY pa_proj_element_versions.task_unpub_ver_status_code%TYPE -- 4537865
3565: ,x_return_status OUT NOCOPY VARCHAR2 -- 4537865
3566: ,x_msg_count OUT NOCOPY NUMBER -- 4537865
3567: ,x_msg_data OUT NOCOPY VARCHAR2) -- 4537865

Line 3564: ,x_task_unpub_ver_status_code OUT NOCOPY pa_proj_element_versions.task_unpub_ver_status_code%TYPE -- 4537865

3560: ,p_structure_id IN pa_proj_elements.proj_element_id%TYPE
3561: ,p_is_wp_separate_from_fn IN VARCHAR2
3562: ,p_is_wp_versioning_enabled IN VARCHAR2
3563: ,x_structure_version_id OUT NOCOPY pa_proj_element_versions.element_version_id%TYPE -- 4537865
3564: ,x_task_unpub_ver_status_code OUT NOCOPY pa_proj_element_versions.task_unpub_ver_status_code%TYPE -- 4537865
3565: ,x_return_status OUT NOCOPY VARCHAR2 -- 4537865
3566: ,x_msg_count OUT NOCOPY NUMBER -- 4537865
3567: ,x_msg_data OUT NOCOPY VARCHAR2) -- 4537865
3568: AS

Line 3575: FROM pa_proj_element_versions c,

3571: -- Cursors used in this API.
3572: CURSOR cur_struc_ver_wp(c_project_id number,c_structure_type varchar2,c_status_code varchar2)
3573: IS
3574: SELECT c.element_version_id
3575: FROM pa_proj_element_versions c,
3576: pa_structure_types a,
3577: pa_proj_structure_types b
3578: ,pa_proj_elem_ver_structure d
3579: WHERE c.project_id = c_project_id

Line 3590: FROM pa_proj_element_versions c,

3586:
3587: CURSOR cur_struc_ver_fin(c_project_id number,c_structure_type varchar2)
3588: IS
3589: SELECT c.element_version_id
3590: FROM pa_proj_element_versions c,
3591: pa_structure_types a,
3592: pa_proj_structure_types b,
3593: pa_proj_elem_ver_structure d
3594: WHERE c.project_id = c_project_id

Line 3802: -- : PA_PROJ_ELEMENT_VERSIONS and pass to API PA_PROJ_ELEMENTS_UTILS.structure_type

3798: -- Purpose : This procedure will check whether the task has transaction or not.This API will be
3799: -- : called from Set_Financial_task_API.
3800: -- Note : Check whether it is a financial task or workplan task.
3801: -- : Fetch the parent_structure_version_id for the passed proj_element_Id from
3802: -- : PA_PROJ_ELEMENT_VERSIONS and pass to API PA_PROJ_ELEMENTS_UTILS.structure_type
3803:
3804: -- Assumptions : Only called for Financial task
3805:
3806: -- Parameters Type Required Description and Purpose

Line 3848: --FROM PA_PROJ_ELEMENT_VERSIONS

3844: --This cursor will select the parent structure version id for the passed proj_elem_id, here it is used for task
3845: --CURSOR c_get_parent_str_ver_id (task_id NUMBER)
3846: --IS
3847: --SELECT PARENT_STRUCTURE_VERSION_ID
3848: --FROM PA_PROJ_ELEMENT_VERSIONS
3849: --WHERE PROJ_ELEMENT_ID = task_id;
3850:
3851: --Bug 3735089
3852: l_user_id NUMBER;

Line 4269: from pa_object_relationships a, pa_proj_element_versions b

4265:
4266: /*
4267: intersect
4268: select a.object_id_to1
4269: from pa_object_relationships a, pa_proj_element_versions b
4270: where b.element_version_id = p_element_version_id
4271: and b.parent_structure_version_id = a.object_id_from1
4272: and a.relationship_type = 'S';
4273: */

Line 4290: select proj_element_id from pa_proj_element_versions

4286:
4287: function GET_TOP_TASK_ID(p_element_version_id IN number) return number
4288: is
4289: cursor C1 (evid number) is
4290: select proj_element_id from pa_proj_element_versions
4291: where element_version_id IN (
4292: /*select object_id_from1 --bug 4043647
4293: from pa_object_relationships
4294: where relationship_type='S'

Line 4315: from pa_object_relationships a, pa_proj_element_versions b

4311:
4312: /*
4313: intersect
4314: select a.object_id_to1
4315: from pa_object_relationships a, pa_proj_element_versions b
4316: where b.element_version_id = p_element_version_id
4317: and b.parent_structure_version_id = a.object_id_from1
4318: and a.relationship_type = 'S');
4319: */

Line 4363: select 1 from pa_proj_element_versions

4359:
4360: l_dummy NUMBER;
4361:
4362: CURSOR c3(evid NUMBER) IS
4363: select 1 from pa_proj_element_versions
4364: where element_version_id = evid
4365: and object_type = 'PA_STRUCTURES';
4366:
4367: begin

Line 4422: p_proj_element_id The ProjElementID PA_PROJ_ELEMENT_VERSIONS.PROJ_ELEMENT_ID%TYPE

4418:
4419: Parameters Description Type Of Parameter
4420: ========== =============== ===================
4421: p_project_id The Project ID PA_PROJECTS_ALL.PROJECT_ID%TYPE
4422: p_proj_element_id The ProjElementID PA_PROJ_ELEMENT_VERSIONS.PROJ_ELEMENT_ID%TYPE
4423:
4424: Return Value of this function :
4425: ===============================
4426: 'T' -> Top Task , 'M' -> Middle Task , 'L' -> Lowest Task , 'X' -> Not Financial Task

Line 4435: p_proj_element_id PA_PROJ_ELEMENT_VERSIONS.PROJ_ELEMENT_ID%TYPE) RETURN VARCHAR2

4431: In this case,There will not be any entry for those 'pure' workplan tasks in PA_TASKS table.
4432: Hence,for such passed Proj_element_id's this API will return 'X'
4433: */
4434: FUNCTION GET_TASK_LEVEL(p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4435: p_proj_element_id PA_PROJ_ELEMENT_VERSIONS.PROJ_ELEMENT_ID%TYPE) RETURN VARCHAR2
4436: IS
4437: l_task_level VARCHAR2(1) :='L';
4438:
4439: l_dummy NUMBER;

Line 4545: FROM pa_object_relationships, pa_proj_element_versions

4541: function GET_PARENT_TASK_ID(p_element_version_id IN number) return number
4542: is
4543: CURSOR c1 IS
4544: SELECT proj_element_id
4545: FROM pa_object_relationships, pa_proj_element_versions
4546: WHERE object_id_to1 = p_element_version_id
4547: AND object_type_from='PA_TASKS'
4548: AND object_id_from1 = element_version_id;
4549:

Line 4591: select b.element_version_id into l_task_version_id from pa_proj_elements a, pa_proj_element_versions b

4587: ,p_task_id IN NUMBER) return NUMBER
4588: is
4589: l_task_version_id NUMBER;
4590: begin
4591: select b.element_version_id into l_task_version_id from pa_proj_elements a, pa_proj_element_versions b
4592: where a.proj_element_id = b.proj_element_id
4593: and a.proj_element_id = p_task_id
4594: and b.parent_structure_version_id = p_structure_version_id;
4595:

Line 4627: FROM pa_proj_element_versions ppev,

4623: IS
4624: --
4625: CURSOR cur_check_deliv (cp_task_version_id number) IS
4626: SELECT ppe.proj_element_id,ppe.base_percent_comp_deriv_code
4627: FROM pa_proj_element_versions ppev,
4628: pa_proj_elements ppe
4629: WHERE ppe.project_id = ppev.project_id
4630: AND ppe.proj_element_id = ppev.proj_element_id
4631: AND ppev.object_type = 'PA_TASKS'

Line 4672: FROM pa_proj_element_versions ppev,

4668: RETURN VARCHAR2
4669: IS
4670: CURSOR cur_check_deliv_bt (cp_target_task_version_id number) IS
4671: SELECT ppe.proj_element_id,ppe.base_percent_comp_deriv_code, ppev.element_version_id
4672: FROM pa_proj_element_versions ppev,
4673: pa_proj_elements ppe
4674: WHERE ppe.project_id = ppev.project_id
4675: AND ppe.proj_element_id = ppev.proj_element_id
4676: AND ppev.object_type = 'PA_TASKS'

Line 4691: FROM pa_proj_element_versions ppev,

4687: AND PRIOR RELATIONSHIP_TYPE = RELATIONSHIP_TYPE);
4688:
4689: CURSOR cur_check_deliv_tb (cp_task_version_id number) IS
4690: SELECT ppe.proj_element_id,ppe.base_percent_comp_deriv_code, ppev.element_version_id
4691: FROM pa_proj_element_versions ppev,
4692: pa_proj_elements ppe
4693: WHERE ppe.project_id = ppev.project_id
4694: AND ppe.proj_element_id = ppev.proj_element_id
4695: AND ppev.object_type = 'PA_TASKS'

Line 4748: FROM pa_proj_element_versions ppev,

4744: IS
4745: /* This cursor get all the leaf nodes for a given structure*/
4746: CURSOR get_leaf_node_cur(cp_structure_elem_id NUMBER) IS
4747: SELECT object_id_to1
4748: FROM pa_proj_element_versions ppev,
4749: pa_object_relationships rel1
4750: WHERE ppev.parent_structure_version_id = cp_structure_elem_id --19671
4751: AND rel1.relationship_type = 'S'
4752: AND ppev.element_version_id = rel1.object_id_to1

Line 4761: FROM pa_proj_element_versions ppev,

4757:
4758: /* This cursor goes from leaf node to top of the branch*/
4759: CURSOR check_for_deliv_cur (cp_task_version_id number) IS
4760: SELECT ppe.proj_element_id,ppe.base_percent_comp_deriv_code
4761: FROM pa_proj_element_versions ppev,
4762: pa_proj_elements ppe
4763: WHERE ppe.project_id = ppev.project_id
4764: AND ppe.proj_element_id = ppev.proj_element_id
4765: AND ppev.object_type = 'PA_TASKS'

Line 4991: FROM pa_proj_element_versions ppev,

4987: RETURN NUMBER
4988: IS
4989: CURSOR cur_check_deliv_bt (cp_target_task_version_id number) IS
4990: SELECT ppe.proj_element_id,ppe.base_percent_comp_deriv_code, ppev.element_version_id
4991: FROM pa_proj_element_versions ppev,
4992: pa_proj_elements ppe
4993: WHERE ppe.project_id = ppev.project_id
4994: AND ppe.proj_element_id = ppev.proj_element_id
4995: AND ppev.object_type = 'PA_TASKS'

Line 5010: FROM pa_proj_element_versions ppev,

5006: AND PRIOR relationship_type = RELATIONSHIP_TYPE);
5007:
5008: CURSOR cur_check_deliv_tb (cp_task_version_id number) IS
5009: SELECT ppe.proj_element_id,ppe.base_percent_comp_deriv_code, ppev.element_version_id
5010: FROM pa_proj_element_versions ppev,
5011: pa_proj_elements ppe
5012: WHERE ppe.project_id = ppev.project_id
5013: AND ppe.proj_element_id = ppev.proj_element_id
5014: AND ppev.object_type = 'PA_TASKS'

Line 5107: from pa_proj_element_versions b

5103: IS
5104: l_task_id NUMBER;
5105: begin
5106: select b.proj_element_id into l_task_id
5107: from pa_proj_element_versions b
5108: where b.element_version_id = p_task_version_id
5109: and b.project_id = p_project_id
5110: and b.parent_structure_version_id = p_structure_version_id;
5111:

Line 5130: from pa_proj_element_versions ppev

5126: cursor cur_fin_task(c_project_id NUMBER
5127: , c_task_version_id NUMBER)
5128: is
5129: select ppev.financial_task_flag
5130: from pa_proj_element_versions ppev
5131: where ppev.project_id = c_project_id
5132: and ppev.element_version_id = c_task_version_id;
5133:
5134: l_financial_task_flag VARCHAR2(1) := null;

Line 5142: from pa_object_relationships por1, pa_proj_element_versions ppev1

5138: , c_include_sub_proj_flag VARCHAR2) -- Fix for Bug # 4290042.
5139: is
5140: -- This query checks if the task version has a financial sub-task.
5141: select 'N'
5142: from pa_object_relationships por1, pa_proj_element_versions ppev1
5143: where por1.object_id_to1 = ppev1.element_version_id
5144: and por1.relationship_type = 'S'
5145: and ppev1.project_id = c_project_id
5146: and por1.object_id_from1 = c_task_version_id

Line 5152: from pa_object_relationships por2, pa_proj_element_versions ppev2

5148: union all
5149: -- This query checks if the task version has a linking sub-task that has a financial link to
5150: -- a sub-project if the input p_include_sub_proj_flag = 'Y'.
5151: select 'N'
5152: from pa_object_relationships por2, pa_proj_element_versions ppev2
5153: where por2.object_id_to1 = ppev2.element_version_id
5154: and por2.relationship_type = 'S'
5155: and ppev2.project_id = c_project_id
5156: and por2.object_id_from1 = c_task_version_id

Line 5880: from pa_object_relationships por, pa_proj_element_versions ppev, pa_proj_elements ppe

5876: l_dummy number;
5877: cursor child_exist IS
5878: select 1 from dual where exists(
5879: select 1
5880: from pa_object_relationships por, pa_proj_element_versions ppev, pa_proj_elements ppe
5881: where por.object_type_from = 'PA_TASKS'
5882: and por.object_id_from1 = p_task_version_id
5883: and por.relationship_type = 'S'
5884: and por.object_id_to1 = ppev.element_version_id