APPS.FEM_CURRTYPES_PKG dependencies on FEM_CURRTYPES_TL

Line 46: insert into FEM_CURRTYPES_TL (

42: X_LAST_UPDATED_BY,
43: X_LAST_UPDATE_LOGIN
44: );
45:
46: insert into FEM_CURRTYPES_TL (
47: CREATED_BY,
48: LAST_UPDATED_BY,
49: LAST_UPDATE_DATE,
50: LAST_UPDATE_LOGIN,

Line 72: from FEM_CURRTYPES_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_CURRTYPES_TL T
73: where T.CURRENCY_TYPE_CODE = X_CURRENCY_TYPE_CODE
74: and T.LANGUAGE = L.LANGUAGE_CODE);
75:
76: open c;

Line 109: from FEM_CURRTYPES_TL

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

Line 175: update FEM_CURRTYPES_TL set

171: if (sql%notfound) then
172: raise no_data_found;
173: end if;
174:
175: update FEM_CURRTYPES_TL set
176: CURRENCY_TYPE_NAME = X_CURRENCY_TYPE_NAME,
177: DESCRIPTION = X_DESCRIPTION,
178: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
179: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 194: delete from FEM_CURRTYPES_TL

190: procedure DELETE_ROW (
191: X_CURRENCY_TYPE_CODE in VARCHAR2
192: ) is
193: begin
194: delete from FEM_CURRTYPES_TL
195: where CURRENCY_TYPE_CODE = X_CURRENCY_TYPE_CODE;
196:
197: if (sql%notfound) then
198: raise no_data_found;

Line 212: delete from FEM_CURRTYPES_TL T

208:
209: procedure ADD_LANGUAGE
210: is
211: begin
212: delete from FEM_CURRTYPES_TL T
213: where not exists
214: (select NULL
215: from FEM_CURRTYPES_B B
216: where B.CURRENCY_TYPE_CODE = T.CURRENCY_TYPE_CODE

Line 219: update FEM_CURRTYPES_TL T set (

215: from FEM_CURRTYPES_B B
216: where B.CURRENCY_TYPE_CODE = T.CURRENCY_TYPE_CODE
217: );
218:
219: update FEM_CURRTYPES_TL T set (
220: CURRENCY_TYPE_NAME,
221: DESCRIPTION
222: ) = (select
223: B.CURRENCY_TYPE_NAME,

Line 225: from FEM_CURRTYPES_TL B

221: DESCRIPTION
222: ) = (select
223: B.CURRENCY_TYPE_NAME,
224: B.DESCRIPTION
225: from FEM_CURRTYPES_TL B
226: where B.CURRENCY_TYPE_CODE = T.CURRENCY_TYPE_CODE
227: and B.LANGUAGE = T.SOURCE_LANG)
228: where (
229: T.CURRENCY_TYPE_CODE,

Line 234: from FEM_CURRTYPES_TL SUBB, FEM_CURRTYPES_TL SUBT

230: T.LANGUAGE
231: ) in (select
232: SUBT.CURRENCY_TYPE_CODE,
233: SUBT.LANGUAGE
234: from FEM_CURRTYPES_TL SUBB, FEM_CURRTYPES_TL SUBT
235: where SUBB.CURRENCY_TYPE_CODE = SUBT.CURRENCY_TYPE_CODE
236: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
237: and (SUBB.CURRENCY_TYPE_NAME <> SUBT.CURRENCY_TYPE_NAME
238: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 241: insert into FEM_CURRTYPES_TL (

237: and (SUBB.CURRENCY_TYPE_NAME <> SUBT.CURRENCY_TYPE_NAME
238: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
239: ));
240:
241: insert into FEM_CURRTYPES_TL (
242: CREATED_BY,
243: LAST_UPDATED_BY,
244: LAST_UPDATE_DATE,
245: LAST_UPDATE_LOGIN,

Line 263: from FEM_CURRTYPES_TL B, FND_LANGUAGES L

259: B.DESCRIPTION,
260: B.CREATION_DATE,
261: L.LANGUAGE_CODE,
262: B.SOURCE_LANG
263: from FEM_CURRTYPES_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_CURRTYPES_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_CURRTYPES_TL T
269: where T.CURRENCY_TYPE_CODE = B.CURRENCY_TYPE_CODE
270: and T.LANGUAGE = L.LANGUAGE_CODE);
271: end ADD_LANGUAGE;
272: PROCEDURE TRANSLATE_ROW(

Line 298: from FEM_CURRTYPES_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_CURRTYPES_TL
299: where CURRENCY_TYPE_CODE = x_CURRENCY_TYPE_CODE
300: and LANGUAGE = userenv('LANG');
301:
302: -- Test for customization and version

Line 306: update FEM_CURRTYPES_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_CURRTYPES_TL set
307: CURRENCY_TYPE_NAME = decode(x_CURRENCY_TYPE_NAME,
308: fnd_load_util.null_value, null, -- Real null
309: null, x_CURRENCY_TYPE_NAME, -- No change
310: x_CURRENCY_TYPE_NAME),