The following lines contain the word 'select', 'insert', 'update' or 'delete':
elsif p_label = 'DELETEDINFO' then
--
return 'Deleted Data';
return 'NOPILPERSON: The person associated with the life event has been deleted. '
||'An EFC adjustment cannot be performed. ';
return 'Deleted option in plan';
||' been deleted. ';
return 'Deleted actual premium';
return 'Deleted enrolment result';
hr_efc_info.insert_line('-- ');
hr_efc_info.insert_line('-- '||l_ent_desc||' details ');
hr_efc_info.insert_line('-- ');
l_dupval_set.delete;
l_dup_success_val_set.delete;
l_unq_success_val_set.delete;
l_dupval_set.delete;
l_dup_excl_val_set.delete;
l_unq_excl_val_set.delete;
l_unq_excl_val_set.delete;
hr_efc_info.insert_line('-- Convertable rows: '||l_tabrow_count);
hr_efc_info.insert_line('-- Converted rows: '||l_conv_count);
hr_efc_info.insert_line('-- Adjustable rows: '||l_adjust_count);
hr_efc_info.insert_line('-- ');
hr_efc_info.insert_line('-- Successfully Adjusted rows: '||l_succ_count||' '||l_succ_perc||'% ');
hr_efc_info.insert_line('-- Duplicate Succ rows: '||l_dupsuccval_count);
hr_efc_info.insert_line('-- Application errors: '||l_rco_count||' '||l_rco_perc||'% ');
hr_efc_info.insert_line('-- Non Excluded failure rows: '||l_fail_count||' '||l_fail_perc||'% ');
hr_efc_info.insert_line('-- Exclusion rows: '||l_excl_count||' '||l_excl_perc||'% ');
hr_efc_info.insert_line('-- Duplicate Exclusion rows: '||l_dupexclval_count);
hr_efc_info.insert_line('-- ');
hr_efc_info.insert_line('-- '||p_rcoerr_val_set.count||' Application errors ');
hr_efc_info.insert_line('-- ');
hr_efc_info.insert_line(p_rcoerr_val_set(errele_num).id
||' '||p_rcoerr_val_set(errele_num).esd
||' '||p_rcoerr_val_set(errele_num).eed
||' '||p_rcoerr_val_set(errele_num).bgp_id
||' '||p_rcoerr_val_set(errele_num).rco_name
||' '||to_char(p_rcoerr_val_set(errele_num).lud,'DD-MON-YYYY')
);
hr_efc_info.insert_line(' '||substr(p_rcoerr_val_set(errele_num).sql_error,1,240)
);
hr_efc_info.insert_line('-- ');
hr_efc_info.insert_line('-- '||p_failed_adj_val_set.count||' Adjustment failures ');
hr_efc_info.insert_line('-- ');
hr_efc_info.insert_line(p_failed_adj_val_set(errele_num).val_type
||' '||p_failed_adj_val_set(errele_num).id
||' '||p_failed_adj_val_set(errele_num).esd
||' '||p_failed_adj_val_set(errele_num).eed
||' '||p_failed_adj_val_set(errele_num).bgp_id
||' '||nvl(to_char(p_failed_adj_val_set(errele_num).old_val1),'N ')
||' '||nvl(to_char(p_failed_adj_val_set(errele_num).new_val1),'N ')
||' '||nvl(to_char(p_failed_adj_val_set(errele_num).old_val2),'N ')
||' '||nvl(to_char(p_failed_adj_val_set(errele_num).new_val2),'N ')
||' '||nvl(to_char(p_failed_adj_val_set(errele_num).credt,'DD-MON-YYYY'),'NCD ')
||' '||nvl(to_char(p_failed_adj_val_set(errele_num).lud,'DD-MON-YYYY'),'NLUD ')
||' '||p_failed_adj_val_set(errele_num).id1
||' '||p_failed_adj_val_set(errele_num).id2
||' '||p_failed_adj_val_set(errele_num).code1
);
hr_efc_info.insert_line('-- ');
l_unqval_set.delete;
l_unqtype_set.delete;
hr_efc_info.insert_line('-- '||l_unqtype_set.count||' Exclusion Type Categories ');
hr_efc_info.insert_line('-- ');
hr_efc_info.insert_line(l_disp_str
);
hr_efc_info.insert_line('-- ');
hr_efc_info.insert_line('-- '||l_unqval_set.count||' Exclusion Types ');
hr_efc_info.insert_line('-- ');
hr_efc_info.insert_line(l_disp_str
);
hr_efc_info.insert_line('-- ');
hr_efc_info.insert_line('-- '||l_fatal_error_val_set.count||' Exclusions ');
hr_efc_info.insert_line('-- ');
hr_efc_info.insert_line(l_fatal_error_val_set(errele_num).faterr_code
||' '||l_fatal_error_val_set(errele_num).faterr_type
||' '||l_fatal_error_val_set(errele_num).id
||' '||l_fatal_error_val_set(errele_num).esd
||' '||l_fatal_error_val_set(errele_num).val_type
||' '||l_fatal_error_val_set(errele_num).old_val1
||' '||l_fatal_error_val_set(errele_num).new_val1
||' '||l_fatal_error_val_set(errele_num).ovn
||' '||l_fatal_error_val_set(errele_num).bgp_id
||' '||to_char(l_fatal_error_val_set(errele_num).credt,'DD-MON-YYYY')
||' '||to_char(l_fatal_error_val_set(errele_num).lud,'DD-MON-YYYY')
||' '||l_fatal_error_val_set(errele_num).cre_by
||' '||l_fatal_error_val_set(errele_num).lu_by
||' '||l_fatal_error_val_set(errele_num).id1
||' '||l_fatal_error_val_set(errele_num).id2
||' '||l_fatal_error_val_set(errele_num).code1
||' '||l_fatal_error_val_set(errele_num).code2
||' '||l_fatal_error_val_set(errele_num).code3
||' '||l_fatal_error_val_set(errele_num).code4
);
hr_efc_info.insert_line('-- ');
hr_efc_info.insert_line('-- '||l_dup_excl_val_set.count||' Duplicate Exclusions ');
hr_efc_info.insert_line('-- ');
hr_efc_info.insert_line(l_dup_excl_val_set(errele_num).faterr_code
||' '||l_dup_excl_val_set(errele_num).faterr_type
||' '||l_dup_excl_val_set(errele_num).id
||' '||l_dup_excl_val_set(errele_num).esd
||' '||l_dup_excl_val_set(errele_num).val_type
||' '||l_dup_excl_val_set(errele_num).old_val1
||' '||l_dup_excl_val_set(errele_num).new_val1
||' '||l_dup_excl_val_set(errele_num).ovn
||' '||l_dup_excl_val_set(errele_num).bgp_id
||' '||to_char(l_dup_excl_val_set(errele_num).credt,'DD-MON-YYYY')
||' '||to_char(l_dup_excl_val_set(errele_num).lud,'DD-MON-YYYY')
||' '||l_dup_excl_val_set(errele_num).cre_by
||' '||l_dup_excl_val_set(errele_num).lu_by
||' '||l_dup_excl_val_set(errele_num).id1
||' '||l_dup_excl_val_set(errele_num).id2
||' '||l_dup_excl_val_set(errele_num).code1
||' '||l_dup_excl_val_set(errele_num).code2
||' '||l_dup_excl_val_set(errele_num).code3
||' '||l_dup_excl_val_set(errele_num).code4
);
hr_efc_info.insert_line('-- ');
hr_efc_info.insert_line('-- '||l_success_val_set.count||' Successes ');
hr_efc_info.insert_line('-- ');
hr_efc_info.insert_line(l_success_val_set(ele_num).id
||' '||l_success_val_set(ele_num).esd
||' '||l_success_val_set(ele_num).eed
||' '||l_success_val_set(ele_num).old_val1
||' '||l_success_val_set(ele_num).new_val1
||' '||l_success_val_set(ele_num).ovn
||' '||l_success_val_set(ele_num).bgp_id
||' '||to_char(l_success_val_set(ele_num).credt,'DD-MON-YYYY')
||' '||to_char(l_success_val_set(ele_num).lud,'DD-MON-YYYY')
||' '||l_success_val_set(ele_num).cre_by
||' '||l_success_val_set(ele_num).lu_by
||' '||l_success_val_set(ele_num).id1
||' '||l_success_val_set(ele_num).id2
||' '||l_success_val_set(ele_num).code1
||' '||l_success_val_set(ele_num).code2
||' '||l_success_val_set(ele_num).code3
||' '||l_success_val_set(ele_num).code4
);
hr_efc_info.insert_line('-- ');
hr_efc_info.insert_line('-- '||l_dup_success_val_set.count||' Duplicate Successes ');
hr_efc_info.insert_line('-- ');
hr_efc_info.insert_line(l_dup_success_val_set(ele_num).id
||' '||l_dup_success_val_set(ele_num).esd
||' '||l_dup_success_val_set(ele_num).eed
||' '||l_dup_success_val_set(ele_num).old_val1
||' '||l_dup_success_val_set(ele_num).new_val1
||' '||l_dup_success_val_set(ele_num).ovn
||' '||l_dup_success_val_set(ele_num).bgp_id
||' '||to_char(l_dup_success_val_set(ele_num).credt,'DD-MON-YYYY')
||' '||to_char(l_dup_success_val_set(ele_num).lud,'DD-MON-YYYY')
||' '||l_dup_success_val_set(ele_num).cre_by
||' '||l_dup_success_val_set(ele_num).lu_by
||' '||l_dup_success_val_set(ele_num).id2
||' '||l_dup_success_val_set(ele_num).code1
||' '||l_dup_success_val_set(ele_num).code2
||' '||l_dup_success_val_set(ele_num).code3
||' '||l_dup_success_val_set(ele_num).code4
);
hr_efc_info.insert_line('-- ');