Get Session Language in IFS

SELECT Sys_Context('FNDSESSION_CTX', 'LANGUAGE') FROM DUAL;