APPS.PJI_REP_UTIL dependencies on PA_PPR_OBJ_TMP_VIEW

Line 316: FROM pa_ppr_obj_tmp_view r

312: cursor c1 is
313: SELECT object_id , LEVEL +1,
314: SYS_CONNECT_BY_PATH(object_id, '/') connect_path,
315: connect_by_isleaf leaf_node
316: FROM pa_ppr_obj_tmp_view r
317: -- OLAP_BUG
318: -- START WITH r.parent_object_id = p_element_version_id CONNECT BY
319: START WITH r.parent_object_id = -1 CONNECT BY
320: PRIOR r.object_id = r.parent_object_id ;

Line 425: FROM pa_ppr_obj_tmp_view

421: l_new_count := 0 ;
422:
423: SELECT COUNT(*)
424: INTO l_new_count
425: FROM pa_ppr_obj_tmp_view
426: WHERE object_id = l_new_elem_id; -- Bug 16507592 ;
427:
428:
429: if ( l_new_count <> 1 ) then

Line 433: delete from pa_ppr_obj_tmp_view;

429: if ( l_new_count <> 1 ) then
430:
431:
432:
433: delete from pa_ppr_obj_tmp_view;
434:
435: insert into pa_ppr_obj_tmp_view ( object_id , parent_object_id )
436: select /*+ ordered */
437: -- OLAP_BUG

Line 435: insert into pa_ppr_obj_tmp_view ( object_id , parent_object_id )

431:
432:
433: delete from pa_ppr_obj_tmp_view;
434:
435: insert into pa_ppr_obj_tmp_view ( object_id , parent_object_id )
436: select /*+ ordered */
437: -- OLAP_BUG
438: -- a.proj_element_id , nvl(c.proj_element_id,p_element_version_id)
439: a.proj_element_id , nvl(c.proj_element_id,l_new_elem_id )

Line 451: insert into pa_ppr_obj_tmp_view ( object_id , parent_object_id ) values ( l_new_elem_id , -1 );

447: and b.object_id_from1 = c.element_version_id (+) ;
448:
449: -- OLAP_BUG
450:
451: insert into pa_ppr_obj_tmp_view ( object_id , parent_object_id ) values ( l_new_elem_id , -1 );
452:
453: l_task_arr.delete;
454: l_task_level_arr.delete;
455: l_connect_path_arr.delete;

Line 469: UPDATE pa_ppr_obj_tmp_view

465:
466:
467:
468: FORALL k IN 1..l_task_arr.COUNT
469: UPDATE pa_ppr_obj_tmp_view
470: SET connect_path = l_connect_path_arr(k),
471: leaf_node = l_leaf_node_arr(k),
472: wbs_rbs_level = l_task_level_arr(k)
473: WHERE object_id = l_task_arr(k);