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_PROGRESS_PVT dependencies on PA_PROJ_ROLLUP_TEMP

Line 478: pa_proj_rollup_temp temp

474: pa_progress_rollup ppr,
475: pa_project_statuses pps1,
476: pa_project_statuses pps2,
477: pa_project_statuses pps3 ,
478: pa_proj_rollup_temp temp
479: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
480: --element_version_id IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
481: temp.object_id = ppev.element_version_id
482: AND temp.process_number = l_process_number_temp

Line 479: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM

475: pa_project_statuses pps1,
476: pa_project_statuses pps2,
477: pa_project_statuses pps3 ,
478: pa_proj_rollup_temp temp
479: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
480: --element_version_id IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
481: temp.object_id = ppev.element_version_id
482: AND temp.process_number = l_process_number_temp
483: AND ppev.object_type = 'PA_STRUCTURES'

Line 480: --element_version_id IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)

476: pa_project_statuses pps2,
477: pa_project_statuses pps3 ,
478: pa_proj_rollup_temp temp
479: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
480: --element_version_id IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
481: temp.object_id = ppev.element_version_id
482: AND temp.process_number = l_process_number_temp
483: AND ppev.object_type = 'PA_STRUCTURES'
484: AND ppr.project_id = ppev.project_id

Line 604: pa_proj_rollup_temp temp

600: pa_project_statuses pps2,
601: pa_project_statuses pps3,
602: pa_project_statuses pps4,
603: pa_task_types ttype ,
604: pa_proj_rollup_temp temp
605: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
606: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
607: temp.object_id = pobj.object_id_from1
608: AND temp.process_number = l_process_number_temp

Line 605: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM

601: pa_project_statuses pps3,
602: pa_project_statuses pps4,
603: pa_task_types ttype ,
604: pa_proj_rollup_temp temp
605: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
606: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
607: temp.object_id = pobj.object_id_from1
608: AND temp.process_number = l_process_number_temp
609: AND pobj.object_id_from1 = ppev1.element_version_id

Line 606: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)

602: pa_project_statuses pps4,
603: pa_task_types ttype ,
604: pa_proj_rollup_temp temp
605: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
606: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
607: temp.object_id = pobj.object_id_from1
608: AND temp.process_number = l_process_number_temp
609: AND pobj.object_id_from1 = ppev1.element_version_id
610: AND pobj.object_id_to1 = ppev2.element_version_id

Line 728: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp

724: , to_number(null) structure_version_id
725: ,'N' create_required
726: ,'N' update_required
727: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
728: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp
729: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
730: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
731: element_version_id = temp.object_id
732: AND temp.process_number = l_process_number_temp

Line 729: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM

725: ,'N' create_required
726: ,'N' update_required
727: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
728: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp
729: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
730: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
731: element_version_id = temp.object_id
732: AND temp.process_number = l_process_number_temp
733: AND ppev.object_type = 'PA_STRUCTURES'

Line 730: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)

726: ,'N' update_required
727: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
728: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp
729: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
730: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
731: element_version_id = temp.object_id
732: AND temp.process_number = l_process_number_temp
733: AND ppev.object_type = 'PA_STRUCTURES'
734: AND pa_progress_utils.get_max_rollup_asofdate(ppev.project_id,

Line 841: pa_proj_rollup_temp temp

837: pa_proj_element_versions ppev2,
838: pa_proj_elements ppe,
839: pa_project_statuses pps4,
840: pa_task_types ttype ,
841: pa_proj_rollup_temp temp
842: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
843: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
844: pobj.object_id_from1 = temp.object_id
845: AND temp.process_number = l_process_number_temp

Line 842: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM

838: pa_proj_elements ppe,
839: pa_project_statuses pps4,
840: pa_task_types ttype ,
841: pa_proj_rollup_temp temp
842: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
843: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
844: pobj.object_id_from1 = temp.object_id
845: AND temp.process_number = l_process_number_temp
846: AND pobj.object_id_from1 = ppev1.element_version_id

Line 843: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)

839: pa_project_statuses pps4,
840: pa_task_types ttype ,
841: pa_proj_rollup_temp temp
842: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
843: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
844: pobj.object_id_from1 = temp.object_id
845: AND temp.process_number = l_process_number_temp
846: AND pobj.object_id_from1 = ppev1.element_version_id
847: AND pobj.object_id_to1 = ppev2.element_version_id

Line 1217: start with object_id_to1 IN (select object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)

1213:
1214: CURSOR c_mass_rollup_tasks IS
1215: select distinct object_id_from1
1216: from pa_object_relationships
1217: start with object_id_to1 IN (select object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
1218: and relationship_type = 'S'
1219: connect by prior object_id_from1 = object_id_to1
1220: and relationship_type = 'S'
1221: MINUS

Line 1222: select object_id object_id_from1 from pa_proj_rollup_temp where process_number = l_process_number_temp

1218: and relationship_type = 'S'
1219: connect by prior object_id_from1 = object_id_to1
1220: and relationship_type = 'S'
1221: MINUS
1222: select object_id object_id_from1 from pa_proj_rollup_temp where process_number = l_process_number_temp
1223: ;
1224:
1225: CURSOR c_mass_rollup_tasks_temp IS
1226: select object_id

Line 1227: from pa_proj_rollup_temp where process_number = l_process_number_temp

1223: ;
1224:
1225: CURSOR c_mass_rollup_tasks_temp IS
1226: select object_id
1227: from pa_proj_rollup_temp where process_number = l_process_number_temp
1228: ;
1229:
1230: CURSOR cur_check_published_version(c_structure_version_id number, c_project_id number)
1231: IS

Line 1282: , pa_proj_rollup_temp rollup

1278: select ppr.as_of_date, ver2.proj_element_id child_task_id, ver2.element_version_id child_task_ver_id
1279: from pa_object_relationships obj
1280: , pa_proj_element_versions ver
1281: , pa_progress_rollup ppr
1282: , pa_proj_rollup_temp rollup
1283: , pa_proj_element_versions ver2
1284: where rollup.object_id = obj.object_id_to1
1285: AND rollup.process_number = l_process_number_temp
1286: AND obj.relationship_type = 'S'

Line 1532: SELECT PA_PROJ_ROLLUP_TEMP_S.nextval

1528:
1529: --l_lowest_task := p_lowest_task;
1530: -- Loop thru all the parents of the passed task
1531:
1532: SELECT PA_PROJ_ROLLUP_TEMP_S.nextval
1533: INTO l_process_number_temp FROM dual;
1534:
1535: IF p_rollup_entire_wbs = 'N' THEN
1536: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)

Line 1536: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)

1532: SELECT PA_PROJ_ROLLUP_TEMP_S.nextval
1533: INTO l_process_number_temp FROM dual;
1534:
1535: IF p_rollup_entire_wbs = 'N' THEN
1536: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
1537: SELECT distinct l_process_number_temp, object_id_from1, 'PA_TASKS', 1
1538: FROM pa_object_relationships
1539: WHERE relationship_type = 'S'
1540: START WITH object_id_to1 = l_task_version_id

Line 1560: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)

1556: END IF;
1557:
1558: IF p_task_version_id_tbl.count > 0 THEN
1559: FORALL i in 1..p_task_version_id_tbl.count
1560: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
1561: VALUES(l_process_number_temp,p_task_version_id_tbl(i), 'PA_TASKS',1 );
1562:
1563: l_mass_rollup_prog_rec_tab.delete;
1564: OPEN c_mass_rollup_tasks;

Line 1569: INSERT INTO PA_PROJ_ROLLUP_TEMP(

1565: FETCH c_mass_rollup_tasks BULK COLLECT INTO l_mass_rollup_prog_rec_tab;
1566: CLOSE c_mass_rollup_tasks;
1567:
1568: FORALL i IN 1..l_mass_rollup_prog_rec_tab.COUNT
1569: INSERT INTO PA_PROJ_ROLLUP_TEMP(
1570: PROCESS_NUMBER,
1571: OBJECT_TYPE,
1572: OBJECT_ID,
1573: wbs_level)

Line 1578: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)

1574: VALUES(l_process_number_temp, 'PA_TASKS',l_mass_rollup_prog_rec_tab(i), 1);
1575:
1576: l_mass_rollup_prog_rec_tab.delete;
1577: ELSE
1578: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
1579: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
1580: FROM pa_proj_element_versions
1581: WHERE project_id = p_project_id
1582: AND parent_structure_version_id = p_structure_version_id

Line 1703: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;

1699: ,l_tsk_base_percent_comp_tab -- 4392189 : Program Reporting Changes - Phase 2
1700: ;
1701: CLOSE cur_tasks;
1702:
1703: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;
1704:
1705: IF g1_debug_mode = 'Y' THEN
1706: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT', x_Msg =>'l_tsk_object_id_to1_tab.count='||l_tsk_object_id_to1_tab.count, x_Log_Level=> 3);
1707: END IF;

Line 2359: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)

2355: IF p_lowest_level_task = 'N' AND p_rollup_entire_wbs = 'N'
2356: AND pa_progress_utils.check_assignment_exists(p_project_id,p_task_version_id, 'PA_TASKS') = 'Y'
2357: AND l_actual_lowest_task = 'N' -- Bug 4392189
2358: THEN
2359: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
2360: SELECT l_process_number_temp, p_task_version_id, 'PA_TASKS', 1
2361: FROM dual;
2362:
2363: FOR cur_tasks_rec in cur_tasks(1) LOOP

Line 2506: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;

2502: END LOOP;
2503: END IF; -- p_lowest_level_task = 'N' AND p_rollup_entire_wbs = 'N'
2504: --end bug 3951982
2505:
2506: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;
2507:
2508: IF g1_debug_mode = 'Y' THEN
2509: FOR i in 1..l_mass_rollup_prog_exists_tab.count loop
2510: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT', x_Msg => 'First l_mass_rollup_prog_exists_tab(i)='||l_mass_rollup_prog_exists_tab(i), x_Log_Level=> 3);

Line 2516: INSERT INTO PA_PROJ_ROLLUP_TEMP(

2512: END IF;
2513:
2514: IF p_rollup_entire_wbs = 'Y' THEN
2515: FORALL i IN 1..l_mass_rollup_prog_exists_tab.COUNT
2516: INSERT INTO PA_PROJ_ROLLUP_TEMP(
2517: PROCESS_NUMBER,
2518: OBJECT_TYPE,
2519: OBJECT_ID,
2520: wbs_level)

Line 2536: INSERT INTO PA_PROJ_ROLLUP_TEMP(

2532: END LOOP;
2533: END IF;
2534:
2535: FORALL i IN 1..l_mass_rollup_prog_exists_tab.COUNT
2536: INSERT INTO PA_PROJ_ROLLUP_TEMP(
2537: PROCESS_NUMBER,
2538: OBJECT_TYPE,
2539: OBJECT_ID,
2540: wbs_level)

Line 2751: from pa_proj_rollup_temp

2747: FROM dual
2748: WHERE exists
2749: (
2750: SELECT 'xyz'
2751: from pa_proj_rollup_temp
2752: WHERE object_id = cur_reverse_tree_rec.object_id_to1
2753: and process_number = l_process_number_temp
2754: );
2755: EXCEPTION

Line 3868: -- DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;

3864: END IF; -- IF p_calling_mode <> 'FUTURE_ROLLUP' OR p_calling_mode IS NULL THEN
3865:
3866: -- Bug 4242787
3867: -- Do not delete here. Delete it at last. This will be used in Future Rollup Too.
3868: -- DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;
3869:
3870: ---- ************** Updation Ends ****************** ----------
3871:
3872: -- Bug 4242787

Line 3948: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;

3944: END IF;
3945: END LOOP;
3946: END IF; -- p_rollup_entire_wbs = 'Y'
3947:
3948: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;
3949:
3950:
3951:
3952: x_return_status := FND_API.G_RET_STS_SUCCESS;