APPS.AME_APPROVER_GROUP_SWI SQL Statements

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

Line: 127

PROCEDURE update_ame_approver_group
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_approval_group_id            in     number
  ,p_description                  in     varchar2  default hr_api.g_varchar2
  ,p_is_static                    in     varchar2  default hr_api.g_varchar2
  ,p_query_string                 in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 146

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

Line: 152

  savepoint update_ame_approver_group_s;

Line: 173

  ame_approver_group_api.update_ame_approver_group
    (p_validate                     => l_validate
    ,p_approval_group_id            => p_approval_group_id
    ,p_description                  => p_description
    ,p_is_static                    => p_is_static
    ,p_query_string                 => p_query_string
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 205

    rollback to update_ame_approver_group_s;

Line: 222

    rollback to update_ame_approver_group_s;

Line: 235

end update_ame_approver_group;

Line: 239

PROCEDURE delete_ame_approver_group
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_approval_group_id            in     number
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 255

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

Line: 261

  savepoint delete_ame_approver_group_s;

Line: 282

  ame_approver_group_api.delete_ame_approver_group
    (p_validate                     => l_validate
    ,p_approval_group_id            => p_approval_group_id
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 311

    rollback to delete_ame_approver_group_s;

Line: 328

    rollback to delete_ame_approver_group_s;

Line: 341

end delete_ame_approver_group;

Line: 455

PROCEDURE delete_approver_group_config
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_approval_group_id            in     number
  ,p_application_id               in     number
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 472

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

Line: 478

  savepoint delete_approver_group_config_s;

Line: 499

  ame_approver_group_api.delete_approver_group_config
    (p_validate                     => l_validate
    ,p_approval_group_id            => p_approval_group_id
    ,p_application_id               => p_application_id
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 529

    rollback to delete_approver_group_config_s;

Line: 546

    rollback to delete_approver_group_config_s;

Line: 559

end delete_approver_group_config;

Line: 563

PROCEDURE update_approver_group_config
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_approval_group_id            in     number
  ,p_application_id               in     number
  ,p_voting_regime                in     varchar2  default hr_api.g_varchar2
  ,p_order_number                 in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 582

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

Line: 588

  savepoint update_approver_group_config_s;

Line: 609

  ame_approver_group_api.update_approver_group_config
    (p_validate                     => l_validate
    ,p_approval_group_id            => p_approval_group_id
    ,p_application_id               => p_application_id
    ,p_voting_regime                => p_voting_regime
    ,p_order_number                 => p_order_number
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 641

    rollback to update_approver_group_config_s;

Line: 658

    rollback to update_approver_group_config_s;

Line: 671

end update_approver_group_config;

Line: 793

PROCEDURE delete_approver_group_item
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_approval_group_item_id       in     number
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 809

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

Line: 815

  savepoint delete_approver_group_item_s;

Line: 836

  ame_approver_group_api.delete_approver_group_item
    (p_validate                     => l_validate
    ,p_approval_group_item_id       => p_approval_group_item_id
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 865

    rollback to delete_approver_group_item_s;

Line: 882

    rollback to delete_approver_group_item_s;

Line: 895

end delete_approver_group_item;

Line: 899

PROCEDURE update_approver_group_item
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_approval_group_item_id       in     number
  ,p_order_number                 in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 916

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

Line: 922

  savepoint update_approver_group_item_s;

Line: 943

  ame_approver_group_api.update_approver_group_item
    (p_validate                     => l_validate
    ,p_approval_group_item_id       => p_approval_group_item_id
    ,p_order_number                 => p_order_number
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 973

    rollback to update_approver_group_item_s;

Line: 990

    rollback to update_approver_group_item_s;

Line: 1003

end update_approver_group_item;