eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SL_DL_ORIG dependencies on IGS_CA_INST

Line 125: lv_cal_type igs_ca_inst.cal_type%TYPE;

121: -- stud_sign_ind, borr_credit_auth_code
122: -- in the call to igf_sl_lor tbh
123: -----------------------------------------------------------------------------------
124: --
125: lv_cal_type igs_ca_inst.cal_type%TYPE;
126: lv_cal_seq_num igs_ca_inst.sequence_number%TYPE;
127: lv_dl_version igf_lookups_view.lookup_code%TYPE;
128: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
129: lv_batch_id igf_sl_dl_batch.batch_id%TYPE;

Line 126: lv_cal_seq_num igs_ca_inst.sequence_number%TYPE;

122: -- in the call to igf_sl_lor tbh
123: -----------------------------------------------------------------------------------
124: --
125: lv_cal_type igs_ca_inst.cal_type%TYPE;
126: lv_cal_seq_num igs_ca_inst.sequence_number%TYPE;
127: lv_dl_version igf_lookups_view.lookup_code%TYPE;
128: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
129: lv_batch_id igf_sl_dl_batch.batch_id%TYPE;
130: lv_mesg_class igf_sl_dl_batch.message_class%TYPE;

Line 139: lv_acad_begin_dt igs_ca_inst.start_dt%TYPE := NULL;

135: lv_orig_award_id igf_aw_award.award_id%TYPE;
136: lv_orig_loan_id igf_sl_loans.loan_id%TYPE;
137: lv_orig_loan_num igf_sl_loans.loan_number%TYPE;
138: lv_num_of_rec NUMBER := 0;
139: lv_acad_begin_dt igs_ca_inst.start_dt%TYPE := NULL;
140: lv_acad_end_dt igs_ca_inst.end_dt%TYPE := NULL;
141: l_i NUMBER(1);
142: l_alternate_code igs_ca_inst.alternate_code%TYPE;
143: l_display VARCHAR2(1) := 'N';

Line 140: lv_acad_end_dt igs_ca_inst.end_dt%TYPE := NULL;

136: lv_orig_loan_id igf_sl_loans.loan_id%TYPE;
137: lv_orig_loan_num igf_sl_loans.loan_number%TYPE;
138: lv_num_of_rec NUMBER := 0;
139: lv_acad_begin_dt igs_ca_inst.start_dt%TYPE := NULL;
140: lv_acad_end_dt igs_ca_inst.end_dt%TYPE := NULL;
141: l_i NUMBER(1);
142: l_alternate_code igs_ca_inst.alternate_code%TYPE;
143: l_display VARCHAR2(1) := 'N';
144:

Line 142: l_alternate_code igs_ca_inst.alternate_code%TYPE;

138: lv_num_of_rec NUMBER := 0;
139: lv_acad_begin_dt igs_ca_inst.start_dt%TYPE := NULL;
140: lv_acad_end_dt igs_ca_inst.end_dt%TYPE := NULL;
141: l_i NUMBER(1);
142: l_alternate_code igs_ca_inst.alternate_code%TYPE;
143: l_display VARCHAR2(1) := 'N';
144:
145: -- masehgal # 2593215 added variables to retrieve values
146: lv_acad_cal_type igs_ps_ofr_inst.cal_type%TYPE := NULL;

Line 166: cp_cal_type igs_ca_inst.cal_type%TYPE,

162: no_loan_data EXCEPTION;
163: yr_full_participant EXCEPTION;
164:
165: CURSOR cur_loan_details (
166: cp_cal_type igs_ca_inst.cal_type%TYPE,
167: cp_seq_number igs_ca_inst.sequence_number%TYPE,
168: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
169: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
170: cp_loan_status igf_sl_loans.loan_status%TYPE,

Line 167: cp_seq_number igs_ca_inst.sequence_number%TYPE,

163: yr_full_participant EXCEPTION;
164:
165: CURSOR cur_loan_details (
166: cp_cal_type igs_ca_inst.cal_type%TYPE,
167: cp_seq_number igs_ca_inst.sequence_number%TYPE,
168: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
169: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
170: cp_loan_status igf_sl_loans.loan_status%TYPE,
171: cp_active igf_sl_loans.active%TYPE,

Line 249: SELECT ca.alternate_code FROM igs_ca_inst ca

245:
246: --Cursor to get the alternate code for the calendar instance
247: --Bug 2332668
248: CURSOR cur_alternate_code IS
249: SELECT ca.alternate_code FROM igs_ca_inst ca
250: WHERE ca.cal_type =lv_cal_type
251: AND ca.sequence_number = lv_cal_seq_num;
252:
253: -- Get the details of school meaning from lookups to print in the log file