APPS.AMV_D_ENT_ATTRIBUTES_PKG dependencies on AMV_D_ENT_ATTRIBUTES_TL

Line 82: update AMV_D_ENT_ATTRIBUTES_TL set

78: X_DESCRIPTION in VARCHAR2,
79: X_OWNER in VARCHAR2)
80: is
81: begin
82: update AMV_D_ENT_ATTRIBUTES_TL set
83: ATTRIBUTE_NAME = x_attribute_name,
84: DESCRIPTION = x_description,
85: LAST_UPDATE_DATE = sysdate,
86: LAST_UPDATED_BY = decode(x_owner, 'SEED', 1, 0),

Line 154: insert into AMV_D_ENT_ATTRIBUTES_TL (

150: X_LAST_UPDATED_BY,
151: X_LAST_UPDATE_LOGIN
152: );
153:
154: insert into AMV_D_ENT_ATTRIBUTES_TL (
155: CREATION_DATE,
156: CREATED_BY,
157: LAST_UPDATE_LOGIN,
158: ATTRIBUTE_NAME,

Line 180: from AMV_D_ENT_ATTRIBUTES_TL T

176: from FND_LANGUAGES L
177: where L.INSTALLED_FLAG in ('I', 'B')
178: and not exists
179: (select NULL
180: from AMV_D_ENT_ATTRIBUTES_TL T
181: where T.ATTRIBUTE_ID = X_ATTRIBUTE_ID
182: and T.LANGUAGE = L.LANGUAGE_CODE);
183:
184: open c;

Line 229: from AMV_D_ENT_ATTRIBUTES_TL

225: cursor c1 is select
226: ATTRIBUTE_NAME,
227: DESCRIPTION,
228: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
229: from AMV_D_ENT_ATTRIBUTES_TL
230: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
231: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
232: for update of ATTRIBUTE_ID nowait;
233: begin

Line 318: update AMV_D_ENT_ATTRIBUTES_TL set

314: if (sql%notfound) then
315: raise no_data_found;
316: end if;
317:
318: update AMV_D_ENT_ATTRIBUTES_TL set
319: ATTRIBUTE_NAME = X_ATTRIBUTE_NAME,
320: DESCRIPTION = X_DESCRIPTION,
321: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
322: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 337: delete from AMV_D_ENT_ATTRIBUTES_TL

333: procedure DELETE_ROW (
334: X_ATTRIBUTE_ID in NUMBER
335: ) is
336: begin
337: delete from AMV_D_ENT_ATTRIBUTES_TL
338: where ATTRIBUTE_ID = X_ATTRIBUTE_ID;
339:
340: if (sql%notfound) then
341: raise no_data_found;

Line 355: delete from AMV_D_ENT_ATTRIBUTES_TL T

351:
352: procedure ADD_LANGUAGE
353: is
354: begin
355: delete from AMV_D_ENT_ATTRIBUTES_TL T
356: where not exists
357: (select NULL
358: from AMV_D_ENT_ATTRIBUTES_B B
359: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID

Line 362: update AMV_D_ENT_ATTRIBUTES_TL T set (

358: from AMV_D_ENT_ATTRIBUTES_B B
359: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
360: );
361:
362: update AMV_D_ENT_ATTRIBUTES_TL T set (
363: ATTRIBUTE_NAME,
364: DESCRIPTION
365: ) = (select
366: B.ATTRIBUTE_NAME,

Line 368: from AMV_D_ENT_ATTRIBUTES_TL B

364: DESCRIPTION
365: ) = (select
366: B.ATTRIBUTE_NAME,
367: B.DESCRIPTION
368: from AMV_D_ENT_ATTRIBUTES_TL B
369: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
370: and B.LANGUAGE = T.SOURCE_LANG)
371: where (
372: T.ATTRIBUTE_ID,

Line 377: from AMV_D_ENT_ATTRIBUTES_TL SUBB, AMV_D_ENT_ATTRIBUTES_TL SUBT

373: T.LANGUAGE
374: ) in (select
375: SUBT.ATTRIBUTE_ID,
376: SUBT.LANGUAGE
377: from AMV_D_ENT_ATTRIBUTES_TL SUBB, AMV_D_ENT_ATTRIBUTES_TL SUBT
378: where SUBB.ATTRIBUTE_ID = SUBT.ATTRIBUTE_ID
379: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
380: and (SUBB.ATTRIBUTE_NAME <> SUBT.ATTRIBUTE_NAME
381: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 386: insert into AMV_D_ENT_ATTRIBUTES_TL (

382: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
383: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
384: ));
385:
386: insert into AMV_D_ENT_ATTRIBUTES_TL (
387: CREATION_DATE,
388: CREATED_BY,
389: LAST_UPDATE_LOGIN,
390: ATTRIBUTE_NAME,

Line 408: from AMV_D_ENT_ATTRIBUTES_TL B, FND_LANGUAGES L

404: B.LAST_UPDATE_DATE,
405: B.LAST_UPDATED_BY,
406: L.LANGUAGE_CODE,
407: B.SOURCE_LANG
408: from AMV_D_ENT_ATTRIBUTES_TL B, FND_LANGUAGES L
409: where L.INSTALLED_FLAG in ('I', 'B')
410: and B.LANGUAGE = userenv('LANG')
411: and not exists
412: (select NULL

Line 413: from AMV_D_ENT_ATTRIBUTES_TL T

409: where L.INSTALLED_FLAG in ('I', 'B')
410: and B.LANGUAGE = userenv('LANG')
411: and not exists
412: (select NULL
413: from AMV_D_ENT_ATTRIBUTES_TL T
414: where T.ATTRIBUTE_ID = B.ATTRIBUTE_ID
415: and T.LANGUAGE = L.LANGUAGE_CODE);
416: end ADD_LANGUAGE;
417: