[Home] [Help]
24: --Aiyer 10-Oct-2001 Added the column grading schema code in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.
25: --svenkata 20-Dec-2001 Added the columns student_career_transcript,student_career_statistics in all Tbh calls of
26: -- IGS_EN_SU_ATTEMPT_PKG as a part of the bug # 2158626
27: --vvutukur 7-Jan-2002 Added primary_program_type,key_program as part of cursor c_sca_hist, for SFCR007 Build, bug 2162747
28: --svenkata 7-JAN-2002 Bug No. 2172405 Standard Flex Field columns have been added to table handler procedure calls as part of
29: -- CCR - ENCR022.
30: --Nishikant 30-jan-2002 Added the column session_id in the Tbh calls of IGS_EN_SU_ATTEMPT_PKG
31: -- as a part of the bug 2172380.
32: --Nishikant 15-may-2002 Condition in an IF clause in the function Enrp_Dropall_Unit modified as part of the bug#2364216.
587: AND dt_alias = cp_dt_alias
588: AND alias_val IS NOT NULL
589: ORDER BY alias_val DESC;
590:
591: -- Cursor to check the Non-Standard Unit Section
592: CURSOR cur_non_std_usec_ind(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
593: SELECT non_std_usec_ind FROM IGS_PS_UNIT_OFR_OPT
594: WHERE uoo_id = p_uoo_id;
595:
692: OPEN cur_non_std_usec_ind(p_uoo_id);
693: FETCH cur_non_std_usec_ind INTO l_non_std_usec_ind;
694: CLOSE cur_non_std_usec_ind;
695:
696: -- Check weather the Unit Section is Standard or Non Standard as assign the message accordingly.
697: IF l_non_std_usec_ind = 'Y' THEN
698: p_message_name := 'IGS_EN_SUA_NOTENR_OUTS_REC_NSU';
699: ELSE
700: p_message_name := 'IGS_EN_SUA_NOTENR_OUTS_REC_SU';