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_AWD_DISB_ALL

Line 518: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE

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

Line 548: p_award_id igf_aw_awd_disb_all.award_id%TYPE,

544:
545:
546: -- Get the disbursment date
547: CURSOR cur_get_disb_date(
548: p_award_id igf_aw_awd_disb_all.award_id%TYPE,
549: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
550: )
551: IS
552: SELECT disb_date

Line 549: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE

545:
546: -- Get the disbursment date
547: CURSOR cur_get_disb_date(
548: p_award_id igf_aw_awd_disb_all.award_id%TYPE,
549: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
550: )
551: IS
552: SELECT disb_date
553: FROM igf_aw_awd_disb_all

Line 553: FROM igf_aw_awd_disb_all

549: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
550: )
551: IS
552: SELECT disb_date
553: FROM igf_aw_awd_disb_all
554: WHERE p_award_id = award_id AND p_disb_num = disb_num;
555:
556: get_disb_date_rec cur_get_disb_date%ROWTYPE;
557: BEGIN

Line 633: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE,

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: )
637: RETURN BOOLEAN

Line 663: p_award_id igf_aw_awd_disb_all.award_id%TYPE,

659:
660:
661: -- Get the disbursment date
662: CURSOR cur_get_disb_date(
663: p_award_id igf_aw_awd_disb_all.award_id%TYPE,
664: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
665: )
666: IS
667: SELECT disb_date

Line 664: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE

660:
661: -- Get the disbursment date
662: CURSOR cur_get_disb_date(
663: p_award_id igf_aw_awd_disb_all.award_id%TYPE,
664: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
665: )
666: IS
667: SELECT disb_date
668: FROM igf_aw_awd_disb_all

Line 668: FROM igf_aw_awd_disb_all

664: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
665: )
666: IS
667: SELECT disb_date
668: FROM igf_aw_awd_disb_all
669: WHERE p_award_id = award_id AND p_disb_num = disb_num;
670:
671: get_disb_date_rec cur_get_disb_date%ROWTYPE;
672: l_pell_setup_rec igf_gr_pell_setup_all%ROWTYPE;

Line 1498: p_disb_date igf_aw_awd_disb_all.disb_date%TYPE

1494: END get_loan_num;
1495:
1496: FUNCTION get_cut_off_dt(
1497: p_ld_seq_num igs_ca_inst_all.sequence_number%TYPE,
1498: p_disb_date igf_aw_awd_disb_all.disb_date%TYPE
1499: )
1500: RETURN DATE
1501: IS
1502:

Line 1521: ld_cut_off_dt igf_aw_awd_disb_all.disb_date%TYPE;

1517: FROM igs_ca_inst_all
1518: WHERE p_ld_seq_num = sequence_number;
1519:
1520: get_eff_date_rec cur_get_eff_date%ROWTYPE;
1521: ld_cut_off_dt igf_aw_awd_disb_all.disb_date%TYPE;
1522: ld_system_dt igf_aw_awd_disb_all.disb_date%TYPE;
1523: ld_start_dt igf_aw_awd_disb_all.disb_date%TYPE;
1524: ld_end_dt igf_aw_awd_disb_all.disb_date%TYPE;
1525: BEGIN

Line 1522: ld_system_dt igf_aw_awd_disb_all.disb_date%TYPE;

1518: WHERE p_ld_seq_num = sequence_number;
1519:
1520: get_eff_date_rec cur_get_eff_date%ROWTYPE;
1521: ld_cut_off_dt igf_aw_awd_disb_all.disb_date%TYPE;
1522: ld_system_dt igf_aw_awd_disb_all.disb_date%TYPE;
1523: ld_start_dt igf_aw_awd_disb_all.disb_date%TYPE;
1524: ld_end_dt igf_aw_awd_disb_all.disb_date%TYPE;
1525: BEGIN
1526: ld_system_dt := TRUNC(SYSDATE);

Line 1523: ld_start_dt igf_aw_awd_disb_all.disb_date%TYPE;

1519:
1520: get_eff_date_rec cur_get_eff_date%ROWTYPE;
1521: ld_cut_off_dt igf_aw_awd_disb_all.disb_date%TYPE;
1522: ld_system_dt igf_aw_awd_disb_all.disb_date%TYPE;
1523: ld_start_dt igf_aw_awd_disb_all.disb_date%TYPE;
1524: ld_end_dt igf_aw_awd_disb_all.disb_date%TYPE;
1525: BEGIN
1526: ld_system_dt := TRUNC(SYSDATE);
1527: ld_cut_off_dt := ld_system_dt;

Line 1524: ld_end_dt igf_aw_awd_disb_all.disb_date%TYPE;

1520: get_eff_date_rec cur_get_eff_date%ROWTYPE;
1521: ld_cut_off_dt igf_aw_awd_disb_all.disb_date%TYPE;
1522: ld_system_dt igf_aw_awd_disb_all.disb_date%TYPE;
1523: ld_start_dt igf_aw_awd_disb_all.disb_date%TYPE;
1524: ld_end_dt igf_aw_awd_disb_all.disb_date%TYPE;
1525: BEGIN
1526: ld_system_dt := TRUNC(SYSDATE);
1527: ld_cut_off_dt := ld_system_dt;
1528: OPEN cur_get_eff_date(p_ld_seq_num);

Line 1586: p_award_id igf_aw_awd_disb_all.award_id%TYPE,

1582: app_exception.raise_exception;
1583: END get_cut_off_dt;
1584:
1585: PROCEDURE set_dri_true(
1586: p_award_id igf_aw_awd_disb_all.award_id%TYPE,
1587: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE,
1588: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE, p_fund_type VARCHAR2
1589: )
1590: AS

Line 1587: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE,

1583: END get_cut_off_dt;
1584:
1585: PROCEDURE set_dri_true(
1586: p_award_id igf_aw_awd_disb_all.award_id%TYPE,
1587: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE,
1588: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE, p_fund_type VARCHAR2
1589: )
1590: AS
1591:

Line 1602: p_award_id igf_aw_awd_disb_all.award_id%TYPE,

1598: --------------------------------------------------------------------------------------------
1599:
1600:
1601: CURSOR cur_get_adisb(
1602: p_award_id igf_aw_awd_disb_all.award_id%TYPE,
1603: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
1604: )
1605: IS
1606: SELECT ROWID row_id, adisb.*

Line 1603: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE

1599:
1600:
1601: CURSOR cur_get_adisb(
1602: p_award_id igf_aw_awd_disb_all.award_id%TYPE,
1603: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
1604: )
1605: IS
1606: SELECT ROWID row_id, adisb.*
1607: FROM igf_aw_awd_disb_all adisb

Line 1607: FROM igf_aw_awd_disb_all adisb

1603: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
1604: )
1605: IS
1606: SELECT ROWID row_id, adisb.*
1607: FROM igf_aw_awd_disb_all adisb
1608: WHERE adisb.award_id = p_award_id
1609: AND adisb.disb_num = p_disb_num
1610: FOR UPDATE OF elig_status NOWAIT;
1611:

Line 1714: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE, p_trans_type VARCHAR2

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
1717:
1718: --------------------------------------------------------------------------------------------

Line 1759: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE,

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
1763: SELECT adisb.*, awd.base_id, fmast.ci_cal_type,

Line 1760: p_trans_type igf_aw_awd_disb_all.trans_type%TYPE

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
1763: SELECT adisb.*, awd.base_id, fmast.ci_cal_type,
1764: fmast.ci_sequence_number, fmast.fund_id, fmast.fund_code,

Line 1766: FROM igf_aw_awd_disb_all adisb, igf_aw_fund_mast_all fmast,

1762: IS
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

Line 1789: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE, p_trans_type VARCHAR2

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,
1793: fmast.ci_sequence_number, fmast.fund_id, fmast.fund_code,

Line 1795: FROM igf_aw_awd_disb_all adisb, igf_aw_fund_mast_all fmast,

1791: IS
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

Line 1815: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE

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,
1819: fmast.ci_sequence_number, fmast.fund_id, fmast.fund_code,

Line 1821: FROM igf_aw_awd_disb_all adisb, igf_aw_fund_mast_all fmast,

1817: IS
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

Line 1879: l_credit_pts igf_aw_awd_disb_all.min_credit_pts%TYPE;

1875: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
1876: l_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
1877: l_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;
1878: l_message_name fnd_new_messages.message_text%TYPE;
1879: l_credit_pts igf_aw_awd_disb_all.min_credit_pts%TYPE;
1880:
1881: --Variables to Store the validation results
1882:
1883: l_pays_prg BOOLEAN := TRUE; -- Pays Only Program Result

Line 3255: p_trans_type IN igf_aw_awd_disb_all.trans_type%TYPE

3251: p_award_year IN VARCHAR2, p_pell_dummy IN VARCHAR2,
3252: p_dl_dummy IN VARCHAR2, p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
3253: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE, p_per_dummy IN NUMBER,
3254: p_loan_id IN NUMBER, p_loan_dummy IN NUMBER, p_per_grp_id IN NUMBER,
3255: p_trans_type IN igf_aw_awd_disb_all.trans_type%TYPE
3256: )
3257:
3258: ------------------------------------------------------------------------------------------------------------------------------------
3259: --