[Home] [Help]
149: -- award rec loop. (Bug 2385334)
150: g_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE; -- Bug 4568942
151: g_award_id igf_aw_award_all.award_id%TYPE;
152: g_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
153: gn_transaction_num igf_ap_isir_matched_all.transaction_num%TYPE;
154: gv_atd_entity_id_txt VARCHAR2(30);
155: gv_rep_entity_id_txt VARCHAR2(30);
156:
157: gv_unsub_elig_for_depnt igf_sl_lor.unsub_elig_for_depnt%TYPE;
772: lv_loan_yr VARCHAR2(2);
773: lv_loan_number igf_sl_loans_all.loan_number%TYPE;
774: lv_incr_seq NUMBER;
775: lv_incr_seq_char VARCHAR2(100);
776: l_ssn igf_ap_isir_matched_all.current_ssn%TYPE;
777:
778: x_return_status VARCHAR2(1);
779: x_msg_data VARCHAR2(30);
780: x_dlsch_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
1170: p_grade_cl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1171: p_enroll_code OUT NOCOPY igf_sl_lor.enrollment_code%TYPE,
1172: p_isir_present OUT NOCOPY BOOLEAN,
1173: p_anticip_comp_date OUT NOCOPY igf_sl_lor.anticip_compl_date%TYPE,
1174: p_transaction_num OUT NOCOPY igf_ap_isir_matched_all.transaction_num%TYPE,
1175: p_unsub_elig_for_depnt OUT NOCOPY igf_sl_lor.unsub_elig_for_depnt%TYPE
1176: )
1177: IS
1178: /***************************************************************
1186: Who When What
1187: ***************************************************************/
1188:
1189: lv_s_default_status igf_sl_lor_all.s_default_status%TYPE;
1190: lv_match_flag igf_ap_isir_matched_all.nslds_match_flag%TYPE;
1191: lv_nslds_data_override_flg igf_ap_fa_base_rec_all.nslds_data_override_flg%TYPE;
1192: lv_adnl_unsub_loan_elig_flag igf_ap_fa_base_rec_all.adnl_unsub_loan_elig_flag%TYPE;
1193:
1194: CURSOR cur_nslds_data IS
1193:
1194: CURSOR cur_nslds_data IS
1195: SELECT isirm.nslds_match_flag, NVL(fabase.nslds_data_override_flg,'N'),isirm.transaction_num,
1196: NVL(fabase.adnl_unsub_loan_elig_flag,'N') adnl_unsub_loan_elig_flag -- FA134
1197: FROM igf_ap_isir_matched_all isirm,
1198: igf_ap_fa_base_rec_all fabase
1199: WHERE fabase.base_id = p_base_id
1200: AND fabase.base_id = isirm.base_id
1201: AND isirm.payment_isir = 'Y'
1268: lv_row_id ROWID;
1269: ln_origination_id igf_sl_lor_all.origination_id%TYPE;
1270: ld_sch_cert_date DATE;
1271: lv_orig_fee_perct igf_sl_dl_setup_all.orig_fee_perct_stafford%TYPE;
1272: lv_match_flag igf_ap_isir_matched_all.nslds_match_flag%TYPE;
1273: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
1274: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
1275: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
1276: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;