DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PJI_UTILS

Line 3262: l_extr_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE; PRINT_TIME ( ' FPM_UPGRADE_INITIALIZE 001 ' ) ;

3258: , x_return_status => l_return_status );
3259:
3260: l_worker_id := 1;
3261: l_process := PJI_PJP_SUM_MAIN.g_process || l_worker_id;
3262: l_extr_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE; PRINT_TIME ( ' FPM_UPGRADE_INITIALIZE 001 ' ) ;
3263:
3264: Pji_utils.set_parameter(c_upgr_proc_name, 'P'); -- table pji_system_parameters
3265: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE', 'FULL'); -- table pji_system_parameters
3266: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PROCESS_RUNNING', 'Y'); -- table pji_system_parameters

Line 3264: Pji_utils.set_parameter(c_upgr_proc_name, 'P'); -- table pji_system_parameters

3260: l_worker_id := 1;
3261: l_process := PJI_PJP_SUM_MAIN.g_process || l_worker_id;
3262: l_extr_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE; PRINT_TIME ( ' FPM_UPGRADE_INITIALIZE 001 ' ) ;
3263:
3264: Pji_utils.set_parameter(c_upgr_proc_name, 'P'); -- table pji_system_parameters
3265: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE', 'FULL'); -- table pji_system_parameters
3266: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PROCESS_RUNNING', 'Y'); -- table pji_system_parameters
3267: PJI_PJP_EXTRACTION_UTILS.SET_WORKER_ID(l_worker_id); -- Private global pkg var: PJI_PJP_EXTRACTION_UTILS.g_worker_id.
3268:

Line 3348: SELECT PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG') , PJI_UTILS.GET_SETUP_PARAMETER('GL_PERIOD_FLAG')

3344: where ver.BUDGET_TYPE_CODE is null);
3345:
3346: PRINT_TIME ( ' FPM_UPGRADE_INITIALIZE 004 ' ) ;
3347:
3348: SELECT PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG') , PJI_UTILS.GET_SETUP_PARAMETER('GL_PERIOD_FLAG')
3349: INTO l_pa_period_flag, l_gl_period_flag
3350: FROM DUAL;
3351:
3352: if (l_pa_period_flag = 'N') then

Line 3418: l_extr_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;

3414: , x_return_status => l_return_status );
3415:
3416: l_worker_id := 1;
3417: l_process := PJI_PJP_SUM_MAIN.g_process || l_worker_id;
3418: l_extr_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;
3419:
3420: PJI_PJP_SUM_ROLLUP.CLEANUP(l_worker_id);
3421:
3422: Pji_utils.set_parameter('PJI_FPM_UPGRADE', 'C');

Line 3422: Pji_utils.set_parameter('PJI_FPM_UPGRADE', 'C');

3418: l_extr_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;
3419:
3420: PJI_PJP_SUM_ROLLUP.CLEANUP(l_worker_id);
3421:
3422: Pji_utils.set_parameter('PJI_FPM_UPGRADE', 'C');
3423:
3424: PJI_PROCESS_UTIL.WRAPUP_PROCESS(l_process);
3425:
3426: update PJI_SYSTEM_CONFIG_HIST

Line 3433: PJI_UTILS.SET_PARAMETER('PJP_FPM_UPGRADE_DATE',

3429: where PROCESS_NAME = l_process and
3430: RUN_TYPE = 'FPM_UPGRADE' and
3431: END_DATE is null;
3432:
3433: PJI_UTILS.SET_PARAMETER('PJP_FPM_UPGRADE_DATE',
3434: to_char(sysdate, PJI_PJP_SUM_MAIN.g_date_mask));
3435:
3436: DELETE FROM PJI_PJP_PROJ_BATCH_MAP WHERE WORKER_ID = l_worker_id;
3437: