[Home] [Help]
1362:
1363: END get_pell_matrix_amt ;
1364:
1365: FUNCTION num_disb(
1366: p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1367: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
1368: p_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
1369: ) RETURN NUMBER AS
1370: ------------------------------------------------------------------
1381: -------------------------------------------------------------------
1382:
1383: -- Get number of disbursements
1384: CURSOR c_num_disb(
1385: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1386: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
1387: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
1388: ) IS
1389: SELECT COUNT (*) num_disb
1405:
1406: PROCEDURE round_term_disbursements (
1407: p_pell_tab IN OUT NOCOPY pell_tab,
1408: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
1409: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
1410: p_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1411: p_ld_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
1412: p_term_amt IN NUMBER,
1413: p_tp_count IN NUMBER,
1649:
1650: PROCEDURE round_all_disbursements(
1651: p_pell_tab IN OUT NOCOPY pell_tab,
1652: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
1653: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
1654: p_aid IN NUMBER,
1655: p_disb_count IN NUMBER,
1656: p_pkg_awd_status IN igf_aw_fund_mast_all.pckg_awd_stat%TYPE,
1657: p_return_status OUT NOCOPY VARCHAR2
1868: END round_all_disbursements;
1869:
1870: PROCEDURE calc_pell(
1871: cp_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
1872: cp_plan_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
1873: cp_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
1874: cp_aid IN OUT NOCOPY NUMBER,
1875: cp_pell_tab IN OUT NOCOPY pell_tab,
1876: cp_return_status IN OUT NOCOPY VARCHAR2,
1962:
1963: -- Get the Count of the Common Terms for the Student
1964: CURSOR c_terms(
1965: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1966: l_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
1967: ) IS
1968: SELECT COUNT(*) Total_terms FROM (
1969: SELECT
1970: terms.ld_cal_type,
1984:
1985: -- Get the Count of the Common Terms for the Student
1986: CURSOR c_dp_terms(
1987: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1988: l_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
1989: ) IS
1990:
1991: SELECT COUNT(*) Total_terms FROM (
1992: SELECT
2000: );
2001:
2002: -- Get the Terms for the Student, Common between COA / DPlan
2003: CURSOR c_terms_det(
2004: l_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
2005: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE
2006: ) IS
2007: SELECT NVL (igf_aw_packaging.get_date_instance (
2008: l_base_id,
2079: l_ofst_rec c_get_ofst%ROWTYPE;
2080:
2081: -- Get CP Plan details
2082: CURSOR c_dp_details(
2083: l_plan_id igf_aw_awd_dist_plans.adplans_id%TYPE) IS
2084: SELECT
2085: dp.adplans_id,
2086: dp.awd_dist_plan_cd,
2087: dp.awd_dist_plan_cd_desc,
2086: dp.awd_dist_plan_cd,
2087: dp.awd_dist_plan_cd_desc,
2088: dp.dist_plan_method_code
2089: FROM
2090: igf_aw_awd_dist_plans dp
2091: WHERE
2092: dp.adplans_id = l_plan_id;
2093:
2094: l_dp_details_rec c_dp_details%ROWTYPE;
2154:
2155: -- Gets anticipated Key Program details
2156: CURSOR cur_get_ant_key_prog_ver(
2157: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
2158: cp_plan_id igf_aw_awd_dist_plans.adplans_id%TYPE
2159: )
2160: IS
2161: SELECT
2162: ant_data.program_cd key_prog,
2197:
2198: -- Returns the terms in the (distribution plan + COA) and the number of teaching periods
2199: -- in each term
2200: CURSOR cur_get_term_info (
2201: cp_plan_id igf_aw_awd_dist_plans.adplans_id%TYPE,
2202: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
2203: )
2204: IS
2205: SELECT