APPS.IRC_VARIABLE_COMP_ELEMENT_SWI SQL Statements

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

Line: 111

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

Line: 125

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

Line: 131

  savepoint delete_variable_comp_swi;

Line: 151

  irc_variable_comp_element_api.delete_variable_compensation
    (p_validate                     => l_validate
    ,p_vacancy_id                   => p_vacancy_id
    ,p_variable_comp_lookup         => p_variable_comp_lookup
    ,p_object_version_number        => p_object_version_number
    );

Line: 179

    rollback to delete_variable_comp_swi;

Line: 193

    rollback to delete_variable_comp_swi;

Line: 203

end delete_variable_compensation;

Line: 268

     delete_variable_compensation
     (p_validate               => p_validate
     ,p_object_version_number  => l_object_version_number
     ,p_vacancy_id             => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
     ,p_variable_comp_lookup   => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VariableCompLookup',NULL)
     ,p_return_status          => l_return_status
     );