[Home] [Help]
358:
359: END get_sectionii_stdnt;
360:
361:
362: FUNCTION get_sectionvi_fund ( p_rec_type IN igf_aw_fisap_vi_h.rec_type%TYPE,
363: p_fund_type IN igf_aw_award_v.fed_fund_code%TYPE,
364: p_depend_stat IN igf_lookups_view.lookup_code%TYPE,
365: p_class_standing IN igf_lookups_view.lookup_code%TYPE,
366: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
388: -- return -2 if incorrect values passed for AUTO_ZERO_EFC
389: -- return -3 if any Unhandled Exception is Raised.
390: /*
391: CURSOR c_non_proff_fund_count (
392: cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
393: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
394: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
395: cp_class_standing igf_lookups_view.lookup_code%TYPE,
396: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
420: AND isir.fti BETWEEN cp_minvalue AND cp_maxvalue
421: AND cp_rec_type ='NON_PROFESSIONAL';
422:
423:
424: CURSOR c_proff_fund_count ( cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
425: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
426: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
427: cp_class_standing igf_lookups_view.lookup_code%TYPE,
428: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
452: WHERE cl.class_standing ='3' )
453: AND cp_rec_type ='PROFESSIONAL';
454:
455: CURSOR c_less_ft_fund_count (
456: cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
457: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
458: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
459: cp_class_standing igf_lookups_view.lookup_code%TYPE,
460: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
484: WHERE cl.class_standing IN ('1','2','3') )
485: AND cp_rec_type ='LESS_THAN_FULL_TIME';
486:
487: CURSOR c_auto_efc_fund_count (
488: cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
489: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
490: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
491: cp_class_standing igf_lookups_view.lookup_code%TYPE,
492: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
515: WHERE cl.class_standing IN ('1','2','3') )
516: AND cp_rec_type ='AUTO_ZERO';
517: */
518:
519: l_fnd_cnt igf_aw_fisap_vi_h.fseog_fund_total%TYPE DEFAULT 0;
520: -- fund total is same data type for
521: -- all the 3 funds.
522:
523: l_rec_type igf_aw_fisap_vi_h.rec_type%TYPE;
519: l_fnd_cnt igf_aw_fisap_vi_h.fseog_fund_total%TYPE DEFAULT 0;
520: -- fund total is same data type for
521: -- all the 3 funds.
522:
523: l_rec_type igf_aw_fisap_vi_h.rec_type%TYPE;
524: l_fund_type igf_aw_award_v.fed_fund_code%TYPE;
525:
526: BEGIN
527: -- code commented as part of Fa132. function only returns 0 since this function is being used
678:
679: END get_sectionvi_fund;
680:
681:
682: FUNCTION get_sectionvi_stdnt (p_rec_type IN igf_aw_fisap_vi_h.rec_type%TYPE,
683: p_fund_type IN igf_aw_award_v.fed_fund_code%TYPE,
684: p_depend_stat IN igf_lookups_view.lookup_code%TYPE,
685: p_class_standing IN igf_lookups_view.lookup_code%TYPE,
686: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
709:
710: -- This cursor would check for the fund types "FWS, PRK, FSEOG"
711: -- and class Standing as 4 ( 4 combination of 1 and 2) and REC_TYPE as "NON_PROFESSIONAL"
712: /*
713: CURSOR c_non_proff_std_count (cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
714: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
715: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
716: cp_class_standing igf_lookups_view.lookup_code%TYPE,
717: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
746: -- This cursor will get for dependency Status " I" and the
747: -- p_rec_type ='PROFESSIONAL' and the fund_type 'FWS' or 'PRK'
748: -- there is no FSEOG fund for Profession cat.
749:
750: CURSOR c_proff_std_count (cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
751: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
752: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
753: cp_class_standing igf_lookups_view.lookup_code%TYPE,
754: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
781:
782: --For total Less than full Time students
783: --The dependency status passed to this "B", valid fed_fund_code and not 'UNDUPL'
784: --and class standing passed would be GRAD-UGRAD
785: CURSOR c_less_ft_std_count (cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
786: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
787: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
788: cp_class_standing igf_lookups_view.lookup_code%TYPE,
789: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
815:
816: --The dependency status passed to this "B", valid
817: --FED_FUND_CODE and not 'UNDUPL' and class standing passed would be GRAD-UGRAD
818:
819: CURSOR c_auto_efc_std_count ( cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
820: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
821: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
822: cp_class_standing igf_lookups_view.lookup_code%TYPE,
823: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
848: AND cp_rec_type ='AUTO_ZERO';
849: -- This cursor would check for the fund types "FWS, PRK, FSEOG"
850: -- and class Standing as 4 and REC_TYPE as "NON_PROFESSIONAL" and Unduplicate student
851:
852: CURSOR c_non_proff_und_std_count (cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
853: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
854: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
855: cp_class_standing igf_lookups_view.lookup_code%TYPE,
856: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
885: -- This cursor will get for dependency Status " I" and the
886: -- p_rec_type ='PROFESSIONAL' and the fund_type 'FWS' or 'PRK' and Unduplicate
887: -- there is no FSEOG fund for Profession cat.
888:
889: CURSOR c_proff_und_std_count (cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
890: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
891: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
892: cp_class_standing igf_lookups_view.lookup_code%TYPE,
893: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
920: --For total Less than full Time students
921: --The dependency status passed to this "B", valid fed_fund_code and 'UNDUPL'
922: --and class standing passed would be GRAD-UGRAD
923:
924: CURSOR c_less_ft_und_std_count (cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
925: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
926: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
927: cp_class_standing igf_lookups_view.lookup_code%TYPE,
928: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
955:
956: --The dependency status passed to this "B", valid
957: --FED_FUND_CODE and 'UNDUPL' and class standing passed would be GRAD-UGRAD
958:
959: CURSOR c_auto_efc_und_std_count ( cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
960: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
961: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
962: cp_class_standing igf_lookups_view.lookup_code%TYPE,
963: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
987: WHERE cl.class_standing IN ('1','2','3') )
988: AND cp_rec_type ='AUTO_ZERO';
989: */
990: l_std_cnt igf_aw_fisap_ii_h.student_count%TYPE DEFAULT 0;
991: l_rec_type igf_aw_fisap_vi_h.rec_type%TYPE;
992: l_fund_type igf_aw_award_v.fed_fund_code%TYPE;
993:
994: BEGIN
995: -- code commented as part of Fa132. function only returns 0 since this function is being used