APPS.FND_REQUEST_SETS_PKG dependencies on FND_REQUEST_SETS_TL

Line 72: insert into FND_REQUEST_SETS_TL (

68: X_LAST_UPDATED_BY,
69: X_LAST_UPDATE_LOGIN
70: );
71:
72: insert into FND_REQUEST_SETS_TL (
73: APPLICATION_ID,
74: REQUEST_SET_ID,
75: CREATION_DATE,
76: CREATED_BY,

Line 100: from FND_REQUEST_SETS_TL T

96: from FND_LANGUAGES L
97: where L.INSTALLED_FLAG in ('I', 'B')
98: and not exists
99: (select NULL
100: from FND_REQUEST_SETS_TL T
101: where T.REQUEST_SET_ID = X_REQUEST_SET_ID
102: and T.APPLICATION_ID = X_APPLICATION_ID
103: and T.LANGUAGE = L.LANGUAGE_CODE);
104:

Line 153: from FND_REQUEST_SETS_TL

149:
150: cursor c1 is select
151: USER_REQUEST_SET_NAME,
152: DESCRIPTION
153: from FND_REQUEST_SETS_TL
154: where REQUEST_SET_ID = X_REQUEST_SET_ID
155: and APPLICATION_ID = X_APPLICATION_ID
156: and LANGUAGE = userenv('LANG')
157: for update of REQUEST_SET_ID nowait;

Line 257: update FND_REQUEST_SETS_TL set

253: if (sql%notfound) then
254: raise no_data_found;
255: end if;
256:
257: update FND_REQUEST_SETS_TL set
258: USER_REQUEST_SET_NAME = X_USER_REQUEST_SET_NAME,
259: DESCRIPTION = X_DESCRIPTION,
260: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
261: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 305: delete from FND_REQUEST_SETS_TL

301: if (sql%notfound) then
302: raise no_data_found;
303: end if;
304:
305: delete from FND_REQUEST_SETS_TL
306: where APPLICATION_ID = X_APPLICATION_ID
307: and REQUEST_SET_ID = X_REQUEST_SET_ID;
308:
309: if (sql%notfound) then

Line 346: delete from FND_REQUEST_SETS_TL T

342: /* as a quick workaround to fix the time-consuming table handler issue */
343: /* Eventually we'll need to turn them into a separate fix_language procedure */
344: /*
345:
346: delete from FND_REQUEST_SETS_TL T
347: where not exists
348: (select NULL
349: from FND_REQUEST_SETS B
350: where B.REQUEST_SET_ID = T.REQUEST_SET_ID

Line 354: update FND_REQUEST_SETS_TL T set (

350: where B.REQUEST_SET_ID = T.REQUEST_SET_ID
351: and B.APPLICATION_ID = T.APPLICATION_ID
352: );
353:
354: update FND_REQUEST_SETS_TL T set (
355: USER_REQUEST_SET_NAME,
356: DESCRIPTION
357: ) = (select
358: B.USER_REQUEST_SET_NAME,

Line 360: from FND_REQUEST_SETS_TL B

356: DESCRIPTION
357: ) = (select
358: B.USER_REQUEST_SET_NAME,
359: B.DESCRIPTION
360: from FND_REQUEST_SETS_TL B
361: where B.REQUEST_SET_ID = T.REQUEST_SET_ID
362: and B.APPLICATION_ID = T.APPLICATION_ID
363: and B.LANGUAGE = T.SOURCE_LANG)
364: where (

Line 372: from FND_REQUEST_SETS_TL SUBB, FND_REQUEST_SETS_TL SUBT

368: ) in (select
369: SUBT.REQUEST_SET_ID,
370: SUBT.APPLICATION_ID,
371: SUBT.LANGUAGE
372: from FND_REQUEST_SETS_TL SUBB, FND_REQUEST_SETS_TL SUBT
373: where SUBB.REQUEST_SET_ID = SUBT.REQUEST_SET_ID
374: and SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
375: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
376: and (SUBB.USER_REQUEST_SET_NAME <> SUBT.USER_REQUEST_SET_NAME

Line 383: insert into FND_REQUEST_SETS_TL (

379: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
380: ));
381: */
382:
383: insert into FND_REQUEST_SETS_TL (
384: APPLICATION_ID,
385: REQUEST_SET_ID,
386: CREATION_DATE,
387: CREATED_BY,

Line 407: from FND_REQUEST_SETS_TL B, FND_LANGUAGES L

403: B.USER_REQUEST_SET_NAME,
404: B.DESCRIPTION,
405: L.LANGUAGE_CODE,
406: B.SOURCE_LANG
407: from FND_REQUEST_SETS_TL B, FND_LANGUAGES L
408: where L.INSTALLED_FLAG in ('I', 'B')
409: and B.LANGUAGE = userenv('LANG')
410: and not exists
411: (select NULL

Line 412: from FND_REQUEST_SETS_TL T

408: where L.INSTALLED_FLAG in ('I', 'B')
409: and B.LANGUAGE = userenv('LANG')
410: and not exists
411: (select NULL
412: from FND_REQUEST_SETS_TL T
413: where T.REQUEST_SET_ID = B.REQUEST_SET_ID
414: and T.APPLICATION_ID = B.APPLICATION_ID
415: and T.LANGUAGE = L.LANGUAGE_CODE);
416: end ADD_LANGUAGE;