APPS.AME_ITEM_CLASS_SWI SQL Statements

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

Line: 123

PROCEDURE update_ame_item_class
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_item_class_id                in     number
  ,p_user_item_class_name         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: 140

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

Line: 146

  savepoint update_ame_item_class_swi;

Line: 167

  ame_item_class_api.update_ame_item_class
    (p_validate                     => l_validate
    ,p_item_class_id                => p_item_class_id
    ,p_user_item_class_name         => p_user_item_class_name
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 197

    rollback to update_ame_item_class_swi;

Line: 214

    rollback to update_ame_item_class_swi;

Line: 227

end update_ame_item_class;

Line: 231

PROCEDURE delete_ame_item_class
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_item_class_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: 247

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

Line: 253

  savepoint delete_ame_item_class_swi;

Line: 274

  ame_item_class_api.delete_ame_item_class
    (p_validate                     => l_validate
    ,p_item_class_id                => p_item_class_id
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 303

    rollback to delete_ame_item_class_swi;

Line: 320

    rollback to delete_ame_item_class_swi;

Line: 333

end delete_ame_item_class;

Line: 459

PROCEDURE update_ame_item_class_usage
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_application_id               in     number
  ,p_item_class_id                in     number
  ,p_item_id_query                in     varchar2  default hr_api.g_varchar2
  ,p_item_class_order_number      in     number    default hr_api.g_number
  ,p_item_class_par_mode          in     varchar2  default hr_api.g_varchar2
  ,p_item_class_sublist_mode      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: 480

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

Line: 486

  savepoint update_ameitem_class_usage_swi;

Line: 507

  ame_item_class_api.update_ame_item_class_usage
    (p_validate                     => l_validate
    ,p_application_id               => p_application_id
    ,p_item_class_id                => p_item_class_id
    ,p_item_id_query                => p_item_id_query
    ,p_item_class_order_number      => p_item_class_order_number
    ,p_item_class_par_mode          => p_item_class_par_mode
    ,p_item_class_sublist_mode      => p_item_class_sublist_mode
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 541

    rollback to update_ame_itemclass_usage_swi;

Line: 558

    rollback to update_ame_itemclass_usage_swi;

Line: 571

end update_ame_item_class_usage;

Line: 575

PROCEDURE delete_ame_item_class_usage
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_application_id               in     number
  ,p_item_class_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: 592

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

Line: 599

  savepoint delete_ame_itemclass_usage_swi;

Line: 620

  ame_item_class_api.delete_ame_item_class_usage
    (p_validate                     => l_validate
    ,p_application_id               => p_application_id
    ,p_item_class_id                => p_item_class_id
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 650

    rollback to delete_ame_itemclass_usage_swi;

Line: 662

    l_found := fnd_msg_pub.delete_msg;

Line: 672

    rollback to delete_ame_itemclass_usage_swi;

Line: 685

end delete_ame_item_class_usage;