APPS.FEM_FOLDERS_PKG dependencies on FEM_FOLDERS_TL

Line 37: insert into FEM_FOLDERS_TL (

33: X_LAST_UPDATED_BY,
34: X_LAST_UPDATE_LOGIN
35: );
36:
37: insert into FEM_FOLDERS_TL (
38: FOLDER_ID,
39: FOLDER_NAME,
40: DESCRIPTION,
41: CREATED_BY,

Line 63: from FEM_FOLDERS_TL T

59: from FND_LANGUAGES L
60: where L.INSTALLED_FLAG in ('I', 'B')
61: and not exists
62: (select NULL
63: from FEM_FOLDERS_TL T
64: where T.FOLDER_ID = X_FOLDER_ID
65: and T.LANGUAGE = L.LANGUAGE_CODE);
66:
67: open c;

Line 94: from FEM_FOLDERS_TL

90: cursor c1 is select
91: FOLDER_NAME,
92: DESCRIPTION,
93: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
94: from FEM_FOLDERS_TL
95: where FOLDER_ID = X_FOLDER_ID
96: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
97: for update of FOLDER_ID nowait;
98: begin

Line 152: update FEM_FOLDERS_TL set

148: if (sql%notfound) then
149: raise no_data_found;
150: end if;
151:
152: update FEM_FOLDERS_TL set
153: FOLDER_NAME = X_FOLDER_NAME,
154: DESCRIPTION = X_DESCRIPTION,
155: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
156: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 171: delete from FEM_FOLDERS_TL

167: procedure DELETE_ROW (
168: X_FOLDER_ID in NUMBER
169: ) is
170: begin
171: delete from FEM_FOLDERS_TL
172: where FOLDER_ID = X_FOLDER_ID;
173:
174: if (sql%notfound) then
175: raise no_data_found;

Line 189: delete from FEM_FOLDERS_TL T

185:
186: procedure ADD_LANGUAGE
187: is
188: begin
189: delete from FEM_FOLDERS_TL T
190: where not exists
191: (select NULL
192: from FEM_FOLDERS_B B
193: where B.FOLDER_ID = T.FOLDER_ID

Line 196: update FEM_FOLDERS_TL T set (

192: from FEM_FOLDERS_B B
193: where B.FOLDER_ID = T.FOLDER_ID
194: );
195:
196: update FEM_FOLDERS_TL T set (
197: FOLDER_NAME,
198: DESCRIPTION
199: ) = (select
200: B.FOLDER_NAME,

Line 202: from FEM_FOLDERS_TL B

198: DESCRIPTION
199: ) = (select
200: B.FOLDER_NAME,
201: B.DESCRIPTION
202: from FEM_FOLDERS_TL B
203: where B.FOLDER_ID = T.FOLDER_ID
204: and B.LANGUAGE = T.SOURCE_LANG)
205: where (
206: T.FOLDER_ID,

Line 211: from FEM_FOLDERS_TL SUBB, FEM_FOLDERS_TL SUBT

207: T.LANGUAGE
208: ) in (select
209: SUBT.FOLDER_ID,
210: SUBT.LANGUAGE
211: from FEM_FOLDERS_TL SUBB, FEM_FOLDERS_TL SUBT
212: where SUBB.FOLDER_ID = SUBT.FOLDER_ID
213: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
214: and (SUBB.FOLDER_NAME <> SUBT.FOLDER_NAME
215: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 220: insert into FEM_FOLDERS_TL (

216: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
217: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
218: ));
219:
220: insert into FEM_FOLDERS_TL (
221: FOLDER_ID,
222: FOLDER_NAME,
223: DESCRIPTION,
224: CREATED_BY,

Line 242: from FEM_FOLDERS_TL B, FND_LANGUAGES L

238: B.LAST_UPDATE_DATE,
239: B.LAST_UPDATE_LOGIN,
240: L.LANGUAGE_CODE,
241: B.SOURCE_LANG
242: from FEM_FOLDERS_TL B, FND_LANGUAGES L
243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL

Line 247: from FEM_FOLDERS_TL T

243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL
247: from FEM_FOLDERS_TL T
248: where T.FOLDER_ID = B.FOLDER_ID
249: and T.LANGUAGE = L.LANGUAGE_CODE);
250: end ADD_LANGUAGE;
251: PROCEDURE TRANSLATE_ROW(

Line 277: from FEM_FOLDERS_TL

273: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
274: begin
275: select LAST_UPDATED_BY, LAST_UPDATE_DATE
276: into db_luby, db_ludate
277: from FEM_FOLDERS_TL
278: where FOLDER_ID = x_FOLDER_ID
279: and LANGUAGE = userenv('LANG');
280:
281: -- Test for customization and version

Line 285: update FEM_FOLDERS_TL set

281: -- Test for customization and version
282: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
283: db_ludate, x_custom_mode)) then
284: -- Update translations for this language
285: update FEM_FOLDERS_TL set
286: FOLDER_NAME = decode(x_FOLDER_NAME,
287: fnd_load_util.null_value, null, -- Real null
288: null, x_FOLDER_NAME, -- No change
289: x_FOLDER_NAME),