APPS.JTF_IH_PUB dependencies on JTF_IH_INTERACTIONS_S1

Line 1565: SELECT jtf_ih_interactions_s1.NEXTVAL INTO n_Return FROM dual;

1561: RETURN n_interaction_id;
1562: END;
1563: ELSIF ((n_interaction_id IS NULL) OR (n_interaction_id = fnd_api.g_miss_num)) THEN
1564: LOOP
1565: SELECT jtf_ih_interactions_s1.NEXTVAL INTO n_Return FROM dual;
1566: BEGIN
1567: SELECT interaction_id INTO n_Dummy FROM jtf_ih_interactions WHERE interaction_id = n_Return;
1568: EXCEPTION
1569: WHEN NO_DATA_FOUND THEN

Line 2925: -- SELECT jtf_ih_interactions_s1.NEXTVAL INTO l_int_val_rec.interaction_id FROM dual;

2921: END IF;
2922:
2923: -- Bug# 2817083
2924: --IF ((p_interaction_rec.interaction_id IS NULL) OR (p_interaction_rec.interaction_id = fnd_api.g_miss_num)) THEN
2925: -- SELECT jtf_ih_interactions_s1.NEXTVAL INTO l_int_val_rec.interaction_id FROM dual;
2926: --END IF;
2927: l_int_val_rec.interaction_id := Get_Interaction_ID(p_interaction_rec.interaction_id);
2928: IF l_int_val_rec.interaction_id = -1 THEN
2929: RAISE fnd_api.g_exc_error;

Line 4143: --SELECT JTF_IH_INTERACTIONS_S1.NextVal into l_interaction_id FROM dual;

4139: END IF;
4140: END IF;
4141: --l_test_msg := '5';
4142:
4143: --SELECT JTF_IH_INTERACTIONS_S1.NextVal into l_interaction_id FROM dual;
4144: --l_test_msg := '6';
4145:
4146: -- Bug# 2817083
4147: --l_interaction_id := Get_Interaction_ID(NULL);