APPS.AMS_CAMPAIGN_SCHEDULES_B_PKG dependencies on AMS_CAMPAIGN_SCHEDULES_TL

Line 410: INSERT INTO AMS_CAMPAIGN_SCHEDULES_TL(

406: DECODE( p_sender_display_name, FND_API.g_miss_char,NULL,p_sender_display_name)--anchaudh
407: ,DECODE( p_delivery_mode, FND_API.g_miss_char, NULL, p_delivery_mode)
408: );
409:
410: INSERT INTO AMS_CAMPAIGN_SCHEDULES_TL(
411: schedule_id,
412: language,
413: last_update_date,
414: last_updated_by,

Line 445: FROM ams_campaign_schedules_tl t

441: FROM fnd_languages l
442: WHERE l.installed_flag IN ('I','B')
443: AND NOT EXISTS(
444: SELECT NULL
445: FROM ams_campaign_schedules_tl t
446: WHERE t.schedule_id = DECODE( px_schedule_id, FND_API.g_miss_num, NULL, px_schedule_id)
447: AND t.language = l.language_code ) ;
448:
449:

Line 728: UPDATE ams_campaign_schedules_tl

724: IF (SQL%NOTFOUND) THEN
725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
726: END IF;
727:
728: UPDATE ams_campaign_schedules_tl
729: SET schedule_name = DECODE(p_schedule_name,FND_API.g_miss_char,schedule_name,p_schedule_name),
730: description = DECODE(p_schedule_description,FND_API.g_miss_char,description,p_schedule_description),
731: greeting_text = DECODE(p_greeting_text,FND_API.g_miss_char,greeting_text,p_greeting_text),
732: footer_text = DECODE(p_footer_text,FND_API.g_miss_char,footer_text,p_footer_text),

Line 825: delete from ams_campaign_schedules_tl T

821:
822: procedure ADD_LANGUAGE
823: is
824: begin
825: delete from ams_campaign_schedules_tl T
826: where not exists
827: (select NULL
828: from ams_campaign_schedules_b B
829: where B.schedule_id = T.schedule_ID

Line 832: update ams_campaign_schedules_tl T set (

828: from ams_campaign_schedules_b B
829: where B.schedule_id = T.schedule_ID
830: );
831:
832: update ams_campaign_schedules_tl T set (
833: schedule_name
834: , DESCRIPTION
835: , greeting_text
836: , footer_text

Line 842: from ams_campaign_schedules_tl B

838: B.schedule_name
839: , B.DESCRIPTION
840: , B.greeting_text
841: , B.footer_text
842: from ams_campaign_schedules_tl B
843: where B.schedule_id = T.schedule_id
844: and B.LANGUAGE = T.SOURCE_LANG)
845: where (
846: T.schedule_id,

Line 851: from ams_campaign_schedules_tl SUBB, ams_campaign_schedules_tl SUBT

847: T.LANGUAGE
848: ) in (select
849: SUBT.schedule_id,
850: SUBT.LANGUAGE
851: from ams_campaign_schedules_tl SUBB, ams_campaign_schedules_tl SUBT
852: where SUBB.schedule_id = SUBT.schedule_id
853: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
854: and (SUBB.schedule_name <> SUBT.schedule_name
855: or SUBB.greeting_text <> SUBT.greeting_text

Line 866: insert into ams_campaign_schedules_tl (

862: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
863: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
864: ));
865:
866: insert into ams_campaign_schedules_tl (
867: schedule_id,
868: CREATION_DATE,
869: CREATED_BY,
870: LAST_UPDATE_DATE,

Line 892: from ams_campaign_schedules_tl B, FND_LANGUAGES L

888: B.footer_text,
889: B.DESCRIPTION,
890: L.LANGUAGE_CODE,
891: B.SOURCE_LANG
892: from ams_campaign_schedules_tl B, FND_LANGUAGES L
893: where L.INSTALLED_FLAG in ('I', 'B')
894: and B.LANGUAGE = userenv('LANG')
895: and not exists
896: (select NULL

Line 897: from ams_campaign_schedules_tl T

893: where L.INSTALLED_FLAG in ('I', 'B')
894: and B.LANGUAGE = userenv('LANG')
895: and not exists
896: (select NULL
897: from ams_campaign_schedules_tl T
898: where T.schedule_id = B.schedule_id
899: and T.LANGUAGE = L.LANGUAGE_CODE);
900: end ADD_LANGUAGE;
901: