APPS.FEM_DS_BALANCE_TYPES_PKG dependencies on FEM_DS_BALANCE_TYPES_TL

Line 43: insert into FEM_DS_BALANCE_TYPES_TL (

39: X_LAST_UPDATED_BY,
40: X_LAST_UPDATE_LOGIN
41: );
42:
43: insert into FEM_DS_BALANCE_TYPES_TL (
44: DS_BALANCE_TYPE_CODE,
45: DS_BALANCE_TYPE_NAME,
46: DESCRIPTION,
47: CREATION_DATE,

Line 69: from FEM_DS_BALANCE_TYPES_TL T

65: from FND_LANGUAGES L
66: where L.INSTALLED_FLAG in ('I', 'B')
67: and not exists
68: (select NULL
69: from FEM_DS_BALANCE_TYPES_TL T
70: where T.DS_BALANCE_TYPE_CODE = X_DS_BALANCE_TYPE_CODE
71: and T.LANGUAGE = L.LANGUAGE_CODE);
72:
73: open c;

Line 104: from FEM_DS_BALANCE_TYPES_TL

100: cursor c1 is select
101: DS_BALANCE_TYPE_NAME,
102: DESCRIPTION,
103: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
104: from FEM_DS_BALANCE_TYPES_TL
105: where DS_BALANCE_TYPE_CODE = X_DS_BALANCE_TYPE_CODE
106: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
107: for update of DS_BALANCE_TYPE_CODE nowait;
108: begin

Line 168: update FEM_DS_BALANCE_TYPES_TL set

164: if (sql%notfound) then
165: raise no_data_found;
166: end if;
167:
168: update FEM_DS_BALANCE_TYPES_TL set
169: DS_BALANCE_TYPE_NAME = X_DS_BALANCE_TYPE_NAME,
170: DESCRIPTION = X_DESCRIPTION,
171: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
172: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 187: delete from FEM_DS_BALANCE_TYPES_TL

183: procedure DELETE_ROW (
184: X_DS_BALANCE_TYPE_CODE in VARCHAR2
185: ) is
186: begin
187: delete from FEM_DS_BALANCE_TYPES_TL
188: where DS_BALANCE_TYPE_CODE = X_DS_BALANCE_TYPE_CODE;
189:
190: if (sql%notfound) then
191: raise no_data_found;

Line 205: delete from FEM_DS_BALANCE_TYPES_TL T

201:
202: procedure ADD_LANGUAGE
203: is
204: begin
205: delete from FEM_DS_BALANCE_TYPES_TL T
206: where not exists
207: (select NULL
208: from FEM_DS_BALANCE_TYPES_B B
209: where B.DS_BALANCE_TYPE_CODE = T.DS_BALANCE_TYPE_CODE

Line 212: update FEM_DS_BALANCE_TYPES_TL T set (

208: from FEM_DS_BALANCE_TYPES_B B
209: where B.DS_BALANCE_TYPE_CODE = T.DS_BALANCE_TYPE_CODE
210: );
211:
212: update FEM_DS_BALANCE_TYPES_TL T set (
213: DS_BALANCE_TYPE_NAME,
214: DESCRIPTION
215: ) = (select
216: B.DS_BALANCE_TYPE_NAME,

Line 218: from FEM_DS_BALANCE_TYPES_TL B

214: DESCRIPTION
215: ) = (select
216: B.DS_BALANCE_TYPE_NAME,
217: B.DESCRIPTION
218: from FEM_DS_BALANCE_TYPES_TL B
219: where B.DS_BALANCE_TYPE_CODE = T.DS_BALANCE_TYPE_CODE
220: and B.LANGUAGE = T.SOURCE_LANG)
221: where (
222: T.DS_BALANCE_TYPE_CODE,

Line 227: from FEM_DS_BALANCE_TYPES_TL SUBB, FEM_DS_BALANCE_TYPES_TL SUBT

223: T.LANGUAGE
224: ) in (select
225: SUBT.DS_BALANCE_TYPE_CODE,
226: SUBT.LANGUAGE
227: from FEM_DS_BALANCE_TYPES_TL SUBB, FEM_DS_BALANCE_TYPES_TL SUBT
228: where SUBB.DS_BALANCE_TYPE_CODE = SUBT.DS_BALANCE_TYPE_CODE
229: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
230: and (SUBB.DS_BALANCE_TYPE_NAME <> SUBT.DS_BALANCE_TYPE_NAME
231: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 236: insert into FEM_DS_BALANCE_TYPES_TL (

232: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
233: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
234: ));
235:
236: insert into FEM_DS_BALANCE_TYPES_TL (
237: DS_BALANCE_TYPE_CODE,
238: DS_BALANCE_TYPE_NAME,
239: DESCRIPTION,
240: CREATION_DATE,

Line 258: from FEM_DS_BALANCE_TYPES_TL B, FND_LANGUAGES L

254: B.LAST_UPDATE_DATE,
255: B.LAST_UPDATE_LOGIN,
256: L.LANGUAGE_CODE,
257: B.SOURCE_LANG
258: from FEM_DS_BALANCE_TYPES_TL B, FND_LANGUAGES L
259: where L.INSTALLED_FLAG in ('I', 'B')
260: and B.LANGUAGE = userenv('LANG')
261: and not exists
262: (select NULL

Line 263: from FEM_DS_BALANCE_TYPES_TL T

259: where L.INSTALLED_FLAG in ('I', 'B')
260: and B.LANGUAGE = userenv('LANG')
261: and not exists
262: (select NULL
263: from FEM_DS_BALANCE_TYPES_TL T
264: where T.DS_BALANCE_TYPE_CODE = B.DS_BALANCE_TYPE_CODE
265: and T.LANGUAGE = L.LANGUAGE_CODE);
266: end ADD_LANGUAGE;
267: PROCEDURE TRANSLATE_ROW(

Line 293: from FEM_DS_BALANCE_TYPES_TL

289: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
290: begin
291: select LAST_UPDATED_BY, LAST_UPDATE_DATE
292: into db_luby, db_ludate
293: from FEM_DS_BALANCE_TYPES_TL
294: where DS_BALANCE_TYPE_CODE = x_DS_BALANCE_TYPE_CODE
295: and LANGUAGE = userenv('LANG');
296:
297: -- Test for customization and version

Line 301: update FEM_DS_BALANCE_TYPES_TL set

297: -- Test for customization and version
298: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
299: db_ludate, x_custom_mode)) then
300: -- Update translations for this language
301: update FEM_DS_BALANCE_TYPES_TL set
302: DS_BALANCE_TYPE_NAME = decode(x_DS_BALANCE_TYPE_NAME,
303: fnd_load_util.null_value, null, -- Real null
304: null, x_DS_BALANCE_TYPE_NAME, -- No change
305: x_DS_BALANCE_TYPE_NAME),