DBA Data[Home] [Help]

APPS.PO_DISTRIBUTIONS_SV dependencies on STANDARD

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

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

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

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

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

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

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

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