APPS.HRI_BPL_FAST_FORMULA SQL Statements

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

Line: 550

    SELECT formula_type_id
    FROM ff_formula_types
    WHERE formula_type_name = 'QuickPaint';

Line: 581

    SELECT 'x' l_exists
    FROM ff_formulas_f
    WHERE business_group_id = cp_business_group_id
    AND   formula_name      = cp_formula_name;

Line: 664

    SELECT 'x' l_exists
    FROM
       ff_formulas_f       frm
      ,ff_compiled_info_f  fcp
    WHERE frm.formula_id        = fcp.formula_id
    AND   frm.business_group_id = cp_business_group_id
    AND   frm.formula_name      = cp_formula_name;

Line: 742

  l_last_update_date DATE;

Line: 792

    ff_formulas_f_pkg.Insert_Row
            (
             X_Rowid                => l_rowid
            ,X_Formula_Id           => l_formula_id
            ,X_Effective_Start_Date => hr_general.start_of_time
            ,X_Effective_End_Date   => l_end_date
            ,X_Business_Group_Id    => p_business_group_id
            ,X_Legislation_Code     => l_legislation_code
            ,X_Formula_Type_Id      => g_Formula_Type_Id
            ,X_Formula_Name         => l_formula_name
            ,X_Description          => l_formula_name
            ,X_Formula_Text         => p_formula_text
            ,X_Sticky_Flag          => NULL
            ,X_Last_Update_Date     => l_last_update_date
            );

Line: 810

      dbg('An error was encountered while inserting the generated fastformula');

Line: 835

    SELECT COUNT(step_value)
    FROM   per_rating_levels
    WHERE rating_scale_id = cp_rating_scale_id;

Line: 920

  SELECT pat.business_group_id
      ,pat.name rating_template_name
      ,prs.name rating_scale_name
      ,prs.rating_scale_id
      ,prl.step_value
  FROM per_appraisal_templates pat
      ,per_rating_scales       prs
      ,per_rating_levels       prl
  WHERE pat.business_group_id = cp_business_group_id
  AND   pat.rating_scale_id   = prs.rating_scale_id
  AND   pat.rating_scale_id   = prl.rating_scale_id
  ORDER BY business_group_id
         , prs.rating_scale_id
         , rating_template_name
         , step_value;

Line: 1132

    SELECT DISTINCT pat.business_group_id business_group_id
    FROM   per_appraisal_templates pat
    WHERE  rating_scale_id IS NOT NULL
    ORDER  BY business_group_id;

Line: 1321

  dbg('Checking if foundation HR mode is selected.');

Line: 1326

    dbg('Foundation HR mode is selected.');

Line: 1393

PROCEDURE delete_performance_formula(p_business_group_id IN NUMBER)
IS
  --
  -- find the rowid of the fast_formula that we want to delete
  --
  CURSOR csr_formula_rowid (cp_business_group_id NUMBER) IS
    SELECT rowid
    FROM ff_formulas_f
    WHERE formula_name = c_prf_aprsl_ff_name
    AND business_group_id = cp_business_group_id;

Line: 1416

  ff_formulas_f_pkg.Delete_Row
              (
               X_Rowid                  => l_row_id
              ,X_Formula_Id             => NULL
              ,X_Dt_Delete_Mode         => 'DELETE'
              ,X_Validation_Start_Date  => NULL
              ,X_Validation_End_Date    => NULL
              );

Line: 1429

  dbg('Formula has been successfully deleted ...');

Line: 1437

    dbg('An error was encountered while attempting to delete a fastformula');

Line: 1439

    g_msg_sub_group := NVL(g_msg_sub_group, 'DELETE_PERFORMANCE_FORMULA');

Line: 1443

END delete_performance_formula;

Line: 1448

PROCEDURE delete_all_prfrmnc_formulas
IS
  --
  -- find all performance appraisal fast formulas
  --
  CURSOR csr_all_prfrmnc_formulas IS
    SELECT rowid
    FROM ff_formulas_f
    WHERE formula_name = c_prf_aprsl_ff_name;

Line: 1467

    ff_formulas_f_pkg.Delete_Row
              (
               X_Rowid                  => l_all_prfrmnc_formulas.rowid
              ,X_Formula_Id             => NULL
              ,X_Dt_Delete_Mode         => 'DELETE'
              ,X_Validation_Start_Date  => NULL
              ,X_Validation_End_Date    => NULL
              );

Line: 1482

  dbg('Formulas have been successfully deleted ...');

Line: 1490

    dbg('An error was encountered while attempting to delete fastformulas');

Line: 1492

    g_msg_sub_group := NVL(g_msg_sub_group, 'DELETE_ALL_PRFRMNC_FORMULAS');

Line: 1496

END delete_all_prfrmnc_formulas;

Line: 1533

  dbg('Checking if foundation HR mode is selected.');

Line: 1538

    dbg('Foundation HR mode is selected.');

Line: 1660

  dbg('Checking if foundation HR mode is selected.');

Line: 1665

    dbg('Foundation HR mode is selected.');