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_LOANS

Line 9: -- Purpose : To Insert Loan Records into IGF_SL_LOANS

5: --
6: ------------------------------------------------------------------------
7: -- Created By : mesriniv
8: -- Date Created By : 2000/11/13
9: -- Purpose : To Insert Loan Records into IGF_SL_LOANS
10: ------------------------------------------------------------------------
11: -- Who When What
12: ------------------------------------------------------------------------------------------------------------
13: azmohamm 03-AUG-2006 FA163

Line 92: -- igf_sl_loans_pkg

88: -- igs_pr_css_class_std_v.class_standing%TYPE and
89: -- igf_ap_fa_base_h.enrl_program_type%TYPE with igs_ps_ver_all.course_type%TYPE.
90: -- gmuralid 3-Juyl-2003 Bug 2995944 - Legacy Part 3 - FFELP Import
91: -- Added legacy record flag as parameter to
92: -- igf_sl_loans_pkg
93: ------------------------------------------------------------------------
94: -- sjadhav 28-Mar-2003 Bug 2863960
95: -- Corrected message token for
96: -- IGF_AP_NO_GRADE_LEVEL to PERSON_NUMBER

Line 173: p_loan_id IN igf_sl_loans.loan_id%TYPE,

169: g_student_person_id NUMBER; -- Bug # 4636920 - bvisvana
170:
171:
172: PROCEDURE get_borrower_parent_id (
173: p_loan_id IN igf_sl_loans.loan_id%TYPE,
174: p_parent_person_id IN OUT NOCOPY NUMBER,
175: p_student_person_id IN OUT NOCOPY NUMBER
176: ) IS
177: -- takes loan_id, return parentid and parent_details for single associated parent for the student

Line 185: CURSOR parent_id_cur (cp_loan_id igf_sl_loans_all.loan_id%TYPE) IS

181: bvisvana 25-Aug-2005 Bug 4127532 - Placed p_student_person_id assignment after the IF condition
182: since we need the student id for ALT loans (student = borrower) irrespective of single parent or not
183: For FLP and DLP only parent is needed and hence if only one parent, that parent_id is returned, else NULL
184: ***************************************************************/
185: CURSOR parent_id_cur (cp_loan_id igf_sl_loans_all.loan_id%TYPE) IS
186: SELECT
187: COUNT(v.row_id) parent_count,
188: MIN(v.object_ID) student_id,
189: MIN(v.SUBJECT_ID) parent_id

Line 193: igf_sl_loans_all loans,

189: MIN(v.SUBJECT_ID) parent_id
190: FROM
191: igs_pe_relationships_v v,
192: igf_aw_award_all awd,
193: igf_sl_loans_all loans,
194: igf_ap_fa_base_rec base
195: WHERE
196: base.person_id = v.object_id
197: AND base.base_id = awd.base_id

Line 236: PROCEDURE populate_cosigner_data (p_loan_id igf_sl_loans_all.loan_id%TYPE,

232: app_exception.raise_exception;
233: END get_borrower_parent_id;
234:
235:
236: PROCEDURE populate_cosigner_data (p_loan_id igf_sl_loans_all.loan_id%TYPE,
237: p_person_id NUMBER) IS
238: /*
239: Change History
240: Who When What

Line 740: FUNCTION ret_loan_number(p_loan_seq_number IN igf_sl_loans.seq_num%TYPE,

736:
737: END log_message;
738:
739:
740: FUNCTION ret_loan_number(p_loan_seq_number IN igf_sl_loans.seq_num%TYPE,
741: p_base_id IN igf_aw_award_v.base_id%TYPE)
742: RETURN VARCHAR2
743: IS
744: /***************************************************************

Line 773: lv_loan_number igf_sl_loans_all.loan_number%TYPE;

769: ***************************************************************/
770:
771: lv_loan_type VARCHAR2(100);
772: lv_loan_yr VARCHAR2(2);
773: lv_loan_number igf_sl_loans_all.loan_number%TYPE;
774: lv_incr_seq NUMBER;
775: lv_incr_seq_char VARCHAR2(100);
776: l_ssn igf_ap_isir_matched_all.current_ssn%TYPE;
777:

Line 784: CURSOR cur_loan_num (p_loan_number igf_sl_loans_all.loan_number%TYPE) IS

780: x_dlsch_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
781: x_ope_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
782: x_sch_non_ed_brc_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
783:
784: CURSOR cur_loan_num (p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
785: SELECT rowid
786: FROM igf_sl_loans_all
787: WHERE loan_number = p_loan_number;
788:

Line 786: FROM igf_sl_loans_all

782: x_sch_non_ed_brc_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
783:
784: CURSOR cur_loan_num (p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
785: SELECT rowid
786: FROM igf_sl_loans_all
787: WHERE loan_number = p_loan_number;
788:
789: loan_num_rec cur_loan_num%ROWTYPE;
790:

Line 1248: p_loan_id IN igf_sl_loans.loan_id%TYPE

1244:
1245: PROCEDURE insert_lor_dl_records(
1246: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1247: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1248: p_loan_id IN igf_sl_loans.loan_id%TYPE
1249: )AS
1250: /***************************************************************
1251: Created By : mesriniv
1252: Date Created By : 2000/11/13

Line 1265: FROM IGF_SL_LOANS_ALL lar

1261: pnote_status
1262: ***************************************************************/
1263: CURSOR getloannumber (cp_loan_id NUMBER) is
1264: SELECT LOAN_NUMBER
1265: FROM IGF_SL_LOANS_ALL lar
1266: WHERE lar.LOAN_ID = cp_loan_id;
1267:
1268: lv_row_id ROWID;
1269: ln_origination_id igf_sl_lor_all.origination_id%TYPE;

Line 1474: p_loan_id IN igf_sl_loans.loan_id%TYPE,

1470:
1471: PROCEDURE insert_lor_cl_records(
1472: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1473: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1474: p_loan_id IN igf_sl_loans.loan_id%TYPE,
1475: p_comp_date IN igf_sl_lor.anticip_compl_date%TYPE,
1476: p_grd_cl IN igf_sl_lor.grade_level_code%TYPE
1477: )AS
1478:

Line 1543: ln_cur_loan_id igf_sl_loans.loan_id%TYPE;

1539: lv_enrollment_code igf_sl_lor.enrollment_code%TYPE;
1540: lv_anticipated_compl_date DATE;
1541: lv_row_id ROWID;
1542:
1543: ln_cur_loan_id igf_sl_loans.loan_id%TYPE;
1544: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
1545: l_party_id igf_sl_cl_setup.party_id%TYPE;
1546: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
1547: l_loan_status VARCHAR2(30);

Line 1552: cp_loan_id igf_sl_loans.loan_id%TYPE

1548:
1549:
1550: -- cursor to get the base id from the loan id
1551: CURSOR c_get_base_id (
1552: cp_loan_id igf_sl_loans.loan_id%TYPE
1553: ) IS
1554: SELECT awd.base_id, awd.award_id
1555: FROM igf_sl_loans_all loans,
1556: igf_aw_award_all awd

Line 1555: FROM igf_sl_loans_all loans,

1551: CURSOR c_get_base_id (
1552: cp_loan_id igf_sl_loans.loan_id%TYPE
1553: ) IS
1554: SELECT awd.base_id, awd.award_id
1555: FROM igf_sl_loans_all loans,
1556: igf_aw_award_all awd
1557: WHERE loans.loan_id = cp_loan_id
1558: AND loans.award_id = awd.award_id;
1559:

Line 1586: SELECT * FROM igf_sl_loans

1582:
1583: l_disb_count NUMBER;
1584:
1585: CURSOR c_tbh_loans_cur (cp_loanid NUMBER) IS
1586: SELECT * FROM igf_sl_loans
1587: WHERE loan_id = cp_loanid;
1588:
1589: l_tbh_loans_rec c_tbh_loans_cur%ROWTYPE;
1590:

Line 1722: igf_sl_loans_pkg.update_row (

1718: p_student_person_id => l_student_person_id
1719: );
1720: END IF; -- END Check if that is plus/alt loans and get parent id for the same.
1721:
1722: igf_sl_loans_pkg.update_row (
1723: x_mode => 'R',
1724: x_rowid => l_tbh_loans_rec.row_id,
1725: x_loan_id => l_tbh_loans_rec.loan_id,
1726: x_award_id => l_tbh_loans_rec.award_id,

Line 2000: FROM igf_sl_loans_all loan,

1996: awd.award_status,
1997: awd.accepted_amt,
1998: fmast.ci_cal_type,
1999: fmast.ci_sequence_number
2000: FROM igf_sl_loans_all loan,
2001: igf_aw_award_all awd,
2002: igf_aw_fund_mast_all fmast,
2003: igf_aw_fund_cat_all fcat,
2004: igf_ap_fa_base_rec_all fa

Line 2027: SELECT * FROM igf_sl_loans

2023:
2024: l_tbh_rec igf_sl_lor%ROWTYPE;
2025:
2026: CURSOR c_tbh_loans_cur (cp_loanid NUMBER) IS
2027: SELECT * FROM igf_sl_loans
2028: WHERE loan_id = cp_loanid;
2029:
2030: l_tbh_loans_rec c_tbh_loans_cur%ROWTYPE;
2031:

Line 2078: igf_sl_loans_all loans,

2074: 'X'
2075: FROM
2076: igs_pe_relationships_v v,
2077: igf_aw_award_all awd,
2078: igf_sl_loans_all loans,
2079: igf_ap_fa_base_rec base
2080: WHERE
2081: base.person_id = v.object_ID
2082: AND base.base_id = awd.base_id

Line 2284: igf_sl_loans_pkg.update_row (

2280: l_tbh_loans_rec.loan_status := 'G';
2281: END IF;
2282:
2283:
2284: igf_sl_loans_pkg.update_row (
2285: x_mode => 'R',
2286: x_rowid => l_tbh_loans_rec.row_id,
2287: x_loan_id => l_tbh_loans_rec.loan_id,
2288: x_award_id => l_tbh_loans_rec.award_id,

Line 2339: igf_sl_loans_pkg.update_row (

2335: -- Update Loan Change Status to "Ready to Send" and loan period
2336: l_tbh_loans_rec.loan_chg_status := 'G';
2337: END IF;
2338:
2339: igf_sl_loans_pkg.update_row (
2340: x_mode => 'R',
2341: x_rowid => l_tbh_loans_rec.row_id,
2342: x_loan_id => l_tbh_loans_rec.loan_id,
2343: x_award_id => l_tbh_loans_rec.award_id,

Line 2624: FROM igf_sl_loans_all loans )

2620: AND awdv.base_id = NVL(p_base_id, awdv.base_id) -- fa134
2621: AND awdv.award_status = 'ACCEPTED'
2622: AND awdv.fed_fund_code IN ('DLP','DLS','DLU','FLP','FLS','FLU','ALT','GPLUSFL')
2623: AND awdv.award_id NOT IN ( SELECT loans.award_id
2624: FROM igf_sl_loans_all loans )
2625: ORDER BY awdv.award_id;
2626:
2627: lv_isir_present BOOLEAN ;
2628:

Line 2632: ln_seq_number igf_sl_loans_all.seq_num%TYPE;

2628:
2629: lb_print_dl BOOLEAN;
2630: lb_print_cl BOOLEAN;
2631:
2632: ln_seq_number igf_sl_loans_all.seq_num%TYPE;
2633: l_msg_name fnd_new_messages.message_name%TYPE;
2634: l_aid NUMBER;
2635: l_loan_tab igf_aw_packng_subfns.std_loan_tab;
2636:

Line 2644: igf_sl_loans_all loan,

2640:
2641: CURSOR cur_count_fed_code IS
2642: SELECT COUNT(*) + 1
2643: FROM
2644: igf_sl_loans_all loan,
2645: igf_aw_award_all awd,
2646: igf_aw_fund_mast_all fmast,
2647: igf_aw_fund_cat_all fcat,
2648: igf_ap_fa_base_rec_all fabase

Line 2659: lv_loan_number igf_sl_loans_all.loan_number%TYPE;

2655: fabase.ci_sequence_number = award_rec.ci_sequence_number AND
2656: fabase.person_id = award_rec.student_id AND
2657: fcat.fed_fund_code = award_rec.fed_fund_code;
2658:
2659: lv_loan_number igf_sl_loans_all.loan_number%TYPE;
2660:
2661: lv_row_id ROWID;
2662: ln_loan_id igf_sl_loans_all.loan_id%TYPE;
2663: l_head VARCHAR2(1);

Line 2662: ln_loan_id igf_sl_loans_all.loan_id%TYPE;

2658:
2659: lv_loan_number igf_sl_loans_all.loan_number%TYPE;
2660:
2661: lv_row_id ROWID;
2662: ln_loan_id igf_sl_loans_all.loan_id%TYPE;
2663: l_head VARCHAR2(1);
2664: l_found_loans VARCHAR2(1);
2665: l_fund_type VARCHAR2(10);
2666:

Line 2901: -- Insert these values into the IGF_SL_LOANS Table

2897:
2898: -- To assign value of Loan Number using function
2899: lv_loan_number := NULL;
2900: lv_loan_number := ret_loan_number(ln_seq_number, award_rec.base_id);
2901: -- Insert these values into the IGF_SL_LOANS Table
2902:
2903: g_accepted_amt := award_rec.accepted_amt;
2904: gn_award_id := award_rec.award_id;
2905: -- bvisvana - Bug # 4575843 - Before creating the loan record check whether the award accepted amount is in whole numbers

Line 2920: -- Modified the call of the IGF_SL_LOANS_PKG.INSERT_ROW to include the

2916: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.insert_loan_records.debug',' gn_award_id ' || gn_award_id);
2917: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.insert_loan_records.debug',' g_accepted_amt : ' || g_accepted_amt);
2918: END IF;
2919:
2920: -- Modified the call of the IGF_SL_LOANS_PKG.INSERT_ROW to include the
2921: -- borrower determination code as part of Refunds DLD 2144600
2922:
2923: lv_row_id := NULL;
2924: ln_loan_id := NULL;

Line 2926: igf_sl_loans_pkg.insert_row (

2922:
2923: lv_row_id := NULL;
2924: ln_loan_id := NULL;
2925:
2926: igf_sl_loans_pkg.insert_row (
2927: x_mode => 'R',
2928: x_rowid => lv_row_id,
2929: x_loan_id => ln_loan_id,
2930: x_award_id => award_rec.award_id,

Line 3003: fnd_message.set_name('IGF','IGF_SL_LOANS_CREATED');

2999: -- Display appropriate message if Loans records are created
3000:
3001: IF l_found_loans ='Y' THEN
3002: --Loan Application Records created
3003: fnd_message.set_name('IGF','IGF_SL_LOANS_CREATED');
3004: fnd_file.put_line(fnd_file.log,fnd_message.get);
3005: fnd_file.new_line(fnd_file.log,2);
3006: ELSIF l_found_loans ='N' THEN
3007: --Loan Application not created

Line 3111: IGF_SL_LOANS

3107: /***************************************************************
3108: Created By : mesriniv
3109: Date Created By : 2000/11/13
3110: Purpose : To arrive at the default values for the various columns in
3111: IGF_SL_LOANS
3112: Known Limitations,Enhancements or Remarks
3113: Change History :
3114: Bug 2367953 Modify Parameters in Loans Process
3115: Who When What

Line 3147: agairola 15-Mar-2002 Modified the call for the IGF_SL_LOANS_PKG.Insert_Row

3143: 3.Added code to print list of person numbers having got the loan and details
3144: in Output File
3145: Bug No : 1978873
3146: Who When What
3147: agairola 15-Mar-2002 Modified the call for the IGF_SL_LOANS_PKG.Insert_Row
3148: for Borrower Determination Code as part of Refunds DLD
3149: Enhancement No: 2144600
3150: ENH Bug No : 1806850 Bug Desc: Awards Build for Nov 2001 Rel
3151: Who When What

Line 3162: lv_loan_number igf_sl_loans_all.loan_number%TYPE;

3158:
3159: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
3160: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
3161:
3162: lv_loan_number igf_sl_loans_all.loan_number%TYPE;
3163:
3164: lv_loan_status igf_sl_loans_all.loan_status%TYPE;
3165:
3166: lv_row_id ROWID;

Line 3164: lv_loan_status igf_sl_loans_all.loan_status%TYPE;

3160: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
3161:
3162: lv_loan_number igf_sl_loans_all.loan_number%TYPE;
3163:
3164: lv_loan_status igf_sl_loans_all.loan_status%TYPE;
3165:
3166: lv_row_id ROWID;
3167: lv_incr_date NUMBER;
3168: l_found_loans VARCHAR2(1);