eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EFC_REPORTING SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 121


    elsif p_label = 'DELETEDINFO' then
      --
      return 'Deleted Data';

Line: 162


      return 'NOPILPERSON: The person associated with the life event has been deleted. '
             ||'An EFC adjustment cannot be performed. ';

Line: 224


      return 'Deleted option in plan';

Line: 232


             ||' been deleted. ';

Line: 240


      return 'Deleted actual premium';

Line: 251


      return 'Deleted enrolment result';

Line: 468


  hr_efc_info.insert_line('-- ');

Line: 469


  hr_efc_info.insert_line('-- '||l_ent_desc||' details ');

Line: 470


  hr_efc_info.insert_line('-- ');

Line: 482


    l_dupval_set.delete;

Line: 484


    l_dup_success_val_set.delete;

Line: 485


    l_unq_success_val_set.delete;

Line: 540


    l_dupval_set.delete;

Line: 541


    l_dup_excl_val_set.delete;

Line: 542


    l_unq_excl_val_set.delete;

Line: 593


      l_unq_excl_val_set.delete;

Line: 671


      hr_efc_info.insert_line('-- Convertable rows: '||l_tabrow_count);

Line: 672


      hr_efc_info.insert_line('-- Converted rows: '||l_conv_count);

Line: 673


      hr_efc_info.insert_line('-- Adjustable rows: '||l_adjust_count);

Line: 674


      hr_efc_info.insert_line('-- ');

Line: 678


    hr_efc_info.insert_line('-- Successfully Adjusted rows: '||l_succ_count||' '||l_succ_perc||'% ');

Line: 682


      hr_efc_info.insert_line('--   Duplicate Succ rows: '||l_dupsuccval_count);

Line: 686


    hr_efc_info.insert_line('-- Application errors: '||l_rco_count||' '||l_rco_perc||'% ');

Line: 687


    hr_efc_info.insert_line('-- Non Excluded failure rows: '||l_fail_count||' '||l_fail_perc||'% ');

Line: 688


    hr_efc_info.insert_line('-- Exclusion rows: '||l_excl_count||' '||l_excl_perc||'% ');

Line: 692


      hr_efc_info.insert_line('--   Duplicate Exclusion rows: '||l_dupexclval_count);

Line: 696


    hr_efc_info.insert_line('-- ');

Line: 702


    hr_efc_info.insert_line('-- '||p_rcoerr_val_set.count||' Application errors ');

Line: 703


    hr_efc_info.insert_line('-- ');

Line: 709


      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')
                          );

Line: 717


      hr_efc_info.insert_line(' '||substr(p_rcoerr_val_set(errele_num).sql_error,1,240)
                          );

Line: 721


    hr_efc_info.insert_line('-- ');

Line: 727


    hr_efc_info.insert_line('-- '||p_failed_adj_val_set.count||' Adjustment failures ');

Line: 728


    hr_efc_info.insert_line('-- ');

Line: 734


      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
                          );

Line: 751


    hr_efc_info.insert_line('-- ');

Line: 759


    l_unqval_set.delete;

Line: 855


      l_unqtype_set.delete;

Line: 930


      hr_efc_info.insert_line('-- '||l_unqtype_set.count||' Exclusion Type Categories ');

Line: 931


      hr_efc_info.insert_line('-- ');

Line: 947


        hr_efc_info.insert_line(l_disp_str
                               );

Line: 951


      hr_efc_info.insert_line('-- ');

Line: 959


      hr_efc_info.insert_line('-- '||l_unqval_set.count||' Exclusion Types ');

Line: 960


      hr_efc_info.insert_line('-- ');

Line: 977


        hr_efc_info.insert_line(l_disp_str
                               );

Line: 981


      hr_efc_info.insert_line('-- ');

Line: 987


      hr_efc_info.insert_line('-- '||l_fatal_error_val_set.count||' Exclusions ');

Line: 988


      hr_efc_info.insert_line('-- ');

Line: 994


        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
                            );

Line: 1016


      hr_efc_info.insert_line('-- ');

Line: 1020


        hr_efc_info.insert_line('-- '||l_dup_excl_val_set.count||' Duplicate Exclusions ');

Line: 1021


        hr_efc_info.insert_line('-- ');

Line: 1027


          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
                              );

Line: 1051


      hr_efc_info.insert_line('-- ');

Line: 1061


    hr_efc_info.insert_line('-- '||l_success_val_set.count||' Successes ');

Line: 1062


    hr_efc_info.insert_line('-- ');

Line: 1068


      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
                          );

Line: 1088


    hr_efc_info.insert_line('-- ');

Line: 1092


      hr_efc_info.insert_line('-- '||l_dup_success_val_set.count||' Duplicate Successes ');

Line: 1093


      hr_efc_info.insert_line('-- ');

Line: 1098


        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
                            );

Line: 1117


      hr_efc_info.insert_line('-- ');