APPS.IGF_SP_AWARD dependencies on IGF_DB_AWD_DISB_DTL

Line 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

19: --sapanigr 26-Jun-2006 Bug 5083572 Awards - Assign Sponsorship Awards (Wrong Msg. Logged)
20: -- In create_aw_award procedure, Logging the message 'New Award is created for the
21: -- person with the following details.' only once before actual creation of Disbursement.
22: -- in the loop of fetched FC records.
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

Line 27: -- Changed the TBH calls of the packages: igf_aw_awd_disb_pkg and igf_db_awd_disb_dtl_pkg

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

Line 363: -- sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igf_db_awd_disb_dtl

359: --Known limitations/enhancements and/or remarks:
360: --
361: --Change History:
362: --Who When What
363: -- sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igf_db_awd_disb_dtl
364: -- are now rounded off to currency precision
365: --vvutukur 26-Feb-2003 Enh#2758823.FA117 Build. Assigned value 'D' to disb_dtl_rec.disb_activity, instead of NULL.
366: -------------------------------------------------------------------------------------
367:

Line 372: FROM igf_db_awd_disb_dtl

368: CURSOR cur_chk_adj( cp_award_id igf_aw_award_all.award_id%TYPE,
369: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
370: IS
371: SELECT NVL(disb_seq_num,0) disb_seq_num
372: FROM igf_db_awd_disb_dtl
373: WHERE award_id = cp_award_id AND
374: disb_num = cp_disb_num;
375: chk_adj_rec cur_chk_adj%ROWTYPE;
376:

Line 386: disb_dtl_rec igf_db_awd_disb_dtl%ROWTYPE;

382: WHERE award_id = cp_award_id AND
383: disb_num = cp_disb_num;
384: get_adisb_rec cur_get_adisb%ROWTYPE;
385:
386: disb_dtl_rec igf_db_awd_disb_dtl%ROWTYPE;
387: BEGIN
388: -- Check if any adjustment record is present for this award
389: OPEN cur_chk_adj (p_award_id, p_disb_num);
390: FETCH cur_chk_adj INTO chk_adj_rec;

Line 421: igf_db_awd_disb_dtl_pkg.insert_row( x_rowid => g_rowid,

417: disb_dtl_rec.disb_status_date := NULL;
418: g_rowid := NULL;
419:
420: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
421: igf_db_awd_disb_dtl_pkg.insert_row( x_rowid => g_rowid,
422: x_award_id => disb_dtl_rec.award_id ,
423: x_disb_num => disb_dtl_rec.disb_num ,
424: x_disb_seq_num => disb_dtl_rec.disb_seq_num ,
425: x_disb_gross_amt => igs_fi_gen_gl.get_formatted_amount(disb_dtl_rec.disb_gross_amt) ,