734: SELECT
735: DOC_TYPE
736: INTO DOC_TYPE1
737: FROM
738: DUAL;
739: IF SQL%NOTFOUND THEN
740: RETURN (NULL);
741: ELSE
742: RETURN (DOC_TYPE1);
758: ,'Warehouse Range: ' || FROM_WHSE || ' - All '
759: ,' Warehouse Range: ' || FROM_WHSE || ' - ' || TO_WHSE))
760: INTO RANGEV
761: FROM
762: DUAL;
763: RETURN (RANGEV);
764: END RANGE1CFFORMULA;
765: FUNCTION RANGE2CFFORMULA RETURN VARCHAR2 IS
766: BEGIN
810: SELECT
811: UNIT_COSTCF * COUNT_QTYSC
812: INTO COSTACCUM
813: FROM
814: DUAL;
815: RETURN (COSTACCUM);
816: RETURN NULL;
817: EXCEPTION
818: WHEN OTHERS THEN