DBA Data[Home] [Help]

APPS.AMS_SCHEDULERULES_PVT dependencies on JTF_IH_MEDIA_ITEMS_S1

Line 2713: SELECT JTF_IH_MEDIA_ITEMS_S1.NEXTVAL

2709: FROM ams_campaign_schedules_b
2710: WHERE schedule_id = p_schedule_id;
2711:
2712: CURSOR c_media_item_id IS
2713: SELECT JTF_IH_MEDIA_ITEMS_S1.NEXTVAL
2714: FROM dual;
2715:
2716: CURSOR c_interactions_id IS
2717: SELECT jtf_ih_interactions_s1.NEXTVAL

Line 2753: -- l_media_rec.media_id := JTF_IH_MEDIA_ITEMS_S1.nextval;

2749: -- populate media_rec
2750: OPEN c_media_item_id;
2751: FETCH c_media_item_id INTO l_media_rec.media_id ;
2752: CLOSE c_media_item_id;
2753: -- l_media_rec.media_id := JTF_IH_MEDIA_ITEMS_S1.nextval;
2754: l_media_rec.end_date_time := l_schedule_end_time ;
2755: l_media_rec.start_date_time := l_schedule_start_time ;
2756: l_media_rec.media_item_type := 'MAIL' ;
2757: