APPS.PO_HEADERS_DRAFT_PKG dependencies on PO_HEADERS_DRAFT_ALL

Line 72: DELETE FROM po_headers_draft_all

68: ( 'PO_HEADERS_DEL',
69: l_header_id||'-'||p_draft_id,
70: '', '', '', '', '');
71:
72: DELETE FROM po_headers_draft_all
73: WHERE draft_id = p_draft_id
74: AND po_header_id = NVL(p_po_header_id, po_header_id);
75:
76: d_position := 10;

Line 173: INSERT INTO po_headers_draft_all

169: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
170: END IF;
171:
172: FORALL i IN 1..p_po_header_id_tbl.COUNT
173: INSERT INTO po_headers_draft_all
174: ( draft_id,
175: delete_flag,
176: change_accepted_flag,
177: po_header_id,

Line 579: UPDATE po_headers_draft_all

575: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
576: END IF;
577:
578: FORALL i IN 1..p_po_header_id_tbl.COUNT
579: UPDATE po_headers_draft_all
580: SET delete_flag = p_delete_flag_tbl(i)
581: WHERE po_header_id = p_po_header_id_tbl(i)
582: AND draft_id = p_draft_id_tbl(i)
583: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989

Line 729: FROM po_headers_draft_all PHD

725:
726: DELETE FROM po_headers_all PH
727: WHERE PH.po_header_id IN
728: ( SELECT PHD.po_header_id
729: FROM po_headers_draft_all PHD
730: WHERE PHD.draft_id = p_draft_id
731: AND PHD.delete_flag = 'Y'
732: AND NVL(PHD.change_accepted_flag, 'Y') = 'Y');
733:

Line 968: FROM po_headers_draft_all PHD

964: PHD.enable_all_sites, --ER 9824167
965: PHD.clm_contract_finance_code,
966: PHD.clm_special_contract_type, -- CLM Phase 4
967: PHD.clm_payment_instr_code -- CLM Phase 4
968: FROM po_headers_draft_all PHD
969: WHERE PHD.draft_id = p_draft_id
970: AND NVL(PHD.change_accepted_flag, 'Y') = 'Y'
971: ) PHDV
972: ON (PH.po_header_id = PHDV.po_header_id)

Line 1596: FROM po_headers_draft_all

1592: END IF;
1593:
1594: SELECT 1
1595: INTO l_dummy
1596: FROM po_headers_draft_all
1597: WHERE po_header_id = p_po_header_id
1598: AND draft_id = p_draft_id
1599: FOR UPDATE NOWAIT;
1600: