APPS.IGF_SL_CL_ORIG_ACK dependencies on IGF_DB_DISB_HOLDS

Line 104: -- insert records into IGF_DB_DISB_HOLDS

100: -- npalanis 11/jan/2002 The process Common Line Origination
101: -- Process( procedure place_holds_disb )
102: -- is modified to pick up disbursement
103: -- records that are in planned state,
104: -- insert records into IGF_DB_DISB_HOLDS
105: -- table with hold 'EXTERNAL' and
106: -- hold type 'SYSTEM' and also
107: -- update manual_hold_ind flag in
108: -- IGF_AW_AWD_DISB table to 'Y'.

Line 3773: CURSOR cur_disb_hold_exists(cp_award_id igf_db_disb_holds.award_id%TYPE,

3769: SELECT adisb.* FROM igf_aw_awd_disb adisb
3770: WHERE award_id = p_award_id and
3771: trans_type = p_trans_type ;
3772:
3773: CURSOR cur_disb_hold_exists(cp_award_id igf_db_disb_holds.award_id%TYPE,
3774: cp_disb_num igf_db_disb_holds.disb_num%TYPE,
3775: cp_hold igf_db_disb_holds.hold%TYPE ,
3776: cp_release_flag igf_db_disb_holds.release_flag%TYPE)
3777: IS

Line 3774: cp_disb_num igf_db_disb_holds.disb_num%TYPE,

3770: WHERE award_id = p_award_id and
3771: trans_type = p_trans_type ;
3772:
3773: CURSOR cur_disb_hold_exists(cp_award_id igf_db_disb_holds.award_id%TYPE,
3774: cp_disb_num igf_db_disb_holds.disb_num%TYPE,
3775: cp_hold igf_db_disb_holds.hold%TYPE ,
3776: cp_release_flag igf_db_disb_holds.release_flag%TYPE)
3777: IS
3778: SELECT count(row_id)

Line 3775: cp_hold igf_db_disb_holds.hold%TYPE ,

3771: trans_type = p_trans_type ;
3772:
3773: CURSOR cur_disb_hold_exists(cp_award_id igf_db_disb_holds.award_id%TYPE,
3774: cp_disb_num igf_db_disb_holds.disb_num%TYPE,
3775: cp_hold igf_db_disb_holds.hold%TYPE ,
3776: cp_release_flag igf_db_disb_holds.release_flag%TYPE)
3777: IS
3778: SELECT count(row_id)
3779: FROM igf_db_disb_holds

Line 3776: cp_release_flag igf_db_disb_holds.release_flag%TYPE)

3772:
3773: CURSOR cur_disb_hold_exists(cp_award_id igf_db_disb_holds.award_id%TYPE,
3774: cp_disb_num igf_db_disb_holds.disb_num%TYPE,
3775: cp_hold igf_db_disb_holds.hold%TYPE ,
3776: cp_release_flag igf_db_disb_holds.release_flag%TYPE)
3777: IS
3778: SELECT count(row_id)
3779: FROM igf_db_disb_holds
3780: WHERE award_id = cp_award_id

Line 3779: FROM igf_db_disb_holds

3775: cp_hold igf_db_disb_holds.hold%TYPE ,
3776: cp_release_flag igf_db_disb_holds.release_flag%TYPE)
3777: IS
3778: SELECT count(row_id)
3779: FROM igf_db_disb_holds
3780: WHERE award_id = cp_award_id
3781: AND disb_num = cp_disb_num
3782: AND hold = cp_hold
3783: AND release_flag = cp_release_flag;

Line 3786: l_hold_id igf_db_disb_holds.hold_id%TYPE;

3782: AND hold = cp_hold
3783: AND release_flag = cp_release_flag;
3784:
3785: l_rowid VARCHAR2(30);
3786: l_hold_id igf_db_disb_holds.hold_id%TYPE;
3787: l_rec_count NUMBER;
3788:
3789: BEGIN
3790:

Line 3801: igf_db_disb_holds_pkg.insert_row (

3797: FETCH cur_disb_hold_exists into l_rec_count;
3798:
3799: IF NOT ( nvl(l_rec_count,0) > 0) THEN
3800: gv_debug_str := gv_debug_str || 'PLACE_DISB_HOLDS - 2'||' ';
3801: igf_db_disb_holds_pkg.insert_row (
3802: x_mode => 'R',
3803: x_rowid => l_rowid,
3804: x_hold_id => l_hold_id,
3805: x_award_id => tbh_rec.award_id,