APPS.PAY_FORMULA_RESULT_RULE_API SQL Statements

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

Line: 41

    select element_type_id
      from pay_status_processing_rules_f spr
     where spr.status_processing_rule_id = p_status_processing_rule_id
       and p_effective_date between spr.effective_start_date
       and spr.effective_end_date;

Line: 195

procedure UPDATE_FORMULA_RESULT_RULE
  (p_validate                    in     boolean   default false
  ,p_effective_date              in     date
  ,p_datetrack_update_mode       in     varchar2
  ,p_formula_result_rule_id      in     number
  ,p_object_version_number       in out nocopy number
  ,p_result_rule_type            in     varchar2  default hr_api.g_varchar2
  ,p_element_type_id             in     number    default hr_api.g_number
  ,p_severity_level              in     varchar2  default hr_api.g_varchar2
  ,p_input_value_id              in     number    default hr_api.g_number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                 varchar2(72):=g_package||'UPDATE_FORMULA_RESULT_RULE';

Line: 219

    select spr.element_type_id
      from pay_formula_result_rules_f frr
          ,pay_status_processing_rules_f spr
     where frr.formula_result_rule_id = p_formula_result_rule_id
       and spr.status_processing_rule_id = frr.status_processing_rule_id
       and p_effective_date between frr.effective_start_date
       and frr.effective_end_date;

Line: 232

  savepoint UPDATE_FORMULA_RESULT_RULE;

Line: 245

    PAY_FORMULA_RESULT_RULE_bk2.UPDATE_FORMULA_RESULT_RULE_b
      (p_effective_date          =>  l_effective_date
      ,p_datetrack_update_mode   =>  p_datetrack_update_mode
      ,p_formula_result_rule_id  =>  p_formula_result_rule_id
      ,p_object_version_number   =>  l_object_version_number
      ,p_result_rule_type        =>  p_result_rule_type
      ,p_element_type_id         =>  p_element_type_id
      ,p_severity_level          =>  p_severity_level
      ,p_input_value_id          =>  p_input_value_id
      );

Line: 258

        (p_module_name => 'UPDATE_FORMULA_RESULT_RULE'
        ,p_hook_type   => 'BP'
        );

Line: 281

    ,p_datetrack_mode             =>  p_datetrack_update_mode
    ,p_formula_result_rule_id     =>  p_formula_result_rule_id
    ,p_object_version_number      =>  l_object_version_number
    ,p_result_rule_type           =>  p_result_rule_type
    ,p_element_type_id            =>  l_element_type_id
    ,p_severity_level             =>  p_severity_level
    ,p_input_value_id             =>  p_input_value_id
    ,p_effective_start_date       =>  l_effective_start_date
    ,p_effective_end_date         =>  l_effective_end_date
    );

Line: 295

    PAY_FORMULA_RESULT_RULE_bk2.UPDATE_FORMULA_RESULT_RULE_a
      (p_effective_date             =>  l_effective_date
      ,p_datetrack_update_mode      =>  p_datetrack_update_mode
      ,p_result_rule_type           =>  p_result_rule_type
      ,p_element_type_id            =>  l_element_type_id
      ,p_severity_level             =>  p_severity_level
      ,p_input_value_id             =>  p_input_value_id
      ,p_formula_result_rule_id     =>  p_formula_result_rule_id
      ,p_effective_start_date       =>  l_effective_start_date
      ,p_effective_end_date         =>  l_effective_end_date
      ,p_object_version_number      =>  l_object_version_number
      );

Line: 310

        (p_module_name => 'UPDATE_FORMULA_RESULT_RULE'
        ,p_hook_type   => 'AP'
        );

Line: 334

    rollback to UPDATE_FORMULA_RESULT_RULE;

Line: 349

    rollback to UPDATE_FORMULA_RESULT_RULE;

Line: 360

End UPDATE_FORMULA_RESULT_RULE;

Line: 366

procedure DELETE_FORMULA_RESULT_RULE
  (p_validate                    in     boolean   default false
  ,p_effective_date              in     date
  ,p_datetrack_delete_mode       in     varchar2
  ,p_formula_result_rule_id      in     number
  ,p_object_version_number       in out nocopy number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                 varchar2(72):=g_package||'DELETE_FORMULA_RESULT_RULE';

Line: 389

  savepoint DELETE_FORMULA_RESULT_RULE;

Line: 402

    PAY_FORMULA_RESULT_RULE_bk3.DELETE_FORMULA_RESULT_RULE_b
      (p_effective_date          =>  l_effective_date
      ,p_datetrack_delete_mode   =>  p_datetrack_delete_mode
      ,p_formula_result_rule_id  =>  p_formula_result_rule_id
      ,p_object_version_number   =>  l_object_version_number
      );

Line: 411

        (p_module_name => 'DELETE_FORMULA_RESULT_RULE'
        ,p_hook_type   => 'BP'
        );

Line: 424

    ,p_datetrack_mode             =>  p_datetrack_delete_mode
    ,p_formula_result_rule_id     =>  p_formula_result_rule_id
    ,p_object_version_number      =>  l_object_version_number
    ,p_effective_start_date       =>  l_effective_start_date
    ,p_effective_end_date         =>  l_effective_end_date
    );

Line: 434

    PAY_FORMULA_RESULT_RULE_bk3.DELETE_FORMULA_RESULT_RULE_a
      (p_effective_date             =>  l_effective_date
      ,p_datetrack_delete_mode      =>  p_datetrack_delete_mode
      ,p_formula_result_rule_id     =>  p_formula_result_rule_id
      ,p_effective_start_date       =>  l_effective_start_date
      ,p_effective_end_date         =>  l_effective_end_date
      ,p_object_version_number      =>  l_object_version_number
      );

Line: 445

        (p_module_name => 'DELETE_FORMULA_RESULT_RULE'
        ,p_hook_type   => 'AP'
        );

Line: 469

    rollback to DELETE_FORMULA_RESULT_RULE;

Line: 484

    rollback to DELETE_FORMULA_RESULT_RULE;

Line: 495

End DELETE_FORMULA_RESULT_RULE;