APPS.FEM_COLUMN_REQUIREMNT_PKG dependencies on FEM_COLUMN_REQUIREMNT_TL

Line 82: insert into FEM_COLUMN_REQUIREMNT_TL (

78: X_LAST_UPDATED_BY,
79: X_LAST_UPDATE_LOGIN
80: );
81:
82: insert into FEM_COLUMN_REQUIREMNT_TL (
83: COLUMN_NAME,
84: DISPLAY_NAME,
85: DESCRIPTION,
86: CREATION_DATE,

Line 108: from FEM_COLUMN_REQUIREMNT_TL T

104: from FND_LANGUAGES L
105: where L.INSTALLED_FLAG in ('I', 'B')
106: and not exists
107: (select NULL
108: from FEM_COLUMN_REQUIREMNT_TL T
109: where T.COLUMN_NAME = X_COLUMN_NAME
110: and T.LANGUAGE = L.LANGUAGE_CODE);
111:
112: open c;

Line 169: from FEM_COLUMN_REQUIREMNT_TL

165: cursor c1 is select
166: DISPLAY_NAME,
167: DESCRIPTION,
168: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
169: from FEM_COLUMN_REQUIREMNT_TL
170: where COLUMN_NAME = X_COLUMN_NAME
171: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
172: for update of COLUMN_NAME nowait;
173: begin

Line 280: update FEM_COLUMN_REQUIREMNT_TL set

276: if (sql%notfound) then
277: raise no_data_found;
278: end if;
279:
280: update FEM_COLUMN_REQUIREMNT_TL set
281: DISPLAY_NAME = X_DISPLAY_NAME,
282: DESCRIPTION = X_DESCRIPTION,
283: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
284: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 299: delete from FEM_COLUMN_REQUIREMNT_TL

295: procedure DELETE_ROW (
296: X_COLUMN_NAME in VARCHAR2
297: ) is
298: begin
299: delete from FEM_COLUMN_REQUIREMNT_TL
300: where COLUMN_NAME = X_COLUMN_NAME;
301:
302: if (sql%notfound) then
303: raise no_data_found;

Line 317: delete from FEM_COLUMN_REQUIREMNT_TL T

313:
314: procedure ADD_LANGUAGE
315: is
316: begin
317: delete from FEM_COLUMN_REQUIREMNT_TL T
318: where not exists
319: (select NULL
320: from FEM_COLUMN_REQUIREMNT_B B
321: where B.COLUMN_NAME = T.COLUMN_NAME

Line 324: update FEM_COLUMN_REQUIREMNT_TL T set (

320: from FEM_COLUMN_REQUIREMNT_B B
321: where B.COLUMN_NAME = T.COLUMN_NAME
322: );
323:
324: update FEM_COLUMN_REQUIREMNT_TL T set (
325: DISPLAY_NAME,
326: DESCRIPTION
327: ) = (select
328: B.DISPLAY_NAME,

Line 330: from FEM_COLUMN_REQUIREMNT_TL B

326: DESCRIPTION
327: ) = (select
328: B.DISPLAY_NAME,
329: B.DESCRIPTION
330: from FEM_COLUMN_REQUIREMNT_TL B
331: where B.COLUMN_NAME = T.COLUMN_NAME
332: and B.LANGUAGE = T.SOURCE_LANG)
333: where (
334: T.COLUMN_NAME,

Line 339: from FEM_COLUMN_REQUIREMNT_TL SUBB, FEM_COLUMN_REQUIREMNT_TL SUBT

335: T.LANGUAGE
336: ) in (select
337: SUBT.COLUMN_NAME,
338: SUBT.LANGUAGE
339: from FEM_COLUMN_REQUIREMNT_TL SUBB, FEM_COLUMN_REQUIREMNT_TL SUBT
340: where SUBB.COLUMN_NAME = SUBT.COLUMN_NAME
341: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
342: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
343: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 346: insert into FEM_COLUMN_REQUIREMNT_TL (

342: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
343: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
344: ));
345:
346: insert into FEM_COLUMN_REQUIREMNT_TL (
347: COLUMN_NAME,
348: DISPLAY_NAME,
349: DESCRIPTION,
350: CREATION_DATE,

Line 368: from FEM_COLUMN_REQUIREMNT_TL B, FND_LANGUAGES L

364: B.LAST_UPDATE_DATE,
365: B.LAST_UPDATE_LOGIN,
366: L.LANGUAGE_CODE,
367: B.SOURCE_LANG
368: from FEM_COLUMN_REQUIREMNT_TL B, FND_LANGUAGES L
369: where L.INSTALLED_FLAG in ('I', 'B')
370: and B.LANGUAGE = userenv('LANG')
371: and not exists
372: (select NULL

Line 373: from FEM_COLUMN_REQUIREMNT_TL T

369: where L.INSTALLED_FLAG in ('I', 'B')
370: and B.LANGUAGE = userenv('LANG')
371: and not exists
372: (select NULL
373: from FEM_COLUMN_REQUIREMNT_TL T
374: where T.COLUMN_NAME = B.COLUMN_NAME
375: and T.LANGUAGE = L.LANGUAGE_CODE);
376: end ADD_LANGUAGE;
377: PROCEDURE TRANSLATE_ROW(

Line 403: from FEM_COLUMN_REQUIREMNT_TL

399: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
400: begin
401: select LAST_UPDATED_BY, LAST_UPDATE_DATE
402: into db_luby, db_ludate
403: from FEM_COLUMN_REQUIREMNT_TL
404: where COLUMN_NAME = x_COLUMN_NAME
405: and LANGUAGE = userenv('LANG');
406:
407: -- Test for customization and version

Line 411: update FEM_COLUMN_REQUIREMNT_TL set

407: -- Test for customization and version
408: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
409: db_ludate, x_custom_mode)) then
410: -- Update translations for this language
411: update FEM_COLUMN_REQUIREMNT_TL set
412: DISPLAY_NAME = decode(x_DISPLAY_NAME,
413: fnd_load_util.null_value, null, -- Real null
414: null, x_DISPLAY_NAME, -- No change
415: x_DISPLAY_NAME),