6120: BEGIN
6121:
6122:
6123: IF P_INVOICE_VALUE_SORT = 'ASC' THEN
6124: RETURN WSH_PICK_CUSTOM.OUTSTANDING_ORDER_VALUE(p_SOURCE_HEADER_ID);
6125:
6126: ELSIF P_INVOICE_VALUE_SORT = 'DESC' THEN
6127: RETURN (-1 * WSH_PICK_CUSTOM.OUTSTANDING_ORDER_VALUE(p_SOURCE_HEADER_ID));
6128:
6123: IF P_INVOICE_VALUE_SORT = 'ASC' THEN
6124: RETURN WSH_PICK_CUSTOM.OUTSTANDING_ORDER_VALUE(p_SOURCE_HEADER_ID);
6125:
6126: ELSIF P_INVOICE_VALUE_SORT = 'DESC' THEN
6127: RETURN (-1 * WSH_PICK_CUSTOM.OUTSTANDING_ORDER_VALUE(p_SOURCE_HEADER_ID));
6128:
6129: ELSE
6130: RETURN NULL;
6131: END IF;