APPS.FND_CONC_STATE_LOOKUPS_PKG dependencies on FND_CONC_STATE_LOOKUPS_TL

Line 48: insert into FND_CONC_STATE_LOOKUPS_TL (

44: X_LAST_UPDATED_BY,
45: X_LAST_UPDATE_LOGIN
46: );
47:
48: insert into FND_CONC_STATE_LOOKUPS_TL (
49: LOOKUP_TYPE_ID,
50: LOOKUP_VALUE,
51: MEANING,
52: DESCRIPTION,

Line 76: from FND_CONC_STATE_LOOKUPS_TL T

72: from FND_LANGUAGES L
73: where L.INSTALLED_FLAG in ('I', 'B')
74: and not exists
75: (select NULL
76: from FND_CONC_STATE_LOOKUPS_TL T
77: where T.LOOKUP_TYPE_ID = X_LOOKUP_TYPE_ID
78: and T.LOOKUP_VALUE = X_LOOKUP_VALUE
79: and T.LANGUAGE = L.LANGUAGE_CODE);
80:

Line 113: from FND_CONC_STATE_LOOKUPS_TL

109:
110: cursor c1 is select
111: MEANING,
112: DESCRIPTION
113: from FND_CONC_STATE_LOOKUPS_TL
114: where LOOKUP_TYPE_ID = X_LOOKUP_TYPE_ID
115: and LOOKUP_VALUE = X_LOOKUP_VALUE
116: and LANGUAGE = userenv('LANG')
117: for update of LOOKUP_TYPE_ID nowait;

Line 187: update FND_CONC_STATE_LOOKUPS_TL set

183: if (sql%notfound) then
184: raise no_data_found;
185: end if;
186:
187: update FND_CONC_STATE_LOOKUPS_TL set
188: MEANING = X_MEANING,
189: DESCRIPTION = X_DESCRIPTION,
190: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
191: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 216: delete from FND_CONC_STATE_LOOKUPS_TL

212: if (sql%notfound) then
213: raise no_data_found;
214: end if;
215:
216: delete from FND_CONC_STATE_LOOKUPS_TL
217: where LOOKUP_TYPE_ID = X_LOOKUP_TYPE_ID
218: and LOOKUP_VALUE = X_LOOKUP_VALUE;
219:
220: if (sql%notfound) then

Line 235: delete from FND_CONC_STATE_LOOKUPS_TL T

231: /* as a quick workaround to fix the time-consuming table handler issue */
232: /* Eventually we'll need to turn them into a separate fix_language procedure */
233: /*
234:
235: delete from FND_CONC_STATE_LOOKUPS_TL T
236: where not exists
237: (select NULL
238: from FND_CONC_STATE_LOOKUPS B
239: where B.LOOKUP_TYPE_ID = T.LOOKUP_TYPE_ID

Line 243: update FND_CONC_STATE_LOOKUPS_TL T set (

239: where B.LOOKUP_TYPE_ID = T.LOOKUP_TYPE_ID
240: and B.LOOKUP_VALUE = T.LOOKUP_VALUE
241: );
242:
243: update FND_CONC_STATE_LOOKUPS_TL T set (
244: MEANING,
245: DESCRIPTION
246: ) = (select
247: B.MEANING,

Line 249: from FND_CONC_STATE_LOOKUPS_TL B

245: DESCRIPTION
246: ) = (select
247: B.MEANING,
248: B.DESCRIPTION
249: from FND_CONC_STATE_LOOKUPS_TL B
250: where B.LOOKUP_TYPE_ID = T.LOOKUP_TYPE_ID
251: and B.LOOKUP_VALUE = T.LOOKUP_VALUE
252: and B.LANGUAGE = T.SOURCE_LANG)
253: where (

Line 261: from FND_CONC_STATE_LOOKUPS_TL SUBB, FND_CONC_STATE_LOOKUPS_TL SUBT

257: ) in (select
258: SUBT.LOOKUP_TYPE_ID,
259: SUBT.LOOKUP_VALUE,
260: SUBT.LANGUAGE
261: from FND_CONC_STATE_LOOKUPS_TL SUBB, FND_CONC_STATE_LOOKUPS_TL SUBT
262: where SUBB.LOOKUP_TYPE_ID = SUBT.LOOKUP_TYPE_ID
263: and SUBB.LOOKUP_VALUE = SUBT.LOOKUP_VALUE
264: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
265: and (SUBB.MEANING <> SUBT.MEANING

Line 270: insert into FND_CONC_STATE_LOOKUPS_TL (

266: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
267: ));
268: */
269:
270: insert into FND_CONC_STATE_LOOKUPS_TL (
271: LOOKUP_TYPE_ID,
272: LOOKUP_VALUE,
273: MEANING,
274: DESCRIPTION,

Line 294: from FND_CONC_STATE_LOOKUPS_TL B, FND_LANGUAGES L

290: B.CREATION_DATE,
291: B.CREATED_BY,
292: L.LANGUAGE_CODE,
293: B.SOURCE_LANG
294: from FND_CONC_STATE_LOOKUPS_TL B, FND_LANGUAGES L
295: where L.INSTALLED_FLAG in ('I', 'B')
296: and B.LANGUAGE = userenv('LANG')
297: and not exists
298: (select NULL

Line 299: from FND_CONC_STATE_LOOKUPS_TL T

295: where L.INSTALLED_FLAG in ('I', 'B')
296: and B.LANGUAGE = userenv('LANG')
297: and not exists
298: (select NULL
299: from FND_CONC_STATE_LOOKUPS_TL T
300: where T.LOOKUP_TYPE_ID = B.LOOKUP_TYPE_ID
301: and T.LOOKUP_VALUE = B.LOOKUP_VALUE
302: and T.LANGUAGE = L.LANGUAGE_CODE);
303: end ADD_LANGUAGE;