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_REL_DISB dependencies on IGF_AW_AWARD

Line 517: p_award_id igf_aw_award_all.award_id%TYPE,

513:
514: FUNCTION chk_fund_meth_dl(
515: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
516: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
517: p_award_id igf_aw_award_all.award_id%TYPE,
518: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
519: )
520: RETURN BOOLEAN
521: AS

Line 632: p_award_id igf_aw_award_all.award_id%TYPE,

628: FUNCTION chk_fund_meth_pell(
629: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
630: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
631: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
632: p_award_id igf_aw_award_all.award_id%TYPE,
633: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE,
634: cp_return_status IN OUT NOCOPY VARCHAR2,
635: cp_message IN OUT NOCOPY VARCHAR2
636: )

Line 773: FUNCTION chk_credit_status(p_award_id igf_aw_award_all.award_id%TYPE)

769: igs_ge_msg_stack.ADD;
770: app_exception.raise_exception;
771: END chk_fund_meth_pell;
772:
773: FUNCTION chk_credit_status(p_award_id igf_aw_award_all.award_id%TYPE)
774: RETURN BOOLEAN
775: AS
776: /*------------------------------------------------------------------------------------------------
777: || Created By : pssahni

Line 787: CURSOR cur_get_crdt_status(p_award_id igf_aw_award_all.award_id%TYPE)

783: || Who When What
784: || (reverse chronological order - newest change first)
785: -------------------------------------------------------------------------------------------------- */
786:
787: CURSOR cur_get_crdt_status(p_award_id igf_aw_award_all.award_id%TYPE)
788: IS
789: SELECT lor.crdt_decision_status status, lor.credit_override override
790: FROM igf_sl_lor_all lor, igf_sl_loans_all loan
791: WHERE loan.loan_id = lor.loan_id AND loan.award_id = p_award_id;

Line 1712: p_award_id igf_aw_award_all.award_id%TYPE,

1708: PROCEDURE process_student(
1709: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1710: p_result IN OUT NOCOPY VARCHAR2,
1711: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1712: p_award_id igf_aw_award_all.award_id%TYPE,
1713: p_loan_id igf_sl_loans_all.loan_id%TYPE,
1714: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE, p_trans_type VARCHAR2
1715: )
1716: AS

Line 1758: p_award_id igf_aw_award_all.award_id%TYPE,

1754: --Get all the awards and corresponding disbursements for the student for a given fund in case of Direct Loans
1755: CURSOR cur_awd_disb_dl(
1756: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1757: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1758: p_award_id igf_aw_award_all.award_id%TYPE,
1759: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE,
1760: p_trans_type igf_aw_awd_disb_all.trans_type%TYPE
1761: )
1762: IS

Line 1767: igf_aw_award_all awd, igf_aw_fund_cat_all cat

1763: SELECT adisb.*, awd.base_id, fmast.ci_cal_type,
1764: fmast.ci_sequence_number, fmast.fund_id, fmast.fund_code,
1765: cat.fed_fund_code
1766: FROM igf_aw_awd_disb_all adisb, igf_aw_fund_mast_all fmast,
1767: igf_aw_award_all awd, igf_aw_fund_cat_all cat
1768: WHERE adisb.award_id = awd.award_id
1769: AND fmast.fund_code = cat.fund_code
1770: AND fmast.fund_id = awd.fund_id AND awd.base_id = p_base_id
1771: AND awd.fund_id = p_fund_id

Line 1788: p_award_id igf_aw_award_all.award_id%TYPE,

1784: -- in case of FFELP Loans and if transaction type is specified
1785: CURSOR cur_awd_disb_fed(
1786: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1787: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1788: p_award_id igf_aw_award_all.award_id%TYPE,
1789: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE, p_trans_type VARCHAR2
1790: )
1791: IS
1792: SELECT adisb.*, awd.base_id, fmast.ci_cal_type,

Line 1796: igf_aw_award_all awd, igf_aw_fund_cat_all cat

1792: SELECT adisb.*, awd.base_id, fmast.ci_cal_type,
1793: fmast.ci_sequence_number, fmast.fund_id, fmast.fund_code,
1794: cat.fed_fund_code
1795: FROM igf_aw_awd_disb_all adisb, igf_aw_fund_mast_all fmast,
1796: igf_aw_award_all awd, igf_aw_fund_cat_all cat
1797: WHERE adisb.award_id = awd.award_id
1798: AND fmast.fund_code = cat.fund_code
1799: AND fmast.fund_id = awd.fund_id AND awd.base_id = p_base_id
1800: AND awd.fund_id = p_fund_id

Line 1814: p_award_id igf_aw_award_all.award_id%TYPE,

1810: -- in case of FFELP Loans and if transaction type is not specified
1811: CURSOR cur_awd_disb_fed_no_trans(
1812: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1813: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1814: p_award_id igf_aw_award_all.award_id%TYPE,
1815: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
1816: )
1817: IS
1818: SELECT adisb.*, awd.base_id, fmast.ci_cal_type,

Line 1822: igf_aw_award_all awd, igf_aw_fund_cat_all cat

1818: SELECT adisb.*, awd.base_id, fmast.ci_cal_type,
1819: fmast.ci_sequence_number, fmast.fund_id, fmast.fund_code,
1820: cat.fed_fund_code
1821: FROM igf_aw_awd_disb_all adisb, igf_aw_fund_mast_all fmast,
1822: igf_aw_award_all awd, igf_aw_fund_cat_all cat
1823: WHERE adisb.award_id = awd.award_id
1824: AND fmast.fund_code = cat.fund_code
1825: AND fmast.fund_id = awd.fund_id AND awd.base_id = p_base_id
1826: AND awd.fund_id = p_fund_id

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

1853: WHERE award_id = p_award_id AND loan_id = NVL(loan_id, p_loan_id);
1854:
1855: get_loans_rec cur_get_loans%ROWTYPE;
1856:
1857: CURSOR cur_get_pell(p_award_id igf_aw_award_all.award_id%TYPE)
1858: IS
1859: SELECT orig_action_code, origination_id
1860: FROM igf_gr_rfms_all
1861: WHERE award_id = p_award_id;

Line 1901: l_old_awd igf_aw_award_all.award_id%TYPE;

1897: -- checks are not repeated for each disbursement belonging to the same fund/award/term
1898:
1899: l_old_fund igf_aw_fund_mast_all.fund_id%TYPE;
1900: l_new_fund igf_aw_fund_mast_all.fund_id%TYPE;
1901: l_old_awd igf_aw_award_all.award_id%TYPE;
1902: l_new_awd igf_aw_award_all.award_id%TYPE;
1903: l_old_ld_cal igf_aw_fund_tp_all.tp_cal_type%TYPE;
1904: l_old_ld_seq igf_aw_fund_tp_all.tp_sequence_number%TYPE;
1905: l_new_ld_cal igf_aw_fund_tp_all.tp_cal_type%TYPE;

Line 1902: l_new_awd igf_aw_award_all.award_id%TYPE;

1898:
1899: l_old_fund igf_aw_fund_mast_all.fund_id%TYPE;
1900: l_new_fund igf_aw_fund_mast_all.fund_id%TYPE;
1901: l_old_awd igf_aw_award_all.award_id%TYPE;
1902: l_new_awd igf_aw_award_all.award_id%TYPE;
1903: l_old_ld_cal igf_aw_fund_tp_all.tp_cal_type%TYPE;
1904: l_old_ld_seq igf_aw_fund_tp_all.tp_sequence_number%TYPE;
1905: l_new_ld_cal igf_aw_fund_tp_all.tp_cal_type%TYPE;
1906: l_new_ld_seq igf_aw_fund_tp_all.tp_sequence_number%TYPE;

Line 3367: FROM igf_aw_award awd, igf_aw_fund_mast fmast,

3363: CURSOR cur_award_std(p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
3364: IS
3365: SELECT DISTINCT awd.base_id base_id, fcat.fed_fund_code
3366: fed_fund_code
3367: FROM igf_aw_award awd, igf_aw_fund_mast fmast,
3368: igf_aw_fund_cat fcat
3369: WHERE awd.fund_id = p_fund_id
3370: AND awd.fund_id = fmast.fund_id
3371: AND fmast.fund_code = fcat.fund_code