APPS.IGF_GR_GEN dependencies on IGF_DB_DISB_HOLDS

Line 487: p_hold igf_db_disb_holds_all.hold%TYPE)

483:
484:
485: PROCEDURE insert_sys_holds ( p_award_id igf_aw_award_all.award_id%TYPE,
486: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE,
487: p_hold igf_db_disb_holds_all.hold%TYPE)
488: IS
489: --------------------------------------------------------------------------------------------
490: --
491: -- sjadhav, 15Feb2002

Line 511: holds_rec igf_db_disb_holds_all%ROWTYPE;

507: awd.disb_num = NVL(p_disb_num,awd.disb_num) AND
508: awd.trans_type = 'P';
509:
510: awd_rec cur_get_adisb%ROWTYPE;
511: holds_rec igf_db_disb_holds_all%ROWTYPE;
512:
513: lv_rowid ROWID;
514:
515: CURSOR cur_chk_holds ( p_award_id igf_aw_awd_disb_all.award_id%TYPE,

Line 517: p_hold igf_db_disb_holds_all.hold%TYPE)

513: lv_rowid ROWID;
514:
515: CURSOR cur_chk_holds ( p_award_id igf_aw_awd_disb_all.award_id%TYPE,
516: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE,
517: p_hold igf_db_disb_holds_all.hold%TYPE)
518: IS
519: SELECT COUNT(hold_id) cnt
520: FROM
521: igf_db_disb_holds

Line 521: igf_db_disb_holds

517: p_hold igf_db_disb_holds_all.hold%TYPE)
518: IS
519: SELECT COUNT(hold_id) cnt
520: FROM
521: igf_db_disb_holds
522: WHERE
523: award_id = p_award_id AND
524: disb_num = p_disb_num AND
525: NVL(release_flag,'N') = 'N' AND

Line 545: igf_db_disb_holds_pkg.insert_row(x_rowid => lv_rowid,

541: FETCH cur_chk_holds INTO chk_holds_rec;
542: CLOSE cur_chk_holds;
543:
544: IF NVL(chk_holds_rec.cnt,0) = 0 THEN
545: igf_db_disb_holds_pkg.insert_row(x_rowid => lv_rowid,
546: x_hold_id => holds_rec.hold_id,
547: x_award_id => awd_rec.award_id,
548: x_disb_num => awd_rec.disb_num,
549: x_hold => p_hold,