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

Line 532: pa_ppr_obj_tmp b

528: 1 ,
529: 1 wbs_level
530: FROM PA_RESOURCE_ASSIGNMENTS ra ,
531: PA_BUDGET_LINES bl ,
532: pa_ppr_obj_tmp b
533: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
534: and ra.budget_version_id = l_budget_version_id
535: and ra.task_id = b.object_id
536: group by

Line 577: pa_ppr_obj_tmp b

573: 1 ,
574: 1 wbs_level
575: FROM PA_RESOURCE_ASSIGNMENTS ra ,
576: PA_BUDGET_LINES bl ,
577: pa_ppr_obj_tmp b
578: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
579: and ra.budget_version_id = l_budget_version_id
580: and (
581: ( p_fact_slice = 'RBS' AND ra.rbs_element_id = b.object_id )

Line 622: pa_ppr_obj_tmp c,

618: 1 ,
619: 1 wbs_level
620: FROM PA_RESOURCE_ASSIGNMENTS ra ,
621: PA_BUDGET_LINES bl ,
622: pa_ppr_obj_tmp c,
623: pa_ppr_obj_tmp2 b
624: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
625: and ra.budget_version_id = l_budget_version_id
626: and ra.task_id = c.object_id

Line 623: pa_ppr_obj_tmp2 b

619: 1 wbs_level
620: FROM PA_RESOURCE_ASSIGNMENTS ra ,
621: PA_BUDGET_LINES bl ,
622: pa_ppr_obj_tmp c,
623: pa_ppr_obj_tmp2 b
624: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
625: and ra.budget_version_id = l_budget_version_id
626: and ra.task_id = c.object_id
627: and (

Line 667: pa_ppr_obj_tmp c,

663: 1 ,
664: 1 wbs_level
665: FROM PA_RESOURCE_ASSIGNMENTS ra ,
666: PA_BUDGET_LINES bl ,
667: pa_ppr_obj_tmp c,
668: pa_ppr_obj_tmp2 b
669: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
670: and ra.budget_version_id = l_budget_version_id
671: and ra.rbs_element_id = c.object_id

Line 668: pa_ppr_obj_tmp2 b

664: 1 wbs_level
665: FROM PA_RESOURCE_ASSIGNMENTS ra ,
666: PA_BUDGET_LINES bl ,
667: pa_ppr_obj_tmp c,
668: pa_ppr_obj_tmp2 b
669: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
670: and ra.budget_version_id = l_budget_version_id
671: and ra.rbs_element_id = c.object_id
672: and ra.task_id = b.object_id

Line 710: pa_ppr_obj_tmp c,

706: 1 ,
707: 1 wbs_level
708: FROM PA_RESOURCE_ASSIGNMENTS ra ,
709: PA_BUDGET_LINES bl ,
710: pa_ppr_obj_tmp c,
711: pa_ppr_obj_tmp2 b
712: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
713: and ra.budget_version_id = l_budget_version_id
714: and ra.cbs_element_id = c.object_id

Line 711: pa_ppr_obj_tmp2 b

707: 1 wbs_level
708: FROM PA_RESOURCE_ASSIGNMENTS ra ,
709: PA_BUDGET_LINES bl ,
710: pa_ppr_obj_tmp c,
711: pa_ppr_obj_tmp2 b
712: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
713: and ra.budget_version_id = l_budget_version_id
714: and ra.cbs_element_id = c.object_id
715: and (

Line 732: FROM pa_ppr_obj_tmp r

728: l_object_id_2 number;
729:
730: cursor c0 is
731: SELECT object_id
732: FROM pa_ppr_obj_tmp r
733: START WITH r.parent_object_id = l_object_id CONNECT BY
734: PRIOR r.object_id = r.parent_object_id;
735:
736: cursor c1 is

Line 738: FROM pa_ppr_obj_tmp2 r

734: PRIOR r.object_id = r.parent_object_id;
735:
736: cursor c1 is
737: SELECT object_id
738: FROM pa_ppr_obj_tmp2 r
739: START WITH r.parent_object_id = l_object_id_2 CONNECT BY
740: PRIOR r.object_id = r.parent_object_id ;
741:
742:

Line 932: delete from pa_ppr_obj_tmp2;

928: end if;
929:
930:
931:
932: delete from pa_ppr_obj_tmp2;
933: delete from pa_ppr_obj_tmp;
934:
935: if ( p_fact_slice in ( 'WBS_TO_RBS' , 'WBS_TO_CBS' , 'WBS' ) ) then
936:

Line 933: delete from pa_ppr_obj_tmp;

929:
930:
931:
932: delete from pa_ppr_obj_tmp2;
933: delete from pa_ppr_obj_tmp;
934:
935: if ( p_fact_slice in ( 'WBS_TO_RBS' , 'WBS_TO_CBS' , 'WBS' ) ) then
936:
937: if ( l_version_type = 'WORKPLAN' ) then

Line 939: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )

935: if ( p_fact_slice in ( 'WBS_TO_RBS' , 'WBS_TO_CBS' , 'WBS' ) ) then
936:
937: if ( l_version_type = 'WORKPLAN' ) then
938:
939: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
940: select /*+ ordered */
941: a.proj_element_id , nvl(c.proj_element_id,l_struct_elem_id)
942: from PA_PROJ_ELEMENT_VERSIONS a , pa_object_relationships b , PA_PROJ_ELEMENT_VERSIONS c
943: where a.project_id = l_project_id

Line 956: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )

952:
953: -- For financial tasks and fully shared.
954: -- For budgets pa_tasks can be used directly
955:
956: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
957: select /*+ ordered */
958: p.task_id , nvl(p.parent_task_id, l_struct_elem_id )
959: from pa_tasks p
960: where p.project_id = l_project_id ;

Line 991: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )

987: ppr_log(' WBS_TO l_rbs_cbs_version_id_2 ... '||l_rbs_cbs_version_id_2,0);
988: ppr_log(' WBS_TO l_object_id_2 ... '||l_object_id_2,0);
989:
990:
991: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
992: select rbs_element_id , nvl(parent_element_id,l_rbs_cbs_version_id)
993: from pa_rbs_elements
994: where rbs_version_id = l_rbs_cbs_version_id_2;
995:

Line 1010: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )

1006:
1007: ppr_log(' l_rbs_cbs_version_id '||l_rbs_cbs_version_id ,0);
1008: ppr_log(' l_object_id '||l_object_id ,0);
1009:
1010: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
1011: select rbs_element_id , nvl(parent_element_id,l_rbs_cbs_version_id_2)
1012: from pa_rbs_elements
1013: where rbs_version_id = l_rbs_cbs_version_id ;
1014:

Line 1025: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )

1021: end if;
1022:
1023: if ( l_version_type = 'WORKPLAN' ) then
1024:
1025: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
1026: select /*+ ordered */
1027: a.proj_element_id , nvl(c.proj_element_id,l_struct_elem_id)
1028: from PA_PROJ_ELEMENT_VERSIONS a , pa_object_relationships b , PA_PROJ_ELEMENT_VERSIONS c
1029: where a.project_id = l_project_id

Line 1042: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )

1038:
1039: -- For financial tasks and fully shared.
1040: -- For budgets pa_tasks can be used directly
1041:
1042: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
1043: select /*+ ordered */
1044: p.task_id , nvl(p.parent_task_id, l_struct_elem_id )
1045: from pa_tasks p
1046: where p.project_id = l_project_id ;

Line 1064: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )

1060:
1061: ppr_log(' l_rbs_cbs_version_id 2 '||l_rbs_cbs_version_id_2 ,0);
1062: ppr_log(' l_object_id 2 '||l_object_id_2 ,0);
1063:
1064: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
1065: select rbs_element_id , nvl(parent_element_id,l_rbs_cbs_version_id_2)
1066: from pa_rbs_elements
1067: where rbs_version_id = l_rbs_cbs_version_id_2 ;
1068:

Line 1087: delete from pa_ppr_obj_tmp ;

1083: CLOSE c0;
1084:
1085: ppr_log('FIRST l_task_arr '||l_task_arr.count,0);
1086:
1087: delete from pa_ppr_obj_tmp ;
1088:
1089: FORALL i IN 1..l_task_arr.count
1090: INSERT INTO pa_ppr_obj_tmp ( object_id ) values ( l_task_arr(i) ) ;
1091:

Line 1090: INSERT INTO pa_ppr_obj_tmp ( object_id ) values ( l_task_arr(i) ) ;

1086:
1087: delete from pa_ppr_obj_tmp ;
1088:
1089: FORALL i IN 1..l_task_arr.count
1090: INSERT INTO pa_ppr_obj_tmp ( object_id ) values ( l_task_arr(i) ) ;
1091:
1092: if ( g_log_level >0 ) then
1093: for k1 in 1..l_task_arr.count loop
1094:

Line 1100: INSERT INTO pa_ppr_obj_tmp ( object_id ) values ( l_object_id ) ;

1096:
1097: end loop;
1098: end if;
1099:
1100: INSERT INTO pa_ppr_obj_tmp ( object_id ) values ( l_object_id ) ;
1101:
1102:
1103: l_task_arr.delete;
1104:

Line 1114: delete from pa_ppr_obj_tmp2 ;

1110: CLOSE c1;
1111:
1112: ppr_log('SECONDARY l_task_arr '||l_task_arr.count,0);
1113:
1114: delete from pa_ppr_obj_tmp2 ;
1115:
1116: FORALL i IN 1..l_task_arr.count
1117: INSERT INTO pa_ppr_obj_tmp2 ( object_id ) values ( l_task_arr(i) ) ;
1118:

Line 1117: INSERT INTO pa_ppr_obj_tmp2 ( object_id ) values ( l_task_arr(i) ) ;

1113:
1114: delete from pa_ppr_obj_tmp2 ;
1115:
1116: FORALL i IN 1..l_task_arr.count
1117: INSERT INTO pa_ppr_obj_tmp2 ( object_id ) values ( l_task_arr(i) ) ;
1118:
1119: if ( g_log_level >0 ) then
1120: for k1 in 1..l_task_arr.count loop
1121:

Line 1127: INSERT INTO pa_ppr_obj_tmp2 ( object_id ) values ( l_object_id_2 ) ;

1123:
1124: end loop;
1125: end if;
1126:
1127: INSERT INTO pa_ppr_obj_tmp2 ( object_id ) values ( l_object_id_2 ) ;
1128:
1129:
1130:
1131: l_task_arr.delete;