APPS.AMS_CELLS_ALL_PKG dependencies on AMS_CELLS_ALL_TL

Line 55: insert into AMS_CELLS_ALL_TL (

51: X_LAST_UPDATED_BY,
52: X_LAST_UPDATE_LOGIN
53: );
54:
55: insert into AMS_CELLS_ALL_TL (
56: DESCRIPTION,
57: LAST_UPDATE_LOGIN,
58: CELL_NAME,
59: CELL_ID,

Line 81: from AMS_CELLS_ALL_TL T

77: from FND_LANGUAGES L
78: where L.INSTALLED_FLAG in ('I', 'B')
79: and not exists
80: (select NULL
81: from AMS_CELLS_ALL_TL T
82: where T.CELL_ID = X_CELL_ID
83: and T.LANGUAGE = L.LANGUAGE_CODE);
84:
85: open c;

Line 124: from AMS_CELLS_ALL_TL

120: cursor c1 is select
121: CELL_NAME,
122: DESCRIPTION,
123: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
124: from AMS_CELLS_ALL_TL
125: where CELL_ID = X_CELL_ID
126: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
127: for update of CELL_ID nowait;
128: begin

Line 204: update AMS_CELLS_ALL_TL set

200: if (sql%notfound) then
201: raise no_data_found;
202: end if;
203:
204: update AMS_CELLS_ALL_TL set
205: CELL_NAME = X_CELL_NAME,
206: DESCRIPTION = X_DESCRIPTION,
207: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
208: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 223: delete from AMS_CELLS_ALL_TL

219: procedure DELETE_ROW (
220: X_CELL_ID in NUMBER
221: ) is
222: begin
223: delete from AMS_CELLS_ALL_TL
224: where CELL_ID = X_CELL_ID;
225:
226: if (sql%notfound) then
227: raise no_data_found;

Line 241: delete from AMS_CELLS_ALL_TL T

237:
238: procedure ADD_LANGUAGE
239: is
240: begin
241: delete from AMS_CELLS_ALL_TL T
242: where not exists
243: (select NULL
244: from AMS_CELLS_ALL_B B
245: where B.CELL_ID = T.CELL_ID

Line 248: update AMS_CELLS_ALL_TL T set (

244: from AMS_CELLS_ALL_B B
245: where B.CELL_ID = T.CELL_ID
246: );
247:
248: update AMS_CELLS_ALL_TL T set (
249: CELL_NAME,
250: DESCRIPTION
251: ) = (select
252: B.CELL_NAME,

Line 254: from AMS_CELLS_ALL_TL B

250: DESCRIPTION
251: ) = (select
252: B.CELL_NAME,
253: B.DESCRIPTION
254: from AMS_CELLS_ALL_TL B
255: where B.CELL_ID = T.CELL_ID
256: and B.LANGUAGE = T.SOURCE_LANG)
257: where (
258: T.CELL_ID,

Line 263: from AMS_CELLS_ALL_TL SUBB, AMS_CELLS_ALL_TL SUBT

259: T.LANGUAGE
260: ) in (select
261: SUBT.CELL_ID,
262: SUBT.LANGUAGE
263: from AMS_CELLS_ALL_TL SUBB, AMS_CELLS_ALL_TL SUBT
264: where SUBB.CELL_ID = SUBT.CELL_ID
265: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
266: and (SUBB.CELL_NAME <> SUBT.CELL_NAME
267: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 272: insert into AMS_CELLS_ALL_TL (

268: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
269: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
270: ));
271:
272: insert into AMS_CELLS_ALL_TL (
273: DESCRIPTION,
274: LAST_UPDATE_LOGIN,
275: CELL_NAME,
276: CELL_ID,

Line 294: from AMS_CELLS_ALL_TL B, FND_LANGUAGES L

290: B.CREATION_DATE,
291: B.CREATED_BY,
292: L.LANGUAGE_CODE,
293: B.SOURCE_LANG
294: from AMS_CELLS_ALL_TL B, FND_LANGUAGES L
295: where L.INSTALLED_FLAG in ('I', 'B')
296: and B.LANGUAGE = userenv('LANG')
297: and not exists
298: (select NULL

Line 299: from AMS_CELLS_ALL_TL T

295: where L.INSTALLED_FLAG in ('I', 'B')
296: and B.LANGUAGE = userenv('LANG')
297: and not exists
298: (select NULL
299: from AMS_CELLS_ALL_TL T
300: where T.CELL_ID = B.CELL_ID
301: and T.LANGUAGE = L.LANGUAGE_CODE);
302: end ADD_LANGUAGE;
303:

Line 312: update ams_cells_all_tl set

308: x_owner IN VARCHAR2
309: )
310: IS
311: BEGIN
312: update ams_cells_all_tl set
313: cell_name = NVL (x_cell_name, cell_name),
314: description = nvl(x_description, description),
315: source_lang = userenv('LANG'),
316: last_update_date = sysdate,