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

Line 297: cosigner_dtl_cur igf_sl_gen.person_dtl_cur;

293:
294: l_alt_borw_rec alt_borw_cur%ROWTYPE;
295: lv_rowid ROWID;
296: l_albw_id igf_sl_alt_borw.albw_id%TYPE;
297: cosigner_dtl_cur igf_sl_gen.person_dtl_cur;
298: cosigner_dtl_rec igf_sl_gen.person_dtl_rec;
299: l_person_phone VARCHAR2(30);
300:
301: BEGIN

Line 298: cosigner_dtl_rec igf_sl_gen.person_dtl_rec;

294: l_alt_borw_rec alt_borw_cur%ROWTYPE;
295: lv_rowid ROWID;
296: l_albw_id igf_sl_alt_borw.albw_id%TYPE;
297: cosigner_dtl_cur igf_sl_gen.person_dtl_cur;
298: cosigner_dtl_rec igf_sl_gen.person_dtl_rec;
299: l_person_phone VARCHAR2(30);
300:
301: BEGIN
302:

Line 303: igf_sl_gen.get_person_details(p_person_id, cosigner_dtl_cur);

299: l_person_phone VARCHAR2(30);
300:
301: BEGIN
302:
303: igf_sl_gen.get_person_details(p_person_id, cosigner_dtl_cur);
304: FETCH cosigner_dtl_cur INTO cosigner_dtl_rec;
305: CLOSE cosigner_dtl_cur;
306: l_person_phone := igf_sl_gen.get_person_phone(p_person_id);
307:

Line 306: l_person_phone := igf_sl_gen.get_person_phone(p_person_id);

302:
303: igf_sl_gen.get_person_details(p_person_id, cosigner_dtl_cur);
304: FETCH cosigner_dtl_cur INTO cosigner_dtl_rec;
305: CLOSE cosigner_dtl_cur;
306: l_person_phone := igf_sl_gen.get_person_phone(p_person_id);
307:
308: OPEN alt_borw_cur (cp_loan_id => p_loan_id);
309: FETCH alt_borw_cur INTO l_alt_borw_rec;
310: CLOSE alt_borw_cur;

Line 555: igf_sl_gen.get_stu_fao_code(

551: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.get_dl_entity_id.debug','Entry p_base_id, p_cal_type, p_seq_num ' || p_base_id || ' : ' || p_cal_type || ' : ' || p_seq_num);
552: END IF;
553:
554: -- Get attending Pell Id from Org Setup.
555: igf_sl_gen.get_stu_fao_code(
556: p_base_id => p_base_id,
557: p_office_type => 'ENTITY_ID',
558: x_office_cd => p_atd_entity_id_txt,
559: x_return_status => l_ret_status,

Line 797: IF igf_sl_gen.chk_dl_fed_fund_code(award_rec.fed_fund_code) = 'TRUE' THEN

793: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
794: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.ret_loan_number.debug','Entry ret_loan_number');
795: END IF;
796:
797: IF igf_sl_gen.chk_dl_fed_fund_code(award_rec.fed_fund_code) = 'TRUE' THEN
798:
799: -- Direct Loan's Loan Number
800: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
801: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.ret_loan_number.debug','DL Loan Number Step 1');

Line 814: igf_sl_gen.get_stu_fao_code(p_base_id, 'DL_SCH_CD', x_dlsch_cd, x_return_status, x_msg_data);

810: l_ssn:=NULL;
811: l_ssn := igf_gr_gen.get_ssn_digits(award_rec.ssn);
812:
813: -- Bug 3102439. To get School ID for Direct Loan.
814: igf_sl_gen.get_stu_fao_code(p_base_id, 'DL_SCH_CD', x_dlsch_cd, x_return_status, x_msg_data);
815: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
816: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.ret_loan_number.debug','after get DL SCHOOL CODE');
817: END IF;
818: IF (x_return_status = 'E') THEN

Line 846: ELSIF igf_sl_gen.chk_cl_fed_fund_code(award_rec.fed_fund_code) = 'TRUE' THEN

842: CLOSE cur_loan_num;
843: END IF;
844:
845:
846: ELSIF igf_sl_gen.chk_cl_fed_fund_code(award_rec.fed_fund_code) = 'TRUE' THEN
847:
848: -- CommonLine Loan's Loan Number
849: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
850: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.ret_loan_number.debug','FFEL Loan Number Step 1');

Line 856: lv_incr_seq_char := igf_sl_gen.base10_to_base36(lv_incr_seq);

852:
853: -- Range is 1 to 46655. So, RECYCLE option should be provided.
854: SELECT igf_sl_cl_loan_seq_s.NEXTVAL into lv_incr_seq FROM DUAL;
855:
856: lv_incr_seq_char := igf_sl_gen.base10_to_base36(lv_incr_seq);
857:
858: -- Bug 3102439. To get OPE ID.
859: igf_sl_gen.get_stu_fao_code(p_base_id, 'OPE_ID_NUM', x_ope_cd, x_return_status, x_msg_data);
860: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 859: igf_sl_gen.get_stu_fao_code(p_base_id, 'OPE_ID_NUM', x_ope_cd, x_return_status, x_msg_data);

855:
856: lv_incr_seq_char := igf_sl_gen.base10_to_base36(lv_incr_seq);
857:
858: -- Bug 3102439. To get OPE ID.
859: igf_sl_gen.get_stu_fao_code(p_base_id, 'OPE_ID_NUM', x_ope_cd, x_return_status, x_msg_data);
860: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
861: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.ret_loan_number.debug','FFEL Loan Number Step 2 x_ope_cd ' || x_ope_cd);
862: END IF;
863: IF (x_return_status = 'E') THEN

Line 871: igf_sl_gen.get_stu_fao_code(p_base_id, 'SCH_NON_ED_BRC_ID', x_sch_non_ed_brc_cd, x_return_status, x_msg_data);

867: RAISE SKIP_THIS_RECORD;
868: END IF;
869:
870: -- Bug 3102439. To get SCH_NON_ED_BRC_ID.
871: igf_sl_gen.get_stu_fao_code(p_base_id, 'SCH_NON_ED_BRC_ID', x_sch_non_ed_brc_cd, x_return_status, x_msg_data);
872: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
873: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.ret_loan_number.debug','FFEL Loan Number Step 3 x_sch_non_ed_brc_cd ' || x_sch_non_ed_brc_cd ||' : x_msg_data ' || x_msg_data);
874: END IF;
875: IF (x_return_status = 'E') THEN

Line 1309: IF igf_sl_gen.chk_dl_stafford(award_rec.fed_fund_code) = 'TRUE' THEN

1305: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.insert_lor_dl_records.debug',' Acad Begin Date :' || lv_acad_begin_date);
1306: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.insert_lor_dl_records.debug',' Acad End Date :' || lv_acad_end_date);
1307: END IF;
1308:
1309: IF igf_sl_gen.chk_dl_stafford(award_rec.fed_fund_code) = 'TRUE' THEN
1310: lv_orig_fee_perct := dl_setup_rec.orig_fee_perct_stafford;
1311: ELSIF igf_sl_gen.chk_dl_plus(award_rec.fed_fund_code) = 'TRUE' THEN
1312: lv_orig_fee_perct := dl_setup_rec.orig_fee_perct_plus;
1313: END IF;

Line 1311: ELSIF igf_sl_gen.chk_dl_plus(award_rec.fed_fund_code) = 'TRUE' THEN

1307: END IF;
1308:
1309: IF igf_sl_gen.chk_dl_stafford(award_rec.fed_fund_code) = 'TRUE' THEN
1310: lv_orig_fee_perct := dl_setup_rec.orig_fee_perct_stafford;
1311: ELSIF igf_sl_gen.chk_dl_plus(award_rec.fed_fund_code) = 'TRUE' THEN
1312: lv_orig_fee_perct := dl_setup_rec.orig_fee_perct_plus;
1313: END IF;
1314:
1315:

Line 1316: IF igf_sl_gen.chk_dl_plus(award_rec.fed_fund_code) = 'TRUE' THEN -- Check if that is plus/alt loans and get parent id for the same.

1312: lv_orig_fee_perct := dl_setup_rec.orig_fee_perct_plus;
1313: END IF;
1314:
1315:
1316: IF igf_sl_gen.chk_dl_plus(award_rec.fed_fund_code) = 'TRUE' THEN -- Check if that is plus/alt loans and get parent id for the same.
1317: get_borrower_parent_id (
1318: p_loan_id => p_loan_id,
1319: p_parent_person_id => l_parent_person_id,
1320: p_student_person_id => l_student_person_id

Line 1623: alien_dtl_cur igf_sl_gen.person_dtl_cur;

1619:
1620: l_cur_borrower_rec cur_borrower_id%ROWTYPE;
1621: l_cur_fa_rec cur_fa_mapping%ROWTYPE;
1622: citizenship_dtl_rec citizenship_dtl_cur%ROWTYPE;
1623: alien_dtl_cur igf_sl_gen.person_dtl_cur;
1624: alien_dtl_rec igf_sl_gen.person_dtl_rec;
1625: l_b_alien_reg_num_txt igf_sl_lor_all.b_alien_reg_num_txt%TYPE;
1626: BEGIN
1627:

Line 1624: alien_dtl_rec igf_sl_gen.person_dtl_rec;

1620: l_cur_borrower_rec cur_borrower_id%ROWTYPE;
1621: l_cur_fa_rec cur_fa_mapping%ROWTYPE;
1622: citizenship_dtl_rec citizenship_dtl_cur%ROWTYPE;
1623: alien_dtl_cur igf_sl_gen.person_dtl_cur;
1624: alien_dtl_rec igf_sl_gen.person_dtl_rec;
1625: l_b_alien_reg_num_txt igf_sl_lor_all.b_alien_reg_num_txt%TYPE;
1626: BEGIN
1627:
1628: -- Origination_Id will be populated from Sequence.

Line 1798: igf_sl_gen.get_person_details(l_parent_person_id, alien_dtl_cur); --get Alein reg number

1794: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.insert_lor_cl_records.debug','Borrower Alein reg number is ' || l_cur_fa_rec.fa_citi_stat_code);
1795: END IF;
1796:
1797: IF NVL(l_cur_fa_rec.fa_citi_stat_code,'*') = '2' THEN
1798: igf_sl_gen.get_person_details(l_parent_person_id, alien_dtl_cur); --get Alein reg number
1799: FETCH alien_dtl_cur INTO alien_dtl_rec;
1800: IF alien_dtl_cur%FOUND THEN
1801: l_b_alien_reg_num_txt := alien_dtl_rec.p_alien_reg_num;
1802: END IF;

Line 2063: alien_dtl_cur igf_sl_gen.person_dtl_cur;

2059: citizenship_dtl_rec citizenship_dtl_cur%ROWTYPE;
2060: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
2061: l_party_id igf_sl_cl_setup.party_id%TYPE;
2062: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
2063: alien_dtl_cur igf_sl_gen.person_dtl_cur;
2064: alien_dtl_rec igf_sl_gen.person_dtl_rec;
2065:
2066: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
2067: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;

Line 2064: alien_dtl_rec igf_sl_gen.person_dtl_rec;

2060: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
2061: l_party_id igf_sl_cl_setup.party_id%TYPE;
2062: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
2063: alien_dtl_cur igf_sl_gen.person_dtl_cur;
2064: alien_dtl_rec igf_sl_gen.person_dtl_rec;
2065:
2066: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
2067: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
2068: lv_message VARCHAR2(100);

Line 2264: igf_sl_gen.get_person_details(l_cur_borrower_rec.p_person_id, alien_dtl_cur); --get Alein reg number

2260: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2261: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.update_loan_rec.debug','Borrower Alein reg number is ' || l_cur_fa_rec.fa_citi_stat_code);
2262: END IF;
2263: IF NVL(l_cur_fa_rec.fa_citi_stat_code,'*') = '2' THEN
2264: igf_sl_gen.get_person_details(l_cur_borrower_rec.p_person_id, alien_dtl_cur); --get Alein reg number
2265: FETCH alien_dtl_cur INTO alien_dtl_rec;
2266: IF alien_dtl_cur%FOUND THEN
2267: l_tbh_rec.b_alien_reg_num_txt := alien_dtl_rec.p_alien_reg_num;
2268: END IF;

Line 2797: IF igf_sl_gen.chk_dl_fed_fund_code(award_rec.fed_fund_code) = 'TRUE' THEN

2793: -- If the Award is a Loan and has a Fund-Source of FEDERAL, then
2794: -- Payment ISIR record should be present in the system for the Student.
2795: -- Else, the Loan Application record should not be created.
2796:
2797: IF igf_sl_gen.chk_dl_fed_fund_code(award_rec.fed_fund_code) = 'TRUE' THEN
2798: log_message(award_rec.award_id);
2799: IF gn_transaction_num IS NULL THEN
2800: fnd_message.set_name('IGF','IGF_AP_NOPAYMENT_ISIR');
2801: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 2952: IF igf_sl_gen.chk_dl_fed_fund_code(award_rec.fed_fund_code) = 'TRUE' THEN

2948: END IF;
2949:
2950: -- Procedure call for Inserting Origination Records into IGF_SL_LOR
2951:
2952: IF igf_sl_gen.chk_dl_fed_fund_code(award_rec.fed_fund_code) = 'TRUE' THEN
2953: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2954: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.insert_loan_records.debug',' calling insert_lor_dl_records');
2955: END IF;
2956: insert_lor_dl_records(p_ci_cal_type, p_ci_sequence_number, ln_loan_id);

Line 2958: ELSIF igf_sl_gen.chk_cl_fed_fund_code(award_rec.fed_fund_code) = 'TRUE' THEN

2954: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.insert_loan_records.debug',' calling insert_lor_dl_records');
2955: END IF;
2956: insert_lor_dl_records(p_ci_cal_type, p_ci_sequence_number, ln_loan_id);
2957:
2958: ELSIF igf_sl_gen.chk_cl_fed_fund_code(award_rec.fed_fund_code) = 'TRUE' THEN
2959: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2960: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.insert_loan_records.debug',' calling insert_lor_cl_records ');
2961: END IF;
2962: insert_lor_cl_records(p_ci_cal_type, p_ci_sequence_number, ln_loan_id, g_anticip_compl_date, g_grade_level_cl);

Line 3382: p_incr_date_code := igf_sl_gen.base10_to_base36(lv_incr_date);

3378: CLOSE cur_cl_setup;
3379:
3380: -- Base 36 Date Code for CommonLine Loan Number
3381: SELECT TO_CHAR(SYSDATE,'DDDYY') INTO lv_incr_date FROM DUAL;
3382: p_incr_date_code := igf_sl_gen.base10_to_base36(lv_incr_date);
3383:
3384: -- fa134
3385: IF p_base_id IS NOT NULL AND
3386: ( igf_gr_gen.get_per_num(p_base_id) IS NULL OR