APPS.HR_NL_ABSENCE_ACTION_SWI SQL Statements

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

Line: 129

PROCEDURE delete_absence_action
  (p_validate                     in     number
  ,p_absence_action_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: 142

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

Line: 148

  savepoint delete_absence_action_swi;

Line: 168

  hr_nl_absence_action_api.delete_absence_action
    (p_validate                     => l_validate
    ,p_absence_action_id            => p_absence_action_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 195

    rollback to delete_absence_action_swi;

Line: 209

    rollback to delete_absence_action_swi;

Line: 219

end delete_absence_action;

Line: 223

PROCEDURE update_absence_action
  (p_validate                     in     number
  ,p_absence_attendance_id        in     number
  ,p_absence_action_id            in     number
  ,p_object_version_number        in out nocopy number
  ,p_expected_date                in     date
  ,p_description                  in     varchar2
  ,p_actual_start_date            in     date
  ,p_actual_end_date              in     date
  ,p_holder                       in     varchar2
  ,p_comments                     in     varchar2
  ,p_document_file_name           in     varchar2
  ,p_return_status                out nocopy varchar2
  ,p_enabled                      in     varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 246

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

Line: 252

  savepoint update_absence_action_swi;

Line: 273

  hr_nl_absence_action_api.update_absence_action
    (p_validate                     => l_validate
    ,p_absence_attendance_id        => p_absence_attendance_id
    ,p_absence_action_id            => p_absence_action_id
    ,p_object_version_number        => p_object_version_number
    ,p_expected_date                => p_expected_date
    ,p_description                  => p_description
    ,p_actual_start_date            => p_actual_start_date
    ,p_actual_end_date              => p_actual_end_date
    ,p_holder                       => p_holder
    ,p_comments                     => p_comments
    ,p_document_file_name           => p_document_file_name
    ,p_enabled                      => p_enabled
    );

Line: 309

    rollback to update_absence_action_swi;

Line: 324

    rollback to update_absence_action_swi;

Line: 335

end update_absence_action;