APPS.AME_ITEM_CLASS_API SQL Statements

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

Line: 149

procedure update_ame_item_class
        (p_validate                     in     boolean   default false
        ,p_language_code                in     varchar2  default
                                                          hr_api.userenv_lang
        ,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
        ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                      varchar2(72) := g_package||'update_ame_item_class';

Line: 173

    savepoint update_ame_item_class;

Line: 183

      ame_item_class_bk2.update_ame_item_class_b
              (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
              );

Line: 191

                              (p_module_name => 'update_ame_item_class'
                              ,p_hook_type   => 'BP'
                              );

Line: 203

      ,p_datetrack_mode        => hr_api.g_update
      ,p_item_class_id         => p_item_class_id
      ,p_object_version_number => p_object_version_number
      ,p_name                  => hr_api.g_varchar2
      ,p_start_date            => l_start_date
      ,p_end_date              => l_end_date
      );

Line: 222

      ame_item_class_bk2.update_ame_item_class_a
              (p_item_class_id           => p_item_class_id
              ,p_object_version_number   => p_object_version_number
              ,p_user_item_class_name    => p_user_item_class_name
              ,p_start_date              => l_start_date
              ,p_end_date                => l_end_date
              );

Line: 232

                              (p_module_name => 'update_ame_item_class'
                              ,p_hook_type   => 'AP'
                              );

Line: 255

      rollback to update_ame_item_class;

Line: 270

      rollback to update_ame_item_class;

Line: 281

  end update_ame_item_class;

Line: 286

procedure delete_ame_item_class
  (p_validate              in     boolean  default false
  ,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
  ) is
  --
  -- Declare cursors and local variables
  --
  cursor getItemClassUsageCur is
    select application_id,
           object_version_number
      from ame_item_class_usages
     where item_class_id = p_item_class_id
       and sysdate between start_date and
             nvl(end_date - ame_util.oneSecond, sysdate);

Line: 303

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

Line: 317

    savepoint delete_ame_item_class;

Line: 326

      ame_item_class_bk3.delete_ame_item_class_b
       (p_item_class_id         => p_item_class_id
       ,p_object_version_number => p_object_version_number
       );

Line: 333

                              (p_module_name => 'delete_ame_item_class'
                              ,p_hook_type   => 'BP'
                              );

Line: 348

    delete_ame_item_class_usage
      (p_validate              => p_validate
      ,p_application_id        => l_applicationIds(indx)
      ,p_item_class_id         => p_item_class_id
      ,p_object_version_number => l_objectVersionNumbers(indx)
      ,p_start_date            => l_start_date_child
      ,p_end_date              => l_end_date_child
      );

Line: 362

        ,p_datetrack_mode          => hr_api.g_delete
        ,p_item_class_id           => p_item_class_id
        ,p_object_version_number   => p_object_version_number
        ,p_start_date              => l_start_date
        ,p_end_date                => l_end_date
        );

Line: 372

      ame_item_class_bk3.delete_ame_item_class_a
         (p_item_class_id           => p_item_class_id
         ,p_object_version_number   => p_object_version_number
         ,p_start_date              => l_start_date
         ,p_end_date                => l_end_date
          );

Line: 381

                              (p_module_name => 'delete_ame_item_class'
                              ,p_hook_type   => 'AP'
                              );

Line: 404

      rollback to delete_ame_item_class;

Line: 419

      rollback to delete_ame_item_class;

Line: 430

  end delete_ame_item_class;

Line: 579

procedure update_ame_item_class_usage
        (p_validate                     in     boolean   default false
        ,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
        ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                      varchar2(72) := g_package||'update_ame_item_class_usage';

Line: 604

    savepoint update_ame_item_class_usage;

Line: 613

      ame_item_class_bk5.update_ame_item_class_usage_b
                (p_application_id          => p_application_id
                ,p_item_class_id           => p_item_class_id
                ,p_object_version_number   => p_object_version_number
                ,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
                );

Line: 625

                              (p_module_name => 'update_ame_item_class_usage'
                              ,p_hook_type   => 'BP'
                              );

Line: 634

      ,p_datetrack_mode           => hr_api.g_update
      ,p_application_id           => p_application_id
      ,p_item_class_id            => p_item_class_id
      ,p_object_version_number    => p_object_version_number
      ,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_start_date               => l_start_date
      ,p_end_date                 => l_end_date
      );

Line: 649

      ame_item_class_bk5.update_ame_item_class_usage_a
                (p_application_id            => p_application_id
                ,p_item_class_id             => p_item_class_id
                ,p_object_version_number     => p_object_version_number
                ,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_start_date                => l_start_date
                ,p_end_date                  => l_end_date
                );

Line: 664

                              (p_module_name => 'update_ame_item_class_usage'
                              ,p_hook_type   => 'AP'
                              );

Line: 687

      rollback to update_ame_item_class_usage;

Line: 702

      rollback to update_ame_item_class_usage;

Line: 713

  end update_ame_item_class_usage;

Line: 718

procedure delete_ame_item_class_usage
                          (p_validate              in boolean  default false
                          ,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
                          ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                   varchar2(72) := g_package||'delete_ame_item_class_usage';

Line: 739

    savepoint delete_ame_item_class_usage;

Line: 748

      ame_item_class_bk6.delete_ame_item_class_usage_b
              (p_application_id         => p_application_id
              ,p_item_class_id          => p_item_class_id
              ,p_object_version_number  => p_object_version_number
              );

Line: 757

                              (p_module_name => 'delete_ame_item_class_usage'
                              ,p_hook_type   => 'BP'
                              );

Line: 766

        ,p_datetrack_mode        => hr_api.g_delete
        ,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            => l_start_date
        ,p_end_date              => l_end_date
        );

Line: 777

      ame_item_class_bk6.delete_ame_item_class_usage_a
        (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             => l_start_date
        ,p_end_date               => l_end_date
        );

Line: 787

                              (p_module_name => 'delete_ame_item_class_usage'
                              ,p_hook_type   => 'AP'
                              );

Line: 810

      rollback to delete_ame_item_class_usage;

Line: 825

      rollback to delete_ame_item_class_usage;

Line: 836

  end delete_ame_item_class_usage;