APPS.PJI_REP_UTIL dependencies on PJI_PLAN_EXTR_TMP

Line 904: -- fnd_stats.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);

900: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
901: END IF;
902:
903: BEGIN
904: -- fnd_stats.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
905: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
906: END;
907:
908: DELETE FROM PJI_PLAN_EXTR_TMP;

Line 905: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);

901: END IF;
902:
903: BEGIN
904: -- fnd_stats.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
905: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
906: END;
907:
908: DELETE FROM PJI_PLAN_EXTR_TMP;
909:

Line 908: DELETE FROM PJI_PLAN_EXTR_TMP;

904: -- fnd_stats.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
905: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
906: END;
907:
908: DELETE FROM PJI_PLAN_EXTR_TMP;
909:
910:
911: -- OLAP START V2
912:

Line 923: INSERT INTO PJI_PLAN_EXTR_TMP

919:
920: if l_pjt_rollup_enabled_flag = 'Y' then
921:
922:
923: INSERT INTO PJI_PLAN_EXTR_TMP
924: (PROJECT_ID, PLAN_VER_ID, LPB_PLAN_VER_ID, BASE_PLAN_VER_ID, PLAN1_VER_ID, PLAN2_VER_ID, STRUCT_VER_ID)
925: VALUES
926: (p_project_id, p_current_version_id, p_latest_version_id, p_baselined_version_id, p_plan1_version_id,
927: p_plan2_version_id, p_curr_wbs_vers_id);

Line 933: INSERT INTO PJI_PLAN_EXTR_TMP

929:
930: elsIF p_prg_flag = 'Y' then
931: -- OLAP END V2
932: -- populate the plan versions ids into the temp table for the program hierarchy
933: INSERT INTO PJI_PLAN_EXTR_TMP
934: (PROJECT_ID, PLAN_VER_ID, LPB_PLAN_VER_ID, BASE_PLAN_VER_ID, PLAN1_VER_ID, PLAN2_VER_ID, STRUCT_VER_ID)
935: SELECT
936: header.project_id,
937: MAX(DECODE(header_p.plan_version_id,p_current_version_id,header.plan_version_id,NULL)),

Line 969: INSERT INTO PJI_PLAN_EXTR_TMP

965: AND header.wbs_version_id = denorm.sub_id
966: AND header.wp_flag = 'Y'
967: GROUP BY header.project_id;
968: ELSE
969: INSERT INTO PJI_PLAN_EXTR_TMP
970: (PROJECT_ID, PLAN_VER_ID, LPB_PLAN_VER_ID, BASE_PLAN_VER_ID, PLAN1_VER_ID, PLAN2_VER_ID, STRUCT_VER_ID)
971: VALUES
972: (p_project_id, p_current_version_id, p_latest_version_id, p_baselined_version_id, p_plan1_version_id, p_plan2_version_id, p_curr_wbs_vers_id);
973: END IF;