APPS.FEM_SOURCE_SYSTEMS_PKG dependencies on FEM_SOURCE_SYSTEMS_TL

Line 49: insert into FEM_SOURCE_SYSTEMS_TL (

45: X_LAST_UPDATED_BY,
46: X_LAST_UPDATE_LOGIN
47: );
48:
49: insert into FEM_SOURCE_SYSTEMS_TL (
50: SOURCE_SYSTEM_CODE,
51: LAST_UPDATE_DATE,
52: LAST_UPDATE_LOGIN,
53: SOURCE_SYSTEM_NAME,

Line 75: from FEM_SOURCE_SYSTEMS_TL T

71: from FND_LANGUAGES L
72: where L.INSTALLED_FLAG in ('I', 'B')
73: and not exists
74: (select NULL
75: from FEM_SOURCE_SYSTEMS_TL T
76: where T.SOURCE_SYSTEM_CODE = X_SOURCE_SYSTEM_CODE
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;

Line 114: from FEM_SOURCE_SYSTEMS_TL

110: cursor c1 is select
111: SOURCE_SYSTEM_NAME,
112: DESCRIPTION,
113: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
114: from FEM_SOURCE_SYSTEMS_TL
115: where SOURCE_SYSTEM_CODE = X_SOURCE_SYSTEM_CODE
116: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
117: for update of SOURCE_SYSTEM_CODE nowait;
118: begin

Line 184: update FEM_SOURCE_SYSTEMS_TL set

180: if (sql%notfound) then
181: raise no_data_found;
182: end if;
183:
184: update FEM_SOURCE_SYSTEMS_TL set
185: SOURCE_SYSTEM_NAME = X_SOURCE_SYSTEM_NAME,
186: DESCRIPTION = X_DESCRIPTION,
187: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
188: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 203: delete from FEM_SOURCE_SYSTEMS_TL

199: procedure DELETE_ROW (
200: X_SOURCE_SYSTEM_CODE in NUMBER
201: ) is
202: begin
203: delete from FEM_SOURCE_SYSTEMS_TL
204: where SOURCE_SYSTEM_CODE = X_SOURCE_SYSTEM_CODE;
205:
206: if (sql%notfound) then
207: raise no_data_found;

Line 221: delete from FEM_SOURCE_SYSTEMS_TL T

217:
218: procedure ADD_LANGUAGE
219: is
220: begin
221: delete from FEM_SOURCE_SYSTEMS_TL T
222: where not exists
223: (select NULL
224: from FEM_SOURCE_SYSTEMS_B B
225: where B.SOURCE_SYSTEM_CODE = T.SOURCE_SYSTEM_CODE

Line 228: update FEM_SOURCE_SYSTEMS_TL T set (

224: from FEM_SOURCE_SYSTEMS_B B
225: where B.SOURCE_SYSTEM_CODE = T.SOURCE_SYSTEM_CODE
226: );
227:
228: update FEM_SOURCE_SYSTEMS_TL T set (
229: SOURCE_SYSTEM_NAME,
230: DESCRIPTION
231: ) = (select
232: B.SOURCE_SYSTEM_NAME,

Line 234: from FEM_SOURCE_SYSTEMS_TL B

230: DESCRIPTION
231: ) = (select
232: B.SOURCE_SYSTEM_NAME,
233: B.DESCRIPTION
234: from FEM_SOURCE_SYSTEMS_TL B
235: where B.SOURCE_SYSTEM_CODE = T.SOURCE_SYSTEM_CODE
236: and B.LANGUAGE = T.SOURCE_LANG)
237: where (
238: T.SOURCE_SYSTEM_CODE,

Line 243: from FEM_SOURCE_SYSTEMS_TL SUBB, FEM_SOURCE_SYSTEMS_TL SUBT

239: T.LANGUAGE
240: ) in (select
241: SUBT.SOURCE_SYSTEM_CODE,
242: SUBT.LANGUAGE
243: from FEM_SOURCE_SYSTEMS_TL SUBB, FEM_SOURCE_SYSTEMS_TL SUBT
244: where SUBB.SOURCE_SYSTEM_CODE = SUBT.SOURCE_SYSTEM_CODE
245: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
246: and (SUBB.SOURCE_SYSTEM_NAME <> SUBT.SOURCE_SYSTEM_NAME
247: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 252: insert into FEM_SOURCE_SYSTEMS_TL (

248: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
249: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
250: ));
251:
252: insert into FEM_SOURCE_SYSTEMS_TL (
253: SOURCE_SYSTEM_CODE,
254: LAST_UPDATE_DATE,
255: LAST_UPDATE_LOGIN,
256: SOURCE_SYSTEM_NAME,

Line 274: from FEM_SOURCE_SYSTEMS_TL B, FND_LANGUAGES L

270: B.CREATED_BY,
271: B.LAST_UPDATED_BY,
272: L.LANGUAGE_CODE,
273: B.SOURCE_LANG
274: from FEM_SOURCE_SYSTEMS_TL B, FND_LANGUAGES L
275: where L.INSTALLED_FLAG in ('I', 'B')
276: and B.LANGUAGE = userenv('LANG')
277: and not exists
278: (select NULL

Line 279: from FEM_SOURCE_SYSTEMS_TL T

275: where L.INSTALLED_FLAG in ('I', 'B')
276: and B.LANGUAGE = userenv('LANG')
277: and not exists
278: (select NULL
279: from FEM_SOURCE_SYSTEMS_TL T
280: where T.SOURCE_SYSTEM_CODE = B.SOURCE_SYSTEM_CODE
281: and T.LANGUAGE = L.LANGUAGE_CODE);
282: end ADD_LANGUAGE;
283: PROCEDURE TRANSLATE_ROW(

Line 309: from FEM_SOURCE_SYSTEMS_TL

305: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
306: begin
307: select LAST_UPDATED_BY, LAST_UPDATE_DATE
308: into db_luby, db_ludate
309: from FEM_SOURCE_SYSTEMS_TL
310: where SOURCE_SYSTEM_CODE = x_SOURCE_SYSTEM_CODE
311: and LANGUAGE = userenv('LANG');
312:
313: -- Test for customization and version

Line 317: update FEM_SOURCE_SYSTEMS_TL set

313: -- Test for customization and version
314: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
315: db_ludate, x_custom_mode)) then
316: -- Update translations for this language
317: update FEM_SOURCE_SYSTEMS_TL set
318: SOURCE_SYSTEM_NAME = decode(x_SOURCE_SYSTEM_NAME,
319: fnd_load_util.null_value, null, -- Real null
320: null, x_SOURCE_SYSTEM_NAME, -- No change
321: x_SOURCE_SYSTEM_NAME),