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_LAR_CREATION dependencies on IGF_SL_LOR_ALL

Line 55: in igf_sl_lor_all table and obsoleting

51: Similarly, OPE ID and School Non Ed Brc ID are also derived for Common Line Loan.
52: --veramach 16-OCT-2003 FA124 Build remove ISIR requirement for awarding(bug # 3108506)
53: -- Added code for checking loan limits in insert_loan_records
54: -- bkkumar 06-oct-2003 Bug 3104228 Impact of adding the relationship_cd
55: in igf_sl_lor_all table and obsoleting
56: BORW_LENDER_ID,
57: DUNS_BORW_LENDER_ID,
58: GUARANTOR_ID,
59: DUNS_GUARNT_ID,

Line 135: g_s_default_status igf_sl_lor_all.s_default_status%TYPE;

131: dl_setup_rec igf_sl_dl_setup_all%ROWTYPE;
132: cl_setup_rec igf_sl_cl_setup_all%ROWTYPE;
133: p_incr_date_code VARCHAR2(100);
134:
135: g_s_default_status igf_sl_lor_all.s_default_status%TYPE;
136: g_p_default_status igf_sl_lor_all.p_default_status%TYPE;
137: g_grade_level_dl igf_sl_lor_all.grade_level_code%TYPE;
138: g_grade_level_cl igf_sl_lor_all.grade_level_code%TYPE;
139: g_anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE;

Line 136: g_p_default_status igf_sl_lor_all.p_default_status%TYPE;

132: cl_setup_rec igf_sl_cl_setup_all%ROWTYPE;
133: p_incr_date_code VARCHAR2(100);
134:
135: g_s_default_status igf_sl_lor_all.s_default_status%TYPE;
136: g_p_default_status igf_sl_lor_all.p_default_status%TYPE;
137: g_grade_level_dl igf_sl_lor_all.grade_level_code%TYPE;
138: g_grade_level_cl igf_sl_lor_all.grade_level_code%TYPE;
139: g_anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE;
140: g_enrollment_code igf_sl_lor_all.enrollment_code%TYPE;

Line 137: g_grade_level_dl igf_sl_lor_all.grade_level_code%TYPE;

133: p_incr_date_code VARCHAR2(100);
134:
135: g_s_default_status igf_sl_lor_all.s_default_status%TYPE;
136: g_p_default_status igf_sl_lor_all.p_default_status%TYPE;
137: g_grade_level_dl igf_sl_lor_all.grade_level_code%TYPE;
138: g_grade_level_cl igf_sl_lor_all.grade_level_code%TYPE;
139: g_anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE;
140: g_enrollment_code igf_sl_lor_all.enrollment_code%TYPE;
141: gv_return_status VARCHAR2(30);

Line 138: g_grade_level_cl igf_sl_lor_all.grade_level_code%TYPE;

134:
135: g_s_default_status igf_sl_lor_all.s_default_status%TYPE;
136: g_p_default_status igf_sl_lor_all.p_default_status%TYPE;
137: g_grade_level_dl igf_sl_lor_all.grade_level_code%TYPE;
138: g_grade_level_cl igf_sl_lor_all.grade_level_code%TYPE;
139: g_anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE;
140: g_enrollment_code igf_sl_lor_all.enrollment_code%TYPE;
141: gv_return_status VARCHAR2(30);
142: gv_message fnd_new_messages.message_text%TYPE;

Line 139: g_anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE;

135: g_s_default_status igf_sl_lor_all.s_default_status%TYPE;
136: g_p_default_status igf_sl_lor_all.p_default_status%TYPE;
137: g_grade_level_dl igf_sl_lor_all.grade_level_code%TYPE;
138: g_grade_level_cl igf_sl_lor_all.grade_level_code%TYPE;
139: g_anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE;
140: g_enrollment_code igf_sl_lor_all.enrollment_code%TYPE;
141: gv_return_status VARCHAR2(30);
142: gv_message fnd_new_messages.message_text%TYPE;
143: SKIP_THIS_RECORD EXCEPTION;

Line 140: g_enrollment_code igf_sl_lor_all.enrollment_code%TYPE;

136: g_p_default_status igf_sl_lor_all.p_default_status%TYPE;
137: g_grade_level_dl igf_sl_lor_all.grade_level_code%TYPE;
138: g_grade_level_cl igf_sl_lor_all.grade_level_code%TYPE;
139: g_anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE;
140: g_enrollment_code igf_sl_lor_all.enrollment_code%TYPE;
141: gv_return_status VARCHAR2(30);
142: gv_message fnd_new_messages.message_text%TYPE;
143: SKIP_THIS_RECORD EXCEPTION;
144:

Line 1189: lv_s_default_status igf_sl_lor_all.s_default_status%TYPE;

1185: Change History :
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:

Line 1269: ln_origination_id igf_sl_lor_all.origination_id%TYPE;

1265: FROM IGF_SL_LOANS_ALL lar
1266: WHERE lar.LOAN_ID = cp_loan_id;
1267:
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 ;

Line 1490: So while inserting into igf_sl_lor_all table person_id has to be the student's party id.

1486: Who When What
1487: azmohamm 03-AUG-2006 For GPLUSFL, the new loan type would be 'GB'
1488: and the Federal application form Code would be 'G'.
1489: The borrower id is same as the student id.
1490: So while inserting into igf_sl_lor_all table person_id has to be the student's party id.
1491: rajagupt 10-Apr-2006 Bug# 5006583, FA161 CL4.
1492: cps_trans_num is inserted. deferment_request_code
1493: borw_interest_ind, borw_outstd_loan_code, p_default_status, s_default_status, stud_sign_ind
1494: are inserted with null and loan_app_form_code = 'Q' for FLP loans

Line 1520: in igf_sl_lor_all table and obsoleting

1516: DUNS_RECIP_ID -- OBSOLETED THIS FIELD
1517: RECIP_NON_ED_BRC_ID is now done from
1518: the FFELP loan Setup.
1519: bkkumar 06-oct-2003 Bug 3104228 Impact of adding the relationship_cd
1520: in igf_sl_lor_all table and obsoleting
1521: BORW_LENDER_ID,
1522: DUNS_BORW_LENDER_ID,
1523: GUARANTOR_ID,
1524: DUNS_GUARNT_ID,

Line 1591: l_appl_form_code igf_sl_lor_all.loan_app_form_code%TYPE;

1587: WHERE loan_id = cp_loanid;
1588:
1589: l_tbh_loans_rec c_tbh_loans_cur%ROWTYPE;
1590:
1591: l_appl_form_code igf_sl_lor_all.loan_app_form_code%TYPE;
1592: l_borw_interest_ind igf_sl_lor.borw_interest_ind%TYPE;
1593: l_borw_outstd_loan_code igf_sl_lor.borw_outstd_loan_code%TYPE;
1594: l_parent_person_id NUMBER;
1595: l_student_person_id NUMBER;

Line 1609: SELECT p_person_id FROM igf_sl_lor_all

1605: AND ci_cal_type = p_cal_type;
1606:
1607: --Bug# 5006583
1608: CURSOR cur_borrower_id (cp_loanid NUMBER) IS
1609: SELECT p_person_id FROM igf_sl_lor_all
1610: WHERE loan_id = cp_loanid;
1611:
1612: --Bug# 5006583
1613: CURSOR citizenship_dtl_cur (cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE) IS

Line 1625: l_b_alien_reg_num_txt igf_sl_lor_all.b_alien_reg_num_txt%TYPE;

1621: l_cur_fa_rec cur_fa_mapping%ROWTYPE;
1622: citizenship_dtl_rec citizenship_dtl_cur%ROWTYPE;
1623: alien_dtl_cur igf_sl_gen.person_dtl_cur;
1624: alien_dtl_rec igf_sl_gen.person_dtl_rec;
1625: l_b_alien_reg_num_txt igf_sl_lor_all.b_alien_reg_num_txt%TYPE;
1626: BEGIN
1627:
1628: -- Origination_Id will be populated from Sequence.
1629: -- Loan_Id is got from the Current value of sequence returned.

Line 2046: SELECT p_person_id FROM igf_sl_lor_all

2042: AND ci_cal_type = p_cal_type;
2043:
2044: --Bug# 5006583
2045: CURSOR cur_borrower_id (cp_loanid NUMBER) IS
2046: SELECT p_person_id FROM igf_sl_lor_all
2047: WHERE loan_id = cp_loanid;
2048:
2049: --Bug# 5006583
2050: CURSOR citizenship_dtl_cur (cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE) IS