Create function

CREATE OR REPLACE FUNCTION XX_CHECKRUNNAME
RETURN VARCHAR2
IS
XX_CHECKRUN VARCHAR2(240);
BEGIN
SELECT CHECKRUN_NAME INTO XX_CHECKRUN FROM APPS.AP_INV_SELECTION_CRITERIA_ALL WHERE STATUS='CONFIRMED'
AND LAST_UPDATE_DATE IN(SELECT MAX(LAST_UPDATE_DATE)FROM APPS.AP_INV_SELECTION_CRITERIA_ALL
WHERE STATUS='CONFIRMED');
RETURN XX_CHECKRUN;
EXCEPTION WHEN OTHERS THEN
RETURN 'A';
END XX_CHECKRUNNAME;