APPS.IGF_AW_GEN dependencies on IGF_AW_AWD_DISB_ALL

Line 278: FROM igf_aw_awd_disb_all

274:
275: CURSOR cur_get_cancl_disb(cp_award_id igf_aw_award_all.award_id%TYPE)
276: IS
277: SELECT 'X'
278: FROM igf_aw_awd_disb_all
279: WHERE award_id = cp_award_id AND
280: trans_type <> 'C';
281:
282: l_cur_get_cancl_disb_rec cur_get_cancl_disb%ROWTYPE;

Line 299: PROCEDURE update_disb(p_disb_old_rec igf_aw_awd_disb_all%ROWTYPE,

295: END IF;
296:
297: END chk_disb_status;
298:
299: PROCEDURE update_disb(p_disb_old_rec igf_aw_awd_disb_all%ROWTYPE,
300: p_disb_new_rec igf_aw_awd_disb_all%ROWTYPE)
301: IS
302:
303: --------------------------------------------------------------------------------------

Line 300: p_disb_new_rec igf_aw_awd_disb_all%ROWTYPE)

296:
297: END chk_disb_status;
298:
299: PROCEDURE update_disb(p_disb_old_rec igf_aw_awd_disb_all%ROWTYPE,
300: p_disb_new_rec igf_aw_awd_disb_all%ROWTYPE)
301: IS
302:
303: --------------------------------------------------------------------------------------
304: -- sjadhav 05-Nov-2004 FA 134 Build. Update loans table if disb data changes

Line 352: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE

348: get_fed_rec cur_get_fed%ROWTYPE;
349:
350: CURSOR c_max_seq_num(
351: p_award_id igf_db_awd_disb_dtl.award_id%TYPE,
352: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
353: )
354: IS
355: SELECT MAX(disb_seq_num) max_num
356: FROM igf_db_awd_disb_dtl

Line 362: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE

358:
359:
360: CURSOR c_get_net_total(
361: p_award_id igf_db_awd_disb_dtl.award_id%TYPE,
362: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
363: )
364: IS
365: SELECT
366: SUM(DECODE(DISB_ACTIVITY,'D',DISB_NET_AMT,'A',DISB_ADJ_AMT,'Q',0)) net_total

Line 1431: p_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE,

1427:
1428: END update_fmast;
1429:
1430: PROCEDURE update_award( p_award_id IN igf_aw_award_all.award_id%TYPE,
1431: p_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE,
1432: p_disb_amt IN igf_aw_awd_disb_all.disb_net_amt%TYPE,
1433: p_disb_dt IN igf_aw_awd_disb_all.disb_date%TYPE,
1434: p_action IN VARCHAR2,
1435: x_called_from IN VARCHAR2

Line 1432: p_disb_amt IN igf_aw_awd_disb_all.disb_net_amt%TYPE,

1428: END update_fmast;
1429:
1430: PROCEDURE update_award( p_award_id IN igf_aw_award_all.award_id%TYPE,
1431: p_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE,
1432: p_disb_amt IN igf_aw_awd_disb_all.disb_net_amt%TYPE,
1433: p_disb_dt IN igf_aw_awd_disb_all.disb_date%TYPE,
1434: p_action IN VARCHAR2,
1435: x_called_from IN VARCHAR2
1436: )

Line 1433: p_disb_dt IN igf_aw_awd_disb_all.disb_date%TYPE,

1429:
1430: PROCEDURE update_award( p_award_id IN igf_aw_award_all.award_id%TYPE,
1431: p_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE,
1432: p_disb_amt IN igf_aw_awd_disb_all.disb_net_amt%TYPE,
1433: p_disb_dt IN igf_aw_awd_disb_all.disb_date%TYPE,
1434: p_action IN VARCHAR2,
1435: x_called_from IN VARCHAR2
1436: )
1437: IS

Line 1501: igf_aw_awd_disb_all

1497: SUM(NVL(disb_gross_amt,0)) offered_amt,
1498: SUM(NVL(disb_accepted_amt,0)) accepted_amt,
1499: SUM(NVL(disb_paid_amt,0)) paid_amt
1500: FROM
1501: igf_aw_awd_disb_all
1502: WHERE
1503: award_id = p_award_id;
1504:
1505: disb_rec cur_disb%ROWTYPE;

Line 1526: FROM igf_aw_awd_disb_all

1522: -- Returns 'X' for all the non-cancelled disbursements in the award
1523: CURSOR cur_get_cancl_disb(cp_award_id igf_aw_award_all.award_id%TYPE)
1524: IS
1525: SELECT 'X'
1526: FROM igf_aw_awd_disb_all
1527: WHERE award_id = cp_award_id AND
1528: trans_type <> 'C';
1529:
1530: l_cur_get_cancl_disb_rec cur_get_cancl_disb%ROWTYPE;

Line 1538: FROM igf_aw_awd_disb_all

1534: CURSOR c_get_accept_amt(
1535: cp_award_id igf_aw_award_all.award_id%TYPE
1536: ) IS
1537: SELECT SUM(disb_accepted_amt) accepted_amt
1538: FROM igf_aw_awd_disb_all
1539: WHERE award_id = cp_award_id
1540: AND trans_type <> 'C';
1541: l_get_accept_amt c_get_accept_amt%ROWTYPE;
1542:

Line 2217: igf_aw_awd_disb_all disb,

2213: SELECT
2214: COUNT(awd.award_id) lock_count
2215: FROM
2216: igf_aw_award_all awd,
2217: igf_aw_awd_disb_all disb,
2218: igf_aw_awd_prd_term apt
2219: WHERE
2220: disb.award_id = awd.award_id
2221: AND disb.ld_cal_type = apt.ld_cal_type