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 479: pa_proj_rollup_temp temp

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

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

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

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

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

Line 606: pa_proj_rollup_temp temp

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

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

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

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

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

Line 731: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp

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

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

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

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

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

Line 845: pa_proj_rollup_temp temp

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

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

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

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

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

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

1218:
1219: CURSOR c_mass_rollup_tasks IS
1220: select distinct object_id_from1
1221: from pa_object_relationships
1222: start with object_id_to1 IN (select object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
1223: and relationship_type = 'S'
1224: connect by prior object_id_from1 = object_id_to1
1225: and relationship_type = 'S'
1226: MINUS

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

1223: and relationship_type = 'S'
1224: connect by prior object_id_from1 = object_id_to1
1225: and relationship_type = 'S'
1226: MINUS
1227: select object_id object_id_from1 from pa_proj_rollup_temp where process_number = l_process_number_temp
1228: ;
1229:
1230: CURSOR c_mass_rollup_tasks_temp IS
1231: select object_id

Line 1232: from pa_proj_rollup_temp where process_number = l_process_number_temp

1228: ;
1229:
1230: CURSOR c_mass_rollup_tasks_temp IS
1231: select object_id
1232: from pa_proj_rollup_temp where process_number = l_process_number_temp
1233: ;
1234:
1235: CURSOR cur_check_published_version(c_structure_version_id number, c_project_id number)
1236: IS

Line 1287: , pa_proj_rollup_temp rollup

1283: select /*+ leading (ROLLUP) */ ppr.as_of_date, ver2.proj_element_id child_task_id, ver2.element_version_id child_task_ver_id
1284: from pa_object_relationships obj
1285: , pa_proj_element_versions ver
1286: , pa_progress_rollup ppr
1287: , pa_proj_rollup_temp rollup
1288: , pa_proj_element_versions ver2
1289: where rollup.object_id = obj.object_id_to1
1290: AND rollup.process_number = l_process_number_temp
1291: AND obj.relationship_type = 'S'

Line 1541: SELECT PA_PROJ_ROLLUP_TEMP_S.nextval

1537:
1538: --l_lowest_task := p_lowest_task;
1539: -- Loop thru all the parents of the passed task
1540:
1541: SELECT PA_PROJ_ROLLUP_TEMP_S.nextval
1542: INTO l_process_number_temp FROM dual;
1543:
1544: IF p_rollup_entire_wbs = 'N' THEN
1545: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)

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

1541: SELECT PA_PROJ_ROLLUP_TEMP_S.nextval
1542: INTO l_process_number_temp FROM dual;
1543:
1544: IF p_rollup_entire_wbs = 'N' THEN
1545: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
1546: SELECT distinct l_process_number_temp, object_id_from1, 'PA_TASKS', 1
1547: FROM pa_object_relationships
1548: WHERE relationship_type = 'S'
1549: START WITH object_id_to1 = l_task_version_id

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

1565: END IF;
1566:
1567: IF p_task_version_id_tbl.count > 0 THEN
1568: FORALL i in 1..p_task_version_id_tbl.count
1569: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
1570: VALUES(l_process_number_temp,p_task_version_id_tbl(i), 'PA_TASKS',1 );
1571:
1572: l_mass_rollup_prog_rec_tab.delete;
1573: OPEN c_mass_rollup_tasks;

Line 1578: INSERT INTO PA_PROJ_ROLLUP_TEMP(

1574: FETCH c_mass_rollup_tasks BULK COLLECT INTO l_mass_rollup_prog_rec_tab;
1575: CLOSE c_mass_rollup_tasks;
1576:
1577: FORALL i IN 1..l_mass_rollup_prog_rec_tab.COUNT
1578: INSERT INTO PA_PROJ_ROLLUP_TEMP(
1579: PROCESS_NUMBER,
1580: OBJECT_TYPE,
1581: OBJECT_ID,
1582: wbs_level)

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

1583: VALUES(l_process_number_temp, 'PA_TASKS',l_mass_rollup_prog_rec_tab(i), 1);
1584:
1585: l_mass_rollup_prog_rec_tab.delete;
1586: ELSE
1587: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
1588: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
1589: FROM pa_proj_element_versions
1590: WHERE project_id = p_project_id
1591: AND parent_structure_version_id = p_structure_version_id

Line 1712: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;

1708: ,l_tsk_base_percent_comp_tab -- 4392189 : Program Reporting Changes - Phase 2
1709: ;
1710: CLOSE cur_tasks;
1711:
1712: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;
1713:
1714: IF g1_debug_mode = 'Y' THEN
1715: 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);
1716: END IF;

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

2391: IF p_lowest_level_task = 'N' AND p_rollup_entire_wbs = 'N'
2392: AND pa_progress_utils.check_assignment_exists(p_project_id,p_task_version_id, 'PA_TASKS') = 'Y'
2393: AND l_actual_lowest_task = 'N' -- Bug 4392189
2394: THEN
2395: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
2396: SELECT l_process_number_temp, p_task_version_id, 'PA_TASKS', 1
2397: FROM dual;
2398:
2399: FOR cur_tasks_rec in cur_tasks(1) LOOP

Line 2549: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;

2545: END LOOP;
2546: END IF; -- p_lowest_level_task = 'N' AND p_rollup_entire_wbs = 'N'
2547: --end bug 3951982
2548:
2549: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;
2550:
2551: IF g1_debug_mode = 'Y' THEN
2552: FOR i in 1..l_mass_rollup_prog_exists_tab.count loop
2553: 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 2559: INSERT INTO PA_PROJ_ROLLUP_TEMP(

2555: END IF;
2556:
2557: IF p_rollup_entire_wbs = 'Y' THEN
2558: FORALL i IN 1..l_mass_rollup_prog_exists_tab.COUNT
2559: INSERT INTO PA_PROJ_ROLLUP_TEMP(
2560: PROCESS_NUMBER,
2561: OBJECT_TYPE,
2562: OBJECT_ID,
2563: wbs_level)

Line 2579: INSERT INTO PA_PROJ_ROLLUP_TEMP(

2575: END LOOP;
2576: END IF;
2577:
2578: FORALL i IN 1..l_mass_rollup_prog_exists_tab.COUNT
2579: INSERT INTO PA_PROJ_ROLLUP_TEMP(
2580: PROCESS_NUMBER,
2581: OBJECT_TYPE,
2582: OBJECT_ID,
2583: wbs_level)

Line 2794: from pa_proj_rollup_temp

2790: FROM dual
2791: WHERE exists
2792: (
2793: SELECT 'xyz'
2794: from pa_proj_rollup_temp
2795: WHERE object_id = cur_reverse_tree_rec.object_id_to1
2796: and process_number = l_process_number_temp
2797: );
2798: EXCEPTION

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

3907: END IF; -- IF p_calling_mode <> 'FUTURE_ROLLUP' OR p_calling_mode IS NULL THEN
3908:
3909: -- Bug 4242787
3910: -- Do not delete here. Delete it at last. This will be used in Future Rollup Too.
3911: -- DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;
3912:
3913: ---- ************** Updation Ends ****************** ----------
3914:
3915: -- Bug 4242787

Line 3991: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;

3987: END IF;
3988: END LOOP;
3989: END IF; -- p_rollup_entire_wbs = 'Y'
3990:
3991: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;
3992:
3993:
3994:
3995: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 10990: pa_proj_rollup_temp temp

10986: pa_progress_rollup ppr,
10987: pa_project_statuses pps1,
10988: pa_project_statuses pps2,
10989: pa_project_statuses pps3 ,
10990: pa_proj_rollup_temp temp
10991: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
10992: --element_version_id IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
10993: temp.object_id = ppev.element_version_id
10994: AND temp.process_number = l_process_number_temp

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

10987: pa_project_statuses pps1,
10988: pa_project_statuses pps2,
10989: pa_project_statuses pps3 ,
10990: pa_proj_rollup_temp temp
10991: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
10992: --element_version_id IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
10993: temp.object_id = ppev.element_version_id
10994: AND temp.process_number = l_process_number_temp
10995: AND ppev.object_type = 'PA_STRUCTURES'

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

10988: pa_project_statuses pps2,
10989: pa_project_statuses pps3 ,
10990: pa_proj_rollup_temp temp
10991: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
10992: --element_version_id IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
10993: temp.object_id = ppev.element_version_id
10994: AND temp.process_number = l_process_number_temp
10995: AND ppev.object_type = 'PA_STRUCTURES'
10996: AND ppr.project_id = ppev.project_id

Line 11117: pa_proj_rollup_temp temp

11113: pa_project_statuses pps2,
11114: pa_project_statuses pps3,
11115: pa_project_statuses pps4,
11116: pa_task_types ttype ,
11117: pa_proj_rollup_temp temp
11118: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
11119: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
11120: temp.object_id = pobj.object_id_from1
11121: AND temp.process_number = l_process_number_temp

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

11114: pa_project_statuses pps3,
11115: pa_project_statuses pps4,
11116: pa_task_types ttype ,
11117: pa_proj_rollup_temp temp
11118: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
11119: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
11120: temp.object_id = pobj.object_id_from1
11121: AND temp.process_number = l_process_number_temp
11122: AND pobj.object_id_from1 = ppev1.element_version_id

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

11115: pa_project_statuses pps4,
11116: pa_task_types ttype ,
11117: pa_proj_rollup_temp temp
11118: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
11119: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
11120: temp.object_id = pobj.object_id_from1
11121: AND temp.process_number = l_process_number_temp
11122: AND pobj.object_id_from1 = ppev1.element_version_id
11123: AND pobj.object_id_to1 = ppev2.element_version_id

Line 11242: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp

11238: , to_number(null) structure_version_id
11239: ,'N' create_required
11240: ,'N' update_required
11241: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
11242: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp
11243: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
11244: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
11245: element_version_id = temp.object_id
11246: AND temp.process_number = l_process_number_temp

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

11239: ,'N' create_required
11240: ,'N' update_required
11241: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
11242: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp
11243: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
11244: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
11245: element_version_id = temp.object_id
11246: AND temp.process_number = l_process_number_temp
11247: AND ppev.object_type = 'PA_STRUCTURES'

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

11240: ,'N' update_required
11241: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
11242: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp
11243: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
11244: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
11245: element_version_id = temp.object_id
11246: AND temp.process_number = l_process_number_temp
11247: AND ppev.object_type = 'PA_STRUCTURES'
11248: AND pa_progress_utils.get_max_rollup_asofdate(ppev.project_id,

Line 11356: pa_proj_rollup_temp temp

11352: pa_proj_element_versions ppev2,
11353: pa_proj_elements ppe,
11354: pa_project_statuses pps4,
11355: pa_task_types ttype ,
11356: pa_proj_rollup_temp temp
11357: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
11358: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
11359: pobj.object_id_from1 = temp.object_id
11360: AND temp.process_number = l_process_number_temp

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

11353: pa_proj_elements ppe,
11354: pa_project_statuses pps4,
11355: pa_task_types ttype ,
11356: pa_proj_rollup_temp temp
11357: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
11358: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
11359: pobj.object_id_from1 = temp.object_id
11360: AND temp.process_number = l_process_number_temp
11361: AND pobj.object_id_from1 = ppev1.element_version_id

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

11354: pa_project_statuses pps4,
11355: pa_task_types ttype ,
11356: pa_proj_rollup_temp temp
11357: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
11358: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
11359: pobj.object_id_from1 = temp.object_id
11360: AND temp.process_number = l_process_number_temp
11361: AND pobj.object_id_from1 = ppev1.element_version_id
11362: AND pobj.object_id_to1 = ppev2.element_version_id

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

11487:
11488: CURSOR c_mass_rollup_tasks IS
11489: select distinct object_id_from1
11490: from pa_object_relationships
11491: start with object_id_to1 IN (select object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
11492: and relationship_type = 'S'
11493: connect by prior object_id_from1 = object_id_to1
11494: and relationship_type = 'S'
11495: MINUS

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

11492: and relationship_type = 'S'
11493: connect by prior object_id_from1 = object_id_to1
11494: and relationship_type = 'S'
11495: MINUS
11496: select object_id object_id_from1 from pa_proj_rollup_temp where process_number = l_process_number_temp
11497: ;
11498:
11499: CURSOR c_mass_rollup_tasks_temp IS
11500: select object_id

Line 11501: from pa_proj_rollup_temp where process_number = l_process_number_temp

11497: ;
11498:
11499: CURSOR c_mass_rollup_tasks_temp IS
11500: select object_id
11501: from pa_proj_rollup_temp where process_number = l_process_number_temp
11502: ;
11503:
11504: CURSOR cur_check_published_version(c_structure_version_id number, c_project_id number)
11505: IS

Line 11556: , pa_proj_rollup_temp rollup

11552: select /*+ leading (ROLLUP) */ ppr.as_of_date, ver2.proj_element_id child_task_id, ver2.element_version_id child_task_ver_id
11553: from pa_object_relationships obj
11554: , pa_proj_element_versions ver
11555: , pa_progress_rollup ppr
11556: , pa_proj_rollup_temp rollup
11557: , pa_proj_element_versions ver2
11558: where rollup.object_id = obj.object_id_to1
11559: AND rollup.process_number = l_process_number_temp
11560: AND obj.relationship_type = 'S'

Line 11845: SELECT PA_PROJ_ROLLUP_TEMP_S.nextval

11841:
11842: --l_lowest_task := p_lowest_task;
11843: -- Loop thru all the parents of the passed task
11844:
11845: SELECT PA_PROJ_ROLLUP_TEMP_S.nextval
11846: INTO l_process_number_temp FROM dual;
11847:
11848: IF p_rollup_entire_wbs = 'N' THEN
11849: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)

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

11845: SELECT PA_PROJ_ROLLUP_TEMP_S.nextval
11846: INTO l_process_number_temp FROM dual;
11847:
11848: IF p_rollup_entire_wbs = 'N' THEN
11849: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
11850: SELECT distinct l_process_number_temp, object_id_from1, 'PA_TASKS', 1
11851: FROM pa_object_relationships
11852: WHERE relationship_type = 'S'
11853: START WITH object_id_to1 = l_task_version_id

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

11868: END IF;
11869:
11870: IF p_task_version_id_tbl.count > 0 THEN
11871: FORALL i in 1..p_task_version_id_tbl.count
11872: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
11873: VALUES(l_process_number_temp,p_task_version_id_tbl(i), 'PA_TASKS',1 );
11874:
11875: l_mass_rollup_prog_rec_tab.delete;
11876: OPEN c_mass_rollup_tasks;

Line 11881: INSERT INTO PA_PROJ_ROLLUP_TEMP(

11877: FETCH c_mass_rollup_tasks BULK COLLECT INTO l_mass_rollup_prog_rec_tab;
11878: CLOSE c_mass_rollup_tasks;
11879:
11880: FORALL i IN 1..l_mass_rollup_prog_rec_tab.COUNT
11881: INSERT INTO PA_PROJ_ROLLUP_TEMP(
11882: PROCESS_NUMBER,
11883: OBJECT_TYPE,
11884: OBJECT_ID,
11885: wbs_level)

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

11886: VALUES(l_process_number_temp, 'PA_TASKS',l_mass_rollup_prog_rec_tab(i), 1);
11887:
11888: l_mass_rollup_prog_rec_tab.delete;
11889: ELSE
11890: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
11891: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
11892: FROM pa_proj_element_versions
11893: WHERE project_id = p_project_id
11894: AND parent_structure_version_id = p_structure_version_id

Line 12024: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;

12020: ;
12021: CLOSE cur_tasks;
12022:
12023:
12024: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;
12025:
12026: IF g1_debug_mode = 'Y' THEN
12027: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg =>'l_tsk_object_id_to1_tab.count='||l_tsk_object_id_to1_tab.count, x_Log_Level=> 3);
12028: END IF;

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

12623: IF p_lowest_level_task = 'N' AND p_rollup_entire_wbs = 'N'
12624: AND pa_progress_utils.check_assignment_exists(p_project_id,p_task_version_id, 'PA_TASKS') = 'Y'
12625: AND l_actual_lowest_task = 'N' -- Bug 4392189
12626: THEN
12627: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
12628: SELECT l_process_number_temp, p_task_version_id, 'PA_TASKS', 1
12629: FROM dual;
12630:
12631: FOR cur_tasks_rec in cur_tasks(1) LOOP

Line 12778: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;

12774: END LOOP;
12775: END IF; -- p_lowest_level_task = 'N' AND p_rollup_entire_wbs = 'N'
12776: --end bug 3951982
12777:
12778: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;
12779:
12780: IF g1_debug_mode = 'Y' THEN
12781: FOR i in 1..l_mass_rollup_prog_exists_tab.count loop
12782: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg => 'First l_mass_rollup_prog_exists_tab(i)='||l_mass_rollup_prog_exists_tab(i), x_Log_Level=> 3);

Line 12788: INSERT INTO PA_PROJ_ROLLUP_TEMP(

12784: END IF;
12785:
12786: IF p_rollup_entire_wbs = 'Y' THEN
12787: FORALL i IN 1..l_mass_rollup_prog_exists_tab.COUNT
12788: INSERT INTO PA_PROJ_ROLLUP_TEMP(
12789: PROCESS_NUMBER,
12790: OBJECT_TYPE,
12791: OBJECT_ID,
12792: wbs_level)

Line 12808: INSERT INTO PA_PROJ_ROLLUP_TEMP(

12804: END LOOP;
12805: END IF;
12806:
12807: FORALL i IN 1..l_mass_rollup_prog_exists_tab.COUNT
12808: INSERT INTO PA_PROJ_ROLLUP_TEMP(
12809: PROCESS_NUMBER,
12810: OBJECT_TYPE,
12811: OBJECT_ID,
12812: wbs_level)

Line 13022: from pa_proj_rollup_temp

13018: FROM dual
13019: WHERE exists
13020: (
13021: SELECT 'xyz'
13022: from pa_proj_rollup_temp
13023: WHERE object_id = cur_reverse_tree_rec.object_id_to1
13024: and process_number = l_process_number_temp
13025: );
13026: EXCEPTION

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

13991: END IF; -- IF p_calling_mode <> 'FUTURE_ROLLUP' OR p_calling_mode IS NULL THEN
13992:
13993: -- Bug 4242787
13994: -- Do not delete here. Delete it at last. This will be used in Future Rollup Too.
13995: -- DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;
13996:
13997: ---- ************** Updation Ends ****************** ----------
13998:
13999: -- Bug 4242787

Line 14074: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;

14070: END IF;
14071: END LOOP;
14072: END IF; -- p_rollup_entire_wbs = 'Y'
14073:
14074: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;
14075:
14076: x_return_status := FND_API.G_RET_STS_SUCCESS;
14077:
14078: IF (p_commit = FND_API.G_TRUE) THEN

Line 14550: pa_proj_rollup_temp temp

14546: pa_progress_rollup ppr,
14547: pa_project_statuses pps1,
14548: pa_project_statuses pps2,
14549: pa_project_statuses pps3 ,
14550: pa_proj_rollup_temp temp
14551: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14552: --element_version_id IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
14553: temp.object_id = ppev.element_version_id
14554: AND temp.process_number = l_process_number_temp

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

14547: pa_project_statuses pps1,
14548: pa_project_statuses pps2,
14549: pa_project_statuses pps3 ,
14550: pa_proj_rollup_temp temp
14551: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14552: --element_version_id IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
14553: temp.object_id = ppev.element_version_id
14554: AND temp.process_number = l_process_number_temp
14555: AND ppev.object_type = 'PA_STRUCTURES'

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

14548: pa_project_statuses pps2,
14549: pa_project_statuses pps3 ,
14550: pa_proj_rollup_temp temp
14551: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14552: --element_version_id IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
14553: temp.object_id = ppev.element_version_id
14554: AND temp.process_number = l_process_number_temp
14555: AND ppev.object_type = 'PA_STRUCTURES'
14556: AND ppr.project_id = ppev.project_id

Line 14677: pa_proj_rollup_temp temp

14673: pa_project_statuses pps2,
14674: pa_project_statuses pps3,
14675: pa_project_statuses pps4,
14676: pa_task_types ttype ,
14677: pa_proj_rollup_temp temp
14678: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14679: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
14680: temp.object_id = pobj.object_id_from1
14681: AND temp.process_number = l_process_number_temp

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

14674: pa_project_statuses pps3,
14675: pa_project_statuses pps4,
14676: pa_task_types ttype ,
14677: pa_proj_rollup_temp temp
14678: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14679: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
14680: temp.object_id = pobj.object_id_from1
14681: AND temp.process_number = l_process_number_temp
14682: AND pobj.object_id_from1 = ppev1.element_version_id

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

14675: pa_project_statuses pps4,
14676: pa_task_types ttype ,
14677: pa_proj_rollup_temp temp
14678: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14679: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
14680: temp.object_id = pobj.object_id_from1
14681: AND temp.process_number = l_process_number_temp
14682: AND pobj.object_id_from1 = ppev1.element_version_id
14683: AND pobj.object_id_to1 = ppev2.element_version_id

Line 14802: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp

14798: , to_number(null) structure_version_id
14799: ,'N' create_required
14800: ,'N' update_required
14801: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
14802: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp
14803: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14804: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
14805: element_version_id = temp.object_id
14806: AND temp.process_number = l_process_number_temp

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

14799: ,'N' create_required
14800: ,'N' update_required
14801: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
14802: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp
14803: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14804: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
14805: element_version_id = temp.object_id
14806: AND temp.process_number = l_process_number_temp
14807: AND ppev.object_type = 'PA_STRUCTURES'

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

14800: ,'N' update_required
14801: , to_number(null) base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
14802: FROM pa_proj_element_versions ppev , pa_proj_rollup_temp temp
14803: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14804: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
14805: element_version_id = temp.object_id
14806: AND temp.process_number = l_process_number_temp
14807: AND ppev.object_type = 'PA_STRUCTURES'
14808: AND pa_progress_utils.get_max_rollup_asofdate(ppev.project_id,

Line 14916: pa_proj_rollup_temp temp

14912: pa_proj_element_versions ppev2,
14913: pa_proj_elements ppe,
14914: pa_project_statuses pps4,
14915: pa_task_types ttype ,
14916: pa_proj_rollup_temp temp
14917: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14918: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
14919: pobj.object_id_from1 = temp.object_id
14920: AND temp.process_number = l_process_number_temp

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

14913: pa_proj_elements ppe,
14914: pa_project_statuses pps4,
14915: pa_task_types ttype ,
14916: pa_proj_rollup_temp temp
14917: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14918: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
14919: pobj.object_id_from1 = temp.object_id
14920: AND temp.process_number = l_process_number_temp
14921: AND pobj.object_id_from1 = ppev1.element_version_id

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

14914: pa_project_statuses pps4,
14915: pa_task_types ttype ,
14916: pa_proj_rollup_temp temp
14917: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14918: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
14919: pobj.object_id_from1 = temp.object_id
14920: AND temp.process_number = l_process_number_temp
14921: AND pobj.object_id_from1 = ppev1.element_version_id
14922: AND pobj.object_id_to1 = ppev2.element_version_id

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

15048:
15049: CURSOR c_mass_rollup_tasks IS
15050: select distinct object_id_from1
15051: from pa_object_relationships
15052: start with object_id_to1 IN (select object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
15053: and relationship_type = 'S'
15054: connect by prior object_id_from1 = object_id_to1
15055: and relationship_type = 'S'
15056: MINUS

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

15053: and relationship_type = 'S'
15054: connect by prior object_id_from1 = object_id_to1
15055: and relationship_type = 'S'
15056: MINUS
15057: select object_id object_id_from1 from pa_proj_rollup_temp where process_number = l_process_number_temp
15058: ;
15059:
15060: CURSOR c_mass_rollup_tasks_temp IS
15061: select object_id

Line 15062: from pa_proj_rollup_temp where process_number = l_process_number_temp

15058: ;
15059:
15060: CURSOR c_mass_rollup_tasks_temp IS
15061: select object_id
15062: from pa_proj_rollup_temp where process_number = l_process_number_temp
15063: ;
15064:
15065: CURSOR cur_check_published_version(c_structure_version_id number, c_project_id number)
15066: IS

Line 15117: , pa_proj_rollup_temp rollup

15113: select /*+ leading (ROLLUP) */ ppr.as_of_date, ver2.proj_element_id child_task_id, ver2.element_version_id child_task_ver_id
15114: from pa_object_relationships obj
15115: , pa_proj_element_versions ver
15116: , pa_progress_rollup ppr
15117: , pa_proj_rollup_temp rollup
15118: , pa_proj_element_versions ver2
15119: where rollup.object_id = obj.object_id_to1
15120: AND rollup.process_number = l_process_number_temp
15121: AND obj.relationship_type = 'S'

Line 15416: SELECT PA_PROJ_ROLLUP_TEMP_S.nextval

15412:
15413: --l_lowest_task := p_lowest_task;
15414: -- Loop thru all the parents of the passed task
15415:
15416: SELECT PA_PROJ_ROLLUP_TEMP_S.nextval
15417: INTO l_process_number_temp FROM dual;
15418:
15419: IF p_rollup_entire_wbs = 'N' THEN
15420: -- sridhar_rollup

Line 15435: /*INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)

15431: IF p_task_version_id_tbl.count > 0 THEN
15432: -- sridhar_rollup
15433: null;
15434: ELSE
15435: /*INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
15436: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15437: FROM pa_proj_element_versions
15438: WHERE project_id = p_project_id
15439: AND parent_structure_version_id = p_structure_version_id

Line 15445: /*INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)

15441: AND object_type = 'PA_TASKS'
15442: UNION
15443: SELECT l_process_number_temp, p_structure_version_id object_id_from1, 'PA_TASKS', 1
15444: FROM dual;*/
15445: /*INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
15446: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15447: FROM PA_PROJ_ELEMENTS_TMP r
15448: START WITH r.TASK_ID in ( select distinct parent_task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code = 'P' ) CONNECT BY
15449: r.TASK_ID = prior r.PARENT_TASK_ID

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

15457: prior r.TASK_ID = r.PARENT_TASK_ID
15458: UNION
15459: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15460: FROM PA_PROJ_ELEMENTS_TMP r where r.defer_code = 'S' ;*/
15461: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
15462: SELECT /*+ CONNECT_BY_FILTERING */ l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15463: FROM PA_PROJ_ELEMENTS_TMP r
15464: START WITH r.TASK_ID in ( select distinct parent_task_id from PA_PROJ_ELEMENTS_TMP t1 where t1.defer_code in ( 'P','C') ) CONNECT BY
15465: r.TASK_ID = prior r.PARENT_TASK_ID

Line 15604: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;

15600: ;
15601: CLOSE cur_tasks;
15602:
15603:
15604: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;
15605:
15606: IF g1_debug_mode = 'Y' THEN
15607: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg =>'l_tsk_object_id_to1_tab.count='||l_tsk_object_id_to1_tab.count, x_Log_Level=> 3);
15608: END IF;

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

16210: IF p_lowest_level_task = 'N' AND p_rollup_entire_wbs = 'N'
16211: AND pa_progress_utils.check_assignment_exists(p_project_id,p_task_version_id, 'PA_TASKS') = 'Y'
16212: AND l_actual_lowest_task = 'N' -- Bug 4392189
16213: THEN
16214: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
16215: SELECT l_process_number_temp, p_task_version_id, 'PA_TASKS', 1
16216: FROM dual;
16217:
16218: FOR cur_tasks_rec in cur_tasks(1) LOOP

Line 16365: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;

16361: END LOOP;
16362: END IF; -- p_lowest_level_task = 'N' AND p_rollup_entire_wbs = 'N'
16363: --end bug 3951982
16364:
16365: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;
16366:
16367: IF g1_debug_mode = 'Y' THEN
16368: FOR i in 1..l_mass_rollup_prog_exists_tab.count loop
16369: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg => 'First l_mass_rollup_prog_exists_tab(i)='||l_mass_rollup_prog_exists_tab(i), x_Log_Level=> 3);

Line 16375: INSERT INTO PA_PROJ_ROLLUP_TEMP(

16371: END IF;
16372:
16373: IF p_rollup_entire_wbs = 'Y' THEN
16374: FORALL i IN 1..l_mass_rollup_prog_exists_tab.COUNT
16375: INSERT INTO PA_PROJ_ROLLUP_TEMP(
16376: PROCESS_NUMBER,
16377: OBJECT_TYPE,
16378: OBJECT_ID,
16379: wbs_level)

Line 16395: INSERT INTO PA_PROJ_ROLLUP_TEMP(

16391: END LOOP;
16392: END IF;
16393:
16394: FORALL i IN 1..l_mass_rollup_prog_exists_tab.COUNT
16395: INSERT INTO PA_PROJ_ROLLUP_TEMP(
16396: PROCESS_NUMBER,
16397: OBJECT_TYPE,
16398: OBJECT_ID,
16399: wbs_level)

Line 16632: from pa_proj_rollup_temp

16628: FROM dual
16629: WHERE exists
16630: (
16631: SELECT 'xyz'
16632: from pa_proj_rollup_temp
16633: WHERE object_id = cur_reverse_tree_rec.object_id_to1
16634: and process_number = l_process_number_temp
16635: );
16636: EXCEPTION

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

17623: END IF; -- IF p_calling_mode <> 'FUTURE_ROLLUP' OR p_calling_mode IS NULL THEN
17624:
17625: -- Bug 4242787
17626: -- Do not delete here. Delete it at last. This will be used in Future Rollup Too.
17627: -- DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;
17628:
17629: ---- ************** Updation Ends ****************** ----------
17630:
17631: -- Bug 4242787

Line 17706: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;

17702: END IF;
17703: END LOOP;
17704: END IF; -- p_rollup_entire_wbs = 'Y'
17705:
17706: DELETE from pa_proj_rollup_temp where process_number= l_process_number_temp;
17707:
17708: x_return_status := FND_API.G_RET_STS_SUCCESS;
17709:
17710: IF (p_commit = FND_API.G_TRUE) THEN