APPS.PO_SHIPMENTS_SV4 dependencies on PO_DISTRIBUTIONS_SV

Line 121: po_distributions_sv.delete_distributions(X_delete_id,

117:
118: if (X_type_lookup_code NOT IN ('BLANKET','RFQ', 'QUOTATION')) THEN
119:
120: -- delete the distributions associated with the line.
121: po_distributions_sv.delete_distributions(X_delete_id,
122: 'LINE');
123:
124: end if; /* X_type_lookup_code not in RFQ and QUOTATION */
125:

Line 191: po_distributions_sv.delete_distributions(X_delete_id,

187:
188: if (X_type_lookup_code NOT IN ('BLANKET', 'RFQ', 'QUOTATION')) THEN
189:
190: -- delete the distributions associated with the header
191: po_distributions_sv.delete_distributions(X_delete_id,
192: 'HEADER');
193:
194: end if; /* X_type_lookup_code not in RFQ and QUOTATION */
195:

Line 245: Moved the po_distributions_sv_delete_distributions before deletion

241: and prior to the fix we were deleting shipment first and then trying to
242: delete the distributions based on the line_location_id which did
243: not delete any records and thereby we ended up having orphan
244: distribution records.
245: Moved the po_distributions_sv_delete_distributions before deletion
246: of shipment lines
247: */
248:
249: -- delete the distributions associated with the release

Line 250: po_distributions_sv.delete_distributions(X_delete_id,

246: of shipment lines
247: */
248:
249: -- delete the distributions associated with the release
250: po_distributions_sv.delete_distributions(X_delete_id,
251: 'RELEASE');
252:
253: X_progress := '030';
254:

Line 411: po_distributions_sv.delete_distributions(X_line_location_id,

407:
408: --dbms_output.put_line('In call to delete children');
409:
410: -- delete the distributions associated with the shipment
411: po_distributions_sv.delete_distributions(X_line_location_id,
412: 'SHIPMENT');
413:
414: -- Remove the req link
415: po_req_lines_sv.remove_req_from_po(X_line_location_id,'SHIPMENT');