45: ) return number is
46: l_batch_id number;
47: begin
48: -- Get the batch_id to allow return from function.
49: select hr_pump_batch_headers_s.nextval
50: into l_batch_id
51: from sys.dual;
52:
53: -- Straight-forward insert statement
51: from sys.dual;
52:
53: -- Straight-forward insert statement
54: -- We don't look for an existing batch.
55: insert into hr_pump_batch_headers (
56: batch_id,
57: batch_name,
58: batch_status,
59: reference,