APPS.PO_HEADERS_DRAFT_PVT dependencies on PO_HEADERS_ALL

Line 219: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_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);
219: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
220: l_new_vendor_id PO_HEADERS_ALL.vendor_id%TYPE;
221: l_new_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
222: l_contract_document_type VARCHAR2(20);
223:

Line 220: l_new_vendor_id PO_HEADERS_ALL.vendor_id%TYPE;

216: l_dml_operation VARCHAR2(10);
217: l_vendor_changed VARCHAR2(1);
218: l_vendor_site_changed VARCHAR2(1);
219: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
220: l_new_vendor_id PO_HEADERS_ALL.vendor_id%TYPE;
221: l_new_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
222: l_contract_document_type VARCHAR2(20);
223:
224: l_return_status VARCHAR2(1);

Line 221: l_new_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;

217: l_vendor_changed VARCHAR2(1);
218: l_vendor_site_changed VARCHAR2(1);
219: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
220: l_new_vendor_id PO_HEADERS_ALL.vendor_id%TYPE;
221: l_new_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
222: l_contract_document_type VARCHAR2(20);
223:
224: l_return_status VARCHAR2(1);
225: l_msg_data VARCHAR2(2000);

Line 246: po_headers_all PH

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'
250: AND PHD.po_header_id = PH.po_header_id(+);

Line 279: po_headers_all PH

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;
283: END IF;

Line 314: FROM po_headers_all PH

310: '', '', '', '', '');
311:
312: SELECT NVL(PH.conterms_exist_flag, 'N')
313: INTO l_conterms_exist_flag
314: FROM po_headers_all PH
315: WHERE po_header_id = p_draft_info.po_header_id;
316:
317: l_contract_document_type :=
318: PO_CONTERMS_UTL_GRP.get_po_contract_doctype