APPS.PO_LINE_LOCATIONS_DRAFT_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 548: FROM po_line_locations_all

544: clm_delivery_period_uom,
545: clm_promise_period_uom,
546: clm_pop_duration_uom,
547: Nvl(revision_num, 0) --
548: FROM po_line_locations_all
549: WHERE line_location_id = p_line_location_id_tbl(i)
550: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
551: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
552:

Line 708: /*DELETE FROM po_line_locations_all PLL

704:
705: -- bug5187544
706: -- Delete only records that have not been rejected
707:
708: /*DELETE FROM po_line_locations_all PLL
709: WHERE PLL.line_location_id IN
710: ( SELECT PLLD.line_location_id
711: FROM po_line_locations_draft_all PLLD
712: WHERE PLLD.draft_id = p_draft_id

Line 730: DELETE FROM po_line_locations_all

726: -- Note that draft_id condition is not required here, as shipment deletion is
727: -- allowed only for unapproved lines. Thus there will be only one row for
728: -- the line_location_id
729: FORALL i IN 1..l_line_loc_id_tbl.Count()
730: DELETE FROM po_line_locations_all
731: WHERE line_location_id = l_line_loc_id_tbl(i);
732:
733: FORALL i IN 1..l_line_loc_id_tbl.Count()
734: DELETE FROM po_line_locations_all_ext_b

Line 734: DELETE FROM po_line_locations_all_ext_b

730: DELETE FROM po_line_locations_all
731: WHERE line_location_id = l_line_loc_id_tbl(i);
732:
733: FORALL i IN 1..l_line_loc_id_tbl.Count()
734: DELETE FROM po_line_locations_all_ext_b
735: WHERE line_location_id = l_line_loc_id_tbl(i);
736:
737: FORALL i IN 1..l_line_loc_id_tbl.Count()
738: DELETE FROM po_line_locations_all_ext_tl

Line 738: DELETE FROM po_line_locations_all_ext_tl

734: DELETE FROM po_line_locations_all_ext_b
735: WHERE line_location_id = l_line_loc_id_tbl(i);
736:
737: FORALL i IN 1..l_line_loc_id_tbl.Count()
738: DELETE FROM po_line_locations_all_ext_tl
739: WHERE line_location_id = l_line_loc_id_tbl(i);
740:
741: d_position := 10;
742: IF (PO_LOG.d_proc) THEN

Line 793: MERGE INTO po_line_locations_all PLL

789: --PLL.retainage_withheld_amount
790: --PLL.retainage_released_amount
791: --
792: --PLL.uda_template_id
793: MERGE INTO po_line_locations_all PLL
794: USING (
795: SELECT
796: PLLD.line_location_id,
797: PLLD.last_update_date,

Line 1560: FROM po_line_locations_all

1556: END IF;
1557:
1558: SELECT 1
1559: INTO l_dummy
1560: FROM po_line_locations_all
1561: WHERE line_location_id = p_line_location_id
1562: FOR UPDATE NOWAIT;
1563:
1564: IF (PO_LOG.d_proc) THEN