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

Line 81: p_mesg_class := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,

77: BEGIN
78:
79: -- Message Class, Batch Type and Cycle Year have been predefined for each Version+Filetype
80: -- in igf_sl_dl_file_type seed data table.
81: p_mesg_class := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,
82: p_dl_loan_catg, 'MESSAGE-CLASS');
83: lv_batch_type := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,
84: p_dl_loan_catg, 'BATCH-TYPE');
85: lv_cycle_year := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,

Line 83: lv_batch_type := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,

79: -- Message Class, Batch Type and Cycle Year have been predefined for each Version+Filetype
80: -- in igf_sl_dl_file_type seed data table.
81: p_mesg_class := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,
82: p_dl_loan_catg, 'MESSAGE-CLASS');
83: lv_batch_type := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,
84: p_dl_loan_catg, 'BATCH-TYPE');
85: lv_cycle_year := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,
86: p_dl_loan_catg, 'CYCLE-YEAR');
87: p_rec_length := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,

Line 85: lv_cycle_year := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,

81: p_mesg_class := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,
82: p_dl_loan_catg, 'MESSAGE-CLASS');
83: lv_batch_type := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,
84: p_dl_loan_catg, 'BATCH-TYPE');
85: lv_cycle_year := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,
86: p_dl_loan_catg, 'CYCLE-YEAR');
87: p_rec_length := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,
88: p_dl_loan_catg, 'REC-LENGTH');
89:

Line 87: p_rec_length := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,

83: lv_batch_type := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,
84: p_dl_loan_catg, 'BATCH-TYPE');
85: lv_cycle_year := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,
86: p_dl_loan_catg, 'CYCLE-YEAR');
87: p_rec_length := igf_sl_gen.get_dl_file_type(p_dl_version, p_file_type,
88: p_dl_loan_catg, 'REC-LENGTH');
89:
90: IF p_dl_version IN ('2002-2003','2003-2004','2004-2005') THEN
91:

Line 456: from igf_sl_gen.get_person_details.

452: bkkumar 30-sep-2003 Bug 3104228 FA 122 Loans Enhancements
453: Added the cursor c_lor_details and
454: instead of using igf_sl_lor_dtls_v used simple
455: joins and got the details of student and parent
456: from igf_sl_gen.get_person_details.
457: Added the debugging log messages.
458: smvk 17-Feb-2003 Bug # 2758823. Added filler space from 132 to 153 for dl_version 2003-2004 for ED to use.
459: mesriniv 1-jul-2002 Made UPPERCASE for Name,Address Fields,Code added for Student/Parent Phone
460: Bug :- 2426609 SSN Format Incorrect in Output File

Line 479: student_dtl_cur igf_sl_gen.person_dtl_cur;

475: lv_message VARCHAR2(100) ;
476:
477: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
478: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
479: student_dtl_cur igf_sl_gen.person_dtl_cur;
480: parent_dtl_cur igf_sl_gen.person_dtl_cur;
481: student_dtl_rec igf_sl_gen.person_dtl_rec;
482: parent_dtl_rec igf_sl_gen.person_dtl_rec;
483:

Line 480: parent_dtl_cur igf_sl_gen.person_dtl_cur;

476:
477: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
478: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
479: student_dtl_cur igf_sl_gen.person_dtl_cur;
480: parent_dtl_cur igf_sl_gen.person_dtl_cur;
481: student_dtl_rec igf_sl_gen.person_dtl_rec;
482: parent_dtl_rec igf_sl_gen.person_dtl_rec;
483:
484: -- cursor to replace the columns selected from the igf_sl_lor_dtls_v FA 122 Enhancements

Line 481: student_dtl_rec igf_sl_gen.person_dtl_rec;

477: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
478: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
479: student_dtl_cur igf_sl_gen.person_dtl_cur;
480: parent_dtl_cur igf_sl_gen.person_dtl_cur;
481: student_dtl_rec igf_sl_gen.person_dtl_rec;
482: parent_dtl_rec igf_sl_gen.person_dtl_rec;
483:
484: -- cursor to replace the columns selected from the igf_sl_lor_dtls_v FA 122 Enhancements
485:

Line 482: parent_dtl_rec igf_sl_gen.person_dtl_rec;

478: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
479: student_dtl_cur igf_sl_gen.person_dtl_cur;
480: parent_dtl_cur igf_sl_gen.person_dtl_cur;
481: student_dtl_rec igf_sl_gen.person_dtl_rec;
482: parent_dtl_rec igf_sl_gen.person_dtl_rec;
483:
484: -- cursor to replace the columns selected from the igf_sl_lor_dtls_v FA 122 Enhancements
485:
486: CURSOR c_lor_details (

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

584: OPEN c_lor_details(p_ci_cal_type,p_ci_seq_num,l_fed_fund_1,l_fed_fund_2,'V','Y',p_dl_loan_number);
585: FETCH c_lor_details INTO l_lor_details;
586: CLOSE c_lor_details;
587:
588: -- FA 122 Loan Enhancements Use the igf_sl_gen.get_person_details for getting the student as
589: -- well as parent details.
590:
591: -- get the student details
592: igf_sl_gen.get_person_details(l_lor_details.student_id,student_dtl_cur);

Line 592: igf_sl_gen.get_person_details(l_lor_details.student_id,student_dtl_cur);

588: -- FA 122 Loan Enhancements Use the igf_sl_gen.get_person_details for getting the student as
589: -- well as parent details.
590:
591: -- get the student details
592: igf_sl_gen.get_person_details(l_lor_details.student_id,student_dtl_cur);
593: FETCH student_dtl_cur INTO student_dtl_rec;
594:
595: -- get the parene details
596: igf_sl_gen.get_person_details(l_lor_details.p_person_id,parent_dtl_cur);

Line 596: igf_sl_gen.get_person_details(l_lor_details.p_person_id,parent_dtl_cur);

592: igf_sl_gen.get_person_details(l_lor_details.student_id,student_dtl_cur);
593: FETCH student_dtl_cur INTO student_dtl_rec;
594:
595: -- get the parene details
596: igf_sl_gen.get_person_details(l_lor_details.p_person_id,parent_dtl_cur);
597: FETCH parent_dtl_cur INTO parent_dtl_rec;
598:
599: CLOSE student_dtl_cur;
600: CLOSE parent_dtl_cur;

Line 622: ||DECODE(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(l_lor_details.base_id)),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(l_lor_details.base_id)),10,0))

618: ||RPAD(NVL(UPPER(student_dtl_rec.p_permt_addr1)||' '||UPPER(student_dtl_rec.p_permt_addr2),' ') ,35)
619: ||RPAD(NVL(UPPER(student_dtl_rec.p_permt_city) ,' '),16)
620: ||RPAD(NVL(UPPER(student_dtl_rec.p_permt_state) ,' '), 2)
621: ||RPAD(NVL(student_dtl_rec.p_permt_zip ,' '), 9)
622: ||DECODE(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(l_lor_details.base_id)),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(l_lor_details.base_id)),10,0))
623: ||RPAD(' ',22)
624: ||RPAD(NVL(TO_CHAR(student_dtl_rec.p_date_of_birth,'YYYYMMDD'),' '),8)
625: ||LPAD(' ', 1)
626: ||LPAD(NVL(l_lor_details.alien_reg_number ,' '), 9)

Line 684: ||DECODE(igf_sl_gen.get_person_phone(l_lor_details.p_person_id),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(l_lor_details.p_person_id),10,0)) -- #10 ######## p_phone

680: ||RPAD(NVL(UPPER(parent_dtl_rec.p_permt_addr1)||' '||UPPER(parent_dtl_rec.p_permt_addr2),' ') ,35)
681: ||RPAD(NVL(UPPER(parent_dtl_rec.p_permt_city),' ') ,16)
682: ||RPAD(NVL(UPPER(parent_dtl_rec.p_permt_state),' ') ,2) -- Should be valid 2 digit code
683: ||RPAD(NVL(parent_dtl_rec.p_permt_zip,' ') ,9)
684: ||DECODE(igf_sl_gen.get_person_phone(l_lor_details.p_person_id),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(l_lor_details.p_person_id),10,0)) -- #10 ######## p_phone
685: ||RPAD(' ',22)
686: ||RPAD(NVL(TO_CHAR(parent_dtl_rec.p_date_of_birth,'YYYYMMDD'),' '),8)
687: ||LPAD(NVL(parent_dtl_rec.p_citizenship_status,' ') , 1)
688: ||LPAD(NVL(parent_dtl_rec.p_alien_reg_num,' ') ,9)

Line 745: ||DECODE(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(l_lor_details.base_id)),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(l_lor_details.base_id)),10,0))

741: ||RPAD(NVL(UPPER(student_dtl_rec.p_permt_addr1)||' '||UPPER(student_dtl_rec.p_permt_addr2),' ') ,35)
742: ||RPAD(NVL(UPPER(student_dtl_rec.p_permt_city) ,' '),16)
743: ||RPAD(NVL(UPPER(student_dtl_rec.p_permt_state) ,' '), 2)
744: ||RPAD(NVL(student_dtl_rec.p_permt_zip ,' '), 9)
745: ||DECODE(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(l_lor_details.base_id)),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(l_lor_details.base_id)),10,0))
746: ||RPAD(' ', 22)-- Filler for ED use. Bug # 2758823
747: ||RPAD(NVL(TO_CHAR(student_dtl_rec.p_date_of_birth,'YYYYMMDD'),' '),8)
748: ||LPAD(' ', 1)
749: ||LPAD(NVL(l_lor_details.alien_reg_number ,' '), 9)

Line 807: ||DECODE(igf_sl_gen.get_person_phone(l_lor_details.p_person_id),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(l_lor_details.p_person_id),10,0))

803: ||RPAD(NVL(UPPER(parent_dtl_rec.p_permt_addr1)||' '||UPPER(parent_dtl_rec.p_permt_addr2),' ') ,35)
804: ||RPAD(NVL(UPPER(parent_dtl_rec.p_permt_city),' ') ,16)
805: ||RPAD(NVL(UPPER(parent_dtl_rec.p_permt_state),' ') ,2) -- Should be valid 2 digit code
806: ||RPAD(NVL(parent_dtl_rec.p_permt_zip,' ') ,9)
807: ||DECODE(igf_sl_gen.get_person_phone(l_lor_details.p_person_id),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(l_lor_details.p_person_id),10,0))
808: ||RPAD(' ', 22)-- Filler for ED use. Bug # 2758823
809: ||RPAD(NVL(TO_CHAR(parent_dtl_rec.p_date_of_birth,'YYYYMMDD'),' '),8)
810: ||LPAD(NVL(parent_dtl_rec.p_citizenship_status,' ') , 1)
811: ||LPAD(NVL(parent_dtl_rec.p_alien_reg_num,' ') ,9)