DBA Data[Home] [Help]

APPS.JTF_IH_PUB dependencies on JTF_IH_REASONS_B

Line 679: FROM jtf_ih_reasons_B

675: l_count := 0;
676: IF ((p_int_val_rec.reason_id IS NOT NULL) AND (p_int_val_rec.reason_id <> fnd_api.g_miss_num)) THEN
677: BEGIN
678: SELECT count(reason_id) into l_count
679: FROM jtf_ih_reasons_B
680: WHERE reason_id = p_int_val_rec.reason_id;
681: IF (l_count <= 0) THEN
682: x_return_status := fnd_api.g_ret_sts_error;
683: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.reason_id),

Line 1068: FROM jtf_ih_reasons_B

1064: l_count := 0;
1065: IF ((p_act_val_rec.reason_id IS NOT NULL) AND (p_act_val_rec.reason_id <> fnd_api.g_miss_num)) THEN
1066: BEGIN
1067: SELECT count(reason_id) into l_count
1068: FROM jtf_ih_reasons_B
1069: WHERE reason_id = p_act_val_rec.reason_id;
1070: IF (l_count <= 0) THEN
1071: x_return_status := fnd_api.g_ret_sts_error;
1072: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.reason_id),