149: AND PORH.PO_HEADER_ID = X_Po_Header_Id;
150:
151: /* FPJ CONTERMS START */
152: l_contracts_document_type VARCHAR2(150);
153: l_conterms_exist_flag po_headers_all.conterms_exist_flag%TYPE;
154: l_vendor_id po_headers_all.vendor_id%TYPE;
155: l_vendor_site_id po_headers_all.vendor_site_id%TYPE;
156: l_vendor_information_updated boolean := FND_API.To_boolean(FND_API.G_FALSE);
157:
150:
151: /* FPJ CONTERMS START */
152: l_contracts_document_type VARCHAR2(150);
153: l_conterms_exist_flag po_headers_all.conterms_exist_flag%TYPE;
154: l_vendor_id po_headers_all.vendor_id%TYPE;
155: l_vendor_site_id po_headers_all.vendor_site_id%TYPE;
156: l_vendor_information_updated boolean := FND_API.To_boolean(FND_API.G_FALSE);
157:
158: l_msg_data VARCHAR2(2000);
151: /* FPJ CONTERMS START */
152: l_contracts_document_type VARCHAR2(150);
153: l_conterms_exist_flag po_headers_all.conterms_exist_flag%TYPE;
154: l_vendor_id po_headers_all.vendor_id%TYPE;
155: l_vendor_site_id po_headers_all.vendor_site_id%TYPE;
156: l_vendor_information_updated boolean := FND_API.To_boolean(FND_API.G_FALSE);
157:
158: l_msg_data VARCHAR2(2000);
159: l_msg_count NUMBER;
242: -- SQL JOIN: rowid
243:
244: SELECT vendor_id, vendor_site_id, conterms_exist_flag
245: INTO l_vendor_id, l_vendor_site_id, l_conterms_exist_flag
246: FROM po_headers_all
247: WHERE rowid = X_Rowid;
248: /* FPJ CONTERMS END*/
249:
250: -- dbms_output.put_line('Before the Table Handler Update');