APPS.AMV_C_CHANNELS_PKG dependencies on AMV_C_CHANNELS_TL

Line 188: update AMV_C_CHANNELS_TL set

184: X_DESCRIPTION in VARCHAR2,
185: X_OWNER in VARCHAR2)
186: is
187: begin
188: update AMV_C_CHANNELS_TL set
189: CHANNEL_NAME = x_channel_name,
190: DESCRIPTION = x_description,
191: LAST_UPDATE_DATE = sysdate,
192: LAST_UPDATED_BY = decode(x_owner, 'SEED', 1, 0),

Line 350: insert into AMV_C_CHANNELS_TL (

346: X_LAST_UPDATED_BY,
347: X_LAST_UPDATE_LOGIN
348: );
349:
350: insert into AMV_C_CHANNELS_TL (
351: CHANNEL_ID,
352: LAST_UPDATE_DATE,
353: LAST_UPDATED_BY,
354: CREATION_DATE,

Line 376: from AMV_C_CHANNELS_TL T

372: from FND_LANGUAGES L
373: where L.INSTALLED_FLAG in ('I', 'B')
374: and not exists
375: (select NULL
376: from AMV_C_CHANNELS_TL T
377: where T.CHANNEL_ID = X_CHANNEL_ID
378: and T.LANGUAGE = L.LANGUAGE_CODE);
379:
380: open c;

Line 485: from AMV_C_CHANNELS_TL

481: cursor c1 is select
482: CHANNEL_NAME,
483: DESCRIPTION,
484: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
485: from AMV_C_CHANNELS_TL
486: where CHANNEL_ID = X_CHANNEL_ID
487: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
488: for update of CHANNEL_ID nowait;
489: begin

Line 683: update AMV_C_CHANNELS_TL set

679: if (sql%notfound) then
680: raise no_data_found;
681: end if;
682:
683: update AMV_C_CHANNELS_TL set
684: CHANNEL_NAME = X_CHANNEL_NAME,
685: DESCRIPTION = X_DESCRIPTION,
686: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
687: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 702: delete from AMV_C_CHANNELS_TL

698: procedure DELETE_ROW (
699: X_CHANNEL_ID in NUMBER
700: ) is
701: begin
702: delete from AMV_C_CHANNELS_TL
703: where CHANNEL_ID = X_CHANNEL_ID;
704:
705: if (sql%notfound) then
706: raise no_data_found;

Line 720: delete from AMV_C_CHANNELS_TL T

716:
717: procedure ADD_LANGUAGE
718: is
719: begin
720: delete from AMV_C_CHANNELS_TL T
721: where not exists
722: (select NULL
723: from AMV_C_CHANNELS_B B
724: where B.CHANNEL_ID = T.CHANNEL_ID

Line 727: update AMV_C_CHANNELS_TL T set (

723: from AMV_C_CHANNELS_B B
724: where B.CHANNEL_ID = T.CHANNEL_ID
725: );
726:
727: update AMV_C_CHANNELS_TL T set (
728: CHANNEL_NAME,
729: DESCRIPTION
730: ) = (select
731: B.CHANNEL_NAME,

Line 733: from AMV_C_CHANNELS_TL B

729: DESCRIPTION
730: ) = (select
731: B.CHANNEL_NAME,
732: B.DESCRIPTION
733: from AMV_C_CHANNELS_TL B
734: where B.CHANNEL_ID = T.CHANNEL_ID
735: and B.LANGUAGE = T.SOURCE_LANG)
736: where (
737: T.CHANNEL_ID,

Line 742: from AMV_C_CHANNELS_TL SUBB, AMV_C_CHANNELS_TL SUBT

738: T.LANGUAGE
739: ) in (select
740: SUBT.CHANNEL_ID,
741: SUBT.LANGUAGE
742: from AMV_C_CHANNELS_TL SUBB, AMV_C_CHANNELS_TL SUBT
743: where SUBB.CHANNEL_ID = SUBT.CHANNEL_ID
744: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
745: and (SUBB.CHANNEL_NAME <> SUBT.CHANNEL_NAME
746: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 751: insert into AMV_C_CHANNELS_TL (

747: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
748: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
749: ));
750:
751: insert into AMV_C_CHANNELS_TL (
752: CHANNEL_ID,
753: LAST_UPDATE_DATE,
754: LAST_UPDATED_BY,
755: CREATION_DATE,

Line 773: from AMV_C_CHANNELS_TL B, FND_LANGUAGES L

769: B.CHANNEL_NAME,
770: B.DESCRIPTION,
771: L.LANGUAGE_CODE,
772: B.SOURCE_LANG
773: from AMV_C_CHANNELS_TL B, FND_LANGUAGES L
774: where L.INSTALLED_FLAG in ('I', 'B')
775: and B.LANGUAGE = userenv('LANG')
776: and not exists
777: (select NULL

Line 778: from AMV_C_CHANNELS_TL T

774: where L.INSTALLED_FLAG in ('I', 'B')
775: and B.LANGUAGE = userenv('LANG')
776: and not exists
777: (select NULL
778: from AMV_C_CHANNELS_TL T
779: where T.CHANNEL_ID = B.CHANNEL_ID
780: and T.LANGUAGE = L.LANGUAGE_CODE);
781: end ADD_LANGUAGE;
782: