[Home] [Help]
15: -- cancelled.
16: --------------------------------------------------------------------------------------
17: -- museshad 14-Jul-2005 Build FA 140.
18: -- Modified TBH call due to the addition of new
19: -- columns to igf_aw_fund_mast_all.
20: --------------------------------------------------------------------------------------
21: -- mnade 6/6/2005 FA 157 - 4382371 - Added
22: -- get_notification_status update_notification_status
23: -- update_awd_notification_status get_concurrent_prog_name
41: -- Eligible for Additional Unsubsidized Loans
42: --------------------------------------------------------------------------------------
43: -- ayedubat 12-OCT-2004 Changed the update_disb procedure for FA 149 build bug # 3416863
44: -- veramach July 2004 FA 151 HR Integration (bug # 3709292)
45: -- Impact of obsoleting columns from igf_aw_fund_mast_all table
46: --------------------------------------------------------------------------------------
47: -- sjadhav 10-Dec-2003 FA 131 Changes
48: -- De-link auto update of Pell Disbursement and Pell
49: -- origination amounts
90: -- Modifed the procedure update_fmast for deletion
91: -- of Simulated awards
92: --------------------------------------------------------------------------------------
93: -- cdcruz 07-Nov-02 Modified the update_row call of
94: -- IGF_AW_FUND_MAST_PKG
95: -- Sap type is obsoleted in the SAP build fa101
96: --------------------------------------------------------------------------------------
97: -- adhawan 25-oct-2002 ALT_PELL_SCHEDULE added for FA108 Awarding
98: -- Enhancements efc_coa --Modified the coa_total_cur
113: -- to calculate the sum of the paid amount of all
114: -- the disbursements
115: --------------------------------------------------------------------------------------
116: -- brajendr 12-Jun-2002 Modified the update_row call of
117: -- IGF_AW_FUND_MAST_PKG as
118: -- Student Employment related columns
119: -- are missing in the call
120: --------------------------------------------------------------------------------------
121: -- sjadhav 24-apr-2002 Bug # 2340471.Restored changes done for Bug
339: p_award_id igf_db_awd_disb_dtl.award_id%TYPE
340: )
341: IS
342: SELECT cat.fed_fund_code, awd.award_status award_status
343: FROM igf_aw_award awd, igf_aw_fund_mast fmast, igf_aw_fund_cat cat
344: WHERE awd.award_id = p_award_id
345: AND awd.fund_id = fmast.fund_id
346: AND fmast.fund_code = cat.fund_code;
347:
1101: || always remains at 0 and it is not used anywhere.
1102: ||
1103: || museshad 14-Jul-2005 Build FA 140.
1104: || Modified TBH call due to the addition of new
1105: || columns to igf_aw_fund_mast_all table.
1106: ||
1107: || smvk 10_feb_2003 Bug # 2758812. Added send_without_doc column in the igf_aw_fund_mast_pkg.update_row call.
1108: ||
1109: || brajendr 19-Dec-2002 Bug # 2708599
1103: || museshad 14-Jul-2005 Build FA 140.
1104: || Modified TBH call due to the addition of new
1105: || columns to igf_aw_fund_mast_all table.
1106: ||
1107: || smvk 10_feb_2003 Bug # 2758812. Added send_without_doc column in the igf_aw_fund_mast_pkg.update_row call.
1108: ||
1109: || brajendr 19-Dec-2002 Bug # 2708599
1110: || Modifed the procedure update_fmast for deletion of Simulated awards,
1111: || earlier it was looking at new refferences, modified to old refferences
1110: || Modifed the procedure update_fmast for deletion of Simulated awards,
1111: || earlier it was looking at new refferences, modified to old refferences
1112: ||
1113: || pkpatel 11-DEC-2001 Bug NO:2154941 Disbursement DLD
1114: || Removed the reference to dropped columns from, IGF_AW_FUND_MAST
1115: ||
1116: || cdcruz 06-MAY-2002 Bug NO: 2310222 Summary Tab updation
1117: || All summary column counts and totals modified
1118: */
1117: || All summary column counts and totals modified
1118: */
1119:
1120:
1121: CURSOR c_fmast( x_fund_id igf_aw_fund_mast.fund_id%TYPE) IS
1122: SELECT fmast.*
1123: FROM igf_aw_fund_mast fmast
1124: WHERE fund_id = x_fund_id ;
1125:
1119:
1120:
1121: CURSOR c_fmast( x_fund_id igf_aw_fund_mast.fund_id%TYPE) IS
1122: SELECT fmast.*
1123: FROM igf_aw_fund_mast fmast
1124: WHERE fund_id = x_fund_id ;
1125:
1126: l_fmast c_fmast%ROWTYPE;
1127:
1290: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_cancelled:'||l_fmast.total_cancelled);
1291: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.declined_amt:'||l_fmast.declined_amt);
1292: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_declined:'||l_fmast.total_declined);
1293: END IF;
1294: igf_aw_fund_mast_pkg.update_row (
1295: x_rowid => l_fmast.row_id,
1296: x_fund_id => l_fmast.fund_id,
1297: x_fund_code => l_fmast.fund_code,
1298: x_ci_cal_type => l_fmast.ci_cal_type,
1504:
1505: disb_rec cur_disb%ROWTYPE;
1506:
1507: -- Get the fund code of the fund.
1508: CURSOR cur_fund_dtls ( c_fund_id igf_aw_fund_mast.fund_id%TYPE)
1509: IS
1510: SELECT
1511: cat.fed_fund_code
1512: FROM
1509: IS
1510: SELECT
1511: cat.fed_fund_code
1512: FROM
1513: igf_aw_fund_mast_all fmast,
1514: igf_aw_fund_cat_all cat
1515: WHERE
1516: fmast.fund_id = c_fund_id AND
1517: fmast.fund_code = cat.fund_code;
1914: 'F', 3
1915: ) STATUS_ORDER
1916: FROM
1917: IGF_AW_AWARD_all AWD,
1918: IGF_AW_FUND_MAST FMAST
1919: WHERE
1920: FMAST.CI_CAL_TYPE = cp_ci_cal_type AND
1921: FMAST.CI_SEQUENCE_NUMBER = cp_ci_sequence_number AND
1922: AWD.FUND_ID = FMAST.FUND_ID AND
1997: SELECT
1998: awd.award_id
1999: FROM
2000: IGF_AW_AWARD_all AWD,
2001: IGF_AW_FUND_MAST FMAST
2002: WHERE
2003: FMAST.CI_CAL_TYPE = cp_ci_cal_type AND
2004: FMAST.CI_SEQUENCE_NUMBER = cp_ci_sequence_number AND
2005: AWD.FUND_ID = FMAST.FUND_ID AND