APPS.PO_LINE_LOCATIONS_DRAFT_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 488: FROM po_line_locations_all

484: retainage_released_amount,
485: --
486: outsourced_assembly,
487: tax_attribute_update_code --
488: FROM po_line_locations_all
489: WHERE line_location_id = p_line_location_id_tbl(i)
490: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
491: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
492:

Line 647: DELETE FROM po_line_locations_all PLL

643:
644: -- bug5187544
645: -- Delete only records that have not been rejected
646:
647: DELETE FROM po_line_locations_all PLL
648: WHERE PLL.line_location_id IN
649: ( SELECT PLLD.line_location_id
650: FROM po_line_locations_draft_all PLLD
651: WHERE PLLD.draft_id = p_draft_id

Line 703: MERGE INTO po_line_locations_all PLL

699: --PLL.amount_recouped
700: --PLL.retainage_withheld_amount
701: --PLL.retainage_released_amount
702: --
703: MERGE INTO po_line_locations_all PLL
704: USING (
705: SELECT
706: PLLD.line_location_id,
707: PLLD.last_update_date,

Line 1431: FROM po_line_locations_all

1427: END IF;
1428:
1429: SELECT 1
1430: INTO l_dummy
1431: FROM po_line_locations_all
1432: WHERE line_location_id = p_line_location_id
1433: FOR UPDATE NOWAIT;
1434:
1435: IF (PO_LOG.d_proc) THEN