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_TMP

Line 29: FROM pa_ppr_obj_tmp r

25: cursor c1 is
26: SELECT object_id , LEVEL,
27: SYS_CONNECT_BY_PATH(object_id, '/') connect_path,
28: connect_by_isleaf leaf_node
29: FROM pa_ppr_obj_tmp r
30: START WITH r.parent_object_id is null CONNECT BY
31: PRIOR r.object_id = r.parent_object_id ;
32:
33:

Line 36: delete from pa_ppr_obj_tmp;

32:
33:
34: begin
35:
36: delete from pa_ppr_obj_tmp;
37: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
38: select rbs_element_id , nvl(parent_element_id,p_rbs_version_id)
39: from pa_rbs_elements
40: where rbs_version_id = p_rbs_version_id;

Line 37: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )

33:
34: begin
35:
36: delete from pa_ppr_obj_tmp;
37: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
38: select rbs_element_id , nvl(parent_element_id,p_rbs_version_id)
39: from pa_rbs_elements
40: where rbs_version_id = p_rbs_version_id;
41:

Line 42: insert into pa_ppr_obj_tmp ( object_id , parent_object_id ) values ( p_rbs_version_id , null );

38: select rbs_element_id , nvl(parent_element_id,p_rbs_version_id)
39: from pa_rbs_elements
40: where rbs_version_id = p_rbs_version_id;
41:
42: insert into pa_ppr_obj_tmp ( object_id , parent_object_id ) values ( p_rbs_version_id , null );
43:
44: OPEN c1;
45:
46: FETCH c1

Line 417: pa_ppr_obj_tmp b

413: nvl(b.leaf_node,1) ,
414: nvl(b.wbs_rbs_level,1)
415: FROM PA_RESOURCE_ASSIGNMENTS ra ,
416: PA_BUDGET_LINES bl ,
417: pa_ppr_obj_tmp b
418: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
419: and ra.budget_version_id = l_budget_version_id
420: and ra.task_id = b.object_id
421: group by

Line 486: pa_ppr_obj_tmp b

482: nvl(b.leaf_node,1) leaf_node,
483: nvl(b.wbs_rbs_level,1) task_level_arr
484: FROM PA_RESOURCE_ASSIGNMENTS ra ,
485: PA_BUDGET_LINES bl ,
486: pa_ppr_obj_tmp b
487: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
488: and ra.budget_version_id = l_budget_version_id
489: and ra.task_id = b.object_id
490: group by

Line 526: pa_ppr_obj_tmp b

522: nvl(b.leaf_node,1) leaf_node,
523: nvl(b.wbs_rbs_level,1) task_level_arr
524: FROM
525: PJI_FM_EXTR_PLAN_LINES bl2,
526: pa_ppr_obj_tmp b
527: WHERE
528: bl2.plan_version_id = l_budget_version_id
529: and bl2.project_element_id = b.object_id ) t1
530: group by

Line 597: ) t , pa_ppr_obj_tmp b

593: PJI_FM_EXTR_PLAN_LINES bl
594: WHERE 1=1
595: AND bl.project_id = l_project_id
596: AND bl.plan_version_id = l_budget_version_id
597: ) t , pa_ppr_obj_tmp b
598: WHERE t.task_id = b.object_id (+)
599: group by
600: t.billable_flag
601: ,t. task_id

Line 669: ) t , pa_ppr_obj_tmp b

665: PJI_FM_EXTR_PLAN_LINES bl
666: WHERE 1=1
667: AND bl.project_id = l_project_id
668: AND bl.plan_version_id = l_budget_version_id
669: ) t , pa_ppr_obj_tmp b
670: WHERE t.task_id = b.object_id (+)
671: and (
672: ( p_fact_slice = 'RBS' AND t.rbs_element_id = b.object_id )
673: OR

Line 715: pa_ppr_obj_tmp b

711: nvl(b.wbs_rbs_level,1),
712: '/'||decode(p_fact_slice,'RBS',ra.rbs_element_id,'CBS',ra.cbs_element_id,null)
713: FROM PA_RESOURCE_ASSIGNMENTS ra ,
714: PA_BUDGET_LINES bl ,
715: pa_ppr_obj_tmp b
716: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
717: and ra.budget_version_id = l_budget_version_id
718: and (
719: ( p_fact_slice = 'RBS' AND ra.rbs_element_id = b.object_id )

Line 763: pa_ppr_obj_tmp b,

759: nvl(b.wbs_rbs_level,1),
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

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 812: pa_ppr_obj_tmp b,

808: nvl(b.leaf_node,1) ,
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

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 857: pa_ppr_obj_tmp b,

853: nvl(b.leaf_node,1) ,
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

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 961: ) t , pa_ppr_obj_tmp b

957: FROM PA_RESOURCE_ASSIGNMENTS ra ,
958: PA_BUDGET_LINES bl
959: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
960: and ra.budget_version_id = l_budget_version_id
961: ) t , pa_ppr_obj_tmp b
962: WHERE t.task_id = b.object_id (+)
963: group by
964: t.billable_flag
965: ,t. task_id

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

980: cursor c1 is
981: SELECT object_id , LEVEL,
982: SYS_CONNECT_BY_PATH(object_id, '/') connect_path,
983: connect_by_isleaf leaf_node
984: FROM pa_ppr_obj_tmp r
985: START WITH r.parent_object_id is null CONNECT BY
986: PRIOR r.object_id = r.parent_object_id ;
987:
988:

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:

Line 1244: delete from pa_ppr_obj_tmp;

1240: end if;
1241:
1242: -- TASK Hierarchy details
1243:
1244: delete from pa_ppr_obj_tmp;
1245:
1246: if ( p_fact_slice in ( 'WBS', 'RBS_TO_WBS','CBS_TO_WBS' ) ) then
1247:
1248: if ( l_version_type = 'WORKPLAN' ) then

Line 1261: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )

1257:
1258: */
1259:
1260:
1261: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
1262: select /*+ ordered */
1263: a.proj_element_id , nvl(c.proj_element_id,l_struct_elem_id)
1264: from PA_PROJ_ELEMENT_VERSIONS a , pa_object_relationships b , PA_PROJ_ELEMENT_VERSIONS c
1265: where a.project_id = l_project_id

Line 1273: insert into pa_ppr_obj_tmp ( object_id , parent_object_id ) values ( l_struct_elem_id , null );

1269: and b.object_type_From (+) = 'PA_TASKS'
1270: and b.relationship_type (+) = 'S'
1271: and b.object_id_from1 = c.element_version_id (+) ;
1272:
1273: insert into pa_ppr_obj_tmp ( object_id , parent_object_id ) values ( l_struct_elem_id , null );
1274:
1275:
1276: elsif ( l_version_type = 'FINANCIAL' ) then
1277:

Line 1283: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )

1279: -- For budgets pa_tasks can be used directly
1280:
1281: ppr_log('TASKS INSERTED ',0);
1282:
1283: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
1284: select /*+ ordered */
1285: p.task_id , nvl(p.parent_task_id, l_struct_elem_id )
1286: from pa_tasks p
1287: where p.project_id = l_project_id ;

Line 1289: insert into pa_ppr_obj_tmp ( object_id , parent_object_id ) values ( l_struct_elem_id , null );

1285: p.task_id , nvl(p.parent_task_id, l_struct_elem_id )
1286: from pa_tasks p
1287: where p.project_id = l_project_id ;
1288:
1289: insert into pa_ppr_obj_tmp ( object_id , parent_object_id ) values ( l_struct_elem_id , null );
1290:
1291: end if;
1292:
1293: elsif p_fact_slice in ( 'RBS' ,'CBS','WBS_TO_RBS','CBS_TO_RBS','WBS_TO_CBS', 'WBS_TO_CBS_TO_RBS', 'CBS_TO_WBS_TO_RBS' ) then

Line 1298: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )

1294:
1295: ppr_log('into RBS ',0);
1296:
1297: l_struct_elem_id := 0;
1298: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
1299: select rbs_element_id , nvl(parent_element_id,l_rbs_cbs_version_id)
1300: from pa_rbs_elements
1301: where rbs_version_id = l_rbs_cbs_version_id;
1302:

Line 1303: ppr_log('first Insert into pa_ppr_obj_tmp '||SQL%rowcount,0);

1299: select rbs_element_id , nvl(parent_element_id,l_rbs_cbs_version_id)
1300: from pa_rbs_elements
1301: where rbs_version_id = l_rbs_cbs_version_id;
1302:
1303: ppr_log('first Insert into pa_ppr_obj_tmp '||SQL%rowcount,0);
1304: insert into pa_ppr_obj_tmp ( object_id , parent_object_id ) values ( l_rbs_cbs_version_id , null );
1305:
1306: ppr_log('second Inserted into pa_ppr_obj_tmp '||SQL%rowcount,0);
1307: end if;

Line 1304: insert into pa_ppr_obj_tmp ( object_id , parent_object_id ) values ( l_rbs_cbs_version_id , null );

1300: from pa_rbs_elements
1301: where rbs_version_id = l_rbs_cbs_version_id;
1302:
1303: ppr_log('first Insert into pa_ppr_obj_tmp '||SQL%rowcount,0);
1304: insert into pa_ppr_obj_tmp ( object_id , parent_object_id ) values ( l_rbs_cbs_version_id , null );
1305:
1306: ppr_log('second Inserted into pa_ppr_obj_tmp '||SQL%rowcount,0);
1307: end if;
1308:

Line 1306: ppr_log('second Inserted into pa_ppr_obj_tmp '||SQL%rowcount,0);

1302:
1303: ppr_log('first Insert into pa_ppr_obj_tmp '||SQL%rowcount,0);
1304: insert into pa_ppr_obj_tmp ( object_id , parent_object_id ) values ( l_rbs_cbs_version_id , null );
1305:
1306: ppr_log('second Inserted into pa_ppr_obj_tmp '||SQL%rowcount,0);
1307: end if;
1308:
1309:
1310:

Line 1320: UPDATE pa_ppr_obj_tmp

1316:
1317: CLOSE c1;
1318:
1319: FORALL k IN 1..l_task_arr.COUNT
1320: UPDATE pa_ppr_obj_tmp
1321: SET connect_path = l_connect_path_arr(k),
1322: leaf_node = l_leaf_node_arr(k),
1323: wbs_rbs_level = l_task_level_arr(k)
1324: WHERE object_id = l_task_arr(k);