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_PPR_ROLLUP_ACTUAL_PVT dependencies on PA_PPR_OBJ_TMP

Line 407: pa_ppr_obj_tmp b

403: AND recvr_period_type = 'GL'
404: AND map1.txn_accum_header_id = accum1.txn_accum_header_id
405: AND map1.struct_version_id = l_rbs_cbs_version_id
406: ) tmp7 ,
407: pa_ppr_obj_tmp b
408: where
409: tmp7.element_id = b.object_id
410: group by -- tmp7.TXN_ACCUM_HEADER_ID,
411: -- tmp7.PROJECT_ID,

Line 649: pa_ppr_obj_tmp b

645: WHERE project_id = p_project_id
646: AND p_calling_mode = 'FULL'
647: AND recvr_period_type = 'GL'
648: ) tmp7 ,
649: pa_ppr_obj_tmp b
650: where
651: tmp7.task_id = b.object_id
652: group by -- tmp7.TXN_ACCUM_HEADER_ID,
653: -- tmp7.PROJECT_ID,

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 670: FROM pa_ppr_obj_tmp r

666: cursor c1 is
667: SELECT object_id , LEVEL ,
668: SYS_CONNECT_BY_PATH(object_id, '/') connect_path,
669: connect_by_isleaf leaf_node
670: FROM pa_ppr_obj_tmp r
671: START WITH r.parent_object_id is null CONNECT BY
672: PRIOR r.object_id = r.parent_object_id ;
673:
674:

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:

Line 849: delete from pa_ppr_obj_tmp;

845: end if;
846:
847: -- TASK Hierarchy details
848:
849: delete from pa_ppr_obj_tmp;
850:
851: if ( p_fact_slice in ( 'WBS' ) ) then
852:
853: ppr_log('into WBS ');

Line 854: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )

850:
851: if ( p_fact_slice in ( 'WBS' ) ) then
852:
853: ppr_log('into WBS ');
854: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
855: select c.task_id , nvl(c.parent_task_id,0)
856: from pa_tasks c
857: where c.project_id = l_project_id ;
858:

Line 864: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )

860: elsif p_fact_slice in ( 'RBS' , 'CBS' ) then
861:
862: ppr_log('into RBS ');
863:
864: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
865: select rbs_element_id , nvl(parent_element_id,0)
866: from pa_rbs_elements
867: where rbs_version_id = l_rbs_cbs_version_id ;
868:

Line 871: insert into pa_ppr_obj_tmp ( object_id , parent_object_id ) values ( 0 , null );

867: where rbs_version_id = l_rbs_cbs_version_id ;
868:
869: end if;
870:
871: insert into pa_ppr_obj_tmp ( object_id , parent_object_id ) values ( 0 , null );
872:
873:
874: OPEN c1;
875:

Line 882: UPDATE pa_ppr_obj_tmp

878:
879: CLOSE c1;
880:
881: FORALL k IN 1..l_task_arr.COUNT
882: UPDATE pa_ppr_obj_tmp
883: SET connect_path = l_connect_path_arr(k),
884: leaf_node = l_leaf_node_arr(k),
885: wbs_rbs_level = l_task_level_arr(k)
886: WHERE object_id = l_task_arr(k);