APPS.AMS_CAMPAIGN_PVT dependencies on AMS_CAMPAIGNS_ALL_TL

Line 507: INSERT INTO ams_campaigns_all_tl(

503: l_camp_rec.program_attribute14,
504: l_camp_rec.program_attribute15
505: );
506:
507: INSERT INTO ams_campaigns_all_tl(
508: campaign_id,
509: language,
510: last_update_date,
511: last_updated_by,

Line 536: FROM ams_campaigns_all_tl t

532: FROM fnd_languages l
533: WHERE l.installed_flag in ('I', 'B')
534: AND NOT EXISTS(
535: SELECT NULL
536: FROM ams_campaigns_all_tl t
537: WHERE t.campaign_id = l_camp_rec.campaign_id
538: AND t.language = l.language_code );
539:
540:

Line 919: FROM ams_campaigns_all_tl

915: FOR UPDATE NOWAIT;
916:
917: CURSOR c_camp_tl IS
918: SELECT campaign_id
919: FROM ams_campaigns_all_tl
920: WHERE campaign_id = p_camp_id
921: AND USERENV('LANG') IN (language, source_lang)
922: FOR UPDATE NOWAIT;
923:

Line 1456: UPDATE ams_campaigns_all_tl SET

1452: END IF;
1453: RAISE FND_API.g_exc_error;
1454: END IF;
1455:
1456: UPDATE ams_campaigns_all_tl SET
1457: campaign_name = l_camp_rec.campaign_name,
1458: campaign_theme = l_camp_rec.campaign_theme,
1459: description = l_camp_rec.description,
1460: last_update_date = SYSDATE,