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

Line 21: -- derived from igf_sl_gen.get_person_details.

17: -----------------------------------------------------------------------------------
18: -- veramach 04-May-2004 bug 3603289
19: -- Modified cursor cur_student_licence to select
20: -- dependency_status from ISIR. other details are
21: -- derived from igf_sl_gen.get_person_details.
22: -----------------------------------------------------------------------------------
23: -- veramach 29-Jan-2004 bug 3408092 added 2004-2005 in p_dl_version checks
24: -----------------------------------------------------------------------------------
25: -- ugummall 23-OCT-2003 Bug 3102439. FA 126 Multiple FA Offices.

Line 43: -- from igf_sl_gen.get_person_details.

39: -- bkkumar 07-oct-2003 Bug 3104228 FA 122 Loan Enhancemtns
40: -- a) Changed the cursor c_lor
41: -- containing igf_sl_lor_dtls_v with simple
42: -- joins and got the details of student and parent
43: -- from igf_sl_gen.get_person_details.
44: -- Added the debugging log messages.
45: -- b) The DUNS_BORW_LENDER_ID,
46: -- DUNS_GUARNT_ID,
47: -- DUNS_LENDER_ID,

Line 146: student_dtl_cur igf_sl_gen.person_dtl_cur;

142: l_alien_reg_number igf_ap_isir_matched.alien_reg_number%TYPE;
143: l_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
144: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
145: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
146: student_dtl_cur igf_sl_gen.person_dtl_cur;
147: parent_dtl_cur igf_sl_gen.person_dtl_cur;
148: student_dtl_rec igf_sl_gen.person_dtl_rec;
149: parent_dtl_rec igf_sl_gen.person_dtl_rec;
150:

Line 147: parent_dtl_cur igf_sl_gen.person_dtl_cur;

143: l_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
144: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
145: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
146: student_dtl_cur igf_sl_gen.person_dtl_cur;
147: parent_dtl_cur igf_sl_gen.person_dtl_cur;
148: student_dtl_rec igf_sl_gen.person_dtl_rec;
149: parent_dtl_rec igf_sl_gen.person_dtl_rec;
150:
151:

Line 148: student_dtl_rec igf_sl_gen.person_dtl_rec;

144: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
145: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
146: student_dtl_cur igf_sl_gen.person_dtl_cur;
147: parent_dtl_cur igf_sl_gen.person_dtl_cur;
148: student_dtl_rec igf_sl_gen.person_dtl_rec;
149: parent_dtl_rec igf_sl_gen.person_dtl_rec;
150:
151:
152: -- ## Cursor to Retrieve the active direct loan records with change status as Send from the igf_sl_lor table

Line 149: parent_dtl_rec igf_sl_gen.person_dtl_rec;

145: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
146: student_dtl_cur igf_sl_gen.person_dtl_cur;
147: parent_dtl_cur igf_sl_gen.person_dtl_cur;
148: student_dtl_rec igf_sl_gen.person_dtl_rec;
149: parent_dtl_rec igf_sl_gen.person_dtl_rec;
150:
151:
152: -- ## Cursor to Retrieve the active direct loan records with change status as Send from the igf_sl_lor table
153: -- ## for the particular award Year

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

420:
421: --Get the Direct Loan File Spec Version Bug :-2490289 DL Header and Trailer Formatting Error.
422: --Handled the NO_DATA_FOUND exception if the DL Setup record is not available
423: BEGIN
424: lv_dl_version := igf_sl_gen.get_dl_version(lv_cal_type, lv_cal_seq_num);
425: EXCEPTION
426: WHEN NO_DATA_FOUND THEN
427: fnd_message.set_name('IGF','IGF_SL_NO_DL_SETUP');
428: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

474:
475: FOR lc_lor IN c_lor(lv_cal_type,lv_cal_seq_num,l_fed_fund_1,l_fed_fund_2,'A','G','Y')
476: LOOP
477: BEGIN
478: -- FA 122 Loan Enhancements Use the igf_sl_gen.get_person_details for getting the student as
479: -- well as parent details.
480: igf_sl_gen.get_person_details(lc_lor.student_id,student_dtl_cur);
481: FETCH student_dtl_cur INTO student_dtl_rec;
482: igf_sl_gen.get_person_details(lc_lor.p_person_id,parent_dtl_cur);

Line 480: igf_sl_gen.get_person_details(lc_lor.student_id,student_dtl_cur);

476: LOOP
477: BEGIN
478: -- FA 122 Loan Enhancements Use the igf_sl_gen.get_person_details for getting the student as
479: -- well as parent details.
480: igf_sl_gen.get_person_details(lc_lor.student_id,student_dtl_cur);
481: FETCH student_dtl_cur INTO student_dtl_rec;
482: igf_sl_gen.get_person_details(lc_lor.p_person_id,parent_dtl_cur);
483: FETCH parent_dtl_cur INTO parent_dtl_rec;
484:

Line 482: igf_sl_gen.get_person_details(lc_lor.p_person_id,parent_dtl_cur);

478: -- FA 122 Loan Enhancements Use the igf_sl_gen.get_person_details for getting the student as
479: -- well as parent details.
480: igf_sl_gen.get_person_details(lc_lor.student_id,student_dtl_cur);
481: FETCH student_dtl_cur INTO student_dtl_rec;
482: igf_sl_gen.get_person_details(lc_lor.p_person_id,parent_dtl_cur);
483: FETCH parent_dtl_cur INTO parent_dtl_rec;
484:
485: CLOSE student_dtl_cur;
486: CLOSE parent_dtl_cur;