[Home] [Help]
899: l_person_id igs_pe_person.person_id%TYPE;
900: l_course_type igs_ps_ver_all.course_type%TYPE;
901: l_coo_id igs_ps_ofr_opt_all.coo_id%TYPE;
902: l_course_att_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE;
903: l_igs_pr_class_std_id igs_en_stdnt_ps_att_all.igs_pr_class_std_id%TYPE;
904: l_catalog_cal_type igs_en_stdnt_ps_att_all.catalog_cal_type%TYPE;
905: l_catalog_seq_num igs_en_stdnt_ps_att_all.catalog_seq_num%TYPE;
906: l_dropped_by igs_en_stdnt_ps_att_all.dropped_by%TYPE;
907: l_catalog_start_dt DATE;
1045: l_err_flag := 'Y';
1046: END IF;
1047: --deriving the class standing identifier.
1048: IF l_sca_re_rec.class_standing_override IS NOT NULL THEN
1049: l_igs_pr_class_std_id:=igs_en_gen_legacy.get_class_std_id(p_class_standing =>l_sca_re_rec.class_standing_override );
1050: IF l_igs_pr_class_std_id IS NULL THEN
1051: FND_MESSAGE.SET_NAME('IGS','IGS_EN_CLASS_STD_ID_NOT_FOUND');
1052: FND_MSG_PUB.ADD;
1053: l_err_flag := 'Y';
1046: END IF;
1047: --deriving the class standing identifier.
1048: IF l_sca_re_rec.class_standing_override IS NOT NULL THEN
1049: l_igs_pr_class_std_id:=igs_en_gen_legacy.get_class_std_id(p_class_standing =>l_sca_re_rec.class_standing_override );
1050: IF l_igs_pr_class_std_id IS NULL THEN
1051: FND_MESSAGE.SET_NAME('IGS','IGS_EN_CLASS_STD_ID_NOT_FOUND');
1052: FND_MSG_PUB.ADD;
1053: l_err_flag := 'Y';
1054: END IF;
1146: logical_delete_dt,
1147: adm_admission_appl_number,
1148: adm_nominated_course_cd,
1149: adm_sequence_number,
1150: igs_pr_class_std_id,
1151: last_date_of_attendance,
1152: dropped_by,
1153: primary_program_type,
1154: primary_prog_type_source,
1228: NULL,
1229: l_sca_re_rec.adm_admission_appl_number,
1230: l_sca_re_rec.adm_nominated_course_cd,
1231: l_sca_re_rec.adm_sequence_number,
1232: l_igs_pr_class_std_id,
1233: NULL,
1234: l_dropped_by,
1235: l_sca_re_rec.primary_program_type,
1236: l_sca_re_rec.primary_prog_type_source,