APPS.FFHUTL SQL Statements

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

Line: 29

  delete from ff_harness
  where test_id = userenv('SESSIONID') and formula_id = p_formula_id;

Line: 37

  insert into ff_harness (test_id, formula_id, item_name, data_type, usage)
  select userenv('SESSIONID'), p_formula_id, item_name, data_type,
         decode (usage, 'B', 'I', usage)
  from ff_fdi_usages
  where formula_id = p_formula_id
  and (usage = 'I' or usage = 'B' or usage = 'U');

Line: 51

procedure delete_harness is
begin
  hr_utility.set_location ('ffhutl.delete_harness', 1);

Line: 54

  delete from ff_harness where test_id = userenv('SESSIONID');

Line: 55

end delete_harness;