APPS.PAY_ELEMENT_TEMPLATE_USER_ISWI SQL Statements

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

Line: 114

PROCEDURE delete_element
  (p_validate                     in     number
  ,p_template_id                  in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 128

    l_proc    := g_package ||'delete_element';

Line: 133

  savepoint delete_element_swi;

Line: 153

  pay_element_template_user_init.delete_element
    (p_validate                     => l_validate
    ,p_template_id                  => p_template_id
    );

Line: 179

    rollback to delete_element_swi;

Line: 193

    rollback to delete_element_swi;

Line: 203

end delete_element;