APPS.HR_NL_ABSENCE_ACTION_API SQL Statements

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

Line: 37

  l_last_updated_by           number;

Line: 89

  ,p_last_updated_by               => l_last_updated_by
  ,p_absence_action_id            => l_absence_action_id
  ,p_object_version_number        => l_object_version_number
  ,p_enabled                      => p_enabled
  );

Line: 172

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

Line: 194

  l_last_updated_by      number;

Line: 206

  savepoint update_absence_action;

Line: 218

    hr_nl_absence_action_bk2.update_absence_action_b
      (p_absence_attendance_id         =>     p_absence_attendance_id
      ,p_absence_action_id             =>     p_absence_action_id
      ,p_expected_date                 =>     l_expected_date
      ,p_description                   =>     p_description
      ,p_actual_start_date             =>     l_actual_start_date
      ,p_actual_end_date               =>     l_actual_end_date
      ,p_holder                        =>     p_holder
      ,p_comments                      =>     p_comments
      ,p_document_file_name            =>     p_document_file_name
      ,p_object_version_number         =>     p_object_version_number
      ,p_enabled                       =>     p_enabled
      );

Line: 234

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

Line: 252

  ,p_last_updated_by               => l_last_updated_by
  ,p_absence_action_id            => p_absence_action_id
  ,p_object_version_number        => l_object_version_number
  ,p_enabled                      => p_enabled
  );

Line: 267

    hr_nl_absence_action_bk2.update_absence_action_a
      (p_absence_attendance_id         =>     p_absence_attendance_id
      ,p_absence_action_id             =>     p_absence_action_id
      ,p_expected_date                 =>     l_expected_date
      ,p_description                   =>     p_description
      ,p_actual_start_date             =>     l_actual_start_date
      ,p_actual_end_date               =>     l_actual_end_date
      ,p_holder                        =>     p_holder
      ,p_comments                      =>     p_comments
      ,p_document_file_name            =>     p_document_file_name
      ,p_object_version_number         =>     l_object_version_number
      ,p_enabled                       =>     p_enabled
      );

Line: 306

    rollback to UPDATE_ABSENCE_ACTION;

Line: 319

    rollback to UPDATE_ABSENCE_ACTION;

Line: 326

end UPDATE_ABSENCE_ACTION;

Line: 332

procedure DELETE_ABSENCE_ACTION
  (p_validate                      in      boolean
  ,p_absence_action_id             in      number
  ,p_object_version_number         in      number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'delete_absence_action';

Line: 350

  savepoint delete_absence_action;

Line: 357

    hr_nl_absence_action_bk3.delete_absence_action_b
      (p_absence_action_id             =>     p_absence_action_id
      ,p_object_version_number         =>     p_object_version_number
       );

Line: 364

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

Line: 387

    hr_nl_absence_action_bk3.delete_absence_action_a
      (p_absence_action_id             =>     p_absence_action_id
      ,p_object_version_number         =>     p_object_version_number
      );

Line: 416

    rollback to DELETE_ABSENCE_ACTION;

Line: 427

    rollback to DELETE_ABSENCE_ACTION;

Line: 430

end DELETE_ABSENCE_ACTION;