[Home] [Help]
23: --akomurav 06-jun-2006 Bug 5276122 - Made the changes required(TBH Impact) for adding 2 new columns in IGF_DB_AWD_DISB_DTL_ALL table
24: --pathipat 18-May-2006 Bug 5194095 - Modified create_award_disb, loop_thru_spnsr_dtl_pvt and recal_dis_gross_amt
25: --sapanigr 03-May-2006 Enh#3924836 Precision Issue. Modified create_disb_dtl, create_aw_award, loop_thru_spnsr_dtl_pvt
26: --ayedubat 13-OCT-04 FA 149 COD-XML Standards build bug # 3416863
27: -- Changed the TBH calls of the packages: igf_aw_awd_disb_pkg and igf_db_awd_disb_dtl_pkg
28: --veramach July 2004 FA 151 HR Integration(bug #3709292)
29: -- Impact of obsoleting columns from fund manager
30: -- bkkumar 04-DEC-2003 Bug 3252382 FA 131 . TBH impact for the igf_aw_awd_disb_all
31: -- Added two columns ATTENDANCE_TYPE_CODE,BASE_ATTENDANCE_TYPE_CODE
1108: ELSE
1109: g_b_msg_logged := TRUE;
1110: l_n_cnt := NVL(l_n_cnt,0) + 1;
1111: g_rowid := NULL;
1112: igf_aw_awd_disb_pkg.insert_row(
1113: x_rowid => g_rowid ,
1114: x_award_id => l_award_id ,
1115: x_disb_num => l_disb_num ,
1116: x_tp_cal_type => NULL ,
1259: log_parameters(g_v_award_id,l_award_id);
1260:
1261: l_disb_num := get_disb_num (l_award_id);
1262: g_rowid := NULL;
1263: igf_aw_awd_disb_pkg.insert_row(
1264: x_rowid => g_rowid ,
1265: x_award_id => l_award_id ,
1266: x_disb_num => l_disb_num ,
1267: x_tp_cal_type => NULL ,
1465:
1466: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');
1467: fnd_file.put_line(fnd_file.log,fnd_message.get);
1468: -- make trans type P to A
1469: igf_aw_awd_disb_pkg.update_row (x_rowid => rec_aw_awd_disb.row_id ,
1470: x_award_id => rec_aw_awd_disb.award_id ,
1471: x_disb_num => rec_aw_awd_disb.disb_num ,
1472: x_tp_cal_type => rec_aw_awd_disb.tp_cal_type ,
1473: x_tp_sequence_number => rec_aw_awd_disb.tp_sequence_number ,
1555: LOOP
1556: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');
1557: fnd_file.put_line(fnd_file.log,fnd_message.get);
1558: -- make trans type P to A
1559: igf_aw_awd_disb_pkg.update_row (x_rowid => rec_aw_awd_disb.row_id ,
1560: x_award_id => rec_aw_awd_disb.award_id ,
1561: x_disb_num => rec_aw_awd_disb.disb_num ,
1562: x_tp_cal_type => rec_aw_awd_disb.tp_cal_type ,
1563: x_tp_sequence_number => rec_aw_awd_disb.tp_sequence_number ,
1678: l_v_msg(i) := g_v_ext_disb_amount||' : '|| rec_aw_awd_disb.disb_net_amt;
1679: i := i+1;
1680: l_v_msg(i) := g_v_upd_disb_amount||' : '|| l_disb_gross_amt;
1681:
1682: igf_aw_awd_disb_pkg.update_row (x_rowid => rec_aw_awd_disb.row_id,
1683: x_award_id => rec_aw_awd_disb.award_id ,
1684: x_disb_num => rec_aw_awd_disb.disb_num ,
1685: x_tp_cal_type => rec_aw_awd_disb.tp_cal_type ,
1686: x_tp_sequence_number => rec_aw_awd_disb.tp_sequence_number ,
1744: l_v_msg(i) := g_v_disb_amount||' : '|| rec_aw_awd_disb.disb_net_amt;
1745:
1746: -- when the process is invoked in the Actual Mode then when there is no change in the disbursement amount
1747: -- then the Planned Disbursement records needs to be updated to Actual
1748: igf_aw_awd_disb_pkg.update_row (x_rowid => rec_aw_awd_disb.row_id,
1749: x_award_id => rec_aw_awd_disb.award_id ,
1750: x_disb_num => rec_aw_awd_disb.disb_num ,
1751: x_tp_cal_type => rec_aw_awd_disb.tp_cal_type ,
1752: x_tp_sequence_number => rec_aw_awd_disb.tp_sequence_number ,
1842: fnd_message.set_name('IGF','IGF_SP_UPDATE_AWARD');
1843: l_v_upd_msg_text := fnd_message.get;
1844:
1845:
1846: igf_aw_awd_disb_pkg.insert_row(x_rowid => g_rowid,
1847: x_award_id => l_award_id,
1848: x_disb_num => l_n_disb_num,
1849: x_tp_cal_type => NULL,
1850: x_tp_sequence_number => NULL,