[Home] [Help]
70: app_exception.raise_exception;
71: END get_fund_desc;
72:
73: FUNCTION chk_attendance(
74: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
75: p_load_cal_type igs_ca_inst_all.cal_type%TYPE,
76: p_load_seq_number igs_ca_inst_all.sequence_number%TYPE,
77: p_min_att_type igs_en_atd_type_all.attendance_type%TYPE,
78: p_result OUT NOCOPY VARCHAR2
167: app_exception.raise_exception;
168: END chk_attendance;
169:
170: FUNCTION chk_fed_elig(
171: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE, p_fund_type VARCHAR2
172: )
173: RETURN BOOLEAN
174: AS
175:
180: --------------------------------------------------------------------------------------------
181:
182: --Get the eligibility status of the student for an active ISIR for the context Award Year
183:
184: CURSOR cur_fedl_elig(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
185: IS
186: SELECT
187: fabaserec.NSLDS_DATA_OVERRIDE_FLG,
188: match.nslds_match_flag
187: fabaserec.NSLDS_DATA_OVERRIDE_FLG,
188: match.nslds_match_flag
189: FROM
190: igf_ap_isir_matched match ,
191: igf_ap_fa_base_rec_all fabaserec
192: WHERE
193: match.base_id = p_base_id and
194: match.active_isir = 'Y' and
195: fabaserec.base_id =p_base_id;
275: app_exception.raise_exception;
276: END chk_loan_active;
277:
278: FUNCTION per_in_fa(
279: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE, p_ci_cal_type VARCHAR2,
280: p_ci_sequence_number NUMBER, p_base_id OUT NOCOPY NUMBER
281: )
282:
283: --------------------------------------------------------------------------------------------
288:
289: RETURN VARCHAR2
290: IS
291: CURSOR cur_get_pers_num(
292: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE
293: )
294: IS
295: SELECT person_number
296: FROM igs_pe_person_base_v
300:
301: CURSOR cur_get_base(
302: p_cal_type igs_ca_inst_all.cal_type%TYPE,
303: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,
304: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE
305: )
306: IS
307: SELECT base_id
308: FROM igf_ap_fa_base_rec
625: END IF;
626: END chk_fund_meth_dl;
627:
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,
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
833: /*
844:
845:
846:
847: CURSOR c_student_details(
848: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
849: )
850: IS
851: SELECT manual_disb_hold, fa_process_status
852: FROM igf_ap_fa_base_rec
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
863: )
864: IS
865: SELECT fed_verif_status
866: FROM igf_ap_fa_base_rec fab
875: 'WAIVED'
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
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
904: WHERE fmast.fund_id = cp_fund_id
905: AND fa.base_id = cp_base_id
906: AND fa.person_id = tdinst.person_id
907: AND fndtd.fund_id = fmast.fund_id
999: app_exception.raise_exception;
1000: END chk_todo_result;
1001:
1002: PROCEDURE insert_pays_prg_uts(
1003: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1004: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,
1005: p_acad_ci_seq_num igs_ca_inst_all.sequence_number%TYPE
1006: )
1007: AS
1036:
1037: -- Get all the programs,unit attempts in which student has 'enrolled'
1038:
1039: CURSOR cur_get_att(
1040: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
1041: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,
1042: p_tp_cal_type igs_ca_inst_all.cal_type%TYPE,
1043: p_tp_sequence_number igs_ca_inst_all.sequence_number%TYPE
1044: )
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
1136:
1148: -- If there are no records, the check is failed else passed
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
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
1218:
1230: -- If there are no records, the check is failed else passed
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
1291: app_exception.raise_exception;
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: )
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: )
1341: IS
1342: SELECT fee_class
1343: FROM igf_aw_fund_feeclas
1705:
1706: --------------------------------------------------------------------------------------------------------------------------------
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,
1752:
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
1782:
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: )
1808:
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: )
1836:
1837:
1838: -- Cursor to get Verification Status of Student
1839:
1840: CURSOR cur_get_ver(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
1841: IS
1842: SELECT NVL(fed_verif_status, '*') fed_verif_status
1843: FROM igf_ap_fa_base_rec
1844: WHERE base_id = p_base_id;
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: )
3257:
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: )
3294:
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
3324: param_exception EXCEPTION;