APPS.AMV_I_CONTENT_TYPES_PKG dependencies on AMV_I_CONTENT_TYPES_TL

Line 53: update AMV_I_CONTENT_TYPES_TL set

49: x_description in VARCHAR2,
50: x_owner in varchar2
51: ) IS
52: begin
53: update AMV_I_CONTENT_TYPES_TL set
54: CONTENT_TYPE_NAME = x_content_type_name,
55: DESCRIPTION = x_description,
56: LAST_UPDATE_DATE = sysdate,
57: LAST_UPDATED_BY = decode(x_owner, 'SEED', 1, 0),

Line 98: insert into AMV_I_CONTENT_TYPES_TL (

94: X_LAST_UPDATED_BY,
95: X_LAST_UPDATE_LOGIN
96: );
97:
98: insert into AMV_I_CONTENT_TYPES_TL (
99: CONTENT_TYPE_ID,
100: LAST_UPDATE_DATE,
101: LAST_UPDATED_BY,
102: CREATION_DATE,

Line 124: from AMV_I_CONTENT_TYPES_TL T

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

Line 155: from AMV_I_CONTENT_TYPES_TL

151: cursor c1 is select
152: CONTENT_TYPE_NAME,
153: DESCRIPTION,
154: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
155: from AMV_I_CONTENT_TYPES_TL
156: where CONTENT_TYPE_ID = X_CONTENT_TYPE_ID
157: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
158: for update of CONTENT_TYPE_ID nowait;
159: begin

Line 215: update AMV_I_CONTENT_TYPES_TL set

211: if (sql%notfound) then
212: raise no_data_found;
213: end if;
214:
215: update AMV_I_CONTENT_TYPES_TL set
216: CONTENT_TYPE_NAME =
217: decode(X_CONTENT_TYPE_NAME, FND_API.G_MISS_CHAR, CONTENT_TYPE_NAME,
218: X_CONTENT_TYPE_NAME),
219: DESCRIPTION =

Line 238: delete from AMV_I_CONTENT_TYPES_TL

234: procedure DELETE_ROW (
235: X_CONTENT_TYPE_ID in NUMBER
236: ) is
237: begin
238: delete from AMV_I_CONTENT_TYPES_TL
239: where CONTENT_TYPE_ID = X_CONTENT_TYPE_ID;
240:
241: if (sql%notfound) then
242: raise no_data_found;

Line 256: delete from AMV_I_CONTENT_TYPES_TL T

252:
253: procedure ADD_LANGUAGE
254: is
255: begin
256: delete from AMV_I_CONTENT_TYPES_TL T
257: where not exists
258: (select NULL
259: from AMV_I_CONTENT_TYPES_B B
260: where B.CONTENT_TYPE_ID = T.CONTENT_TYPE_ID

Line 263: update AMV_I_CONTENT_TYPES_TL T set (

259: from AMV_I_CONTENT_TYPES_B B
260: where B.CONTENT_TYPE_ID = T.CONTENT_TYPE_ID
261: );
262:
263: update AMV_I_CONTENT_TYPES_TL T set (
264: CONTENT_TYPE_NAME,
265: DESCRIPTION
266: ) = (select
267: B.CONTENT_TYPE_NAME,

Line 269: from AMV_I_CONTENT_TYPES_TL B

265: DESCRIPTION
266: ) = (select
267: B.CONTENT_TYPE_NAME,
268: B.DESCRIPTION
269: from AMV_I_CONTENT_TYPES_TL B
270: where B.CONTENT_TYPE_ID = T.CONTENT_TYPE_ID
271: and B.LANGUAGE = T.SOURCE_LANG)
272: where (
273: T.CONTENT_TYPE_ID,

Line 278: from AMV_I_CONTENT_TYPES_TL SUBB, AMV_I_CONTENT_TYPES_TL SUBT

274: T.LANGUAGE
275: ) in (select
276: SUBT.CONTENT_TYPE_ID,
277: SUBT.LANGUAGE
278: from AMV_I_CONTENT_TYPES_TL SUBB, AMV_I_CONTENT_TYPES_TL SUBT
279: where SUBB.CONTENT_TYPE_ID = SUBT.CONTENT_TYPE_ID
280: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
281: and (SUBB.CONTENT_TYPE_NAME <> SUBT.CONTENT_TYPE_NAME
282: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 287: insert into AMV_I_CONTENT_TYPES_TL (

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

Line 309: from AMV_I_CONTENT_TYPES_TL B, FND_LANGUAGES L

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

Line 314: from AMV_I_CONTENT_TYPES_TL T

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