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

Line 40: -- derived from igf_sl_gen.get_person_details.

36: ---------------------------------------------------------------------------------
37: -- veramach 04-May-2004 bug 3603289
38: -- Modified cursor cur_student_licence to select
39: -- dependency_status from ISIR. other details are
40: -- derived from igf_sl_gen.get_person_details.
41: -----------------------------------------------------------------------------------
42: -- sjadhav 18-Feb-2004 Bug 3451140
43: -- Check for Non ED Branch ID setup only iff it is not
44: -- '0000'

Line 3574: -- Changed c_loan_dtls cursor.it does not select borrower information.igf_sl_gen.get_person_details is used for this

3570: -- cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
3571: -- p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
3572: -- chg_batch_id from igf_sl_lor_loc
3573: -- veramach 16-SEP-2003 FA 122 loan enhancements
3574: -- Changed c_loan_dtls cursor.it does not select borrower information.igf_sl_gen.get_person_details is used for this
3575:
3576:
3577: ln_rowid ROWID;
3578: lor_rowid ROWID;

Line 3663: student_dtl_rec igf_sl_gen.person_dtl_rec;

3659:
3660:
3661: loan_rec c_loan_dtls%ROWTYPE;
3662:
3663: student_dtl_rec igf_sl_gen.person_dtl_rec;
3664: student_dtl_cur igf_sl_gen.person_dtl_cur;
3665:
3666: parent_dtl_rec igf_sl_gen.person_dtl_rec;
3667: parent_dtl_cur igf_sl_gen.person_dtl_cur;

Line 3664: student_dtl_cur igf_sl_gen.person_dtl_cur;

3660:
3661: loan_rec c_loan_dtls%ROWTYPE;
3662:
3663: student_dtl_rec igf_sl_gen.person_dtl_rec;
3664: student_dtl_cur igf_sl_gen.person_dtl_cur;
3665:
3666: parent_dtl_rec igf_sl_gen.person_dtl_rec;
3667: parent_dtl_cur igf_sl_gen.person_dtl_cur;
3668:

Line 3666: parent_dtl_rec igf_sl_gen.person_dtl_rec;

3662:
3663: student_dtl_rec igf_sl_gen.person_dtl_rec;
3664: student_dtl_cur igf_sl_gen.person_dtl_cur;
3665:
3666: parent_dtl_rec igf_sl_gen.person_dtl_rec;
3667: parent_dtl_cur igf_sl_gen.person_dtl_cur;
3668:
3669: CURSOR cur_isir_depend_status (cp_person_id NUMBER)
3670: IS

Line 3667: parent_dtl_cur igf_sl_gen.person_dtl_cur;

3663: student_dtl_rec igf_sl_gen.person_dtl_rec;
3664: student_dtl_cur igf_sl_gen.person_dtl_cur;
3665:
3666: parent_dtl_rec igf_sl_gen.person_dtl_rec;
3667: parent_dtl_cur igf_sl_gen.person_dtl_cur;
3668:
3669: CURSOR cur_isir_depend_status (cp_person_id NUMBER)
3670: IS
3671: SELECT isir.dependency_status

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

4040:
4041: OPEN c_loan_dtls(ln_loan_id,ln_origination_id);
4042: FETCH c_loan_dtls INTO loan_rec;
4043:
4044: igf_sl_gen.get_person_details(loan_rec.student_id,student_dtl_cur);
4045: FETCH student_dtl_cur INTO student_dtl_rec;
4046: igf_sl_gen.get_person_details(loan_rec.p_person_id,parent_dtl_cur);
4047: FETCH parent_dtl_cur INTO parent_dtl_rec;
4048:

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

4042: FETCH c_loan_dtls INTO loan_rec;
4043:
4044: igf_sl_gen.get_person_details(loan_rec.student_id,student_dtl_cur);
4045: FETCH student_dtl_cur INTO student_dtl_rec;
4046: igf_sl_gen.get_person_details(loan_rec.p_person_id,parent_dtl_cur);
4047: FETCH parent_dtl_cur INTO parent_dtl_rec;
4048:
4049:
4050: CLOSE c_loan_dtls;

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

4054: OPEN cur_isir_depend_status(loan_rec.student_id);
4055: FETCH cur_isir_depend_status INTO lv_dependency_status;
4056: CLOSE cur_isir_depend_status;
4057:
4058: lv_s_permt_phone := igf_sl_gen.get_person_phone(loan_rec.student_id);
4059: lv_p_permt_phone := igf_sl_gen.get_person_phone(loan_rec.p_person_id);
4060:
4061: --Code added for bug 3603289 start
4062: lv_s_license_number := student_dtl_rec.p_license_num;

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

4055: FETCH cur_isir_depend_status INTO lv_dependency_status;
4056: CLOSE cur_isir_depend_status;
4057:
4058: lv_s_permt_phone := igf_sl_gen.get_person_phone(loan_rec.student_id);
4059: lv_p_permt_phone := igf_sl_gen.get_person_phone(loan_rec.p_person_id);
4060:
4061: --Code added for bug 3603289 start
4062: lv_s_license_number := student_dtl_rec.p_license_num;
4063: lv_s_license_state := student_dtl_rec.p_license_state;