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_DB_DISB dependencies on IGF_AW_AWARD_ALL

Line 488: CURSOR cur_chk_adj (p_award_id igf_aw_award_all.award_id%TYPE,

484: -- Purpose : This routine creates an actual disbursement
485: --
486: --------------------------------------------------------------------------------------------
487:
488: CURSOR cur_chk_adj (p_award_id igf_aw_award_all.award_id%TYPE,
489: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
490: IS
491: SELECT NVL(MAX(disb_seq_num),0) + 1 disb_seq_num
492: FROM

Line 808: CURSOR cur_max_disb(p_award_id igf_aw_award_all.award_id%TYPE)

804:
805: grant_disb_rec cur_grant_disb%ROWTYPE;
806:
807: -- Cursor to get the last RFMS Disbursement Date
808: CURSOR cur_max_disb(p_award_id igf_aw_award_all.award_id%TYPE)
809: IS
810: SELECT disb_date,disb_num
811: FROM igf_aw_awd_disb adisb
812: WHERE

Line 840: CURSOR c_get_awd_status (p_award_id igf_aw_award_all.award_id%TYPE)

836:
837: --
838: -- Cursor to retrieve award status
839: --
840: CURSOR c_get_awd_status (p_award_id igf_aw_award_all.award_id%TYPE)
841: IS
842: SELECT award_status
843: FROM igf_aw_award_all
844: WHERE award_id = p_award_id;

Line 843: FROM igf_aw_award_all

839: --
840: CURSOR c_get_awd_status (p_award_id igf_aw_award_all.award_id%TYPE)
841: IS
842: SELECT award_status
843: FROM igf_aw_award_all
844: WHERE award_id = p_award_id;
845:
846: awd_status_rec c_get_awd_status%ROWTYPE;
847:

Line 848: CURSOR c_get_awd_det (cp_awd_id igf_aw_award_all.award_id%TYPE)

844: WHERE award_id = p_award_id;
845:
846: awd_status_rec c_get_awd_status%ROWTYPE;
847:
848: CURSOR c_get_awd_det (cp_awd_id igf_aw_award_all.award_id%TYPE)
849: IS
850: SELECT fmast.ci_cal_type, fmast.ci_sequence_number
851: FROM igf_aw_fund_mast_all fmast,
852: igf_aw_award_all awd

Line 852: igf_aw_award_all awd

848: CURSOR c_get_awd_det (cp_awd_id igf_aw_award_all.award_id%TYPE)
849: IS
850: SELECT fmast.ci_cal_type, fmast.ci_sequence_number
851: FROM igf_aw_fund_mast_all fmast,
852: igf_aw_award_all awd
853: WHERE fmast.fund_id = awd.fund_id AND
854: awd.award_id = cp_awd_id;
855:
856: awd_det_rec c_get_awd_det%ROWTYPE;

Line 2295: p_award_id igf_aw_award_all.award_id%TYPE,

2291:
2292: PROCEDURE process_student( p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
2293: p_result IN OUT NOCOPY VARCHAR2,
2294: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
2295: p_award_id igf_aw_award_all.award_id%TYPE,
2296: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
2297: )
2298: AS
2299: --------------------------------------------------------------------------------------------

Line 2322: p_award_id igf_aw_award_all.award_id%TYPE,

2318: SKIP_RECORD EXCEPTION;
2319:
2320: CURSOR cur_awd_disb(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
2321: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
2322: p_award_id igf_aw_award_all.award_id%TYPE,
2323: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
2324: IS
2325: SELECT
2326: adisb.ROWID row_id,

Line 2345: igf_aw_award_all awd,

2341: cat.fed_fund_code
2342: FROM
2343: igf_aw_awd_disb_all adisb,
2344: igf_aw_fund_mast_all fmast,
2345: igf_aw_award_all awd,
2346: igf_aw_fund_cat_all cat
2347: WHERE
2348: adisb.award_id = awd.award_id AND
2349: fmast.fund_code = cat.fund_code AND

Line 2370: CURSOR cur_get_loans (p_award_id igf_aw_award_all.award_id%TYPE)

2366: awd_disb_rec cur_awd_disb%ROWTYPE;
2367:
2368: -- Get the loan generated for this award
2369:
2370: CURSOR cur_get_loans (p_award_id igf_aw_award_all.award_id%TYPE)
2371: IS
2372: SELECT
2373: loan_id, loan_number, loan_status, active
2374: FROM

Line 2395: CURSOR cur_get_pell (p_award_id igf_aw_award_all.award_id%TYPE)

2391: loan_id = p_loan_id;
2392:
2393: pnote_stat_rec cur_pnote_stat%ROWTYPE;
2394:
2395: CURSOR cur_get_pell (p_award_id igf_aw_award_all.award_id%TYPE)
2396: IS
2397: SELECT
2398: origination_id,orig_action_code,efc
2399: FROM

Line 2442: igf_aw_award_all awd

2438: p_ld_seq_num NUMBER)
2439: IS
2440: SELECT SUM(disb.disb_gross_amt) term_total
2441: FROM igf_aw_awd_disb_all disb,
2442: igf_aw_award_all awd
2443: WHERE disb.trans_type <> 'C'
2444: AND awd.award_id = disb.award_id
2445: AND awd.award_id = p_award_id
2446: AND disb.ld_cal_type = p_ld_cal_type

Line 2487: ln_old_awd igf_aw_award_all.award_id%TYPE;

2483:
2484: ln_old_fund igf_aw_fund_mast_all.fund_id%TYPE;
2485: ln_new_fund igf_aw_fund_mast_all.fund_id%TYPE;
2486:
2487: ln_old_awd igf_aw_award_all.award_id%TYPE;
2488: ln_new_awd igf_aw_award_all.award_id%TYPE;
2489:
2490: lv_old_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;
2491: ln_old_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;

Line 2488: ln_new_awd igf_aw_award_all.award_id%TYPE;

2484: ln_old_fund igf_aw_fund_mast_all.fund_id%TYPE;
2485: ln_new_fund igf_aw_fund_mast_all.fund_id%TYPE;
2486:
2487: ln_old_awd igf_aw_award_all.award_id%TYPE;
2488: ln_new_awd igf_aw_award_all.award_id%TYPE;
2489:
2490: lv_old_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;
2491: ln_old_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;
2492: lv_new_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;