APPS.FND_CONC_RELEASE_DISJS_PKG dependencies on FND_CONC_RELEASE_DISJS_TL

Line 54: insert into FND_CONC_RELEASE_DISJS_TL (

50: X_LAST_UPDATED_BY,
51: X_LAST_UPDATE_LOGIN
52: );
53:
54: insert into FND_CONC_RELEASE_DISJS_TL (
55: APPLICATION_ID,
56: DISJUNCTION_ID,
57: USER_DISJUNCTION_NAME,
58: DESCRIPTION,

Line 82: from FND_CONC_RELEASE_DISJS_TL T

78: from FND_LANGUAGES L
79: where L.INSTALLED_FLAG in ('I', 'B')
80: and not exists
81: (select NULL
82: from FND_CONC_RELEASE_DISJS_TL T
83: where T.DISJUNCTION_ID = X_DISJUNCTION_ID
84: and T.APPLICATION_ID = X_APPLICATION_ID
85: and T.LANGUAGE = L.LANGUAGE_CODE);
86:

Line 123: from FND_CONC_RELEASE_DISJS_TL

119:
120: cursor c1 is select
121: USER_DISJUNCTION_NAME,
122: DESCRIPTION
123: from FND_CONC_RELEASE_DISJS_TL
124: where DISJUNCTION_ID = X_DISJUNCTION_ID
125: and APPLICATION_ID = X_APPLICATION_ID
126: and LANGUAGE = userenv('LANG')
127: for update of DISJUNCTION_ID nowait;

Line 204: update FND_CONC_RELEASE_DISJS_TL set

200: if (sql%notfound) then
201: raise no_data_found;
202: end if;
203:
204: update FND_CONC_RELEASE_DISJS_TL set
205: USER_DISJUNCTION_NAME = X_USER_DISJUNCTION_NAME,
206: DESCRIPTION = X_DESCRIPTION,
207: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
208: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 233: delete from FND_CONC_RELEASE_DISJS_TL

229: if (sql%notfound) then
230: raise no_data_found;
231: end if;
232:
233: delete from FND_CONC_RELEASE_DISJS_TL
234: where DISJUNCTION_ID = X_DISJUNCTION_ID
235: and APPLICATION_ID = X_APPLICATION_ID;
236:
237: if (sql%notfound) then

Line 252: delete from FND_CONC_RELEASE_DISJS_TL T

248: /* as a quick workaround to fix the time-consuming table handler issue */
249: /* Eventually we'll need to turn them into a separate fix_language procedure */
250: /*
251:
252: delete from FND_CONC_RELEASE_DISJS_TL T
253: where not exists
254: (select NULL
255: from FND_CONC_RELEASE_DISJS B
256: where B.DISJUNCTION_ID = T.DISJUNCTION_ID

Line 260: update FND_CONC_RELEASE_DISJS_TL T set (

256: where B.DISJUNCTION_ID = T.DISJUNCTION_ID
257: and B.APPLICATION_ID = T.APPLICATION_ID
258: );
259:
260: update FND_CONC_RELEASE_DISJS_TL T set (
261: USER_DISJUNCTION_NAME,
262: DESCRIPTION
263: ) = (select
264: B.USER_DISJUNCTION_NAME,

Line 266: from FND_CONC_RELEASE_DISJS_TL B

262: DESCRIPTION
263: ) = (select
264: B.USER_DISJUNCTION_NAME,
265: B.DESCRIPTION
266: from FND_CONC_RELEASE_DISJS_TL B
267: where B.DISJUNCTION_ID = T.DISJUNCTION_ID
268: and B.APPLICATION_ID = T.APPLICATION_ID
269: and B.LANGUAGE = T.SOURCE_LANG)
270: where (

Line 278: from FND_CONC_RELEASE_DISJS_TL SUBB, FND_CONC_RELEASE_DISJS_TL SUBT

274: ) in (select
275: SUBT.DISJUNCTION_ID,
276: SUBT.APPLICATION_ID,
277: SUBT.LANGUAGE
278: from FND_CONC_RELEASE_DISJS_TL SUBB, FND_CONC_RELEASE_DISJS_TL SUBT
279: where SUBB.DISJUNCTION_ID = SUBT.DISJUNCTION_ID
280: and SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
281: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
282: and (SUBB.USER_DISJUNCTION_NAME <> SUBT.USER_DISJUNCTION_NAME

Line 289: insert into FND_CONC_RELEASE_DISJS_TL (

285: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
286: ));
287: */
288:
289: insert into FND_CONC_RELEASE_DISJS_TL (
290: APPLICATION_ID,
291: DISJUNCTION_ID,
292: USER_DISJUNCTION_NAME,
293: DESCRIPTION,

Line 313: from FND_CONC_RELEASE_DISJS_TL B, FND_LANGUAGES L

309: B.CREATION_DATE,
310: B.CREATED_BY,
311: L.LANGUAGE_CODE,
312: B.SOURCE_LANG
313: from FND_CONC_RELEASE_DISJS_TL B, FND_LANGUAGES L
314: where L.INSTALLED_FLAG in ('I', 'B')
315: and B.LANGUAGE = userenv('LANG')
316: and not exists
317: (select NULL

Line 318: from FND_CONC_RELEASE_DISJS_TL T

314: where L.INSTALLED_FLAG in ('I', 'B')
315: and B.LANGUAGE = userenv('LANG')
316: and not exists
317: (select NULL
318: from FND_CONC_RELEASE_DISJS_TL T
319: where T.DISJUNCTION_ID = B.DISJUNCTION_ID
320: and T.APPLICATION_ID = B.APPLICATION_ID
321: and T.LANGUAGE = L.LANGUAGE_CODE);
322: end ADD_LANGUAGE;