18: l_total_workers NUMBER;
19:
20: BEGIN
21:
22: delete qp_upg_lines_distribution
23: where line_type = v_type;
24: commit;
25:
26: BEGIN
140:
141: BEGIN
142: SELECT start_line_id, end_line_id
143: INTO v_min_line, v_max_line
144: FROM qp_upg_lines_distribution
145: WHERE worker = l_worker
146: AND line_type = G_LIST_TYPE_CODE;
147: EXCEPTION
148: WHEN NO_DATA_FOUND THEN