[Home] [Help]
24:
25: -- veramach 04-May-2004 bug 3603289
26: -- Modified cursor cur_student_licence to select
27: -- dependency_status from ISIR. other details are
28: -- derived from igf_sl_gen.get_person_details.
29: -----------------------------------------------------------------------------------
30: -- ugummall 29-OCT-2003 Bug 3102439. FA 126 - Multiple FA Offices.
31: -- 1. Added two new parameters p_school_id and p_base_id to cl_lar_validate function.
32: -- 2. Changed the cursor cur_lor_details_recs to select only those records related to
35: -- 3. Changed the cursor cur_school_id to fetch only one attribute eft_authorization.
36: -- 4. p_school_id is used instead of lv_school_id(fetched from cur_school_id)
37: -- veramach 19-SEP-2003 FA 122 Loan Enhancements Build
38: -- 1. changed cursor cur_lor_details_recs not to select student/borrower information.
39: -- This is derived from igf_sl_gen.get_person_details
40: ----------------------------------------------------------------------------------
41: -- gmuralid 03-07-2003 Bug 2995944 - Legacy Part 3 - FFELP Import
42: -- Added legacy record flag as parameter to
43: -- igf_sl_loans_pkg
190:
191: Change History :
192: FA 122 Loan Enhancements Build
193: changed cursor cur_lor_details_recs not to select student/borrower information.
194: This is derived from igf_sl_gen.get_person_details
195:
196: Bug No: 2400487 Desc : FFELP Validation and Origination Issues.
197: Who When What
198: rajagupt 10-Apr-2006 Bug 5006587 . Removed validations (set_complete_status()) for the following field names
235: ln_disb_ind_count NUMBER(2);
236: ln_disb_dates_count NUMBER(2);
237: l_phone VARCHAR2(100);
238:
239: student_dtl_rec igf_sl_gen.person_dtl_rec;
240: student_dtl_cur igf_sl_gen.person_dtl_cur;
241:
242: parent_dtl_rec igf_sl_gen.person_dtl_rec;
243: parent_dtl_cur igf_sl_gen.person_dtl_cur;
236: ln_disb_dates_count NUMBER(2);
237: l_phone VARCHAR2(100);
238:
239: student_dtl_rec igf_sl_gen.person_dtl_rec;
240: student_dtl_cur igf_sl_gen.person_dtl_cur;
241:
242: parent_dtl_rec igf_sl_gen.person_dtl_rec;
243: parent_dtl_cur igf_sl_gen.person_dtl_cur;
244:
238:
239: student_dtl_rec igf_sl_gen.person_dtl_rec;
240: student_dtl_cur igf_sl_gen.person_dtl_cur;
241:
242: parent_dtl_rec igf_sl_gen.person_dtl_rec;
243: parent_dtl_cur igf_sl_gen.person_dtl_cur;
244:
245: l_n_coa igf_ap_fa_base_rec_all.coa_f%TYPE;
246: l_n_efc igf_ap_fa_base_rec_all.efc_f%TYPE;
239: student_dtl_rec igf_sl_gen.person_dtl_rec;
240: student_dtl_cur igf_sl_gen.person_dtl_cur;
241:
242: parent_dtl_rec igf_sl_gen.person_dtl_rec;
243: parent_dtl_cur igf_sl_gen.person_dtl_cur;
244:
245: l_n_coa igf_ap_fa_base_rec_all.coa_f%TYPE;
246: l_n_efc igf_ap_fa_base_rec_all.efc_f%TYPE;
247: l_n_pell_efc NUMBER;
720: BEGIN
721: -- Get CommonLine Version for this Award Year.
722: -- museshad(Bug# 4346258) - Added the parameter p_base_id due to change in the
723: -- signature of the function 'get_cl_version()'
724: p_cl_version := igf_sl_gen.get_cl_version(p_ci_cal_type, p_ci_sequence_number,lor_rec.relationship_cd,p_base_id);
725:
726: EXCEPTION
727: WHEN NO_DATA_FOUND THEN
728: fnd_message.set_name('IGF','IGF_SL_NO_CL_SETUP');
804: END IF;
805:
806: END IF;
807:
808: igf_sl_gen.get_person_details(lor_rec.student_id,student_dtl_cur);
809: FETCH student_dtl_cur INTO student_dtl_rec;
810: igf_sl_gen.get_person_details(lor_rec.p_person_id,parent_dtl_cur);
811: FETCH parent_dtl_cur INTO parent_dtl_rec;
812:
806: END IF;
807:
808: igf_sl_gen.get_person_details(lor_rec.student_id,student_dtl_cur);
809: FETCH student_dtl_cur INTO student_dtl_rec;
810: igf_sl_gen.get_person_details(lor_rec.p_person_id,parent_dtl_cur);
811: FETCH parent_dtl_cur INTO parent_dtl_rec;
812:
813: --FA 161 - Due to the introduction of a new mapping form, we don't use the lookup tag but rather require the lookup_code itself to
814: --determine the mapping values...and hence the below blocks of citizenship_dtl_cur
832:
833: -- For each of the LOR records check if the Required Fields are not null
834:
835: IF p_loan_catg = 'CL_STAFFORD' THEN
836: l_phone := igf_sl_gen.get_person_phone( lor_rec.student_id );
837:
838: -- Following are the checks for Common Line Loan Stafford.
839:
840: set_complete_status(check_for_reqd(lor_rec.loan_number,p_loan_catg,'S_SSN',
931: END IF;
932:
933:
934: ELSIF p_loan_catg IN ('CL_PLUS','CL_GPLUSFL') THEN
935: l_phone := igf_sl_gen.get_person_phone( lor_rec.p_person_id );
936: -- Following are the checks for Common Line Loan PLUS and Grad Plus Loan.
937:
938: set_complete_status(check_for_reqd(lor_rec.loan_number,p_loan_catg,'P_SSN',
939: parent_dtl_rec.p_ssn,lor_rec.prc_type_code));
1105: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '001', 'P_SSN', NULL);
1106: END IF;
1107: END IF;
1108: ELSIF p_loan_catg = 'CL_ALT' THEN
1109: l_phone := igf_sl_gen.get_person_phone( lor_rec.p_person_id );
1110:
1111: -- Following are the checks for Common Line Loan ALTERNATE.
1112: log_to_fnd('cl_lar_validate','debug','----P_LAST_NAME----');
1113: set_complete_status(check_for_reqd(lor_rec.loan_number,p_loan_catg,'P_LAST_NAME',