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_TASKS

Line 167: IF (PA_SECURITY_PVT.check_user_privilege('PA_TASKS_UPDATE_DETAILS', 'PA_PROJECTS', p_project_id

163: , 'N') -- Fix for Bug # 4319137.
164: <> FND_API.G_TRUE) THEN
165: IF p_element_id is NOT NULL THEN
166: IF (l_is_task_manager_flag = 'Y') THEN --bug 4239490 replaced the is_task_manager api call with the variable.
167: IF (PA_SECURITY_PVT.check_user_privilege('PA_TASKS_UPDATE_DETAILS', 'PA_PROJECTS', p_project_id
168: , 'N') -- Fix for Bug # 4319137.
169: <> FND_API.G_TRUE) THEN
170: -- Bug 4533152
171: IF p_add_error_flag = 'Y' THEN

Line 228: AND ppev.object_type = 'PA_TASKS';

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';
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:

Line 659: where object_type_from = 'PA_TASKS'

655:
656: cursor child_exist IS
657: select 1
658: from pa_object_relationships
659: where object_type_from = 'PA_TASKS'
660: and object_id_from1 = p_task_version_id
661: and relationship_type = 'S';
662:
663: BEGIN

Line 689: -- p_object_type IN VARCHAR2 := 'PA_TASKS'

685: -- Parameters
686: -- p_element_name IN VARCHAR2
687: -- p_element_id IN NUMBER
688: -- p_project_id IN NUMBER
689: -- p_object_type IN VARCHAR2 := 'PA_TASKS'
690: --
691: -- History
692: --
693: -- 01-NOV-01 MAANSARI -Created

Line 703: ,p_object_type IN VARCHAR2 := 'PA_TASKS'

699: p_element_number IN VARCHAR2
700: ,p_element_id IN NUMBER
701: ,p_project_id IN NUMBER
702: ,p_structure_id IN NUMBER
703: ,p_object_type IN VARCHAR2 := 'PA_TASKS'
704: ) return VARCHAR2
705: IS
706: cursor c1 is
707: select 1 from pa_proj_elements

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 921: -- because CI, EGO Items and progress check will happen, even if entry is not there in pa_tasks.

917: --dbms_output.put_line( 'Before if 1 ');
918:
919: --hsiu: added for bug 2682805
920: -- Bug 3933576 : proj_element_id shd come from cur_wp_proj_elem_ver rather than cur_proj_elem_ver
921: -- because CI, EGO Items and progress check will happen, even if entry is not there in pa_tasks.
922:
923: -- OPEN cur_proj_elem_ver;
924: -- FETCH cur_proj_elem_ver INTO l_proj_element_id;
925: -- CLOSE cur_proj_elem_ver;

Line 1019: IF pa_progress_utils.progress_record_exists( p_task_version_id, 'PA_TASKS'

1015: x_error_message_code := 'PA_PS_TASK_HAS_PROG';
1016: raise FND_API.G_EXC_ERROR;
1017: END IF;
1018:
1019: IF pa_progress_utils.progress_record_exists( p_task_version_id, 'PA_TASKS'
1020: ,p_project_id) = 'Y' -- Fixed bug # 3688901.
1021: THEN
1022: x_return_status := FND_API.G_RET_STS_ERROR;
1023: x_error_message_code := 'PA_PS_CANT_DELETE_TASK_VER';

Line 1115: AND object_type = 'PA_TASKS';

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 )
1118: IS
1119: SELECT 'Y'

Line 1165: AND object_type_from = 'PA_TASKS'

1161: WHERE object_id_from1 = p_element_version_id
1162: --hsiu: bug 2800553: performance
1163: and rownum < 2
1164: --start with object_id_from1 = p_element_version_id
1165: AND object_type_from = 'PA_TASKS'
1166: AND relationship_type = 'S'
1167: And object_id_to1 NOT IN (
1168: select b.object_id_from1
1169: from pa_object_relationships a,

Line 1188: AND por.object_type_from ='PA_TASKS'

1184: FROM pa_object_relationships por,
1185: pa_proj_element_versions pev,
1186: pa_proj_elements pe
1187: WHERE por.object_id_from1 = p_element_version_id
1188: AND por.object_type_from ='PA_TASKS'
1189: AND por.relationship_type = 'S'
1190: AND por.object_id_to1=pev.element_version_id
1191: AND pe.proj_element_id=pev.proj_element_id
1192: AND (((NVL(pe.link_task_flag,'N') <> 'Y'))

Line 1212: AND por.object_type_from ='PA_TASKS'

1208: FROM pa_object_relationships por,
1209: pa_proj_element_versions pev,
1210: pa_proj_elements pe
1211: WHERE por.object_id_from1 = p_element_version_id
1212: AND por.object_type_from ='PA_TASKS'
1213: AND por.relationship_type = 'S'
1214: AND por.object_id_to1=pev.element_version_id
1215: AND pe.proj_element_id=pev.proj_element_id
1216: AND NVL(pe.link_task_flag,'N') <> 'Y'

Line 1470: AND pev.object_type = 'PA_TASKS'

1466: IS
1467: SELECT rel.object_id_from1 parent_task_id, pev.wbs_number
1468: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1469: WHERE pev.element_version_id = c_task_id
1470: AND pev.object_type = 'PA_TASKS'
1471: AND rel.object_id_to1 = pev.element_version_id
1472: AND rel.relationship_type = 'S'
1473: AND rel.object_type_from in ('PA_TASKS', 'PA_STRUCTURES');
1474:

Line 1473: AND rel.object_type_from in ('PA_TASKS', 'PA_STRUCTURES');

1469: WHERE pev.element_version_id = c_task_id
1470: AND pev.object_type = 'PA_TASKS'
1471: AND rel.object_id_to1 = pev.element_version_id
1472: AND rel.relationship_type = 'S'
1473: AND rel.object_type_from in ('PA_TASKS', 'PA_STRUCTURES');
1474:
1475: CURSOR UPDATE_MASKED_TASKS_CSR (c_parent_structure_ver_id NUMBER, c_display_seq NUMBER, c_mask VARCHAR2)
1476: IS
1477: SELECT element_version_id task_id, wbs_number, display_sequence

Line 1480: AND object_type = 'PA_TASKS'

1476: IS
1477: SELECT element_version_id task_id, wbs_number, display_sequence
1478: FROM PA_PROJ_ELEMENT_VERSIONS
1479: WHERE parent_structure_version_id = c_parent_structure_ver_id
1480: AND object_type = 'PA_TASKS'
1481: AND abs(display_sequence) >= abs(c_display_seq)
1482: AND display_sequence <> c_display_seq
1483: -- AND substr(wbs_number, 1, length(c_mask)) = c_mask Commented for bug 3581030
1484: AND substr(wbs_number, 1, length(c_mask)+1) = c_mask||'.' -- Added for bug 3581030

Line 1492: AND object_type = 'PA_TASKS'

1488: IS
1489: SELECT element_version_id task_id, wbs_number, display_sequence
1490: FROM PA_PROJ_ELEMENT_VERSIONS
1491: WHERE parent_structure_version_id = c_parent_structure_ver_id
1492: AND object_type = 'PA_TASKS'
1493: AND abs(display_sequence) >= abs(c_display_seq)
1494: AND display_sequence <> c_display_seq
1495: ORDER BY abs(display_sequence);
1496:

Line 1502: AND object_type = 'PA_TASKS'

1498: IS
1499: SELECT element_version_id task_id
1500: FROM PA_PROJ_ELEMENT_VERSIONS
1501: WHERE parent_structure_version_id = c_parent_structure_ver_id
1502: AND object_type = 'PA_TASKS'
1503: AND display_sequence = c_display_seq;
1504:
1505: CURSOR GET_PREV_PEER_TASK_CSR(c_parent_structure_ver_id NUMBER, c_parent_task_id NUMBER, c_display_seq NUMBER)
1506: IS

Line 1510: AND object_type = 'PA_TASKS'

1506: IS
1507: SELECT element_version_id task_id
1508: FROM PA_PROJ_ELEMENT_VERSIONS
1509: WHERE parent_structure_version_id = c_parent_structure_ver_id
1510: AND object_type = 'PA_TASKS'
1511: AND display_sequence =
1512: (SELECT max(pev.display_sequence)
1513: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1514: WHERE rel.object_type_from = 'PA_TASKS'

Line 1514: WHERE rel.object_type_from = 'PA_TASKS'

1510: AND object_type = 'PA_TASKS'
1511: AND display_sequence =
1512: (SELECT max(pev.display_sequence)
1513: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1514: WHERE rel.object_type_from = 'PA_TASKS'
1515: AND rel.object_id_from1 = c_parent_task_id
1516: AND rel.relationship_type = 'S'
1517: AND rel.object_type_to = 'PA_TASKS'
1518: AND rel.object_id_to1 = pev.element_version_id

Line 1517: AND rel.object_type_to = 'PA_TASKS'

1513: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1514: WHERE rel.object_type_from = 'PA_TASKS'
1515: AND rel.object_id_from1 = c_parent_task_id
1516: AND rel.relationship_type = 'S'
1517: AND rel.object_type_to = 'PA_TASKS'
1518: AND rel.object_id_to1 = pev.element_version_id
1519: AND pev.parent_structure_version_id = c_parent_structure_ver_id
1520: AND pev.display_sequence < c_display_seq);
1521:

Line 1539: AND object_type = 'PA_TASKS'

1535: IS
1536: SELECT element_version_id task_id
1537: FROM PA_PROJ_ELEMENT_VERSIONS
1538: WHERE parent_structure_version_id = c_parent_structure_ver_id
1539: AND object_type = 'PA_TASKS'
1540: AND display_sequence =
1541: (SELECT max(pev.display_sequence)
1542: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1543: WHERE rel.object_type_from = 'PA_STRUCTURES'

Line 1546: AND rel.object_type_to = 'PA_TASKS'

1542: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1543: WHERE rel.object_type_from = 'PA_STRUCTURES'
1544: AND rel.object_id_from1 = c_parent_structure_ver_id
1545: AND rel.relationship_type = 'S'
1546: AND rel.object_type_to = 'PA_TASKS'
1547: AND rel.object_id_to1 = pev.element_version_id
1548: AND pev.parent_structure_version_id = c_parent_structure_ver_id
1549: AND display_sequence < c_display_seq);
1550:

Line 1603: AND pev.object_type = 'PA_TASKS'

1599: SELECT /*+ LEADING (rel) */ count(pev.element_version_id)
1600: INTO l_count
1601: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1602: WHERE pev.parent_structure_version_id = p_parent_structure_ver_id
1603: AND pev.object_type = 'PA_TASKS'
1604: AND abs(pev.display_sequence) <= abs(p_display_seq)
1605: AND rel.object_id_to1 = pev.element_version_id
1606: AND rel.relationship_type = 'S'
1607: AND rel.object_type_from = 'PA_STRUCTURES'

Line 1609: AND rel.object_type_to = 'PA_TASKS'; --Added for Bug 6430953

1605: AND rel.object_id_to1 = pev.element_version_id
1606: AND rel.relationship_type = 'S'
1607: AND rel.object_type_from = 'PA_STRUCTURES'
1608: AND rel.object_id_from1 = p_parent_structure_ver_id
1609: AND rel.object_type_to = 'PA_TASKS'; --Added for Bug 6430953
1610:
1611: l_wbs_number := l_count;
1612: l_mask := 'NONE';
1613: else

Line 1684: AND pev.object_type = 'PA_TASKS'

1680: begin
1681: SELECT rel.object_id_from1 INTO l_parent_task_id
1682: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1683: WHERE pev.element_version_id = p_task_version_id
1684: AND pev.object_type = 'PA_TASKS'
1685: AND rel.object_id_to1 = pev.element_version_id
1686: AND rel.relationship_type = 'S'
1687: AND rel.object_type_from in ('PA_TASKS', 'PA_STRUCTURES');
1688:

Line 1687: AND rel.object_type_from in ('PA_TASKS', 'PA_STRUCTURES');

1683: WHERE pev.element_version_id = p_task_version_id
1684: AND pev.object_type = 'PA_TASKS'
1685: AND rel.object_id_to1 = pev.element_version_id
1686: AND rel.relationship_type = 'S'
1687: AND rel.object_type_from in ('PA_TASKS', 'PA_STRUCTURES');
1688:
1689: SELECT rel.object_id_from1 INTO l_ref_parent_task_id
1690: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1691: WHERE pev.element_version_id = p_ref_task_version_id

Line 1692: AND pev.object_type = 'PA_TASKS'

1688:
1689: SELECT rel.object_id_from1 INTO l_ref_parent_task_id
1690: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
1691: WHERE pev.element_version_id = p_ref_task_version_id
1692: AND pev.object_type = 'PA_TASKS'
1693: AND rel.object_id_to1 = pev.element_version_id
1694: AND rel.relationship_type = 'S'
1695: AND rel.object_type_from in ('PA_TASKS', 'PA_STRUCTURES');
1696: EXCEPTION

Line 1695: AND rel.object_type_from in ('PA_TASKS', 'PA_STRUCTURES');

1691: WHERE pev.element_version_id = p_ref_task_version_id
1692: AND pev.object_type = 'PA_TASKS'
1693: AND rel.object_id_to1 = pev.element_version_id
1694: AND rel.relationship_type = 'S'
1695: AND rel.object_type_from in ('PA_TASKS', 'PA_STRUCTURES');
1696: EXCEPTION
1697: WHEN OTHERS then
1698: l_parent_task_id := null;
1699: l_ref_parent_task_id := null;

Line 2475: FROM PA_TASKS

2471: RETURN VARCHAR2
2472: IS
2473: cursor c1 IS
2474: SELECT 1
2475: FROM PA_TASKS
2476: WHERE task_id = p_proj_element_id;
2477: l_dummy NUMBER;
2478: BEGIN
2479: OPEN c1;

Line 2645: AND object_type = 'PA_TASKS'

2641: select 'xyz'
2642: from PA_PROJ_ELEMENTS
2643: where type_id = p_task_type_id
2644: AND project_id > -1
2645: AND object_type = 'PA_TASKS'
2646: );
2647:
2648: l_ret_val VARCHAR2(1);
2649: BEGIN

Line 2756: FROM pa_tasks

2752: l_element_version_id pa_proj_element_versions.element_version_id%TYPE;
2753:
2754: CURSOR c1(p_task_id IN NUMBER) IS
2755: SELECT project_id
2756: FROM pa_tasks
2757: WHERE task_id = p_task_id;
2758:
2759: v_c1 c1%ROWTYPE;
2760:

Line 2815: where object_type_to = 'PA_TASKS'

2811: IS
2812: CURSOR c1 IS
2813: select object_Id_to1
2814: from pa_object_relationships
2815: where object_type_to = 'PA_TASKS'
2816: and relationship_type = 'S'
2817: start with object_id_from1 = p_task_version_id
2818: and object_type_from = 'PA_TASKS'
2819: and relationship_type = 'S'

Line 2818: and object_type_from = 'PA_TASKS'

2814: from pa_object_relationships
2815: where object_type_to = 'PA_TASKS'
2816: and relationship_type = 'S'
2817: start with object_id_from1 = p_task_version_id
2818: and object_type_from = 'PA_TASKS'
2819: and relationship_type = 'S'
2820: connect by prior object_id_to1 = object_id_from1
2821: and prior object_type_to = object_type_from
2822: and relationship_type = prior relationship_type; --Bug 3792616

Line 3046: ,p_object_type => 'PA_TASKS'

3042: AND PA_PROGRESS_UTILS.check_object_has_prog(
3043: p_project_id => l_project_id
3044: ,p_proj_element_id => l_proj_element_id
3045: ,p_object_id => l_proj_element_id
3046: ,p_object_type => 'PA_TASKS'
3047: ,p_structure_type => 'WORKPLAN'
3048: ) = 'Y'
3049: AND PA_PROGRESS_UTILS.check_ta_has_prog(
3050: p_project_id => l_project_id

Line 3261: pa_tasks a

3257: and c.status_code = 'STRUCTURE_PUBLISHED';
3258:
3259: CURSOR c2 IS
3260: select 1 from
3261: pa_tasks a
3262: where a.task_id = p_task_id;
3263:
3264: l_dummy NUMBER;
3265:

Line 3401: and object_type_from = 'PA_TASKS'

3397: select object_id_to1
3398: from pa_object_relationships
3399: where relationship_type = 'S'
3400: start with object_id_from1 = p_task_version_id
3401: and object_type_from = 'PA_TASKS'
3402: and relationship_type = 'S'
3403: connect by object_id_from1 = prior object_id_to1
3404: and object_type_from = prior object_type_to
3405: and relationship_type = prior relationship_type);

Line 4339: and object_type_from='PA_TASKS'

4335: /*cursor C1 is
4336: select object_id_from1
4337: from pa_object_relationships
4338: where relationship_type='S'
4339: and object_type_from='PA_TASKS'
4340: connect by prior object_id_from1 = object_id_to1
4341: and prior relationship_type = relationship_type
4342: start with object_id_to1 = p_element_version_id
4343: and relationship_type = 'S'

Line 4352: and object_type_to='PA_TASKS'

4348: select object_id_to1
4349: from pa_object_relationships
4350: where relationship_type='S'
4351: and object_type_from='PA_STRUCTURES'
4352: and object_type_to='PA_TASKS'
4353: connect by prior object_id_from1 = object_id_to1
4354: start with object_id_to1 = p_element_version_id
4355: and relationship_type = 'S';
4356:

Line 4388: and object_type_from='PA_TASKS'

4384: where element_version_id IN (
4385: /*select object_id_from1 --bug 4043647
4386: from pa_object_relationships
4387: where relationship_type='S'
4388: and object_type_from='PA_TASKS'
4389: connect by prior object_id_from1 = object_id_to1
4390: and prior relationship_type = relationship_type
4391: start with object_id_to1 = p_element_version_id
4392: and relationship_type = 'S'

Line 4399: and object_type_to='PA_TASKS'

4395: select object_id_to1
4396: from pa_object_relationships
4397: where relationship_type='S'
4398: and object_type_from='PA_STRUCTURES'
4399: and object_type_to='PA_TASKS'
4400: connect by prior object_id_from1 = object_id_to1
4401: start with object_id_to1 = p_element_version_id
4402: and relationship_type = 'S');
4403:

Line 4524: In this case,There will not be any entry for those 'pure' workplan tasks in PA_TASKS table.

4520:
4521: Note that it is very much possible that (say) the case of Partially Shared Structures,
4522: Some of the tasks may be both workplan and financial tasks,whereas some tasks are only workplan tasks.
4523:
4524: In this case,There will not be any entry for those 'pure' workplan tasks in PA_TASKS table.
4525: Hence,for such passed Proj_element_id's this API will return 'X'
4526: */
4527: FUNCTION GET_TASK_LEVEL(p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4528: p_proj_element_id PA_PROJ_ELEMENT_VERSIONS.PROJ_ELEMENT_ID%TYPE) RETURN VARCHAR2

Line 4539: from pa_tasks

4535:
4536: CURSOR c_task_exists
4537: IS
4538: select 1
4539: from pa_tasks
4540: where task_id = p_proj_element_id
4541: and project_id = p_project_id
4542: ;
4543:

Line 4550: from pa_tasks

4546: select 1
4547: from dual
4548: where exists
4549: (select 1
4550: from pa_tasks
4551: where nvl(parent_task_id,-9999) = p_proj_element_id
4552: and project_id = p_project_id
4553: ) ;
4554:

Line 4557: select 1 from pa_tasks

4553: ) ;
4554:
4555: CURSOR c_is_mid_task
4556: IS
4557: select 1 from pa_tasks
4558: where parent_task_id is not null
4559: and task_id = p_proj_element_id ;
4560:
4561: BEGIN

Line 4569: return 'X' ; -- as the task doesnt exist in PA_TASKS table

4565: CLOSE c_task_exists;
4566:
4567: IF nvl(l_dummy,0) = 0
4568: THEN
4569: return 'X' ; -- as the task doesnt exist in PA_TASKS table
4570: END IF;
4571:
4572: --At this point the task exists
4573:

Line 4640: AND object_type_from='PA_TASKS'

4636: CURSOR c1 IS
4637: SELECT proj_element_id
4638: FROM pa_object_relationships, pa_proj_element_versions
4639: WHERE object_id_to1 = p_element_version_id
4640: AND object_type_from='PA_TASKS'
4641: AND object_id_from1 = element_version_id
4642: AND relationship_type = 'S'; -- added for bug 16170622 to eliminate 'D' dependency records
4643:
4644: l_parent_task_id NUMBER := NULL;

Line 4666: AND object_type_from='PA_TASKS'

4662: CURSOR c1 IS
4663: SELECT object_id_from1
4664: FROM pa_object_relationships
4665: WHERE object_id_to1 = p_element_version_id
4666: AND object_type_from='PA_TASKS'
4667: AND relationship_type = 'S';
4668:
4669: begin
4670: OPEN c1;

Line 4725: AND ppev.object_type = 'PA_TASKS'

4721: FROM pa_proj_element_versions ppev,
4722: pa_proj_elements ppe
4723: WHERE ppe.project_id = ppev.project_id
4724: AND ppe.proj_element_id = ppev.proj_element_id
4725: AND ppev.object_type = 'PA_TASKS'
4726: AND ppe.object_type = 'PA_TASKS'
4727: AND ppev.element_version_id IN (
4728: SELECT object_id_to1
4729: FROM pa_object_relationships

Line 4726: AND ppe.object_type = 'PA_TASKS'

4722: pa_proj_elements ppe
4723: WHERE ppe.project_id = ppev.project_id
4724: AND ppe.proj_element_id = ppev.proj_element_id
4725: AND ppev.object_type = 'PA_TASKS'
4726: AND ppe.object_type = 'PA_TASKS'
4727: AND ppev.element_version_id IN (
4728: SELECT object_id_to1
4729: FROM pa_object_relationships
4730: WHERE relationship_type = 'S'

Line 4732: AND object_type_to = 'PA_TASKS'

4728: SELECT object_id_to1
4729: FROM pa_object_relationships
4730: WHERE relationship_type = 'S'
4731: START WITH object_id_to1 = cp_task_version_id --24628
4732: AND object_type_to = 'PA_TASKS'
4733: and relationship_type = 'S'
4734: CONNECT BY PRIOR object_id_from1 = object_id_to1
4735: AND PRIOR object_type_from = object_type_to
4736: AND PRIOR relationship_type = relationship_type);

Line 4770: AND ppev.object_type = 'PA_TASKS'

4766: FROM pa_proj_element_versions ppev,
4767: pa_proj_elements ppe
4768: WHERE ppe.project_id = ppev.project_id
4769: AND ppe.proj_element_id = ppev.proj_element_id
4770: AND ppev.object_type = 'PA_TASKS'
4771: AND ppe.object_type = 'PA_TASKS'
4772: AND ppev.element_version_id IN (
4773: SELECT object_id_to1
4774: FROM pa_object_relationships

Line 4771: AND ppe.object_type = 'PA_TASKS'

4767: pa_proj_elements ppe
4768: WHERE ppe.project_id = ppev.project_id
4769: AND ppe.proj_element_id = ppev.proj_element_id
4770: AND ppev.object_type = 'PA_TASKS'
4771: AND ppe.object_type = 'PA_TASKS'
4772: AND ppev.element_version_id IN (
4773: SELECT object_id_to1
4774: FROM pa_object_relationships
4775: WHERE relationship_type = 'S'

Line 4777: AND object_type_to = 'PA_TASKS'

4773: SELECT object_id_to1
4774: FROM pa_object_relationships
4775: WHERE relationship_type = 'S'
4776: START WITH object_id_to1 = cp_target_task_version_id
4777: AND object_type_to = 'PA_TASKS'
4778: and relationship_type = 'S'
4779: CONNECT BY PRIOR object_id_from1 = object_id_to1
4780: AND PRIOR object_type_from = object_type_to
4781: AND PRIOR RELATIONSHIP_TYPE = RELATIONSHIP_TYPE);

Line 4789: AND ppev.object_type = 'PA_TASKS'

4785: FROM pa_proj_element_versions ppev,
4786: pa_proj_elements ppe
4787: WHERE ppe.project_id = ppev.project_id
4788: AND ppe.proj_element_id = ppev.proj_element_id
4789: AND ppev.object_type = 'PA_TASKS'
4790: AND ppe.object_type = 'PA_TASKS'
4791: AND ppev.element_version_id IN (
4792: SELECT object_id_to1
4793: FROM pa_object_relationships

Line 4790: AND ppe.object_type = 'PA_TASKS'

4786: pa_proj_elements ppe
4787: WHERE ppe.project_id = ppev.project_id
4788: AND ppe.proj_element_id = ppev.proj_element_id
4789: AND ppev.object_type = 'PA_TASKS'
4790: AND ppe.object_type = 'PA_TASKS'
4791: AND ppev.element_version_id IN (
4792: SELECT object_id_to1
4793: FROM pa_object_relationships
4794: WHERE relationship_type = 'S'

Line 4796: AND object_type_to = 'PA_TASKS'

4792: SELECT object_id_to1
4793: FROM pa_object_relationships
4794: WHERE relationship_type = 'S'
4795: START WITH object_id_to1 = cp_task_version_id
4796: AND object_type_to = 'PA_TASKS'
4797: and relationship_type = 'S'
4798: CONNECT BY object_id_from1 = prior object_id_to1
4799: AND object_type_from = prior object_type_to
4800: AND PRIOR RELATIONSHIP_TYPE = RELATIONSHIP_TYPE);

Line 4859: AND ppev.object_type = 'PA_TASKS'

4855: FROM pa_proj_element_versions ppev,
4856: pa_proj_elements ppe
4857: WHERE ppe.project_id = ppev.project_id
4858: AND ppe.proj_element_id = ppev.proj_element_id
4859: AND ppev.object_type = 'PA_TASKS'
4860: AND ppe.object_type = 'PA_TASKS'
4861: AND ppev.element_version_id IN (
4862: SELECT object_id_to1
4863: FROM pa_object_relationships

Line 4860: AND ppe.object_type = 'PA_TASKS'

4856: pa_proj_elements ppe
4857: WHERE ppe.project_id = ppev.project_id
4858: AND ppe.proj_element_id = ppev.proj_element_id
4859: AND ppev.object_type = 'PA_TASKS'
4860: AND ppe.object_type = 'PA_TASKS'
4861: AND ppev.element_version_id IN (
4862: SELECT object_id_to1
4863: FROM pa_object_relationships
4864: WHERE relationship_type = 'S'

Line 4866: AND object_type_to = 'PA_TASKS'

4862: SELECT object_id_to1
4863: FROM pa_object_relationships
4864: WHERE relationship_type = 'S'
4865: START WITH object_id_to1 = cp_task_version_id --24628
4866: AND object_type_to = 'PA_TASKS'
4867: and relationship_type = 'S'
4868: CONNECT BY PRIOR object_id_from1 = object_id_to1
4869: AND PRIOR object_type_from = object_type_to
4870: AND PRIOR RELATIONSHIP_TYPE = RELATIONSHIP_TYPE);

Line 5066: AND object_type_to='PA_TASKS'

5062: CURSOR c1 IS
5063: SELECT object_id_to1
5064: FROM pa_object_relationships
5065: WHERE object_id_from1 = p_task_version_id
5066: AND object_type_to='PA_TASKS'
5067: AND relationship_type = 'S';
5068: --
5069: begin
5070: OPEN c1;

Line 5089: AND ppev.object_type = 'PA_TASKS'

5085: FROM pa_proj_element_versions ppev,
5086: pa_proj_elements ppe
5087: WHERE ppe.project_id = ppev.project_id
5088: AND ppe.proj_element_id = ppev.proj_element_id
5089: AND ppev.object_type = 'PA_TASKS'
5090: AND ppe.object_type = 'PA_TASKS'
5091: AND ppev.element_version_id IN (
5092: SELECT object_id_to1
5093: FROM pa_object_relationships

Line 5090: AND ppe.object_type = 'PA_TASKS'

5086: pa_proj_elements ppe
5087: WHERE ppe.project_id = ppev.project_id
5088: AND ppe.proj_element_id = ppev.proj_element_id
5089: AND ppev.object_type = 'PA_TASKS'
5090: AND ppe.object_type = 'PA_TASKS'
5091: AND ppev.element_version_id IN (
5092: SELECT object_id_to1
5093: FROM pa_object_relationships
5094: WHERE relationship_type = 'S'

Line 5096: AND object_type_to = 'PA_TASKS'

5092: SELECT object_id_to1
5093: FROM pa_object_relationships
5094: WHERE relationship_type = 'S'
5095: START WITH object_id_to1 = cp_target_task_version_id
5096: AND object_type_to = 'PA_TASKS'
5097: and relationship_type = 'S'
5098: CONNECT BY PRIOR object_id_from1 = object_id_to1
5099: AND PRIOR object_type_from = object_type_to
5100: AND PRIOR relationship_type = RELATIONSHIP_TYPE);

Line 5108: AND ppev.object_type = 'PA_TASKS'

5104: FROM pa_proj_element_versions ppev,
5105: pa_proj_elements ppe
5106: WHERE ppe.project_id = ppev.project_id
5107: AND ppe.proj_element_id = ppev.proj_element_id
5108: AND ppev.object_type = 'PA_TASKS'
5109: AND ppe.object_type = 'PA_TASKS'
5110: AND ppev.element_version_id IN (
5111: SELECT object_id_to1
5112: FROM pa_object_relationships

Line 5109: AND ppe.object_type = 'PA_TASKS'

5105: pa_proj_elements ppe
5106: WHERE ppe.project_id = ppev.project_id
5107: AND ppe.proj_element_id = ppev.proj_element_id
5108: AND ppev.object_type = 'PA_TASKS'
5109: AND ppe.object_type = 'PA_TASKS'
5110: AND ppev.element_version_id IN (
5111: SELECT object_id_to1
5112: FROM pa_object_relationships
5113: WHERE relationship_type = 'S'

Line 5115: AND object_type_to = 'PA_TASKS'

5111: SELECT object_id_to1
5112: FROM pa_object_relationships
5113: WHERE relationship_type = 'S'
5114: START WITH object_id_to1 = cp_task_version_id
5115: AND object_type_to = 'PA_TASKS'
5116: and relationship_type = 'S'
5117: CONNECT BY object_id_from1 = prior object_id_to1
5118: AND object_type_from = prior object_type_to
5119: AND PRIOR relationship_type = RELATIONSHIP_TYPE);

Line 5405: FROM PA_TASKS

5401:
5402:
5403: /*CURSOR c_tasks_in_hierarchy IS --Commented the following cursor as this is not needed after perf bug fix Bug#4964992
5404: SELECT TASK_ID
5405: FROM PA_TASKS
5406: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
5407: AND PROJECT_ID = p_project_id
5408: START WITH TASK_ID = p_TASK_ID
5409: AND PROJECT_ID = p_project_id; */

Line 6004: -- This is known to cause FTS on pa_tasks . But,this cant be avoided.

6000: -- passed task_id.
6001:
6002: -- Note that START WITH - CONNECT BY CLAUSE cant be avoided as we want the task passed and all its children
6003: -- in the hierarchy
6004: -- This is known to cause FTS on pa_tasks . But,this cant be avoided.
6005:
6006: -- (ie) if the hierarchy is :
6007: -- 1
6008: -- 11

Line 6037: pa_tasks

6033: CURSOR task_hierarchy IS
6034: SELECT
6035: task_rec(task_name,task_id)
6036: FROM
6037: pa_tasks
6038: CONNECT BY PRIOR
6039: task_id = parent_task_id AND
6040: project_id = p_project_id
6041: START WITH

Line 6095: pa_tasks

6091: task_rec(null,alt_task_id)
6092: FROM
6093: pa_alternate_tasks where
6094: proj_element_id in (select task_id from
6095: pa_tasks
6096: CONNECT BY PRIOR
6097: task_id = parent_task_id AND
6098: project_id = p_project_id
6099: START WITH

Line 6143: where por.object_type_from = 'PA_TASKS'

6139: cursor child_exist IS
6140: select 1 from dual where exists(
6141: select 1
6142: from pa_object_relationships por, pa_proj_element_versions ppev, pa_proj_elements ppe
6143: where por.object_type_from = 'PA_TASKS'
6144: and por.object_id_from1 = p_task_version_id
6145: and por.relationship_type = 'S'
6146: and por.object_id_to1 = ppev.element_version_id
6147: and ppe.PROJ_ELEMENT_ID = ppev.PROJ_ELEMENT_ID