[Home] [Help]
115: l_d_loan_per_begin_date := p_new_loan_rec.loan_per_begin_date;
116: l_d_loan_per_end_date := p_new_loan_rec.loan_per_end_date;
117:
118: -- get the loan version for the input award id
119: l_n_cl_version := igf_sl_award.get_loan_cl_version(p_n_award_id => l_n_award_id);
120: -- get the processing type code and loan record status for the input loan id
121: OPEN c_igf_sl_lor(cp_n_loan_id => l_n_loan_id);
122: FETCH c_igf_sl_lor INTO rec_c_igf_sl_lor;
123: CLOSE c_igf_sl_lor;
821: -- get the loan version for the input award id
822: l_n_award_id := rec_c_igf_sl_loans.award_id;
823: l_v_loan_number := rec_c_igf_sl_loans.loan_number;
824: l_v_loan_status := rec_c_igf_sl_loans.loan_status;
825: l_n_cl_version := igf_sl_award.get_loan_cl_version(p_n_award_id => l_n_award_id);
826: l_v_prc_type_code := p_new_lor_rec.prc_type_code;
827: l_c_cl_rec_status := p_new_lor_rec.cl_rec_status;
828: l_d_lor_anticip_compl_dt := p_new_lor_rec.anticip_compl_date;
829: --bvisvana #bug 5091388 if override grade level is null then take grade level ride
1538: l_v_prc_type_code := rec_c_igf_sl_lorlar.prc_type_code;
1539: l_c_cl_rec_status := rec_c_igf_sl_lorlar.cl_rec_status;
1540:
1541: -- get the loan version for the input award id
1542: l_n_cl_version := igf_sl_award.get_loan_cl_version(p_n_award_id => l_n_award_id);
1543:
1544:
1545: -- if any of the disbursements pertaining to the award id is funded, then
1546: -- loan cancellation record would not be created.
2955: l_v_prc_type_code := rec_c_igf_sl_lorlar.prc_type_code;
2956: l_c_cl_rec_status := rec_c_igf_sl_lorlar.cl_rec_status;
2957:
2958: -- get the loan version for the input award id
2959: l_n_cl_version := igf_sl_award.get_loan_cl_version(p_n_award_id => l_n_award_id);
2960:
2961: -- get the latest Guaranteed Response for the required fields
2962: -- if no records are found change record would not be created. The control is returned back
2963: -- to the calling program.