APPS.FEM_USER_LOV27_PKG dependencies on FEM_USER_LOV27_TL

Line 46: insert into FEM_USER_LOV27_TL (

42: X_LAST_UPDATED_BY,
43: X_LAST_UPDATE_LOGIN
44: );
45:
46: insert into FEM_USER_LOV27_TL (
47: USER_LOV27_CODE,
48: USER_LOV27_NAME,
49: DESCRIPTION,
50: CREATION_DATE,

Line 72: from FEM_USER_LOV27_TL T

68: from FND_LANGUAGES L
69: where L.INSTALLED_FLAG in ('I', 'B')
70: and not exists
71: (select NULL
72: from FEM_USER_LOV27_TL T
73: where T.USER_LOV27_CODE = X_USER_LOV27_CODE
74: and T.LANGUAGE = L.LANGUAGE_CODE);
75:
76: open c;

Line 109: from FEM_USER_LOV27_TL

105: cursor c1 is select
106: USER_LOV27_NAME,
107: DESCRIPTION,
108: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
109: from FEM_USER_LOV27_TL
110: where USER_LOV27_CODE = X_USER_LOV27_CODE
111: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
112: for update of USER_LOV27_CODE nowait;
113: begin

Line 176: update FEM_USER_LOV27_TL set

172: if (sql%notfound) then
173: raise no_data_found;
174: end if;
175:
176: update FEM_USER_LOV27_TL set
177: USER_LOV27_NAME = X_USER_LOV27_NAME,
178: DESCRIPTION = X_DESCRIPTION,
179: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
180: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 195: delete from FEM_USER_LOV27_TL

191: procedure DELETE_ROW (
192: X_USER_LOV27_CODE in VARCHAR2
193: ) is
194: begin
195: delete from FEM_USER_LOV27_TL
196: where USER_LOV27_CODE = X_USER_LOV27_CODE;
197:
198: if (sql%notfound) then
199: raise no_data_found;

Line 213: delete from FEM_USER_LOV27_TL T

209:
210: procedure ADD_LANGUAGE
211: is
212: begin
213: delete from FEM_USER_LOV27_TL T
214: where not exists
215: (select NULL
216: from FEM_USER_LOV27_B B
217: where B.USER_LOV27_CODE = T.USER_LOV27_CODE

Line 220: update FEM_USER_LOV27_TL T set (

216: from FEM_USER_LOV27_B B
217: where B.USER_LOV27_CODE = T.USER_LOV27_CODE
218: );
219:
220: update FEM_USER_LOV27_TL T set (
221: USER_LOV27_NAME,
222: DESCRIPTION
223: ) = (select
224: B.USER_LOV27_NAME,

Line 226: from FEM_USER_LOV27_TL B

222: DESCRIPTION
223: ) = (select
224: B.USER_LOV27_NAME,
225: B.DESCRIPTION
226: from FEM_USER_LOV27_TL B
227: where B.USER_LOV27_CODE = T.USER_LOV27_CODE
228: and B.LANGUAGE = T.SOURCE_LANG)
229: where (
230: T.USER_LOV27_CODE,

Line 235: from FEM_USER_LOV27_TL SUBB, FEM_USER_LOV27_TL SUBT

231: T.LANGUAGE
232: ) in (select
233: SUBT.USER_LOV27_CODE,
234: SUBT.LANGUAGE
235: from FEM_USER_LOV27_TL SUBB, FEM_USER_LOV27_TL SUBT
236: where SUBB.USER_LOV27_CODE = SUBT.USER_LOV27_CODE
237: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
238: and (SUBB.USER_LOV27_NAME <> SUBT.USER_LOV27_NAME
239: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 244: insert into FEM_USER_LOV27_TL (

240: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
241: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
242: ));
243:
244: insert into FEM_USER_LOV27_TL (
245: USER_LOV27_CODE,
246: USER_LOV27_NAME,
247: DESCRIPTION,
248: CREATION_DATE,

Line 266: from FEM_USER_LOV27_TL B, FND_LANGUAGES L

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

Line 271: from FEM_USER_LOV27_TL T

267: where L.INSTALLED_FLAG in ('I', 'B')
268: and B.LANGUAGE = userenv('LANG')
269: and not exists
270: (select NULL
271: from FEM_USER_LOV27_TL T
272: where T.USER_LOV27_CODE = B.USER_LOV27_CODE
273: and T.LANGUAGE = L.LANGUAGE_CODE);
274: end ADD_LANGUAGE;
275: PROCEDURE TRANSLATE_ROW(

Line 301: from FEM_USER_LOV27_TL

297: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
298: begin
299: select LAST_UPDATED_BY, LAST_UPDATE_DATE
300: into db_luby, db_ludate
301: from FEM_USER_LOV27_TL
302: where USER_LOV27_CODE = x_USER_LOV27_CODE
303: and LANGUAGE = userenv('LANG');
304:
305: -- Test for customization and version

Line 309: update FEM_USER_LOV27_TL set

305: -- Test for customization and version
306: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
307: db_ludate, x_custom_mode)) then
308: -- Update translations for this language
309: update FEM_USER_LOV27_TL set
310: USER_LOV27_NAME = decode(x_USER_LOV27_NAME,
311: fnd_load_util.null_value, null, -- Real null
312: null, x_USER_LOV27_NAME, -- No change
313: x_USER_LOV27_NAME),