DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT dependencies on PJI_FP_XBS_ACCUM_F

Line 533: -- 13. ... insert data in pjp1 into pji_fp_xbs_accum_f.

529: -- PRINT_TBL_SIZE;
530:
531:
532: --
533: -- 13. ... insert data in pjp1 into pji_fp_xbs_accum_f.
534: --
535: PJI_PJP_SUM_ROLLUP.INSERT_INTO_FP_FACT(l_worker_id);
536: l_count := l_count + 1;
537: print_time('FPM Upgr ' || l_count);

Line 903: -- fnd_stats.gather_table_stats('PJI','PJI_FP_XBS_ACCUM_F',PERCENT=>40);

899:
900: -- Bug 15881881
901: fnd_stats.gather_table_stats('PJI','PJI_FP_AGGR_PJP1',PERCENT=>40);
902: -- Commented for bug 16360282
903: -- fnd_stats.gather_table_stats('PJI','PJI_FP_XBS_ACCUM_F',PERCENT=>40);
904: -- End Bug 15881881
905:
906: Pji_Fm_Plan_Maint_Pvt.EXTRACT_DANGL_REVERSAL;
907: print_time(' Inserted Reversal records for dangling plans.');

Line 1150: DELETE FROM PJI_FP_XBS_ACCUM_F

1146:
1147: /* Added for bug 8708651 */
1148: BEGIN
1149: FORALL i IN 1..p_fp_version_ids.COUNT
1150: DELETE FROM PJI_FP_XBS_ACCUM_F
1151: WHERE plan_version_id = p_fp_version_ids(i)
1152: AND project_id = l_project_ids(i);
1153: EXCEPTION
1154: WHEN NO_DATA_FOUND THEN