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_AWARD dependencies on IGF_AW_AWD_DISB

Line 35: -- Impacts of obsoleting columns from igf_aw_awd_disb_all

31: -- despite of Preferred Lender as the Preferred Lender is not setup for the Award Year.
32: ------------------------------------------------------------------------
33:
34: -- veramach July 2004 FA 151 HR Integration (bug#3709292)
35: -- Impacts of obsoleting columns from igf_aw_awd_disb_all
36: ---------------------------------------------------------------------------------
37: -- sjadhav 18-Feb-2004 Modified get_loan_fee1 call so that
38: -- pick_setup is invoked only for FFELP/ALT
39: -- Loan calculations

Line 42: -- Changed calll to igf_aw_awd_disb_pkg.update_row to

38: -- pick_setup is invoked only for FFELP/ALT
39: -- Loan calculations
40: ----------------------------------------------------------------------------------------
41: -- veramach 1-NOV-2003 FA 125 Multiple Distr Methods
42: -- Changed calll to igf_aw_awd_disb_pkg.update_row to
43: -- reflect the addition of attendance_type_code
44: ----------------------------------------------------------------------------------------
45: -- sjalasut 30 OCT 03 Uncommented the Code to get associated org
46: -- for the Person as part of FA126 Multiple FA

Line 503: FROM igf_aw_awd_disb_all disb

499: cp_loan_per_end_date igf_sl_loans_all.loan_per_end_date%TYPE) IS
500: SELECT disb.award_id
501: ,disb.disb_date
502: ,disb.disb_num
503: FROM igf_aw_awd_disb_all disb
504: ,igf_sl_loans_all loans
505: WHERE loans.award_id=disb.award_id
506: AND loans.award_id = cp_n_award_id
507: AND ( disb.disb_date < NVL(cp_loan_per_begin_date, loans.loan_per_begin_date)

Line 665: p_gross_amt IN igf_aw_awd_disb_all.disb_gross_amt%TYPE,

661:
662: PROCEDURE get_loan_amts(p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
663: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
664: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
665: p_gross_amt IN igf_aw_awd_disb_all.disb_gross_amt%TYPE,
666: p_rebate_amt OUT NOCOPY igf_aw_awd_disb_all.int_rebate_amt%TYPE,
667: p_loan_fee_amt OUT NOCOPY igf_aw_awd_disb_all.fee_1%TYPE,
668: p_net_amt OUT NOCOPY igf_aw_awd_disb_all.disb_net_amt%TYPE)
669: IS

Line 666: p_rebate_amt OUT NOCOPY igf_aw_awd_disb_all.int_rebate_amt%TYPE,

662: PROCEDURE get_loan_amts(p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
663: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
664: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
665: p_gross_amt IN igf_aw_awd_disb_all.disb_gross_amt%TYPE,
666: p_rebate_amt OUT NOCOPY igf_aw_awd_disb_all.int_rebate_amt%TYPE,
667: p_loan_fee_amt OUT NOCOPY igf_aw_awd_disb_all.fee_1%TYPE,
668: p_net_amt OUT NOCOPY igf_aw_awd_disb_all.disb_net_amt%TYPE)
669: IS
670: -----------------------------------------------------------------------------------

Line 667: p_loan_fee_amt OUT NOCOPY igf_aw_awd_disb_all.fee_1%TYPE,

663: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
664: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
665: p_gross_amt IN igf_aw_awd_disb_all.disb_gross_amt%TYPE,
666: p_rebate_amt OUT NOCOPY igf_aw_awd_disb_all.int_rebate_amt%TYPE,
667: p_loan_fee_amt OUT NOCOPY igf_aw_awd_disb_all.fee_1%TYPE,
668: p_net_amt OUT NOCOPY igf_aw_awd_disb_all.disb_net_amt%TYPE)
669: IS
670: -----------------------------------------------------------------------------------
671: --

Line 668: p_net_amt OUT NOCOPY igf_aw_awd_disb_all.disb_net_amt%TYPE)

664: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
665: p_gross_amt IN igf_aw_awd_disb_all.disb_gross_amt%TYPE,
666: p_rebate_amt OUT NOCOPY igf_aw_awd_disb_all.int_rebate_amt%TYPE,
667: p_loan_fee_amt OUT NOCOPY igf_aw_awd_disb_all.fee_1%TYPE,
668: p_net_amt OUT NOCOPY igf_aw_awd_disb_all.disb_net_amt%TYPE)
669: IS
670: -----------------------------------------------------------------------------------
671: --
672: -- sjadhav, Jan 23,2002

Line 680: ln_comb_int_amt igf_aw_awd_disb_all.disb_net_amt%TYPE;

676: -----------------------------------------------------------------------------------
677:
678:
679: ln_comb_int_pct igf_sl_dl_setup_all.int_rebate%TYPE;
680: ln_comb_int_amt igf_aw_awd_disb_all.disb_net_amt%TYPE;
681:
682: BEGIN
683:
684: --

Line 757: Changed calll to igf_aw_awd_disb_pkg.update_row to reflect the addition of attendance_type_code

753: This is to recalculate teh fees
754: based on the setup choosen for the
755: student
756: veramach 1-NOV-2003 FA 125 Multiple Distr Methods
757: Changed calll to igf_aw_awd_disb_pkg.update_row to reflect the addition of attendance_type_code
758: (reverse chronological order - newest change first)
759: ***************************************************************/
760:
761: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;

Line 768: FROM igf_aw_awd_disb adisb

764:
765: CURSOR cur_get_adisb (cp_award_id igf_sl_loans.award_id%TYPE)
766: IS
767: SELECT *
768: FROM igf_aw_awd_disb adisb
769: WHERE adisb.award_id = p_award_id;
770:
771: CURSOR c_get_alt_code (cp_award_id igf_aw_award_all.award_id%TYPE)
772: IS

Line 787: l_fee1 igf_aw_awd_disb.fee_1%TYPE;

783:
784:
785: get_adisb_rec cur_get_adisb%ROWTYPE;
786: l_get_fed_fund_code c_get_fed_fund_code%ROWTYPE;
787: l_fee1 igf_aw_awd_disb.fee_1%TYPE;
788: l_fee2 igf_aw_awd_disb.fee_2%TYPE;
789: l_net_amt igf_aw_awd_disb.disb_net_amt%TYPE;
790: l_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE;
791: BEGIN

Line 788: l_fee2 igf_aw_awd_disb.fee_2%TYPE;

784:
785: get_adisb_rec cur_get_adisb%ROWTYPE;
786: l_get_fed_fund_code c_get_fed_fund_code%ROWTYPE;
787: l_fee1 igf_aw_awd_disb.fee_1%TYPE;
788: l_fee2 igf_aw_awd_disb.fee_2%TYPE;
789: l_net_amt igf_aw_awd_disb.disb_net_amt%TYPE;
790: l_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE;
791: BEGIN
792:

Line 789: l_net_amt igf_aw_awd_disb.disb_net_amt%TYPE;

785: get_adisb_rec cur_get_adisb%ROWTYPE;
786: l_get_fed_fund_code c_get_fed_fund_code%ROWTYPE;
787: l_fee1 igf_aw_awd_disb.fee_1%TYPE;
788: l_fee2 igf_aw_awd_disb.fee_2%TYPE;
789: l_net_amt igf_aw_awd_disb.disb_net_amt%TYPE;
790: l_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE;
791: BEGIN
792:
793: l_rel_code := NULL;

Line 859: igf_aw_awd_disb_pkg.update_row( x_rowid => get_adisb_rec.row_id ,

855: + NVL(get_adisb_rec.fee_paid_2,0);
856:
857: END IF;
858: -- update the amounts and the fees as calculated above
859: igf_aw_awd_disb_pkg.update_row( x_rowid => get_adisb_rec.row_id ,
860: x_award_id => get_adisb_rec.award_id ,
861: x_disb_num => get_adisb_rec.disb_num ,
862: x_tp_cal_type => get_adisb_rec.tp_cal_type ,
863: x_tp_sequence_number => get_adisb_rec.tp_sequence_number ,

Line 1305: CURSOR c_igf_aw_awd_disb (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS

1301: WHERE lar.award_id = cp_n_award_id;
1302:
1303: rec_c_igf_sl_loans c_igf_sl_loans%ROWTYPE;
1304:
1305: CURSOR c_igf_aw_awd_disb (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
1306: SELECT adisb.disb_num
1307: FROM igf_aw_awd_disb_all adisb
1308: WHERE adisb.award_id=cp_n_award_id
1309: AND NVL(adisb.fund_status,'N') = 'N';

Line 1307: FROM igf_aw_awd_disb_all adisb

1303: rec_c_igf_sl_loans c_igf_sl_loans%ROWTYPE;
1304:
1305: CURSOR c_igf_aw_awd_disb (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
1306: SELECT adisb.disb_num
1307: FROM igf_aw_awd_disb_all adisb
1308: WHERE adisb.award_id=cp_n_award_id
1309: AND NVL(adisb.fund_status,'N') = 'N';
1310:
1311: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;

Line 1311: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;

1307: FROM igf_aw_awd_disb_all adisb
1308: WHERE adisb.award_id=cp_n_award_id
1309: AND NVL(adisb.fund_status,'N') = 'N';
1310:
1311: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
1312: l_n_award_id igf_aw_award_all.award_id%TYPE;
1313: l_return_val BOOLEAN;
1314: BEGIN
1315: l_n_award_id := p_n_award_id;

Line 1325: OPEN c_igf_aw_awd_disb(cp_n_award_id => l_n_award_id);

1321: RETURN TRUE;
1322: END IF;
1323: CLOSE c_igf_sl_loans;
1324: --if loan records exists, check if new disbursement can be added or not
1325: OPEN c_igf_aw_awd_disb(cp_n_award_id => l_n_award_id);
1326: FETCH c_igf_aw_awd_disb INTO l_disb_num;
1327: CLOSE c_igf_aw_awd_disb ;
1328:
1329: l_return_val:= igf_sl_award.chk_chg_enable (p_n_award_id => l_n_award_id);

Line 1326: FETCH c_igf_aw_awd_disb INTO l_disb_num;

1322: END IF;
1323: CLOSE c_igf_sl_loans;
1324: --if loan records exists, check if new disbursement can be added or not
1325: OPEN c_igf_aw_awd_disb(cp_n_award_id => l_n_award_id);
1326: FETCH c_igf_aw_awd_disb INTO l_disb_num;
1327: CLOSE c_igf_aw_awd_disb ;
1328:
1329: l_return_val:= igf_sl_award.chk_chg_enable (p_n_award_id => l_n_award_id);
1330:

Line 1327: CLOSE c_igf_aw_awd_disb ;

1323: CLOSE c_igf_sl_loans;
1324: --if loan records exists, check if new disbursement can be added or not
1325: OPEN c_igf_aw_awd_disb(cp_n_award_id => l_n_award_id);
1326: FETCH c_igf_aw_awd_disb INTO l_disb_num;
1327: CLOSE c_igf_aw_awd_disb ;
1328:
1329: l_return_val:= igf_sl_award.chk_chg_enable (p_n_award_id => l_n_award_id);
1330:
1331: IF NOT (l_return_val) THEN

Line 1379: CURSOR c_igf_aw_awd_disb (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS

1375: WHERE lar.award_id = cp_n_award_id;
1376:
1377: rec_c_igf_sl_loans c_igf_sl_loans%ROWTYPE;
1378:
1379: CURSOR c_igf_aw_awd_disb (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
1380: SELECT adisb.disb_num
1381: FROM igf_aw_awd_disb_all adisb
1382: WHERE adisb.award_id=cp_n_award_id
1383: AND NVL(adisb.fund_status,'N') = 'N';

Line 1381: FROM igf_aw_awd_disb_all adisb

1377: rec_c_igf_sl_loans c_igf_sl_loans%ROWTYPE;
1378:
1379: CURSOR c_igf_aw_awd_disb (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
1380: SELECT adisb.disb_num
1381: FROM igf_aw_awd_disb_all adisb
1382: WHERE adisb.award_id=cp_n_award_id
1383: AND NVL(adisb.fund_status,'N') = 'N';
1384:
1385: CURSOR c_chk_chg_enable (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS

Line 1408: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;

1404:
1405: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
1406: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
1407: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;
1408: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
1409: l_n_award_id igf_aw_award_all.award_id%TYPE;
1410:
1411: BEGIN
1412: l_n_award_id := p_n_award_id;

Line 1422: OPEN c_igf_aw_awd_disb(cp_n_award_id => l_n_award_id);

1418: RETURN TRUE;
1419: END IF;
1420: CLOSE c_igf_sl_loans;
1421: --if loan records exists, check if new disbursement can be added or not
1422: OPEN c_igf_aw_awd_disb(cp_n_award_id => l_n_award_id);
1423: FETCH c_igf_aw_awd_disb INTO l_disb_num;
1424: CLOSE c_igf_aw_awd_disb ;
1425:
1426: OPEN c_chk_chg_enable (cp_n_award_id => l_n_award_id);

Line 1423: FETCH c_igf_aw_awd_disb INTO l_disb_num;

1419: END IF;
1420: CLOSE c_igf_sl_loans;
1421: --if loan records exists, check if new disbursement can be added or not
1422: OPEN c_igf_aw_awd_disb(cp_n_award_id => l_n_award_id);
1423: FETCH c_igf_aw_awd_disb INTO l_disb_num;
1424: CLOSE c_igf_aw_awd_disb ;
1425:
1426: OPEN c_chk_chg_enable (cp_n_award_id => l_n_award_id);
1427: FETCH c_chk_chg_enable INTO l_v_loan_number,l_n_cl_version,l_v_loan_status;

Line 1424: CLOSE c_igf_aw_awd_disb ;

1420: CLOSE c_igf_sl_loans;
1421: --if loan records exists, check if new disbursement can be added or not
1422: OPEN c_igf_aw_awd_disb(cp_n_award_id => l_n_award_id);
1423: FETCH c_igf_aw_awd_disb INTO l_disb_num;
1424: CLOSE c_igf_aw_awd_disb ;
1425:
1426: OPEN c_chk_chg_enable (cp_n_award_id => l_n_award_id);
1427: FETCH c_chk_chg_enable INTO l_v_loan_number,l_n_cl_version,l_v_loan_status;
1428: IF c_chk_chg_enable%NOTFOUND THEN

Line 1537: p_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE

1533: app_exception.raise_exception;
1534: END get_loan_cl_version;
1535:
1536: FUNCTION chk_fund_st_chg ( p_n_award_id IN igf_aw_award_all.award_id%TYPE,
1537: p_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE
1538: )
1539: RETURN BOOLEAN AS
1540: ------------------------------------------------------------------
1541: --Created by : Sanil Madathil, Oracle IDC

Line 1557: cp_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE) IS

1553: --Change History:
1554: --Who When What
1555: ------------------------------------------------------------------
1556: CURSOR c_chk_fund_st_chg_1 (cp_n_award_id IN igf_aw_award_all.award_id%TYPE,
1557: cp_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE) IS
1558: SELECT dbresp.disb_num
1559: FROM igf_db_cl_disb_resp dbresp
1560: ,igf_sl_loans_all loans
1561: ,igf_aw_award_all awd

Line 1569: cp_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE) IS

1565: AND awd.award_id = cp_n_award_id
1566: ORDER BY cdbr_id DESC;
1567:
1568: CURSOR c_chk_fund_st_chg_2 (cp_n_award_id IN igf_aw_award_all.award_id%TYPE,
1569: cp_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE) IS
1570: SELECT chg.disbursement_number
1571: FROM igf_sl_clchsn_dtls chg
1572: ,igf_sl_loans_all loans
1573: ,igf_aw_award_all awd

Line 1581: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE;

1577: AND chg.loan_number_txt = loans.loan_number
1578: AND loans.award_id = awd.award_id
1579: AND awd.award_id = cp_n_award_id ;
1580:
1581: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
1582:
1583: BEGIN
1584:
1585: -- Fund Status would determine if the Disbursement Change is to be considered as Pre or Post Disbursement,