DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PJI_SYSTEM_PARAMETERS

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

4383: l_worker_id := 1;
4384: l_process := PJI_PJP_SUM_MAIN.g_process || l_worker_id;
4385: l_extr_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE; PRINT_TIME ( ' FPM_UPGRADE_INITIALIZE 001 ' ) ;
4386:
4387: Pji_utils.set_parameter(c_upgr_proc_name, 'P'); -- table pji_system_parameters
4388: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE', 'FULL'); -- table pji_system_parameters
4389: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PROCESS_RUNNING', 'Y'); -- table pji_system_parameters
4390: PJI_PJP_EXTRACTION_UTILS.SET_WORKER_ID(l_worker_id); -- Private global pkg var: PJI_PJP_EXTRACTION_UTILS.g_worker_id.
4391:

Line 4388: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE', 'FULL'); -- table pji_system_parameters

4384: l_process := PJI_PJP_SUM_MAIN.g_process || l_worker_id;
4385: l_extr_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE; PRINT_TIME ( ' FPM_UPGRADE_INITIALIZE 001 ' ) ;
4386:
4387: Pji_utils.set_parameter(c_upgr_proc_name, 'P'); -- table pji_system_parameters
4388: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE', 'FULL'); -- table pji_system_parameters
4389: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PROCESS_RUNNING', 'Y'); -- table pji_system_parameters
4390: PJI_PJP_EXTRACTION_UTILS.SET_WORKER_ID(l_worker_id); -- Private global pkg var: PJI_PJP_EXTRACTION_UTILS.g_worker_id.
4391:
4392: PRINT_TIME ( ' FPM_UPGRADE_INITIALIZE 002 ' ) ;

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

4385: l_extr_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE; PRINT_TIME ( ' FPM_UPGRADE_INITIALIZE 001 ' ) ;
4386:
4387: Pji_utils.set_parameter(c_upgr_proc_name, 'P'); -- table pji_system_parameters
4388: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE', 'FULL'); -- table pji_system_parameters
4389: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PROCESS_RUNNING', 'Y'); -- table pji_system_parameters
4390: PJI_PJP_EXTRACTION_UTILS.SET_WORKER_ID(l_worker_id); -- Private global pkg var: PJI_PJP_EXTRACTION_UTILS.g_worker_id.
4391:
4392: PRINT_TIME ( ' FPM_UPGRADE_INITIALIZE 002 ' ) ;
4393:

Line 4505: DELETE FROM pji_system_parameters

4501: -- before new actuals are entered in the system.
4502: -- Use: If the value of this param is 'Y', then etc from get plan res actuals will
4503: -- be extracted during FULL sumz.
4504:
4505: DELETE FROM pji_system_parameters
4506: WHERE name = 'EXTRACT_ETC_FULLLOAD';
4507:
4508: INSERT INTO pji_system_parameters ( name, value )
4509: VALUES ( 'EXTRACT_ETC_FULLLOAD' , 'N' );

Line 4508: INSERT INTO pji_system_parameters ( name, value )

4504:
4505: DELETE FROM pji_system_parameters
4506: WHERE name = 'EXTRACT_ETC_FULLLOAD';
4507:
4508: INSERT INTO pji_system_parameters ( name, value )
4509: VALUES ( 'EXTRACT_ETC_FULLLOAD' , 'N' );
4510:
4511: commit;
4512: