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_LI_IMP_PKG dependencies on IGF_SL_GEN

Line 1913: || 2. igf_sl_gen.get_person_details is now used to get borrower information

1909: || p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
1910: || chg_batch_id from igf_sl_lor _loc
1911: || veramach 16-SEP-2003 FA 122 loan enhancements
1912: || 1. c_loan_dtls does not select borrower information from igf_sl_lor_dtls_v
1913: || 2. igf_sl_gen.get_person_details is now used to get borrower information
1914: || (reverse chronological order - newest change first)
1915: */
1916:
1917: CURSOR c_award_amt IS

Line 1945: student_dtl_rec igf_sl_gen.person_dtl_rec;

1941:
1942:
1943: loan_rec c_loan_dtls%ROWTYPE;
1944:
1945: student_dtl_rec igf_sl_gen.person_dtl_rec;
1946: student_dtl_cur igf_sl_gen.person_dtl_cur;
1947:
1948: parent_dtl_rec igf_sl_gen.person_dtl_rec;
1949: parent_dtl_cur igf_sl_gen.person_dtl_cur;

Line 1946: student_dtl_cur igf_sl_gen.person_dtl_cur;

1942:
1943: loan_rec c_loan_dtls%ROWTYPE;
1944:
1945: student_dtl_rec igf_sl_gen.person_dtl_rec;
1946: student_dtl_cur igf_sl_gen.person_dtl_cur;
1947:
1948: parent_dtl_rec igf_sl_gen.person_dtl_rec;
1949: parent_dtl_cur igf_sl_gen.person_dtl_cur;
1950:

Line 1948: parent_dtl_rec igf_sl_gen.person_dtl_rec;

1944:
1945: student_dtl_rec igf_sl_gen.person_dtl_rec;
1946: student_dtl_cur igf_sl_gen.person_dtl_cur;
1947:
1948: parent_dtl_rec igf_sl_gen.person_dtl_rec;
1949: parent_dtl_cur igf_sl_gen.person_dtl_cur;
1950:
1951: CURSOR cur_isir_depend_status (cp_person_id NUMBER)
1952: IS

Line 1949: parent_dtl_cur igf_sl_gen.person_dtl_cur;

1945: student_dtl_rec igf_sl_gen.person_dtl_rec;
1946: student_dtl_cur igf_sl_gen.person_dtl_cur;
1947:
1948: parent_dtl_rec igf_sl_gen.person_dtl_rec;
1949: parent_dtl_cur igf_sl_gen.person_dtl_cur;
1950:
1951: CURSOR cur_isir_depend_status (cp_person_id NUMBER)
1952: IS
1953: SELECT isir.dependency_status

Line 1983: igf_sl_gen.get_person_details(loan_rec.student_id,student_dtl_cur);

1979: CLOSE c_award_amt;
1980:
1981: OPEN c_loan_dtls(ln_loan_id,ln_origination_id);
1982: FETCH c_loan_dtls INTO loan_rec;
1983: igf_sl_gen.get_person_details(loan_rec.student_id,student_dtl_cur);
1984: FETCH student_dtl_cur INTO student_dtl_rec;
1985: igf_sl_gen.get_person_details(loan_rec.p_person_id,parent_dtl_cur);
1986: FETCH parent_dtl_cur INTO parent_dtl_rec;
1987:

Line 1985: igf_sl_gen.get_person_details(loan_rec.p_person_id,parent_dtl_cur);

1981: OPEN c_loan_dtls(ln_loan_id,ln_origination_id);
1982: FETCH c_loan_dtls INTO loan_rec;
1983: igf_sl_gen.get_person_details(loan_rec.student_id,student_dtl_cur);
1984: FETCH student_dtl_cur INTO student_dtl_rec;
1985: igf_sl_gen.get_person_details(loan_rec.p_person_id,parent_dtl_cur);
1986: FETCH parent_dtl_cur INTO parent_dtl_rec;
1987:
1988: CLOSE c_loan_dtls;
1989: CLOSE student_dtl_cur;

Line 1996: lv_s_permt_phone := igf_sl_gen.get_person_phone(loan_rec.student_id);

1992: OPEN cur_isir_depend_status(loan_rec.student_id);
1993: FETCH cur_isir_depend_status INTO lv_dependency_status;
1994: CLOSE cur_isir_depend_status;
1995:
1996: lv_s_permt_phone := igf_sl_gen.get_person_phone(loan_rec.student_id);
1997: lv_p_permt_phone := igf_sl_gen.get_person_phone(loan_rec.p_person_id);
1998:
1999: --Code added for bug 3603289 start
2000: lv_s_license_number := student_dtl_rec.p_license_num;

Line 1997: lv_p_permt_phone := igf_sl_gen.get_person_phone(loan_rec.p_person_id);

1993: FETCH cur_isir_depend_status INTO lv_dependency_status;
1994: CLOSE cur_isir_depend_status;
1995:
1996: lv_s_permt_phone := igf_sl_gen.get_person_phone(loan_rec.student_id);
1997: lv_p_permt_phone := igf_sl_gen.get_person_phone(loan_rec.p_person_id);
1998:
1999: --Code added for bug 3603289 start
2000: lv_s_license_number := student_dtl_rec.p_license_num;
2001: lv_s_license_state := student_dtl_rec.p_license_state;

Line 2351: || 2. igf_sl_gen.get_person_details is now used to get borrower information

2347: || Change History :
2348: || Who When What
2349: || veramach 16-SEP-2003 FA 122 loan enhancements
2350: || 1. c_loan_dtls does not select borrower information from igf_sl_lor_dtls_v
2351: || 2. igf_sl_gen.get_person_details is now used to get borrower information
2352: || (reverse chronological order - newest change first)
2353: */
2354: CURSOR c_award_amt IS
2355: SELECT offered_amt,

Line 2381: student_dtl_rec igf_sl_gen.person_dtl_rec;

2377: AND loans.loan_id = p_loan_id;
2378:
2379: loan_rec c_loan_dtls%ROWTYPE;
2380:
2381: student_dtl_rec igf_sl_gen.person_dtl_rec;
2382: student_dtl_cur igf_sl_gen.person_dtl_cur;
2383:
2384: parent_dtl_rec igf_sl_gen.person_dtl_rec;
2385: parent_dtl_cur igf_sl_gen.person_dtl_cur;

Line 2382: student_dtl_cur igf_sl_gen.person_dtl_cur;

2378:
2379: loan_rec c_loan_dtls%ROWTYPE;
2380:
2381: student_dtl_rec igf_sl_gen.person_dtl_rec;
2382: student_dtl_cur igf_sl_gen.person_dtl_cur;
2383:
2384: parent_dtl_rec igf_sl_gen.person_dtl_rec;
2385: parent_dtl_cur igf_sl_gen.person_dtl_cur;
2386:

Line 2384: parent_dtl_rec igf_sl_gen.person_dtl_rec;

2380:
2381: student_dtl_rec igf_sl_gen.person_dtl_rec;
2382: student_dtl_cur igf_sl_gen.person_dtl_cur;
2383:
2384: parent_dtl_rec igf_sl_gen.person_dtl_rec;
2385: parent_dtl_cur igf_sl_gen.person_dtl_cur;
2386:
2387: CURSOR cur_isir_depend_status (cp_person_id NUMBER)
2388: IS

Line 2385: parent_dtl_cur igf_sl_gen.person_dtl_cur;

2381: student_dtl_rec igf_sl_gen.person_dtl_rec;
2382: student_dtl_cur igf_sl_gen.person_dtl_cur;
2383:
2384: parent_dtl_rec igf_sl_gen.person_dtl_rec;
2385: parent_dtl_cur igf_sl_gen.person_dtl_cur;
2386:
2387: CURSOR cur_isir_depend_status (cp_person_id NUMBER)
2388: IS
2389: SELECT isir.dependency_status

Line 2423: igf_sl_gen.get_person_details(loan_rec.student_id,student_dtl_cur);

2419: CLOSE c_award_amt;
2420:
2421: OPEN c_loan_dtls(ln_loan_id,ln_origination_id);
2422: FETCH c_loan_dtls INTO loan_rec;
2423: igf_sl_gen.get_person_details(loan_rec.student_id,student_dtl_cur);
2424: FETCH student_dtl_cur INTO student_dtl_rec;
2425: igf_sl_gen.get_person_details(loan_rec.p_person_id,parent_dtl_cur);
2426: FETCH parent_dtl_cur INTO parent_dtl_rec;
2427:

Line 2425: igf_sl_gen.get_person_details(loan_rec.p_person_id,parent_dtl_cur);

2421: OPEN c_loan_dtls(ln_loan_id,ln_origination_id);
2422: FETCH c_loan_dtls INTO loan_rec;
2423: igf_sl_gen.get_person_details(loan_rec.student_id,student_dtl_cur);
2424: FETCH student_dtl_cur INTO student_dtl_rec;
2425: igf_sl_gen.get_person_details(loan_rec.p_person_id,parent_dtl_cur);
2426: FETCH parent_dtl_cur INTO parent_dtl_rec;
2427:
2428: CLOSE c_loan_dtls;
2429: CLOSE student_dtl_cur;

Line 2436: lv_s_permt_phone := igf_sl_gen.get_person_phone(loan_rec.student_id);

2432: OPEN cur_isir_depend_status(loan_rec.student_id);
2433: FETCH cur_isir_depend_status INTO lv_dependency_status;
2434: CLOSE cur_isir_depend_status;
2435:
2436: lv_s_permt_phone := igf_sl_gen.get_person_phone(loan_rec.student_id);
2437: lv_p_permt_phone := igf_sl_gen.get_person_phone(loan_rec.p_person_id);
2438:
2439: --Code added for bug 3603289 start
2440: lv_s_license_number := student_dtl_rec.p_license_num;

Line 2437: lv_p_permt_phone := igf_sl_gen.get_person_phone(loan_rec.p_person_id);

2433: FETCH cur_isir_depend_status INTO lv_dependency_status;
2434: CLOSE cur_isir_depend_status;
2435:
2436: lv_s_permt_phone := igf_sl_gen.get_person_phone(loan_rec.student_id);
2437: lv_p_permt_phone := igf_sl_gen.get_person_phone(loan_rec.p_person_id);
2438:
2439: --Code added for bug 3603289 start
2440: lv_s_license_number := student_dtl_rec.p_license_num;
2441: lv_s_license_state := student_dtl_rec.p_license_state;