APPS.IGF_GR_REPACKAGE dependencies on IGF_AW_AWD_DISB

Line 9: -- Changed the TBH calls of the packages: igf_aw_awd_disb_pkg and

5: ----------------------------------------------------------------------
6: --sjadhav 06-Nov-2004 FA 149 build, do not insert into igf_gr_rfms_disb for cod year
7: ----------------------------------------------------------------------
8: --ayedubat 13-OCT-04 FA 149 COD-XML Standards build bug # 3416863
9: -- Changed the TBH calls of the packages: igf_aw_awd_disb_pkg and
10: -- igf_gr_rfms_pkg
11: ----------------------------------------------------------------------
12: -- veramach July 2004 FA 151 HR integration (bug # 3709292)
13: -- Impact of obsoleting columns from igf_aw_awd_disb_pkg

Line 13: -- Impact of obsoleting columns from igf_aw_awd_disb_pkg

9: -- Changed the TBH calls of the packages: igf_aw_awd_disb_pkg and
10: -- igf_gr_rfms_pkg
11: ----------------------------------------------------------------------
12: -- veramach July 2004 FA 151 HR integration (bug # 3709292)
13: -- Impact of obsoleting columns from igf_aw_awd_disb_pkg
14: ----------------------------------------------------------------------
15: -- veramach 12-Mar-2004 Bug 3490915
16: -- in call to igf_gr_rfms_pkg.update_row, changed the
17: -- value of pell_amout to l_offered_amt

Line 181: FROM igf_aw_awd_disb_all disb

177: cp_award_id igf_aw_award_all.award_id%TYPE
178: ) IS
179: SELECT disb.rowid row_id,
180: disb.*
181: FROM igf_aw_awd_disb_all disb
182: WHERE award_id = cp_award_id;
183:
184:
185:

Line 196: igf_aw_awd_disb_pkg.update_row(

192: FOR awd_rec IN c_award(p_award_id) LOOP
193:
194: FOR disb_rec IN c_disb(p_award_id) LOOP
195:
196: igf_aw_awd_disb_pkg.update_row(
197: x_rowid => disb_rec.row_id,
198: x_award_id => disb_rec.award_id,
199: x_disb_num => disb_rec.disb_num,
200: x_tp_cal_type => disb_rec.tp_cal_type,

Line 455: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE

451:
452: -- Get disbursements which should be cancelled
453: CURSOR c_disb_cancel(
454: cp_award_id igf_aw_award_all.award_id%TYPE,
455: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
456: ) IS
457: SELECT *
458: FROM igf_aw_awd_disb
459: WHERE award_id = cp_award_id

Line 458: FROM igf_aw_awd_disb

454: cp_award_id igf_aw_award_all.award_id%TYPE,
455: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
456: ) IS
457: SELECT *
458: FROM igf_aw_awd_disb
459: WHERE award_id = cp_award_id
460: AND disb_num > cp_disb_num;
461:
462: -- Get context disbursement record

Line 465: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE

461:
462: -- Get context disbursement record
463: CURSOR c_disb(
464: cp_award_id igf_aw_award_all.award_id%TYPE,
465: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
466: ) IS
467: SELECT disb.rowid row_id,
468: disb.*
469: FROM igf_aw_awd_disb_all disb

Line 469: FROM igf_aw_awd_disb_all disb

465: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
466: ) IS
467: SELECT disb.rowid row_id,
468: disb.*
469: FROM igf_aw_awd_disb_all disb
470: WHERE
471: award_id = cp_award_id AND
472: disb_num = cp_disb_num ;
473:

Line 942: igf_aw_awd_disb_pkg.update_row(

938: IF c_disb%FOUND THEN
939:
940:
941: -- Update the Award Disbursement Table
942: igf_aw_awd_disb_pkg.update_row(
943: x_rowid => l_disb_rec.row_id,
944: x_award_id => lc_stud_det.award_id,
945: x_disb_num => l_pell_tab(i).sl_number,
946: x_tp_cal_type => l_pell_tab(i).tp_cal_type,

Line 997: igf_aw_awd_disb_pkg.insert_row(

993: --
994:
995: lv_row_id := NULL;
996:
997: igf_aw_awd_disb_pkg.insert_row(
998: x_rowid => lv_row_id,
999: x_award_id => lc_stud_det.award_id,
1000: x_disb_num => l_pell_tab(i).sl_number,
1001: x_tp_cal_type => l_pell_tab(i).tp_cal_type,

Line 1169: igf_aw_awd_disb_pkg.update_row(

1165: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','cancelling awd_disb for award_id:'||disb_cancel_rec.award_id||' disb_cancel_rec.disb_num:'||disb_cancel_rec.disb_num);
1166: END IF;
1167:
1168: -- cancel the disbursement
1169: igf_aw_awd_disb_pkg.update_row(
1170: x_rowid => disb_cancel_rec.row_id,
1171: x_award_id => disb_cancel_rec.award_id,
1172: x_disb_num => disb_cancel_rec.disb_num,
1173: x_tp_cal_type => disb_cancel_rec.tp_cal_type,