DBA Data[Home] [Help]

APPS.JTF_IH_PUB_PS dependencies on JTF_IH_RESULTS_B

Line 140: FROM jtf_ih_results_B

136: l_count := 0;
137: IF ((p_int_val_rec.result_id IS NOT NULL) AND (p_int_val_rec.result_id <> fnd_api.g_miss_num)) THEN
138: BEGIN
139: SELECT count(*) into l_count
140: FROM jtf_ih_results_B
141: WHERE result_id = p_int_val_rec.result_id;
142: IF (l_count <= 0) THEN
143: x_return_status := fnd_api.g_ret_sts_error;
144: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.result_id),

Line 459: FROM jtf_ih_results_B

455: l_count := 0;
456: IF ((p_act_val_rec.result_id IS NOT NULL) AND (p_act_val_rec.result_id <> fnd_api.g_miss_num)) THEN
457: BEGIN
458: SELECT count(*) into l_count
459: FROM jtf_ih_results_B
460: WHERE result_id = p_act_val_rec.result_id;
461: IF (l_count <= 0) THEN
462: x_return_status := fnd_api.g_ret_sts_error;
463: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.result_id),