eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_RM_SUM_EXTR dependencies on PJI_RM_SUM_AVL

Line 1769: PJI_RM_SUM_AVL.UPDATE_RES_STATUS;

1765: indname => 'PJI_ORG_EXTR_INFO_N1',
1766: percent => 10);
1767:
1768: -- Reset status for Availability helper workers
1769: PJI_RM_SUM_AVL.UPDATE_RES_STATUS;
1770:
1771: -- Populate Rolling Week Offset Table if it is not populated
1772: PJI_RM_SUM_AVL.POP_ROLL_WEEK_OFFSET;
1773:

Line 1772: PJI_RM_SUM_AVL.POP_ROLL_WEEK_OFFSET;

1768: -- Reset status for Availability helper workers
1769: PJI_RM_SUM_AVL.UPDATE_RES_STATUS;
1770:
1771: -- Populate Rolling Week Offset Table if it is not populated
1772: PJI_RM_SUM_AVL.POP_ROLL_WEEK_OFFSET;
1773:
1774: PJI_PROCESS_UTIL.CLEAN_HELPER_BATCH_TABLE;
1775:
1776: -- Procedure updates project classification dimension tables

Line 1835: PJI_RM_SUM_AVL.INS_INTO_RES_STATUS(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,
1838: 'PJI_RM_SUM_AVL.START_RES_AVL_CALC_R1(p_worker_id);',
1839: PJI_RM_SUM_MAIN.g_process_delay)) then

Line 1838: 'PJI_RM_SUM_AVL.START_RES_AVL_CALC_R1(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,
1838: 'PJI_RM_SUM_AVL.START_RES_AVL_CALC_R1(p_worker_id);',
1839: PJI_RM_SUM_MAIN.g_process_delay)) then
1840: return;
1841: end if;
1842:

Line 1890: PJI_RM_SUM_AVL.UPDATE_RES_STA_FOR_RUN2(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,
1893: 'PJI_RM_SUM_AVL.START_RES_AVL_CALC_R2(p_worker_id);',
1894: PJI_RM_SUM_MAIN.g_process_delay)) then

Line 1893: 'PJI_RM_SUM_AVL.START_RES_AVL_CALC_R2(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,
1893: 'PJI_RM_SUM_AVL.START_RES_AVL_CALC_R2(p_worker_id);',
1894: PJI_RM_SUM_MAIN.g_process_delay)) then
1895: return;
1896: end if;
1897: PJI_RM_SUM_AVL.MERGE_ORG_AVL_DUR(p_worker_id);

Line 1897: PJI_RM_SUM_AVL.MERGE_ORG_AVL_DUR(p_worker_id);

1893: 'PJI_RM_SUM_AVL.START_RES_AVL_CALC_R2(p_worker_id);',
1894: PJI_RM_SUM_MAIN.g_process_delay)) then
1895: return;
1896: end if;
1897: PJI_RM_SUM_AVL.MERGE_ORG_AVL_DUR(p_worker_id);
1898: PJI_RM_SUM_AVL.MERGE_CURR_ORG_AVL(p_worker_id);
1899: PJI_RM_SUM_AVL.RES_CALC_CLEANUP(p_worker_id);
1900:
1901: PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPW(p_worker_id);

Line 1898: PJI_RM_SUM_AVL.MERGE_CURR_ORG_AVL(p_worker_id);

1894: PJI_RM_SUM_MAIN.g_process_delay)) then
1895: return;
1896: end if;
1897: PJI_RM_SUM_AVL.MERGE_ORG_AVL_DUR(p_worker_id);
1898: PJI_RM_SUM_AVL.MERGE_CURR_ORG_AVL(p_worker_id);
1899: PJI_RM_SUM_AVL.RES_CALC_CLEANUP(p_worker_id);
1900:
1901: PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPW(p_worker_id);
1902: PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPE(p_worker_id);

Line 1899: PJI_RM_SUM_AVL.RES_CALC_CLEANUP(p_worker_id);

1895: return;
1896: end if;
1897: PJI_RM_SUM_AVL.MERGE_ORG_AVL_DUR(p_worker_id);
1898: PJI_RM_SUM_AVL.MERGE_CURR_ORG_AVL(p_worker_id);
1899: PJI_RM_SUM_AVL.RES_CALC_CLEANUP(p_worker_id);
1900:
1901: PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPW(p_worker_id);
1902: PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPE(p_worker_id);
1903: PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPP(p_worker_id);

Line 1933: PJI_RM_SUM_AVL.REFRESH_AV_ORGO_F_MV(p_worker_id);

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:
1936: PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FWO(p_worker_id);
1937: PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FWC(p_worker_id);

Line 1934: PJI_RM_SUM_AVL.REFRESH_CA_ORGO_F_MV(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:
1936: PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FWO(p_worker_id);
1937: PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FWC(p_worker_id);
1938: PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FEO(p_worker_id);

Line 2000: 'PJI_RM_SUM_AVL.INS_INTO_RES_STATUS(p_worker_id);',

1996: PJI_RM_SUM_EXTR.MARK_EXTRACTED_ROWS(p_worker_id);
1997:
1998: if (not PJI_PROCESS_UTIL.WAIT_FOR_STEP
1999: (PJI_RM_SUM_MAIN.g_process,
2000: 'PJI_RM_SUM_AVL.INS_INTO_RES_STATUS(p_worker_id);',
2001: PJI_RM_SUM_MAIN.g_process_delay)) then
2002: return;
2003: end if;
2004:

Line 2005: PJI_RM_SUM_AVL.START_RES_AVL_CALC_R1(p_worker_id);

2001: PJI_RM_SUM_MAIN.g_process_delay)) then
2002: return;
2003: end if;
2004:
2005: PJI_RM_SUM_AVL.START_RES_AVL_CALC_R1(p_worker_id);
2006:
2007: if (not PJI_PROCESS_UTIL.WAIT_FOR_STEP
2008: (PJI_RM_SUM_MAIN.g_process,
2009: 'PJI_RM_SUM_AVL.UPDATE_RES_STA_FOR_RUN2(p_worker_id);',

Line 2009: 'PJI_RM_SUM_AVL.UPDATE_RES_STA_FOR_RUN2(p_worker_id);',

2005: PJI_RM_SUM_AVL.START_RES_AVL_CALC_R1(p_worker_id);
2006:
2007: if (not PJI_PROCESS_UTIL.WAIT_FOR_STEP
2008: (PJI_RM_SUM_MAIN.g_process,
2009: 'PJI_RM_SUM_AVL.UPDATE_RES_STA_FOR_RUN2(p_worker_id);',
2010: PJI_RM_SUM_MAIN.g_process_delay)) then
2011: return;
2012: end if;
2013:

Line 2014: PJI_RM_SUM_AVL.START_RES_AVL_CALC_R2(p_worker_id);

2010: PJI_RM_SUM_MAIN.g_process_delay)) then
2011: return;
2012: end if;
2013:
2014: PJI_RM_SUM_AVL.START_RES_AVL_CALC_R2(p_worker_id);
2015:
2016: if (not PJI_PROCESS_UTIL.WAIT_FOR_STEP
2017: (PJI_RM_SUM_MAIN.g_process,
2018: 'PJI_FM_SUM_BKLG.CLEANUP_INT_TABLE(p_worker_id);',