APPS.FND_CONC_RELEASE_STATES_PKG dependencies on FND_CONC_RELEASE_STATES_TL

Line 60: insert into FND_CONC_RELEASE_STATES_TL (

56: X_LAST_UPDATED_BY,
57: X_LAST_UPDATE_LOGIN
58: );
59:
60: insert into FND_CONC_RELEASE_STATES_TL (
61: APPLICATION_ID,
62: CONCURRENT_STATE_ID,
63: USER_CONCURRENT_STATE_NAME,
64: DESCRIPTION,

Line 88: from FND_CONC_RELEASE_STATES_TL T

84: from FND_LANGUAGES L
85: where L.INSTALLED_FLAG in ('I', 'B')
86: and not exists
87: (select NULL
88: from FND_CONC_RELEASE_STATES_TL T
89: where T.CONCURRENT_STATE_ID = X_CONCURRENT_STATE_ID
90: and T.APPLICATION_ID = X_APPLICATION_ID
91: and T.LANGUAGE = L.LANGUAGE_CODE);
92:

Line 133: from FND_CONC_RELEASE_STATES_TL

129:
130: cursor c1 is select
131: USER_CONCURRENT_STATE_NAME,
132: DESCRIPTION
133: from FND_CONC_RELEASE_STATES_TL
134: where CONCURRENT_STATE_ID = X_CONCURRENT_STATE_ID
135: and APPLICATION_ID = X_APPLICATION_ID
136: and LANGUAGE = userenv('LANG')
137: for update of CONCURRENT_STATE_ID nowait;

Line 220: update FND_CONC_RELEASE_STATES_TL set

216: if (sql%notfound) then
217: raise no_data_found;
218: end if;
219:
220: update FND_CONC_RELEASE_STATES_TL set
221: USER_CONCURRENT_STATE_NAME = X_USER_CONCURRENT_STATE_NAME,
222: DESCRIPTION = X_DESCRIPTION,
223: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
224: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 249: delete from FND_CONC_RELEASE_STATES_TL

245: if (sql%notfound) then
246: raise no_data_found;
247: end if;
248:
249: delete from FND_CONC_RELEASE_STATES_TL
250: where CONCURRENT_STATE_ID = X_CONCURRENT_STATE_ID
251: and APPLICATION_ID = X_APPLICATION_ID;
252:
253: if (sql%notfound) then

Line 267: delete from FND_CONC_RELEASE_STATES_TL T

263: /* The following delete and update statements are commented out */
264: /* as a quick workaround to fix the time-consuming table handler issue */
265: /* Eventually we'll need to turn them into a separate fix_language procedure */
266: /*
267: delete from FND_CONC_RELEASE_STATES_TL T
268: where not exists
269: (select NULL
270: from FND_CONC_RELEASE_STATES B
271: where B.CONCURRENT_STATE_ID = T.CONCURRENT_STATE_ID

Line 275: update FND_CONC_RELEASE_STATES_TL T set (

271: where B.CONCURRENT_STATE_ID = T.CONCURRENT_STATE_ID
272: and B.APPLICATION_ID = T.APPLICATION_ID
273: );
274:
275: update FND_CONC_RELEASE_STATES_TL T set (
276: USER_CONCURRENT_STATE_NAME,
277: DESCRIPTION
278: ) = (select
279: B.USER_CONCURRENT_STATE_NAME,

Line 281: from FND_CONC_RELEASE_STATES_TL B

277: DESCRIPTION
278: ) = (select
279: B.USER_CONCURRENT_STATE_NAME,
280: B.DESCRIPTION
281: from FND_CONC_RELEASE_STATES_TL B
282: where B.CONCURRENT_STATE_ID = T.CONCURRENT_STATE_ID
283: and B.APPLICATION_ID = T.APPLICATION_ID
284: and B.LANGUAGE = T.SOURCE_LANG)
285: where (

Line 293: from FND_CONC_RELEASE_STATES_TL SUBB, FND_CONC_RELEASE_STATES_TL SUBT

289: ) in (select
290: SUBT.CONCURRENT_STATE_ID,
291: SUBT.APPLICATION_ID,
292: SUBT.LANGUAGE
293: from FND_CONC_RELEASE_STATES_TL SUBB, FND_CONC_RELEASE_STATES_TL SUBT
294: where SUBB.CONCURRENT_STATE_ID = SUBT.CONCURRENT_STATE_ID
295: and SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
296: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
297: and (SUBB.USER_CONCURRENT_STATE_NAME <> SUBT.USER_CONCURRENT_STATE_NAME

Line 304: insert into FND_CONC_RELEASE_STATES_TL (

300: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
301: ));
302: */
303:
304: insert into FND_CONC_RELEASE_STATES_TL (
305: APPLICATION_ID,
306: CONCURRENT_STATE_ID,
307: USER_CONCURRENT_STATE_NAME,
308: DESCRIPTION,

Line 328: from FND_CONC_RELEASE_STATES_TL B, FND_LANGUAGES L

324: B.CREATION_DATE,
325: B.CREATED_BY,
326: L.LANGUAGE_CODE,
327: B.SOURCE_LANG
328: from FND_CONC_RELEASE_STATES_TL B, FND_LANGUAGES L
329: where L.INSTALLED_FLAG in ('I', 'B')
330: and B.LANGUAGE = userenv('LANG')
331: and not exists
332: (select NULL

Line 333: from FND_CONC_RELEASE_STATES_TL T

329: where L.INSTALLED_FLAG in ('I', 'B')
330: and B.LANGUAGE = userenv('LANG')
331: and not exists
332: (select NULL
333: from FND_CONC_RELEASE_STATES_TL T
334: where T.CONCURRENT_STATE_ID = B.CONCURRENT_STATE_ID
335: and T.APPLICATION_ID = B.APPLICATION_ID
336: and T.LANGUAGE = L.LANGUAGE_CODE);
337: end ADD_LANGUAGE;