591: l_no_of_records := 0;
592:
593: SELECT count(*)
594: INTO l_no_of_records
595: FROM jty_dea_values_idx_header
596: WHERE source_id = p_source_id
597: AND qual_usg_id = p_qual_usg_id_tbl(i);
598:
599: IF (l_no_of_records = 0) THEN
597: AND qual_usg_id = p_qual_usg_id_tbl(i);
598:
599: IF (l_no_of_records = 0) THEN
600:
601: SELECT jty_dea_values_idx_header_s.nextval
602: INTO l_header_seq
603: FROM dual;
604:
605: INSERT INTO jty_dea_values_idx_header (
601: SELECT jty_dea_values_idx_header_s.nextval
602: INTO l_header_seq
603: FROM dual;
604:
605: INSERT INTO jty_dea_values_idx_header (
606: dea_values_idx_header_id
607: ,source_id
608: ,last_update_date
609: ,last_updated_by