APPS.QP_QUALIFICATION_IND_UPG_UTIL dependencies on QP_UPG_LINES_DISTRIBUTION

Line 20: from qp_upg_lines_distribution

16: select start_line_id,
17: end_line_id
18: into v_min_line,
19: v_max_line
20: from qp_upg_lines_distribution
21: where worker = l_worker
22: and line_type = 'QUA';
23:
24: exception

Line 88: from qp_upg_lines_distribution

84: select start_line_id,
85: end_line_id
86: into v_min_line,
87: v_max_line
88: from qp_upg_lines_distribution
89: where worker = l_worker
90: and line_type = 'QUA';
91:
92: exception

Line 156: from qp_upg_lines_distribution

152: select start_line_id,
153: end_line_id
154: into v_min_line,
155: v_max_line
156: from qp_upg_lines_distribution
157: where worker = l_worker
158: and line_type = 'QUA';
159:
160: exception

Line 337: DELETE FROM qp_upg_lines_distribution

333: L_TOTAL_WORKERS NUMBER;
334:
335: BEGIN
336:
337: DELETE FROM qp_upg_lines_distribution
338: WHERE line_type = l_type;
339: COMMIT;
340:
341: BEGIN

Line 406: from qp_upg_lines_distribution

402: --there isn't even 1 such slab existing.
403: begin
404: select 1
405: into l_count
406: from qp_upg_lines_distribution
407: where line_type = l_type
408: and last_proc_line is not null
409: and rownum = 1;
410: exception

Line 420: delete from qp_upg_lines_distribution

416: --Re-runnable slabs do not already exist.
417: if l_count = 0 then
418:
419: --So that even non-rerunnable slabs, if any, may be purged.
420: delete from qp_upg_lines_distribution
421: where line_type = l_type;
422: commit;
423:
424: select round(count(*)/l_workers) + 1