128: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
129: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
130:
131: PROCEDURE log_input_params( p_batch_num IN igf_aw_li_coa_ints.batch_num%TYPE ,
132: p_alternate_code IN igs_ca_inst.alternate_code%TYPE ,
133: p_delete_flag IN VARCHAR2)
134: IS
135: /*
136: || Created By : rasahoo
3149: l_num_of_disb_rec NUMBER := 0;
3150: lb_write_log BOOLEAN := FALSE;
3151: l_loan_id_msg VARCHAR(10);
3152: -- cursor to get alternate code for award year
3153: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
3154: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
3155: SELECT alternate_code
3156: FROM igs_ca_inst
3157: WHERE cal_type = cp_ci_cal_type
3150: lb_write_log BOOLEAN := FALSE;
3151: l_loan_id_msg VARCHAR(10);
3152: -- cursor to get alternate code for award year
3153: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
3154: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
3155: SELECT alternate_code
3156: FROM igs_ca_inst
3157: WHERE cal_type = cp_ci_cal_type
3158: AND sequence_number = cp_ci_sequence_number ;
3152: -- cursor to get alternate code for award year
3153: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
3154: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
3155: SELECT alternate_code
3156: FROM igs_ca_inst
3157: WHERE cal_type = cp_ci_cal_type
3158: AND sequence_number = cp_ci_sequence_number ;
3159:
3160: l_alternate_code igs_ca_inst.alternate_code%TYPE ;
3156: FROM igs_ca_inst
3157: WHERE cal_type = cp_ci_cal_type
3158: AND sequence_number = cp_ci_sequence_number ;
3159:
3160: l_alternate_code igs_ca_inst.alternate_code%TYPE ;
3161:
3162: CURSOR c_award_year (cp_cal_type VARCHAR2,
3163: cp_seq_num NUMBER)
3164: IS