APPS.AMV_C_CATEGORIES_PKG dependencies on AMV_C_CATEGORIES_TL

Line 98: update AMV_C_CATEGORIES_TL set

94: X_DESCRIPTION in VARCHAR2,
95: X_OWNER in VARCHAR2)
96: is
97: begin
98: update AMV_C_CATEGORIES_TL set
99: CHANNEL_CATEGORY_NAME = x_channel_category_name,
100: DESCRIPTION = x_description,
101: LAST_UPDATE_DATE = sysdate,
102: LAST_UPDATED_BY = decode(x_owner, 'SEED', 1, 0),

Line 156: insert into AMV_C_CATEGORIES_TL (

152: X_LAST_UPDATED_BY,
153: X_LAST_UPDATE_LOGIN
154: );
155:
156: insert into AMV_C_CATEGORIES_TL (
157: CHANNEL_CATEGORY_ID,
158: LAST_UPDATE_DATE,
159: LAST_UPDATED_BY,
160: CREATION_DATE,

Line 182: from AMV_C_CATEGORIES_TL T

178: from FND_LANGUAGES L
179: where L.INSTALLED_FLAG in ('I', 'B')
180: and not exists
181: (select NULL
182: from AMV_C_CATEGORIES_TL T
183: where T.CHANNEL_CATEGORY_ID = X_CHANNEL_CATEGORY_ID
184: and T.LANGUAGE = L.LANGUAGE_CODE);
185:
186: open c;

Line 221: from AMV_C_CATEGORIES_TL

217: cursor c1 is select
218: CHANNEL_CATEGORY_NAME,
219: DESCRIPTION,
220: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
221: from AMV_C_CATEGORIES_TL
222: where CHANNEL_CATEGORY_ID = X_CHANNEL_CATEGORY_ID
223: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
224: for update of CHANNEL_CATEGORY_ID nowait;
225: begin

Line 304: update AMV_C_CATEGORIES_TL set

300: X_LAST_UPDATE_LOGIN in NUMBER
301: ) is
302: begin
303:
304: update AMV_C_CATEGORIES_TL set
305: CHANNEL_CATEGORY_NAME = X_CHANNEL_CATEGORY_NAME,
306: DESCRIPTION = X_DESCRIPTION,
307: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
308: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 348: update AMV_C_CATEGORIES_TL set

344: if (sql%notfound) then
345: raise no_data_found;
346: end if;
347:
348: update AMV_C_CATEGORIES_TL set
349: CHANNEL_CATEGORY_NAME = X_CHANNEL_CATEGORY_NAME,
350: DESCRIPTION = X_DESCRIPTION,
351: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
352: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 367: delete from AMV_C_CATEGORIES_TL

363: procedure DELETE_ROW (
364: X_CHANNEL_CATEGORY_ID in NUMBER
365: ) is
366: begin
367: delete from AMV_C_CATEGORIES_TL
368: where CHANNEL_CATEGORY_ID = X_CHANNEL_CATEGORY_ID;
369:
370: if (sql%notfound) then
371: raise no_data_found;

Line 386: delete from AMV_C_CATEGORIES_TL T

382:
383: procedure ADD_LANGUAGE
384: is
385: begin
386: delete from AMV_C_CATEGORIES_TL T
387: where not exists
388: (select NULL
389: from AMV_C_CATEGORIES_B B
390: where B.CHANNEL_CATEGORY_ID = T.CHANNEL_CATEGORY_ID

Line 393: update AMV_C_CATEGORIES_TL T set (

389: from AMV_C_CATEGORIES_B B
390: where B.CHANNEL_CATEGORY_ID = T.CHANNEL_CATEGORY_ID
391: );
392:
393: update AMV_C_CATEGORIES_TL T set (
394: CHANNEL_CATEGORY_NAME,
395: DESCRIPTION
396: ) = (select
397: B.CHANNEL_CATEGORY_NAME,

Line 399: from AMV_C_CATEGORIES_TL B

395: DESCRIPTION
396: ) = (select
397: B.CHANNEL_CATEGORY_NAME,
398: B.DESCRIPTION
399: from AMV_C_CATEGORIES_TL B
400: where B.CHANNEL_CATEGORY_ID = T.CHANNEL_CATEGORY_ID
401: and B.LANGUAGE = T.SOURCE_LANG)
402: where (
403: T.CHANNEL_CATEGORY_ID,

Line 408: from AMV_C_CATEGORIES_TL SUBB, AMV_C_CATEGORIES_TL SUBT

404: T.LANGUAGE
405: ) in (select
406: SUBT.CHANNEL_CATEGORY_ID,
407: SUBT.LANGUAGE
408: from AMV_C_CATEGORIES_TL SUBB, AMV_C_CATEGORIES_TL SUBT
409: where SUBB.CHANNEL_CATEGORY_ID = SUBT.CHANNEL_CATEGORY_ID
410: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
411: and (SUBB.CHANNEL_CATEGORY_NAME <> SUBT.CHANNEL_CATEGORY_NAME
412: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 417: insert into AMV_C_CATEGORIES_TL (

413: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
414: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
415: ));
416:
417: insert into AMV_C_CATEGORIES_TL (
418: CHANNEL_CATEGORY_ID,
419: LAST_UPDATE_DATE,
420: LAST_UPDATED_BY,
421: CREATION_DATE,

Line 439: from AMV_C_CATEGORIES_TL B, FND_LANGUAGES L

435: B.CHANNEL_CATEGORY_NAME,
436: B.DESCRIPTION,
437: L.LANGUAGE_CODE,
438: B.SOURCE_LANG
439: from AMV_C_CATEGORIES_TL B, FND_LANGUAGES L
440: where L.INSTALLED_FLAG in ('I', 'B')
441: and B.LANGUAGE = userenv('LANG')
442: and not exists
443: (select NULL

Line 444: from AMV_C_CATEGORIES_TL T

440: where L.INSTALLED_FLAG in ('I', 'B')
441: and B.LANGUAGE = userenv('LANG')
442: and not exists
443: (select NULL
444: from AMV_C_CATEGORIES_TL T
445: where T.CHANNEL_CATEGORY_ID = B.CHANNEL_CATEGORY_ID
446: and T.LANGUAGE = L.LANGUAGE_CODE);
447: end ADD_LANGUAGE;
448: