[Home] [Help]
97:
98: (reverse chronological order - newest change first)
99: ***************************************************************/
100:
101: lv_cal_type igs_ca_inst.cal_type%TYPE; -- ## Used for the award year ##
102: lv_cal_seq_num igs_ca_inst.sequence_number%TYPE; -- ## Both cal_seq_num and cal_type forms the award year ##
103: lv_dl_version igf_lookups_view.lookup_code%TYPE; -- ## Variable for the storing the version number ##
104: lv_batch_id igf_sl_dl_batch.batch_id%TYPE; -- ## Variable to have the batch ID ##
105: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
98: (reverse chronological order - newest change first)
99: ***************************************************************/
100:
101: lv_cal_type igs_ca_inst.cal_type%TYPE; -- ## Used for the award year ##
102: lv_cal_seq_num igs_ca_inst.sequence_number%TYPE; -- ## Both cal_seq_num and cal_type forms the award year ##
103: lv_dl_version igf_lookups_view.lookup_code%TYPE; -- ## Variable for the storing the version number ##
104: lv_batch_id igf_sl_dl_batch.batch_id%TYPE; -- ## Variable to have the batch ID ##
105: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
106: lv_mesg_class igf_sl_dl_batch.message_class%TYPE;
108: lv_end_date igf_sl_lor_loc.acad_yr_end_date%TYPE; -- ## Variable to have the academic end date ##
109:
110: --Bug No:2332668
111: l_i NUMBER(1);
112: l_alternate_code igs_ca_inst.alternate_code%TYPE;
113: l_display VARCHAR2(1) := 'N';
114:
115: TYPE l_parameters IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
116: l_para_rec l_parameters;
152: -- ## Cursor to Retrieve the active direct loan records with change status as Send from the igf_sl_lor table
153: -- ## for the particular award Year
154: -- FA 122 Loans Enhancemnts changed the cursor to remove the obsolete view igf_sl_lor_dtls_v
155: CURSOR c_lor(
156: p_cal_type igs_ca_inst.cal_type%TYPE,
157: p_seq_num igs_ca_inst.sequence_number%TYPE,
158: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
159: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
160: p_loan_status igf_sl_loans.loan_status%TYPE,
153: -- ## for the particular award Year
154: -- FA 122 Loans Enhancemnts changed the cursor to remove the obsolete view igf_sl_lor_dtls_v
155: CURSOR c_lor(
156: p_cal_type igs_ca_inst.cal_type%TYPE,
157: p_seq_num igs_ca_inst.sequence_number%TYPE,
158: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
159: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
160: p_loan_status igf_sl_loans.loan_status%TYPE,
161: p_loan_chg_status igf_sl_loans.loan_chg_status%TYPE,
206: substr(loans.loan_number, 13, 6) = p_school_code;
207:
208: -- masehgal # 2593215 define variables to be used in the call to get_acad_cal_dtls
209: l_loan_number igf_sl_loans.loan_number%TYPE := NULL ;
210: lv_acad_cal_type igs_ca_inst.cal_type%TYPE := NULL ;
211: lv_acad_seq_num igs_ca_inst.sequence_number%TYPE := NULL ;
212: lv_message VARCHAR2(100) := NULL ;
213:
214: -- ## Cursor to Retrieve the Originated record to compare with the igf_sl_lor table to see if any
207:
208: -- masehgal # 2593215 define variables to be used in the call to get_acad_cal_dtls
209: l_loan_number igf_sl_loans.loan_number%TYPE := NULL ;
210: lv_acad_cal_type igs_ca_inst.cal_type%TYPE := NULL ;
211: lv_acad_seq_num igs_ca_inst.sequence_number%TYPE := NULL ;
212: lv_message VARCHAR2(100) := NULL ;
213:
214: -- ## Cursor to Retrieve the Originated record to compare with the igf_sl_lor table to see if any
215: -- ## change records exist.
276:
277: --Cursor to get the alternate code for the calendar instance
278: --Bug 2332668
279: CURSOR cur_alternate_code IS
280: SELECT ca.alternate_code FROM igs_ca_inst ca
281: WHERE ca.cal_type =lv_cal_type
282: AND ca.sequence_number = lv_cal_seq_num;
283:
284: -- Private Definition of the Procedure comp_lor_loc