DBA Data[Home] [Help]

APPS.FEM_OCCUPANCIES_PKG dependencies on FEM_OCCUPANCIES_TL

Line 49: insert into FEM_OCCUPANCIES_TL (

45: X_LAST_UPDATED_BY,
46: X_LAST_UPDATE_LOGIN
47: );
48:
49: insert into FEM_OCCUPANCIES_TL (
50: CREATION_DATE,
51: CREATED_BY,
52: LAST_UPDATED_BY,
53: LAST_UPDATE_DATE,

Line 75: from FEM_OCCUPANCIES_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_OCCUPANCIES_TL T
76: where T.OCCUPANCY_ID = X_OCCUPANCY_ID
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;

Line 114: from FEM_OCCUPANCIES_TL

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

Line 183: update FEM_OCCUPANCIES_TL set

179: if (sql%notfound) then
180: raise no_data_found;
181: end if;
182:
183: update FEM_OCCUPANCIES_TL set
184: OCCUPANCY_NAME = X_OCCUPANCY_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_OCCUPANCIES_TL

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

Line 220: delete from FEM_OCCUPANCIES_TL T

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

Line 227: update FEM_OCCUPANCIES_TL T set (

223: from FEM_OCCUPANCIES_B B
224: where B.OCCUPANCY_ID = T.OCCUPANCY_ID
225: );
226:
227: update FEM_OCCUPANCIES_TL T set (
228: OCCUPANCY_NAME,
229: DESCRIPTION
230: ) = (select
231: B.OCCUPANCY_NAME,

Line 233: from FEM_OCCUPANCIES_TL B

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

Line 242: from FEM_OCCUPANCIES_TL SUBB, FEM_OCCUPANCIES_TL SUBT

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

Line 249: insert into FEM_OCCUPANCIES_TL (

245: and (SUBB.OCCUPANCY_NAME <> SUBT.OCCUPANCY_NAME
246: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
247: ));
248:
249: insert into FEM_OCCUPANCIES_TL (
250: CREATION_DATE,
251: CREATED_BY,
252: LAST_UPDATED_BY,
253: LAST_UPDATE_DATE,

Line 271: from FEM_OCCUPANCIES_TL B, FND_LANGUAGES L

267: B.OCCUPANCY_NAME,
268: B.DESCRIPTION,
269: L.LANGUAGE_CODE,
270: B.SOURCE_LANG
271: from FEM_OCCUPANCIES_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_OCCUPANCIES_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_OCCUPANCIES_TL T
277: where T.OCCUPANCY_ID = B.OCCUPANCY_ID
278: and T.LANGUAGE = L.LANGUAGE_CODE);
279: end ADD_LANGUAGE;
280: PROCEDURE TRANSLATE_ROW(

Line 306: from FEM_OCCUPANCIES_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_OCCUPANCIES_TL
307: where OCCUPANCY_ID = x_OCCUPANCY_ID
308: and LANGUAGE = userenv('LANG');
309:
310: -- Test for customization and version

Line 314: update FEM_OCCUPANCIES_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_OCCUPANCIES_TL set
315: OCCUPANCY_NAME = decode(x_OCCUPANCY_NAME,
316: fnd_load_util.null_value, null, -- Real null
317: null, x_OCCUPANCY_NAME, -- No change
318: x_OCCUPANCY_NAME),