33: )
34: is
35: Begin
36:
37: insert into qp_upg_lines_distribution
38: (
39: worker,
40: start_line_id,
41: end_line_id,
86: l_total_workers number;
87:
88: Begin
89:
90: delete from qp_upg_lines_distribution
91: where line_type = v_type;
92:
93: commit;
94:
199:
200: BEGIN
201:
202: DELETE from
203: QP_UPG_LINES_DISTRIBUTION
204: where line_type = v_type;
205:
206: COMMIT;
207:
1592: select start_line_id,
1593: end_line_id
1594: into v_min_line,
1595: v_max_line
1596: from qp_upg_lines_distribution
1597: where worker = l_worker
1598: and line_type = 'PLL';
1599:
1600: exception