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.HRI_OPL_CMPTNC_LVL SQL Statements

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

Line: 119


PROCEDURE recover_insert_rows(p_stored_rows_to_insert NUMBER) IS

BEGIN
  --
  -- loop through rows still to insert one at a time
  --
  FOR i IN 1..p_stored_rows_to_insert LOOP
    --
    -- Trap unique constraint errors
    --
    BEGIN
      --
      -- @@ Code specific to this view/table below
      -- @@ INTRUCTION TO DEVELOPER:
      -- @@ 1/ For each column in your view put a column in the insert
      -- @@ statement below.
      -- @@ 2/ Prefix each column in the VALUE clause with g_
      -- @@ 3/ make sure (i) is at the end of each column in the value clause
      --
      INSERT INTO hri_cs_cmptnc_lvl_ct
        (row_indicator
        ,no_level_indicator
        ,scale_level_value
        ,min_scale_level_value
        ,max_scale_level_value
        ,rank_level_value
        ,min_rank_level_value
        ,max_rank_level_value
        ,nrmlzd_scale_level_value
        ,nrmlzd_rank_level_value
        ,competence_id
        ,scale_id
        ,level_id
        ,cmptnc_eval_mthd_code
        ,cmptnc_rnwl_prd_freq_value
        ,cmptnc_rnwl_prd_unit_code
        ,cmptnc_cert_reqrd_flag_code
        ,scale_flag_code
        ,scale_dflt_flag_code
        ,last_change_date)
        VALUES
          (g_row_ind(i)
          ,g_no_level_ind(i)
          ,g_scale_level_val(i)
          ,g_min_scale_level(i)
          ,g_max_scale_level(i)
          ,g_rank_level_val(i)
          ,g_min_rank_level(i)
          ,g_max_rank_level(i)
          ,g_nrmlzd_scale_lvl(i)
          ,g_nrmlzd_rank_lvl(i)
          ,g_competence_id(i)
          ,g_scale_id(i)
          ,g_level_id(i)
          ,g_eval_mthd_code(i)
          ,g_rnwl_prd_freq(i)
          ,g_rnwl_prd_unit(i)
          ,g_cert_reqrd_flag(i)
          ,g_scale_flag(i)
          ,g_scale_default_flag(i)
          ,g_last_change_date(i));

Line: 191


        output('Single insert error: ' || to_char(g_competence_id(i)) ||
               ' - ' || to_char(g_level_id(i)) ||
               ' - ' || to_char(g_scale_id(i)));

Line: 205


END recover_insert_rows;

Line: 211


PROCEDURE bulk_insert_rows(p_stored_rows_to_insert NUMBER) IS
  --
BEGIN
  --
  -- insert chunk of rows
  --
  -- @@ Code specific to this view/table below
  -- @@ INTRUCTION TO DEVELOPER:
  -- @@ 1/ For each column in your view put a column in the insert statement
  --       below.
  -- @@ 2/ Prefix each column in the VALUE clause with g_
  -- @@ 3/ make sure (i) is at the end of each column in the value clause
  --
  FORALL i IN 1..p_stored_rows_to_insert
      INSERT INTO hri_cs_cmptnc_lvl_ct
        (row_indicator
        ,no_level_indicator
        ,scale_level_value
        ,min_scale_level_value
        ,max_scale_level_value
        ,rank_level_value
        ,min_rank_level_value
        ,max_rank_level_value
        ,nrmlzd_scale_level_value
        ,nrmlzd_rank_level_value
        ,competence_id
        ,scale_id
        ,level_id
        ,cmptnc_eval_mthd_code
        ,cmptnc_rnwl_prd_freq_value
        ,cmptnc_rnwl_prd_unit_code
        ,cmptnc_cert_reqrd_flag_code
        ,scale_flag_code
        ,scale_dflt_flag_code
        ,last_change_date)
        VALUES
          (g_row_ind(i)
          ,g_no_level_ind(i)
          ,g_scale_level_val(i)
          ,g_min_scale_level(i)
          ,g_max_scale_level(i)
          ,g_rank_level_val(i)
          ,g_min_rank_level(i)
          ,g_max_rank_level(i)
          ,g_nrmlzd_scale_lvl(i)
          ,g_nrmlzd_rank_lvl(i)
          ,g_competence_id(i)
          ,g_scale_id(i)
          ,g_level_id(i)
          ,g_eval_mthd_code(i)
          ,g_rnwl_prd_freq(i)
          ,g_rnwl_prd_unit(i)
          ,g_cert_reqrd_flag(i)
          ,g_scale_flag(i)
          ,g_scale_default_flag(i)
          ,g_last_change_date(i));

Line: 282


    recover_insert_rows(p_stored_rows_to_insert);

Line: 284


END bulk_insert_rows;

Line: 296


  SELECT
         row_indicator
        ,no_level_indicator
        ,scale_level_value
        ,min_scale_level_value
        ,max_scale_level_value
        ,rank_level_value
        ,min_rank_level_value
        ,max_rank_level_value
        ,nrmlzd_scale_level_value
        ,nrmlzd_rank_level_value
        ,competence_id
        ,scale_id
        ,level_id
        ,cmptnc_eval_mthd_code
        ,cmptnc_rnwl_prd_freq_value
        ,cmptnc_rnwl_prd_unit_code
        ,cmptnc_cert_reqrd_flag_code
        ,scale_flag_code
        ,scale_dflt_flag_code
        ,last_change_date
  FROM hri_cs_cmptnc_lvl_v;

Line: 412


    bulk_insert_rows (l_rows_fetched);