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_TASKS

Line 470: and r.object_type_from IN ('PA_TASKS','PA_STRUCTURES')

466: from pa_object_relationships r,
467: pa_proj_element_versions v1,
468: pa_proj_element_versions v2
469: where r.relationship_type = 'L'
470: and r.object_type_from IN ('PA_TASKS','PA_STRUCTURES')
471: and r.object_id_from1 = v2.element_version_id
472: and r.object_id_to1 = v1.element_version_id
473: and v2.parent_structure_version_id = p_structure_version_id;
474:

Line 1305: and b.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

1301: pa_object_relationships b,
1302: pa_proj_element_versions c
1303: where relationship_type IN ('S', 'L')
1304: and b.object_id_from1 = p_element_version_id
1305: and b.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
1306: and b.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
1307: and b.object_id_to1 = c.element_version_id
1308: and c.project_id = a.project_id
1309: and c.element_version_id = a.element_version_id;

Line 1306: and b.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')

1302: pa_proj_element_versions c
1303: where relationship_type IN ('S', 'L')
1304: and b.object_id_from1 = p_element_version_id
1305: and b.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
1306: and b.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
1307: and b.object_id_to1 = c.element_version_id
1308: and c.project_id = a.project_id
1309: and c.element_version_id = a.element_version_id;
1310:

Line 1318: and b.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

1314: pa_object_relationships b,
1315: pa_proj_element_versions c
1316: where relationship_type IN ('S', 'L')
1317: and b.object_id_from1 = p_element_version_id
1318: and b.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
1319: and b.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
1320: and b.object_id_to1 = c.element_version_id
1321: and c.project_id = a.project_id
1322: and c.element_version_id = a.element_version_id;

Line 1319: and b.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')

1315: pa_proj_element_versions c
1316: where relationship_type IN ('S', 'L')
1317: and b.object_id_from1 = p_element_version_id
1318: and b.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
1319: and b.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
1320: and b.object_id_to1 = c.element_version_id
1321: and c.project_id = a.project_id
1322: and c.element_version_id = a.element_version_id;
1323:

Line 1330: and a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

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')
1332: and a.object_id_to1 = c.element_version_id
1333: and c.proj_element_id = b.proj_element_id
1334: and c.project_id = b.project_id

Line 1331: and a.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')

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')
1332: and a.object_id_to1 = c.element_version_id
1333: and c.proj_element_id = b.proj_element_id
1334: and c.project_id = b.project_id
1335: and b.link_task_flag = 'Y';

Line 1347: and b.object_type_to = 'PA_TASKS'

1343: pa_proj_element_versions c
1344: where a.element_version_id = c.element_version_id
1345: and a.project_id = c.project_id
1346: and c.element_version_id = b.object_id_to1
1347: and b.object_type_to = 'PA_TASKS'
1348: and b.object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')
1349: and b.relationship_type = 'S'
1350: and b.object_id_from1 = p_element_version_id;
1351: --end bug 3074706

Line 1348: and b.object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')

1344: where a.element_version_id = c.element_version_id
1345: and a.project_id = c.project_id
1346: and c.element_version_id = b.object_id_to1
1347: and b.object_type_to = 'PA_TASKS'
1348: and b.object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')
1349: and b.relationship_type = 'S'
1350: and b.object_id_from1 = p_element_version_id;
1351: --end bug 3074706
1352:

Line 1972: and object_type = 'PA_TASKS'

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
1975: from pa_proj_element_versions ppev1,
1976: pa_proj_element_versions ppev2

Line 1989: and ppev1.object_type = 'PA_TASKS'

1985: pa_proj_element_versions ppev2
1986: where ppev2.object_type = 'PA_STRUCTURES'
1987: and ppev2.project_id = p_project_id
1988: and ppev2.proj_element_id = l_structure_id
1989: and ppev1.object_type = 'PA_TASKS'
1990: and ppev1.parent_structure_version_id = ppev2.element_version_id;
1991:
1992: l_task_id NUMBER;
1993:

Line 2065: and object_type = 'PA_TASKS'

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
2068: from PA_TASKS
2069: where project_id = p_project_id);

Line 2068: from PA_TASKS

2064: where project_id = p_project_id
2065: and object_type = 'PA_TASKS'
2066: and proj_element_id NOT IN (
2067: select task_id
2068: from PA_TASKS
2069: where project_id = p_project_id);
2070: l_task_id NUMBER;
2071:
2072: CURSOR get_wp_id IS

Line 2146: and object_type = 'PA_TASKS';

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
2149: --check if progress exists for current structure
2150: IF (check_proj_progress_exist(p_project_id, 0) = 'Y') THEN

Line 2247: -- Bug 3933576 : Call pa_proj_tsk_utils.get_task_project_id gives the project_id from pa_tasks

2243: BEGIN
2244: --get API from Saima
2245:
2246: -- Progress Management Changes. Bug # 3420093.
2247: -- Bug 3933576 : Call pa_proj_tsk_utils.get_task_project_id gives the project_id from pa_tasks
2248: -- It is wrong..
2249: --l_project_id := pa_proj_tsk_utils.get_task_project_id(p_task_id);
2250: OPEN c_get_project_id;
2251: FETCH c_get_project_id INTO l_project_id;

Line 2423: from pa_tasks a,

2419: avoid Hash Join*/
2420:
2421: /* CURSOR c1 is
2422: select 1
2423: from pa_tasks a,
2424: pa_percent_completes b
2425: where b.project_id = a.project_id
2426: and b.task_id = a.task_id
2427: and a.project_id = p_project_id;

Line 2435: from pa_tasks a,

2431: select 1
2432: from dual
2433: where exists
2434: ( select 1
2435: from pa_tasks a,
2436: pa_percent_completes b
2437: where b.project_id = a.project_id
2438: and b.task_id = a.task_id
2439: and a.project_id = p_project_id

Line 2708: IF (p_object_type = 'PA_TASKS') THEN

2704: l_structure_id NUMBER;
2705: l_ret VARCHAR2(30);
2706: BEGIN
2707: --Find structure
2708: IF (p_object_type = 'PA_TASKS') THEN
2709: OPEN get_parent_structure;
2710: FETCH get_parent_structure into l_structure_id;
2711: CLOSE get_parent_structure;
2712: ELSE --'PA_STRUCTURES'

Line 2836: and ppev.object_type = 'PA_TASKS'

2832: select ppev.proj_element_id, ppev.element_version_id
2833: from pa_proj_element_versions ppev,
2834: pa_object_relationships por
2835: where ppev.parent_structure_version_id = p_structure_version_id
2836: and ppev.object_type = 'PA_TASKS'
2837: and ppev.element_version_id = por.object_id_from1
2838: and ppev.object_type = por.object_type_from
2839: and por.relationship_type = 'S';
2840: l_workplan VARCHAR2(1);

Line 2898: from pa_tasks where task_id = l_proj_element_id;

2894: IF (l_financial = 'Y') THEN
2895: --hsiu: changes for bug 2817687
2896: BEGIN
2897: select 1 into l_dummy
2898: from pa_tasks where task_id = l_proj_element_id;
2899:
2900: --bug 4068736
2901: OPEN c2(l_element_version_id);
2902: fetch c2 into l_dummy;

Line 2970: and ppev.object_type = 'PA_TASKS'

2966: select ppev.proj_element_id, ppev.element_version_id
2967: from pa_proj_element_versions ppev,
2968: pa_object_relationships por
2969: where ppev.parent_structure_version_id = p_structure_version_id
2970: and ppev.object_type = 'PA_TASKS'
2971: and ppev.element_version_id = por.object_id_from1
2972: and ppev.object_type = por.object_type_from
2973: and por.relationship_type = 'S';
2974: l_proj_element_id NUMBER;

Line 2993: and por.object_type_from = 'PA_TASKS'

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'
2994: and por.relationship_type = 'S'
2995: and por.object_type_to = 'PA_TASKS'
2996: and por.object_id_to1 = ppev.element_version_id
2997: and ppev.project_id = ppe.project_id

Line 2995: and por.object_type_to = 'PA_TASKS'

2991: pa_object_relationships por
2992: where por.object_id_from1 = c_parent_task_ver_id
2993: and por.object_type_from = 'PA_TASKS'
2994: and por.relationship_type = 'S'
2995: and por.object_type_to = 'PA_TASKS'
2996: and por.object_id_to1 = ppev.element_version_id
2997: and ppev.project_id = ppe.project_id
2998: and ppev.proj_element_id = ppe.proj_element_id
2999: and ppev.object_type = ppe.object_type

Line 3840: and b.Object_Type_From = 'PA_TASKS'

3836: and a.Element_Version_ID IN (
3837: Select b.OBJECT_ID_FROM1
3838: from pa_object_relationships b
3839: where b.Relationship_Type = 'S'
3840: and b.Object_Type_From = 'PA_TASKS'
3841: ) )
3842: Loop
3843: Begin
3844: Select 'Y'

Line 3848: and b.Object_Type_From = 'PA_TASKS'

3844: Select 'Y'
3845: Into l_Exist_Flag
3846: from pa_object_relationships b
3847: where Rec.Element_Version_ID IN ( b.Object_ID_From1, b.Object_ID_To1 )
3848: and b.Object_Type_From = 'PA_TASKS'
3849: and b.Object_Type_To = 'PA_TASKS'
3850: and b.Relationship_Type = 'D';
3851: Exception when No_Data_Found Then Null;
3852: End;

Line 3849: and b.Object_Type_To = 'PA_TASKS'

3845: Into l_Exist_Flag
3846: from pa_object_relationships b
3847: where Rec.Element_Version_ID IN ( b.Object_ID_From1, b.Object_ID_To1 )
3848: and b.Object_Type_From = 'PA_TASKS'
3849: and b.Object_Type_To = 'PA_TASKS'
3850: and b.Relationship_Type = 'D';
3851: Exception when No_Data_Found Then Null;
3852: End;
3853: If l_Exist_Flag = 'Y' then