APPS.AMV_D_ENTITIES_PKG dependencies on AMV_D_ENTITIES_TL

Line 68: update AMV_D_ENTITIES_TL set

64: X_DESCRIPTION in VARCHAR2,
65: X_OWNER in VARCHAR2)
66: is
67: begin
68: update AMV_D_ENTITIES_TL set
69: ENTITY_NAME = x_entity_name,
70: DESCRIPTION = x_description,
71: LAST_UPDATE_DATE = sysdate,
72: LAST_UPDATED_BY = decode(x_owner, 'SEED', 1, 0),

Line 125: insert into AMV_D_ENTITIES_TL (

121: X_LAST_UPDATED_BY,
122: X_LAST_UPDATE_LOGIN
123: );
124:
125: insert into AMV_D_ENTITIES_TL (
126: ENTITY_ID,
127: LAST_UPDATE_DATE,
128: LAST_UPDATED_BY,
129: CREATION_DATE,

Line 151: from AMV_D_ENTITIES_TL T

147: from FND_LANGUAGES L
148: where L.INSTALLED_FLAG in ('I', 'B')
149: and not exists
150: (select NULL
151: from AMV_D_ENTITIES_TL T
152: where T.ENTITY_ID = X_ENTITY_ID
153: and T.LANGUAGE = L.LANGUAGE_CODE);
154:
155: open c;

Line 190: from AMV_D_ENTITIES_TL

186: cursor c1 is select
187: ENTITY_NAME,
188: DESCRIPTION,
189: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
190: from AMV_D_ENTITIES_TL
191: where ENTITY_ID = X_ENTITY_ID
192: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
193: for update of ENTITY_ID nowait;
194: begin

Line 260: update AMV_D_ENTITIES_TL set

256: if (sql%notfound) then
257: raise no_data_found;
258: end if;
259:
260: update AMV_D_ENTITIES_TL set
261: ENTITY_NAME = X_ENTITY_NAME,
262: DESCRIPTION = X_DESCRIPTION,
263: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
264: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 279: delete from AMV_D_ENTITIES_TL

275: procedure DELETE_ROW (
276: X_ENTITY_ID in NUMBER
277: ) is
278: begin
279: delete from AMV_D_ENTITIES_TL
280: where ENTITY_ID = X_ENTITY_ID;
281:
282: if (sql%notfound) then
283: raise no_data_found;

Line 297: delete from AMV_D_ENTITIES_TL T

293:
294: procedure ADD_LANGUAGE
295: is
296: begin
297: delete from AMV_D_ENTITIES_TL T
298: where not exists
299: (select NULL
300: from AMV_D_ENTITIES_B B
301: where B.ENTITY_ID = T.ENTITY_ID

Line 304: update AMV_D_ENTITIES_TL T set (

300: from AMV_D_ENTITIES_B B
301: where B.ENTITY_ID = T.ENTITY_ID
302: );
303:
304: update AMV_D_ENTITIES_TL T set (
305: ENTITY_NAME,
306: DESCRIPTION
307: ) = (select
308: B.ENTITY_NAME,

Line 310: from AMV_D_ENTITIES_TL B

306: DESCRIPTION
307: ) = (select
308: B.ENTITY_NAME,
309: B.DESCRIPTION
310: from AMV_D_ENTITIES_TL B
311: where B.ENTITY_ID = T.ENTITY_ID
312: and B.LANGUAGE = T.SOURCE_LANG)
313: where (
314: T.ENTITY_ID,

Line 319: from AMV_D_ENTITIES_TL SUBB, AMV_D_ENTITIES_TL SUBT

315: T.LANGUAGE
316: ) in (select
317: SUBT.ENTITY_ID,
318: SUBT.LANGUAGE
319: from AMV_D_ENTITIES_TL SUBB, AMV_D_ENTITIES_TL SUBT
320: where SUBB.ENTITY_ID = SUBT.ENTITY_ID
321: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
322: and (SUBB.ENTITY_NAME <> SUBT.ENTITY_NAME
323: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 328: insert into AMV_D_ENTITIES_TL (

324: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
325: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
326: ));
327:
328: insert into AMV_D_ENTITIES_TL (
329: ENTITY_ID,
330: LAST_UPDATE_DATE,
331: LAST_UPDATED_BY,
332: CREATION_DATE,

Line 350: from AMV_D_ENTITIES_TL B, FND_LANGUAGES L

346: B.ENTITY_NAME,
347: B.DESCRIPTION,
348: L.LANGUAGE_CODE,
349: B.SOURCE_LANG
350: from AMV_D_ENTITIES_TL B, FND_LANGUAGES L
351: where L.INSTALLED_FLAG in ('I', 'B')
352: and B.LANGUAGE = userenv('LANG')
353: and not exists
354: (select NULL

Line 355: from AMV_D_ENTITIES_TL T

351: where L.INSTALLED_FLAG in ('I', 'B')
352: and B.LANGUAGE = userenv('LANG')
353: and not exists
354: (select NULL
355: from AMV_D_ENTITIES_TL T
356: where T.ENTITY_ID = B.ENTITY_ID
357: and T.LANGUAGE = L.LANGUAGE_CODE);
358: end ADD_LANGUAGE;
359: