APPS.PA_PPR_ROLLUP_ACTUAL_PVT dependencies on PA_PPR_OBJ_TMP2

Line 662: FROM pa_ppr_obj_tmp2 r

658:
659:
660: cursor c0 is
661: SELECT object_id
662: FROM pa_ppr_obj_tmp2 r
663: START WITH r.parent_object_id = l_object_id CONNECT BY
664: PRIOR r.object_id = r.parent_object_id ;
665:
666: cursor c1 is

Line 762: delete from pa_ppr_obj_tmp2;

758: -- l_functional_currency := 'GBP';
759:
760: --- Scenodary slice task / rbs / cbs list
761:
762: delete from pa_ppr_obj_tmp2;
763:
764: if ( p_fact_slice in ( 'WBS_TO_RBS' , 'WBS_TO_CBS' ) ) then
765:
766: if ( l_version_type = 'WORKPLAN' ) then

Line 768: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )

764: if ( p_fact_slice in ( 'WBS_TO_RBS' , 'WBS_TO_CBS' ) ) then
765:
766: if ( l_version_type = 'WORKPLAN' ) then
767:
768: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
769: select /*+ ordered */
770: a.proj_element_id , nvl(c.proj_element_id,0)
771: from PA_PROJ_ELEMENT_VERSIONS a , pa_tasks c , pa_object_relationships b , PA_PROJ_ELEMENT_VERSIONS c
772: where a.project_id = l_project_id

Line 786: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )

782:
783: -- For financial tasks and fully shared.
784: -- For budgets pa_tasks can be used directly
785:
786: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
787: select c.task_id , nvl(c.parent_task_id,0)
788: from pa_tasks c
789: where c.project_id = l_project_id ;
790:

Line 806: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )

802:
803: end if;
804:
805:
806: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
807: select rbs_element_id , nvl(parent_element_id,0)
808: from pa_rbs_elements
809: where rbs_version_id = l_rbs_cbs_version_id_2 ;
810:

Line 820: FROM pa_ppr_obj_tmp2;

816: /* l_task_arr.delete;
817:
818: SELECT object_id
819: BULK COLLECT INTO l_task_arr
820: FROM pa_ppr_obj_tmp2;
821:
822: ppr_log('SECONDARY SOURCE l_task_arr '||l_task_arr.count);
823: */
824: l_task_arr.delete;

Line 835: delete from pa_ppr_obj_tmp2;

831: CLOSE c0;
832:
833: ppr_log('SECONDARY l_task_arr '||l_task_arr.count);
834:
835: delete from pa_ppr_obj_tmp2;
836:
837: FORALL i IN 1..l_out_task_arr.count
838: INSERT INTO pa_ppr_obj_tmp2 ( object_id ) values ( l_out_task_arr(i) ) ;
839:

Line 838: INSERT INTO pa_ppr_obj_tmp2 ( object_id ) values ( l_out_task_arr(i) ) ;

834:
835: delete from pa_ppr_obj_tmp2;
836:
837: FORALL i IN 1..l_out_task_arr.count
838: INSERT INTO pa_ppr_obj_tmp2 ( object_id ) values ( l_out_task_arr(i) ) ;
839:
840: l_task_arr.delete;
841:
842: INSERT INTO pa_ppr_obj_tmp2 ( object_id ) values ( l_object_id ) ;

Line 842: INSERT INTO pa_ppr_obj_tmp2 ( object_id ) values ( l_object_id ) ;

838: INSERT INTO pa_ppr_obj_tmp2 ( object_id ) values ( l_out_task_arr(i) ) ;
839:
840: l_task_arr.delete;
841:
842: INSERT INTO pa_ppr_obj_tmp2 ( object_id ) values ( l_object_id ) ;
843:
844:
845: end if;
846: