APPS.PAY_ELEMENT_TEMPLATE_API SQL Statements

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

Line: 565

procedure delete_template
  (p_validate                      in     boolean default false
  ,p_template_id                   in     number
  ) is
  l_proc                varchar2(72) := g_package||'delete_template';

Line: 599

  savepoint delete_template;

Line: 652

  pay_element_template_util.delete_template
  (p_template_id     => p_template_id
  ,p_formulas        => l_formulas
  ,p_delete_formulas => false
  );

Line: 681

    rollback to delete_template;

Line: 694

    rollback to delete_template;

Line: 699

end delete_template;

Line: 703

procedure delete_user_structure
  (p_validate                      in     boolean default false
  ,p_drop_formula_packages         in     boolean
  ,p_template_id                   in     number
  ) is
  l_proc                  varchar2(72) := g_package||'delete_user_structure';

Line: 739

  savepoint delete_template;

Line: 804

  pay_element_template_util.delete_template
  (p_template_id     => p_template_id
  ,p_formulas        => l_formulas
  ,p_delete_formulas => true
  );

Line: 833

    rollback to delete_template;

Line: 846

    rollback to delete_template;

Line: 851

end delete_user_structure;