APPS.XTR_MISC_P dependencies on XTR_SYS_LANGUAGES

Line 256: v_module_name XTR_SYS_LANGUAGES.MODULE_NAME%type;

252: l_original_text IN VARCHAR2) is -- 3424625 Added new parameter
253: --
254: l_module VARCHAR2(20);
255: v_rowid VARCHAR2(100);
256: v_module_name XTR_SYS_LANGUAGES.MODULE_NAME%type;
257: v_canvas_type XTR_SYS_LANGUAGES.CANVAS_TYPE%type :='TEXT';
258: v_item_name XTR_SYS_LANGUAGES.ITEM_NAME%type;
259:
260: --

Line 257: v_canvas_type XTR_SYS_LANGUAGES.CANVAS_TYPE%type :='TEXT';

253: --
254: l_module VARCHAR2(20);
255: v_rowid VARCHAR2(100);
256: v_module_name XTR_SYS_LANGUAGES.MODULE_NAME%type;
257: v_canvas_type XTR_SYS_LANGUAGES.CANVAS_TYPE%type :='TEXT';
258: v_item_name XTR_SYS_LANGUAGES.ITEM_NAME%type;
259:
260: --
261: -- Create cursor to fetch all the rows that satisfies the given criteria

Line 258: v_item_name XTR_SYS_LANGUAGES.ITEM_NAME%type;

254: l_module VARCHAR2(20);
255: v_rowid VARCHAR2(100);
256: v_module_name XTR_SYS_LANGUAGES.MODULE_NAME%type;
257: v_canvas_type XTR_SYS_LANGUAGES.CANVAS_TYPE%type :='TEXT';
258: v_item_name XTR_SYS_LANGUAGES.ITEM_NAME%type;
259:
260: --
261: -- Create cursor to fetch all the rows that satisfies the given criteria
262: -- bug 3424625 modified cursor lang_cursor

Line 271: from XTR_SYS_LANGUAGES_TL tl , xtr_sys_languages sl

267: v_language VARCHAR2,
268: v_text VARCHAR2,
269: v_original_text VARCHAR2) IS
270: select tl.MODULE_NAME, tl.CANVAS_TYPE, tl.ITEM_NAME
271: from XTR_SYS_LANGUAGES_TL tl , xtr_sys_languages sl
272: where tl.MODULE_NAME like v_module_name
273: and tl.CANVAS_TYPE = v_canvas_type
274: and tl.LANGUAGE = v_language
275: and tl.TEXT = v_text

Line 283: from XTR_SYS_LANGUAGES_TL tl

279: and tl.item_name =sl.item_name;
280:
281:
282: /* select tl.MODULE_NAME, tl.CANVAS_TYPE, tl.ITEM_NAME
283: from XTR_SYS_LANGUAGES_TL tl
284: where tl.MODULE_NAME like v_module_name
285: and tl.CANVAS_TYPE = v_canvas_type
286: and tl.LANGUAGE = v_language
287: and tl.TEXT = v_text; */

Line 310: XTR_SYS_LANGUAGES_PKG.Update_Row

306: exit when lang_cursor%notfound or lang_cursor%notfound is null;
307: --
308: -- Update row based on rowid
309: --
310: XTR_SYS_LANGUAGES_PKG.Update_Row
311: (X_MODULE_NAME => v_module_name,
312: X_CANVAS_TYPE => v_canvas_type,
313: X_ITEM_NAME => v_item_name,
314: X_ORIGINAL_TEXT => null,

Line 324: XTR_SYS_LANGUAGES_PKG.Insert_Row

320:
321: end loop; -- lang_cursor
322: if l_cnt =0 then
323: l_orginal_text :=initcap(replace(l_item,'_',' '));
324: XTR_SYS_LANGUAGES_PKG.Insert_Row
325: (X_ROWID => l_rowid,
326: X_MODULE_NAME => l_form,
327: X_CANVAS_TYPE => 'TEXT',
328: X_ITEM_NAME => l_item,