182:
183: -- Collect all withdrawn distributions
184: SELECT po_distribution_id
185: BULK COLLECT INTO l_withdrawn_dist_list
186: FROM po_distributions_draft_all
187: WHERE draft_id = p_draft_id;
188:
189: IF (PO_LOG.d_stmt) THEN
190: PO_LOG.stmt(d_module,d_position,'l_withdrawn_line_list',l_withdrawn_line_list);
219:
220: -- Collect all PAR withdrawn distributions
221: SELECT po_distribution_id
222: BULK COLLECT INTO l_withdrawn_par_dist_list
223: FROM po_distributions_draft_all
224: WHERE draft_id = p_draft_id
225: AND par_distribution_id IS NOT NULL;
226:
227: IF (PO_LOG.d_stmt) THEN
453:
454: -- Collect all deleted distributions
455: SELECT po_distribution_id
456: BULK COLLECT INTO l_deleted_dist_list
457: FROM po_distributions_draft_all
458: WHERE draft_id = p_draft_id;
459:
460: IF (PO_LOG.d_stmt) THEN
461: PO_LOG.stmt(d_module,d_position,'l_deleted_line_list',l_deleted_line_list);