Line 197: select userenv('LANG') into l_language_code from dual;
193: ELSE
194: -- Selecting userenv('LANG') into language code based on
195: -- the discussion with Wasi and advised by him.
196: 197: select userenv('LANG') into l_language_code from dual; 198: END IF;
199:
200: UPDATE ENI_DENORM_HRCHY_STG
201: SET PARENT_ID = p_parent_id,