352: l_person_id igs_pe_person.person_id%TYPE;
353: l_person_type igs_pe_person_types.person_type_code%TYPE;
354: l_cal_type igs_ca_inst.cal_type%TYPE;
355: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
356: l_program_cd igs_en_su_attempt_all.course_cd%TYPE;
357: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;
358: l_primary_version igs_en_su_attempt_all.version_number%TYPE;
359: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
360: l_messaage_count NUMBER(15);
353: l_person_type igs_pe_person_types.person_type_code%TYPE;
354: l_cal_type igs_ca_inst.cal_type%TYPE;
355: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
356: l_program_cd igs_en_su_attempt_all.course_cd%TYPE;
357: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;
358: l_primary_version igs_en_su_attempt_all.version_number%TYPE;
359: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
360: l_messaage_count NUMBER(15);
361: l_error_message VARCHAR2(1000);
354: l_cal_type igs_ca_inst.cal_type%TYPE;
355: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
356: l_program_cd igs_en_su_attempt_all.course_cd%TYPE;
357: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;
358: l_primary_version igs_en_su_attempt_all.version_number%TYPE;
359: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
360: l_messaage_count NUMBER(15);
361: l_error_message VARCHAR2(1000);
362: l_return_stat VARCHAR2(10);