APPS.FEM_BAL_SHEET_MODELS_PKG dependencies on FEM_BAL_SHEET_MODELS_TL

Line 49: insert into FEM_BAL_SHEET_MODELS_TL (

45: X_LAST_UPDATED_BY,
46: X_LAST_UPDATE_LOGIN
47: );
48:
49: insert into FEM_BAL_SHEET_MODELS_TL (
50: LAST_UPDATE_LOGIN,
51: DESCRIPTION,
52: CREATION_DATE,
53: CREATED_BY,

Line 75: from FEM_BAL_SHEET_MODELS_TL T

71: from FND_LANGUAGES L
72: where L.INSTALLED_FLAG in ('I', 'B')
73: and not exists
74: (select NULL
75: from FEM_BAL_SHEET_MODELS_TL T
76: where T.BAL_SHEET_MODEL_CODE = X_BAL_SHEET_MODEL_CODE
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;

Line 114: from FEM_BAL_SHEET_MODELS_TL

110: cursor c1 is select
111: BAL_SHEET_MODEL_NAME,
112: DESCRIPTION,
113: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
114: from FEM_BAL_SHEET_MODELS_TL
115: where BAL_SHEET_MODEL_CODE = X_BAL_SHEET_MODEL_CODE
116: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
117: for update of BAL_SHEET_MODEL_CODE nowait;
118: begin

Line 184: update FEM_BAL_SHEET_MODELS_TL set

180: if (sql%notfound) then
181: raise no_data_found;
182: end if;
183:
184: update FEM_BAL_SHEET_MODELS_TL set
185: BAL_SHEET_MODEL_NAME = X_BAL_SHEET_MODEL_NAME,
186: DESCRIPTION = X_DESCRIPTION,
187: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
188: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 203: delete from FEM_BAL_SHEET_MODELS_TL

199: procedure DELETE_ROW (
200: X_BAL_SHEET_MODEL_CODE in VARCHAR2
201: ) is
202: begin
203: delete from FEM_BAL_SHEET_MODELS_TL
204: where BAL_SHEET_MODEL_CODE = X_BAL_SHEET_MODEL_CODE;
205:
206: if (sql%notfound) then
207: raise no_data_found;

Line 221: delete from FEM_BAL_SHEET_MODELS_TL T

217:
218: procedure ADD_LANGUAGE
219: is
220: begin
221: delete from FEM_BAL_SHEET_MODELS_TL T
222: where not exists
223: (select NULL
224: from FEM_BAL_SHEET_MODELS_B B
225: where B.BAL_SHEET_MODEL_CODE = T.BAL_SHEET_MODEL_CODE

Line 228: update FEM_BAL_SHEET_MODELS_TL T set (

224: from FEM_BAL_SHEET_MODELS_B B
225: where B.BAL_SHEET_MODEL_CODE = T.BAL_SHEET_MODEL_CODE
226: );
227:
228: update FEM_BAL_SHEET_MODELS_TL T set (
229: BAL_SHEET_MODEL_NAME,
230: DESCRIPTION
231: ) = (select
232: B.BAL_SHEET_MODEL_NAME,

Line 234: from FEM_BAL_SHEET_MODELS_TL B

230: DESCRIPTION
231: ) = (select
232: B.BAL_SHEET_MODEL_NAME,
233: B.DESCRIPTION
234: from FEM_BAL_SHEET_MODELS_TL B
235: where B.BAL_SHEET_MODEL_CODE = T.BAL_SHEET_MODEL_CODE
236: and B.LANGUAGE = T.SOURCE_LANG)
237: where (
238: T.BAL_SHEET_MODEL_CODE,

Line 243: from FEM_BAL_SHEET_MODELS_TL SUBB, FEM_BAL_SHEET_MODELS_TL SUBT

239: T.LANGUAGE
240: ) in (select
241: SUBT.BAL_SHEET_MODEL_CODE,
242: SUBT.LANGUAGE
243: from FEM_BAL_SHEET_MODELS_TL SUBB, FEM_BAL_SHEET_MODELS_TL SUBT
244: where SUBB.BAL_SHEET_MODEL_CODE = SUBT.BAL_SHEET_MODEL_CODE
245: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
246: and (SUBB.BAL_SHEET_MODEL_NAME <> SUBT.BAL_SHEET_MODEL_NAME
247: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 252: insert into FEM_BAL_SHEET_MODELS_TL (

248: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
249: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
250: ));
251:
252: insert into FEM_BAL_SHEET_MODELS_TL (
253: LAST_UPDATE_LOGIN,
254: DESCRIPTION,
255: CREATION_DATE,
256: CREATED_BY,

Line 274: from FEM_BAL_SHEET_MODELS_TL B, FND_LANGUAGES L

270: B.BAL_SHEET_MODEL_CODE,
271: B.BAL_SHEET_MODEL_NAME,
272: L.LANGUAGE_CODE,
273: B.SOURCE_LANG
274: from FEM_BAL_SHEET_MODELS_TL B, FND_LANGUAGES L
275: where L.INSTALLED_FLAG in ('I', 'B')
276: and B.LANGUAGE = userenv('LANG')
277: and not exists
278: (select NULL

Line 279: from FEM_BAL_SHEET_MODELS_TL T

275: where L.INSTALLED_FLAG in ('I', 'B')
276: and B.LANGUAGE = userenv('LANG')
277: and not exists
278: (select NULL
279: from FEM_BAL_SHEET_MODELS_TL T
280: where T.BAL_SHEET_MODEL_CODE = B.BAL_SHEET_MODEL_CODE
281: and T.LANGUAGE = L.LANGUAGE_CODE);
282: end ADD_LANGUAGE;
283: PROCEDURE TRANSLATE_ROW(

Line 309: from FEM_BAL_SHEET_MODELS_TL

305: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
306: begin
307: select LAST_UPDATED_BY, LAST_UPDATE_DATE
308: into db_luby, db_ludate
309: from FEM_BAL_SHEET_MODELS_TL
310: where BAL_SHEET_MODEL_CODE = x_BAL_SHEET_MODEL_CODE
311: and LANGUAGE = userenv('LANG');
312:
313: -- Test for customization and version

Line 317: update FEM_BAL_SHEET_MODELS_TL set

313: -- Test for customization and version
314: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
315: db_ludate, x_custom_mode)) then
316: -- Update translations for this language
317: update FEM_BAL_SHEET_MODELS_TL set
318: BAL_SHEET_MODEL_NAME = decode(x_BAL_SHEET_MODEL_NAME,
319: fnd_load_util.null_value, null, -- Real null
320: null, x_BAL_SHEET_MODEL_NAME, -- No change
321: x_BAL_SHEET_MODEL_NAME),