APPS.IEU_CTL_PLUGINS_PKG dependencies on IEU_CTL_PLUGINS_TL

Line 53: insert into IEU_CTL_PLUGINS_TL (

49: FND_GLOBAL.USER_ID,
50: FND_GLOBAL.LOGIN_ID
51: );
52:
53: insert into IEU_CTL_PLUGINS_TL (
54: CREATION_DATE,
55: LAST_UPDATED_BY,
56: LAST_UPDATE_DATE,
57: CREATED_BY,

Line 81: from IEU_CTL_PLUGINS_TL T

77: from FND_LANGUAGES L
78: where L.INSTALLED_FLAG in ('I', 'B')
79: and not exists
80: (select NULL
81: from IEU_CTL_PLUGINS_TL T
82: where T.PLUGIN_ID = P_PLUGIN_ID
83: and T.LANGUAGE = L.LANGUAGE_CODE);
84:
85: open c;

Line 126: from IEU_CTL_PLUGINS_TL

122: cursor c1 is select
123: NAME,
124: DESCRIPTION,
125: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
126: from IEU_CTL_PLUGINS_TL
127: where PLUGIN_ID = P_PLUGIN_ID
128: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
129: for update of PLUGIN_ID nowait;
130: begin

Line 206: update IEU_CTL_PLUGINS_TL set

202: if (sql%notfound) then
203: raise no_data_found;
204: end if;
205:
206: update IEU_CTL_PLUGINS_TL set
207: NAME = P_NAME,
208: DESCRIPTION = P_DESCRIPTION,
209: LAST_UPDATE_DATE = SYSDATE,
210: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 225: delete from IEU_CTL_PLUGINS_TL

221: procedure DELETE_ROW (
222: P_PLUGIN_ID in NUMBER
223: ) is
224: begin
225: delete from IEU_CTL_PLUGINS_TL
226: where PLUGIN_ID = P_PLUGIN_ID;
227:
228: if (sql%notfound) then
229: raise no_data_found;

Line 243: delete from IEU_CTL_PLUGINS_TL T

239:
240: procedure ADD_LANGUAGE
241: is
242: begin
243: delete from IEU_CTL_PLUGINS_TL T
244: where not exists
245: (select NULL
246: from IEU_CTL_PLUGINS_B B
247: where B.PLUGIN_ID = T.PLUGIN_ID

Line 250: update IEU_CTL_PLUGINS_TL T set (

246: from IEU_CTL_PLUGINS_B B
247: where B.PLUGIN_ID = T.PLUGIN_ID
248: );
249:
250: update IEU_CTL_PLUGINS_TL T set (
251: NAME,
252: DESCRIPTION
253: ) = (select
254: B.NAME,

Line 256: from IEU_CTL_PLUGINS_TL B

252: DESCRIPTION
253: ) = (select
254: B.NAME,
255: B.DESCRIPTION
256: from IEU_CTL_PLUGINS_TL B
257: where B.PLUGIN_ID = T.PLUGIN_ID
258: and B.LANGUAGE = T.SOURCE_LANG)
259: where (
260: T.PLUGIN_ID,

Line 265: from IEU_CTL_PLUGINS_TL SUBB, IEU_CTL_PLUGINS_TL SUBT

261: T.LANGUAGE
262: ) in (select
263: SUBT.PLUGIN_ID,
264: SUBT.LANGUAGE
265: from IEU_CTL_PLUGINS_TL SUBB, IEU_CTL_PLUGINS_TL SUBT
266: where SUBB.PLUGIN_ID = SUBT.PLUGIN_ID
267: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
268: and (SUBB.NAME <> SUBT.NAME
269: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 272: insert into IEU_CTL_PLUGINS_TL (

268: and (SUBB.NAME <> SUBT.NAME
269: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
270: ));
271:
272: insert into IEU_CTL_PLUGINS_TL (
273: CREATION_DATE,
274: LAST_UPDATED_BY,
275: LAST_UPDATE_DATE,
276: CREATED_BY,

Line 296: from IEU_CTL_PLUGINS_TL B, FND_LANGUAGES L

292: B.LAST_UPDATE_LOGIN,
293: B.NAME,
294: L.LANGUAGE_CODE,
295: B.SOURCE_LANG
296: from IEU_CTL_PLUGINS_TL B, FND_LANGUAGES L
297: where L.INSTALLED_FLAG in ('I', 'B')
298: and B.LANGUAGE = userenv('LANG')
299: and not exists
300: (select NULL

Line 301: from IEU_CTL_PLUGINS_TL T

297: where L.INSTALLED_FLAG in ('I', 'B')
298: and B.LANGUAGE = userenv('LANG')
299: and not exists
300: (select NULL
301: from IEU_CTL_PLUGINS_TL T
302: where T.PLUGIN_ID = B.PLUGIN_ID
303: and T.LANGUAGE = L.LANGUAGE_CODE);
304: end ADD_LANGUAGE;
305:

Line 318: UPDATE IEU_CTL_PLUGINS_TL

314: --only update rows that have not been altered by user
315:
316: user_id := fnd_load_util.owner_id(P_OWNER);
317:
318: UPDATE IEU_CTL_PLUGINS_TL
319: SET
320: NAME = P_NAME,
321: SOURCE_LANG = userenv( 'LANG' ),
322: DESCRIPTION = P_DESCRIPTION,