DBA Data[Home] [Help]

APPS.PO_DISTRIBUTIONS_SV dependencies on STANDARD

Line 426: and shipment_type in ('STANDARD', 'PLANNED'));

422: where line_location_id in
423: (select line_location_id
424: from po_line_locations
425: where po_line_id = x_delete_id
426: and shipment_type in ('STANDARD', 'PLANNED'));
427:
428: ELSIF (X_delete_entity = 'HEADER') THEN
429:
430: --

Line 435: AND distribution_type in ('STANDARD', 'PLANNED', 'AGREEMENT');

431: --We can have encumbrance distributions tied to a BPA header.
432: --Allow distributions with distribution_type 'AGREEMENT' to be deleted.
433: DELETE PO_DISTRIBUTIONS_ALL /*Bug6632095: using base table instead of view */
434: WHERE po_header_id = x_delete_id
435: AND distribution_type in ('STANDARD', 'PLANNED', 'AGREEMENT');
436: --
437:
438: END IF;
439:

Line 619: -- calls the pricing APIs to calculate the new price if a Standard PO

615: --Locks:
616: -- None
617: --Function:
618: -- Deletes the selected Line Location from the Database and
619: -- calls the pricing APIs to calculate the new price if a Standard PO
620: -- shipment with a source reference is deleted
621: --Parameters:
622: --IN:
623: --p_po_distribution_id

Line 628: -- Document Sub type of the PO [STANDARD/BLANKET]

624: -- Distribution ID for the Po Distribution to be deleted
625: --p_line_loc_id
626: -- Line Location ID for the Po Shipment to be deleted
627: --p_doc_subtype
628: -- Document Sub type of the PO [STANDARD/BLANKET]
629: --p_approved_date
630: -- Date on which the document was last approved. Get it from the PO header.
631: --p_style_disp_name
632: -- Display Name of the document style