APPS.IGS_AD_IMP_028 dependencies on IGS_UC_QUAL_DETS

Line 64: l_qual_dets_id igs_uc_qual_dets.qual_dets_id%TYPE;

60: ||
61: */
62:
63: l_rowid VARCHAR2(20);
64: l_qual_dets_id igs_uc_qual_dets.qual_dets_id%TYPE;
65: l_status VARCHAR2(1);
66: l_error_code VARCHAR2(30);
67: l_error_text VARCHAR2(2000);
68: l_interface_qual_id igs_uc_qual_ints.interface_qual_id%TYPE;

Line 102: AND EXISTS ( SELECT 1 FROM IGS_UC_QUAL_DETS

98: ,error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E683', 8405)
99: , status ='3'
100: WHERE STATUS = '2'
101: AND interface_run_id = p_interface_run_id
102: AND EXISTS ( SELECT 1 FROM IGS_UC_QUAL_DETS
103: WHERE person_id = qints.person_id);
104:
105: COMMIT;
106: -- Check for duplicates among interface records. If exists error out all the such records.

Line 155: igs_uc_qual_dets_imp_pkg.validate_pe_qual(uc_qual_rec,l_Status,l_error_Code);

151: invalid_record exception;
152: BEGIN
153: l_error_Code := NULL;
154: l_error_text := NULL;
155: igs_uc_qual_dets_imp_pkg.validate_pe_qual(uc_qual_rec,l_Status,l_error_Code);
156: IF(l_Status ='3' ) THEN
157: RAISE invalid_record;
158: END IF;
159: l_msg_at_index := igs_ge_msg_stack.count_msg;

Line 160: igs_uc_qual_dets_pkg.insert_row(

156: IF(l_Status ='3' ) THEN
157: RAISE invalid_record;
158: END IF;
159: l_msg_at_index := igs_ge_msg_stack.count_msg;
160: igs_uc_qual_dets_pkg.insert_row(
161: x_rowid => l_rowid,
162: x_qual_dets_id => l_qual_dets_id,
163: x_person_id => uc_qual_rec.person_id,
164: x_exam_level => uc_qual_rec.exam_level,