1823: if(X_work_type_name IS NOT NULL)then
1824: Begin
1825: select work_type_id
1826: into l_work_type_id
1827: from pa_work_types_tl
1828: where name=X_work_type_name AND
1829: language = userenv('LANG');
1830: exception
1831: when no_data_found then
2289: if(X_work_type_name IS NOT NULL) then
2290: Begin
2291: select work_type_id
2292: into l_work_type_id
2293: from pa_work_types_tl
2294: where name=X_work_type_name AND
2295: language = userenv('LANG');
2296: exception
2297: when no_data_found then