DBA Data[Home] [Help]

APPS.JTF_IH_PVT dependencies on DUAL

Line 35: SELECT jtf.jtf_ih_media_items_s1.NEXTVAL INTO l_media.media_id FROM dual;

31:
32: -- Initialize API return status to success
33: x_return_status := fnd_api.g_ret_sts_success;
34:
35: SELECT jtf.jtf_ih_media_items_s1.NEXTVAL INTO l_media.media_id FROM dual;
36:
37: JTF_IH_PUB.Create_MediaItem(1.0,'T','T',p_resp_appl_id,p_resp_id,p_user_id,p_login_id,
38: l_return_status,
39: l_msg_count,

Line 46: SELECT jtf.jtf_ih_interactions_s1.NEXTVAL INTO l_interaction_rec.interaction_id FROM dual;

42: p_mlcs
43: );
44:
45:
46: SELECT jtf.jtf_ih_interactions_s1.NEXTVAL INTO l_interaction_rec.interaction_id FROM dual;
47:
48: for idx in 1 .. l_activities.count loop
49: l_activities(idx).media_id := l_media.media_id;
50: end loop;