APPS.AMS_CAMPAIGNS_ALL_PKG dependencies on AMS_CAMPAIGNS_ALL_TL

Line 260: insert into AMS_CAMPAIGNS_ALL_TL (

256: X_LAST_UPDATED_BY,
257: X_LAST_UPDATE_LOGIN
258: );
259:
260: insert into AMS_CAMPAIGNS_ALL_TL (
261: CAMPAIGN_ID,
262: CREATION_DATE,
263: CREATED_BY,
264: LAST_UPDATE_DATE,

Line 288: from AMS_CAMPAIGNS_ALL_TL T

284: from FND_LANGUAGES L
285: where L.INSTALLED_FLAG in ('I', 'B')
286: and not exists
287: (select NULL
288: from AMS_CAMPAIGNS_ALL_TL T
289: where T.CAMPAIGN_ID = X_CAMPAIGN_ID
290: and T.LANGUAGE = L.LANGUAGE_CODE);
291:
292: open c;

Line 469: from AMS_CAMPAIGNS_ALL_TL

465: CAMPAIGN_NAME,
466: CAMPAIGN_THEME,
467: DESCRIPTION,
468: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
469: from AMS_CAMPAIGNS_ALL_TL
470: where CAMPAIGN_ID = X_CAMPAIGN_ID
471: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
472: for update of CAMPAIGN_ID nowait;
473: begin

Line 814: update AMS_CAMPAIGNS_ALL_TL set

810: if (sql%notfound) then
811: raise no_data_found;
812: end if;
813:
814: update AMS_CAMPAIGNS_ALL_TL set
815: CAMPAIGN_NAME = X_CAMPAIGN_NAME,
816: CAMPAIGN_THEME = X_CAMPAIGN_THEME,
817: DESCRIPTION = X_DESCRIPTION,
818: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 834: delete from AMS_CAMPAIGNS_ALL_TL

830: procedure DELETE_ROW (
831: X_CAMPAIGN_ID in NUMBER
832: ) is
833: begin
834: delete from AMS_CAMPAIGNS_ALL_TL
835: where CAMPAIGN_ID = X_CAMPAIGN_ID;
836:
837: if (sql%notfound) then
838: raise no_data_found;

Line 852: delete from AMS_CAMPAIGNS_ALL_TL T

848:
849: procedure ADD_LANGUAGE
850: is
851: begin
852: delete from AMS_CAMPAIGNS_ALL_TL T
853: where not exists
854: (select NULL
855: from AMS_CAMPAIGNS_ALL_B B
856: where B.CAMPAIGN_ID = T.CAMPAIGN_ID

Line 859: update AMS_CAMPAIGNS_ALL_TL T set (

855: from AMS_CAMPAIGNS_ALL_B B
856: where B.CAMPAIGN_ID = T.CAMPAIGN_ID
857: );
858:
859: update AMS_CAMPAIGNS_ALL_TL T set (
860: CAMPAIGN_NAME,
861: CAMPAIGN_THEME,
862: DESCRIPTION
863: ) = (select

Line 867: from AMS_CAMPAIGNS_ALL_TL B

863: ) = (select
864: B.CAMPAIGN_NAME,
865: B.CAMPAIGN_THEME,
866: B.DESCRIPTION
867: from AMS_CAMPAIGNS_ALL_TL B
868: where B.CAMPAIGN_ID = T.CAMPAIGN_ID
869: and B.LANGUAGE = T.SOURCE_LANG)
870: where (
871: T.CAMPAIGN_ID,

Line 876: from AMS_CAMPAIGNS_ALL_TL SUBB, AMS_CAMPAIGNS_ALL_TL SUBT

872: T.LANGUAGE
873: ) in (select
874: SUBT.CAMPAIGN_ID,
875: SUBT.LANGUAGE
876: from AMS_CAMPAIGNS_ALL_TL SUBB, AMS_CAMPAIGNS_ALL_TL SUBT
877: where SUBB.CAMPAIGN_ID = SUBT.CAMPAIGN_ID
878: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
879: and (SUBB.CAMPAIGN_NAME <> SUBT.CAMPAIGN_NAME
880: or SUBB.CAMPAIGN_THEME <> SUBT.CAMPAIGN_THEME

Line 888: insert into AMS_CAMPAIGNS_ALL_TL (

884: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
885: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
886: ));
887:
888: insert into AMS_CAMPAIGNS_ALL_TL (
889: CAMPAIGN_ID,
890: CREATION_DATE,
891: CREATED_BY,
892: LAST_UPDATE_DATE,

Line 912: from AMS_CAMPAIGNS_ALL_TL B, FND_LANGUAGES L

908: B.CAMPAIGN_THEME,
909: B.DESCRIPTION,
910: L.LANGUAGE_CODE,
911: B.SOURCE_LANG
912: from AMS_CAMPAIGNS_ALL_TL B, FND_LANGUAGES L
913: where L.INSTALLED_FLAG in ('I', 'B')
914: and B.LANGUAGE = userenv('LANG')
915: and not exists
916: (select NULL

Line 917: from AMS_CAMPAIGNS_ALL_TL T

913: where L.INSTALLED_FLAG in ('I', 'B')
914: and B.LANGUAGE = userenv('LANG')
915: and not exists
916: (select NULL
917: from AMS_CAMPAIGNS_ALL_TL T
918: where T.CAMPAIGN_ID = B.CAMPAIGN_ID
919: and T.LANGUAGE = L.LANGUAGE_CODE);
920: end ADD_LANGUAGE;
921:

Line 931: update AMS_CAMPAIGNS_ALL_TL set

927: X_OWNER in VARCHAR2
928: )
929: IS
930: BEGIN
931: update AMS_CAMPAIGNS_ALL_TL set
932: campaign_name = nvl(x_campaign_name, campaign_name),
933: campaign_theme = nvl(x_campaign_theme, campaign_theme),
934: description = nvl(x_description, description),
935: source_lang = userenv('LANG'),