666: v_test := 0;
667:
668: if v_emergency = 'YES' then
669: select count(-1) into v_test
670: from po_reqexpress_headers
671: where express_name = v_return_template
672: and (reserve_po_number = 'YES' OR reserve_po_number = 'OPTIONAL');
673: else
674: select count(-1) into v_test
671: where express_name = v_return_template
672: and (reserve_po_number = 'YES' OR reserve_po_number = 'OPTIONAL');
673: else
674: select count(-1) into v_test
675: from po_reqexpress_headers
676: where express_name = v_return_template
677: and (reserve_po_number = 'NO' OR reserve_po_number = 'OPTIONAL' OR reserve_po_number is null);
678: end if;
679: