APPS.PQH_FR_STAT_SIT_RULES_SWI SQL Statements

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

Line: 164

PROCEDURE delete_stat_situation_rule
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_stat_situation_rule_id       in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 177

  l_proc    varchar2(72) := g_package ||'delete_stat_situation_rule';

Line: 189

  savepoint delete_stat_situation_rule_swi;

Line: 209

  pqh_fr_stat_sit_rules_api.delete_stat_situation_rule
    (p_validate                     => l_validate
    ,p_stat_situation_rule_id       => p_stat_situation_rule_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 242

    rollback to delete_stat_situation_rule_swi;

Line: 262

    rollback to delete_stat_situation_rule_swi;

Line: 283

end delete_stat_situation_rule;

Line: 287

PROCEDURE update_stat_situation_rule
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date      default hr_api.g_date
  ,p_stat_situation_rule_id       in     number
  ,p_object_version_number        in out nocopy number
  ,p_statutory_situation_id       in     number    default hr_api.g_number
  ,p_processing_sequence          in     number    default hr_api.g_number
  ,p_txn_category_attribute_id    in     number    default hr_api.g_number
  ,p_from_value                   in     varchar2  default hr_api.g_varchar2
  ,p_to_value                     in     varchar2  default hr_api.g_varchar2
  ,p_enabled_flag                 in     varchar2  default hr_api.g_varchar2
  ,p_required_flag                in     varchar2  default hr_api.g_varchar2
  ,p_exclude_flag                 in     varchar2  default hr_api.g_varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 310

  l_proc    varchar2(72) := g_package ||'update_stat_situation_rule';

Line: 322

  savepoint update_stat_situation_rule_swi;

Line: 343

  pqh_fr_stat_sit_rules_api.update_stat_situation_rule
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_stat_situation_rule_id       => p_stat_situation_rule_id
    ,p_object_version_number        => p_object_version_number
    ,p_statutory_situation_id       => p_statutory_situation_id
    ,p_processing_sequence          => p_processing_sequence
    ,p_txn_category_attribute_id    => p_txn_category_attribute_id
    ,p_from_value                   => p_from_value
    ,p_to_value                     => p_to_value
    ,p_enabled_flag                 => p_enabled_flag
    ,p_required_flag                => p_required_flag
    ,p_exclude_flag                 => p_exclude_flag
    );

Line: 385

    rollback to update_stat_situation_rule_swi;

Line: 406

    rollback to update_stat_situation_rule_swi;

Line: 429

end update_stat_situation_rule;