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_PVT dependencies on PA_PPR_OBJ_TMP2

Line 764: pa_ppr_obj_tmp2 c

760: '/'||decode(p_fact_slice,'WBS_TO_RBS',ra.rbs_element_id,'WBS_TO_CBS',ra.cbs_element_id,null)
761: FROM PA_RESOURCE_ASSIGNMENTS ra ,
762: PA_BUDGET_LINES bl ,
763: pa_ppr_obj_tmp b,
764: pa_ppr_obj_tmp2 c
765: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
766: and ra.budget_version_id = l_budget_version_id
767: and ra.task_id = c.object_id
768: and (

Line 813: pa_ppr_obj_tmp2 c

809: nvl(b.wbs_rbs_level,1)
810: FROM PA_RESOURCE_ASSIGNMENTS ra ,
811: PA_BUDGET_LINES bl ,
812: pa_ppr_obj_tmp b,
813: pa_ppr_obj_tmp2 c
814: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
815: and ra.budget_version_id = l_budget_version_id
816: and ra.rbs_element_id = c.object_id
817: and ra.task_id = b.object_id

Line 858: pa_ppr_obj_tmp2 c

854: nvl(b.wbs_rbs_level,1)
855: FROM PA_RESOURCE_ASSIGNMENTS ra ,
856: PA_BUDGET_LINES bl ,
857: pa_ppr_obj_tmp b,
858: pa_ppr_obj_tmp2 c
859: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
860: and ra.budget_version_id = l_budget_version_id
861: and ra.cbs_element_id = c.object_id
862: and (

Line 976: FROM pa_ppr_obj_tmp2 r

972:
973:
974: cursor c0 is
975: SELECT object_id
976: FROM pa_ppr_obj_tmp2 r
977: START WITH r.parent_object_id = l_object_id CONNECT BY
978: PRIOR r.object_id = r.parent_object_id ;
979:
980: cursor c1 is

Line 1138: delete from pa_ppr_obj_tmp2;

1134: -- l_functional_currency := 'GBP';
1135:
1136: --- Scenodary slice task / rbs / cbs list
1137:
1138: delete from pa_ppr_obj_tmp2;
1139:
1140: if ( p_fact_slice in ( 'WBS_TO_RBS' , 'WBS_TO_CBS' , 'CBS_TO_WBS_TO_RBS' ) ) then
1141:
1142: if ( l_version_type = 'WORKPLAN' ) then

Line 1144: ppr_log('inserting into pa_ppr_obj_tmp2 workplan '|| p_fact_slice);

1140: if ( p_fact_slice in ( 'WBS_TO_RBS' , 'WBS_TO_CBS' , 'CBS_TO_WBS_TO_RBS' ) ) then
1141:
1142: if ( l_version_type = 'WORKPLAN' ) then
1143:
1144: ppr_log('inserting into pa_ppr_obj_tmp2 workplan '|| p_fact_slice);
1145: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
1146: select /*+ ordered */
1147: a.proj_element_id , nvl(c.proj_element_id,l_struct_elem_id)
1148: from PA_PROJ_ELEMENT_VERSIONS a , pa_object_relationships b , PA_PROJ_ELEMENT_VERSIONS c

Line 1145: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )

1141:
1142: if ( l_version_type = 'WORKPLAN' ) then
1143:
1144: ppr_log('inserting into pa_ppr_obj_tmp2 workplan '|| p_fact_slice);
1145: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
1146: select /*+ ordered */
1147: a.proj_element_id , nvl(c.proj_element_id,l_struct_elem_id)
1148: from PA_PROJ_ELEMENT_VERSIONS a , pa_object_relationships b , PA_PROJ_ELEMENT_VERSIONS c
1149: where a.project_id = l_project_id

Line 1164: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )

1160: ppr_log('inserting into tmp2 financial '|| p_fact_slice);
1161: -- For financial tasks and fully shared.
1162: -- For budgets pa_tasks can be used directly
1163:
1164: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
1165: select /*+ ordered */
1166: p.task_id , nvl(p.parent_task_id, l_struct_elem_id )
1167: from pa_tasks p
1168: where p.project_id = l_project_id

Line 1188: ppr_log( 'Inserting into pa_ppr_obj_tmp2');

1184:
1185: ppr_log('p_fact_slice '||p_fact_slice|| ' l_rbs_cbs_version_id_2 '||l_rbs_cbs_version_id_2 );
1186: -- l_struct_elem_id := 0;
1187:
1188: ppr_log( 'Inserting into pa_ppr_obj_tmp2');
1189: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
1190: select rbs_element_id , nvl(parent_element_id,l_rbs_cbs_version_id_2)
1191: from pa_rbs_elements
1192: where rbs_version_id = l_rbs_cbs_version_id_2;

Line 1189: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )

1185: ppr_log('p_fact_slice '||p_fact_slice|| ' l_rbs_cbs_version_id_2 '||l_rbs_cbs_version_id_2 );
1186: -- l_struct_elem_id := 0;
1187:
1188: ppr_log( 'Inserting into pa_ppr_obj_tmp2');
1189: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
1190: select rbs_element_id , nvl(parent_element_id,l_rbs_cbs_version_id_2)
1191: from pa_rbs_elements
1192: where rbs_version_id = l_rbs_cbs_version_id_2;
1193:

Line 1194: ppr_log( 'Inserted into pa_ppr_obj_tmp2 count '||SQL%rowcount);

1190: select rbs_element_id , nvl(parent_element_id,l_rbs_cbs_version_id_2)
1191: from pa_rbs_elements
1192: where rbs_version_id = l_rbs_cbs_version_id_2;
1193:
1194: ppr_log( 'Inserted into pa_ppr_obj_tmp2 count '||SQL%rowcount);
1195: end if;
1196:
1197: if ( p_fact_slice in ( 'RBS_TO_WBS','CBS_TO_RBS', 'CBS_TO_WBS' , 'WBS_TO_RBS' , 'WBS_TO_CBS', 'WBS_TO_CBS_TO_RBS', 'CBS_TO_WBS_TO_RBS' ) ) then
1198:

Line 1204: FROM pa_ppr_obj_tmp2;

1200: /* l_task_arr.delete;
1201:
1202: SELECT object_id
1203: BULK COLLECT INTO l_task_arr
1204: FROM pa_ppr_obj_tmp2;
1205:
1206: ppr_log('SECONDARY SOURCE l_task_arr '||l_task_arr.count);
1207: */
1208: l_task_arr.delete;

Line 1220: delete from pa_ppr_obj_tmp2 ;

1216: CLOSE c0;
1217:
1218: ppr_log('SECONDARY c0 cursor output l_task_arr.count '||l_task_arr.count,0);
1219:
1220: delete from pa_ppr_obj_tmp2 ;
1221:
1222: FORALL i IN 1..l_task_arr.count
1223: INSERT INTO pa_ppr_obj_tmp2 ( object_id ) values ( l_task_arr(i) ) ;
1224:

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

1219:
1220: delete from pa_ppr_obj_tmp2 ;
1221:
1222: FORALL i IN 1..l_task_arr.count
1223: INSERT INTO pa_ppr_obj_tmp2 ( object_id ) values ( l_task_arr(i) ) ;
1224:
1225: if ( g_log_level >0 ) then
1226: for k1 in 1..l_task_arr.count loop
1227:

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

1233:
1234: l_task_arr.delete;
1235:
1236: ppr_log('before inserting l_object_id '||l_object_id);
1237: INSERT INTO pa_ppr_obj_tmp2 ( object_id ) values ( l_object_id ) ;
1238:
1239:
1240: end if;
1241: