DBA Data[Home] [Help]

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 198: po_distributions_sv.delete_distributions(X_delete_id,

194:
195: if (X_type_lookup_code NOT IN ('BLANKET', 'RFQ', 'QUOTATION')) THEN
196:
197: -- delete the distributions associated with the header
198: po_distributions_sv.delete_distributions(X_delete_id,
199: 'HEADER');
200:
201: end if; /* X_type_lookup_code not in RFQ and QUOTATION */
202:

Line 252: Moved the po_distributions_sv_delete_distributions before deletion

248: and prior to the fix we were deleting shipment first and then trying to
249: delete the distributions based on the line_location_id which did
250: not delete any records and thereby we ended up having orphan
251: distribution records.
252: Moved the po_distributions_sv_delete_distributions before deletion
253: of shipment lines
254: */
255:
256: -- delete the distributions associated with the release

Line 257: po_distributions_sv.delete_distributions(X_delete_id,

253: of shipment lines
254: */
255:
256: -- delete the distributions associated with the release
257: po_distributions_sv.delete_distributions(X_delete_id,
258: 'RELEASE');
259:
260: X_progress := '030';
261:

Line 420: po_distributions_sv.delete_distributions(X_line_location_id,

416:
417: --dbms_output.put_line('In call to delete children');
418:
419: -- delete the distributions associated with the shipment
420: po_distributions_sv.delete_distributions(X_line_location_id,
421: 'SHIPMENT');
422:
423: -- Remove the req link
424: po_req_lines_sv.remove_req_from_po(X_line_location_id,'SHIPMENT');