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_LOR

Line 55: in igf_sl_lor_all table and obsoleting

51: Similarly, OPE ID and School Non Ed Brc ID are also derived for Common Line Loan.
52: --veramach 16-OCT-2003 FA124 Build remove ISIR requirement for awarding(bug # 3108506)
53: -- Added code for checking loan limits in insert_loan_records
54: -- bkkumar 06-oct-2003 Bug 3104228 Impact of adding the relationship_cd
55: in igf_sl_lor_all table and obsoleting
56: BORW_LENDER_ID,
57: DUNS_BORW_LENDER_ID,
58: GUARANTOR_ID,
59: DUNS_GUARNT_ID,

Line 135: g_s_default_status igf_sl_lor_all.s_default_status%TYPE;

131: dl_setup_rec igf_sl_dl_setup_all%ROWTYPE;
132: cl_setup_rec igf_sl_cl_setup_all%ROWTYPE;
133: p_incr_date_code VARCHAR2(100);
134:
135: g_s_default_status igf_sl_lor_all.s_default_status%TYPE;
136: g_p_default_status igf_sl_lor_all.p_default_status%TYPE;
137: g_grade_level_dl igf_sl_lor_all.grade_level_code%TYPE;
138: g_grade_level_cl igf_sl_lor_all.grade_level_code%TYPE;
139: g_anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE;

Line 136: g_p_default_status igf_sl_lor_all.p_default_status%TYPE;

132: cl_setup_rec igf_sl_cl_setup_all%ROWTYPE;
133: p_incr_date_code VARCHAR2(100);
134:
135: g_s_default_status igf_sl_lor_all.s_default_status%TYPE;
136: g_p_default_status igf_sl_lor_all.p_default_status%TYPE;
137: g_grade_level_dl igf_sl_lor_all.grade_level_code%TYPE;
138: g_grade_level_cl igf_sl_lor_all.grade_level_code%TYPE;
139: g_anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE;
140: g_enrollment_code igf_sl_lor_all.enrollment_code%TYPE;

Line 137: g_grade_level_dl igf_sl_lor_all.grade_level_code%TYPE;

133: p_incr_date_code VARCHAR2(100);
134:
135: g_s_default_status igf_sl_lor_all.s_default_status%TYPE;
136: g_p_default_status igf_sl_lor_all.p_default_status%TYPE;
137: g_grade_level_dl igf_sl_lor_all.grade_level_code%TYPE;
138: g_grade_level_cl igf_sl_lor_all.grade_level_code%TYPE;
139: g_anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE;
140: g_enrollment_code igf_sl_lor_all.enrollment_code%TYPE;
141: gv_return_status VARCHAR2(30);

Line 138: g_grade_level_cl igf_sl_lor_all.grade_level_code%TYPE;

134:
135: g_s_default_status igf_sl_lor_all.s_default_status%TYPE;
136: g_p_default_status igf_sl_lor_all.p_default_status%TYPE;
137: g_grade_level_dl igf_sl_lor_all.grade_level_code%TYPE;
138: g_grade_level_cl igf_sl_lor_all.grade_level_code%TYPE;
139: g_anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE;
140: g_enrollment_code igf_sl_lor_all.enrollment_code%TYPE;
141: gv_return_status VARCHAR2(30);
142: gv_message fnd_new_messages.message_text%TYPE;

Line 139: g_anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE;

135: g_s_default_status igf_sl_lor_all.s_default_status%TYPE;
136: g_p_default_status igf_sl_lor_all.p_default_status%TYPE;
137: g_grade_level_dl igf_sl_lor_all.grade_level_code%TYPE;
138: g_grade_level_cl igf_sl_lor_all.grade_level_code%TYPE;
139: g_anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE;
140: g_enrollment_code igf_sl_lor_all.enrollment_code%TYPE;
141: gv_return_status VARCHAR2(30);
142: gv_message fnd_new_messages.message_text%TYPE;
143: SKIP_THIS_RECORD EXCEPTION;

Line 140: g_enrollment_code igf_sl_lor_all.enrollment_code%TYPE;

136: g_p_default_status igf_sl_lor_all.p_default_status%TYPE;
137: g_grade_level_dl igf_sl_lor_all.grade_level_code%TYPE;
138: g_grade_level_cl igf_sl_lor_all.grade_level_code%TYPE;
139: g_anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE;
140: g_enrollment_code igf_sl_lor_all.enrollment_code%TYPE;
141: gv_return_status VARCHAR2(30);
142: gv_message fnd_new_messages.message_text%TYPE;
143: SKIP_THIS_RECORD EXCEPTION;
144:

Line 157: gv_unsub_elig_for_depnt igf_sl_lor.unsub_elig_for_depnt%TYPE;

153: gn_transaction_num igf_ap_isir_matched_all.transaction_num%TYPE;
154: gv_atd_entity_id_txt VARCHAR2(30);
155: gv_rep_entity_id_txt VARCHAR2(30);
156:
157: gv_unsub_elig_for_depnt igf_sl_lor.unsub_elig_for_depnt%TYPE;
158: gn_award_id igf_aw_awd_disb_all.award_id%TYPE;
159:
160: g_accepted_amt award_rec.accepted_amt%TYPE;
161:

Line 260: FROM igf_sl_lor_v slor

256:
257: CURSOR cal_type_cur (cp_loan_id igf_sl_alt_borw_all.loan_id%TYPE) IS
258: SELECT
259: slor.ci_cal_type, slor.ci_sequence_number
260: FROM igf_sl_lor_v slor
261: WHERE slor.loan_id = cp_loan_id;
262:
263: cal_type_rec cal_type_cur%ROWTYPE;
264:

Line 1046: p_grd_dl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,

1042: END get_dl_cl_std_code ;
1043:
1044:
1045: PROCEDURE return_entities ( P_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
1046: p_grd_dl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1047: p_enrl_stat OUT NOCOPY igf_sl_lor.enrollment_code%TYPE,
1048: p_grd_cl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1049: p_anticip_comp_date OUT NOCOPY igf_sl_lor.anticip_compl_date%TYPE) IS
1050: /***************************************************************

Line 1047: p_enrl_stat OUT NOCOPY igf_sl_lor.enrollment_code%TYPE,

1043:
1044:
1045: PROCEDURE return_entities ( P_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
1046: p_grd_dl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1047: p_enrl_stat OUT NOCOPY igf_sl_lor.enrollment_code%TYPE,
1048: p_grd_cl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1049: p_anticip_comp_date OUT NOCOPY igf_sl_lor.anticip_compl_date%TYPE) IS
1050: /***************************************************************
1051: Created By : kpadiyar

Line 1048: p_grd_cl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,

1044:
1045: PROCEDURE return_entities ( P_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
1046: p_grd_dl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1047: p_enrl_stat OUT NOCOPY igf_sl_lor.enrollment_code%TYPE,
1048: p_grd_cl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1049: p_anticip_comp_date OUT NOCOPY igf_sl_lor.anticip_compl_date%TYPE) IS
1050: /***************************************************************
1051: Created By : kpadiyar
1052: Date Created By : 2001/04/26

Line 1049: p_anticip_comp_date OUT NOCOPY igf_sl_lor.anticip_compl_date%TYPE) IS

1045: PROCEDURE return_entities ( P_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
1046: p_grd_dl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1047: p_enrl_stat OUT NOCOPY igf_sl_lor.enrollment_code%TYPE,
1048: p_grd_cl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1049: p_anticip_comp_date OUT NOCOPY igf_sl_lor.anticip_compl_date%TYPE) IS
1050: /***************************************************************
1051: Created By : kpadiyar
1052: Date Created By : 2001/04/26
1053: Purpose :

Line 1168: p_s_default_status OUT NOCOPY igf_sl_lor.s_default_status%TYPE,

1164: NULL;
1165: END return_entities;
1166:
1167: PROCEDURE get_fa_base_details(p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
1168: p_s_default_status OUT NOCOPY igf_sl_lor.s_default_status%TYPE,
1169: p_grade_dl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1170: p_grade_cl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1171: p_enroll_code OUT NOCOPY igf_sl_lor.enrollment_code%TYPE,
1172: p_isir_present OUT NOCOPY BOOLEAN,

Line 1169: p_grade_dl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,

1165: END return_entities;
1166:
1167: PROCEDURE get_fa_base_details(p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
1168: p_s_default_status OUT NOCOPY igf_sl_lor.s_default_status%TYPE,
1169: p_grade_dl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1170: p_grade_cl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1171: p_enroll_code OUT NOCOPY igf_sl_lor.enrollment_code%TYPE,
1172: p_isir_present OUT NOCOPY BOOLEAN,
1173: p_anticip_comp_date OUT NOCOPY igf_sl_lor.anticip_compl_date%TYPE,

Line 1170: p_grade_cl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,

1166:
1167: PROCEDURE get_fa_base_details(p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
1168: p_s_default_status OUT NOCOPY igf_sl_lor.s_default_status%TYPE,
1169: p_grade_dl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1170: p_grade_cl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1171: p_enroll_code OUT NOCOPY igf_sl_lor.enrollment_code%TYPE,
1172: p_isir_present OUT NOCOPY BOOLEAN,
1173: p_anticip_comp_date OUT NOCOPY igf_sl_lor.anticip_compl_date%TYPE,
1174: p_transaction_num OUT NOCOPY igf_ap_isir_matched_all.transaction_num%TYPE,

Line 1171: p_enroll_code OUT NOCOPY igf_sl_lor.enrollment_code%TYPE,

1167: PROCEDURE get_fa_base_details(p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
1168: p_s_default_status OUT NOCOPY igf_sl_lor.s_default_status%TYPE,
1169: p_grade_dl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1170: p_grade_cl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1171: p_enroll_code OUT NOCOPY igf_sl_lor.enrollment_code%TYPE,
1172: p_isir_present OUT NOCOPY BOOLEAN,
1173: p_anticip_comp_date OUT NOCOPY igf_sl_lor.anticip_compl_date%TYPE,
1174: p_transaction_num OUT NOCOPY igf_ap_isir_matched_all.transaction_num%TYPE,
1175: p_unsub_elig_for_depnt OUT NOCOPY igf_sl_lor.unsub_elig_for_depnt%TYPE

Line 1173: p_anticip_comp_date OUT NOCOPY igf_sl_lor.anticip_compl_date%TYPE,

1169: p_grade_dl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1170: p_grade_cl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1171: p_enroll_code OUT NOCOPY igf_sl_lor.enrollment_code%TYPE,
1172: p_isir_present OUT NOCOPY BOOLEAN,
1173: p_anticip_comp_date OUT NOCOPY igf_sl_lor.anticip_compl_date%TYPE,
1174: p_transaction_num OUT NOCOPY igf_ap_isir_matched_all.transaction_num%TYPE,
1175: p_unsub_elig_for_depnt OUT NOCOPY igf_sl_lor.unsub_elig_for_depnt%TYPE
1176: )
1177: IS

Line 1175: p_unsub_elig_for_depnt OUT NOCOPY igf_sl_lor.unsub_elig_for_depnt%TYPE

1171: p_enroll_code OUT NOCOPY igf_sl_lor.enrollment_code%TYPE,
1172: p_isir_present OUT NOCOPY BOOLEAN,
1173: p_anticip_comp_date OUT NOCOPY igf_sl_lor.anticip_compl_date%TYPE,
1174: p_transaction_num OUT NOCOPY igf_ap_isir_matched_all.transaction_num%TYPE,
1175: p_unsub_elig_for_depnt OUT NOCOPY igf_sl_lor.unsub_elig_for_depnt%TYPE
1176: )
1177: IS
1178: /***************************************************************
1179: Created By : mesriniv

Line 1189: lv_s_default_status igf_sl_lor_all.s_default_status%TYPE;

1185: Change History :
1186: Who When What
1187: ***************************************************************/
1188:
1189: lv_s_default_status igf_sl_lor_all.s_default_status%TYPE;
1190: lv_match_flag igf_ap_isir_matched_all.nslds_match_flag%TYPE;
1191: lv_nslds_data_override_flg igf_ap_fa_base_rec_all.nslds_data_override_flg%TYPE;
1192: lv_adnl_unsub_loan_elig_flag igf_ap_fa_base_rec_all.adnl_unsub_loan_elig_flag%TYPE;
1193:

Line 1243: /* Procedure to insert Direct Loan Originations into IGF_SL_LOR */

1239: END get_fa_base_details;
1240:
1241:
1242:
1243: /* Procedure to insert Direct Loan Originations into IGF_SL_LOR */
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,

Line 1253: Purpose : To Insert Records into IGF_SL_LOR for DL Loans

1249: )AS
1250: /***************************************************************
1251: Created By : mesriniv
1252: Date Created By : 2000/11/13
1253: Purpose : To Insert Records into IGF_SL_LOR for DL Loans
1254: Known Limitations,Enhancements or Remarks
1255:
1256: Change History :
1257: Who When What

Line 1259: TBH impact change in igf_sl_lor_pkg.insert_row().

1255:
1256: Change History :
1257: Who When What
1258: bvisvana 10-Apr-2006 Build FA161.
1259: TBH impact change in igf_sl_lor_pkg.insert_row().
1260: pkpatel 12-05-2001 Given default value for the parameter
1261: pnote_status
1262: ***************************************************************/
1263: CURSOR getloannumber (cp_loan_id NUMBER) is

Line 1269: ln_origination_id igf_sl_lor_all.origination_id%TYPE;

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;
1270: ld_sch_cert_date DATE;
1271: lv_orig_fee_perct igf_sl_dl_setup_all.orig_fee_perct_stafford%TYPE;
1272: lv_match_flag igf_ap_isir_matched_all.nslds_match_flag%TYPE;
1273: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;

Line 1326: -- With these Default values need to insert data into igf_sl_lor table

1322: END IF; -- END Check if that is plus/alt loans and get parent id for the same.
1323:
1324:
1325:
1326: -- With these Default values need to insert data into igf_sl_lor table
1327: lv_row_id := NULL;
1328: ln_origination_id := NULL;
1329:
1330: igf_sl_lor_pkg.insert_row (

Line 1330: igf_sl_lor_pkg.insert_row (

1326: -- With these Default values need to insert data into igf_sl_lor table
1327: lv_row_id := NULL;
1328: ln_origination_id := NULL;
1329:
1330: igf_sl_lor_pkg.insert_row (
1331: x_mode => 'R',
1332: x_rowid => lv_row_id,
1333: x_origination_id => ln_origination_id,
1334: x_loan_id => p_loan_id,

Line 1469: /* Procedure to insert into IGF_SL_LOR for CL Loans*/

1465:
1466: END insert_lor_dl_records;
1467:
1468:
1469: /* Procedure to insert into IGF_SL_LOR for CL Loans*/
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,

Line 1475: p_comp_date IN igf_sl_lor.anticip_compl_date%TYPE,

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:
1479: /***************************************************************

Line 1476: p_grd_cl IN igf_sl_lor.grade_level_code%TYPE

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:
1479: /***************************************************************
1480: Created By : mesriniv

Line 1482: Purpose : To Insert Records into IGF_SL_LOR for CL Loans

1478:
1479: /***************************************************************
1480: Created By : mesriniv
1481: Date Created By : 2000/11/13
1482: Purpose : To Insert Records into IGF_SL_LOR for CL Loans
1483: Known Limitations,Enhancements or Remarks
1484:
1485: Change History :
1486: Who When What

Line 1490: So while inserting into igf_sl_lor_all table person_id has to be the student's party id.

1486: Who When What
1487: azmohamm 03-AUG-2006 For GPLUSFL, the new loan type would be 'GB'
1488: and the Federal application form Code would be 'G'.
1489: The borrower id is same as the student id.
1490: So while inserting into igf_sl_lor_all table person_id has to be the student's party id.
1491: rajagupt 10-Apr-2006 Bug# 5006583, FA161 CL4.
1492: cps_trans_num is inserted. deferment_request_code
1493: borw_interest_ind, borw_outstd_loan_code, p_default_status, s_default_status, stud_sign_ind
1494: are inserted with null and loan_app_form_code = 'Q' for FLP loans

Line 1520: in igf_sl_lor_all table and obsoleting

1516: DUNS_RECIP_ID -- OBSOLETED THIS FIELD
1517: RECIP_NON_ED_BRC_ID is now done from
1518: the FFELP loan Setup.
1519: bkkumar 06-oct-2003 Bug 3104228 Impact of adding the relationship_cd
1520: in igf_sl_lor_all table and obsoleting
1521: BORW_LENDER_ID,
1522: DUNS_BORW_LENDER_ID,
1523: GUARANTOR_ID,
1524: DUNS_GUARNT_ID,

Line 1534: ln_origination_id igf_sl_lor.origination_id%TYPE;

1530: pick_Setup routine.
1531: ***************************************************************/
1532:
1533:
1534: ln_origination_id igf_sl_lor.origination_id%TYPE;
1535: lv_cl_loan_type igf_sl_lor.cl_loan_type%TYPE;
1536: ld_sch_cert_date igf_sl_lor.sch_cert_date%TYPE;
1537: lv_s_default_status igf_sl_lor.s_default_status%TYPE;
1538: lv_grade_level_code igf_sl_lor.grade_level_code%TYPE;

Line 1535: lv_cl_loan_type igf_sl_lor.cl_loan_type%TYPE;

1531: ***************************************************************/
1532:
1533:
1534: ln_origination_id igf_sl_lor.origination_id%TYPE;
1535: lv_cl_loan_type igf_sl_lor.cl_loan_type%TYPE;
1536: ld_sch_cert_date igf_sl_lor.sch_cert_date%TYPE;
1537: lv_s_default_status igf_sl_lor.s_default_status%TYPE;
1538: lv_grade_level_code igf_sl_lor.grade_level_code%TYPE;
1539: lv_enrollment_code igf_sl_lor.enrollment_code%TYPE;

Line 1536: ld_sch_cert_date igf_sl_lor.sch_cert_date%TYPE;

1532:
1533:
1534: ln_origination_id igf_sl_lor.origination_id%TYPE;
1535: lv_cl_loan_type igf_sl_lor.cl_loan_type%TYPE;
1536: ld_sch_cert_date igf_sl_lor.sch_cert_date%TYPE;
1537: lv_s_default_status igf_sl_lor.s_default_status%TYPE;
1538: lv_grade_level_code igf_sl_lor.grade_level_code%TYPE;
1539: lv_enrollment_code igf_sl_lor.enrollment_code%TYPE;
1540: lv_anticipated_compl_date DATE;

Line 1537: lv_s_default_status igf_sl_lor.s_default_status%TYPE;

1533:
1534: ln_origination_id igf_sl_lor.origination_id%TYPE;
1535: lv_cl_loan_type igf_sl_lor.cl_loan_type%TYPE;
1536: ld_sch_cert_date igf_sl_lor.sch_cert_date%TYPE;
1537: lv_s_default_status igf_sl_lor.s_default_status%TYPE;
1538: lv_grade_level_code igf_sl_lor.grade_level_code%TYPE;
1539: lv_enrollment_code igf_sl_lor.enrollment_code%TYPE;
1540: lv_anticipated_compl_date DATE;
1541: lv_row_id ROWID;

Line 1538: lv_grade_level_code igf_sl_lor.grade_level_code%TYPE;

1534: ln_origination_id igf_sl_lor.origination_id%TYPE;
1535: lv_cl_loan_type igf_sl_lor.cl_loan_type%TYPE;
1536: ld_sch_cert_date igf_sl_lor.sch_cert_date%TYPE;
1537: lv_s_default_status igf_sl_lor.s_default_status%TYPE;
1538: lv_grade_level_code igf_sl_lor.grade_level_code%TYPE;
1539: lv_enrollment_code igf_sl_lor.enrollment_code%TYPE;
1540: lv_anticipated_compl_date DATE;
1541: lv_row_id ROWID;
1542:

Line 1539: lv_enrollment_code igf_sl_lor.enrollment_code%TYPE;

1535: lv_cl_loan_type igf_sl_lor.cl_loan_type%TYPE;
1536: ld_sch_cert_date igf_sl_lor.sch_cert_date%TYPE;
1537: lv_s_default_status igf_sl_lor.s_default_status%TYPE;
1538: lv_grade_level_code igf_sl_lor.grade_level_code%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;

Line 1591: l_appl_form_code igf_sl_lor_all.loan_app_form_code%TYPE;

1587: WHERE loan_id = cp_loanid;
1588:
1589: l_tbh_loans_rec c_tbh_loans_cur%ROWTYPE;
1590:
1591: l_appl_form_code igf_sl_lor_all.loan_app_form_code%TYPE;
1592: l_borw_interest_ind igf_sl_lor.borw_interest_ind%TYPE;
1593: l_borw_outstd_loan_code igf_sl_lor.borw_outstd_loan_code%TYPE;
1594: l_parent_person_id NUMBER;
1595: l_student_person_id NUMBER;

Line 1592: l_borw_interest_ind igf_sl_lor.borw_interest_ind%TYPE;

1588:
1589: l_tbh_loans_rec c_tbh_loans_cur%ROWTYPE;
1590:
1591: l_appl_form_code igf_sl_lor_all.loan_app_form_code%TYPE;
1592: l_borw_interest_ind igf_sl_lor.borw_interest_ind%TYPE;
1593: l_borw_outstd_loan_code igf_sl_lor.borw_outstd_loan_code%TYPE;
1594: l_parent_person_id NUMBER;
1595: l_student_person_id NUMBER;
1596: l_cosigner_person_id NUMBER;

Line 1593: l_borw_outstd_loan_code igf_sl_lor.borw_outstd_loan_code%TYPE;

1589: l_tbh_loans_rec c_tbh_loans_cur%ROWTYPE;
1590:
1591: l_appl_form_code igf_sl_lor_all.loan_app_form_code%TYPE;
1592: l_borw_interest_ind igf_sl_lor.borw_interest_ind%TYPE;
1593: l_borw_outstd_loan_code igf_sl_lor.borw_outstd_loan_code%TYPE;
1594: l_parent_person_id NUMBER;
1595: l_student_person_id NUMBER;
1596: l_cosigner_person_id NUMBER;
1597:

Line 1609: SELECT p_person_id FROM igf_sl_lor_all

1605: AND ci_cal_type = p_cal_type;
1606:
1607: --Bug# 5006583
1608: CURSOR cur_borrower_id (cp_loanid NUMBER) IS
1609: SELECT p_person_id FROM igf_sl_lor_all
1610: WHERE loan_id = cp_loanid;
1611:
1612: --Bug# 5006583
1613: CURSOR citizenship_dtl_cur (cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE) IS

Line 1625: l_b_alien_reg_num_txt igf_sl_lor_all.b_alien_reg_num_txt%TYPE;

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.
1629: -- Loan_Id is got from the Current value of sequence returned.

Line 1742: -- With these values get loan details insert data into igf_sl_lor table

1738: x_legacy_record_flag => l_tbh_loans_rec.legacy_record_flag,
1739: x_external_loan_id_txt => l_tbh_loans_rec.external_loan_id_txt
1740: );
1741:
1742: -- With these values get loan details insert data into igf_sl_lor table
1743: lv_row_id := NULL;
1744: ln_origination_id := NULL;
1745:
1746: -- Bug 4087865 Populate loan application form code

Line 1810: igf_sl_lor_pkg.insert_row (

1806: CLOSE citizenship_dtl_cur;
1807: END IF; --End of "IF l_parent_person_id IS NOT NULL THEN"
1808:
1809:
1810: igf_sl_lor_pkg.insert_row (
1811: x_mode => 'R',
1812: x_rowid => lv_row_id,
1813: x_origination_id => ln_origination_id,
1814: x_loan_id => p_loan_id,

Line 2021: SELECT * FROM igf_sl_lor

2017: lv_isir_present BOOLEAN ;
2018: loan_title VARCHAR2(1000);
2019:
2020: CURSOR c_tbh_cur (cp_loanid NUMBER) IS
2021: SELECT * FROM igf_sl_lor
2022: WHERE loan_id = cp_loanid;
2023:
2024: l_tbh_rec igf_sl_lor%ROWTYPE;
2025:

Line 2024: l_tbh_rec igf_sl_lor%ROWTYPE;

2020: CURSOR c_tbh_cur (cp_loanid NUMBER) IS
2021: SELECT * FROM igf_sl_lor
2022: WHERE loan_id = cp_loanid;
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;

Line 2046: SELECT p_person_id FROM igf_sl_lor_all

2042: AND ci_cal_type = p_cal_type;
2043:
2044: --Bug# 5006583
2045: CURSOR cur_borrower_id (cp_loanid NUMBER) IS
2046: SELECT p_person_id FROM igf_sl_lor_all
2047: WHERE loan_id = cp_loanid;
2048:
2049: --Bug# 5006583
2050: CURSOR citizenship_dtl_cur (cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE) IS

Line 2071: CURSOR get_parent_id_cur (cp_loan_id igf_sl_lor.loan_id%TYPE

2067: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
2068: lv_message VARCHAR2(100);
2069:
2070: --Bug# 5006583
2071: CURSOR get_parent_id_cur (cp_loan_id igf_sl_lor.loan_id%TYPE
2072: ) IS
2073: SELECT
2074: 'X'
2075: FROM

Line 2432: igf_sl_lor_pkg.update_row(

2428: END IF;
2429: -- END Populate borrower information based on the borrower specified in existing LOR
2430:
2431: IF lb_update THEN
2432: igf_sl_lor_pkg.update_row(
2433: x_mode => 'R',
2434: x_rowid => l_tbh_rec.row_id,
2435: x_origination_id => l_tbh_rec.origination_id,
2436: x_loan_id => l_tbh_rec.loan_id,

Line 2892: -- To get the Seq No.value based on records available in IGF_SL_LOR

2888: RAISE SKIP_THIS_RECORD;
2889:
2890: END IF;
2891:
2892: -- To get the Seq No.value based on records available in IGF_SL_LOR
2893: ln_seq_number := 0;
2894: OPEN cur_count_fed_code;
2895: FETCH cur_count_fed_code INTO ln_seq_number;
2896: CLOSE cur_count_fed_code;

Line 2950: -- Procedure call for Inserting Origination Records into IGF_SL_LOR

2946: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2947: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.insert_loan_records.debug',' after insert of loan record ');
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');