APPS.FND_TIMEZONES_PKG dependencies on FND_TIMEZONES_TL

Line 48: insert into FND_TIMEZONES_TL (

44: X_LAST_UPDATED_BY,
45: X_LAST_UPDATE_LOGIN
46: );
47:
48: insert into FND_TIMEZONES_TL (
49: TIMEZONE_CODE,
50: NAME,
51: CREATION_DATE,
52: CREATED_BY,

Line 72: from FND_TIMEZONES_TL T

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

Line 109: from FND_TIMEZONES_TL

105:
106: cursor c1 is select
107: NAME,
108: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
109: from FND_TIMEZONES_TL
110: where TIMEZONE_CODE = X_TIMEZONE_CODE
111: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
112: for update of TIMEZONE_CODE nowait;
113: begin

Line 178: update FND_TIMEZONES_TL set

174: if (sql%notfound) then
175: raise no_data_found;
176: end if;
177:
178: update FND_TIMEZONES_TL set
179: NAME = X_NAME,
180: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
181: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
182: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 196: delete from FND_TIMEZONES_TL

192: procedure DELETE_ROW (
193: X_TIMEZONE_CODE in VARCHAR2
194: ) is
195: begin
196: delete from FND_TIMEZONES_TL
197: where TIMEZONE_CODE = X_TIMEZONE_CODE;
198:
199: if (sql%notfound) then
200: raise no_data_found;

Line 220: delete from FND_TIMEZONES_TL T

216: /* as a quick workaround to fix the time-consuming table handler issue */
217: /* Eventually we'll need to turn them into a separate fix_language procedure */
218: /*
219:
220: delete from FND_TIMEZONES_TL T
221: where not exists
222: (select NULL
223: from FND_TIMEZONES_B B
224: where B.TIMEZONE_CODE = T.TIMEZONE_CODE

Line 227: update FND_TIMEZONES_TL T set (

223: from FND_TIMEZONES_B B
224: where B.TIMEZONE_CODE = T.TIMEZONE_CODE
225: );
226:
227: update FND_TIMEZONES_TL T set (
228: NAME
229: ) = (select
230: B.NAME
231: from FND_TIMEZONES_TL B

Line 231: from FND_TIMEZONES_TL B

227: update FND_TIMEZONES_TL T set (
228: NAME
229: ) = (select
230: B.NAME
231: from FND_TIMEZONES_TL B
232: where B.TIMEZONE_CODE = T.TIMEZONE_CODE
233: and B.LANGUAGE = T.SOURCE_LANG)
234: where (
235: T.TIMEZONE_CODE,

Line 240: from FND_TIMEZONES_TL SUBB, FND_TIMEZONES_TL SUBT

236: T.LANGUAGE
237: ) in (select
238: SUBT.TIMEZONE_CODE,
239: SUBT.LANGUAGE
240: from FND_TIMEZONES_TL SUBB, FND_TIMEZONES_TL SUBT
241: where SUBB.TIMEZONE_CODE = SUBT.TIMEZONE_CODE
242: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
243: and (SUBB.NAME <> SUBT.NAME
244: ));

Line 247: insert into FND_TIMEZONES_TL (

243: and (SUBB.NAME <> SUBT.NAME
244: ));
245: */
246:
247: insert into FND_TIMEZONES_TL (
248: TIMEZONE_CODE,
249: NAME,
250: CREATION_DATE,
251: CREATED_BY,

Line 267: from FND_TIMEZONES_TL B, FND_LANGUAGES L

263: B.LAST_UPDATED_BY,
264: B.LAST_UPDATE_LOGIN,
265: L.LANGUAGE_CODE,
266: B.SOURCE_LANG
267: from FND_TIMEZONES_TL B, FND_LANGUAGES L
268: where L.INSTALLED_FLAG in ('I', 'B')
269: and B.LANGUAGE = userenv('LANG')
270: and not exists
271: (select NULL

Line 272: from FND_TIMEZONES_TL T

268: where L.INSTALLED_FLAG in ('I', 'B')
269: and B.LANGUAGE = userenv('LANG')
270: and not exists
271: (select NULL
272: from FND_TIMEZONES_TL T
273: where T.TIMEZONE_CODE = B.TIMEZONE_CODE
274: and T.LANGUAGE = L.LANGUAGE_CODE);
275: end ADD_LANGUAGE;
276:

Line 301: from FND_TIMEZONES_TL

297: begin
298:
299: select LAST_UPDATED_BY, LAST_UPDATE_DATE
300: into db_luby, db_ludate
301: from FND_TIMEZONES_TL
302: where TIMEZONE_CODE = x_timezone_code
303: and LANGUAGE = userenv('LANG');
304:
305: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 307: update FND_TIMEZONES_TL set

303: and LANGUAGE = userenv('LANG');
304:
305: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
306: db_ludate, X_CUSTOM_MODE)) then
307: update FND_TIMEZONES_TL set
308: NAME = X_NAME,
309: LAST_UPDATE_DATE = f_ludate,
310: LAST_UPDATED_BY = f_luby,
311: LAST_UPDATE_LOGIN = 0,