[Home] [Help]
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
5260: FROM dual;
5261:
5262: CURSOR c_activities_id IS
5263: SELECT JTF_IH_ACTIVITIES_S1.NEXTVAL
5356: -- populate interaction record
5357: /*OPEN c_interactions_id;
5358: FETCH c_interactions_id INTO l_interaction_id ;
5359: CLOSE c_interactions_id;*/
5360: -- l_interaction_id := jtf_ih_interactions_s1.nextval ;
5361:
5362: --l_interaction_rec.interaction_id := l_interaction_id ;
5363: l_interaction_rec.end_date_time := l_end_time ;
5364: l_interaction_rec.start_date_time := l_start_time ;