APPS.IGF_SL_DL_PNOTE_ACK dependencies on IGF_DB_DISB_HOLDS

Line 65: -- insert records into IGF_DB_DISB_HOLDS

61: -- npalanis 11/jan/2002 The process Common Line Origination
62: -- Process( procedure place_holds_disb )
63: -- is modified to pick up disbursement
64: -- records that are in planned state,
65: -- insert records into IGF_DB_DISB_HOLDS
66: -- table with hold 'EXTERNAL' and
67: -- hold type 'SYSTEM' and also
68: -- update manual_hold_ind flag in
69: -- IGF_AW_AWD_DISB table to 'Y'.

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

1045: SELECT adisb.* FROM igf_aw_awd_disb adisb
1046: WHERE award_id = p_award_id and
1047: trans_type = 'P';
1048:
1049: CURSOR cur_disb_hold_exists(cp_award_id igf_db_disb_holds.award_id%TYPE,
1050: cp_disb_num igf_db_disb_holds.disb_num%TYPE,
1051: cp_hold igf_db_disb_holds.hold%TYPE )
1052: IS
1053: SELECT COUNT(row_id)

Line 1050: cp_disb_num igf_db_disb_holds.disb_num%TYPE,

1046: WHERE award_id = p_award_id and
1047: trans_type = 'P';
1048:
1049: CURSOR cur_disb_hold_exists(cp_award_id igf_db_disb_holds.award_id%TYPE,
1050: cp_disb_num igf_db_disb_holds.disb_num%TYPE,
1051: cp_hold igf_db_disb_holds.hold%TYPE )
1052: IS
1053: SELECT COUNT(row_id)
1054: FROM igf_db_disb_holds

Line 1051: cp_hold igf_db_disb_holds.hold%TYPE )

1047: trans_type = 'P';
1048:
1049: CURSOR cur_disb_hold_exists(cp_award_id igf_db_disb_holds.award_id%TYPE,
1050: cp_disb_num igf_db_disb_holds.disb_num%TYPE,
1051: cp_hold igf_db_disb_holds.hold%TYPE )
1052: IS
1053: SELECT COUNT(row_id)
1054: FROM igf_db_disb_holds
1055: WHERE award_id = cp_award_id

Line 1054: FROM igf_db_disb_holds

1050: cp_disb_num igf_db_disb_holds.disb_num%TYPE,
1051: cp_hold igf_db_disb_holds.hold%TYPE )
1052: IS
1053: SELECT COUNT(row_id)
1054: FROM igf_db_disb_holds
1055: WHERE award_id = cp_award_id
1056: AND disb_num = cp_disb_num
1057: AND hold = cp_hold
1058: AND release_flag ='N';

Line 1061: l_hold_id igf_db_disb_holds.hold_id%TYPE;

1057: AND hold = cp_hold
1058: AND release_flag ='N';
1059:
1060: l_rowid VARCHAR2(30);
1061: l_hold_id igf_db_disb_holds.hold_id%TYPE;
1062: l_rec_count NUMBER;
1063:
1064: BEGIN
1065:

Line 1074: igf_db_disb_holds_pkg.insert_row (

1070: OPEN cur_disb_hold_exists(tbh_rec.award_id,tbh_rec.disb_num,'DL_PROM');
1071: FETCH cur_disb_hold_exists into l_rec_count;
1072: IF NOT ( nvl(l_rec_count,0) > 0) THEN
1073:
1074: igf_db_disb_holds_pkg.insert_row (
1075: x_mode => 'R',
1076: x_rowid => l_rowid,
1077: x_hold_id => l_hold_id,
1078: x_award_id => tbh_rec.award_id,