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.

[Home] [Help]

APPS.IGF_AW_PACKAGING dependencies on IGF_AW_GEN_004

Line 7945: l_loan_amt := get_perct_amt(l_frml_plcy.max_loan_perct_fact,l_frml_plcy.max_loan_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);

7941: l_loan_amt := l_frml_plcy.max_loan_amt;
7942: ELSIF l_frml_plcy.max_loan_perct IS NULL THEN
7943: l_loan_amt := 0;
7944: ELSE
7945: l_loan_amt := get_perct_amt(l_frml_plcy.max_loan_perct_fact,l_frml_plcy.max_loan_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);
7946: END IF;
7947:
7948: -- Calculate the Max Grant Amt ( directly from the grant amt or grom the % defined at the Frml Policy level)
7949: IF l_frml_plcy.max_grant_amt IS NOT NULL THEN

Line 7955: l_grant_amt := get_perct_amt(l_frml_plcy.max_grant_perct_fact,l_frml_plcy.max_grant_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);

7951:
7952: ELSIF l_frml_plcy.max_grant_perct IS NULL THEN
7953: l_grant_amt := 0;
7954: ELSE
7955: l_grant_amt := get_perct_amt(l_frml_plcy.max_grant_perct_fact,l_frml_plcy.max_grant_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);
7956: END IF;
7957:
7958: -- Calculate the Max Work Amt ( directly from the work amt or from the % defined at the Frml Policy level)
7959: IF l_frml_plcy.max_work_amt IS NOT NULL THEN

Line 7965: l_work_amt := get_perct_amt(l_frml_plcy.max_work_perct_fact,l_frml_plcy.max_work_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);

7961:
7962: ELSIF l_frml_plcy.max_work_perct IS NULL THEN
7963: l_work_amt := 0;
7964: ELSE
7965: l_work_amt := get_perct_amt(l_frml_plcy.max_work_perct_fact,l_frml_plcy.max_work_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);
7966: END IF;
7967:
7968: -- Calculate the Max Self Help Amt
7969: IF l_frml_plcy.max_shelp_amt IS NOT NULL THEN

Line 7975: l_shelp_amt := get_perct_amt(l_frml_plcy.max_shelp_perct_fact,l_frml_plcy.max_shelp_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);

7971:
7972: ELSIF l_frml_plcy.max_shelp_perct IS NULL THEN
7973: l_shelp_amt := 0;
7974: ELSE
7975: l_shelp_amt := get_perct_amt(l_frml_plcy.max_shelp_perct_fact,l_frml_plcy.max_shelp_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);
7976: END IF;
7977:
7978: -- Calculate the Max Gift Aid Amt
7979: IF l_frml_plcy.max_gift_amt IS NOT NULL THEN

Line 7985: l_gift_amt := get_perct_amt(l_frml_plcy.max_gift_perct_fact,l_frml_plcy.max_gift_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);

7981:
7982: ELSIF l_frml_plcy.max_gift_perct IS NULL THEN
7983: l_gift_amt := 0;
7984: ELSE
7985: l_gift_amt := get_perct_amt(l_frml_plcy.max_gift_perct_fact,l_frml_plcy.max_gift_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);
7986: END IF;
7987:
7988: -- Calculate the Max Scholarship Amt
7989: IF l_frml_plcy.max_schlrshp_amt IS NOT NULL THEN

Line 7995: l_schlp_amt := get_perct_amt(l_frml_plcy.max_schlrshp_perct_fact,l_frml_plcy.max_schlrshp_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);

7991:
7992: ELSIF l_frml_plcy.max_schlrshp_perct IS NULL THEN
7993: l_schlp_amt := 0;
7994: ELSE
7995: l_schlp_amt := get_perct_amt(l_frml_plcy.max_schlrshp_perct_fact,l_frml_plcy.max_schlrshp_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);
7996: END IF;
7997:
7998: -- Calculate the Gap Amount
7999: IF l_frml_plcy.max_gap_amt IS NOT NULL THEN

Line 8005: l_gap_amt := get_perct_amt(l_frml_plcy.max_gap_perct_fact,l_frml_plcy.max_gap_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);

8001: ELSIF l_frml_plcy.max_gap_perct IS NULL THEN
8002:
8003: l_gap_amt := 0;
8004: ELSE
8005: l_gap_amt := get_perct_amt(l_frml_plcy.max_gap_perct_fact,l_frml_plcy.max_gap_perct,l_base_id,igf_aw_gen_004.efc_f(l_base_id,g_awd_prd),g_awd_prd);
8006: END IF;
8007:
8008: -- Get the Max Aid Package
8009: l_max_aid_pkg := l_frml_plcy.max_aid_pkg;

Line 9214: l_efc_i := igf_aw_gen_004.efc_i(l_fabase.base_id,g_awd_prd);

9210: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'c_rem_efc%NOTFOUND');
9211: END IF;
9212:
9213: -- If Awarding PROFILE is present for the student, get the EFC, NEED
9214: l_efc_i := igf_aw_gen_004.efc_i(l_fabase.base_id,g_awd_prd);
9215:
9216: IF l_use_fixed_costs = 'Y' THEN
9217: l_need_i := NVL(l_fabase.coa_fixed,0) - NVL(l_efc_i,0) - NVL(l_gap_amt,0);
9218: ELSE

Line 11442: g_awarded_aid(l_cnt).need_f := NVL(igf_aw_gen_004.need_f(l_fabase.base_id,g_awd_prd),0);

11438: END IF;
11439: l_cnt := 1;
11440: g_awarded_aid.extend;
11441: g_awarded_aid(l_cnt).base_id := l_fabase.base_id;
11442: g_awarded_aid(l_cnt).need_f := NVL(igf_aw_gen_004.need_f(l_fabase.base_id,g_awd_prd),0);
11443: g_awarded_aid(l_cnt).awarded_aid := NVL(l_aid,0);
11444: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11445: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'set g_awarded_aid('||l_cnt||').base_id:'||g_awarded_aid(l_cnt).base_id);
11446: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'set g_awarded_aid('||l_cnt||').need_f:'||g_awarded_aid(l_cnt).need_f);

Line 11490: g_awarded_aid(l_cnt).need_f := NVL(igf_aw_gen_004.need_f(l_fabase.base_id,g_awd_prd),0);

11486:
11487: l_cnt := l_cnt + 1;
11488: g_awarded_Aid.extend;
11489: g_awarded_aid(l_cnt).base_id := l_fabase.base_id;
11490: g_awarded_aid(l_cnt).need_f := NVL(igf_aw_gen_004.need_f(l_fabase.base_id,g_awd_prd),0);
11491: g_awarded_aid(l_cnt).awarded_aid := NVL(l_aid,0);
11492:
11493: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11494: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'l_rec_fnd=FALSE!g_awarded_aid('||l_cnt||').awarded_aid:'||g_awarded_aid(l_cnt).awarded_aid);