[Home] [Help]
2961:
2962: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, l_process,
2963: FND_GLOBAL.CONC_REQUEST_ID);
2964:
2965: PJI_PJP_EXTRACTION_UTILS.SET_WORKER_ID(p_worker_id);
2966:
2967: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PROCESS_RUNNING', 'Y');
2968: -- Putting this insert here, Config Hist in case of resubmit of failed run Bug 5057835
2969: insert into PJI_SYSTEM_CONFIG_HIST
3023: end if;
3024:
3025: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'PRELOAD');
3026:
3027: PJI_PJP_EXTRACTION_UTILS.UPDATE_EXTR_SCOPE;
3028:
3029: -- Moving down the query for l_rbs_ for the stamping of parameters Bug 5057835
3030:
3031: if (l_extraction_type = 'FULL' or
3693:
3694: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3695: (l_process, 'EXTRACTION_TYPE');
3696:
3697: PJI_PJP_EXTRACTION_UTILS.SEED_PJI_PJP_STATS(p_worker_id);
3698:
3699: PJI_PJP_SUM_ROLLUP.POPULATE_TIME_DIMENSION(p_worker_id);
3700:
3701: PJI_PJP_EXTRACTION_UTILS.POPULATE_ORG_EXTR_INFO;
3697: PJI_PJP_EXTRACTION_UTILS.SEED_PJI_PJP_STATS(p_worker_id);
3698:
3699: PJI_PJP_SUM_ROLLUP.POPULATE_TIME_DIMENSION(p_worker_id);
3700:
3701: PJI_PJP_EXTRACTION_UTILS.POPULATE_ORG_EXTR_INFO;
3702:
3703: -- implicit commit
3704: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3705: tabname => 'PJI_ORG_EXTR_INFO',
3820: -- if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3821: -- (l_process, 'FROM_PROJECT_ID') = -1 and
3822: -- PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3823: -- (l_process, 'TO_PROJECT_ID') = -1) then
3824: -- PJI_PJP_EXTRACTION_UTILS.ANALYZE_PJP_FACTS;
3825: -- end if;
3826:
3827: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_MAIN.RUN_PROCESS(p_worker_id);');
3828: