887: /****************************************************************************
888: * This function returns urgent flag value of a given requisition header id *
889: ****************************************************************************/
890: function get_urgent_flag(req_header_id IN NUMBER) RETURN VARCHAR2 is
891: value PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE := '';
892: begin
893: select plc_urg.displayed_field
894: into value
895: from
894: into value
895: from
896: po_requisition_headers_all prh,
897: po_requisition_lines_all prl,
898: po_lookup_codes plc_urg
899: where
900: prh.requisition_header_id = req_header_id and
901: prl.requisition_header_id = prh.requisition_header_id and
902: plc_urg.lookup_code = nvl(prl.urgent_flag, 'N') and