DBA Data[Home] [Help]

APPS.PO_MOD_CONTROL_PVT dependencies on PO_DISTRIBUTIONS_DRAFT_ALL

Line 186: FROM po_distributions_draft_all

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);

Line 223: FROM po_distributions_draft_all

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

Line 457: FROM po_distributions_draft_all

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);