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 1112: DELETE FROM PJI_FP_XBS_ACCUM_F

1108: END;
1109: END LOOP;
1110:
1111: FORALL i IN 1..p_fp_version_ids.COUNT
1112: DELETE FROM PJI_FP_XBS_ACCUM_F
1113: WHERE plan_version_id = p_fp_version_ids(i)
1114: AND project_id = l_project_ids(i);
1115:
1116: print_time ( 'deleted from fact. # rows = ' || SQL%ROWCOUNT ) ;