DBA Data[Home] [Help]

APPS.JTF_IH_PUB_PS dependencies on AMS_SOURCE_CODES

Line 190: FROM ams_source_codes

186: l_count := 0;
187: IF ((p_int_val_rec.source_code_id IS NOT NULL) AND (p_int_val_rec.source_code_id <> fnd_api.g_miss_num)) THEN
188: BEGIN
189: SELECT count(*) into l_count
190: FROM ams_source_codes
191: WHERE source_code_id = p_int_val_rec.source_code_id;
192: IF (l_count <= 0) THEN
193: x_return_status := fnd_api.g_ret_sts_error;
194: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.source_code_id),

Line 493: FROM ams_source_codes

489: l_count := 0;
490: IF ((p_act_val_rec.source_code_id IS NOT NULL) AND (p_act_val_rec.source_code_id <> fnd_api.g_miss_num)) THEN
491: BEGIN
492: SELECT count(*) into l_count
493: FROM ams_source_codes
494: WHERE source_code_id = p_act_val_rec.source_code_id;
495: IF (l_count <= 0) THEN
496: x_return_status := fnd_api.g_ret_sts_error;
497: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.source_code_id),