APPS.PO_MOD_CONTROL_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 600: FROM po_line_locations_draft_all

596:
597: DELETE FROM po_line_locations_all_ext_b
598: WHERE draft_id = p_draft_id
599: AND line_location_id IN(SELECT line_location_id
600: FROM po_line_locations_draft_all
601: WHERE po_header_id = p_entity_id
602: AND draft_id = p_draft_id);
603:
604: DELETE FROM po_line_locations_all_ext_tl

Line 607: FROM po_line_locations_draft_all

603:
604: DELETE FROM po_line_locations_all_ext_tl
605: WHERE draft_id = p_draft_id
606: AND line_location_id IN(SELECT line_location_id
607: FROM po_line_locations_draft_all
608: WHERE po_header_id = p_entity_id
609: AND draft_id = p_draft_id);
610:
611: ELSIF p_entity_level = 'PO_LINE' THEN

Line 626: FROM po_line_locations_draft_all

622:
623: DELETE FROM po_line_locations_all_ext_b
624: WHERE draft_id = p_draft_id
625: AND line_location_id IN (SELECT line_location_id
626: FROM po_line_locations_draft_all
627: WHERE po_line_id = p_entity_id
628: AND draft_id = p_draft_id);
629:
630: DELETE FROM po_lines_all_ext_tl

Line 643: FROM po_line_locations_draft_all

639:
640: DELETE FROM po_line_locations_all_ext_tl
641: WHERE draft_id = p_draft_id
642: AND line_location_id IN (SELECT line_location_id
643: FROM po_line_locations_draft_all
644: WHERE po_line_id = p_entity_id
645: AND draft_id = p_draft_id);
646:
647: ELSIF p_entity_level = 'PO_SHIPMENT' THEN

Line 833: update po_line_locations_draft_all

829:
830: d_position := 50;
831: -- If return status success, then go ahead
832:
833: update po_line_locations_draft_all
834: set control_action = p_action
835: where draft_id = p_draft_id;
836:
837: d_position := 60;