APPS.PQH_DE_OPERATIONS_SWI SQL Statements

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

Line: 11

PROCEDURE delete_operations
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_operation_id                 in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 24

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

Line: 30

  savepoint delete_operations_swi;

Line: 50

  pqh_de_operations_api.delete_operations
    (p_validate                     => l_validate
    ,p_operation_id                 => p_operation_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 77

    rollback to delete_operations_swi;

Line: 91

    rollback to delete_operations_swi;

Line: 101

end delete_operations;

Line: 105

PROCEDURE insert_operations
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_operation_number             in     varchar2  default hr_api.g_varchar2
  ,p_description                  in     varchar2
  ,p_operation_id                    out nocopy number
  ,p_object_version_number           out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 121

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

Line: 127

  savepoint insert_operations_swi;

Line: 150

  pqh_de_operations_api.insert_operations
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_operation_number             => p_operation_number
    ,p_description                  => p_description
    ,p_operation_id                 => p_operation_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 180

    rollback to insert_operations_swi;

Line: 196

    rollback to insert_operations_swi;

Line: 208

end insert_operations;

Line: 212

PROCEDURE update_operations
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_operation_number             in     varchar2  default hr_api.g_varchar2
  ,p_description                  in     varchar2  default hr_api.g_varchar2
  ,p_operation_id                 in     number
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 229

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

Line: 235

  savepoint update_operations_swi;

Line: 256

  pqh_de_operations_api.update_operations
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_operation_number             => p_operation_number
    ,p_description                  => p_description
    ,p_operation_id                 => p_operation_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 286

    rollback to update_operations_swi;

Line: 301

    rollback to update_operations_swi;

Line: 312

end update_operations;