APPS.IEU_WORK_SOURCE_PVT dependencies on IEU_UWQM_WORK_SOURCES_TL

Line 50: l_language ieu_uwqm_work_sources_tl.language%type;

46:
47: l_action_map_id NUMBER(15);
48: sql_stmt varchar2(2000);
49: l_count number:=0;
50: l_language ieu_uwqm_work_sources_tl.language%type;
51: x_rowid varchar2(20000);
52:
53: l_ws_id number;
54: l_ws_assoc_prop_id number;

Line 271: EXECUTE IMMEDIATE ' select count(*) from ieu_uwqm_work_sources_b b, ieu_uwqm_work_sources_tl tl '||

267: x_msg_count := x_msg_count+1;
268: x_msg_data := 'IEU_PROV_WS_CODE_INVALID$';
269: END if;
270: IF (r_mode = 'create') then
271: EXECUTE IMMEDIATE ' select count(*) from ieu_uwqm_work_sources_b b, ieu_uwqm_work_sources_tl tl '||
272: ' where upper(tl.ws_name) = upper(:1) and b.not_valid_flag=:2 ' ||
273: ' and b.ws_id = tl.ws_id and tl.language = :3 '
274: INTO l_count USING p_ws_name, l_not_valid_flag, FND_GLOBAL.CURRENT_LANGUAGE ;
275: IF (l_count > 0) then