DBA Data[Home] [Help]

APPS.PJI_PJ_PROJ_CLASS_EXTR dependencies on DUAL

Line 44: select USERENV('LANG') into l_current_run_lang from dual ;

40: LOCK TABLE pji_class_categories IN EXCLUSIVE MODE;
41:
42: Pji_Utils.write2log('Locked table PJI_CLASS_CATEGORIES in exclusive mode',TRUE,2);
43:
44: select USERENV('LANG') into l_current_run_lang from dual ;
45: l_last_run_lang := PJI_UTILS.GET_PARAMETER('LAST_REQUEST_LANG');
46: if(nvl(l_last_run_lang,'-99') <> nvl(l_current_run_lang,'-99')) then
47: delete from pji_class_categories;
48: PJI_UTILS.SET_PARAMETER('LAST_REQUEST_LANG',l_current_run_lang); -- Bug 4736331 : set the value of LAST_REQUEST_LANG in pji_system_parameters.