APPS.PO_LINES_DRAFT_PKG dependencies on PO_LINES_ALL

Line 452: FROM po_lines_all

448: catalog_name,
449: supplier_part_auxid,
450: ip_category_id,
451: tax_attribute_update_code --
452: FROM po_lines_all
453: WHERE po_line_id = p_po_line_id_tbl(i)
454: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
455: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
456:

Line 611: DELETE FROM po_lines_all PL

607:
608: -- bug5187544
609: -- Delete only records that have not been rejected
610:
611: DELETE FROM po_lines_all PL
612: WHERE PL.po_line_id IN
613: ( SELECT PLD.po_line_id
614: FROM po_lines_draft_all PLD
615: WHERE PLD.draft_id = p_draft_id

Line 642: MERGE INTO po_lines_all PL

638: --PL.bid_number
639: --PL.bid_line_number
640: --PL.svc_amount_notif_sent
641: --PL.svc_completion_notif_sent
642: MERGE INTO po_lines_all PL
643: USING (
644: SELECT
645: PLD.draft_id,
646: PLD.delete_flag,

Line 1318: FROM po_lines_all

1314: END IF;
1315:
1316: SELECT 1
1317: INTO l_dummy
1318: FROM po_lines_all
1319: WHERE po_line_id = p_po_line_id
1320: FOR UPDATE NOWAIT;
1321:
1322: IF (PO_LOG.d_proc) THEN