APPS.FEM_COLLATERAL_PKG dependencies on FEM_COLLATERAL_TL

Line 49: insert into FEM_COLLATERAL_TL (

45: X_LAST_UPDATED_BY,
46: X_LAST_UPDATE_LOGIN
47: );
48:
49: insert into FEM_COLLATERAL_TL (
50: COLLATERAL_ID,
51: COLLATERAL_NAME,
52: DESCRIPTION,
53: CREATION_DATE,

Line 75: from FEM_COLLATERAL_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_COLLATERAL_TL T
76: where T.COLLATERAL_ID = X_COLLATERAL_ID
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;

Line 114: from FEM_COLLATERAL_TL

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

Line 183: update FEM_COLLATERAL_TL set

179: if (sql%notfound) then
180: raise no_data_found;
181: end if;
182:
183: update FEM_COLLATERAL_TL set
184: COLLATERAL_NAME = X_COLLATERAL_NAME,
185: DESCRIPTION = X_DESCRIPTION,
186: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
187: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 202: delete from FEM_COLLATERAL_TL

198: procedure DELETE_ROW (
199: X_COLLATERAL_ID in NUMBER
200: ) is
201: begin
202: delete from FEM_COLLATERAL_TL
203: where COLLATERAL_ID = X_COLLATERAL_ID;
204:
205: if (sql%notfound) then
206: raise no_data_found;

Line 220: delete from FEM_COLLATERAL_TL T

216:
217: procedure ADD_LANGUAGE
218: is
219: begin
220: delete from FEM_COLLATERAL_TL T
221: where not exists
222: (select NULL
223: from FEM_COLLATERAL_B B
224: where B.COLLATERAL_ID = T.COLLATERAL_ID

Line 227: update FEM_COLLATERAL_TL T set (

223: from FEM_COLLATERAL_B B
224: where B.COLLATERAL_ID = T.COLLATERAL_ID
225: );
226:
227: update FEM_COLLATERAL_TL T set (
228: COLLATERAL_NAME,
229: DESCRIPTION
230: ) = (select
231: B.COLLATERAL_NAME,

Line 233: from FEM_COLLATERAL_TL B

229: DESCRIPTION
230: ) = (select
231: B.COLLATERAL_NAME,
232: B.DESCRIPTION
233: from FEM_COLLATERAL_TL B
234: where B.COLLATERAL_ID = T.COLLATERAL_ID
235: and B.LANGUAGE = T.SOURCE_LANG)
236: where (
237: T.COLLATERAL_ID,

Line 242: from FEM_COLLATERAL_TL SUBB, FEM_COLLATERAL_TL SUBT

238: T.LANGUAGE
239: ) in (select
240: SUBT.COLLATERAL_ID,
241: SUBT.LANGUAGE
242: from FEM_COLLATERAL_TL SUBB, FEM_COLLATERAL_TL SUBT
243: where SUBB.COLLATERAL_ID = SUBT.COLLATERAL_ID
244: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
245: and (SUBB.COLLATERAL_NAME <> SUBT.COLLATERAL_NAME
246: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 249: insert into FEM_COLLATERAL_TL (

245: and (SUBB.COLLATERAL_NAME <> SUBT.COLLATERAL_NAME
246: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
247: ));
248:
249: insert into FEM_COLLATERAL_TL (
250: COLLATERAL_ID,
251: COLLATERAL_NAME,
252: DESCRIPTION,
253: CREATION_DATE,

Line 271: from FEM_COLLATERAL_TL B, FND_LANGUAGES L

267: B.LAST_UPDATE_DATE,
268: B.LAST_UPDATE_LOGIN,
269: L.LANGUAGE_CODE,
270: B.SOURCE_LANG
271: from FEM_COLLATERAL_TL B, FND_LANGUAGES L
272: where L.INSTALLED_FLAG in ('I', 'B')
273: and B.LANGUAGE = userenv('LANG')
274: and not exists
275: (select NULL

Line 276: from FEM_COLLATERAL_TL T

272: where L.INSTALLED_FLAG in ('I', 'B')
273: and B.LANGUAGE = userenv('LANG')
274: and not exists
275: (select NULL
276: from FEM_COLLATERAL_TL T
277: where T.COLLATERAL_ID = B.COLLATERAL_ID
278: and T.LANGUAGE = L.LANGUAGE_CODE);
279: end ADD_LANGUAGE;
280: PROCEDURE TRANSLATE_ROW(

Line 306: from FEM_COLLATERAL_TL

302: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
303: begin
304: select LAST_UPDATED_BY, LAST_UPDATE_DATE
305: into db_luby, db_ludate
306: from FEM_COLLATERAL_TL
307: where COLLATERAL_ID = x_COLLATERAL_ID
308: and LANGUAGE = userenv('LANG');
309:
310: -- Test for customization and version

Line 314: update FEM_COLLATERAL_TL set

310: -- Test for customization and version
311: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
312: db_ludate, x_custom_mode)) then
313: -- Update translations for this language
314: update FEM_COLLATERAL_TL set
315: COLLATERAL_NAME = decode(x_COLLATERAL_NAME,
316: fnd_load_util.null_value, null, -- Real null
317: null, x_COLLATERAL_NAME, -- No change
318: x_COLLATERAL_NAME),