eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AW_GEN dependencies on IGF_AW_AWD_DISB

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 1468: -- igf_aw_awd_Disb table. This routine updates

1464: -- status to 'R'.
1465: --------------------------------------------------------------------------------------
1466: -- sjadhav Jan 25,2002 Bug ID : 2154941
1467: -- This routine is called throgh table handler of
1468: -- igf_aw_awd_Disb table. This routine updates
1469: -- igf_aw_Award,igf_gr_rfms,igf_gr_rfms_disb
1470: -- tables to reflect the changes made in
1471: -- igf_aw_Awd_disb table
1472: --------------------------------------------------------------------------------------

Line 1471: -- igf_aw_Awd_disb table

1467: -- This routine is called throgh table handler of
1468: -- igf_aw_awd_Disb table. This routine updates
1469: -- igf_aw_Award,igf_gr_rfms,igf_gr_rfms_disb
1470: -- tables to reflect the changes made in
1471: -- igf_aw_Awd_disb table
1472: --------------------------------------------------------------------------------------
1473:
1474: --
1475: -- Cursor to Get The Award Record which will be updated

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 1926: FROM IGF_AW_AWD_DISB DISB

1922: AWD.FUND_ID = FMAST.FUND_ID AND
1923: AWD.BASE_ID = cp_base_id AND
1924: NOT EXISTS
1925: (SELECT DISB.LD_CAL_TYPE, DISB.LD_SEQUENCE_NUMBER
1926: FROM IGF_AW_AWD_DISB DISB
1927: WHERE
1928: DISB.AWARD_ID = AWD.AWARD_ID
1929: MINUS
1930: SELECT LD_CAL_TYPE, LD_SEQUENCE_NUMBER

Line 2009: FROM IGF_AW_AWD_DISB DISB

2005: AWD.FUND_ID = FMAST.FUND_ID AND
2006: AWD.BASE_ID = cp_base_id AND
2007: NOT EXISTS
2008: (SELECT DISB.LD_CAL_TYPE, DISB.LD_SEQUENCE_NUMBER
2009: FROM IGF_AW_AWD_DISB DISB
2010: WHERE
2011: DISB.AWARD_ID = AWD.AWARD_ID
2012: MINUS
2013: SELECT LD_CAL_TYPE, LD_SEQUENCE_NUMBER

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