eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_LOCALIZED_TEXTS_PKG dependencies on CZ_LOCALIZED_TEXTS

Line 1: package body CZ_LOCALIZED_TEXTS_PKG as

1: package body CZ_LOCALIZED_TEXTS_PKG as
2: /* $Header: cziloctb.pls 120.4 2006/09/26 20:08:47 asiaston ship $ */
3:
4: NO_MODEL_ID NUMBER := -1;
5:

Line 27: from CZ_LOCALIZED_TEXTS

23: X_UI_PAGE_ELEMENT_ID IN VARCHAR2) is
24:
25: cursor C is
26: select ROWID
27: from CZ_LOCALIZED_TEXTS
28: where INTL_TEXT_ID = X_INTL_TEXT_ID
29: and language = userenv('LANG');
30:
31: begin

Line 33: insert into CZ_LOCALIZED_TEXTS

29: and language = userenv('LANG');
30:
31: begin
32:
33: insert into CZ_LOCALIZED_TEXTS
34: (INTL_TEXT_ID
35: ,LOCALIZED_STR
36: ,ORIG_SYS_REF
37: ,CREATION_DATE

Line 71: from CZ_LOCALIZED_TEXTS T

67: from FND_LANGUAGES L
68: where L.INSTALLED_FLAG in ('I', 'B')
69: and not exists
70: ( select NULL
71: from CZ_LOCALIZED_TEXTS T
72: where T.INTL_TEXT_ID = X_INTL_TEXT_ID
73: and T.LANGUAGE = L.LANGUAGE_CODE);
74:
75: open c;

Line 105: update CZ_LOCALIZED_TEXTS set

101: X_UI_PAGE_ELEMENT_ID IN VARCHAR2) is
102:
103: begin
104:
105: update CZ_LOCALIZED_TEXTS set
106: INTL_TEXT_ID =X_INTL_TEXT_ID
107: ,LOCALIZED_STR = DECODE(userenv('LANG'), language, X_LOCALIZED_STR, source_lang, X_LOCALIZED_STR, localized_str)
108: ,ORIG_SYS_REF =X_ORIG_SYS_REF
109: ,DELETED_FLAG =X_DELETED_FLAG

Line 136: delete from CZ_LOCALIZED_TEXTS

132: X_INTL_TEXT_ID in NUMBER
133: ) is
134: begin
135:
136: delete from CZ_LOCALIZED_TEXTS
137: where INTL_TEXT_ID = X_INTL_TEXT_ID ;
138:
139: if (sql%notfound) then
140: raise no_data_found;

Line 159: delete from CZ_LOCALIZED_TEXTS where DELETED_FLAG='1';

155: /* as a quick workaround to fix the time-consuming table handler issue */
156: /* Eventually we'll need to turn them into a separate fix_language procedure */
157: /* Added by Pat Passerini July 17, 2003. */
158: /*
159: delete from CZ_LOCALIZED_TEXTS where DELETED_FLAG='1';
160: commit;
161:
162: update CZ_LOCALIZED_TEXTS T set (
163: LOCALIZED_STR

Line 162: update CZ_LOCALIZED_TEXTS T set (

158: /*
159: delete from CZ_LOCALIZED_TEXTS where DELETED_FLAG='1';
160: commit;
161:
162: update CZ_LOCALIZED_TEXTS T set (
163: LOCALIZED_STR
164: ) = ( select B.LOCALIZED_STR
165: from CZ_LOCALIZED_TEXTS B
166: where B.INTL_TEXT_ID = T.INTL_TEXT_ID

Line 165: from CZ_LOCALIZED_TEXTS B

161:
162: update CZ_LOCALIZED_TEXTS T set (
163: LOCALIZED_STR
164: ) = ( select B.LOCALIZED_STR
165: from CZ_LOCALIZED_TEXTS B
166: where B.INTL_TEXT_ID = T.INTL_TEXT_ID
167: and B.LANGUAGE = T.SOURCE_LANG and B.DELETED_FLAG='0')
168: where (
169: T.INTL_TEXT_ID,

Line 174: from CZ_LOCALIZED_TEXTS SUBB,

170: T.LANGUAGE
171: ) in ( select
172: SUBT.INTL_TEXT_ID,
173: SUBT.LANGUAGE
174: from CZ_LOCALIZED_TEXTS SUBB,
175: CZ_LOCALIZED_TEXTS SUBT
176: where SUBB.INTL_TEXT_ID = SUBT.INTL_TEXT_ID
177: and SUBB.LANGUAGE = SUBT.SOURCE_LANG and SUBT.DELETED_FLAG='0' and SUBB.DELETED_FLAG='0'
178: and ( SUBB.LOCALIZED_STR <> SUBT.LOCALIZED_STR

Line 175: CZ_LOCALIZED_TEXTS SUBT

171: ) in ( select
172: SUBT.INTL_TEXT_ID,
173: SUBT.LANGUAGE
174: from CZ_LOCALIZED_TEXTS SUBB,
175: CZ_LOCALIZED_TEXTS SUBT
176: where SUBB.INTL_TEXT_ID = SUBT.INTL_TEXT_ID
177: and SUBB.LANGUAGE = SUBT.SOURCE_LANG and SUBT.DELETED_FLAG='0' and SUBB.DELETED_FLAG='0'
178: and ( SUBB.LOCALIZED_STR <> SUBT.LOCALIZED_STR
179: or ( SUBB.LOCALIZED_STR is null and SUBT.LOCALIZED_STR is not null )

Line 185: insert into CZ_LOCALIZED_TEXTS (

181: );
182: commit;
183: */
184:
185: insert into CZ_LOCALIZED_TEXTS (
186: LAST_UPDATE_LOGIN,
187: INTL_TEXT_ID,
188: LOCALIZED_STR,
189: LAST_UPDATE_DATE,

Line 217: from CZ_LOCALIZED_TEXTS B,

213: B.UI_PAGE_ID, B.UI_PAGE_ELEMENT_ID,
214: B.persistent_intl_text_id,
215: B.DELETED_FLAG,
216: B.ORIG_SYS_REF
217: from CZ_LOCALIZED_TEXTS B,
218: FND_LANGUAGES L
219: where L.INSTALLED_FLAG in ('I', 'B')
220: and B.LANGUAGE = userenv('LANG')
221: and not exists

Line 223: from CZ_LOCALIZED_TEXTS T

219: where L.INSTALLED_FLAG in ('I', 'B')
220: and B.LANGUAGE = userenv('LANG')
221: and not exists
222: ( select NULL
223: from CZ_LOCALIZED_TEXTS T
224: where T.INTL_TEXT_ID = B.INTL_TEXT_ID
225: and T.LANGUAGE = L.LANGUAGE_CODE);
226: commit;
227:

Line 256: UPDATE CZ_LOCALIZED_TEXTS

252:
253: -- Translate owner to file_last_updated_by
254: f_luby := fnd_load_util.owner_id(X_OWNER);
255:
256: UPDATE CZ_LOCALIZED_TEXTS
257: SET LOCALIZED_STR = NVL(X_LOCALIZED_STR, LOCALIZED_STR)
258: ,LAST_UPDATE_DATE = SYSDATE
259: ,LAST_UPDATED_BY = f_luby
260: ,last_update_login = 0

Line 287: s_intlid cz_localized_texts.intl_text_id%type; -- entity intl_text_id

283: X_SEEDED_FLAG IN VARCHAR2,
284: X_UI_PAGE_ID IN NUMBER,
285: X_UI_PAGE_ELEMENT_ID IN VARCHAR2) IS
286:
287: s_intlid cz_localized_texts.intl_text_id%type; -- entity intl_text_id
288: f_luby number; -- entity owner in file
289: f_ludate date; -- entity update date in file
290: row_id varchar2(64);
291:

Line 295: from cz_localized_texts

291:
292:
293: cursor c_lktx is
294: select intl_text_id
295: from cz_localized_texts
296: where intl_text_id = x_intl_text_id
297: and language = userenv('LANG');
298:
299: begin

Line 312: CZ_LOCALIZED_TEXTS_PKG.INSERT_ROW(

308: fetch c_lktx into s_intlid;
309:
310: if (c_lktx%notfound) then
311: -- No matching rows
312: CZ_LOCALIZED_TEXTS_PKG.INSERT_ROW(
313: X_ROWID => row_id,
314: X_INTL_TEXT_ID => X_INTL_TEXT_ID,
315: X_LOCALIZED_STR => X_LOCALIZED_STR,
316: X_ORIG_SYS_REF => X_ORIG_SYS_REF,

Line 334: CZ_LOCALIZED_TEXTS_PKG.UPDATE_ROW (

330: );
331: else
332: loop
333: -- Update row in all matching locales
334: CZ_LOCALIZED_TEXTS_PKG.UPDATE_ROW (
335: X_INTL_TEXT_ID => X_INTL_TEXT_ID,
336: X_LOCALIZED_STR => X_LOCALIZED_STR,
337: X_ORIG_SYS_REF => X_ORIG_SYS_REF,
338: X_CREATION_DATE => SYSDATE,

Line 368: update CZ_LOCALIZED_TEXTS set

364: X_DELETED_FLAG in VARCHAR2) is
365:
366: begin
367:
368: update CZ_LOCALIZED_TEXTS set
369: INTL_TEXT_ID =X_INTL_TEXT_ID
370: ,LOCALIZED_STR = DECODE(userenv('LANG'), language, X_LOCALIZED_STR, source_lang, X_LOCALIZED_STR, localized_str)
371: ,ORIG_SYS_REF =X_ORIG_SYS_REF
372: ,DELETED_FLAG =X_DELETED_FLAG

Line 388: s_intlid cz_localized_texts.intl_text_id%type; -- entity intl_text_id

384: X_LOCALIZED_STR in VARCHAR2,
385: X_ORIG_SYS_REF in VARCHAR2,
386: X_DELETED_FLAG in VARCHAR2) IS
387:
388: s_intlid cz_localized_texts.intl_text_id%type; -- entity intl_text_id
389: row_id varchar2(64);
390:
391:
392: cursor c_lktx is

Line 394: from cz_localized_texts

390:
391:
392: cursor c_lktx is
393: select intl_text_id
394: from cz_localized_texts
395: where intl_text_id = x_intl_text_id
396: and language = userenv('LANG');
397:
398: begin

Line 405: CZ_LOCALIZED_TEXTS_PKG.INSERT_ROW(

401: fetch c_lktx into s_intlid;
402:
403: if (c_lktx%notfound) then
404: -- No matching rows
405: CZ_LOCALIZED_TEXTS_PKG.INSERT_ROW(
406: X_ROWID => row_id,
407: X_INTL_TEXT_ID => X_INTL_TEXT_ID,
408: X_LOCALIZED_STR => X_LOCALIZED_STR,
409: X_ORIG_SYS_REF => X_ORIG_SYS_REF,

Line 427: CZ_LOCALIZED_TEXTS_PKG.UPDATE_ROW (

423: );
424: else
425: loop
426: -- Update row in all matching locales
427: CZ_LOCALIZED_TEXTS_PKG.UPDATE_ROW (
428: X_INTL_TEXT_ID => X_INTL_TEXT_ID,
429: X_LOCALIZED_STR => X_LOCALIZED_STR,
430: X_ORIG_SYS_REF => X_ORIG_SYS_REF,
431: X_DELETED_FLAG => X_DELETED_FLAG);

Line 442: end CZ_LOCALIZED_TEXTS_PKG;

438:
439: end LOAD_ROW;
440:
441:
442: end CZ_LOCALIZED_TEXTS_PKG;