1403: ELSIF label IN ('VENDOR_ID') THEN
1404:
1405: SELECT vendor_name
1406: INTO id
1407: FROM po_vendors
1408: WHERE vendor_id = p_id;
1409:
1410: ELSIF label IN ('VENDOR_SITE_ID') THEN
1411:
5814:
5815:
5816: --
5817: x_item_inspection_req_flag varchar2(1):=NULL;
5818: x_vendor_receipt_required_flag po_vendors.receipt_required_flag%type := NULL;
5819: x_transaction_flow_header_id PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE;
5820: --
5821: l_uom_conversion_rate MTL_UOM_CONVERSIONS.conversion_rate%TYPE := 1;
5822: l_currency_conversion_rate PO_HEADERS_ALL.rate%TYPE := 1;
6197:
6198: BEGIN
6199: SELECT v.receipt_required_flag
6200: INTO x_vendor_receipt_required_flag
6201: FROM po_vendors v
6202: WHERE v.vendor_id = x_vendor_id;
6203:
6204:
6205: EXCEPTION