398:
399: IF p_selected_line_tbl.COUNT > 0 THEN
400: SELECT oe_reservation_sets_s.nextval
401: INTO l_set_id 402: FROM dual; 403: -- selected rows are inserted into oe_rsv_set_details table without parent, and then the
404: -- concurrent program will delete these rows after processing.
405: FOR I IN 1..p_selected_line_tbl.COUNT LOOP
406: INSERT INTO oe_rsv_set_details