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
5245: FROM dual;
5246:
5247: CURSOR c_activities_id IS
5248: SELECT JTF_IH_ACTIVITIES_S1.NEXTVAL
5341: -- populate interaction record
5342: /*OPEN c_interactions_id;
5343: FETCH c_interactions_id INTO l_interaction_id ;
5344: CLOSE c_interactions_id;*/
5345: -- l_interaction_id := jtf_ih_interactions_s1.nextval ;
5346:
5347: --l_interaction_rec.interaction_id := l_interaction_id ;
5348: l_interaction_rec.end_date_time := l_end_time ;
5349: l_interaction_rec.start_date_time := l_start_time ;