DBA Data[Home] [Help]

APPS.PJI_RM_SUM_EXTR dependencies on PJI_RM_SUM_ROLLUP_RES

Line 1677: PJI_RM_SUM_ROLLUP_RES.CLEANUP(p_worker_id);

1673: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
1674:
1675: PJI_PJ_PROJ_CLASS_EXTR.CLEANUP(p_worker_id);
1676: PJI_FM_PLAN_EXTR.CLEANUP(p_worker_id);
1677: PJI_RM_SUM_ROLLUP_RES.CLEANUP(p_worker_id);
1678:
1679: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
1680: 'PJI_RM_REXT_FCSTITEM',
1681: 'NORMAL',

Line 1813: PJI_RM_SUM_ROLLUP_RES.JOB_NONUTIL2UTIL(p_worker_id);

1809: PJI_PJ_PROJ_CLASS_EXTR.EXTR_PROJECT_CLASSES(p_worker_id);
1810:
1811: PJI_RM_SUM_EXTR.PROCESS_DANGLING_ROWS(p_worker_id);
1812: PJI_RM_SUM_EXTR.PURGE_DANGLING_ROWS(p_worker_id);
1813: PJI_RM_SUM_ROLLUP_RES.JOB_NONUTIL2UTIL(p_worker_id);
1814: PJI_RM_SUM_EXTR.EXTRACT_BATCH_FID_ROWIDS(p_worker_id);
1815:
1816: PJI_RM_SUM_EXTR.MARK_EXTRACTED_ROWS_PRE(p_worker_id);
1817: if (not PJI_PROCESS_UTIL.WAIT_FOR_STEP

Line 1833: PJI_RM_SUM_ROLLUP_RES.CALC_RMS_AVL_AND_WT(p_worker_id);

1829: PJI_RM_SUM_EXTR.PURGE_RES_DATA(p_worker_id);
1830: PJI_RM_SUM_EXTR.GET_JOB_ID_LOOKUPS(p_worker_id);
1831: PJI_RM_SUM_EXTR.PROCESS_JOB_ID(p_worker_id);
1832:
1833: PJI_RM_SUM_ROLLUP_RES.CALC_RMS_AVL_AND_WT(p_worker_id);
1834:
1835: PJI_RM_SUM_AVL.INS_INTO_RES_STATUS(p_worker_id);
1836: if (not PJI_PROCESS_UTIL.WAIT_FOR_STEP
1837: (PJI_RM_SUM_MAIN.g_process,

Line 1858: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_EN(p_worker_id);

1854: PJI_FM_SUM_ROLLUP_ACT.ACT_ROWID_TABLE(p_worker_id);
1855: PJI_FM_SUM_ROLLUP_ACT.AGGREGATE_ACT_SLICES(p_worker_id);
1856: PJI_FM_SUM_ROLLUP_ACT.PURGE_ACT_DATA(p_worker_id);
1857:
1858: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_EN(p_worker_id);
1859: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_PA(p_worker_id);
1860: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_GL(p_worker_id);
1861: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_WK(p_worker_id);
1862: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_EN(p_worker_id);

Line 1859: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_PA(p_worker_id);

1855: PJI_FM_SUM_ROLLUP_ACT.AGGREGATE_ACT_SLICES(p_worker_id);
1856: PJI_FM_SUM_ROLLUP_ACT.PURGE_ACT_DATA(p_worker_id);
1857:
1858: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_EN(p_worker_id);
1859: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_PA(p_worker_id);
1860: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_GL(p_worker_id);
1861: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_WK(p_worker_id);
1862: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_EN(p_worker_id);
1863: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_PA(p_worker_id);

Line 1860: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_GL(p_worker_id);

1856: PJI_FM_SUM_ROLLUP_ACT.PURGE_ACT_DATA(p_worker_id);
1857:
1858: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_EN(p_worker_id);
1859: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_PA(p_worker_id);
1860: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_GL(p_worker_id);
1861: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_WK(p_worker_id);
1862: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_EN(p_worker_id);
1863: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_PA(p_worker_id);
1864: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_GL(p_worker_id);

Line 1861: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_WK(p_worker_id);

1857:
1858: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_EN(p_worker_id);
1859: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_PA(p_worker_id);
1860: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_GL(p_worker_id);
1861: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_WK(p_worker_id);
1862: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_EN(p_worker_id);
1863: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_PA(p_worker_id);
1864: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_GL(p_worker_id);
1865: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_WK(p_worker_id);

Line 1862: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_EN(p_worker_id);

1858: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_EN(p_worker_id);
1859: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_PA(p_worker_id);
1860: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_GL(p_worker_id);
1861: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_WK(p_worker_id);
1862: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_EN(p_worker_id);
1863: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_PA(p_worker_id);
1864: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_GL(p_worker_id);
1865: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_WK(p_worker_id);
1866:

Line 1863: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_PA(p_worker_id);

1859: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_PA(p_worker_id);
1860: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_GL(p_worker_id);
1861: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_WK(p_worker_id);
1862: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_EN(p_worker_id);
1863: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_PA(p_worker_id);
1864: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_GL(p_worker_id);
1865: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_WK(p_worker_id);
1866:
1867: PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_EN(p_worker_id);

Line 1864: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_GL(p_worker_id);

1860: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_GL(p_worker_id);
1861: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_WK(p_worker_id);
1862: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_EN(p_worker_id);
1863: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_PA(p_worker_id);
1864: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_GL(p_worker_id);
1865: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_WK(p_worker_id);
1866:
1867: PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_EN(p_worker_id);
1868: PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_PA(p_worker_id);

Line 1865: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_WK(p_worker_id);

1861: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_WK(p_worker_id);
1862: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_EN(p_worker_id);
1863: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_PA(p_worker_id);
1864: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_GL(p_worker_id);
1865: PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_WK(p_worker_id);
1866:
1867: PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_EN(p_worker_id);
1868: PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_PA(p_worker_id);
1869: PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_GL(p_worker_id);

Line 1885: PJI_RM_SUM_ROLLUP_RES.MERGE_TMP1_INTO_RMR(p_worker_id);

1881: PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_PA(p_worker_id, 'N');
1882: PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_GL(p_worker_id, 'N');
1883: PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_WK(p_worker_id, 'N');
1884:
1885: PJI_RM_SUM_ROLLUP_RES.MERGE_TMP1_INTO_RMR(p_worker_id);
1886: PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMR(p_worker_id);
1887: PJI_RM_SUM_ROLLUP_RES.MERGE_TMP2_INTO_RMS(p_worker_id);
1888: PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMS(p_worker_id);
1889:

Line 1886: PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMR(p_worker_id);

1882: PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_GL(p_worker_id, 'N');
1883: PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_WK(p_worker_id, 'N');
1884:
1885: PJI_RM_SUM_ROLLUP_RES.MERGE_TMP1_INTO_RMR(p_worker_id);
1886: PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMR(p_worker_id);
1887: PJI_RM_SUM_ROLLUP_RES.MERGE_TMP2_INTO_RMS(p_worker_id);
1888: PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMS(p_worker_id);
1889:
1890: PJI_RM_SUM_AVL.UPDATE_RES_STA_FOR_RUN2(p_worker_id);

Line 1887: PJI_RM_SUM_ROLLUP_RES.MERGE_TMP2_INTO_RMS(p_worker_id);

1883: PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_WK(p_worker_id, 'N');
1884:
1885: PJI_RM_SUM_ROLLUP_RES.MERGE_TMP1_INTO_RMR(p_worker_id);
1886: PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMR(p_worker_id);
1887: PJI_RM_SUM_ROLLUP_RES.MERGE_TMP2_INTO_RMS(p_worker_id);
1888: PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMS(p_worker_id);
1889:
1890: PJI_RM_SUM_AVL.UPDATE_RES_STA_FOR_RUN2(p_worker_id);
1891: if (not PJI_PROCESS_UTIL.WAIT_FOR_STEP

Line 1888: PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMS(p_worker_id);

1884:
1885: PJI_RM_SUM_ROLLUP_RES.MERGE_TMP1_INTO_RMR(p_worker_id);
1886: PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMR(p_worker_id);
1887: PJI_RM_SUM_ROLLUP_RES.MERGE_TMP2_INTO_RMS(p_worker_id);
1888: PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMS(p_worker_id);
1889:
1890: PJI_RM_SUM_AVL.UPDATE_RES_STA_FOR_RUN2(p_worker_id);
1891: if (not PJI_PROCESS_UTIL.WAIT_FOR_STEP
1892: (PJI_RM_SUM_MAIN.g_process,

Line 1925: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTW(p_worker_id);

1921:
1922: PJI_FM_SUM_ROLLUP_FIN.PROJECT_ORGANIZATION(p_worker_id);
1923: PJI_FM_SUM_ROLLUP_ACT.PROJECT_ORGANIZATION(p_worker_id);
1924:
1925: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTW(p_worker_id);
1926: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTX(p_worker_id);
1927: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTJ(p_worker_id);
1928:
1929: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME(p_worker_id);

Line 1926: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTX(p_worker_id);

1922: PJI_FM_SUM_ROLLUP_FIN.PROJECT_ORGANIZATION(p_worker_id);
1923: PJI_FM_SUM_ROLLUP_ACT.PROJECT_ORGANIZATION(p_worker_id);
1924:
1925: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTW(p_worker_id);
1926: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTX(p_worker_id);
1927: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTJ(p_worker_id);
1928:
1929: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME(p_worker_id);
1930: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_DAY(p_worker_id);

Line 1927: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTJ(p_worker_id);

1923: PJI_FM_SUM_ROLLUP_ACT.PROJECT_ORGANIZATION(p_worker_id);
1924:
1925: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTW(p_worker_id);
1926: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTX(p_worker_id);
1927: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTJ(p_worker_id);
1928:
1929: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME(p_worker_id);
1930: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_DAY(p_worker_id);
1931: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_TREND(p_worker_id);

Line 1929: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME(p_worker_id);

1925: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTW(p_worker_id);
1926: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTX(p_worker_id);
1927: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTJ(p_worker_id);
1928:
1929: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME(p_worker_id);
1930: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_DAY(p_worker_id);
1931: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_TREND(p_worker_id);
1932:
1933: PJI_RM_SUM_AVL.REFRESH_AV_ORGO_F_MV(p_worker_id);

Line 1930: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_DAY(p_worker_id);

1926: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTX(p_worker_id);
1927: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTJ(p_worker_id);
1928:
1929: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME(p_worker_id);
1930: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_DAY(p_worker_id);
1931: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_TREND(p_worker_id);
1932:
1933: PJI_RM_SUM_AVL.REFRESH_AV_ORGO_F_MV(p_worker_id);
1934: PJI_RM_SUM_AVL.REFRESH_CA_ORGO_F_MV(p_worker_id);

Line 1931: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_TREND(p_worker_id);

1927: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTJ(p_worker_id);
1928:
1929: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME(p_worker_id);
1930: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_DAY(p_worker_id);
1931: PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_TREND(p_worker_id);
1932:
1933: PJI_RM_SUM_AVL.REFRESH_AV_ORGO_F_MV(p_worker_id);
1934: PJI_RM_SUM_AVL.REFRESH_CA_ORGO_F_MV(p_worker_id);
1935: