APPS.FND_FLEX_HIERARCHIES_PKG dependencies on FND_FLEX_HIERARCHIES_TL

Line 42: insert into FND_FLEX_HIERARCHIES_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into FND_FLEX_HIERARCHIES_TL (
43: FLEX_VALUE_SET_ID,
44: HIERARCHY_ID,
45: HIERARCHY_NAME,
46: LAST_UPDATE_DATE,

Line 70: from FND_FLEX_HIERARCHIES_TL T

66: from FND_LANGUAGES L
67: where L.INSTALLED_FLAG in ('I', 'B')
68: and not exists
69: (select NULL
70: from FND_FLEX_HIERARCHIES_TL T
71: where T.FLEX_VALUE_SET_ID = X_FLEX_VALUE_SET_ID
72: and T.HIERARCHY_ID = X_HIERARCHY_ID
73: and T.LANGUAGE = L.LANGUAGE_CODE);
74:

Line 104: from FND_FLEX_HIERARCHIES_TL

100: cursor c1 is select
101: HIERARCHY_NAME,
102: DESCRIPTION,
103: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
104: from FND_FLEX_HIERARCHIES_TL
105: where FLEX_VALUE_SET_ID = X_FLEX_VALUE_SET_ID
106: and HIERARCHY_ID = X_HIERARCHY_ID
107: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
108: for update of FLEX_VALUE_SET_ID nowait;

Line 165: update FND_FLEX_HIERARCHIES_TL set

161: if (sql%notfound) then
162: raise no_data_found;
163: end if;
164:
165: update FND_FLEX_HIERARCHIES_TL set
166: HIERARCHY_NAME = X_HIERARCHY_NAME,
167: DESCRIPTION = X_DESCRIPTION,
168: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
169: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 186: delete from FND_FLEX_HIERARCHIES_TL

182: X_FLEX_VALUE_SET_ID in NUMBER,
183: X_HIERARCHY_ID in NUMBER
184: ) is
185: begin
186: delete from FND_FLEX_HIERARCHIES_TL
187: where FLEX_VALUE_SET_ID = X_FLEX_VALUE_SET_ID
188: and HIERARCHY_ID = X_HIERARCHY_ID;
189:
190: if (sql%notfound) then

Line 212: delete from FND_FLEX_HIERARCHIES_TL T

208: /* as a quick workaround to fix the time-consuming table handler issue */
209: /* Eventually we'll need to turn them into a separate fix_language procedure */
210: /*
211:
212: delete from FND_FLEX_HIERARCHIES_TL T
213: where not exists
214: (select NULL
215: from FND_FLEX_HIERARCHIES B
216: where B.FLEX_VALUE_SET_ID = T.FLEX_VALUE_SET_ID

Line 220: update FND_FLEX_HIERARCHIES_TL T set (

216: where B.FLEX_VALUE_SET_ID = T.FLEX_VALUE_SET_ID
217: and B.HIERARCHY_ID = T.HIERARCHY_ID
218: );
219:
220: update FND_FLEX_HIERARCHIES_TL T set (
221: HIERARCHY_NAME,
222: DESCRIPTION
223: ) = (select
224: B.HIERARCHY_NAME,

Line 226: from FND_FLEX_HIERARCHIES_TL B

222: DESCRIPTION
223: ) = (select
224: B.HIERARCHY_NAME,
225: B.DESCRIPTION
226: from FND_FLEX_HIERARCHIES_TL B
227: where B.FLEX_VALUE_SET_ID = T.FLEX_VALUE_SET_ID
228: and B.HIERARCHY_ID = T.HIERARCHY_ID
229: and B.LANGUAGE = T.SOURCE_LANG)
230: where (

Line 238: from FND_FLEX_HIERARCHIES_TL SUBB, FND_FLEX_HIERARCHIES_TL SUBT

234: ) in (select
235: SUBT.FLEX_VALUE_SET_ID,
236: SUBT.HIERARCHY_ID,
237: SUBT.LANGUAGE
238: from FND_FLEX_HIERARCHIES_TL SUBB, FND_FLEX_HIERARCHIES_TL SUBT
239: where SUBB.FLEX_VALUE_SET_ID = SUBT.FLEX_VALUE_SET_ID
240: and SUBB.HIERARCHY_ID = SUBT.HIERARCHY_ID
241: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
242: and (SUBB.HIERARCHY_NAME <> SUBT.HIERARCHY_NAME

Line 249: insert into FND_FLEX_HIERARCHIES_TL (

245: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
246: ));
247: */
248:
249: insert into FND_FLEX_HIERARCHIES_TL (
250: FLEX_VALUE_SET_ID,
251: HIERARCHY_ID,
252: HIERARCHY_NAME,
253: LAST_UPDATE_DATE,

Line 273: from FND_FLEX_HIERARCHIES_TL B, FND_LANGUAGES L

269: B.LAST_UPDATE_LOGIN,
270: B.DESCRIPTION,
271: L.LANGUAGE_CODE,
272: B.SOURCE_LANG
273: from FND_FLEX_HIERARCHIES_TL B, FND_LANGUAGES L
274: where L.INSTALLED_FLAG in ('I', 'B')
275: and B.LANGUAGE = userenv('LANG')
276: and not exists
277: (select NULL

Line 278: from FND_FLEX_HIERARCHIES_TL T

274: where L.INSTALLED_FLAG in ('I', 'B')
275: and B.LANGUAGE = userenv('LANG')
276: and not exists
277: (select NULL
278: from FND_FLEX_HIERARCHIES_TL T
279: where T.FLEX_VALUE_SET_ID = B.FLEX_VALUE_SET_ID
280: and T.HIERARCHY_ID = B.HIERARCHY_ID
281: and T.LANGUAGE = L.LANGUAGE_CODE);
282: end ADD_LANGUAGE;

Line 345: UPDATE fnd_flex_hierarchies_tl SET

341: x_hierarchy_name IN VARCHAR2,
342: x_description IN VARCHAR2)
343: IS
344: BEGIN
345: UPDATE fnd_flex_hierarchies_tl SET
346: hierarchy_name = Nvl(x_hierarchy_name, hierarchy_name),
347: description = Nvl(x_description, description),
348: last_update_date = x_who.last_update_date,
349: last_updated_by = x_who.last_updated_by,