APPS.PO_HEADERS_DRAFT_PVT dependencies on PO_HEADERS_DRAFT_ALL

Line 82: FROM po_headers_draft_all PHD

78: SELECT l_key,
79: l_index_tbl(i)
80: FROM DUAL
81: WHERE EXISTS (SELECT 1
82: FROM po_headers_draft_all PHD
83: WHERE PHD.draft_id = p_draft_id_tbl(i)
84: AND PHD.po_header_id = NVL(p_po_header_id_tbl(i),
85: PHD.po_header_id)
86: AND NVL(PHD.change_accepted_flag, 'Y') = 'Y');

Line 214: l_delete_flag PO_HEADERS_DRAFT_ALL.delete_flag%TYPE;

210: d_api_name CONSTANT VARCHAR2(30) := 'apply_changes';
211: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
212: d_position NUMBER;
213:
214: l_delete_flag PO_HEADERS_DRAFT_ALL.delete_flag%TYPE;
215: l_record_exists_in_txn VARCHAR2(1);
216: l_dml_operation VARCHAR2(10);
217: l_vendor_changed VARCHAR2(1);
218: l_vendor_site_changed VARCHAR2(1);

Line 245: FROM po_headers_draft_all PHD,

241: d_position := 10;
242: SELECT NVL(PHD.delete_flag, 'N'),
243: DECODE (PH.po_header_id, NULL, 'N', 'Y')
244: INTO l_delete_flag, l_record_exists_in_txn
245: FROM po_headers_draft_all PHD,
246: po_headers_all PH
247: WHERE PHD.draft_id = p_draft_info.draft_id
248: AND PHD.po_header_id = p_draft_info.po_header_Id
249: AND NVL(PHD.change_accepted_flag, 'Y') = 'Y'

Line 278: FROM po_headers_draft_all PHD,

274: l_vendor_site_changed,
275: l_conterms_exist_flag,
276: l_new_vendor_id,
277: l_new_vendor_site_id
278: FROM po_headers_draft_all PHD,
279: po_headers_all PH
280: WHERE PHD.draft_id = p_draft_info.draft_id
281: AND PHD.po_header_id = p_draft_info.po_header_id
282: AND PHD.po_header_id = PH.po_header_id;