APPS.PQH_RULE_SETS_SWI SQL Statements

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

Line: 139

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

Line: 153

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

Line: 159

  savepoint delete_rule_set_swi;

Line: 179

  pqh_rule_sets_api.delete_rule_set
    (p_validate                     => l_validate
    ,p_rule_set_id                  => p_rule_set_id
    ,p_object_version_number        => p_object_version_number
    ,p_effective_date               => p_effective_date
    );

Line: 207

    rollback to delete_rule_set_swi;

Line: 221

    rollback to delete_rule_set_swi;

Line: 231

end delete_rule_set;

Line: 235

PROCEDURE update_rule_set
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_rule_set_id                  in     number
  ,p_rule_set_name                in     varchar2  default hr_api.g_varchar2
  ,p_description                  in     varchar2  default hr_api.g_varchar2
  ,p_organization_structure_id    in     number    default hr_api.g_number
  ,p_organization_id              in     number    default hr_api.g_number
  ,p_referenced_rule_set_id       in     number    default hr_api.g_number
  ,p_rule_level_cd                in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_short_name                   in     varchar2  default hr_api.g_varchar2
  ,p_effective_date               in     date
  ,p_language_code                in     varchar2  default hr_api.userenv_lang
  ,p_rule_applicability           in     varchar2  default hr_api.g_varchar2
  ,p_rule_category                in     varchar2  default hr_api.g_varchar2
  ,p_starting_organization_id     in     number    default hr_api.g_number
  ,p_seeded_rule_flag             in     varchar2  default hr_api.g_varchar2
  ,p_status                       in     varchar2  default hr_api.g_varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 264

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

Line: 270

  savepoint update_rule_set_swi;

Line: 291

  pqh_rule_sets_api.update_rule_set
    (p_validate                     => l_validate
    ,p_business_group_id            => p_business_group_id
    ,p_rule_set_id                  => p_rule_set_id
    ,p_rule_set_name                => p_rule_set_name
    ,p_description		    => p_description
    ,p_organization_structure_id    => p_organization_structure_id
    ,p_organization_id              => p_organization_id
    ,p_referenced_rule_set_id       => p_referenced_rule_set_id
    ,p_rule_level_cd                => p_rule_level_cd
    ,p_object_version_number        => p_object_version_number
    ,p_short_name                   => p_short_name
    ,p_effective_date               => p_effective_date
    ,p_language_code                => p_language_code
    ,p_rule_applicability           => p_rule_applicability
    ,p_rule_category                => p_rule_category
    ,p_starting_organization_id     => p_starting_organization_id
    ,p_seeded_rule_flag             => p_seeded_rule_flag
    ,p_status                       => p_status
    );

Line: 333

    rollback to update_rule_set_swi;

Line: 348

    rollback to update_rule_set_swi;

Line: 359

end update_rule_set;