APPS.AME_RULE_SWI SQL Statements

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

Line: 507

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

Line: 526

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

Line: 532

  savepoint update_ame_rule_swi;

Line: 555

  ame_rule_api.update_ame_rule
    (p_validate                     => l_validate
    ,p_rule_id                      => p_rule_id
    ,p_description                  => p_description
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    ,p_effective_date               => g_effective_date
    );

Line: 586

    rollback to update_ame_rule_swi;

Line: 603

    rollback to update_ame_rule_swi;

Line: 616

end update_ame_rule;

Line: 620

PROCEDURE update_ame_rule_usage
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_rule_id                      in     number
  ,p_application_id               in     number
  ,p_priority                     in     number    default hr_api.g_number
  ,p_approver_category            in     varchar2  default hr_api.g_varchar2
  ,p_old_start_date               in     date
  ,p_object_version_number        in out nocopy number
  ,p_start_date                   in out nocopy date
  ,p_end_date                     in out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 642

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

Line: 648

  savepoint update_ame_rule_usage_swi;

Line: 672

  ame_rule_api.update_ame_rule_usage
    (p_validate                     => l_validate
    ,p_rule_id                      => p_rule_id
    ,p_application_id               => p_application_id
    ,p_priority                     => p_priority
    ,p_approver_category            => p_approver_category
    ,p_old_start_date               => p_old_start_date
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => l_start_date
    ,p_end_date                     => l_end_date
    ,p_effective_date               => g_effective_date
    );

Line: 706

    rollback to update_ame_rule_usage_swi;

Line: 723

    rollback to update_ame_rule_usage_swi;

Line: 736

end update_ame_rule_usage;

Line: 740

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

Line: 759

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

Line: 765

  savepoint delete_ame_rule_usage_swi;

Line: 788

  ame_rule_api.delete_ame_rule_usage
    (p_validate                     => l_validate
    ,p_rule_id                      => p_rule_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: 818

    rollback to delete_ame_rule_usage_swi;

Line: 835

    rollback to delete_ame_rule_usage_swi;

Line: 848

end delete_ame_rule_usage;

Line: 852

PROCEDURE delete_ame_rule_condition
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_rule_id                      in     number
  ,p_condition_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: 869

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

Line: 875

  savepoint delete_ame_rule_condition_swi;

Line: 896

  ame_rule_api.delete_ame_rule_condition
    (p_validate                     => l_validate
    ,p_rule_id                      => p_rule_id
    ,p_condition_id                 => p_condition_id
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    ,p_effective_date               => g_effective_date
    );

Line: 927

    rollback to delete_ame_rule_condition_swi;

Line: 944

    rollback to delete_ame_rule_condition_swi;

Line: 957

end delete_ame_rule_condition;

Line: 961

PROCEDURE delete_ame_rule_action
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_rule_id                      in     number
  ,p_action_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: 978

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

Line: 984

  savepoint delete_ame_rule_action_swi;

Line: 1005

  ame_rule_api.delete_ame_rule_action
    (p_validate                     => l_validate
    ,p_rule_id                      => p_rule_id
    ,p_action_id                    => p_action_id
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    ,p_effective_date               => g_effective_date
    );

Line: 1036

    rollback to delete_ame_rule_action_swi;

Line: 1053

    rollback to delete_ame_rule_action_swi;

Line: 1066

end delete_ame_rule_action;