APPS.IGF_DB_DISB dependencies on IGF_DB_AWD_DISB_DTL

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

25: --ridas 08-Nov-2004 Bug 3021287 If the profile_value = 'DISBURSED'
26: -- then updating COA at the student level
27: -----------------------------------------------------------------------------------
28: --ayedubat 13-OCT-04 FA 149 COD-XML Standards build bug # 3416863
29: -- Changed the TBH calls of the packages: igf_aw_awd_disb_pkg and igf_db_awd_disb_dtl_pkg
30: -----------------------------------------------------------------------------------
31: -- veramach Sep 2004 Bug 3871976
32: -- Added ability to handle dynamic person id groups
33: -----------------------------------------------------------------------------------

Line 493: igf_db_awd_disb_dtl dtl

489: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
490: IS
491: SELECT NVL(MAX(disb_seq_num),0) + 1 disb_seq_num
492: FROM
493: igf_db_awd_disb_dtl dtl
494: WHERE
495: dtl.award_id = p_award_id AND
496: dtl.disb_num = p_disb_num;
497:

Line 512: disb_dtl_rec igf_db_awd_disb_dtl%ROWTYPE;

508: FOR UPDATE OF elig_status NOWAIT;
509:
510: get_adisb_rec cur_get_adisb%ROWTYPE;
511:
512: disb_dtl_rec igf_db_awd_disb_dtl%ROWTYPE;
513:
514:
515: CURSOR cur_update_fund (p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
516: IS

Line 630: igf_db_awd_disb_dtl_pkg.insert_row(x_rowid => lv_rowid,

626:
627: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
628: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','creating actual disbursment with disb_gross_amt '|| disb_dtl_rec.disb_gross_amt);
629: END IF;
630: igf_db_awd_disb_dtl_pkg.insert_row(x_rowid => lv_rowid,
631: x_award_id => disb_dtl_rec.award_id ,
632: x_disb_num => disb_dtl_rec.disb_num ,
633: x_disb_seq_num => disb_dtl_rec.disb_seq_num ,
634: x_disb_gross_amt => disb_dtl_rec.disb_gross_amt ,

Line 829: igf_db_awd_disb_dtl

825: IS
826: SELECT
827: COUNT(disb_seq_num) adj_cnt
828: FROM
829: igf_db_awd_disb_dtl
830: WHERE
831: award_id = p_award_id AND
832: disb_num = p_disb_num AND
833: disb_status = 'S';