APPS.IGF_AW_GEN_003 dependencies on IGF_DB_DISB_HOLDS

Line 2454: FROM igf_db_disb_holds dh

2450: --
2451: CURSOR c_chk_sys_disb_holds(p_award_id igf_aw_award.award_id%TYPE)
2452: IS
2453: SELECT 'x'
2454: FROM igf_db_disb_holds dh
2455: WHERE dh.award_id = p_award_id
2456: AND dh.hold_type = 'SYSTEM'
2457: AND dh.hold = 'OVERAWARD'
2458: AND dh.release_flag = 'N';

Line 2558: FROM igf_db_disb_holds dh

2554: --
2555: CURSOR cur_chk_holds( p_award_id igf_aw_award.award_id%TYPE,
2556: p_disb_num igf_aw_awd_disb.disb_num%TYPE) IS
2557: SELECT dh.release_flag
2558: FROM igf_db_disb_holds dh
2559: WHERE dh.award_id = p_award_id
2560: AND dh.disb_num = p_disb_num
2561: AND dh.hold_type = 'SYSTEM'
2562: AND dh.hold = 'OVERAWARD';

Line 2622: ln_hold_id igf_db_disb_holds.hold_id%TYPE;

2618: WHERE disb.award_id = p_award_id
2619: AND disb.trans_type = 'P';
2620:
2621: lc_row_id VARCHAR2(30);
2622: ln_hold_id igf_db_disb_holds.hold_id%TYPE;
2623:
2624:
2625: l_app VARCHAR2(50);
2626: l_name VARCHAR2(30);

Line 2640: igf_db_disb_holds_pkg.insert_row(

2636:
2637: IF place_ovawd_holds (p_award_id,rec_c_get_planned_awd_disb.disb_num) THEN
2638:
2639: -- If Hold is not present, then create the hold on the disbursement.
2640: igf_db_disb_holds_pkg.insert_row(
2641: x_mode => 'R',
2642: x_rowid => lc_row_id,
2643: x_hold_id => ln_hold_id,
2644: x_award_id => rec_c_get_planned_awd_disb.award_id,

Line 4075: igf_db_disb_holds

4071: IS
4072: SELECT
4073: row_id
4074: FROM
4075: igf_db_disb_holds
4076: WHERE
4077: award_id = p_award_id AND
4078: disb_num = NVL(p_disb_num,disb_num);
4079:

Line 4175: igf_db_disb_holds_pkg.delete_row(get_holds_rec.row_id);

4171:
4172: IF p_ld_seq_num IS NOT NULL THEN
4173: FOR get_adisb_rec IN cur_get_adisb (p_award_id,p_ld_seq_num,p_disb_num) LOOP
4174: FOR get_holds_rec IN cur_get_holds (p_award_id,get_adisb_rec.disb_num) LOOP
4175: igf_db_disb_holds_pkg.delete_row(get_holds_rec.row_id);
4176: END LOOP;
4177:
4178: OPEN cur_fed_fund_code(p_award_id);
4179: FETCH cur_fed_fund_code INTO get_fund_rec;