APPS.ITA_SETUP_HIERARCHY_PKG dependencies on ITA_SETUP_HIERARCHY_TL

Line 37: insert into ITA_SETUP_HIERARCHY_TL (

33: X_LAST_UPDATED_BY,
34: X_LAST_UPDATE_LOGIN
35: );
36:
37: insert into ITA_SETUP_HIERARCHY_TL (
38: HIERARCHY_LEVEL_CODE,
39: HIERARCHY_LEVEL_NAME,
40: SECURITY_GROUP_ID,
41: OBJECT_VERSION_NUMBER,

Line 65: from ITA_SETUP_HIERARCHY_TL tl

61: from FND_LANGUAGES L
62: where L.INSTALLED_FLAG in ('I', 'B')
63: and not exists (
64: select null
65: from ITA_SETUP_HIERARCHY_TL tl
66: where
67: tl.HIERARCHY_LEVEL_CODE = X_HIERARCHY_LEVEL_CODE and
68: tl.LANGUAGE = L.LANGUAGE_CODE);
69: end INSERT_ROW;

Line 90: from ITA_SETUP_HIERARCHY_TL

86:
87: cursor c1 is select
88: HIERARCHY_LEVEL_NAME,
89: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
90: from ITA_SETUP_HIERARCHY_TL
91: where
92: HIERARCHY_LEVEL_CODE = X_HIERARCHY_LEVEL_CODE and
93: userenv('LANG') in (LANGUAGE, SOURCE_LANG)
94: for update of HIERARCHY_LEVEL_CODE nowait;

Line 155: update ITA_SETUP_HIERARCHY_TL set

151: if (sql%notfound) then
152: raise no_data_found;
153: end if;
154:
155: update ITA_SETUP_HIERARCHY_TL set
156: HIERARCHY_LEVEL_NAME = X_HIERARCHY_LEVEL_NAME,
157: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
158: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
159: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 175: delete from ITA_SETUP_HIERARCHY_TL

171: procedure DELETE_ROW (
172: X_HIERARCHY_LEVEL_CODE in VARCHAR2
173: ) is
174: begin
175: delete from ITA_SETUP_HIERARCHY_TL
176: where HIERARCHY_LEVEL_CODE = X_HIERARCHY_LEVEL_CODE;
177:
178: if (sql%notfound) then
179: raise no_data_found;

Line 242: delete from ITA_SETUP_HIERARCHY_TL tl

238:
239: procedure ADD_LANGUAGE
240: is
241: begin
242: delete from ITA_SETUP_HIERARCHY_TL tl
243: where not exists (
244: select null
245: from ITA_SETUP_HIERARCHY_B b
246: where b.HIERARCHY_LEVEL_CODE = tl.HIERARCHY_LEVEL_CODE

Line 249: update ITA_SETUP_HIERARCHY_TL tl set (

245: from ITA_SETUP_HIERARCHY_B b
246: where b.HIERARCHY_LEVEL_CODE = tl.HIERARCHY_LEVEL_CODE
247: );
248:
249: update ITA_SETUP_HIERARCHY_TL tl set (
250: HIERARCHY_LEVEL_NAME
251: ) = (select
252: b.HIERARCHY_LEVEL_NAME
253: from ITA_SETUP_HIERARCHY_TL b

Line 253: from ITA_SETUP_HIERARCHY_TL b

249: update ITA_SETUP_HIERARCHY_TL tl set (
250: HIERARCHY_LEVEL_NAME
251: ) = (select
252: b.HIERARCHY_LEVEL_NAME
253: from ITA_SETUP_HIERARCHY_TL b
254: where
255: b.HIERARCHY_LEVEL_CODE = tl.HIERARCHY_LEVEL_CODE and
256: b.LANGUAGE = tl.SOURCE_LANG)
257: where (

Line 263: from ITA_SETUP_HIERARCHY_TL subb, ITA_SETUP_HIERARCHY_TL subtl

259: tl.LANGUAGE
260: ) in (select
261: subtl.HIERARCHY_LEVEL_CODE,
262: subtl.LANGUAGE
263: from ITA_SETUP_HIERARCHY_TL subb, ITA_SETUP_HIERARCHY_TL subtl
264: where
265: subb.HIERARCHY_LEVEL_CODE = subtl.HIERARCHY_LEVEL_CODE and
266: subb.LANGUAGE = subtl.SOURCE_LANG and
267: (subb.HIERARCHY_LEVEL_NAME <> subtl.HIERARCHY_LEVEL_NAME or

Line 271: insert into ITA_SETUP_HIERARCHY_TL (

267: (subb.HIERARCHY_LEVEL_NAME <> subtl.HIERARCHY_LEVEL_NAME or
268: (subb.HIERARCHY_LEVEL_NAME is null and subtl.HIERARCHY_LEVEL_NAME is not null) or
269: (subb.HIERARCHY_LEVEL_NAME is not null and subtl.HIERARCHY_LEVEL_NAME is null)));
270:
271: insert into ITA_SETUP_HIERARCHY_TL (
272: HIERARCHY_LEVEL_CODE,
273: HIERARCHY_LEVEL_NAME,
274: CREATED_BY,
275: CREATION_DATE,

Line 295: from ITA_SETUP_HIERARCHY_TL b, FND_LANGUAGES L

291: b.SECURITY_GROUP_ID,
292: b.OBJECT_VERSION_NUMBER,
293: L.LANGUAGE_CODE,
294: b.SOURCE_LANG
295: from ITA_SETUP_HIERARCHY_TL b, FND_LANGUAGES L
296: where
297: L.INSTALLED_FLAG in ('I', 'B') and
298: b.LANGUAGE = userenv('LANG') and
299: not exists (

Line 301: from ITA_SETUP_HIERARCHY_TL tl

297: L.INSTALLED_FLAG in ('I', 'B') and
298: b.LANGUAGE = userenv('LANG') and
299: not exists (
300: select null
301: from ITA_SETUP_HIERARCHY_TL tl
302: where
303: tl.HIERARCHY_LEVEL_CODE = b.HIERARCHY_LEVEL_CODE and
304: tl.LANGUAGE = L.LANGUAGE_CODE);
305: end ADD_LANGUAGE;

Line 329: from ITA_SETUP_HIERARCHY_TL

325: -- Translate char last_update_date to date
326: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
327:
328: select LAST_UPDATED_BY, LAST_UPDATE_DATE into db_luby, db_ludate
329: from ITA_SETUP_HIERARCHY_TL
330: where HIERARCHY_LEVEL_CODE = X_HIERARCHY_LEVEL_CODE and LANGUAGE = userenv('LANG');
331:
332: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
333: then update ITA_SETUP_HIERARCHY_TL set

Line 333: then update ITA_SETUP_HIERARCHY_TL set

329: from ITA_SETUP_HIERARCHY_TL
330: where HIERARCHY_LEVEL_CODE = X_HIERARCHY_LEVEL_CODE and LANGUAGE = userenv('LANG');
331:
332: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
333: then update ITA_SETUP_HIERARCHY_TL set
334: HIERARCHY_LEVEL_NAME = nvl(X_HIERARCHY_LEVEL_NAME, HIERARCHY_LEVEL_NAME),
335: SOURCE_LANG = userenv('LANG'),
336: LAST_UPDATE_DATE = f_ludate,
337: LAST_UPDATED_BY = f_luby,