199: l_total_workers NUMBER;
200:
201: BEGIN
202:
203: delete qp_upg_lines_distribution
204: where line_type = v_type;
205: commit;
206:
207: BEGIN
406: select start_line_id,
407: end_line_id
408: into v_min_line,
409: v_max_line
410: from qp_upg_lines_distribution
411: where worker = l_worker
412: and line_type = G_LIST_TYPE_CODE;
413:
414: exception