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.ZX_DET_FACTOR_TEMPL_PKG dependencies on ZX_DET_FACTOR_TEMPL_TL

Line 66: insert into ZX_DET_FACTOR_TEMPL_TL (

62: X_PROGRAM_ID,
63: X_PROGRAM_LOGIN_ID,
64: X_OBJECT_VERSION_NUMBER);
65:
66: insert into ZX_DET_FACTOR_TEMPL_TL (
67: DET_FACTOR_TEMPL_ID,
68: DET_FACTOR_TEMPL_NAME,
69: DET_FACTOR_TEMPL_DESC,
70: CREATION_DATE,

Line 92: from ZX_DET_FACTOR_TEMPL_TL T

88: from FND_LANGUAGES L
89: where L.INSTALLED_FLAG in ('I', 'B')
90: and not exists
91: (select NULL
92: from ZX_DET_FACTOR_TEMPL_TL T
93: where T.DET_FACTOR_TEMPL_ID = X_DET_FACTOR_TEMPL_ID
94: and T.LANGUAGE = L.LANGUAGE_CODE);
95: open c;
96: fetch c into X_ROWID;

Line 144: from ZX_DET_FACTOR_TEMPL_TL

140:
141: cursor c1 is select DET_FACTOR_TEMPL_NAME,
142: DET_FACTOR_TEMPL_DESC,
143: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
144: from ZX_DET_FACTOR_TEMPL_TL
145: where DET_FACTOR_TEMPL_ID = X_DET_FACTOR_TEMPL_ID
146: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
147: for update of DET_FACTOR_TEMPL_ID nowait;
148: begin

Line 244: update ZX_DET_FACTOR_TEMPL_TL set

240: if (sql%notfound) then
241: raise no_data_found;
242: end if;
243:
244: update ZX_DET_FACTOR_TEMPL_TL set
245: DET_FACTOR_TEMPL_NAME = X_DET_FACTOR_TEMPL_NAME,
246: DET_FACTOR_TEMPL_DESC = X_DET_FACTOR_TEMPL_DESC,
247: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
248: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 268: delete from ZX_DET_FACTOR_TEMPL_TL

264: procedure DELETE_ROW (
265: X_DET_FACTOR_TEMPL_ID in NUMBER) is
266: begin
267:
268: delete from ZX_DET_FACTOR_TEMPL_TL
269: where DET_FACTOR_TEMPL_ID = X_DET_FACTOR_TEMPL_ID;
270:
271: if (sql%notfound) then
272: raise no_data_found;

Line 292: delete from ZX_DET_FACTOR_TEMPL_TL T

288: procedure ADD_LANGUAGE
289: is
290: begin
291:
292: delete from ZX_DET_FACTOR_TEMPL_TL T
293: where not exists (select NULL
294: from ZX_DET_FACTOR_TEMPL_B B
295: where B.DET_FACTOR_TEMPL_ID = T.DET_FACTOR_TEMPL_ID);
296:

Line 297: update ZX_DET_FACTOR_TEMPL_TL T

293: where not exists (select NULL
294: from ZX_DET_FACTOR_TEMPL_B B
295: where B.DET_FACTOR_TEMPL_ID = T.DET_FACTOR_TEMPL_ID);
296:
297: update ZX_DET_FACTOR_TEMPL_TL T
298: set (DET_FACTOR_TEMPL_NAME, DET_FACTOR_TEMPL_DESC) =
299: (select B.DET_FACTOR_TEMPL_NAME,
300: B.DET_FACTOR_TEMPL_DESC
301: from ZX_DET_FACTOR_TEMPL_TL B

Line 301: from ZX_DET_FACTOR_TEMPL_TL B

297: update ZX_DET_FACTOR_TEMPL_TL T
298: set (DET_FACTOR_TEMPL_NAME, DET_FACTOR_TEMPL_DESC) =
299: (select B.DET_FACTOR_TEMPL_NAME,
300: B.DET_FACTOR_TEMPL_DESC
301: from ZX_DET_FACTOR_TEMPL_TL B
302: where B.DET_FACTOR_TEMPL_ID = T.DET_FACTOR_TEMPL_ID
303: and B.LANGUAGE = T.SOURCE_LANG)
304: where (T.DET_FACTOR_TEMPL_ID, T.LANGUAGE) in
305: (select SUBT.DET_FACTOR_TEMPL_ID,

Line 307: from ZX_DET_FACTOR_TEMPL_TL SUBB, ZX_DET_FACTOR_TEMPL_TL SUBT

303: and B.LANGUAGE = T.SOURCE_LANG)
304: where (T.DET_FACTOR_TEMPL_ID, T.LANGUAGE) in
305: (select SUBT.DET_FACTOR_TEMPL_ID,
306: SUBT.LANGUAGE
307: from ZX_DET_FACTOR_TEMPL_TL SUBB, ZX_DET_FACTOR_TEMPL_TL SUBT
308: where SUBB.DET_FACTOR_TEMPL_ID = SUBT.DET_FACTOR_TEMPL_ID
309: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
310: and (SUBB.DET_FACTOR_TEMPL_NAME <> SUBT.DET_FACTOR_TEMPL_NAME
311: or SUBB.DET_FACTOR_TEMPL_DESC <> SUBT.DET_FACTOR_TEMPL_DESC

Line 317: insert into ZX_DET_FACTOR_TEMPL_TL (DET_FACTOR_TEMPL_ID,

313: and SUBT.DET_FACTOR_TEMPL_DESC is not null)
314: or (SUBB.DET_FACTOR_TEMPL_DESC is not null
315: and SUBT.DET_FACTOR_TEMPL_DESC is null)));
316:
317: insert into ZX_DET_FACTOR_TEMPL_TL (DET_FACTOR_TEMPL_ID,
318: DET_FACTOR_TEMPL_NAME,
319: DET_FACTOR_TEMPL_DESC,
320: CREATION_DATE,
321: CREATED_BY,

Line 337: from ZX_DET_FACTOR_TEMPL_TL B,

333: B.LAST_UPDATED_BY,
334: B.LAST_UPDATE_LOGIN,
335: L.LANGUAGE_CODE,
336: B.SOURCE_LANG
337: from ZX_DET_FACTOR_TEMPL_TL B,
338: FND_LANGUAGES L
339: where L.INSTALLED_FLAG in ('I', 'B')
340: and B.LANGUAGE = userenv('LANG')
341: and not exists

Line 343: from ZX_DET_FACTOR_TEMPL_TL T

339: where L.INSTALLED_FLAG in ('I', 'B')
340: and B.LANGUAGE = userenv('LANG')
341: and not exists
342: (select NULL
343: from ZX_DET_FACTOR_TEMPL_TL T
344: where T.DET_FACTOR_TEMPL_ID =
345: B.DET_FACTOR_TEMPL_ID
346: and T.LANGUAGE = L.LANGUAGE_CODE);
347:

Line 404: insert into ZX_DET_FACTOR_TEMPL_TL (DET_FACTOR_TEMPL_ID,

400: fnd_global.conc_login_id
401: );
402:
403: forall i in x_det_factor_templ_id.first..x_det_factor_templ_id.last
404: insert into ZX_DET_FACTOR_TEMPL_TL (DET_FACTOR_TEMPL_ID,
405: DET_FACTOR_TEMPL_NAME,
406: DET_FACTOR_TEMPL_DESC,
407: LANGUAGE,
408: SOURCE_LANG,

Line 428: from ZX_DET_FACTOR_TEMPL_TL T

424: from FND_LANGUAGES L
425: where L.INSTALLED_FLAG in ('I', 'B')
426: and not exists
427: (select NULL
428: from ZX_DET_FACTOR_TEMPL_TL T
429: where T.DET_FACTOR_TEMPL_ID =
430: X_DET_FACTOR_TEMPL_ID(i)
431: and T.LANGUAGE = L.LANGUAGE_CODE);
432: end if;