[Home] [Help]
88: END IF;
89: -- If Program Code is specified , it should be in Upper Case.
90: IF p_suarc_dtls_rec.program_cd IS NOT NULL THEN
91: BEGIN
92: igs_en_su_attempt_pkg.check_constraints(
93: column_name => 'COURSE_CD' ,
94: column_value => p_suarc_dtls_rec.program_cd );
95: EXCEPTION
96: WHEN OTHERS THEN
104: END IF;
105: -- If Applied Program Code is specified , it should be in Upper Case.
106: IF p_suarc_dtls_rec.program_cd IS NOT NULL THEN
107: BEGIN
108: igs_en_su_attempt_pkg.check_constraints(
109: column_name => 'COURSE_CD' ,
110: column_value => p_suarc_dtls_rec.applied_program_cd );
111: EXCEPTION
112: WHEN OTHERS THEN
120: END IF;
121: -- If Unit Code is specified , it should be in Upper Case.
122: IF p_suarc_dtls_rec.unit_cd IS NOT NULL THEN
123: BEGIN
124: igs_en_su_attempt_pkg.check_constraints(
125: column_name => 'UNIT_CD' ,
126: column_value => p_suarc_dtls_rec.unit_cd );
127: EXCEPTION
128: WHEN OTHERS THEN
136: END IF;
137: -- If Location Code is specified , it should be in Upper Case.
138: IF p_suarc_dtls_rec.location_cd IS NOT NULL THEN
139: BEGIN
140: igs_en_su_attempt_pkg.check_constraints(
141: column_name => 'LOCATION_CD' ,
142: column_value => p_suarc_dtls_rec.location_cd );
143: EXCEPTION
144: WHEN OTHERS THEN
152: END IF;
153: -- If Unit class is specified , it should be in Upper Case.
154: IF p_suarc_dtls_rec.unit_class IS NOT NULL THEN
155: BEGIN
156: igs_en_su_attempt_pkg.check_constraints(
157: column_name => 'UNIT_CLASS' ,
158: column_value => p_suarc_dtls_rec.unit_class );
159: EXCEPTION
160: WHEN OTHERS THEN
236: g_suarc_status := 'INVALID';
237: END IF;
238:
239: -- Foreign Key Validation - Check if Student Unit Attempt exists.
240: IF NOT igs_en_su_attempt_pkg.get_pk_for_validation (
241: x_person_id => p_person_id,
242: x_course_cd => p_suarc_dtls_rec.program_cd,
243: x_uoo_id => p_uoo_id) THEN
244: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_FI_PRSNID_PRGCD_NOT_MATCH');
294: l_insert_flag BOOLEAN := TRUE;
295: l_suar_id igs_as_sua_ref_cds.suar_id%TYPE;
296: l_person_id igs_pe_person.person_id%TYPE;
297: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
298: l_cal_type igs_en_su_attempt.cal_type%TYPE;
299: l_ci_sequence_number igs_en_su_attempt.ci_Sequence_number%TYPE;
300: l_ci_start_dt igs_ca_inst.start_dt%TYPE;
301: l_ci_end_dt igs_ca_inst.end_dt%TYPE;
302: l_version_number igs_en_su_attempt.version_number%TYPE;
295: l_suar_id igs_as_sua_ref_cds.suar_id%TYPE;
296: l_person_id igs_pe_person.person_id%TYPE;
297: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
298: l_cal_type igs_en_su_attempt.cal_type%TYPE;
299: l_ci_sequence_number igs_en_su_attempt.ci_Sequence_number%TYPE;
300: l_ci_start_dt igs_ca_inst.start_dt%TYPE;
301: l_ci_end_dt igs_ca_inst.end_dt%TYPE;
302: l_version_number igs_en_su_attempt.version_number%TYPE;
303: l_reference_code_id igs_as_sua_ref_cds.reference_code_id%TYPE;
298: l_cal_type igs_en_su_attempt.cal_type%TYPE;
299: l_ci_sequence_number igs_en_su_attempt.ci_Sequence_number%TYPE;
300: l_ci_start_dt igs_ca_inst.start_dt%TYPE;
301: l_ci_end_dt igs_ca_inst.end_dt%TYPE;
302: l_version_number igs_en_su_attempt.version_number%TYPE;
303: l_reference_code_id igs_as_sua_ref_cds.reference_code_id%TYPE;
304: l_reference_cd_type igs_as_sua_ref_cds.reference_cd_type%TYPE;
305: l_reference_cd igs_as_sua_ref_cds.reference_cd%TYPE;
306: l_applied_program_cd igs_as_sua_ref_cds.applied_course_cd%TYPE;
309: l_msg_data VARCHAR2(2000);
310: l_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
311: l_ref_cd_id NUMBER;
312: L_EXISTS VARCHAR2(30);
313: l_sua_status igs_en_su_attempt_all.unit_attempt_status%TYPE;
314:
315: CURSOR cur_sua_status
316: IS
317: SELECT unit_attempt_status
314:
315: CURSOR cur_sua_status
316: IS
317: SELECT unit_attempt_status
318: FROM igs_en_su_attempt_all
319: where person_id = l_person_id
320: AND course_cd =p_suarc_dtls_rec.program_cd
321: AND uoo_id = l_uoo_id ;
322: