APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PA_PPR_OBJ_TMP_VIEW

Line 1634: FROM pa_ppr_obj_tmp_view r

1630: cursor c1 is
1631: SELECT object_id , LEVEL +1,
1632: SYS_CONNECT_BY_PATH(object_id, '/') connect_path,
1633: connect_by_isleaf leaf_node
1634: FROM pa_ppr_obj_tmp_view r
1635: -- OLAP_BUG
1636: -- START WITH r.parent_object_id = p_element_version_id CONNECT BY
1637: START WITH r.parent_object_id = l_start_object_id CONNECT BY
1638: PRIOR r.object_id = r.parent_object_id ;

Line 1984: DELETE FROM pa_ppr_obj_tmp_view; --16679474

1980: FROM
1981: PA_PROJ_ELEMENT_VERSIONS
1982: where element_version_id = l_wking_struct_ver_id; -- modified for 16594243
1983:
1984: DELETE FROM pa_ppr_obj_tmp_view; --16679474
1985: insert into pa_ppr_obj_tmp_view ( object_id , parent_object_id )
1986: select /*+ ordered */
1987: distinct a.proj_element_id , nvl(c.proj_element_id,l_new_elem_id ) -- BUG_00
1988: from PA_PROJ_ELEMENT_VERSIONS a , pa_object_relationships b , PA_PROJ_ELEMENT_VERSIONS c

Line 1985: insert into pa_ppr_obj_tmp_view ( object_id , parent_object_id )

1981: PA_PROJ_ELEMENT_VERSIONS
1982: where element_version_id = l_wking_struct_ver_id; -- modified for 16594243
1983:
1984: DELETE FROM pa_ppr_obj_tmp_view; --16679474
1985: insert into pa_ppr_obj_tmp_view ( object_id , parent_object_id )
1986: select /*+ ordered */
1987: distinct a.proj_element_id , nvl(c.proj_element_id,l_new_elem_id ) -- BUG_00
1988: from PA_PROJ_ELEMENT_VERSIONS a , pa_object_relationships b , PA_PROJ_ELEMENT_VERSIONS c
1989: where a.project_id = p_project_id

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

1994: and b.relationship_type (+) = 'S'
1995: and b.object_id_from1 = c.element_version_id (+) ;
1996:
1997:
1998: insert into pa_ppr_obj_tmp_view ( object_id , parent_object_id ) values ( l_new_elem_id , -1 );
1999:
2000: l_task_arr.delete;
2001: l_task_level_arr.delete;
2002: l_connect_path_arr.delete;

Line 2019: UPDATE pa_ppr_obj_tmp_view

2015:
2016: CLOSE c1;
2017:
2018: FORALL k IN 1..l_task_arr.COUNT
2019: UPDATE pa_ppr_obj_tmp_view
2020: SET connect_path = l_connect_path_arr(k),
2021: leaf_node = l_leaf_node_arr(k),
2022: wbs_rbs_level = l_task_level_arr(k)
2023: WHERE object_id = l_task_arr(k);

Line 2841: pa_ppr_obj_tmp_view obj1,

2837: decode (p1.project_currency_code , fact.currency_code,1,0) PRJ_MASK,
2838: decode (p1.projfunc_currency_code , fact.currency_code,1,0) POU_MASK
2839: from
2840: pa_projects_all p1 ,
2841: pa_ppr_obj_tmp_view obj1,
2842: pa_pjt_wbs_fact fact
2843: where 1 = 1
2844: AND p1.project_id = p_project_id
2845: AND fact.project_id = p_project_id