91: l_rec_batch_type VARCHAR2(100);
92:
93: l_rowid VARCHAR2(25);
94: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
95: l_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE;
96: l_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE;
97:
98: -- Cursor to parse and load the Header record.
99: CURSOR c_header IS
92:
93: l_rowid VARCHAR2(25);
94: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
95: l_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE;
96: l_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE;
97:
98: -- Cursor to parse and load the Header record.
99: CURSOR c_header IS
100: SELECT substr(record_data, 23, 23) batch_id,