DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on 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 3265: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE', 'FULL'); -- table pji_system_parameters

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:
3269: PRINT_TIME ( ' FPM_UPGRADE_INITIALIZE 002 ' ) ;

Line 3266: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PROCESS_RUNNING', 'Y'); -- table pji_system_parameters

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:
3269: PRINT_TIME ( ' FPM_UPGRADE_INITIALIZE 002 ' ) ;
3270:

Line 3382: DELETE FROM pji_system_parameters

3378: -- before new actuals are entered in the system.
3379: -- Use: If the value of this param is 'Y', then etc from get plan res actuals will
3380: -- be extracted during FULL sumz.
3381:
3382: DELETE FROM pji_system_parameters
3383: WHERE name = 'EXTRACT_ETC_FULLLOAD';
3384:
3385: INSERT INTO pji_system_parameters ( name, value )
3386: VALUES ( 'EXTRACT_ETC_FULLLOAD' , 'N' );

Line 3385: INSERT INTO pji_system_parameters ( name, value )

3381:
3382: DELETE FROM pji_system_parameters
3383: WHERE name = 'EXTRACT_ETC_FULLLOAD';
3384:
3385: INSERT INTO pji_system_parameters ( name, value )
3386: VALUES ( 'EXTRACT_ETC_FULLLOAD' , 'N' );
3387:
3388: commit;
3389: