APPS.PO_HEADERS_SV1 dependencies on PO_DISTRIBUTIONS

Line 160: FROM po_distributions

156:
157: X_progress VARCHAR2(3) := '';
158:
159: cursor c1 is SELECT 'Y'
160: FROM po_distributions
161: WHERE po_header_id = X_po_header_id
162: AND nvl(encumbered_flag,'N') <> 'N';
163:
164: --BUG 3230237

Line 247: FROM po_distributions_all

243:
244: -- Collect all deleted distributions
245: SELECT po_distribution_id
246: BULK COLLECT INTO l_deleted_dist_list
247: FROM po_distributions_all
248: WHERE po_header_id = X_po_header_id;
249:
250:
251: IF (PO_LOG.d_stmt) THEN

Line 274: po_distributions_sv.delete_distributions(X_po_header_id, 'HEADER');

270: if (X_type_lookup_code IN ('STANDARD','PLANNED','BLANKET')) then --BUG 3230237
271: /* Delete Distributions for a PO */
272: X_progress := '020';
273: --dbms_output.put_line('Before Delete All Distributions');
274: po_distributions_sv.delete_distributions(X_po_header_id, 'HEADER');
275: end if;
276:
277: if (X_type_lookup_code <> 'CONTRACT') then
278: