APPS.AMS_EVTREGS_PVT dependencies on JTF_IH_MEDIA_ITEMS_S1

Line 5255: SELECT JTF_IH_MEDIA_ITEMS_S1.NEXTVAL

5251: FROM ams_event_offers_all_b
5252: WHERE event_offer_id = p_event_offer_id;
5253:
5254: CURSOR c_media_item_id IS
5255: SELECT JTF_IH_MEDIA_ITEMS_S1.NEXTVAL
5256: FROM dual;
5257:
5258: CURSOR c_interactions_id IS
5259: SELECT jtf_ih_interactions_s1.NEXTVAL

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

5306: -- populate media_rec
5307: OPEN c_media_item_id;
5308: FETCH c_media_item_id INTO l_media_rec.media_id ;
5309: CLOSE c_media_item_id;
5310: -- l_media_rec.media_id := JTF_IH_MEDIA_ITEMS_S1.nextval;
5311: l_media_rec.end_date_time := SYSDATE ; -- l_end_time ; Modified by ptendulk
5312: l_media_rec.start_date_time := SYSDATE ; -- l_start_time ; Modified by ptendulk
5313: l_media_rec.media_item_type := 'MAIL' ;
5314: