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_FMT_LAYOUTS_PKG dependencies on HZ_STYLE_FMT_LAYOUTS_TL

Line 85: insert into HZ_STYLE_FMT_LAYOUTS_TL (

81: STYLE_FMT_LAYOUT_ID
82: INTO
83: X_STYLE_FMT_LAYOUT_ID;
84:
85: insert into HZ_STYLE_FMT_LAYOUTS_TL (
86: STYLE_FMT_LAYOUT_ID,
87: PROMPT,
88: CREATED_BY,
89: CREATION_DATE,

Line 109: from HZ_STYLE_FMT_LAYOUTS_TL T

105: from FND_LANGUAGES L
106: where L.INSTALLED_FLAG in ('I', 'B')
107: and not exists
108: (select NULL
109: from HZ_STYLE_FMT_LAYOUTS_TL T
110: where T.STYLE_FMT_LAYOUT_ID = X_STYLE_FMT_LAYOUT_ID
111: and T.LANGUAGE = L.LANGUAGE_CODE);
112:
113: open c;

Line 164: from HZ_STYLE_FMT_LAYOUTS_TL

160:
161: cursor c1 is select
162: PROMPT,
163: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
164: from HZ_STYLE_FMT_LAYOUTS_TL
165: where STYLE_FMT_LAYOUT_ID = X_STYLE_FMT_LAYOUT_ID
166: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
167: for update of STYLE_FMT_LAYOUT_ID nowait;
168: begin

Line 268: update HZ_STYLE_FMT_LAYOUTS_TL set

264: if (sql%notfound) then
265: raise no_data_found;
266: end if;
267:
268: update HZ_STYLE_FMT_LAYOUTS_TL set
269: PROMPT = DECODE( X_PROMPT, NULL, PROMPT, FND_API.G_MISS_CHAR, NULL, X_PROMPT ),
270: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
271: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
272: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),

Line 342: FROM HZ_STYLE_FMT_LAYOUTS_B B, HZ_STYLE_FMT_LAYOUTS_TL T

338: X_BLANK_LINES_AFTER ,
339: X_PROMPT,
340: X_START_DATE_ACTIVE ,
341: X_END_DATE_ACTIVE
342: FROM HZ_STYLE_FMT_LAYOUTS_B B, HZ_STYLE_FMT_LAYOUTS_TL T
343: WHERE B.STYLE_FMT_LAYOUT_ID = X_STYLE_FMT_LAYOUT_ID
344: AND T.STYLE_FMT_LAYOUT_ID = X_STYLE_FMT_LAYOUT_ID
345: AND T.LANGUAGE = userenv('LANG');
346:

Line 361: delete from HZ_STYLE_FMT_LAYOUTS_TL

357: procedure DELETE_ROW (
358: X_STYLE_FMT_LAYOUT_ID in NUMBER
359: ) is
360: begin
361: delete from HZ_STYLE_FMT_LAYOUTS_TL
362: where STYLE_FMT_LAYOUT_ID = X_STYLE_FMT_LAYOUT_ID;
363:
364: if (sql%notfound) then
365: raise no_data_found;

Line 379: delete from HZ_STYLE_FMT_LAYOUTS_TL T

375:
376: procedure ADD_LANGUAGE
377: is
378: begin
379: delete from HZ_STYLE_FMT_LAYOUTS_TL T
380: where not exists
381: (select NULL
382: from HZ_STYLE_FMT_LAYOUTS_B B
383: where B.STYLE_FMT_LAYOUT_ID = T.STYLE_FMT_LAYOUT_ID

Line 386: update HZ_STYLE_FMT_LAYOUTS_TL T set (

382: from HZ_STYLE_FMT_LAYOUTS_B B
383: where B.STYLE_FMT_LAYOUT_ID = T.STYLE_FMT_LAYOUT_ID
384: );
385:
386: update HZ_STYLE_FMT_LAYOUTS_TL T set (
387: PROMPT
388: ) = (select
389: B.PROMPT
390: from HZ_STYLE_FMT_LAYOUTS_TL B

Line 390: from HZ_STYLE_FMT_LAYOUTS_TL B

386: update HZ_STYLE_FMT_LAYOUTS_TL T set (
387: PROMPT
388: ) = (select
389: B.PROMPT
390: from HZ_STYLE_FMT_LAYOUTS_TL B
391: where B.STYLE_FMT_LAYOUT_ID = T.STYLE_FMT_LAYOUT_ID
392: and B.LANGUAGE = T.SOURCE_LANG)
393: where (
394: T.STYLE_FMT_LAYOUT_ID,

Line 399: from HZ_STYLE_FMT_LAYOUTS_TL SUBB, HZ_STYLE_FMT_LAYOUTS_TL SUBT

395: T.LANGUAGE
396: ) in (select
397: SUBT.STYLE_FMT_LAYOUT_ID,
398: SUBT.LANGUAGE
399: from HZ_STYLE_FMT_LAYOUTS_TL SUBB, HZ_STYLE_FMT_LAYOUTS_TL SUBT
400: where SUBB.STYLE_FMT_LAYOUT_ID = SUBT.STYLE_FMT_LAYOUT_ID
401: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
402: and (SUBB.PROMPT <> SUBT.PROMPT
403: or (SUBB.PROMPT is null and SUBT.PROMPT is not null)

Line 407: insert into HZ_STYLE_FMT_LAYOUTS_TL (

403: or (SUBB.PROMPT is null and SUBT.PROMPT is not null)
404: or (SUBB.PROMPT is not null and SUBT.PROMPT is null)
405: ));
406:
407: insert into HZ_STYLE_FMT_LAYOUTS_TL (
408: STYLE_FMT_LAYOUT_ID,
409: PROMPT,
410: LAST_UPDATE_DATE,
411: LAST_UPDATED_BY,

Line 427: from HZ_STYLE_FMT_LAYOUTS_TL B, FND_LANGUAGES L

423: B.CREATED_BY,
424: B.LAST_UPDATE_LOGIN,
425: L.LANGUAGE_CODE,
426: B.SOURCE_LANG
427: from HZ_STYLE_FMT_LAYOUTS_TL B, FND_LANGUAGES L
428: where L.INSTALLED_FLAG in ('I', 'B')
429: and B.LANGUAGE = userenv('LANG')
430: and not exists
431: (select NULL

Line 432: from HZ_STYLE_FMT_LAYOUTS_TL T

428: where L.INSTALLED_FLAG in ('I', 'B')
429: and B.LANGUAGE = userenv('LANG')
430: and not exists
431: (select NULL
432: from HZ_STYLE_FMT_LAYOUTS_TL T
433: where T.STYLE_FMT_LAYOUT_ID = B.STYLE_FMT_LAYOUT_ID
434: and T.LANGUAGE = L.LANGUAGE_CODE);
435: end ADD_LANGUAGE;
436:

Line 603: from HZ_STYLE_FMT_LAYOUTS_TL

599: and ATTRIBUTE_APPLICATION_ID = l_app_id;
600:
601: select LAST_UPDATED_BY, LAST_UPDATE_DATE
602: into l_db_luby, l_db_ludate
603: from HZ_STYLE_FMT_LAYOUTS_TL
604: where STYLE_FMT_LAYOUT_ID = l_id
605: and LANGUAGE = userenv('LANG');
606:
607: -- Update record, honoring customization mode.

Line 617: update HZ_STYLE_FMT_LAYOUTS_TL

613: if ((x_custom_mode = 'FORCE') or
614: ((l_f_luby = 0) and (l_db_luby = 1)) or
615: ((l_f_luby = l_db_luby) and (l_f_ludate > l_db_ludate)))
616: then
617: update HZ_STYLE_FMT_LAYOUTS_TL
618: set PROMPT = nvl(X_PROMPT,PROMPT),
619: LAST_UPDATE_DATE = l_f_ludate,
620: LAST_UPDATED_BY = l_f_luby,
621: LAST_UPDATE_LOGIN = 0,