eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_WEBMARKETING_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 470: FROM AMS_CAMPAIGN_SCHEDULES_B

466: WHERE CAMPAIGN_ID = l_id;
467:
468: CURSOR c_campaign_schedule_id_exists (l_id IN NUMBER) IS
469: SELECT 1
470: FROM AMS_CAMPAIGN_SCHEDULES_B
471: WHERE SCHEDULE_ID = l_id;
472:
473: BEGIN
474: -- Standard Start of API savepoint

Line 1125: FROM AMS_CAMPAIGN_SCHEDULES_B SCHED, AMS_WEB_PLCE_MP_B MP

1121: l_media_id NUMBER;
1122:
1123: CURSOR c_campaign_activity_id_exists (l_campaign_activity_id IN NUMBER) IS
1124: SELECT sched.schedule_id
1125: FROM AMS_CAMPAIGN_SCHEDULES_B SCHED, AMS_WEB_PLCE_MP_B MP
1126: WHERE SCHED.SCHEDULE_ID = MP.OBJECT_USED_BY_ID AND SCHED.SCHEDULE_ID = L_CAMPAIGN_ACTIVITY_ID;
1127:
1128: CURSOR c_media_id_exists(l_schedule_id IN NUMBER) IS
1129: SELECT activity_id FROM ams_campaign_schedules_b where SCHEDULE_ID=l_schedule_id;

Line 1129: SELECT activity_id FROM ams_campaign_schedules_b where SCHEDULE_ID=l_schedule_id;

1125: FROM AMS_CAMPAIGN_SCHEDULES_B SCHED, AMS_WEB_PLCE_MP_B MP
1126: WHERE SCHED.SCHEDULE_ID = MP.OBJECT_USED_BY_ID AND SCHED.SCHEDULE_ID = L_CAMPAIGN_ACTIVITY_ID;
1127:
1128: CURSOR c_media_id_exists(l_schedule_id IN NUMBER) IS
1129: SELECT activity_id FROM ams_campaign_schedules_b where SCHEDULE_ID=l_schedule_id;
1130:
1131: CURSOR c_content_id_exists(l_campaign_activity_id IN NUMBER) IS
1132: SELECT Assn.content_item_id , Citem.live_citem_version_id
1133: FROM IBC_ASSOCIATIONS Assn, IBC_CONTENT_ITEMS Citem