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_PACKAGING dependencies on IGF_AW_AWARD_T

Line 81: || 1.Added logic to insert 2 rows into igf_aw_award_t table which holds IM/FM needs in calc_need

77: || l_method, l_pct, l_fseog_cnt, l_fseog_sum,
78: || l_match_pct, cursor c_match_method
79: || and cursor variable l_method_rec.
80: || veramach 13-OCT-2003 FA 124 Build Remove ISIR Requirement for Awarding
81: || 1.Added logic to insert 2 rows into igf_aw_award_t table which holds IM/FM needs in calc_need
82: || 2.Added logic to error out if a student does not have active ISIR in multiple fund packaging in stud_run
83: || 3.Added logic as specified in the logic flow specified in the TD in process_stud
84: || 4.Added logic for validations on g_sf_max_award_amt,g_sf_min_award_amt,g_allow_to_exceed in run
85: || 5.Removed p_grp_code parameter and added p_sf_min_amount,p_sf_max_amount,p_allow_to_exceed in pkg_single_fund

Line 271: Important : The following are the statuses present for the igf_aw_award_t.flag

267: || The Cost of Attendance Process must be run before Running Packaging
268:
269:
270: -------------------------------------------------------------------------------
271: Important : The following are the statuses present for the igf_aw_award_t.flag
272: -------------------------------------------------------------------------------
273: AA - Already Awarded fund to the student.(Will exist only if the student has awards)
274: AW - Selected for Award, before Fund checks.
275: CF - Initial loaded INTO the temporary table.

Line 885: igf_aw_award_t_pkg.insert_row(

881: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
882: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_students_need.debug '|| g_req_id,'Calculated NEED values are l_normal_efc: '||l_normal_efc||' and p_coa : '||p_coa);
883: END IF;
884:
885: igf_aw_award_t_pkg.insert_row(
886: x_rowid => lv_rowid ,
887: x_process_id => l_process_id ,
888: x_sl_number => l_sl_number,
889: x_fund_id => NULL,

Line 1025: FROM igf_aw_award_t

1021:
1022: -- Get the details of students from the Temp Table in the descending order of their needs
1023: CURSOR c_ordered_stdnts IS
1024: SELECT base_id
1025: FROM igf_aw_award_t
1026: WHERE flag = 'ST'
1027: AND process_id = l_process_id
1028: ORDER BY temp_num_val2 DESC;
1029:

Line 1663: p_process_id igf_aw_award_t.process_id%TYPE,

1659: END IF;
1660: END cancel_invalid_award;
1661:
1662: PROCEDURE cancel_awards(
1663: p_process_id igf_aw_award_t.process_id%TYPE,
1664: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1665: ) AS
1666: ------------------------------------------------------------------
1667: --Created by : veramach, Oracle India

Line 1681: cp_process_id igf_aw_award_t.process_id%TYPE,

1677: -------------------------------------------------------------------
1678:
1679: -- Get cancelled awards
1680: CURSOR c_cancelled_awards(
1681: cp_process_id igf_aw_award_t.process_id%TYPE,
1682: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1683: ) IS
1684: SELECT awdt.award_id
1685: FROM igf_aw_award_t awdt

Line 1685: FROM igf_aw_award_t awdt

1681: cp_process_id igf_aw_award_t.process_id%TYPE,
1682: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1683: ) IS
1684: SELECT awdt.award_id
1685: FROM igf_aw_award_t awdt
1686: WHERE process_id = cp_process_id
1687: AND base_id = cp_base_id
1688: AND flag IN ('AC','AR');
1689:

Line 1704: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,

1700: END LOOP;
1701: END cancel_awards;
1702:
1703: PROCEDURE round_off_disbursements(
1704: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
1705: p_base_id IN igf_aw_award_t_all.base_id%TYPE,
1706: p_process_id IN igf_aw_award_t_all.process_id%TYPE,
1707: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
1708: p_adplans_id IN igf_aw_award_t_all.adplans_id%TYPE,

Line 1705: p_base_id IN igf_aw_award_t_all.base_id%TYPE,

1701: END cancel_awards;
1702:
1703: PROCEDURE round_off_disbursements(
1704: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
1705: p_base_id IN igf_aw_award_t_all.base_id%TYPE,
1706: p_process_id IN igf_aw_award_t_all.process_id%TYPE,
1707: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
1708: p_adplans_id IN igf_aw_award_t_all.adplans_id%TYPE,
1709: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,

Line 1706: p_process_id IN igf_aw_award_t_all.process_id%TYPE,

1702:
1703: PROCEDURE round_off_disbursements(
1704: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
1705: p_base_id IN igf_aw_award_t_all.base_id%TYPE,
1706: p_process_id IN igf_aw_award_t_all.process_id%TYPE,
1707: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
1708: p_adplans_id IN igf_aw_award_t_all.adplans_id%TYPE,
1709: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
1710: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,

Line 1707: p_award_id IN igf_aw_award_t_all.award_id%TYPE,

1703: PROCEDURE round_off_disbursements(
1704: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
1705: p_base_id IN igf_aw_award_t_all.base_id%TYPE,
1706: p_process_id IN igf_aw_award_t_all.process_id%TYPE,
1707: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
1708: p_adplans_id IN igf_aw_award_t_all.adplans_id%TYPE,
1709: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
1710: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
1711: p_disb_count IN NUMBER

Line 1708: p_adplans_id IN igf_aw_award_t_all.adplans_id%TYPE,

1704: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
1705: p_base_id IN igf_aw_award_t_all.base_id%TYPE,
1706: p_process_id IN igf_aw_award_t_all.process_id%TYPE,
1707: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
1708: p_adplans_id IN igf_aw_award_t_all.adplans_id%TYPE,
1709: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
1710: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
1711: p_disb_count IN NUMBER
1712: )

Line 1709: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,

1705: p_base_id IN igf_aw_award_t_all.base_id%TYPE,
1706: p_process_id IN igf_aw_award_t_all.process_id%TYPE,
1707: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
1708: p_adplans_id IN igf_aw_award_t_all.adplans_id%TYPE,
1709: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
1710: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
1711: p_disb_count IN NUMBER
1712: )
1713: IS

Line 1722: || IGF_AW_AWARD_T table.

1718: || Calculates the disbursement amount based on the
1719: || disbursement rounding factor. The procedure fills the
1720: || PL/SQL table 'l_disb_structure_tab' with the disbursement
1721: || amounts. This PL/SQL table is then used to update the
1722: || IGF_AW_AWARD_T table.
1723: ||
1724: || Note, this procedure holds good only for non-PELL funds.
1725: || Disbursement rounding for Pell is handled in IGFGR11B.pls
1726: ||

Line 1770: cp_fund_id igf_aw_award_t_all.fund_id%TYPE,

1766: -- Returns all the disbursements in the temporary table
1767: -- The ORDER BY clause ensures that the disbursements are returned
1768: -- in the order of their creation
1769: CURSOR cur_get_all_disb (
1770: cp_fund_id igf_aw_award_t_all.fund_id%TYPE,
1771: cp_base_id igf_aw_award_t_all.base_id%TYPE,
1772: cp_process_id igf_aw_award_t_all.process_id%TYPE,
1773: cp_adplans_id igf_aw_award_t_all.adplans_id%TYPE,
1774: p_award_id igf_aw_award_t_all.award_id%TYPE

Line 1771: cp_base_id igf_aw_award_t_all.base_id%TYPE,

1767: -- The ORDER BY clause ensures that the disbursements are returned
1768: -- in the order of their creation
1769: CURSOR cur_get_all_disb (
1770: cp_fund_id igf_aw_award_t_all.fund_id%TYPE,
1771: cp_base_id igf_aw_award_t_all.base_id%TYPE,
1772: cp_process_id igf_aw_award_t_all.process_id%TYPE,
1773: cp_adplans_id igf_aw_award_t_all.adplans_id%TYPE,
1774: p_award_id igf_aw_award_t_all.award_id%TYPE
1775: )

Line 1772: cp_process_id igf_aw_award_t_all.process_id%TYPE,

1768: -- in the order of their creation
1769: CURSOR cur_get_all_disb (
1770: cp_fund_id igf_aw_award_t_all.fund_id%TYPE,
1771: cp_base_id igf_aw_award_t_all.base_id%TYPE,
1772: cp_process_id igf_aw_award_t_all.process_id%TYPE,
1773: cp_adplans_id igf_aw_award_t_all.adplans_id%TYPE,
1774: p_award_id igf_aw_award_t_all.award_id%TYPE
1775: )
1776: IS

Line 1773: cp_adplans_id igf_aw_award_t_all.adplans_id%TYPE,

1769: CURSOR cur_get_all_disb (
1770: cp_fund_id igf_aw_award_t_all.fund_id%TYPE,
1771: cp_base_id igf_aw_award_t_all.base_id%TYPE,
1772: cp_process_id igf_aw_award_t_all.process_id%TYPE,
1773: cp_adplans_id igf_aw_award_t_all.adplans_id%TYPE,
1774: p_award_id igf_aw_award_t_all.award_id%TYPE
1775: )
1776: IS
1777: SELECT awd_t.rowid, awd_t.*

Line 1774: p_award_id igf_aw_award_t_all.award_id%TYPE

1770: cp_fund_id igf_aw_award_t_all.fund_id%TYPE,
1771: cp_base_id igf_aw_award_t_all.base_id%TYPE,
1772: cp_process_id igf_aw_award_t_all.process_id%TYPE,
1773: cp_adplans_id igf_aw_award_t_all.adplans_id%TYPE,
1774: p_award_id igf_aw_award_t_all.award_id%TYPE
1775: )
1776: IS
1777: SELECT awd_t.rowid, awd_t.*
1778: FROM igf_aw_award_t_all awd_t

Line 1778: FROM igf_aw_award_t_all awd_t

1774: p_award_id igf_aw_award_t_all.award_id%TYPE
1775: )
1776: IS
1777: SELECT awd_t.rowid, awd_t.*
1778: FROM igf_aw_award_t_all awd_t
1779: WHERE
1780: base_id = p_base_id AND
1781: fund_id = p_fund_id AND
1782: process_id = p_process_id AND

Line 1989: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_packaging.round_off_disbursements.debug '|| g_req_id, 'Updating temp table(igf_aw_award_t) with the rounded disbursement amounts.');

1985: END IF; -- End of disb_round_factor
1986:
1987: -- Log values
1988: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1989: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_packaging.round_off_disbursements.debug '|| g_req_id, 'Updating temp table(igf_aw_award_t) with the rounded disbursement amounts.');
1990: END IF;
1991:
1992: -- All the rounded disbursement amounts are now available in the PL/SQL table
1993: -- Update these to the temporary table

Line 2013: igf_aw_award_t_pkg.update_row(

2009: 'igf.plsql.igf_aw_packaging.round_off_disbursements.debug '|| g_req_id,
2010: 'Disbursement number: ' ||l_disb_no|| ' Old Disbursement amount: ' ||l_disb_rec.temp_num_val1|| ' New disbursement amount after applying rounding logic: ' ||NVL(l_disb_structure_rec(l_disb_no).disb_amt, 0));
2011: END IF;
2012:
2013: igf_aw_award_t_pkg.update_row(
2014: x_rowid => l_disb_rec.rowid,
2015: x_process_id => l_disb_rec.process_id,
2016: x_sl_number => l_disb_rec.sl_number,
2017: x_fund_id => l_disb_rec.fund_id,

Line 2134: CURSOR c_awd_tot( x_process_id igf_aw_award_t.process_id%TYPE,

2130: || pmarada 13-Feb-2002 Modified as part of FACR008-correspondence build, updateing fabase rec.
2131: */
2132:
2133: -- Get all the awards which can be awarded to the students
2134: CURSOR c_awd_tot( x_process_id igf_aw_award_t.process_id%TYPE,
2135: x_base_id igf_aw_award_t.base_id%TYPE ) IS
2136: SELECT awdt.fund_id,
2137: awdt.adplans_id,
2138: NVL(awdt.offered_amt,0) offered_amt,

Line 2135: x_base_id igf_aw_award_t.base_id%TYPE ) IS

2131: */
2132:
2133: -- Get all the awards which can be awarded to the students
2134: CURSOR c_awd_tot( x_process_id igf_aw_award_t.process_id%TYPE,
2135: x_base_id igf_aw_award_t.base_id%TYPE ) IS
2136: SELECT awdt.fund_id,
2137: awdt.adplans_id,
2138: NVL(awdt.offered_amt,0) offered_amt,
2139: NVL(awdt.accepted_amt,0) accepted_amt,

Line 2144: FROM igf_aw_award_t awdt

2140: temp_char_val1 over_award,
2141: temp_num_val1 common_perct,
2142: award_id,
2143: lock_award_flag
2144: FROM igf_aw_award_t awdt
2145: WHERE awdt.process_id = x_process_id
2146: AND awdt.base_id = x_base_id
2147: AND awdt.flag = 'FL';
2148:

Line 2190: FROM igf_aw_award_t awdt

2186: x_adplans_id NUMBER,
2187: x_award_id NUMBER
2188: ) IS
2189: SELECT awdt.*
2190: FROM igf_aw_award_t awdt
2191: WHERE base_id = x_base_id
2192: AND fund_id = x_fund_id
2193: AND process_id = x_process_id
2194: AND NVL(award_id,-1) = NVL(x_award_id,-1)

Line 2210: FROM igf_aw_award_t awdt

2206: x_adplans_id NUMBER,
2207: x_award_id NUMBER
2208: ) IS
2209: SELECT COUNT(*)
2210: FROM igf_aw_award_t awdt
2211: WHERE base_id = x_base_id
2212: AND fund_id = x_fund_id
2213: AND process_id = x_process_id
2214: AND flag = 'DB'

Line 4717: FROM igf_aw_award_t

4713: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
4714: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
4715: ) IS
4716: SELECT 'x'
4717: FROM igf_aw_award_t
4718: WHERE base_id = cp_base_id
4719: AND process_id = l_process_id
4720: AND flag = 'AU'
4721: AND fund_id NOT IN (SELECT fund_id

Line 4733: FROM igf_aw_award_t awd

4729: CURSOR c_non_merge(
4730: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
4731: ) IS
4732: SELECT awd.fund_id
4733: FROM igf_aw_award_t awd
4734: WHERE awd.temp_char_val1 IS NULL
4735: AND awd.flag IN ('CF','AU')
4736: AND awd.base_id = cp_base_id
4737: AND awd.process_id = l_process_id

Line 4752: igf_aw_award_t awd

4748: ) IS
4749: SELECT ROWNUM priority,
4750: awd.*
4751: FROM igf_aw_fn_rpkg_prty prty,
4752: igf_aw_award_t awd
4753: WHERE awd.base_id = cp_base_id
4754: AND awd.process_id = l_process_id
4755: AND awd.flag IN ('CF','AU')
4756: AND awd.fund_id = prty.fund_id

Line 4824: igf_aw_award_t_pkg.update_row(

4820: ' l_merge.temp_val3_num:'||l_merge.temp_val3_num||
4821: 'l_merge.temp_val4_num:'||l_merge.temp_val4_num
4822: );
4823: END IF;
4824: igf_aw_award_t_pkg.update_row(
4825: x_rowid => l_merge.row_id,
4826: x_process_id => l_merge.process_id,
4827: x_sl_number => l_merge.sl_number,
4828: x_fund_id => l_merge.fund_id,

Line 4989: FROM igf_aw_award_t_all

4985: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
4986: )
4987: IS
4988: SELECT 'x'
4989: FROM igf_aw_award_t_all
4990: WHERE
4991: process_id = l_process_id AND
4992: fund_id = cp_fund_id AND
4993: base_id = cp_base_id AND

Line 5004: FROM igf_aw_award_t_all awd_t

5000: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
5001: )
5002: IS
5003: SELECT awd_t.rowid, awd_t.*
5004: FROM igf_aw_award_t_all awd_t
5005: WHERE
5006: awd_t.flag = 'AU' AND
5007: process_id = l_process_id AND
5008: fund_id = cp_fund_id AND

Line 5015: FROM igf_aw_award_t awdt

5011:
5012: -- Get the Over Award records from the temporary table.
5013: CURSOR c_ov_fund( x_fund_id igf_aw_fund_mast.fund_id%TYPE ) IS
5014: SELECT row_id
5015: FROM igf_aw_award_t awdt
5016: WHERE fund_id = x_fund_id
5017: AND flag = 'OV'
5018: AND process_id = l_process_id;
5019:

Line 5029: FROM igf_aw_award_t_all awdt,

5025: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
5026: ) IS
5027: SELECT SUM(DECODE(awd.award_status,'CANCELLED',1,0)) cancelled_awd,
5028: SUM(DECODE(awd.award_status,'OFFERED',1,'ACCEPTED',1,0)) off_acc_awd
5029: FROM igf_aw_award_t_all awdt,
5030: igf_aw_award_all awd
5031: WHERE awdt.fund_id = cp_fund_id
5032: AND awdt.base_id = cp_base_id
5033: AND awdt.process_id = l_process_id

Line 5044: FROM igf_aw_award_t_all awdt,

5040: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
5041: ) IS
5042: SELECT awdt.ROWID row_id,
5043: awdt.*
5044: FROM igf_aw_award_t_all awdt,
5045: igf_aw_award_all awd
5046: WHERE awdt.award_id = awd.award_id
5047: AND awdt.fund_id = cp_fund_id
5048: AND awdt.base_id = cp_base_id

Line 5060: FROM igf_aw_award_t_all awdt

5056: cp_award_id igf_aw_award_all.award_id%TYPE
5057: ) IS
5058: SELECT awdt.ROWID row_id,
5059: awdt.*
5060: FROM igf_aw_award_t_all awdt
5061: WHERE awdt.award_id <> cp_award_id
5062: AND awdt.base_id = cp_base_id
5063: AND awdt.fund_id = cp_fund_id
5064: AND awdt.process_id = l_process_id;

Line 5071: FROM igf_aw_award_t_all awdt,

5067: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
5068: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
5069: ) IS
5070: SELECT awd.award_id
5071: FROM igf_aw_award_t_all awdt,
5072: igf_aw_award_all awd
5073: WHERE awdt.award_id = awd.award_id
5074: AND awdt.fund_id = cp_fund_id
5075: AND awdt.base_id = cp_base_id

Line 5133: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'inserting into igf_aw_award_t with flag:OV for fund:'||p_fund_id||' and base_id:'||p_base_id);

5129: END IF;
5130:
5131: END IF;
5132: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5133: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'inserting into igf_aw_award_t with flag:OV for fund:'||p_fund_id||' and base_id:'||p_base_id);
5134: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'l_awds.remaining_amt:'||l_awds.remaining_amt);
5135: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'l_overaward:'||l_overaward);
5136: END IF;
5137: igf_aw_award_t_pkg.insert_row(

Line 5137: igf_aw_award_t_pkg.insert_row(

5133: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'inserting into igf_aw_award_t with flag:OV for fund:'||p_fund_id||' and base_id:'||p_base_id);
5134: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'l_awds.remaining_amt:'||l_awds.remaining_amt);
5135: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'l_overaward:'||l_overaward);
5136: END IF;
5137: igf_aw_award_t_pkg.insert_row(
5138: x_rowid => lv_rowid ,
5139: x_process_id => l_process_id ,
5140: x_sl_number => l_sl_number,
5141: x_fund_id => p_fund_id,

Line 5352: igf_aw_award_t_pkg.insert_row(

5348: IF lb_awards_locked THEN
5349: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'created locked award');
5351: END IF;
5352: igf_aw_award_t_pkg.insert_row(
5353: x_rowid => lv_rowid ,
5354: x_process_id => l_process_id ,
5355: x_sl_number => l_sl_number,
5356: x_fund_id => p_fund_id,

Line 5386: igf_aw_award_t_pkg.insert_row(

5382: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'created unlocked award');
5383: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'l_awds.max_award_amt:'||l_awds.max_award_amt||',l_awds.min_award_amt:'||l_awds.min_award_amt);
5384: END IF;
5385:
5386: igf_aw_award_t_pkg.insert_row(
5387: x_rowid => lv_rowid ,
5388: x_process_id => l_process_id ,
5389: x_sl_number => l_sl_number,
5390: x_fund_id => p_fund_id,

Line 5427: igf_aw_award_t_pkg.update_row(

5423: -- for the fund when there are any existing locked awards from that
5424: -- fund
5425: FOR l_exist_awd IN c_get_unlocked_award(p_fund_id, p_base_id)
5426: LOOP
5427: igf_aw_award_t_pkg.update_row(
5428: x_rowid => l_exist_awd.rowid,
5429: x_process_id => l_exist_awd.process_id,
5430: x_sl_number => l_exist_awd.sl_number,
5431: x_fund_id => l_exist_awd.fund_id,

Line 5484: igf_aw_award_t_pkg.update_row(

5480: FOR l_lock_pell_awd IN c_lock_pell_awd(p_fund_id,p_base_id) LOOP
5481: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5482: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'locked award_id:'||l_lock_pell_awd.award_id);
5483: END IF;
5484: igf_aw_award_t_pkg.update_row(
5485: x_rowid => l_lock_pell_awd.row_id,
5486: x_process_id => l_lock_pell_awd.process_id,
5487: x_sl_number => l_lock_pell_awd.sl_number,
5488: x_fund_id => l_lock_pell_awd.fund_id,

Line 5533: igf_aw_award_t_pkg.update_row(

5529: FOR l_lock_pell_awd IN c_lock_pell_awd1(p_fund_id,p_base_id,l_latest_awd.award_id) LOOP
5530: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5531: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_awards.debug '|| g_req_id,'locked award_id:'||l_lock_pell_awd.award_id);
5532: END IF;
5533: igf_aw_award_t_pkg.update_row(
5534: x_rowid => l_lock_pell_awd.row_id,
5535: x_process_id => l_lock_pell_awd.process_id,
5536: x_sl_number => l_lock_pell_awd.sl_number,
5537: x_fund_id => l_lock_pell_awd.fund_id,

Line 5671: FROM igf_aw_award_t awdt

5667:
5668: -- Get the Over Award records from the temporary table.
5669: CURSOR c_ovr_awd( x_fund_id igf_aw_fund_mast.fund_id%TYPE ) IS
5670: SELECT row_id
5671: FROM igf_aw_award_t awdt
5672: WHERE fund_id = x_fund_id
5673: AND flag = 'OV'
5674: AND process_id = l_process_id;
5675:

Line 5838: cp_process_id igf_aw_award_t_all.process_id%TYPE

5834: -- Gets all the existing awards for a particular fund for a particular student
5835: CURSOR c_get_cancel_awds(
5836: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
5837: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
5838: cp_process_id igf_aw_award_t_all.process_id%TYPE
5839: )
5840: IS
5841: SELECT awd_t.rowid, awd_t.*
5842: FROM igf_aw_award_t_all awd_t

Line 5842: FROM igf_aw_award_t_all awd_t

5838: cp_process_id igf_aw_award_t_all.process_id%TYPE
5839: )
5840: IS
5841: SELECT awd_t.rowid, awd_t.*
5842: FROM igf_aw_award_t_all awd_t
5843: WHERE
5844: base_id = cp_base_id AND
5845: fund_id = cp_fund_id AND
5846: process_id = cp_process_id AND

Line 6302: --we have to load the awards into the igf_aw_award_t table

6298: p_fund_id => l_fund_ld.fund_id,
6299: p_awd_prd_code => g_awd_prd
6300: ) THEN
6301: --oops.we are into repackaging
6302: --we have to load the awards into the igf_aw_award_t table
6303:
6304: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6305: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'calling load_awards for fund:'||l_fund_ld.fund_id||
6306: 'base_id:'||l_base_id||

Line 6331: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'inserting into igf_aw_award_t with flag:CF for fund:'||l_fund_ld.fund_id||' and base_id:'||l_base_id);

6327: ELSE
6328: lv_rowid := NULL;
6329: l_sl_number := NULL;
6330: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6331: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'inserting into igf_aw_award_t with flag:CF for fund:'||l_fund_ld.fund_id||' and base_id:'||l_base_id);
6332: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'also g_plan_id:'||g_plan_id||',l_fund_ld.fund_id:'||l_fund_ld.adplans_id);
6333: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'also l_fund_ld.max_award_amt:'||l_fund_ld.max_award_amt||',l_fund_ld.min_award_amt:'||l_fund_ld.min_award_amt);
6334: END IF;
6335:

Line 6336: igf_aw_award_t_pkg.insert_row(

6332: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'also g_plan_id:'||g_plan_id||',l_fund_ld.fund_id:'||l_fund_ld.adplans_id);
6333: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'also l_fund_ld.max_award_amt:'||l_fund_ld.max_award_amt||',l_fund_ld.min_award_amt:'||l_fund_ld.min_award_amt);
6334: END IF;
6335:
6336: igf_aw_award_t_pkg.insert_row(
6337: x_rowid => lv_rowid ,
6338: x_process_id => l_process_id ,
6339: x_sl_number => l_sl_number,
6340: x_fund_id => l_fund_ld.fund_id,

Line 6399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'inserting into igf_aw_award_t with flag:OV for fund:'||l_fund_ld.fund_id||' and base_id:'||l_base_id);

6395: END IF;
6396:
6397: END IF;
6398: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'inserting into igf_aw_award_t with flag:OV for fund:'||l_fund_ld.fund_id||' and base_id:'||l_base_id);
6400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'l_fund_ld.remaining_amt:'||l_fund_ld.remaining_amt);
6401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'l_overaward:'||l_overaward);
6402: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'adplans_id:'||NVL(l_fund_ld.adplans_id,g_plan_id));
6403: END IF;

Line 6404: igf_aw_award_t_pkg.insert_row(

6400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'l_fund_ld.remaining_amt:'||l_fund_ld.remaining_amt);
6401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'l_overaward:'||l_overaward);
6402: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'adplans_id:'||NVL(l_fund_ld.adplans_id,g_plan_id));
6403: END IF;
6404: igf_aw_award_t_pkg.insert_row(
6405: x_rowid => lv_rowid ,
6406: x_process_id => l_process_id ,
6407: x_sl_number => l_sl_number,
6408: x_fund_id => l_fund_ld.fund_id,

Line 6483: igf_aw_award_t_pkg.update_row(

6479: cp_base_id => l_base_id,
6480: cp_process_id => l_process_id)
6481: LOOP
6482: -- Cancel awards
6483: igf_aw_award_t_pkg.update_row(
6484: x_rowid => l_cancel_awd_rec.rowid,
6485: x_process_id => l_cancel_awd_rec.process_id,
6486: x_sl_number => l_cancel_awd_rec.sl_number,
6487: x_fund_id => l_cancel_awd_rec.fund_id,

Line 6604: FROM igf_aw_award_t

6600: x_process_is NUMBER,
6601: x_base_id igf_ap_fa_base_rec.base_id%TYPE
6602: ) IS
6603: SELECT *
6604: FROM igf_aw_award_t
6605: WHERE process_id = x_process_is
6606: AND base_id = x_base_id
6607: AND flag IN ('RF','AR');
6608:

Line 6617: FROM igf_aw_award_t awdt

6613: x_process_id NUMBER,
6614: x_base_id NUMBER
6615: ) IS
6616: SELECT awdt.*
6617: FROM igf_aw_award_t awdt
6618: WHERE awdt.process_id = x_process_id
6619: AND awdt.base_id = x_base_id
6620: AND awdt.flag IN ('CF','AU')
6621: ORDER BY TO_NUMBER(awdt.temp_char_val1); -- Sequence order of the fund in Temp table

Line 6645: x_base_id igf_aw_award_t.base_id%TYPE,

6641: -- Get the count of all the funds from the Temp Table for a given fund code and base_id
6642: -- Here the checking for the fund for the same TERMs occurances
6643: CURSOR cur_new_awards(
6644: x_fund_code igf_aw_fund_cat.fund_code%TYPE,
6645: x_base_id igf_aw_award_t.base_id%TYPE,
6646: x_process_id igf_aw_award_t.base_id%TYPE,
6647: x_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
6648: ) IS
6649: SELECT COUNT(awdt.fund_id) ftotal

Line 6646: x_process_id igf_aw_award_t.base_id%TYPE,

6642: -- Here the checking for the fund for the same TERMs occurances
6643: CURSOR cur_new_awards(
6644: x_fund_code igf_aw_fund_cat.fund_code%TYPE,
6645: x_base_id igf_aw_award_t.base_id%TYPE,
6646: x_process_id igf_aw_award_t.base_id%TYPE,
6647: x_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
6648: ) IS
6649: SELECT COUNT(awdt.fund_id) ftotal
6650: FROM igf_aw_award_t awdt,

Line 6650: FROM igf_aw_award_t awdt,

6646: x_process_id igf_aw_award_t.base_id%TYPE,
6647: x_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
6648: ) IS
6649: SELECT COUNT(awdt.fund_id) ftotal
6650: FROM igf_aw_award_t awdt,
6651: igf_aw_fund_mast_all fmast,
6652: igf_aw_dp_terms adterms,
6653: igf_aw_awd_prd_term aprd
6654: WHERE fmast.fund_code = x_fund_code

Line 6672: x_base_id igf_aw_award_t.base_id%TYPE,

6668: -- Get the count of the Active Awards of the student for a given fund
6669:
6670: CURSOR cur_prior_awards(
6671: x_fund_code igf_aw_fund_cat.fund_code%TYPE,
6672: x_base_id igf_aw_award_t.base_id%TYPE,
6673: x_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
6674: ) IS
6675: SELECT COUNT(fmast.fund_code) ftotal
6676: FROM igf_aw_award_all awd,

Line 6701: l_flag igf_aw_award_t.flag%TYPE;

6697: WHERE fund_id = cp_fund_id;
6698:
6699: l_fund_cd c_fund_cd%ROWTYPE;
6700:
6701: l_flag igf_aw_award_t.flag%TYPE;
6702: BEGIN
6703:
6704: -- Initialise the previously rejected funds back so that they too are considered
6705: OPEN c_init_flag( l_process_id, l_base_id );

Line 6726: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.excl_incl_check.debug '|| g_req_id,'updating igf_aw_award_t for fund_id:'||l_init_flag.fund_id||' with flag:CF,adplans_id:'||l_init_flag.adplans_id);

6722: END IF;
6723: END IF;
6724:
6725: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6726: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.excl_incl_check.debug '|| g_req_id,'updating igf_aw_award_t for fund_id:'||l_init_flag.fund_id||' with flag:CF,adplans_id:'||l_init_flag.adplans_id);
6727: END IF;
6728: /*
6729: If the record was a rejected fund, make it a considered fund.
6730: If the record was a rejected award, make it a repackagable candidate.

Line 6745: igf_aw_award_t_pkg.update_row(

6741: ' base_id:'||l_init_flag.base_id||' to flag:'||l_flag
6742: );
6743: END IF;
6744:
6745: igf_aw_award_t_pkg.update_row(
6746: x_rowid => l_init_flag.row_id,
6747: x_process_id => l_init_flag.process_id,
6748: x_sl_number => l_init_flag.sl_number,
6749: x_fund_id => l_init_flag.fund_id,

Line 6838: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.excl_incl_check.debug '|| g_req_id,'updating igf_aw_award_t for fund_id:'||l_fund_chk.fund_id||' with flag:RF,adplans_id:'||l_fund_chk.adplans_id);

6834: fnd_file.put_line(fnd_file.log,fnd_message.get);
6835: END IF;
6836:
6837: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6838: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.excl_incl_check.debug '|| g_req_id,'updating igf_aw_award_t for fund_id:'||l_fund_chk.fund_id||' with flag:RF,adplans_id:'||l_fund_chk.adplans_id);
6839: END IF;
6840:
6841: -- Update the Fund status as 'REJECTED' in the Temp Table.
6842: -- This can used while reconsidering later in different Incl or Excl CHECK

Line 6860: igf_aw_award_t_pkg.update_row(

6856: ' base_id:'||l_fund_chk.base_id||' to flag:'||l_flag
6857: );
6858: END IF;
6859:
6860: igf_aw_award_t_pkg.update_row(
6861: x_rowid => l_fund_chk.row_id,
6862: x_process_id => l_fund_chk.process_id,
6863: x_sl_number => l_fund_chk.sl_number,
6864: x_fund_id => l_fund_chk.fund_id,

Line 6940: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.excl_incl_check.debug '|| g_req_id,'updating igf_aw_award_t for fund_id:'||l_fund_chk.fund_id||' with flag:RF');

6936: fnd_file.put_line(fnd_file.log,fnd_message.get);
6937: END IF;
6938:
6939: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6940: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.excl_incl_check.debug '|| g_req_id,'updating igf_aw_award_t for fund_id:'||l_fund_chk.fund_id||' with flag:RF');
6941: END IF;
6942:
6943: -- Update the Fund status as 'REJECTED' in the Temp Table.
6944: -- This can used while reconsidering later in different Incl or Excl CHECK

Line 6962: igf_aw_award_t_pkg.update_row(

6958: ' base_id:'||l_fund_chk.base_id||' to flag:'||l_flag
6959: );
6960: END IF;
6961:
6962: igf_aw_award_t_pkg.update_row(
6963: x_rowid => l_fund_chk.row_id,
6964: x_process_id => l_fund_chk.process_id,
6965: x_sl_number => l_fund_chk.sl_number,
6966: x_fund_id => l_fund_chk.fund_id,

Line 7025: --veramach 13-OCT-2003 FA 124 Build -Added logic to insert 2 rows into igf_aw_award_t table which holds IM/FM needs

7021: || Change History :
7022: || Who WHEN What
7023: || (reverse chronological order - newest change first)
7024: --veramach 20-NOV-2003 FA 125 Build -Removed p_coa_i,p_need_f as parameters
7025: --veramach 13-OCT-2003 FA 124 Build -Added logic to insert 2 rows into igf_aw_award_t table which holds IM/FM needs
7026: --rasahoo 05-Aug-2003 #3024112 Changed the parameters in call igf_ap_efc_calc.get_efc_no_of_months
7027: --
7028: */
7029:

Line 7038: FROM igf_aw_award_t

7034: Net Need = COA - (Already Awards which are not eligible for Repkg + EFC)
7035: */
7036: CURSOR c_rem_efc IS
7037: SELECT *
7038: FROM igf_aw_award_t
7039: WHERE process_id = l_process_id
7040: AND base_id = p_base_id
7041: AND flag = 'AA';
7042:

Line 7175: igf_aw_award_t_pkg.update_row(

7171: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,'c_rem_efc%FOUND - so updating values with '||' l_need:'||l_need||' l_efc:'||l_efc||' l_rem_efc:'||l_rem_efc||' l_need_VB_AC: '||l_need_VB_AC);
7172: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,'p_awds.replace_fc:'||p_awds.replace_fc||' p_awds.update_need:'||p_awds.update_need||'adplans_id:'||l_efc_cur.adplans_id);
7173: END IF;
7174:
7175: igf_aw_award_t_pkg.update_row(
7176: x_rowid => l_efc_cur.row_id ,
7177: x_process_id => l_efc_cur.process_id ,
7178: x_sl_number => l_efc_cur.sl_number,
7179: x_fund_id => l_efc_cur.fund_id,

Line 7350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,'inserting calculated values into igf_aw_award_t with x_temp_char_val1=FEDERAL');

7346: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,' p_awds.replace_fc : '||p_awds.replace_fc||' p_awds.update_need: '||p_awds.update_need);
7347: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,'Calculated values are: '||' l_efc_months: '||l_efc_months);
7348: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,' l_efc_f:'||l_efc_f||' l_efc_i:'||l_efc_i||' l_rem_efc_f:'||l_rem_efc_f||' l_rem_efc_i:'||l_rem_efc_i);
7349: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,'l_need_f:'||l_need_f||' l_need_i:'||l_need_i||' l_need_VB_AC_f:'||l_need_VB_AC_f|| ' l_need_VB_AC_i:' ||l_need_VB_AC_i);
7350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,'inserting calculated values into igf_aw_award_t with x_temp_char_val1=FEDERAL');
7351: END IF;
7352: -- insert the record into Temp table
7353: igf_aw_award_t_pkg.insert_row(
7354: x_rowid => lv_rowid ,

Line 7353: igf_aw_award_t_pkg.insert_row(

7349: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,'l_need_f:'||l_need_f||' l_need_i:'||l_need_i||' l_need_VB_AC_f:'||l_need_VB_AC_f|| ' l_need_VB_AC_i:' ||l_need_VB_AC_i);
7350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,'inserting calculated values into igf_aw_award_t with x_temp_char_val1=FEDERAL');
7351: END IF;
7352: -- insert the record into Temp table
7353: igf_aw_award_t_pkg.insert_row(
7354: x_rowid => lv_rowid ,
7355: x_process_id => l_process_id ,
7356: x_sl_number => l_sl_number,
7357: x_fund_id => NULL,

Line 7382: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,'inserting calculating values into igf_aw_award_t with x_temp_char_val1=INSTITUTIONAL');

7378: x_temp_char2_txt => NULL,
7379: x_temp_char3_txt => NULL
7380: );
7381: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7382: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,'inserting calculating values into igf_aw_award_t with x_temp_char_val1=INSTITUTIONAL');
7383: END IF;
7384: -- insert the record into Temp table
7385: igf_aw_award_t_pkg.insert_row(
7386: x_rowid => lv_rowid ,

Line 7385: igf_aw_award_t_pkg.insert_row(

7381: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7382: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,'inserting calculating values into igf_aw_award_t with x_temp_char_val1=INSTITUTIONAL');
7383: END IF;
7384: -- insert the record into Temp table
7385: igf_aw_award_t_pkg.insert_row(
7386: x_rowid => lv_rowid ,
7387: x_process_id => l_process_id ,
7388: x_sl_number => l_sl_number,
7389: x_fund_id => NULL,

Line 7660: FROM igf_aw_award_t

7656: AND awd.fund_id = fm.fund_id
7657: AND fm.fund_code = fcat.fund_code
7658: AND awd.award_status IN ('ACCEPTED','OFFERED')
7659: AND awd.award_id NOT IN ( SELECT award_id
7660: FROM igf_aw_award_t
7661: WHERE base_id = cp_base_id
7662: AND process_id = l_process_id
7663: AND flag = 'AU'); -- AU is it is a candidate for repackaging
7664:

Line 7702: FROM igf_aw_award_t

7698:
7699: -- Get the funds from the Temp table which are not yet awarded
7700: CURSOR c_rem_fund(x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
7701: SELECT COUNT(*)
7702: FROM igf_aw_award_t
7703: WHERE process_id = l_process_id
7704: AND base_id = x_base_id
7705: AND flag IN ('CF','AU');
7706:

Line 8340: -- It has a link to igf_aw_award_t with a flag = 'CF' ie the valid funds

8336: || (reverse chronological order - newest change first)
8337: */
8338:
8339: -- Retrieves all the funds that are part of the Formula Code in Sequence
8340: -- It has a link to igf_aw_award_t with a flag = 'CF' ie the valid funds
8341: CURSOR c_fund(
8342: x_group_code igf_aw_target_grp_all.group_cd%TYPE,
8343: x_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
8344: x_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

Line 8360: FROM igf_aw_award_t awt,

8356: fmast.fm_fc_methd,
8357: fcat.fund_source fund_source,
8358: awt.award_id,
8359: awt.offered_amt
8360: FROM igf_aw_award_t awt,
8361: igf_aw_fund_mast_all fmast,
8362: igf_aw_fund_cat_all fcat
8363: WHERE awt.fund_id = fmast.fund_id
8364: AND fmast.fund_code = fcat.fund_code

Line 8384: igf_aw_award_t awt1,

8380: fcat.fund_source fund_source,
8381: awt1.award_id,
8382: awt1.offered_amt
8383: FROM igf_aw_fund_mast_all fmast ,
8384: igf_aw_award_t awt1,
8385: igf_aw_fund_cat_all fcat
8386: WHERE g_sf_packaging = 'T'
8387: AND fmast.fund_id = g_sf_fund
8388: AND fmast.fund_id = awt1.fund_id

Line 8415: x_process_id igf_aw_award_t.process_id%TYPE ,

8411: l_fmast c_fmast%ROWTYPE;
8412:
8413: -- Gets the Total amount awarded for a fund from the temporary table
8414: CURSOR c_temp(
8415: x_process_id igf_aw_award_t.process_id%TYPE ,
8416: x_fund_id igf_aw_award_t.fund_id%TYPE,
8417: x_base_id igf_aw_award_t.base_id%TYPE
8418: ) IS
8419: SELECT NVL(SUM(offered_amt),0) offered

Line 8416: x_fund_id igf_aw_award_t.fund_id%TYPE,

8412:
8413: -- Gets the Total amount awarded for a fund from the temporary table
8414: CURSOR c_temp(
8415: x_process_id igf_aw_award_t.process_id%TYPE ,
8416: x_fund_id igf_aw_award_t.fund_id%TYPE,
8417: x_base_id igf_aw_award_t.base_id%TYPE
8418: ) IS
8419: SELECT NVL(SUM(offered_amt),0) offered
8420: FROM igf_aw_award_t awdt

Line 8417: x_base_id igf_aw_award_t.base_id%TYPE

8413: -- Gets the Total amount awarded for a fund from the temporary table
8414: CURSOR c_temp(
8415: x_process_id igf_aw_award_t.process_id%TYPE ,
8416: x_fund_id igf_aw_award_t.fund_id%TYPE,
8417: x_base_id igf_aw_award_t.base_id%TYPE
8418: ) IS
8419: SELECT NVL(SUM(offered_amt),0) offered
8420: FROM igf_aw_award_t awdt
8421: WHERE awdt.base_id = x_base_id

Line 8420: FROM igf_aw_award_t awdt

8416: x_fund_id igf_aw_award_t.fund_id%TYPE,
8417: x_base_id igf_aw_award_t.base_id%TYPE
8418: ) IS
8419: SELECT NVL(SUM(offered_amt),0) offered
8420: FROM igf_aw_award_t awdt
8421: WHERE awdt.base_id = x_base_id
8422: AND awdt.fund_id = x_fund_id
8423: AND awdt.process_id = x_process_id
8424: AND awdt.flag = 'AW';

Line 8431: FROM igf_aw_award_t awdt

8427:
8428: -- Check whether the fund is resulted in over award or not
8429: CURSOR c_cur_ovr_awd ( x_fund_id igf_aw_fund_mast.fund_id%TYPE ) IS
8430: SELECT awdt.*
8431: FROM igf_aw_award_t awdt
8432: WHERE awdt.fund_id = x_fund_id
8433: AND flag = 'OV'
8434: AND process_id = l_process_id;
8435:

Line 8527: x_fund_id igf_aw_award_t.fund_id%TYPE,

8523: agg_lf_count_rec cur_agg_lf_count%ROWTYPE;
8524:
8525: -- Get all the funds from te temp table whose consolidated records are calculated
8526: CURSOR c_awd_grp_funds(
8527: x_fund_id igf_aw_award_t.fund_id%TYPE,
8528: x_base_id igf_aw_award_t.base_id%TYPE,
8529: x_process_id igf_aw_award_t.process_id%TYPE
8530: ) IS
8531: SELECT awdt.row_id row_id

Line 8528: x_base_id igf_aw_award_t.base_id%TYPE,

8524:
8525: -- Get all the funds from te temp table whose consolidated records are calculated
8526: CURSOR c_awd_grp_funds(
8527: x_fund_id igf_aw_award_t.fund_id%TYPE,
8528: x_base_id igf_aw_award_t.base_id%TYPE,
8529: x_process_id igf_aw_award_t.process_id%TYPE
8530: ) IS
8531: SELECT awdt.row_id row_id
8532: FROM igf_aw_award_t awdt

Line 8529: x_process_id igf_aw_award_t.process_id%TYPE

8525: -- Get all the funds from te temp table whose consolidated records are calculated
8526: CURSOR c_awd_grp_funds(
8527: x_fund_id igf_aw_award_t.fund_id%TYPE,
8528: x_base_id igf_aw_award_t.base_id%TYPE,
8529: x_process_id igf_aw_award_t.process_id%TYPE
8530: ) IS
8531: SELECT awdt.row_id row_id
8532: FROM igf_aw_award_t awdt
8533: WHERE awdt.process_id = x_process_id

Line 8532: FROM igf_aw_award_t awdt

8528: x_base_id igf_aw_award_t.base_id%TYPE,
8529: x_process_id igf_aw_award_t.process_id%TYPE
8530: ) IS
8531: SELECT awdt.row_id row_id
8532: FROM igf_aw_award_t awdt
8533: WHERE awdt.process_id = x_process_id
8534: AND awdt.base_id = x_base_id
8535: AND awdt.fund_id = x_fund_id
8536: AND flag = 'AW';

Line 8552: cp_base_id igf_aw_award_t.base_id%TYPE ,

8548:
8549: -- now select whether there is any FSEOG Fund Type in the passed combination of
8550: -- of process_id and base_id, No need to check for calendar details.
8551: CURSOR c_find_fseog(
8552: cp_base_id igf_aw_award_t.base_id%TYPE ,
8553: cp_process_id igf_aw_award_t.process_id%TYPE
8554: ) IS
8555: SELECT COUNT(*) cnt, fm.fund_id
8556: FROM igf_aw_fund_mast_all fm,

Line 8553: cp_process_id igf_aw_award_t.process_id%TYPE

8549: -- now select whether there is any FSEOG Fund Type in the passed combination of
8550: -- of process_id and base_id, No need to check for calendar details.
8551: CURSOR c_find_fseog(
8552: cp_base_id igf_aw_award_t.base_id%TYPE ,
8553: cp_process_id igf_aw_award_t.process_id%TYPE
8554: ) IS
8555: SELECT COUNT(*) cnt, fm.fund_id
8556: FROM igf_aw_fund_mast_all fm,
8557: igf_aw_fund_cat_all ca

Line 8561: FROM igf_aw_award_t awdt

8557: igf_aw_fund_cat_all ca
8558: WHERE fm.fund_code = ca.fund_code
8559: AND ca.fed_fund_code ='FSEOG'
8560: AND fm.fund_id IN ( SELECT awdt.fund_id
8561: FROM igf_aw_award_t awdt
8562: WHERE awdt.process_id = cp_process_id
8563: AND awdt.base_id = cp_base_id )
8564: GROUP BY fm.fund_id;
8565:

Line 8583: cp_fund_id igf_aw_award_t.fund_id%TYPE ,

8579: ORDER BY fsm.fund_id;
8580:
8581: -- get the sum of offered amout of fund passed as variable.
8582: CURSOR c_get_fund_sum(
8583: cp_fund_id igf_aw_award_t.fund_id%TYPE ,
8584: cp_base_id igf_aw_award_t.base_id%TYPE ,
8585: cp_process_id igf_aw_award_t.process_id%TYPE
8586: ) IS
8587: SELECT NVL(SUM(awdt.offered_amt),0) offered_amt

Line 8584: cp_base_id igf_aw_award_t.base_id%TYPE ,

8580:
8581: -- get the sum of offered amout of fund passed as variable.
8582: CURSOR c_get_fund_sum(
8583: cp_fund_id igf_aw_award_t.fund_id%TYPE ,
8584: cp_base_id igf_aw_award_t.base_id%TYPE ,
8585: cp_process_id igf_aw_award_t.process_id%TYPE
8586: ) IS
8587: SELECT NVL(SUM(awdt.offered_amt),0) offered_amt
8588: FROM igf_aw_award_t awdt

Line 8585: cp_process_id igf_aw_award_t.process_id%TYPE

8581: -- get the sum of offered amout of fund passed as variable.
8582: CURSOR c_get_fund_sum(
8583: cp_fund_id igf_aw_award_t.fund_id%TYPE ,
8584: cp_base_id igf_aw_award_t.base_id%TYPE ,
8585: cp_process_id igf_aw_award_t.process_id%TYPE
8586: ) IS
8587: SELECT NVL(SUM(awdt.offered_amt),0) offered_amt
8588: FROM igf_aw_award_t awdt
8589: WHERE awdt.fund_id= cp_fund_id

Line 8588: FROM igf_aw_award_t awdt

8584: cp_base_id igf_aw_award_t.base_id%TYPE ,
8585: cp_process_id igf_aw_award_t.process_id%TYPE
8586: ) IS
8587: SELECT NVL(SUM(awdt.offered_amt),0) offered_amt
8588: FROM igf_aw_award_t awdt
8589: WHERE awdt.fund_id= cp_fund_id
8590: AND awdt.process_id = cp_process_id
8591: AND awdt.base_id = cp_base_id
8592: AND awdt.flag = 'AW'

Line 8605: FROM igf_aw_award_t

8601:
8602: -- Get the remaining EFC of the student from the Temp Table
8603: CURSOR c_rem_efc IS
8604: SELECT *
8605: FROM igf_aw_award_t
8606: WHERE process_id = l_process_id
8607: AND base_id = l_fabase.base_id
8608: AND flag IN ('ND','AA');
8609:

Line 8631: cp_process_id igf_aw_award_t.process_id%TYPE

8627:
8628: -- Get all the Loan Awards of the students which were already awarded or yet to be awarded
8629: CURSOR c_std_ln_awd(
8630: cp_base_id igf_ap_fa_base_rec.base_id%TYPE,
8631: cp_process_id igf_aw_award_t.process_id%TYPE
8632: ) IS
8633: SELECT fcat.fund_code fund_code,
8634: fed_fund_code,
8635: NVL(awd.offered_amt,0) offered_amt ,

Line 8646: FROM igf_aw_award_t

8642: AND awd.fund_id = fm.fund_id
8643: AND fm.fund_code = fcat.fund_code
8644: AND fcat.fed_fund_code IN ('FLS','FLU','DLS','DLU')
8645: AND awd.award_id NOT IN (SELECT award_id
8646: FROM igf_aw_award_t
8647: WHERE award_id IS NOT NULL
8648: AND base_id = cp_base_id
8649: AND process_id = cp_process_id
8650: AND flag IN ('AU','AW'))

Line 8657: FROM igf_aw_Award_t awdt,

8653: SELECT fcat.fund_code fund_code,
8654: fed_fund_code,
8655: NVL(awdt.offered_amt,0),
8656: SYSDATE award_date
8657: FROM igf_aw_Award_t awdt,
8658: igf_aw_fund_mast_all fmt,
8659: igf_aw_fund_cat_all fcat
8660: WHERE awdt.base_id = cp_base_id
8661: AND awdt.process_id = cp_process_id

Line 8693: offered_amt igf_aw_award_t.offered_amt%TYPE,

8689:
8690: TYPE awd_grp_rec IS RECORD(
8691: fund_id igf_aw_fund_mast.fund_id%TYPE,
8692: fund_Code igf_aw_fund_mast_v.fund_code%TYPE,
8693: offered_amt igf_aw_award_t.offered_amt%TYPE,
8694: accepted_amt igf_aw_award_t.accepted_Amt%TYPE,
8695: total NUMBER,
8696: seq_no igf_aw_awd_frml_det.seq_no%TYPE,
8697: adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,

Line 8694: accepted_amt igf_aw_award_t.accepted_Amt%TYPE,

8690: TYPE awd_grp_rec IS RECORD(
8691: fund_id igf_aw_fund_mast.fund_id%TYPE,
8692: fund_Code igf_aw_fund_mast_v.fund_code%TYPE,
8693: offered_amt igf_aw_award_t.offered_amt%TYPE,
8694: accepted_amt igf_aw_award_t.accepted_Amt%TYPE,
8695: total NUMBER,
8696: seq_no igf_aw_awd_frml_det.seq_no%TYPE,
8697: adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
8698: award_id igf_aw_award_all.award_id%TYPE,

Line 8732: l_match_fund_id igf_aw_award_t.fund_id%TYPE;

8728: l_round_tol_ant NUMBER(12,2) := 0;
8729: lv_rowid VARCHAR2(25);
8730: l_sl_number NUMBER(15);
8731: l_found BOOLEAN;
8732: l_match_fund_id igf_aw_award_t.fund_id%TYPE;
8733: l_total_match_amnt NUMBER(12,2) := 0;
8734: l_match_sum NUMBER(12,2) := 0;
8735: l_est_match_amnt NUMBER(12,2) := 0;
8736: l_efc_cur efc_cur;

Line 8758: cp_process_id igf_aw_award_t.process_id%TYPE

8754:
8755: -- Find if student already has FM awards
8756: CURSOR c_fm_awards(
8757: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
8758: cp_process_id igf_aw_award_t.process_id%TYPE
8759: ) IS
8760: SELECT fmast.fm_fc_methd fm_fc_methd
8761: FROM igf_aw_fund_mast_all fmast,
8762: igf_aw_award_all awd

Line 8768: FROM igf_aw_award_t awd_t

8764: AND awd.base_id=cp_base_id
8765: AND fmast.fm_fc_methd = 'FEDERAL'
8766: UNION
8767: SELECT awd_t.temp_char_val1 fm_fc_methd
8768: FROM igf_aw_award_t awd_t
8769: WHERE awd_t.base_id = cp_base_id
8770: AND awd_t.temp_char_val1 = 'FEDERAL'
8771: and awd_t.flag = 'AA'
8772: and awd_t.process_id = cp_process_id;

Line 8798: FROM igf_aw_award_t

8794: CURSOR c_temp_awd(
8795: cp_award_id igf_aw_award_all.award_id%TYPE
8796: ) IS
8797: SELECT *
8798: FROM igf_aw_award_t
8799: WHERE award_id = cp_award_id
8800: AND process_id = l_process_id
8801: AND flag = 'AU';
8802: l_temp_awd c_temp_awd%ROWTYPE;

Line 9270: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'inserting into igf_aw_award_t with flag:ND and adplans_id: '||l_fund.adplans_id);

9266:
9267: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9268: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'calculated need,efc for method:INSTITUTIONAL as l_efc_i: '||l_efc_i||' l_need_i: '||l_need_i||' l_rem_rep_efc_i: '||l_rem_rep_efc_i);
9269: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'calculated need,efc for method:FEDERAL as l_efc_f: '||l_efc_f||' l_need_f: '||l_need_f||' l_rem_rep_efc_f: '||l_rem_rep_efc_f);
9270: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'inserting into igf_aw_award_t with flag:ND and adplans_id: '||l_fund.adplans_id);
9271: END IF;
9272:
9273: fnd_message.set_name('IGF','IGF_AW_PKG_EFC_MONTH');
9274: fnd_message.set_token('MONTH',l_efc_months);

Line 9278: igf_aw_award_t_pkg.insert_row(

9274: fnd_message.set_token('MONTH',l_efc_months);
9275: fnd_file.put_line(fnd_file.log,fnd_message.get);
9276:
9277:
9278: igf_aw_award_t_pkg.insert_row(
9279: x_rowid => lv_rowid ,
9280: x_process_id => l_process_id ,
9281: x_sl_number => l_sl_number,
9282: x_fund_id => l_fund.fund_id,

Line 9307: igf_aw_award_t_pkg.insert_row(

9303: x_temp_char2_txt => NULL,
9304: x_temp_char3_txt => NULL
9305: );
9306:
9307: igf_aw_award_t_pkg.insert_row(
9308: x_rowid => lv_rowid ,
9309: x_process_id => l_process_id ,
9310: x_sl_number => l_sl_number,
9311: x_fund_id => l_fund.fund_id,

Line 9579: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'^^^inserting into igf_aw_award_t with flag GR^^^');

9575: FETCH c_first_disb_dt INTO l_first_disb_dt;
9576: CLOSE c_first_disb_dt;
9577: END IF;
9578: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9579: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'^^^inserting into igf_aw_award_t with flag GR^^^');
9580: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'l_fund.fund_id:'||l_fund.fund_id);
9581: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'l_fabase.base_id:'||l_fabase.base_id);
9582: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'l_term_aid - l_term_amounts.term_total:'||(l_term_aid - l_term_amounts.term_total));
9583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'l_first_disb_dt.disb_date:'||l_first_disb_dt.disb_date);

Line 9590: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'^^^done inserting into igf_aw_award_t^^^');

9586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'l_term_amounts.ld_cal_type:'||l_term_amounts.ld_cal_type);
9587: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'l_term_amounts.ld_sequence_number:'||l_term_amounts.ld_sequence_number);
9588: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'l_term_amounts.adplans_id:'||l_term_amounts.adplans_id);
9589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'l_fund.award_id:'||l_fund.award_id);
9590: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'^^^done inserting into igf_aw_award_t^^^');
9591: END IF;
9592: igf_aw_award_t_pkg.insert_row(
9593: x_rowid => lv_rowid ,
9594: x_process_id => l_process_id ,

Line 9592: igf_aw_award_t_pkg.insert_row(

9588: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'l_term_amounts.adplans_id:'||l_term_amounts.adplans_id);
9589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'l_fund.award_id:'||l_fund.award_id);
9590: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'^^^done inserting into igf_aw_award_t^^^');
9591: END IF;
9592: igf_aw_award_t_pkg.insert_row(
9593: x_rowid => lv_rowid ,
9594: x_process_id => l_process_id ,
9595: x_sl_number => l_sl_number,
9596: x_fund_id => l_fund.fund_id,

Line 10758: igf_aw_award_t_pkg.update_row(

10754: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10755: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'after awarding updating amount for the fund as l_remaining_amt:'||l_remaining_amt||' l_overaward:'||l_overaward);
10756: END IF;
10757:
10758: igf_aw_award_t_pkg.update_row(
10759: x_rowid => l_cur_ovr_awd.row_id,
10760: x_process_id => l_cur_ovr_awd.process_id,
10761: x_sl_number => l_cur_ovr_awd.sl_number,
10762: x_fund_id => l_cur_ovr_awd.fund_id,

Line 10796: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'after awarding,inserting to igf_aw_award_t with flag:AW and l_aid: '||l_aid||' ln_award_perct:'||ln_award_perct||

10792:
10793: -- Insert Data INTO the Temporary Table
10794: IF NVL(l_aid,0) > 0 THEN
10795: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10796: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'after awarding,inserting to igf_aw_award_t with flag:AW and l_aid: '||l_aid||' ln_award_perct:'||ln_award_perct||
10797: 'lock_award_flag:'||l_fund.lock_award_flag);
10798: END IF;
10799: IF l_fund.award_id IS NULL THEN
10800: --Update the Overaward record in the Temp Award table for this fund

Line 10807: igf_aw_award_t_pkg.insert_row(

10803: 'process_id:'||l_process_id||
10804: 'fund_id:'||l_fmast.fund_id||
10805: 'base_id:'||l_fabase.base_id);
10806: END IF;
10807: igf_aw_award_t_pkg.insert_row(
10808: x_rowid => lv_rowid ,
10809: x_process_id => l_process_id ,
10810: x_sl_number => l_sl_number,
10811: x_fund_id => l_fmast.fund_id,

Line 10847: igf_aw_award_t_pkg.update_row(

10843: 'base_id:'||l_fabase.base_id||
10844: 'award_id:'||l_temp_awd.award_id
10845: );
10846: END IF;
10847: igf_aw_award_t_pkg.update_row(
10848: x_rowid => l_temp_awd.row_id,
10849: x_process_id => l_temp_awd.process_id,
10850: x_sl_number => l_temp_awd.sl_number,
10851: x_fund_id => l_fmast.fund_id,

Line 11028: igf_aw_award_t_pkg.update_row(

11024: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11025: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'after awarding,updating igf_aw_awrd_t (ONLY INSTITUTIONAL) with l_need_i :'||l_need_i|| ' l_need_VB_AC_i: ' ||l_need_VB_AC_i);
11026: END IF;
11027:
11028: igf_aw_award_t_pkg.update_row(
11029: x_rowid => l_rem_efc.row_id ,
11030: x_process_id => l_rem_efc.process_id ,
11031: x_sl_number => l_rem_efc.sl_number,
11032: x_fund_id => l_rem_efc.fund_id,

Line 11065: igf_aw_award_t_pkg.update_row(

11061: 'after awarding,updating igf_aw_awrd_t (ONLY FEDERAL) with l_rem_rep_efc:'||l_rem_rep_efc
11062: ||' l_need_f :'||l_need_f|| ' l_need_VB_AC_f: ' ||l_need_VB_AC_f);
11063: END IF;
11064:
11065: igf_aw_award_t_pkg.update_row(
11066: x_rowid => l_rem_efc.row_id ,
11067: x_process_id => l_rem_efc.process_id ,
11068: x_sl_number => l_rem_efc.sl_number,
11069: x_fund_id => l_rem_efc.fund_id,

Line 11236: FROM igf_aw_award_t awdt ,

11232: frml.seq_no,
11233: awdt.adplans_id,
11234: awdt.award_id,
11235: awdt.lock_award_flag
11236: FROM igf_aw_award_t awdt ,
11237: igf_aw_fund_mast fmast,
11238: (SELECT MIN(awdt1.temp_char_val1) seq_no,
11239: awdt1.fund_id fund_id
11240: FROM igf_aw_award_t awdt1

Line 11240: FROM igf_aw_award_t awdt1

11236: FROM igf_aw_award_t awdt ,
11237: igf_aw_fund_mast fmast,
11238: (SELECT MIN(awdt1.temp_char_val1) seq_no,
11239: awdt1.fund_id fund_id
11240: FROM igf_aw_award_t awdt1
11241: WHERE awdt1.process_id = l_process_id
11242: AND awdt1.base_id = l_fabase.base_id
11243: AND awdt1.flag = 'AW'
11244: GROUP BY awdt1.fund_id) frml

Line 11272: FROM igf_aw_award_t awdt,

11268: 1,
11269: awdt.adplans_id,
11270: awdt.award_id,
11271: awdt.lock_award_flag
11272: FROM igf_aw_award_t awdt,
11273: igf_aw_fund_mast fmast
11274: WHERE awdt.process_id = l_process_id
11275: AND awdt.base_id = l_fabase.base_id
11276: AND awdt.fund_id = fmast.fund_id

Line 11388: igf_aw_award_t_pkg.delete_row(l_awd_grp_funds.row_id);

11384: LOOP
11385:
11386: FETCH c_awd_grp_funds INTO l_awd_grp_funds;
11387: EXIT WHEN c_awd_grp_funds%NOTFOUND;
11388: igf_aw_award_t_pkg.delete_row(l_awd_grp_funds.row_id);
11389: END LOOP;
11390: CLOSE c_awd_grp_funds;
11391:
11392: -- Insert one consolidated Value per fund ID

Line 11506: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'inserting to igf_aw_award_t with flag:FL for base_id:'||l_fabase.base_id||' g_over_awd:'||g_over_awd);

11502: l_cnt := 0;
11503: l_rec_fnd := FALSE;
11504:
11505: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11506: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'inserting to igf_aw_award_t with flag:FL for base_id:'||l_fabase.base_id||' g_over_awd:'||g_over_awd);
11507: END IF;
11508: -- Insert a new consolidated record into the temp table.
11509: -- These are the actual awards to the inserted in the igf_aw_award and igf_aw_awd_disb
11510:

Line 11523: igf_aw_award_t_pkg.insert_row(

11519: ||' l_awd_grp.award_id:'||l_awd_grp.award_id
11520: );
11521: END IF;
11522:
11523: igf_aw_award_t_pkg.insert_row(
11524: x_rowid => lv_rowid ,
11525: x_process_id => l_process_id ,
11526: x_sl_number => l_sl_number,
11527: x_fund_id => l_awd_grp.fund_id,

Line 11696: FROM igf_aw_award_t awdt

11692: x_seq_no NUMBER,
11693: x_award_id igf_aw_award_all.award_id%TYPE
11694: ) IS
11695: SELECT awdt.*
11696: FROM igf_aw_award_t awdt
11697: WHERE fund_id = x_fund_id
11698: AND (temp_char_val1 = TO_CHAR( x_seq_no ) OR x_seq_no =-1)
11699: AND process_id = x_process_id
11700: AND flag IN ('CF','AU')

Line 11725: FROM igf_aw_award_t

11721: cp_award_id igf_aw_award_all.award_id%TYPE,
11722: cp_seq_no NUMBER
11723: ) IS
11724: SELECT 'x'
11725: FROM igf_aw_award_t
11726: WHERE process_id = cp_process_id
11727: AND award_id = cp_award_id
11728: AND flag = 'AU'
11729: AND TO_NUMBER(NVL(temp_char_val1,-1)) < cp_seq_no;

Line 11757: igf_aw_award_t_pkg.delete_row( x_rowid => l_awd_det.row_id );

11753: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.update_fund.debug '|| g_req_id,'base_id:'||l_awd_det.base_id);
11754: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.update_fund.debug '|| g_req_id,'flag:'||l_awd_det.flag);
11755: END IF;
11756:
11757: igf_aw_award_t_pkg.delete_row( x_rowid => l_awd_det.row_id );
11758: ELSE
11759: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11760: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.update_fund.debug '|| g_req_id,'Calling update_row for');
11761: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.update_fund.debug '|| g_req_id,'fund_id:'||l_awd_det.fund_id);

Line 11789: igf_aw_award_t_pkg.update_row(

11785: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11786: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.update_fund.debug '|| g_req_id,'cancelling the award');
11787: END IF;
11788: CLOSE c_awd_ex;
11789: igf_aw_award_t_pkg.update_row(
11790: x_rowid => l_awd_det.row_id,
11791: x_process_id => l_awd_det.process_id,
11792: x_sl_number => l_awd_det.sl_number,
11793: x_fund_id => l_awd_det.fund_id,

Line 11823: igf_aw_award_t_pkg.delete_row( x_rowid => l_awd_det.row_id );

11819: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11820: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.update_fund.debug '|| g_req_id,'deleting the award');
11821: END IF;
11822: CLOSE c_awd_ex;
11823: igf_aw_award_t_pkg.delete_row( x_rowid => l_awd_det.row_id );
11824: END IF;
11825: END IF;
11826: END LOOP;
11827:

Line 12117: FROM igf_aw_award_t awdt

12113: cp_award_id igf_aw_award_all.award_id%TYPE,
12114: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
12115: ) IS
12116: SELECT awdt.*
12117: FROM igf_aw_award_t awdt
12118: WHERE process_id = l_process_id
12119: AND base_id = cp_base_id
12120: AND award_id = cp_award_id
12121: AND flag = 'GR';

Line 12130: FROM igf_aw_award_t awdt

12126: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
12127: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
12128: ) IS
12129: SELECT awdt.temp_char2_txt base_attendance_type_code
12130: FROM igf_aw_award_t awdt
12131: WHERE process_id = l_process_id
12132: AND base_id = cp_base_id
12133: AND award_id = cp_award_id
12134: AND ld_cal_type = cp_ld_cal_type

Line 12297: igf_aw_award_t_pkg.insert_row(

12293: END IF;
12294: -- Create a disbursements INTO the temporary table with the fund deatils and the newly calculated disbursements amounts with the status = 'DB'
12295: l_sl_number := NULL;
12296:
12297: igf_aw_award_t_pkg.insert_row(
12298: x_rowid => lv_rowid,
12299: x_process_id => l_process_id,
12300: x_sl_number => l_sl_number,
12301: x_fund_id => l_fund_id,

Line 12458: igf_aw_award_t_pkg.insert_row(

12454: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12455: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'full participant logic');
12456: END IF;
12457: FOR i IN 1..g_pell_tab.COUNT LOOP
12458: igf_aw_award_t_pkg.insert_row(
12459: x_rowid => lv_rowid,
12460: x_process_id => l_process_id,
12461: x_sl_number => l_sl_number,
12462: x_fund_id => l_fund_id,

Line 12541: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'^^^inserting into igf_aw_award_t for PELL(old)^^^');

12537: FETCH c_base_attendance INTO l_base_attendance;
12538: CLOSE c_base_attendance;
12539:
12540: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12541: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'^^^inserting into igf_aw_award_t for PELL(old)^^^');
12542: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_fund_id:'||l_fund_id);
12543: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_base_id:'||l_base_id);
12544: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pelldisb.disb_gross_amt:'||l_pelldisb.disb_gross_amt);
12545: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pelldisb.disb_accepted_amt:'||l_pelldisb.disb_accepted_amt);

Line 12553: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'^^^done inserting into igf_aw_award_t^^^');

12549: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pelldisb.tp_sequence_number:'||l_pelldisb.tp_sequence_number);
12550: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pelldisb.ld_cal_type:'||l_pelldisb.ld_cal_type);
12551: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pelldisb.ld_sequence_number:'||l_pelldisb.ld_sequence_number);
12552: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pelldisb.award_id:'||l_pelldisb.award_id);
12553: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'^^^done inserting into igf_aw_award_t^^^');
12554: END IF;
12555: igf_aw_award_t_pkg.insert_row(
12556: x_rowid => lv_rowid,
12557: x_process_id => l_process_id,

Line 12555: igf_aw_award_t_pkg.insert_row(

12551: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pelldisb.ld_sequence_number:'||l_pelldisb.ld_sequence_number);
12552: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pelldisb.award_id:'||l_pelldisb.award_id);
12553: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'^^^done inserting into igf_aw_award_t^^^');
12554: END IF;
12555: igf_aw_award_t_pkg.insert_row(
12556: x_rowid => lv_rowid,
12557: x_process_id => l_process_id,
12558: x_sl_number => l_sl_number,
12559: x_fund_id => l_fund_id,

Line 12595: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'^^^inserting into igf_aw_award_t for PELL(new)^^^');

12591: FOR l_pell_new_disb IN c_pell_new_disb(l_award_id,l_base_id) LOOP
12592: lv_rowid := NULL;
12593: l_sl_number := NULL;
12594: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12595: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'^^^inserting into igf_aw_award_t for PELL(new)^^^');
12596: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pell_new_disb.offered_amt:'||l_pell_new_disb.offered_amt);
12597: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pell_new_disb.accepted_amt:'||l_pell_new_disb.accepted_amt);
12598: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pell_new_disb.offered_amt:'||l_pell_new_disb.offered_amt);
12599: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pell_new_disb.temp_num_val2:'||l_pell_new_disb.temp_num_val2);

Line 12607: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'^^^done inserting into igf_aw_award_t^^^');

12603: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pell_new_disb.ld_cal_type:'||l_pell_new_disb.ld_cal_type);
12604: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pell_new_disb.ld_sequence_number:'||l_pell_new_disb.ld_sequence_number);
12605: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pell_new_disb.adplans_id:'||l_pell_new_disb.adplans_id);
12606: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pell_new_disb.award_id:'||l_pell_new_disb.award_id);
12607: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'^^^done inserting into igf_aw_award_t^^^');
12608: END IF;
12609: igf_aw_award_t_pkg.insert_row(
12610: x_rowid => lv_rowid,
12611: x_process_id => l_process_id,

Line 12609: igf_aw_award_t_pkg.insert_row(

12605: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pell_new_disb.adplans_id:'||l_pell_new_disb.adplans_id);
12606: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'l_pell_new_disb.award_id:'||l_pell_new_disb.award_id);
12607: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'^^^done inserting into igf_aw_award_t^^^');
12608: END IF;
12609: igf_aw_award_t_pkg.insert_row(
12610: x_rowid => lv_rowid,
12611: x_process_id => l_process_id,
12612: x_sl_number => l_sl_number,
12613: x_fund_id => l_fund_id,

Line 12872: FROM igf_aw_award_t

12868:
12869: -- Get the details of students from the Temp Table in the descending order of their needs
12870: CURSOR c_ordered_stdnts IS
12871: SELECT base_id
12872: FROM igf_aw_award_t
12873: WHERE flag = 'ST'
12874: AND process_id = l_process_id
12875: ORDER BY temp_num_val2 DESC;
12876:

Line 13290: FROM igf_aw_award_t awdt

13286: l_ci_sequence_number NUMBER;
13287:
13288: CURSOR c_temp_rec IS
13289: SELECT row_id row_id
13290: FROM igf_aw_award_t awdt
13291: WHERE awdt.process_id = l_process_id;
13292:
13293: l_temp_rec c_temp_rec%ROWTYPE;
13294:

Line 13300: FROM igf_aw_award_t awt,

13296: SELECT COUNT(*) cnt,
13297: SUM(awt.offered_amt * awt.temp_num_val1/100) offered_amt,
13298: fund_code,
13299: adplans_id
13300: FROM igf_aw_award_t awt,
13301: igf_aw_fund_mast_all fm
13302: WHERE fm.fund_id=awt.fund_id
13303: AND awt.flag = 'FL'
13304: AND awt.process_id = l_process_id

Line 13343: FROM igf_aw_award_t

13339:
13340: -- Get the details of students from the Temp Table in the descending order of their needs
13341: CURSOR c_ordered_stdnts IS
13342: SELECT base_id
13343: FROM igf_aw_award_t
13344: WHERE flag = 'ST'
13345: AND process_id = l_process_id
13346: ORDER BY temp_num_val2 DESC;
13347:

Line 13659: igf_aw_award_t_pkg.delete_row(l_temp_rec.row_id );

13655: LOOP
13656: FETCH c_temp_rec INTO l_temp_rec;
13657: EXIT WHEN c_temp_rec%NOTFOUND;
13658:
13659: igf_aw_award_t_pkg.delete_row(l_temp_rec.row_id );
13660:
13661: END LOOP;
13662: CLOSE c_temp_rec;
13663: