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
  --
  --
  l_object_version_number irc_variable_comp_elements.object_version_number%TYPE;

Line: 124

    select object_version_number
    from   irc_variable_comp_elements
    where  vacancy_id = p_vacancy_id
     and   variable_comp_lookup = p_variable_comp_lookup;

Line: 135

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

Line: 141

  savepoint delete_variable_comp_swi;

Line: 169

  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        => l_object_version_number
    );

Line: 197

    rollback to delete_variable_comp_swi;

Line: 211

    rollback to delete_variable_comp_swi;

Line: 221

end delete_variable_compensation;

Line: 286

     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
     );