APPS.FEM_SIC_PKG dependencies on FEM_SIC_TL

Line 52: insert into FEM_SIC_TL (

48: X_LAST_UPDATED_BY,
49: X_LAST_UPDATE_LOGIN
50: );
51:
52: insert into FEM_SIC_TL (
53: SIC_ID,
54: SIC_NAME,
55: DESCRIPTION,
56: CREATION_DATE,

Line 78: from FEM_SIC_TL T

74: from FND_LANGUAGES L
75: where L.INSTALLED_FLAG in ('I', 'B')
76: and not exists
77: (select NULL
78: from FEM_SIC_TL T
79: where T.SIC_ID = X_SIC_ID
80: and T.LANGUAGE = L.LANGUAGE_CODE);
81:
82: open c;

Line 119: from FEM_SIC_TL

115: cursor c1 is select
116: SIC_NAME,
117: DESCRIPTION,
118: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
119: from FEM_SIC_TL
120: where SIC_ID = X_SIC_ID
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
122: for update of SIC_ID nowait;
123: begin

Line 191: update FEM_SIC_TL set

187: if (sql%notfound) then
188: raise no_data_found;
189: end if;
190:
191: update FEM_SIC_TL set
192: SIC_NAME = X_SIC_NAME,
193: DESCRIPTION = X_DESCRIPTION,
194: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
195: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 210: delete from FEM_SIC_TL

206: procedure DELETE_ROW (
207: X_SIC_ID in NUMBER
208: ) is
209: begin
210: delete from FEM_SIC_TL
211: where SIC_ID = X_SIC_ID;
212:
213: if (sql%notfound) then
214: raise no_data_found;

Line 228: delete from FEM_SIC_TL T

224:
225: procedure ADD_LANGUAGE
226: is
227: begin
228: delete from FEM_SIC_TL T
229: where not exists
230: (select NULL
231: from FEM_SIC_B B
232: where B.SIC_ID = T.SIC_ID

Line 235: update FEM_SIC_TL T set (

231: from FEM_SIC_B B
232: where B.SIC_ID = T.SIC_ID
233: );
234:
235: update FEM_SIC_TL T set (
236: SIC_NAME,
237: DESCRIPTION
238: ) = (select
239: B.SIC_NAME,

Line 241: from FEM_SIC_TL B

237: DESCRIPTION
238: ) = (select
239: B.SIC_NAME,
240: B.DESCRIPTION
241: from FEM_SIC_TL B
242: where B.SIC_ID = T.SIC_ID
243: and B.LANGUAGE = T.SOURCE_LANG)
244: where (
245: T.SIC_ID,

Line 250: from FEM_SIC_TL SUBB, FEM_SIC_TL SUBT

246: T.LANGUAGE
247: ) in (select
248: SUBT.SIC_ID,
249: SUBT.LANGUAGE
250: from FEM_SIC_TL SUBB, FEM_SIC_TL SUBT
251: where SUBB.SIC_ID = SUBT.SIC_ID
252: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
253: and (SUBB.SIC_NAME <> SUBT.SIC_NAME
254: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 257: insert into FEM_SIC_TL (

253: and (SUBB.SIC_NAME <> SUBT.SIC_NAME
254: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
255: ));
256:
257: insert into FEM_SIC_TL (
258: SIC_ID,
259: SIC_NAME,
260: DESCRIPTION,
261: CREATION_DATE,

Line 279: from FEM_SIC_TL B, FND_LANGUAGES L

275: B.LAST_UPDATE_DATE,
276: B.LAST_UPDATE_LOGIN,
277: L.LANGUAGE_CODE,
278: B.SOURCE_LANG
279: from FEM_SIC_TL B, FND_LANGUAGES L
280: where L.INSTALLED_FLAG in ('I', 'B')
281: and B.LANGUAGE = userenv('LANG')
282: and not exists
283: (select NULL

Line 284: from FEM_SIC_TL T

280: where L.INSTALLED_FLAG in ('I', 'B')
281: and B.LANGUAGE = userenv('LANG')
282: and not exists
283: (select NULL
284: from FEM_SIC_TL T
285: where T.SIC_ID = B.SIC_ID
286: and T.LANGUAGE = L.LANGUAGE_CODE);
287: end ADD_LANGUAGE;
288: PROCEDURE TRANSLATE_ROW(

Line 314: from FEM_SIC_TL

310: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
311: begin
312: select LAST_UPDATED_BY, LAST_UPDATE_DATE
313: into db_luby, db_ludate
314: from FEM_SIC_TL
315: where SIC_ID = x_SIC_ID
316: and LANGUAGE = userenv('LANG');
317:
318: -- Test for customization and version

Line 322: update FEM_SIC_TL set

318: -- Test for customization and version
319: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
320: db_ludate, x_custom_mode)) then
321: -- Update translations for this language
322: update FEM_SIC_TL set
323: SIC_NAME = decode(x_SIC_NAME,
324: fnd_load_util.null_value, null, -- Real null
325: null, x_SIC_NAME, -- No change
326: x_SIC_NAME),