APPS.PAY_STATUS_PROCESSING_RULE_API SQL Statements

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

Line: 169

procedure update_status_process_rule
(  p_validate                     in     boolean default false
  ,p_effective_date               in     date
  ,p_datetrack_mode               in     varchar2
  ,p_status_processing_rule_id    in     number
  ,p_object_version_number        in out nocopy number
  ,p_formula_id                   in     number    default hr_api.g_number
  ,p_comments                     in     varchar2  default hr_api.g_varchar2
  ,p_effective_start_date            out nocopy date
  ,p_effective_end_date              out nocopy date
  ,p_formula_mismatch_warning        out nocopy boolean
) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'update_status_process_rule';

Line: 197

    savepoint update_status_process_rule;

Line: 209

    pay_status_processing_rule_bk2.update_status_process_rule_b
      (p_effective_date             =>  l_effective_date
      ,p_datetrack_mode             =>  p_datetrack_mode
      ,p_status_processing_rule_id  =>  p_status_processing_rule_id
      ,p_object_version_number      =>  l_object_version_number
      ,p_formula_id                 =>  p_formula_id
      ,p_comments                   =>  p_comments
      );

Line: 220

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

Line: 246

    pay_status_processing_rule_bk2.update_status_process_rule_a
      (p_effective_date             =>  l_effective_date
      ,p_datetrack_mode             =>  p_datetrack_mode
      ,p_status_processing_rule_id  =>  p_status_processing_rule_id
      ,p_object_version_number      =>  l_object_version_number
      ,p_formula_id                 =>  p_formula_id
      ,p_comments                   =>  p_comments
      ,p_effective_start_date       =>  l_effective_start_date
      ,p_effective_end_date         =>  l_effective_end_date
      ,p_formula_mismatch_warning   =>  l_formula_mismatch_warning
      );

Line: 260

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

Line: 290

    ROLLBACK TO update_status_process_rule;

Line: 307

    ROLLBACK TO update_status_process_rule;

Line: 311

end update_status_process_rule;

Line: 317

PROCEDURE delete_status_process_rule
  (p_validate                       in    boolean  default false
  ,p_effective_date                 in    date
  ,p_datetrack_mode                 in    varchar2
  ,p_status_processing_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_status_process_rule';

Line: 341

  SAVEPOINT delete_status_process_rule;

Line: 354

    pay_status_processing_rule_bk3.delete_status_process_rule_b
      (p_effective_date             =>  l_effective_date
      ,p_datetrack_mode             =>  p_datetrack_mode
      ,p_status_processing_rule_id  =>  p_status_processing_rule_id
      ,p_object_version_number      =>  l_object_version_number
      );

Line: 363

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

Line: 383

    pay_status_processing_rule_bk3.delete_status_process_rule_a
      (p_effective_date             =>  l_effective_date
      ,p_datetrack_mode             =>  p_datetrack_mode
      ,p_status_processing_rule_id  =>  p_status_processing_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: 394

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

Line: 424

    ROLLBACK TO delete_status_process_rule;

Line: 440

    ROLLBACK TO delete_status_process_rule;

Line: 445

END delete_status_process_rule;