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_AW_GEN_002 dependencies on IGF_AW_GEN_002

Line 1: PACKAGE BODY igf_aw_gen_002 AS

1: PACKAGE BODY igf_aw_gen_002 AS
2: /* $Header: IGFAW10B.pls 120.3 2006/08/04 07:39:04 veramach ship $ */
3:
4: --------------------------------------------------------------------------------------
5: --veramach Oct 2004 FA 152/FA 137 - Changes to wrappers to include Award Period setup

Line 1704: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','Parameter List - START');

1700:
1701: BEGIN
1702:
1703: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1704: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','Parameter List - START');
1705: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_base_id: ' ||p_base_id);
1706: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_awd_prd_code: ' ||p_awd_prd_code);
1707: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_calc_for_subz_loan: ' ||p_calc_for_subz_loan);
1708: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','Parameter List - END');

Line 1705: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_base_id: ' ||p_base_id);

1701: BEGIN
1702:
1703: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1704: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','Parameter List - START');
1705: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_base_id: ' ||p_base_id);
1706: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_awd_prd_code: ' ||p_awd_prd_code);
1707: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_calc_for_subz_loan: ' ||p_calc_for_subz_loan);
1708: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','Parameter List - END');
1709: END IF;

Line 1706: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_awd_prd_code: ' ||p_awd_prd_code);

1702:
1703: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1704: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','Parameter List - START');
1705: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_base_id: ' ||p_base_id);
1706: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_awd_prd_code: ' ||p_awd_prd_code);
1707: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_calc_for_subz_loan: ' ||p_calc_for_subz_loan);
1708: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','Parameter List - END');
1709: END IF;
1710:

Line 1707: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_calc_for_subz_loan: ' ||p_calc_for_subz_loan);

1703: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1704: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','Parameter List - START');
1705: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_base_id: ' ||p_base_id);
1706: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_awd_prd_code: ' ||p_awd_prd_code);
1707: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_calc_for_subz_loan: ' ||p_calc_for_subz_loan);
1708: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','Parameter List - END');
1709: END IF;
1710:
1711: IF p_awd_prd_code IS NULL THEN

Line 1708: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','Parameter List - END');

1704: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','Parameter List - START');
1705: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_base_id: ' ||p_base_id);
1706: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_awd_prd_code: ' ||p_awd_prd_code);
1707: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_calc_for_subz_loan: ' ||p_calc_for_subz_loan);
1708: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','Parameter List - END');
1709: END IF;
1710:
1711: IF p_awd_prd_code IS NULL THEN
1712: -- AP not available

Line 1714: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','Awarding Period NOT available. Considering all awards for the Student in the Awd Yr as resource');

1710:
1711: IF p_awd_prd_code IS NULL THEN
1712: -- AP not available
1713: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1714: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','Awarding Period NOT available. Considering all awards for the Student in the Awd Yr as resource');
1715: END IF;
1716:
1717: OPEN resource_cur;
1718: FETCH resource_cur INTO resource_rec;

Line 1723: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','Awarding Period is available. Considering awards ONLY in Awarding Period ' ||p_awd_prd_code|| ' for the Student as resource');

1719: CLOSE resource_cur;
1720: ELSE
1721: -- AP available
1722: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1723: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','Awarding Period is available. Considering awards ONLY in Awarding Period ' ||p_awd_prd_code|| ' for the Student as resource');
1724: END IF;
1725:
1726: OPEN resource_cur_awd;
1727: FETCH resource_cur_awd INTO resource_rec;

Line 1747: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','Reducing p_resource_f_fc to EFC, bcoz the Replace_FC awds got by the student is > EFC');

1743:
1744: -- If the replace efc awards are more than the Fed EFC then reduce the resource_fm_f to the FED EFC.
1745: IF NVL(resource_rec.resource_fm_f,0) > ln_efc_f THEN
1746: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1747: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','Reducing p_resource_f_fc to EFC, bcoz the Replace_FC awds got by the student is > EFC');
1748: END IF;
1749:
1750: p_resource_f_fc := ln_efc_f;
1751: ELSE

Line 1758: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','l_coa: ' ||l_coa);

1754: -- Here the unmet need is adjusted with the replace FC funds.
1755: p_unmet_need_f := NVL(l_coa,0) - ln_efc_f - NVL(p_resource_f,0) + NVL(p_resource_f_fc,0);
1756:
1757: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1758: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','l_coa: ' ||l_coa);
1759: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','ln_efc_f: ' ||ln_efc_f|| ', ln_efc_i: ' ||ln_efc_i);
1760: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_resource_f: ' ||p_resource_f|| ', p_resource_i: ' ||p_resource_i);
1761: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_resource_f_fc: ' ||p_resource_f_fc|| ', p_resource_i_fc: ' ||p_resource_i_fc);
1762: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_unmet_need_f: ' ||p_unmet_need_f|| ', p_unmet_need_i: ' ||p_unmet_need_i);

Line 1759: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','ln_efc_f: ' ||ln_efc_f|| ', ln_efc_i: ' ||ln_efc_i);

1755: p_unmet_need_f := NVL(l_coa,0) - ln_efc_f - NVL(p_resource_f,0) + NVL(p_resource_f_fc,0);
1756:
1757: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1758: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','l_coa: ' ||l_coa);
1759: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','ln_efc_f: ' ||ln_efc_f|| ', ln_efc_i: ' ||ln_efc_i);
1760: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_resource_f: ' ||p_resource_f|| ', p_resource_i: ' ||p_resource_i);
1761: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_resource_f_fc: ' ||p_resource_f_fc|| ', p_resource_i_fc: ' ||p_resource_i_fc);
1762: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_unmet_need_f: ' ||p_unmet_need_f|| ', p_unmet_need_i: ' ||p_unmet_need_i);
1763: END IF;

Line 1760: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_resource_f: ' ||p_resource_f|| ', p_resource_i: ' ||p_resource_i);

1756:
1757: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1758: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','l_coa: ' ||l_coa);
1759: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','ln_efc_f: ' ||ln_efc_f|| ', ln_efc_i: ' ||ln_efc_i);
1760: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_resource_f: ' ||p_resource_f|| ', p_resource_i: ' ||p_resource_i);
1761: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_resource_f_fc: ' ||p_resource_f_fc|| ', p_resource_i_fc: ' ||p_resource_i_fc);
1762: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_unmet_need_f: ' ||p_unmet_need_f|| ', p_unmet_need_i: ' ||p_unmet_need_i);
1763: END IF;
1764:

Line 1761: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_resource_f_fc: ' ||p_resource_f_fc|| ', p_resource_i_fc: ' ||p_resource_i_fc);

1757: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1758: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','l_coa: ' ||l_coa);
1759: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','ln_efc_f: ' ||ln_efc_f|| ', ln_efc_i: ' ||ln_efc_i);
1760: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_resource_f: ' ||p_resource_f|| ', p_resource_i: ' ||p_resource_i);
1761: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_resource_f_fc: ' ||p_resource_f_fc|| ', p_resource_i_fc: ' ||p_resource_i_fc);
1762: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_unmet_need_f: ' ||p_unmet_need_f|| ', p_unmet_need_i: ' ||p_unmet_need_i);
1763: END IF;
1764:
1765: END get_resource_need;

Line 1762: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_unmet_need_f: ' ||p_unmet_need_f|| ', p_unmet_need_i: ' ||p_unmet_need_i);

1758: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','l_coa: ' ||l_coa);
1759: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','ln_efc_f: ' ||ln_efc_f|| ', ln_efc_i: ' ||ln_efc_i);
1760: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_resource_f: ' ||p_resource_f|| ', p_resource_i: ' ||p_resource_i);
1761: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_resource_f_fc: ' ||p_resource_f_fc|| ', p_resource_i_fc: ' ||p_resource_i_fc);
1762: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_002.get_resource_need.debug','p_unmet_need_f: ' ||p_unmet_need_f|| ', p_unmet_need_i: ' ||p_unmet_need_i);
1763: END IF;
1764:
1765: END get_resource_need;
1766:

Line 1767: END igf_aw_gen_002;

1763: END IF;
1764:
1765: END get_resource_need;
1766:
1767: END igf_aw_gen_002;