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_FUND_MAST

Line 34: FUNCTION get_fund_desc(p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)

30:
31:
32: ------------------------------------------------------------------------------------------
33:
34: FUNCTION get_fund_desc(p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
35: RETURN VARCHAR2
36: IS
37:
38: --------------------------------------------------------------------------------------------

Line 44: CURSOR cur_fund_des(p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)

40: -- Purpose : Returns fund code + description of the fund id passed
41: --
42: --------------------------------------------------------------------------------------------
43:
44: CURSOR cur_fund_des(p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
45: IS
46: SELECT fund_code fdesc
47: FROM igf_aw_fund_mast
48: WHERE fund_id = p_fund_id;

Line 47: FROM igf_aw_fund_mast

43:
44: CURSOR cur_fund_des(p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
45: IS
46: SELECT fund_code fdesc
47: FROM igf_aw_fund_mast
48: WHERE fund_id = p_fund_id;
49:
50: fund_des_rec cur_fund_des%ROWTYPE;
51: BEGIN

Line 355: FROM igf_aw_fund_mast_all

351: -- Get the values from the lookups
352: CURSOR cur_get_fund_code(p_fund_id NUMBER)
353: IS
354: SELECT fund_code
355: FROM igf_aw_fund_mast_all
356: WHERE fund_id = p_fund_id;
357:
358: get_fund_code_rec cur_get_fund_code%ROWTYPE;
359:

Line 363: FROM igf_aw_fund_mast_all fmast,igf_aw_fund_cat_all fcat

359:
360: CURSOR cur_get_fed_fund_code(p_fund_id NUMBER)
361: IS
362: SELECT fcat.fed_fund_code
363: FROM igf_aw_fund_mast_all fmast,igf_aw_fund_cat_all fcat
364: WHERE fmast.fund_id = p_fund_id
365: AND fmast.fund_code = fcat.fund_code;
366:
367: get_fed_fund_code cur_get_fed_fund_code%ROWTYPE;

Line 828: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

824: END chk_credit_status;
825:
826: FUNCTION chk_todo_result(
827: p_message_name OUT NOCOPY VARCHAR2,
828: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
829: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
830: )
831: RETURN BOOLEAN
832: AS

Line 855: CURSOR c_fund_details(cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE)

851: SELECT manual_disb_hold, fa_process_status
852: FROM igf_ap_fa_base_rec
853: WHERE base_id = cp_base_id;
854:
855: CURSOR c_fund_details(cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
856: IS
857: SELECT ver_app_stat_override
858: FROM igf_aw_fund_mast
859: WHERE fund_id = cp_fund_id;

Line 858: FROM igf_aw_fund_mast

854:
855: CURSOR c_fund_details(cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
856: IS
857: SELECT ver_app_stat_override
858: FROM igf_aw_fund_mast
859: WHERE fund_id = cp_fund_id;
860:
861: CURSOR c_chk_verif_status(
862: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

Line 880: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,

876: );
877:
878: CURSOR c_fnd_todo(
879: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
880: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
881: cp_status igf_ap_td_item_inst_all.status%TYPE,
882: cp_inactive igf_ap_td_item_inst_all.inactive_flag%TYPE
883: ) IS
884: SELECT 'x'

Line 885: FROM igf_aw_fund_mast_all fmast,

881: cp_status igf_ap_td_item_inst_all.status%TYPE,
882: cp_inactive igf_ap_td_item_inst_all.inactive_flag%TYPE
883: ) IS
884: SELECT 'x'
885: FROM igf_aw_fund_mast_all fmast,
886: igf_aw_fund_td_map_all fndtd,
887: igf_ap_td_item_inst_all tdinst,
888: igf_ap_td_item_mst_all tdmst
889: WHERE fmast.fund_id = cp_fund_id

Line 899: FROM igf_aw_fund_mast_all fmast,

895: AND tdinst.status <> cp_status
896: AND tdinst.inactive_flag <> cp_inactive
897: UNION
898: SELECT 'x'
899: FROM igf_aw_fund_mast_all fmast,
900: igf_aw_fund_td_map_all fndtd,
901: igf_ap_td_item_inst_v tdinst,
902: igf_ap_td_item_mst_all tdmst,
903: igf_ap_fa_base_rec_all fa

Line 1131: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,

1127: app_exception.raise_exception;
1128: END insert_pays_prg_uts;
1129:
1130: FUNCTION chk_pays_prg(
1131: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1132: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1133: )
1134: RETURN BOOLEAN
1135: AS

Line 1153: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE

1149: --
1150:
1151: CURSOR cur_std_pays(
1152: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1153: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE
1154: )
1155: IS
1156: SELECT program_cd, prg_ver_num
1157: FROM igf_db_pays_prg_t

Line 1171: CURSOR cur_fund_pprg(p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)

1167: --
1168: -- This cursor will retreive records from fund setup for pays only program
1169: -- If there are no records, then the pays only prog check is passed
1170: --
1171: CURSOR cur_fund_pprg(p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
1172: IS
1173: SELECT course_cd, version_number
1174: FROM igf_aw_fund_prg_v fprg
1175: WHERE fprg.fund_id = p_fund_id;

Line 1213: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,

1209: app_exception.raise_exception;
1210: END chk_pays_prg;
1211:
1212: FUNCTION chk_pays_uts(
1213: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1214: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1215: )
1216: RETURN BOOLEAN
1217: AS

Line 1235: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE

1231: --
1232:
1233: CURSOR cur_std_pays(
1234: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1235: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE
1236: )
1237: IS
1238: SELECT unit_cd, unit_ver_num
1239: FROM igf_db_pays_prg_t

Line 1253: CURSOR cur_fund_unit(p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)

1249: --
1250: -- This cursor will retreive records from fund setup for pays only program
1251: -- If there are no records, then the pays only prog check is passed
1252: --
1253: CURSOR cur_fund_unit(p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
1254: IS
1255: SELECT unit_cd, version_number
1256: FROM igf_aw_fund_unit_v funit
1257: WHERE funit.fund_id = p_fund_id;

Line 1296: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,

1292: END chk_pays_uts;
1293:
1294: FUNCTION chk_fclass_result(
1295: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1296: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1297: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
1298: p_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
1299: )
1300: RETURN BOOLEAN

Line 1321: CURSOR cur_fund_fcls(p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)

1317: --
1318: -- This cursor will retreive records from fund setup for pays only Fee Class
1319: -- If there are no records, then the pays only fee class check is passed
1320: --
1321: CURSOR cur_fund_fcls(p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
1322: IS
1323: SELECT fee_class
1324: FROM igf_aw_fund_feeclas
1325: WHERE fund_id = p_fund_id;

Line 1336: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,

1332: -- fund setup and persons charges
1333: --
1334:
1335: CURSOR cur_fee_cls(
1336: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1337: p_fee_cal_type igs_ca_inst_all.cal_type%TYPE,
1338: p_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1339: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE
1340: )

Line 1588: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE, p_fund_type VARCHAR2

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:
1592: --------------------------------------------------------------------------------------------

Line 1711: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,

1707:
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: )

Line 1757: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,

1753:
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: )

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 1787: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,

1783: --Get all the awards and corresponding disbursements for the student for a given fund
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

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 1813: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,

1809: --Get all the awards and corresponding disbursements for the student for a given fund
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

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 1867: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE

1863: get_pell_rec cur_get_pell%ROWTYPE;
1864:
1865: -- Get the fed fund code of the fund
1866: CURSOR cur_get_fed_fund_code(
1867: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE
1868: )
1869: IS
1870: SELECT cat.fed_fund_code
1871: FROM igf_aw_fund_cat_all cat, igf_aw_fund_mast_all fmast

Line 1871: FROM igf_aw_fund_cat_all cat, igf_aw_fund_mast_all fmast

1867: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE
1868: )
1869: IS
1870: SELECT cat.fed_fund_code
1871: FROM igf_aw_fund_cat_all cat, igf_aw_fund_mast_all fmast
1872: WHERE fmast.fund_code = cat.fund_code AND fmast.fund_id = p_fund_id;
1873:
1874: get_fed_fund_code_rec cur_get_fed_fund_code%ROWTYPE;
1875: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;

Line 1899: l_old_fund igf_aw_fund_mast_all.fund_id%TYPE;

1895:
1896: -- following variables are used to make sure that the fund level,award level and term level
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;

Line 1900: l_new_fund igf_aw_fund_mast_all.fund_id%TYPE;

1896: -- following variables are used to make sure that the fund level,award level and term level
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;

Line 3252: p_dl_dummy IN VARCHAR2, p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

3248: -----------------------------------------------------------------------------------
3249: PROCEDURE rel_disb_process_dl(
3250: errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY NUMBER,
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: )

Line 3289: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

3285: -----------------------------------------------------------------------------------
3286: PROCEDURE rel_disb_process_fed(
3287: errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY NUMBER,
3288: p_award_year IN VARCHAR2,
3289: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
3290: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE, p_per_dummy IN NUMBER,
3291: p_loan_id IN NUMBER, p_loan_dummy IN NUMBER, p_trans_type IN VARCHAR2,
3292: p_per_grp_id IN NUMBER
3293: )

Line 3319: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

3315:
3316: PROCEDURE rel_disb_process(
3317: p_errbuf OUT NOCOPY VARCHAR2, p_retcode OUT NOCOPY NUMBER,
3318: p_award_year IN VARCHAR2,
3319: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
3320: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE, p_loan_id IN NUMBER,
3321: p_trans_type IN VARCHAR2, p_per_grp_id IN NUMBER
3322: )
3323: IS

Line 3363: CURSOR cur_award_std(p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)

3359:
3360: per_grp_rec cur_per_grp_name%ROWTYPE;
3361:
3362: -- Cursor to retreive Student having awards for a given fund
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,

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

Line 3388: CURSOR cur_get_fund_type(p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)

3384:
3385: get_awd_id_rec cur_get_awd_id%ROWTYPE;
3386:
3387: -- Get the fund type
3388: CURSOR cur_get_fund_type(p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
3389: IS
3390: SELECT cat.fed_fund_code fed_fund_code
3391: FROM igf_aw_fund_cat_all cat, igf_aw_fund_mast_all mast
3392: WHERE mast.fund_code = cat.fund_code AND mast.fund_id = p_fund_id;

Line 3391: FROM igf_aw_fund_cat_all cat, igf_aw_fund_mast_all mast

3387: -- Get the fund type
3388: CURSOR cur_get_fund_type(p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
3389: IS
3390: SELECT cat.fed_fund_code fed_fund_code
3391: FROM igf_aw_fund_cat_all cat, igf_aw_fund_mast_all mast
3392: WHERE mast.fund_code = cat.fund_code AND mast.fund_id = p_fund_id;
3393:
3394: get_fund_type_rec cur_get_fund_type%ROWTYPE;
3395: lv_group_type igs_pe_persid_group_v.group_type%TYPE;