APPS.PO_LINES_DRAFT_PKG dependencies on PO_LINES_DRAFT_ALL

Line 48: DELETE FROM po_lines_draft_all

44: IF (PO_LOG.d_proc) THEN
45: PO_LOG.proc_begin(d_module);
46: END IF;
47:
48: DELETE FROM po_lines_draft_all
49: WHERE draft_id = p_draft_id
50: AND po_line_id = NVL(p_po_line_id, po_line_id);
51:
52: d_position := 10;

Line 150: INSERT INTO po_lines_draft_all

146: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
147: END IF;
148:
149: FORALL i IN 1..p_po_line_id_tbl.COUNT
150: INSERT INTO po_lines_draft_all
151: (
152: draft_id,
153: delete_flag,
154: change_accepted_flag,

Line 463: UPDATE po_lines_draft_all

459: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
460: END IF;
461:
462: FORALL i IN 1..p_po_line_id_tbl.COUNT
463: UPDATE po_lines_draft_all
464: SET delete_flag = p_delete_flag_tbl(i)
465: WHERE po_line_id = p_po_line_id_tbl(i)
466: AND draft_id = p_draft_id_tbl(i)
467: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989

Line 614: FROM po_lines_draft_all PLD

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
616: AND PLD.delete_flag = 'Y'
617: AND NVL(PLD.change_accepted_flag, 'Y') = 'Y' );
618:

Line 794: FROM po_lines_draft_all PLD

790: PLD.catalog_name,
791: PLD.supplier_part_auxid,
792: PLD.ip_category_id,
793: PLD.tax_attribute_update_code --
794: FROM po_lines_draft_all PLD
795: WHERE PLD.draft_id = p_draft_id
796: AND NVL(PLD.change_accepted_flag, 'Y') = 'Y'
797: ) PLDV
798: ON (PL.po_line_id = PLDV.po_line_id)

Line 1274: FROM po_lines_draft_all

1270: END IF;
1271:
1272: SELECT 1
1273: INTO l_dummy
1274: FROM po_lines_draft_all
1275: WHERE po_line_id = p_po_line_id
1276: AND draft_id = p_draft_id
1277: FOR UPDATE NOWAIT;
1278: