APPS.AMS_EVTREGS_PVT dependencies on JTF_IH_MEDIA_ITEMS_S1

Line 5240: SELECT JTF_IH_MEDIA_ITEMS_S1.NEXTVAL

5236: FROM ams_event_offers_all_b
5237: WHERE event_offer_id = p_event_offer_id;
5238:
5239: CURSOR c_media_item_id IS
5240: SELECT JTF_IH_MEDIA_ITEMS_S1.NEXTVAL
5241: FROM dual;
5242:
5243: CURSOR c_interactions_id IS
5244: SELECT jtf_ih_interactions_s1.NEXTVAL

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

5291: -- populate media_rec
5292: OPEN c_media_item_id;
5293: FETCH c_media_item_id INTO l_media_rec.media_id ;
5294: CLOSE c_media_item_id;
5295: -- l_media_rec.media_id := JTF_IH_MEDIA_ITEMS_S1.nextval;
5296: l_media_rec.end_date_time := SYSDATE ; -- l_end_time ; Modified by ptendulk
5297: l_media_rec.start_date_time := SYSDATE ; -- l_start_time ; Modified by ptendulk
5298: l_media_rec.media_item_type := 'MAIL' ;
5299: