2464: -- Get full refresh value for each of dependent tables
2465: --
2466: dbg('Getting full refresh value for each of dependent tables ...');
2467: --
2468: l_suph_full_refresh := hri_oltp_conc_param.get_parameter_value
2469: (p_parameter_name => 'FULL_REFRESH',
2470: p_process_table_name => 'HRI_CS_SUPH');
2471: l_asgn_full_refresh := hri_oltp_conc_param.get_parameter_value
2472: (p_parameter_name => 'FULL_REFRESH',
2467: --
2468: l_suph_full_refresh := hri_oltp_conc_param.get_parameter_value
2469: (p_parameter_name => 'FULL_REFRESH',
2470: p_process_table_name => 'HRI_CS_SUPH');
2471: l_asgn_full_refresh := hri_oltp_conc_param.get_parameter_value
2472: (p_parameter_name => 'FULL_REFRESH',
2473: p_process_table_name => 'HRI_MB_ASGN_EVENTS_CT');
2474: l_spst_full_refresh := hri_oltp_conc_param.get_parameter_value
2475: (p_parameter_name => 'FULL_REFRESH',
2470: p_process_table_name => 'HRI_CS_SUPH');
2471: l_asgn_full_refresh := hri_oltp_conc_param.get_parameter_value
2472: (p_parameter_name => 'FULL_REFRESH',
2473: p_process_table_name => 'HRI_MB_ASGN_EVENTS_CT');
2474: l_spst_full_refresh := hri_oltp_conc_param.get_parameter_value
2475: (p_parameter_name => 'FULL_REFRESH',
2476: p_process_table_name => 'HRI_CL_WKR_SUP_STATUS_CT');
2477: l_absc_full_refresh := hri_oltp_conc_param.get_parameter_value
2478: (p_parameter_name => 'FULL_REFRESH',
2473: p_process_table_name => 'HRI_MB_ASGN_EVENTS_CT');
2474: l_spst_full_refresh := hri_oltp_conc_param.get_parameter_value
2475: (p_parameter_name => 'FULL_REFRESH',
2476: p_process_table_name => 'HRI_CL_WKR_SUP_STATUS_CT');
2477: l_absc_full_refresh := hri_oltp_conc_param.get_parameter_value
2478: (p_parameter_name => 'FULL_REFRESH',
2479: p_process_table_name => 'HRI_CS_ABSENCE_CT');
2480: --
2481: -- Only do the following if you are in debug mode for information purposes