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_TIMEZONE_PKG dependencies on HZ_TIMEZONES

Line 30: cursor C is select ROWID from HZ_TIMEZONES

26: X_LAST_UPDATE_DATE in DATE,
27: X_LAST_UPDATED_BY in NUMBER,
28: X_LAST_UPDATE_LOGIN in NUMBER
29: ) is
30: cursor C is select ROWID from HZ_TIMEZONES
31: where TIMEZONE_ID = X_TIMEZONE_ID
32: ;
33: begin
34: insert into HZ_TIMEZONES (

Line 34: insert into HZ_TIMEZONES (

30: cursor C is select ROWID from HZ_TIMEZONES
31: where TIMEZONE_ID = X_TIMEZONE_ID
32: ;
33: begin
34: insert into HZ_TIMEZONES (
35: TIMEZONE_ID,
36: GLOBAL_TIMEZONE_NAME,
37: STANDARD_TIME_SHORT_CODE,
38: DAYLIGHT_SAVINGS_SHORT_CODE,

Line 82: insert into HZ_TIMEZONES_TL (

78: X_LAST_UPDATED_BY,
79: X_LAST_UPDATE_LOGIN
80: );
81:
82: insert into HZ_TIMEZONES_TL (
83: CREATION_DATE,
84: CREATED_BY,
85: LAST_UPDATE_DATE,
86: LAST_UPDATED_BY,

Line 108: from HZ_TIMEZONES_TL T

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

Line 160: from HZ_TIMEZONES

156: END_DST_WEEK_OF_MONTH,
157: END_DST_DAY_OF_WEEK,
158: END_DST_HOUR,
159: PRIMARY_ZONE_FLAG
160: from HZ_TIMEZONES
161: where TIMEZONE_ID = X_TIMEZONE_ID
162: for update of TIMEZONE_ID nowait;
163: recinfo c%rowtype;
164:

Line 169: from HZ_TIMEZONES_TL

165: cursor c1 is select
166: NAME,
167: DESCRIPTION,
168: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
169: from HZ_TIMEZONES_TL
170: where TIMEZONE_ID = X_TIMEZONE_ID
171: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
172: for update of TIMEZONE_ID nowait;
173: begin

Line 257: update HZ_TIMEZONES set

253: X_LAST_UPDATED_BY in NUMBER,
254: X_LAST_UPDATE_LOGIN in NUMBER
255: ) is
256: begin
257: update HZ_TIMEZONES set
258: GLOBAL_TIMEZONE_NAME = X_GLOBAL_TIMEZONE_NAME,
259: STANDARD_TIME_SHORT_CODE = X_STANDARD_TIME_SHORT_CODE,
260: DAYLIGHT_SAVINGS_SHORT_CODE = X_DAYLIGHT_SAVINGS_SHORT_CODE,
261: GMT_DEVIATION_HOURS = X_GMT_DEVIATION_HOURS,

Line 283: update HZ_TIMEZONES_TL set

279: if (sql%notfound) then
280: raise no_data_found;
281: end if;
282:
283: update HZ_TIMEZONES_TL set
284: NAME = X_NAME,
285: DESCRIPTION = X_DESCRIPTION,
286: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
287: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 302: delete from HZ_TIMEZONES_TL

298: procedure DELETE_ROW (
299: X_TIMEZONE_ID in NUMBER
300: ) is
301: begin
302: delete from HZ_TIMEZONES_TL
303: where TIMEZONE_ID = X_TIMEZONE_ID;
304:
305: if (sql%notfound) then
306: raise no_data_found;

Line 309: delete from HZ_TIMEZONES

305: if (sql%notfound) then
306: raise no_data_found;
307: end if;
308:
309: delete from HZ_TIMEZONES
310: where TIMEZONE_ID = X_TIMEZONE_ID;
311:
312: if (sql%notfound) then
313: raise no_data_found;

Line 320: delete from HZ_TIMEZONES_TL T

316:
317: procedure ADD_LANGUAGE
318: is
319: begin
320: delete from HZ_TIMEZONES_TL T
321: where not exists
322: (select NULL
323: from HZ_TIMEZONES B
324: where B.TIMEZONE_ID = T.TIMEZONE_ID

Line 323: from HZ_TIMEZONES B

319: begin
320: delete from HZ_TIMEZONES_TL T
321: where not exists
322: (select NULL
323: from HZ_TIMEZONES B
324: where B.TIMEZONE_ID = T.TIMEZONE_ID
325: );
326:
327: update HZ_TIMEZONES_TL T set (

Line 327: update HZ_TIMEZONES_TL T set (

323: from HZ_TIMEZONES B
324: where B.TIMEZONE_ID = T.TIMEZONE_ID
325: );
326:
327: update HZ_TIMEZONES_TL T set (
328: NAME,
329: DESCRIPTION
330: ) = (select
331: B.NAME,

Line 333: from HZ_TIMEZONES_TL B

329: DESCRIPTION
330: ) = (select
331: B.NAME,
332: B.DESCRIPTION
333: from HZ_TIMEZONES_TL B
334: where B.TIMEZONE_ID = T.TIMEZONE_ID
335: and B.LANGUAGE = T.SOURCE_LANG)
336: where (
337: T.TIMEZONE_ID,

Line 342: from HZ_TIMEZONES_TL SUBB, HZ_TIMEZONES_TL SUBT

338: T.LANGUAGE
339: ) in (select
340: SUBT.TIMEZONE_ID,
341: SUBT.LANGUAGE
342: from HZ_TIMEZONES_TL SUBB, HZ_TIMEZONES_TL SUBT
343: where SUBB.TIMEZONE_ID = SUBT.TIMEZONE_ID
344: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
345: and (SUBB.NAME <> SUBT.NAME
346: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 351: insert into HZ_TIMEZONES_TL (

347: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
348: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
349: ));
350:
351: insert into HZ_TIMEZONES_TL (
352: CREATION_DATE,
353: CREATED_BY,
354: LAST_UPDATE_DATE,
355: LAST_UPDATED_BY,

Line 373: from HZ_TIMEZONES_TL B, FND_LANGUAGES L

369: B.NAME,
370: B.DESCRIPTION,
371: L.LANGUAGE_CODE,
372: B.SOURCE_LANG
373: from HZ_TIMEZONES_TL B, FND_LANGUAGES L
374: where L.INSTALLED_FLAG in ('I', 'B')
375: and B.LANGUAGE = userenv('LANG')
376: and not exists
377: (select NULL

Line 378: from HZ_TIMEZONES_TL T

374: where L.INSTALLED_FLAG in ('I', 'B')
375: and B.LANGUAGE = userenv('LANG')
376: and not exists
377: (select NULL
378: from HZ_TIMEZONES_TL T
379: where T.TIMEZONE_ID = B.TIMEZONE_ID
380: and T.LANGUAGE = L.LANGUAGE_CODE);
381: end ADD_LANGUAGE;
382: