APPS.PJI_FM_SUM_ROLLUP_ACT dependencies on FND_STATS

Line 2763: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,

2759: l_p_degree := 0;
2760: end if;
2761:
2762: /* Stats gathered for this table in costing mviews refresh.
2763: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
2764: TABNAME => 'PJI_ORG_DENORM',
2765: PERCENT => 10,
2766: DEGREE => l_p_degree);
2767: */

Line 2781: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,

2777: 'PJI_AC_ORGO_F_MV',
2778: 'C',
2779: 'N');
2780: else
2781: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
2782: TABNAME => 'MLOG$_PJI_AC_PROJ_F',
2783: PERCENT => 10,
2784: DEGREE => l_p_degree);
2785: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

Line 2790: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,

2786: l_retcode,
2787: 'PJI_AC_ORG_F_MV',
2788: 'F',
2789: 'N');
2790: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
2791: TABNAME => 'MLOG$_PJI_AC_ORG_F_MV',
2792: PERCENT => 10,
2793: DEGREE => l_p_degree);
2794: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

Line 2802: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

2798: 'N');
2799: end if;
2800:
2801: if (l_extraction_type <> 'INCREMENTAL') then
2802: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
2803: tabname => 'PJI_AC_ORG_F_MV',
2804: percent => 10,
2805: degree => l_p_degree);
2806: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

Line 2806: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

2802: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
2803: tabname => 'PJI_AC_ORG_F_MV',
2804: percent => 10,
2805: degree => l_p_degree);
2806: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
2807: tabname => 'PJI_AC_ORGO_F_MV',
2808: percent => 10,
2809: degree => l_p_degree);
2810: end if;

Line 2865: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,

2861: l_p_degree := 0;
2862: end if;
2863:
2864: /* Stats gathered for this table in costing mviews refresh.
2865: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
2866: TABNAME => 'PJI_PROJECT_CLASSES',
2867: PERCENT => 10,
2868: DEGREE => l_p_degree);
2869: */

Line 2888: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,

2884: l_retcode,
2885: 'PJI_AC_CLS_F_MV',
2886: 'F',
2887: 'N');
2888: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
2889: TABNAME => 'MLOG$_PJI_AC_CLS_F_MV',
2890: PERCENT => 10,
2891: DEGREE => l_p_degree);
2892: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

Line 2900: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

2896: 'N');
2897: end if;
2898:
2899: if (l_extraction_type <> 'INCREMENTAL') then
2900: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
2901: tabname => 'PJI_AC_CLS_F_MV',
2902: percent => 10,
2903: degree => l_p_degree);
2904: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

Line 2904: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

2900: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
2901: tabname => 'PJI_AC_CLS_F_MV',
2902: percent => 10,
2903: degree => l_p_degree);
2904: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
2905: tabname => 'PJI_AC_CLSO_F_MV',
2906: percent => 10,
2907: degree => l_p_degree);
2908: end if;