[Home] [Help]
3036:
3037: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, l_process,
3038: FND_GLOBAL.CONC_REQUEST_ID);
3039:
3040: PJI_PJP_EXTRACTION_UTILS.SET_WORKER_ID(p_worker_id);
3041:
3042: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PROCESS_RUNNING', 'Y');
3043: -- Putting this insert here, Config Hist in case of resubmit of failed run Bug 5057835
3044: insert into PJI_SYSTEM_CONFIG_HIST
3100: end if;
3101:
3102: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'PRELOAD');
3103:
3104: PJI_PJP_EXTRACTION_UTILS.UPDATE_EXTR_SCOPE;
3105:
3106: -- Moving down the query for l_rbs_ for the stamping of parameters Bug 5057835
3107:
3108: if (l_extraction_type = 'FULL' or
3899:
3900: /* Added for Bug 8708651 */
3901: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');
3902:
3903: PJI_PJP_EXTRACTION_UTILS.SEED_PJI_PJP_STATS(p_worker_id);
3904:
3905: PJI_PJP_SUM_ROLLUP.POPULATE_TIME_DIMENSION(p_worker_id);
3906:
3907: PJI_PJP_EXTRACTION_UTILS.POPULATE_ORG_EXTR_INFO;
3903: PJI_PJP_EXTRACTION_UTILS.SEED_PJI_PJP_STATS(p_worker_id);
3904:
3905: PJI_PJP_SUM_ROLLUP.POPULATE_TIME_DIMENSION(p_worker_id);
3906:
3907: PJI_PJP_EXTRACTION_UTILS.POPULATE_ORG_EXTR_INFO;
3908:
3909: -- implicit commit
3910: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3911: tabname => 'PJI_ORG_EXTR_INFO',
4048: -- if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4049: -- (l_process, 'FROM_PROJECT_ID') = -1 and
4050: -- PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4051: -- (l_process, 'TO_PROJECT_ID') = -1) then
4052: -- PJI_PJP_EXTRACTION_UTILS.ANALYZE_PJP_FACTS;
4053: -- end if;
4054:
4055: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_MAIN.RUN_PROCESS(p_worker_id);');
4056: