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.HZ_STYLE_FORMATS_PKG dependencies on HZ_STYLE_FORMATS_TL

Line 42: insert into HZ_STYLE_FORMATS_TL (

38: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
39: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
40: );
41:
42: insert into HZ_STYLE_FORMATS_TL (
43: STYLE_FORMAT_CODE,
44: STYLE_FORMAT_NAME,
45: DESCRIPTION,
46: CREATED_BY,

Line 68: from HZ_STYLE_FORMATS_TL T

64: from FND_LANGUAGES L
65: where L.INSTALLED_FLAG in ('I', 'B')
66: and not exists
67: (select NULL
68: from HZ_STYLE_FORMATS_TL T
69: where T.STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
70: and T.LANGUAGE = L.LANGUAGE_CODE);
71:
72: open c;

Line 101: from HZ_STYLE_FORMATS_TL

97: cursor c1 is select
98: STYLE_FORMAT_NAME,
99: DESCRIPTION,
100: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
101: from HZ_STYLE_FORMATS_TL
102: where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
103: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
104: for update of STYLE_FORMAT_CODE nowait;
105: begin

Line 162: update HZ_STYLE_FORMATS_TL set

158: if (sql%notfound) then
159: raise no_data_found;
160: end if;
161:
162: update HZ_STYLE_FORMATS_TL set
163: STYLE_FORMAT_NAME = DECODE( X_STYLE_FORMAT_NAME, NULL, STYLE_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_NAME ),
164: DESCRIPTION = DECODE( X_DESCRIPTION, NULL, DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_DESCRIPTION ),
165: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
166: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),

Line 197: FROM HZ_STYLE_FORMATS_B B, HZ_STYLE_FORMATS_TL T

193: X_STYLE_CODE,
194: X_DEFAULT_FLAG,
195: X_STYLE_FORMAT_NAME,
196: X_DESCRIPTION
197: FROM HZ_STYLE_FORMATS_B B, HZ_STYLE_FORMATS_TL T
198: WHERE B.STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
199: AND T.STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
200: AND T.LANGUAGE = userenv('LANG');
201:

Line 216: delete from HZ_STYLE_FORMATS_TL

212: procedure DELETE_ROW (
213: X_STYLE_FORMAT_CODE in VARCHAR2
214: ) is
215: begin
216: delete from HZ_STYLE_FORMATS_TL
217: where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE;
218:
219: if (sql%notfound) then
220: raise no_data_found;

Line 234: delete from HZ_STYLE_FORMATS_TL T

230:
231: procedure ADD_LANGUAGE
232: is
233: begin
234: delete from HZ_STYLE_FORMATS_TL T
235: where not exists
236: (select NULL
237: from HZ_STYLE_FORMATS_B B
238: where B.STYLE_FORMAT_CODE = T.STYLE_FORMAT_CODE

Line 241: update HZ_STYLE_FORMATS_TL T set (

237: from HZ_STYLE_FORMATS_B B
238: where B.STYLE_FORMAT_CODE = T.STYLE_FORMAT_CODE
239: );
240:
241: update HZ_STYLE_FORMATS_TL T set (
242: STYLE_FORMAT_NAME,
243: DESCRIPTION
244: ) = (select
245: B.STYLE_FORMAT_NAME,

Line 247: from HZ_STYLE_FORMATS_TL B

243: DESCRIPTION
244: ) = (select
245: B.STYLE_FORMAT_NAME,
246: B.DESCRIPTION
247: from HZ_STYLE_FORMATS_TL B
248: where B.STYLE_FORMAT_CODE = T.STYLE_FORMAT_CODE
249: and B.LANGUAGE = T.SOURCE_LANG)
250: where (
251: T.STYLE_FORMAT_CODE,

Line 256: from HZ_STYLE_FORMATS_TL SUBB, HZ_STYLE_FORMATS_TL SUBT

252: T.LANGUAGE
253: ) in (select
254: SUBT.STYLE_FORMAT_CODE,
255: SUBT.LANGUAGE
256: from HZ_STYLE_FORMATS_TL SUBB, HZ_STYLE_FORMATS_TL SUBT
257: where SUBB.STYLE_FORMAT_CODE = SUBT.STYLE_FORMAT_CODE
258: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
259: and (SUBB.STYLE_FORMAT_NAME <> SUBT.STYLE_FORMAT_NAME
260: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 265: insert into HZ_STYLE_FORMATS_TL (

261: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
262: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
263: ));
264:
265: insert into HZ_STYLE_FORMATS_TL (
266: STYLE_FORMAT_CODE,
267: STYLE_FORMAT_NAME,
268: DESCRIPTION,
269: LAST_UPDATE_DATE,

Line 287: from HZ_STYLE_FORMATS_TL B, FND_LANGUAGES L

283: B.CREATED_BY,
284: B.LAST_UPDATE_LOGIN,
285: L.LANGUAGE_CODE,
286: B.SOURCE_LANG
287: from HZ_STYLE_FORMATS_TL B, FND_LANGUAGES L
288: where L.INSTALLED_FLAG in ('I', 'B')
289: and B.LANGUAGE = userenv('LANG')
290: and not exists
291: (select NULL

Line 292: from HZ_STYLE_FORMATS_TL T

288: where L.INSTALLED_FLAG in ('I', 'B')
289: and B.LANGUAGE = userenv('LANG')
290: and not exists
291: (select NULL
292: from HZ_STYLE_FORMATS_TL T
293: where T.STYLE_FORMAT_CODE = B.STYLE_FORMAT_CODE
294: and T.LANGUAGE = L.LANGUAGE_CODE);
295: end ADD_LANGUAGE;
296:

Line 394: from HZ_STYLE_FORMATS_TL

390:
391: begin
392: select LAST_UPDATED_BY, LAST_UPDATE_DATE
393: into l_db_luby, l_db_ludate
394: from HZ_STYLE_FORMATS_TL
395: where STYLE_FORMAT_CODE = x_style_format_code
396: and LANGUAGE = userenv('LANG');
397:
398: -- Update record, honoring customization mode.

Line 408: update HZ_STYLE_FORMATS_TL

404: if ((x_custom_mode = 'FORCE') or
405: ((l_f_luby = 0) and (l_db_luby = 1)) or
406: ((l_f_luby = l_db_luby) and (l_f_ludate > l_db_ludate)))
407: then
408: update HZ_STYLE_FORMATS_TL
409: set STYLE_FORMAT_NAME = nvl(X_STYLE_FORMAT_NAME,STYLE_FORMAT_NAME),
410: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
411: LAST_UPDATE_DATE = l_f_ludate,
412: LAST_UPDATED_BY = l_f_luby,