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.

[Home] [Help]

APPS.IGF_SL_AWARD dependencies on IGF_AW_AWD_DISB_ALL

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 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 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 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 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,