APPS.JTF_IH_PUB dependencies on JTF_IH_ACTIVITIES_S1

Line 1522: SELECT jtf_ih_activities_s1.NEXTVAL INTO n_Return FROM dual;

1518: RETURN n_activity_id;
1519: END;
1520: ELSIF ((n_activity_id IS NULL) OR (n_activity_id = fnd_api.g_miss_num)) THEN
1521: LOOP
1522: SELECT jtf_ih_activities_s1.NEXTVAL INTO n_Return FROM dual;
1523: BEGIN
1524: SELECT activity_id INTO n_Dummy FROM jtf_ih_activities WHERE activity_id = n_Return;
1525: EXCEPTION
1526: WHEN NO_DATA_FOUND THEN

Line 3079: -- SELECT jtf_ih_activities_s1.NEXTVAL INTO l_activities(idx).activity_id FROM dual;

3075:
3076: for idx in 1 .. p_activities.count loop
3077: --Bug# 2817083
3078: --IF ((p_activities(idx).activity_id IS NULL) OR (p_activities(idx).activity_id = fnd_api.g_miss_num)) THEN
3079: -- SELECT jtf_ih_activities_s1.NEXTVAL INTO l_activities(idx).activity_id FROM dual;
3080: --END IF;
3081:
3082: -- Bug# 2323210
3083: if(p_activities(idx).start_date_time <> fnd_api.g_miss_date) AND (p_activities(idx).start_date_time IS NOT NULL) then

Line 5962: --SELECT JTF_IH_ACTIVITIES_S1.NextVal into l_activity_id FROM dual;

5958:
5959: -- Bug 2817083
5960: --l_activity_id := Get_Activity_ID(NULL);
5961: l_activity_rec.activity_id := Get_Activity_ID(NULL);
5962: --SELECT JTF_IH_ACTIVITIES_S1.NextVal into l_activity_id FROM dual;
5963:
5964: validate_source_code(l_api_name_full, l_activity_rec.source_code_id, l_activity_rec.source_code, x_return_status);
5965: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
5966: RAISE fnd_api.g_exc_error;