APPS.AME_ATTRIBUTE_SWI SQL Statements

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

Line: 265

PROCEDURE update_ame_attribute
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_attribute_id                 in     number
  ,p_description                  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: 282

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

Line: 288

  savepoint update_ame_attribute_swi;

Line: 309

  ame_attribute_api.update_ame_attribute
    (p_validate                     => l_validate
    ,p_attribute_id                 => p_attribute_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
    );

Line: 339

    rollback to update_ame_attribute_swi;

Line: 356

    rollback to update_ame_attribute_swi;

Line: 369

end update_ame_attribute;

Line: 373

PROCEDURE update_ame_attribute_usage
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_attribute_id                 in     number
  ,p_application_id               in     number
  ,p_is_static                    in     varchar2  default hr_api.g_varchar2
  ,p_query_string                 in     varchar2  default hr_api.g_varchar2
  ,p_value_set_id                 in     number    default null
  ,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: 393

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

Line: 399

  savepoint update_ame_attribute_usage_swi;

Line: 420

  ame_attribute_api.update_ame_attribute_usage
    (p_validate                     => l_validate
    ,p_attribute_id                 => p_attribute_id
    ,p_application_id               => p_application_id
    ,p_is_static                    => p_is_static
    ,p_query_string                 => p_query_string
    ,p_value_set_id                 => p_value_set_id
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 453

    rollback to update_ame_attribute_usage_swi;

Line: 470

    rollback to update_ame_attribute_usage_swi;

Line: 483

end update_ame_attribute_usage;

Line: 487

PROCEDURE delete_ame_attribute_usage
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_attribute_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: 504

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

Line: 510

  savepoint delete_ame_attribute_usage_swi;

Line: 531

  ame_attribute_api.delete_ame_attribute_usage
    (p_validate                     => l_validate
    ,p_attribute_id                 => p_attribute_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: 561

    rollback to delete_ame_attribute_usage_swi;

Line: 578

    rollback to delete_ame_attribute_usage_swi;

Line: 591

end delete_ame_attribute_usage;