APPS.FND_CONC_STATE_LOOKUP_TYPES_PG dependencies on FND_CONC_STATE_LOOKUP_TYPES_TL

Line 47: insert into FND_CONC_STATE_LOOKUP_TYPES_TL (

43: X_LAST_UPDATED_BY,
44: X_LAST_UPDATE_LOGIN
45: );
46:
47: insert into FND_CONC_STATE_LOOKUP_TYPES_TL (
48: LOOKUP_TYPE_ID,
49: USER_LOOKUP_TYPE_NAME,
50: DESCRIPTION,
51: LAST_UPDATE_DATE,

Line 73: from FND_CONC_STATE_LOOKUP_TYPES_TL T

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

Line 109: from FND_CONC_STATE_LOOKUP_TYPES_TL

105:
106: cursor c1 is select
107: USER_LOOKUP_TYPE_NAME,
108: DESCRIPTION
109: from FND_CONC_STATE_LOOKUP_TYPES_TL
110: where LOOKUP_TYPE_ID = X_LOOKUP_TYPE_ID
111: and LANGUAGE = userenv('LANG')
112: for update of LOOKUP_TYPE_ID nowait;
113: tlinfo c1%rowtype;

Line 184: update FND_CONC_STATE_LOOKUP_TYPES_TL set

180: if (sql%notfound) then
181: raise no_data_found;
182: end if;
183:
184: update FND_CONC_STATE_LOOKUP_TYPES_TL set
185: USER_LOOKUP_TYPE_NAME = X_USER_LOOKUP_TYPE_NAME,
186: DESCRIPTION = X_DESCRIPTION,
187: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
188: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 210: delete from FND_CONC_STATE_LOOKUP_TYPES_TL

206: if (sql%notfound) then
207: raise no_data_found;
208: end if;
209:
210: delete from FND_CONC_STATE_LOOKUP_TYPES_TL
211: where LOOKUP_TYPE_ID = X_LOOKUP_TYPE_ID;
212:
213: if (sql%notfound) then
214: raise no_data_found;

Line 228: delete from FND_CONC_STATE_LOOKUP_TYPES_TL T

224: /* as a quick workaround to fix the time-consuming table handler issue */
225: /* Eventually we'll need to turn them into a separate fix_language procedure */
226: /*
227:
228: delete from FND_CONC_STATE_LOOKUP_TYPES_TL T
229: where not exists
230: (select NULL
231: from FND_CONC_STATE_LOOKUP_TYPES B
232: where B.LOOKUP_TYPE_ID = T.LOOKUP_TYPE_ID

Line 235: update FND_CONC_STATE_LOOKUP_TYPES_TL T set (

231: from FND_CONC_STATE_LOOKUP_TYPES B
232: where B.LOOKUP_TYPE_ID = T.LOOKUP_TYPE_ID
233: );
234:
235: update FND_CONC_STATE_LOOKUP_TYPES_TL T set (
236: USER_LOOKUP_TYPE_NAME,
237: DESCRIPTION
238: ) = (select
239: B.USER_LOOKUP_TYPE_NAME,

Line 241: from FND_CONC_STATE_LOOKUP_TYPES_TL B

237: DESCRIPTION
238: ) = (select
239: B.USER_LOOKUP_TYPE_NAME,
240: B.DESCRIPTION
241: from FND_CONC_STATE_LOOKUP_TYPES_TL B
242: where B.LOOKUP_TYPE_ID = T.LOOKUP_TYPE_ID
243: and B.LANGUAGE = T.SOURCE_LANG)
244: where (
245: T.LOOKUP_TYPE_ID,

Line 250: from FND_CONC_STATE_LOOKUP_TYPES_TL SUBB, FND_CONC_STATE_LOOKUP_TYPES_TL SUBT

246: T.LANGUAGE
247: ) in (select
248: SUBT.LOOKUP_TYPE_ID,
249: SUBT.LANGUAGE
250: from FND_CONC_STATE_LOOKUP_TYPES_TL SUBB, FND_CONC_STATE_LOOKUP_TYPES_TL SUBT
251: where SUBB.LOOKUP_TYPE_ID = SUBT.LOOKUP_TYPE_ID
252: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
253: and (SUBB.USER_LOOKUP_TYPE_NAME <> SUBT.USER_LOOKUP_TYPE_NAME
254: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 260: insert into FND_CONC_STATE_LOOKUP_TYPES_TL (

256: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
257: ));
258: */
259:
260: insert into FND_CONC_STATE_LOOKUP_TYPES_TL (
261: LOOKUP_TYPE_ID,
262: USER_LOOKUP_TYPE_NAME,
263: DESCRIPTION,
264: LAST_UPDATE_DATE,

Line 282: from FND_CONC_STATE_LOOKUP_TYPES_TL B, FND_LANGUAGES L

278: B.CREATION_DATE,
279: B.CREATED_BY,
280: L.LANGUAGE_CODE,
281: B.SOURCE_LANG
282: from FND_CONC_STATE_LOOKUP_TYPES_TL B, FND_LANGUAGES L
283: where L.INSTALLED_FLAG in ('I', 'B')
284: and B.LANGUAGE = userenv('LANG')
285: and not exists
286: (select NULL

Line 287: from FND_CONC_STATE_LOOKUP_TYPES_TL T

283: where L.INSTALLED_FLAG in ('I', 'B')
284: and B.LANGUAGE = userenv('LANG')
285: and not exists
286: (select NULL
287: from FND_CONC_STATE_LOOKUP_TYPES_TL T
288: where T.LOOKUP_TYPE_ID = B.LOOKUP_TYPE_ID
289: and T.LANGUAGE = L.LANGUAGE_CODE);
290: end ADD_LANGUAGE;
291: