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_GR_PELL_CALC dependencies on IGF_AW_FUND_MAST

Line 314: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,

310: AND gap.attending_pell_cd = l_att_pell_id
311: AND gap.rcampus_id = rep.rcampus_id;
312:
313: CURSOR c_pell_setup(
314: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
315: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
316: l_reporting_pell_id igf_gr_pell_setup.rep_pell_id%TYPE,
317: l_course_cd igf_gr_pell_setup.course_cd%TYPE,
318: l_version_number igf_gr_pell_setup.version_number%TYPE

Line 315: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,

311: AND gap.rcampus_id = rep.rcampus_id;
312:
313: CURSOR c_pell_setup(
314: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
315: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
316: l_reporting_pell_id igf_gr_pell_setup.rep_pell_id%TYPE,
317: l_course_cd igf_gr_pell_setup.course_cd%TYPE,
318: l_version_number igf_gr_pell_setup.version_number%TYPE
319: )

Line 330: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,

326: AND pell.course_cd = l_course_cd
327: AND pell.version_number = l_version_number;
328:
329: CURSOR c_pell_def_setup(
330: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
331: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
332: l_reporting_pell_id igf_gr_pell_setup.rep_pell_id%TYPE
333: )
334: IS

Line 331: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,

327: AND pell.version_number = l_version_number;
328:
329: CURSOR c_pell_def_setup(
330: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
331: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
332: l_reporting_pell_id igf_gr_pell_setup.rep_pell_id%TYPE
333: )
334: IS
335: SELECT pell.*

Line 366: l_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,

362: AND gap.atd_entity_id_txt = l_atd_entity_id
363: AND gap.rcampus_id = rep.rcampus_id;
364:
365: CURSOR c_pell_def_setup_cod(
366: l_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,
367: l_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE,
368: l_rep_entity_id igf_gr_pell_setup_all.rep_entity_id_txt%TYPE
369: )
370: IS

Line 367: l_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE,

363: AND gap.rcampus_id = rep.rcampus_id;
364:
365: CURSOR c_pell_def_setup_cod(
366: l_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,
367: l_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE,
368: l_rep_entity_id igf_gr_pell_setup_all.rep_entity_id_txt%TYPE
369: )
370: IS
371: SELECT pell.*

Line 380: l_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,

376: AND pell.course_cd IS NULL
377: AND pell.version_number IS NULL;
378:
379: CURSOR c_pell_ovrd_setup_cod(
380: l_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,
381: l_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE,
382: l_rep_entity_id igf_gr_pell_setup_all.rep_entity_id_txt%TYPE,
383: l_course_cd igf_gr_pell_setup_all.course_cd%TYPE,
384: l_version_number igf_gr_pell_setup_all.version_number%TYPE

Line 381: l_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE,

377: AND pell.version_number IS NULL;
378:
379: CURSOR c_pell_ovrd_setup_cod(
380: l_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,
381: l_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE,
382: l_rep_entity_id igf_gr_pell_setup_all.rep_entity_id_txt%TYPE,
383: l_course_cd igf_gr_pell_setup_all.course_cd%TYPE,
384: l_version_number igf_gr_pell_setup_all.version_number%TYPE
385: )

Line 1213: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,

1209: -- Schdl Pell Award from Regular Pell Matrix
1210: --
1211:
1212: CURSOR c_pell_rng(
1213: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
1214: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
1215: l_coa igf_gr_reg_amts.coa_range_start%TYPE,
1216: l_efc igf_gr_reg_amts.efc_range_start%TYPE,
1217: l_enrl_stat igf_gr_reg_amts.enrollment_stat_code%TYPE

Line 1214: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,

1210: --
1211:
1212: CURSOR c_pell_rng(
1213: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
1214: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
1215: l_coa igf_gr_reg_amts.coa_range_start%TYPE,
1216: l_efc igf_gr_reg_amts.efc_range_start%TYPE,
1217: l_enrl_stat igf_gr_reg_amts.enrollment_stat_code%TYPE
1218: ) IS

Line 1237: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,

1233: -- Schdl Pell Award from Alternate Pell Matrix
1234: --
1235:
1236: CURSOR c_alt_pell(
1237: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
1238: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
1239: l_coa igf_gr_alt_amts.coa_range_start%TYPE,
1240: l_altexp igf_gr_alt_amts.exp_range_start%TYPE,
1241: l_efc igf_gr_reg_amts.efc_range_start%TYPE,

Line 1238: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,

1234: --
1235:
1236: CURSOR c_alt_pell(
1237: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
1238: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
1239: l_coa igf_gr_alt_amts.coa_range_start%TYPE,
1240: l_altexp igf_gr_alt_amts.exp_range_start%TYPE,
1241: l_efc igf_gr_reg_amts.efc_range_start%TYPE,
1242: l_enrl_stat igf_gr_reg_amts.enrollment_stat_code%TYPE

Line 1408: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

1404: END 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,

Line 1414: p_pkg_awd_status IN igf_aw_fund_mast_all.pckg_awd_stat%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,
1414: p_pkg_awd_status IN igf_aw_fund_mast_all.pckg_awd_stat%TYPE,
1415: p_return_status OUT NOCOPY VARCHAR2
1416: )
1417: IS
1418: /*

Line 1429: l_disb_round_factor igf_aw_fund_mast.disb_rounding_code%TYPE := NULL;

1425: || Who When What
1426: || (reverse chronological order - newest change first)
1427: */
1428:
1429: l_disb_round_factor igf_aw_fund_mast.disb_rounding_code%TYPE := NULL;
1430: l_trunc_factor NUMBER := 0;
1431: l_extra_factor NUMBER := 0;
1432: l_disb_no NUMBER := 0;
1433: l_special_disb_no NUMBER := 0;

Line 1652: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

1648:
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,

Line 1656: p_pkg_awd_status IN igf_aw_fund_mast_all.pckg_awd_stat%TYPE,

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
1658: ) AS
1659: ------------------------------------------------------------------
1660: --Created by : veramach, Oracle India

Line 1671: l_disb_round_factor igf_aw_fund_mast.disb_rounding_code%TYPE := NULL;

1667: --
1668: --Change History:
1669: --Who When What
1670: -------------------------------------------------------------------
1671: l_disb_round_factor igf_aw_fund_mast.disb_rounding_code%TYPE := NULL;
1672: l_trunc_factor NUMBER := 0;
1673: l_extra_factor NUMBER := 0;
1674: l_disb_no NUMBER := 0;
1675: l_special_disb_no NUMBER := 0;

Line 1871: cp_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

1867: app_exception.raise_exception;
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,

Line 2048: CURSOR c_fund ( l_fund_id igf_aw_fund_mast_all.fund_id%TYPE

2044:
2045: l_base_rec c_base%ROWTYPE;
2046:
2047: -- Get The Fund Details
2048: CURSOR c_fund ( l_fund_id igf_aw_fund_mast_all.fund_id%TYPE
2049: ) IS
2050: SELECT
2051: fm.disb_exp_da,
2052: fm.disb_verf_da,

Line 2055: FROM igf_aw_fund_mast fm

2051: fm.disb_exp_da,
2052: fm.disb_verf_da,
2053: fm.show_on_bill,
2054: fm.pckg_awd_stat
2055: FROM igf_aw_fund_mast fm
2056: WHERE
2057: fm.fund_id = l_fund_id ;
2058:
2059: l_fund_rec c_fund%ROWTYPE;

Line 2227: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE

2223: -- museshad (Build# FA 157 Pell disbursement rounding)
2224:
2225: -- Get roundoff_fact
2226: CURSOR c_roundoff_fact(
2227: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE
2228: ) IS
2229: SELECT roundoff_fact
2230: FROM igf_aw_fund_mast_all
2231: WHERE fund_id = cp_fund_id;

Line 2230: FROM igf_aw_fund_mast_all

2226: CURSOR c_roundoff_fact(
2227: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE
2228: ) IS
2229: SELECT roundoff_fact
2230: FROM igf_aw_fund_mast_all
2231: WHERE fund_id = cp_fund_id;
2232: l_roundoff_fact igf_aw_fund_mast_all.roundoff_fact%TYPE;
2233:
2234: BEGIN

Line 2232: l_roundoff_fact igf_aw_fund_mast_all.roundoff_fact%TYPE;

2228: ) IS
2229: SELECT roundoff_fact
2230: FROM igf_aw_fund_mast_all
2231: WHERE fund_id = cp_fund_id;
2232: l_roundoff_fact igf_aw_fund_mast_all.roundoff_fact%TYPE;
2233:
2234: BEGIN
2235: l_pell_amt := 0;
2236: l_ft_pell_amt := 0;

Line 3246: igf_aw_fund_mast_all fmast,

3242: CURSOR cur_get_awd_round_fact(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
3243: IS
3244: SELECT LTRIM(RTRIM(roundoff_fact)) roundoff_fact
3245: FROM
3246: igf_aw_fund_mast_all fmast,
3247: igf_ap_fa_base_rec_all fabase
3248: WHERE
3249: fabase.base_id = cp_base_id AND
3250: fabase.ci_cal_type = fmast.ci_cal_type AND