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 IGF_SL_GEN

Line 45: -- are derived from igf_sl_gen.get_person_details

41: -- svuppala 4-Nov-2004 #3416936 FA 134 TBH impacts for newly added columns
42:
43: -- veramach 04-May-2004 bug 3603289
44: -- modified cursor c_fabase to select only dependency_status from ISIR.Other details
45: -- are derived from igf_sl_gen.get_person_details
46: -----------------------------------------------------------------------------------
47: -- ugummall 23-OCT-2003 Bug 3102439. FA 126 Multiple FA Offices.
48: -- Modified the cursor cur_loan_details to include the clause which
49: -- filter only the loans having the school id matched with parameter p_school_code.

Line 81: -- from igf_sl_gen.get_person_details.

77: -- bkkumar 30-sep-2003 Bug 3104228 FA 122 Loans Enhancements
78: -- Changed the cursor c_tbh_cur
79: -- containing igf_sl_lor_dtls_v with simple
80: -- joins and got the details of student and parent
81: -- from igf_sl_gen.get_person_details.
82: -- Added the debugging log messages.
83: -- OBSOLETED FIELDS ::
84: -- A) Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
85: -- cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,

Line 319: lv_dl_version := igf_sl_gen.get_dl_version(lv_cal_type, lv_cal_seq_num);

315: --Handled the NO_DATA_FOUND exception if the DL Setup record
316: --is not available
317: BEGIN
318:
319: lv_dl_version := igf_sl_gen.get_dl_version(lv_cal_type, lv_cal_seq_num);
320:
321: EXCEPTION
322: WHEN NO_DATA_FOUND THEN
323:

Line 465: student_dtl_cur igf_sl_gen.person_dtl_cur;

461:
462: lv_row_id VARCHAR2(25);
463: lv_base_id igf_ap_fa_base_rec.base_id%TYPE;
464:
465: student_dtl_cur igf_sl_gen.person_dtl_cur;
466: parent_dtl_cur igf_sl_gen.person_dtl_cur;
467: student_dtl_rec igf_sl_gen.person_dtl_rec;
468: parent_dtl_rec igf_sl_gen.person_dtl_rec;
469:

Line 466: parent_dtl_cur igf_sl_gen.person_dtl_cur;

462: lv_row_id VARCHAR2(25);
463: lv_base_id igf_ap_fa_base_rec.base_id%TYPE;
464:
465: student_dtl_cur igf_sl_gen.person_dtl_cur;
466: parent_dtl_cur igf_sl_gen.person_dtl_cur;
467: student_dtl_rec igf_sl_gen.person_dtl_rec;
468: parent_dtl_rec igf_sl_gen.person_dtl_rec;
469:
470: -- FA 122 Loan Enhancements added this cursor to remove the cursor based on the obsolete view igf_sl_lor_dtls_v

Line 467: student_dtl_rec igf_sl_gen.person_dtl_rec;

463: lv_base_id igf_ap_fa_base_rec.base_id%TYPE;
464:
465: student_dtl_cur igf_sl_gen.person_dtl_cur;
466: parent_dtl_cur igf_sl_gen.person_dtl_cur;
467: student_dtl_rec igf_sl_gen.person_dtl_rec;
468: parent_dtl_rec igf_sl_gen.person_dtl_rec;
469:
470: -- FA 122 Loan Enhancements added this cursor to remove the cursor based on the obsolete view igf_sl_lor_dtls_v
471:

Line 468: parent_dtl_rec igf_sl_gen.person_dtl_rec;

464:
465: student_dtl_cur igf_sl_gen.person_dtl_cur;
466: parent_dtl_cur igf_sl_gen.person_dtl_cur;
467: student_dtl_rec igf_sl_gen.person_dtl_rec;
468: parent_dtl_rec igf_sl_gen.person_dtl_rec;
469:
470: -- FA 122 Loan Enhancements added this cursor to remove the cursor based on the obsolete view igf_sl_lor_dtls_v
471:
472: CURSOR c_tbh_cur IS

Line 608: DECODE(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(lv_base_id)),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(lv_base_id)),10,0))

604: AND fabase.base_id = lv_base_id;
605:
606: -- Get the Student Phone
607: CURSOR cur_get_s_phone IS select
608: DECODE(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(lv_base_id)),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(lv_base_id)),10,0))
609: FROM DUAL;
610:
611: -- Get the Parent Phone
612: CURSOR cur_get_p_phone(p_per_id igf_ap_fa_base_rec.person_id%TYPE) IS

Line 613: SELECT DECODE(igf_sl_gen.get_person_phone(p_per_id),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(p_per_id),10,0))

609: FROM DUAL;
610:
611: -- Get the Parent Phone
612: CURSOR cur_get_p_phone(p_per_id igf_ap_fa_base_rec.person_id%TYPE) IS
613: SELECT DECODE(igf_sl_gen.get_person_phone(p_per_id),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(p_per_id),10,0))
614: FROM DUAL;
615:
616: l_p_phone VARCHAR2(80);
617: l_s_phone VARCHAR2(80);

Line 624: -- FA 122 Loan Enhancements Use the igf_sl_gen.get_person_details for getting the student as

620:
621: BEGIN
622: FOR tbh_rec in c_tbh_cur LOOP
623:
624: -- FA 122 Loan Enhancements Use the igf_sl_gen.get_person_details for getting the student as
625: -- well as parent details.
626: -- get the student details
627: igf_sl_gen.get_person_details(tbh_rec.student_id,student_dtl_cur);
628: FETCH student_dtl_cur INTO student_dtl_rec;

Line 627: igf_sl_gen.get_person_details(tbh_rec.student_id,student_dtl_cur);

623:
624: -- FA 122 Loan Enhancements Use the igf_sl_gen.get_person_details for getting the student as
625: -- well as parent details.
626: -- get the student details
627: igf_sl_gen.get_person_details(tbh_rec.student_id,student_dtl_cur);
628: FETCH student_dtl_cur INTO student_dtl_rec;
629:
630: -- get the parent details
631: igf_sl_gen.get_person_details(tbh_rec.p_person_id,parent_dtl_cur);

Line 631: igf_sl_gen.get_person_details(tbh_rec.p_person_id,parent_dtl_cur);

627: igf_sl_gen.get_person_details(tbh_rec.student_id,student_dtl_cur);
628: FETCH student_dtl_cur INTO student_dtl_rec;
629:
630: -- get the parent details
631: igf_sl_gen.get_person_details(tbh_rec.p_person_id,parent_dtl_cur);
632: FETCH parent_dtl_cur INTO parent_dtl_rec;
633:
634: CLOSE student_dtl_cur;
635: CLOSE parent_dtl_cur;