APPS.FEM_DB_LINKS_PKG dependencies on FEM_DB_LINKS_TL

Line 43: insert into FEM_DB_LINKS_TL (

39: X_LAST_UPDATED_BY,
40: X_LAST_UPDATE_LOGIN
41: );
42:
43: insert into FEM_DB_LINKS_TL (
44: DATABASE_LINK,
45: DB_LINK_NAME,
46: DESCRIPTION,
47: CREATION_DATE,

Line 69: from FEM_DB_LINKS_TL T

65: from FND_LANGUAGES L
66: where L.INSTALLED_FLAG in ('I', 'B')
67: and not exists
68: (select NULL
69: from FEM_DB_LINKS_TL T
70: where T.DATABASE_LINK = X_DATABASE_LINK
71: and T.LANGUAGE = L.LANGUAGE_CODE);
72:
73: open c;

Line 104: from FEM_DB_LINKS_TL

100: cursor c1 is select
101: DB_LINK_NAME,
102: DESCRIPTION,
103: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
104: from FEM_DB_LINKS_TL
105: where DATABASE_LINK = X_DATABASE_LINK
106: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
107: for update of DATABASE_LINK nowait;
108: begin

Line 171: update FEM_DB_LINKS_TL set

167: if (sql%notfound) then
168: raise no_data_found;
169: end if;
170:
171: update FEM_DB_LINKS_TL set
172: DB_LINK_NAME = X_DB_LINK_NAME,
173: DESCRIPTION = X_DESCRIPTION,
174: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
175: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 190: delete from FEM_DB_LINKS_TL

186: procedure DELETE_ROW (
187: X_DATABASE_LINK in VARCHAR2
188: ) is
189: begin
190: delete from FEM_DB_LINKS_TL
191: where DATABASE_LINK = X_DATABASE_LINK;
192:
193: if (sql%notfound) then
194: raise no_data_found;

Line 208: delete from FEM_DB_LINKS_TL T

204:
205: procedure ADD_LANGUAGE
206: is
207: begin
208: delete from FEM_DB_LINKS_TL T
209: where not exists
210: (select NULL
211: from FEM_DB_LINKS_B B
212: where B.DATABASE_LINK = T.DATABASE_LINK

Line 215: update FEM_DB_LINKS_TL T set (

211: from FEM_DB_LINKS_B B
212: where B.DATABASE_LINK = T.DATABASE_LINK
213: );
214:
215: update FEM_DB_LINKS_TL T set (
216: DB_LINK_NAME,
217: DESCRIPTION
218: ) = (select
219: B.DB_LINK_NAME,

Line 221: from FEM_DB_LINKS_TL B

217: DESCRIPTION
218: ) = (select
219: B.DB_LINK_NAME,
220: B.DESCRIPTION
221: from FEM_DB_LINKS_TL B
222: where B.DATABASE_LINK = T.DATABASE_LINK
223: and B.LANGUAGE = T.SOURCE_LANG)
224: where (
225: T.DATABASE_LINK,

Line 230: from FEM_DB_LINKS_TL SUBB, FEM_DB_LINKS_TL SUBT

226: T.LANGUAGE
227: ) in (select
228: SUBT.DATABASE_LINK,
229: SUBT.LANGUAGE
230: from FEM_DB_LINKS_TL SUBB, FEM_DB_LINKS_TL SUBT
231: where SUBB.DATABASE_LINK = SUBT.DATABASE_LINK
232: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
233: and (SUBB.DB_LINK_NAME <> SUBT.DB_LINK_NAME
234: or (SUBB.DB_LINK_NAME is null and SUBT.DB_LINK_NAME is not null)

Line 241: insert into FEM_DB_LINKS_TL (

237: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
238: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
239: ));
240:
241: insert into FEM_DB_LINKS_TL (
242: DATABASE_LINK,
243: DB_LINK_NAME,
244: DESCRIPTION,
245: CREATION_DATE,

Line 263: from FEM_DB_LINKS_TL B, FND_LANGUAGES L

259: B.LAST_UPDATE_DATE,
260: B.LAST_UPDATE_LOGIN,
261: L.LANGUAGE_CODE,
262: B.SOURCE_LANG
263: from FEM_DB_LINKS_TL B, FND_LANGUAGES L
264: where L.INSTALLED_FLAG in ('I', 'B')
265: and B.LANGUAGE = userenv('LANG')
266: and not exists
267: (select NULL

Line 268: from FEM_DB_LINKS_TL T

264: where L.INSTALLED_FLAG in ('I', 'B')
265: and B.LANGUAGE = userenv('LANG')
266: and not exists
267: (select NULL
268: from FEM_DB_LINKS_TL T
269: where T.DATABASE_LINK = B.DATABASE_LINK
270: and T.LANGUAGE = L.LANGUAGE_CODE);
271: end ADD_LANGUAGE;
272: PROCEDURE TRANSLATE_ROW(

Line 298: from FEM_DB_LINKS_TL

294: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
295: begin
296: select LAST_UPDATED_BY, LAST_UPDATE_DATE
297: into db_luby, db_ludate
298: from FEM_DB_LINKS_TL
299: where DATABASE_LINK = x_DATABASE_LINK
300: and LANGUAGE = userenv('LANG');
301:
302: -- Test for customization and version

Line 306: update FEM_DB_LINKS_TL set

302: -- Test for customization and version
303: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
304: db_ludate, x_custom_mode)) then
305: -- Update translations for this language
306: update FEM_DB_LINKS_TL set
307: DB_LINK_NAME = decode(x_DB_LINK_NAME,
308: fnd_load_util.null_value, null, -- Real null
309: null, x_DB_LINK_NAME, -- No change
310: x_DB_LINK_NAME),