APPS.AMV_I_PERSPECTIVES_PKG dependencies on AMV_I_PERSPECTIVES_TL

Line 52: update AMV_I_PERSPECTIVES_TL set

48: x_description in varchar2,
49: x_owner in varchar2
50: ) is
51: begin
52: update AMV_I_PERSPECTIVES_TL set
53: PERSPECTIVE_NAME = x_perspective_name,
54: DESCRIPTION = x_description,
55: LAST_UPDATE_DATE = sysdate,
56: LAST_UPDATED_BY = decode(x_owner, 'SEED', 1, 0),

Line 97: insert into AMV_I_PERSPECTIVES_TL (

93: X_LAST_UPDATED_BY,
94: X_LAST_UPDATE_LOGIN
95: );
96:
97: insert into AMV_I_PERSPECTIVES_TL (
98: PERSPECTIVE_ID,
99: LAST_UPDATE_DATE,
100: LAST_UPDATED_BY,
101: CREATION_DATE,

Line 123: from AMV_I_PERSPECTIVES_TL T

119: from FND_LANGUAGES L
120: where L.INSTALLED_FLAG in ('I', 'B')
121: and not exists
122: (select NULL
123: from AMV_I_PERSPECTIVES_TL T
124: where T.PERSPECTIVE_ID = X_PERSPECTIVE_ID
125: and T.LANGUAGE = L.LANGUAGE_CODE);
126:
127: open c;

Line 154: from AMV_I_PERSPECTIVES_TL

150: cursor c1 is select
151: PERSPECTIVE_NAME,
152: DESCRIPTION,
153: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
154: from AMV_I_PERSPECTIVES_TL
155: where PERSPECTIVE_ID = X_PERSPECTIVE_ID
156: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
157: for update of PERSPECTIVE_ID nowait;
158: begin

Line 213: update AMV_I_PERSPECTIVES_TL set

209: if (sql%notfound) then
210: raise no_data_found;
211: end if;
212:
213: update AMV_I_PERSPECTIVES_TL set
214: PERSPECTIVE_NAME =
215: decode(X_PERSPECTIVE_NAME, FND_API.G_MISS_CHAR, PERSPECTIVE_NAME,
216: X_PERSPECTIVE_NAME),
217: DESCRIPTION =

Line 237: delete from AMV_I_PERSPECTIVES_TL

233: procedure DELETE_ROW (
234: X_PERSPECTIVE_ID in NUMBER
235: ) is
236: begin
237: delete from AMV_I_PERSPECTIVES_TL
238: where PERSPECTIVE_ID = X_PERSPECTIVE_ID;
239:
240: if (sql%notfound) then
241: raise no_data_found;

Line 255: delete from AMV_I_PERSPECTIVES_TL T

251:
252: procedure ADD_LANGUAGE
253: is
254: begin
255: delete from AMV_I_PERSPECTIVES_TL T
256: where not exists
257: (select NULL
258: from AMV_I_PERSPECTIVES_B B
259: where B.PERSPECTIVE_ID = T.PERSPECTIVE_ID

Line 262: update AMV_I_PERSPECTIVES_TL T set (

258: from AMV_I_PERSPECTIVES_B B
259: where B.PERSPECTIVE_ID = T.PERSPECTIVE_ID
260: );
261:
262: update AMV_I_PERSPECTIVES_TL T set (
263: PERSPECTIVE_NAME,
264: DESCRIPTION
265: ) = (select
266: B.PERSPECTIVE_NAME,

Line 268: from AMV_I_PERSPECTIVES_TL B

264: DESCRIPTION
265: ) = (select
266: B.PERSPECTIVE_NAME,
267: B.DESCRIPTION
268: from AMV_I_PERSPECTIVES_TL B
269: where B.PERSPECTIVE_ID = T.PERSPECTIVE_ID
270: and B.LANGUAGE = T.SOURCE_LANG)
271: where (
272: T.PERSPECTIVE_ID,

Line 277: from AMV_I_PERSPECTIVES_TL SUBB, AMV_I_PERSPECTIVES_TL SUBT

273: T.LANGUAGE
274: ) in (select
275: SUBT.PERSPECTIVE_ID,
276: SUBT.LANGUAGE
277: from AMV_I_PERSPECTIVES_TL SUBB, AMV_I_PERSPECTIVES_TL SUBT
278: where SUBB.PERSPECTIVE_ID = SUBT.PERSPECTIVE_ID
279: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
280: and (SUBB.PERSPECTIVE_NAME <> SUBT.PERSPECTIVE_NAME
281: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 286: insert into AMV_I_PERSPECTIVES_TL (

282: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
283: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
284: ));
285:
286: insert into AMV_I_PERSPECTIVES_TL (
287: PERSPECTIVE_ID,
288: LAST_UPDATE_DATE,
289: LAST_UPDATED_BY,
290: CREATION_DATE,

Line 308: from AMV_I_PERSPECTIVES_TL B, FND_LANGUAGES L

304: B.PERSPECTIVE_NAME,
305: B.DESCRIPTION,
306: L.LANGUAGE_CODE,
307: B.SOURCE_LANG
308: from AMV_I_PERSPECTIVES_TL B, FND_LANGUAGES L
309: where L.INSTALLED_FLAG in ('I', 'B')
310: and B.LANGUAGE = userenv('LANG')
311: and not exists
312: (select NULL

Line 313: from AMV_I_PERSPECTIVES_TL T

309: where L.INSTALLED_FLAG in ('I', 'B')
310: and B.LANGUAGE = userenv('LANG')
311: and not exists
312: (select NULL
313: from AMV_I_PERSPECTIVES_TL T
314: where T.PERSPECTIVE_ID = B.PERSPECTIVE_ID
315: and T.LANGUAGE = L.LANGUAGE_CODE);
316: end ADD_LANGUAGE;
317: