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_AWARD

Line 61: -- igf_aw_award_pkg.update_row

57: -- adplans_id is passed instead of fund_id and out
58: -- variable is VARCHAR2 instead of BOOLEAN
59: --------------------------------------------------------------------------------------
60: -- veramach 1-NOV-2003 FA 125(#3160568) Added apdlans_id in the calls to
61: -- igf_aw_award_pkg.update_row
62: --------------------------------------------------------------------------------------
63: -- ugummall 25-SEP-2003 FA 126 - Multiple FA Offices
64: -- added new parameter assoc_org_num to
65: -- igf_ap_fa_base_rec_pkg.update_row call.

Line 69: -- handler calls for igf_aw_award_pkg.update_row

65: -- igf_ap_fa_base_rec_pkg.update_row call.
66: --------------------------------------------------------------------------------------
67: -- bkkumar 04-jun-2003 Bug 2858504 Added legacy_record_flag
68: -- and award_number_txt in the table
69: -- handler calls for igf_aw_award_pkg.update_row
70: --------------------------------------------------------------------------------------
71: -- sjadhav 26-Mar-2003 Bug 2863960
72: -- Modified routine update_disb to populate disb gross
73: -- amount in the adjustment table with disb accepted

Line 112: -- igf_aw_award_pkg.update_row

108: -- masehgal 25-Sep-2002 FA 104 - To Do Enhancements
109: -- Added manual_disb_hold in FA Base update
110: --------------------------------------------------------------------------------------
111: -- brajendr 14-Jun-2002 Modified the update_row call of
112: -- igf_aw_award_pkg.update_row
113: -- to calculate the sum of the paid amount of all
114: -- the disbursements
115: --------------------------------------------------------------------------------------
116: -- brajendr 12-Jun-2002 Modified the update_row call of

Line 259: FUNCTION chk_disb_status(p_award_id igf_aw_award_all.award_id%TYPE)

255: RETURN l_desc;
256:
257: END lookup_desc;
258:
259: FUNCTION chk_disb_status(p_award_id igf_aw_award_all.award_id%TYPE)
260: RETURN BOOLEAN
261: IS
262: ------------------------------------------------------------------
263: --Created by : museshad

Line 275: CURSOR cur_get_cancl_disb(cp_award_id igf_aw_award_all.award_id%TYPE)

271: --Change History:
272: --Who When What
273: -------------------------------------------------------------------
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

Line 343: FROM igf_aw_award awd, igf_aw_fund_mast fmast, igf_aw_fund_cat cat

339: p_award_id igf_db_awd_disb_dtl.award_id%TYPE
340: )
341: IS
342: SELECT cat.fed_fund_code, awd.award_status award_status
343: FROM igf_aw_award awd, igf_aw_fund_mast fmast, igf_aw_fund_cat cat
344: WHERE awd.award_id = p_award_id
345: AND awd.fund_id = fmast.fund_id
346: AND fmast.fund_code = cat.fund_code;
347:

Line 850: CURSOR c_pkg_tot ( x_base_id igf_aw_award_t.base_id%TYPE) IS

846: || avenkatr 27-JUN-2001 1. Added p_pack_status parameter.
847: */
848:
849: -- Sums up studentwise packaged totals
850: CURSOR c_pkg_tot ( x_base_id igf_aw_award_t.base_id%TYPE) IS
851: SELECT SUM(NVL(awd.offered_amt,0)) offered_amt,
852: SUM(NVL(awd.accepted_amt,0)) accepted_amt
853: FROM igf_aw_award awd
854: WHERE awd.base_id = x_base_id

Line 853: FROM igf_aw_award awd

849: -- Sums up studentwise packaged totals
850: CURSOR c_pkg_tot ( x_base_id igf_aw_award_t.base_id%TYPE) IS
851: SELECT SUM(NVL(awd.offered_amt,0)) offered_amt,
852: SUM(NVL(awd.accepted_amt,0)) accepted_amt
853: FROM igf_aw_award awd
854: WHERE awd.base_id = x_base_id
855: AND award_status NOT IN( 'CANCELLED', 'DECLINED','SIMULATED' ) ;
856:
857: l_pkg_tot c_pkg_tot%rowtype ;

Line 1085: PROCEDURE update_fmast( x_old_ref in igf_aw_award_all%ROWTYPE,

1081: igs_ge_gen_003.set_org_id(p_context);
1082: END set_org_id;
1083:
1084:
1085: PROCEDURE update_fmast( x_old_ref in igf_aw_award_all%ROWTYPE,
1086: x_new_ref in igf_aw_award_all%ROWTYPE,
1087: flag in Varchar )
1088: IS
1089: /*

Line 1086: x_new_ref in igf_aw_award_all%ROWTYPE,

1082: END set_org_id;
1083:
1084:
1085: PROCEDURE update_fmast( x_old_ref in igf_aw_award_all%ROWTYPE,
1086: x_new_ref in igf_aw_award_all%ROWTYPE,
1087: flag in Varchar )
1088: IS
1089: /*
1090: || Created By : pkpatel

Line 1430: PROCEDURE update_award( p_award_id IN igf_aw_award_all.award_id%TYPE,

1426: app_exception.raise_exception;
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,

Line 1456: -- to igf_aw_award_pkg.update_row

1452: -- De-link auto update of Pell Disbursement and Pell
1453: -- origination amounts
1454: --------------------------------------------------------------------------------------
1455: -- veramach 1-NOV-2003 FA 125(#3160568) Added apdlans_id in the calls
1456: -- to igf_aw_award_pkg.update_row
1457: --------------------------------------------------------------------------------------
1458: -- rasahoo 09-Sep-2003 Bug 33094878 Added the call to update_fabase_awds
1459: -- as the FA base rec was not getting updated when any
1460: -- DML Operations performed from Disbursement form.

Line 1469: -- igf_aw_Award,igf_gr_rfms,igf_gr_rfms_disb

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: --------------------------------------------------------------------------------------
1473:

Line 1477: CURSOR cur_award (p_award_id igf_aw_award_all.award_id%TYPE)

1473:
1474: --
1475: -- Cursor to Get The Award Record which will be updated
1476: --
1477: CURSOR cur_award (p_award_id igf_aw_award_all.award_id%TYPE)
1478: IS
1479: SELECT
1480: awd.rowid row_id,awd.*
1481: FROM

Line 1482: igf_aw_award_all awd

1478: IS
1479: SELECT
1480: awd.rowid row_id,awd.*
1481: FROM
1482: igf_aw_award_all awd
1483: WHERE
1484: award_id = p_award_id
1485: FOR UPDATE OF offered_amt;
1486:

Line 1494: CURSOR cur_disb (p_award_id igf_aw_award_all.award_id%TYPE)

1490: -- Cursor to get Total Amounts from Disbursement Table
1491: -- The paid amount should be updated by the Student Finance process,
1492: -- that is why we are not taking the Paid amount in this cursor
1493: --
1494: CURSOR cur_disb (p_award_id igf_aw_award_all.award_id%TYPE)
1495: IS
1496: SELECT
1497: SUM(NVL(disb_gross_amt,0)) offered_amt,
1498: SUM(NVL(disb_accepted_amt,0)) accepted_amt,

Line 1523: CURSOR cur_get_cancl_disb(cp_award_id igf_aw_award_all.award_id%TYPE)

1519: cur_fund_dtls_rec cur_fund_dtls%ROWTYPE;
1520:
1521: -- museshad (Bug 3954451)
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

Line 1535: cp_award_id igf_aw_award_all.award_id%TYPE

1531: -- museshad (Bug 3954451)
1532:
1533: -- Get accepted amt
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

Line 1548: l_awd_status igf_aw_award_all.award_status%TYPE;

1544: l_name VARCHAR2(80);
1545: l_v_called_from VARCHAR2(30);
1546:
1547: -- museshad (Bug 3954451)
1548: l_awd_status igf_aw_award_all.award_status%TYPE;
1549: l_awd_off_amt igf_aw_award_all.offered_amt%TYPE;
1550: l_awd_acc_amt igf_aw_award_all.accepted_amt%TYPE;
1551: l_awd_proc_status_code igf_aw_award_all.awd_proc_status_code%TYPE;
1552: -- museshad (Bug 3954451)

Line 1549: l_awd_off_amt igf_aw_award_all.offered_amt%TYPE;

1545: l_v_called_from VARCHAR2(30);
1546:
1547: -- museshad (Bug 3954451)
1548: l_awd_status igf_aw_award_all.award_status%TYPE;
1549: l_awd_off_amt igf_aw_award_all.offered_amt%TYPE;
1550: l_awd_acc_amt igf_aw_award_all.accepted_amt%TYPE;
1551: l_awd_proc_status_code igf_aw_award_all.awd_proc_status_code%TYPE;
1552: -- museshad (Bug 3954451)
1553:

Line 1550: l_awd_acc_amt igf_aw_award_all.accepted_amt%TYPE;

1546:
1547: -- museshad (Bug 3954451)
1548: l_awd_status igf_aw_award_all.award_status%TYPE;
1549: l_awd_off_amt igf_aw_award_all.offered_amt%TYPE;
1550: l_awd_acc_amt igf_aw_award_all.accepted_amt%TYPE;
1551: l_awd_proc_status_code igf_aw_award_all.awd_proc_status_code%TYPE;
1552: -- museshad (Bug 3954451)
1553:
1554: BEGIN

Line 1551: l_awd_proc_status_code igf_aw_award_all.awd_proc_status_code%TYPE;

1547: -- museshad (Bug 3954451)
1548: l_awd_status igf_aw_award_all.award_status%TYPE;
1549: l_awd_off_amt igf_aw_award_all.offered_amt%TYPE;
1550: l_awd_acc_amt igf_aw_award_all.accepted_amt%TYPE;
1551: l_awd_proc_status_code igf_aw_award_all.awd_proc_status_code%TYPE;
1552: -- museshad (Bug 3954451)
1553:
1554: BEGIN
1555: l_v_called_from := x_called_from;

Line 1651: igf_aw_award_pkg.update_row ( x_mode => 'R',

1647: ||award_rec.award_id);
1648: END IF;
1649: END IF;
1650:
1651: igf_aw_award_pkg.update_row ( x_mode => 'R',
1652: x_rowid => award_rec.row_id,
1653: x_award_id => award_rec.award_id,
1654: x_fund_id => award_rec.fund_id,
1655: x_base_id => award_rec.base_id,

Line 1892: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,

1888: */
1889: PROCEDURE get_notification_status (
1890: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1891: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
1892: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
1893: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
1894: p_notification_status_code OUT NOCOPY igf_aw_award_all.notification_status_code%TYPE,
1895: p_notification_status_date OUT NOCOPY igf_aw_award_all.notification_status_date%TYPE
1896: ) AS

Line 1894: p_notification_status_code OUT NOCOPY igf_aw_award_all.notification_status_code%TYPE,

1890: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1891: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
1892: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
1893: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
1894: p_notification_status_code OUT NOCOPY igf_aw_award_all.notification_status_code%TYPE,
1895: p_notification_status_date OUT NOCOPY igf_aw_award_all.notification_status_date%TYPE
1896: ) AS
1897: -- mnade 5/24/2005 using the base query from IGFAW016.pld for the same C_PROCESS_STATUS
1898: CURSOR c_process_status (cp_ci_cal_type igs_ca_inst_all.cal_type%TYPE,

Line 1895: p_notification_status_date OUT NOCOPY igf_aw_award_all.notification_status_date%TYPE

1891: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
1892: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
1893: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
1894: p_notification_status_code OUT NOCOPY igf_aw_award_all.notification_status_code%TYPE,
1895: p_notification_status_date OUT NOCOPY igf_aw_award_all.notification_status_date%TYPE
1896: ) AS
1897: -- mnade 5/24/2005 using the base query from IGFAW016.pld for the same C_PROCESS_STATUS
1898: CURSOR c_process_status (cp_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
1899: cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,

Line 1917: IGF_AW_AWARD_all AWD,

1913: 'S', 3,
1914: 'F', 3
1915: ) STATUS_ORDER
1916: FROM
1917: IGF_AW_AWARD_all AWD,
1918: IGF_AW_FUND_MAST FMAST
1919: WHERE
1920: FMAST.CI_CAL_TYPE = cp_ci_cal_type AND
1921: FMAST.CI_SEQUENCE_NUMBER = cp_ci_sequence_number AND

Line 1985: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,

1981: */
1982: PROCEDURE update_notification_status (
1983: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1984: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
1985: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
1986: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
1987: p_notification_status_code IN igf_aw_award_all.notification_status_code%TYPE,
1988: p_notification_status_date IN igf_aw_award_all.notification_status_date%TYPE,
1989: p_called_from IN VARCHAR2

Line 1987: p_notification_status_code IN igf_aw_award_all.notification_status_code%TYPE,

1983: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1984: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
1985: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
1986: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
1987: p_notification_status_code IN igf_aw_award_all.notification_status_code%TYPE,
1988: p_notification_status_date IN igf_aw_award_all.notification_status_date%TYPE,
1989: p_called_from IN VARCHAR2
1990: ) AS
1991: -- mnade 5/24/2005 using the base query from IGFAW016.pld for the same C_PROCESS_STATUS

Line 1988: p_notification_status_date IN igf_aw_award_all.notification_status_date%TYPE,

1984: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
1985: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
1986: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
1987: p_notification_status_code IN igf_aw_award_all.notification_status_code%TYPE,
1988: p_notification_status_date IN igf_aw_award_all.notification_status_date%TYPE,
1989: p_called_from IN VARCHAR2
1990: ) AS
1991: -- mnade 5/24/2005 using the base query from IGFAW016.pld for the same C_PROCESS_STATUS
1992: CURSOR c_awards (cp_ci_cal_type igs_ca_inst_all.cal_type%TYPE,

Line 2000: IGF_AW_AWARD_all AWD,

1996: IS
1997: SELECT
1998: awd.award_id
1999: FROM
2000: IGF_AW_AWARD_all AWD,
2001: IGF_AW_FUND_MAST FMAST
2002: WHERE
2003: FMAST.CI_CAL_TYPE = cp_ci_cal_type AND
2004: FMAST.CI_SEQUENCE_NUMBER = cp_ci_sequence_number AND

Line 2065: p_award_id IN igf_aw_award_all.award_id%TYPE,

2061: || Who When What
2062: || (reverse chronological order - newest change first)
2063: */
2064: PROCEDURE update_awd_notification_status (
2065: p_award_id IN igf_aw_award_all.award_id%TYPE,
2066: p_notification_status_code IN igf_aw_award_all.notification_status_code%TYPE,
2067: p_notification_status_date IN igf_aw_award_all.notification_status_date%TYPE,
2068: p_called_from IN VARCHAR2
2069: ) AS

Line 2066: p_notification_status_code IN igf_aw_award_all.notification_status_code%TYPE,

2062: || (reverse chronological order - newest change first)
2063: */
2064: PROCEDURE update_awd_notification_status (
2065: p_award_id IN igf_aw_award_all.award_id%TYPE,
2066: p_notification_status_code IN igf_aw_award_all.notification_status_code%TYPE,
2067: p_notification_status_date IN igf_aw_award_all.notification_status_date%TYPE,
2068: p_called_from IN VARCHAR2
2069: ) AS
2070: -- mnade 5/24/2005 using the base query from IGFAW016.pld for the same C_PROCESS_STATUS

Line 2067: p_notification_status_date IN igf_aw_award_all.notification_status_date%TYPE,

2063: */
2064: PROCEDURE update_awd_notification_status (
2065: p_award_id IN igf_aw_award_all.award_id%TYPE,
2066: p_notification_status_code IN igf_aw_award_all.notification_status_code%TYPE,
2067: p_notification_status_date IN igf_aw_award_all.notification_status_date%TYPE,
2068: p_called_from IN VARCHAR2
2069: ) AS
2070: -- mnade 5/24/2005 using the base query from IGFAW016.pld for the same C_PROCESS_STATUS
2071: CURSOR c_award (cp_award_id igf_aw_award_all.award_id%TYPE)

Line 2071: CURSOR c_award (cp_award_id igf_aw_award_all.award_id%TYPE)

2067: p_notification_status_date IN igf_aw_award_all.notification_status_date%TYPE,
2068: p_called_from IN VARCHAR2
2069: ) AS
2070: -- mnade 5/24/2005 using the base query from IGFAW016.pld for the same C_PROCESS_STATUS
2071: CURSOR c_award (cp_award_id igf_aw_award_all.award_id%TYPE)
2072: IS
2073: SELECT
2074: awd.rowid row_id, awd.*
2075: FROM

Line 2076: IGF_AW_AWARD_all awd

2072: IS
2073: SELECT
2074: awd.rowid row_id, awd.*
2075: FROM
2076: IGF_AW_AWARD_all awd
2077: WHERE
2078: awd.award_id = cp_award_id;
2079: -- award_rec c_award%ROWTYPE;
2080: BEGIN

Line 2092: igf_aw_award_pkg.update_row ( x_mode => 'R',

2088:
2089: -- OPEN c_award (cp_award_id => p_award_id);
2090: FOR award_rec IN c_award (cp_award_id => p_award_id) LOOP
2091: -- FETCH c_award INTO award_rec;
2092: igf_aw_award_pkg.update_row ( x_mode => 'R',
2093: x_rowid => award_rec.row_id,
2094: x_award_id => award_rec.award_id,
2095: x_fund_id => award_rec.fund_id,
2096: x_base_id => award_rec.base_id,

Line 2202: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,

2198: FUNCTION is_fund_locked_for_awd_period (
2199: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
2200: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2201: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
2202: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
2203: p_fund_id IN igf_aw_award_all.fund_id%TYPE
2204: ) RETURN BOOLEAN AS
2205: CURSOR locked_award_count_cur (
2206: cp_base_id IN igf_ap_fa_base_rec_all.base_id%type,

Line 2203: p_fund_id IN igf_aw_award_all.fund_id%TYPE

2199: p_base_id IN igf_ap_fa_base_rec_all.base_id%type,
2200: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2201: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
2202: p_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
2203: p_fund_id IN igf_aw_award_all.fund_id%TYPE
2204: ) RETURN BOOLEAN AS
2205: CURSOR locked_award_count_cur (
2206: cp_base_id IN igf_ap_fa_base_rec_all.base_id%type,
2207: cp_cal_type IN igs_ca_inst_all.cal_type%TYPE,

Line 2209: cp_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,

2205: CURSOR locked_award_count_cur (
2206: cp_base_id IN igf_ap_fa_base_rec_all.base_id%type,
2207: cp_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2208: cp_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
2209: cp_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
2210: cp_fund_id IN igf_aw_award_all.fund_id%TYPE
2211: )
2212: IS
2213: SELECT

Line 2210: cp_fund_id IN igf_aw_award_all.fund_id%TYPE

2206: cp_base_id IN igf_ap_fa_base_rec_all.base_id%type,
2207: cp_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2208: cp_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
2209: cp_awarding_period IN igf_aw_award_prd.award_prd_cd%TYPE,
2210: cp_fund_id IN igf_aw_award_all.fund_id%TYPE
2211: )
2212: IS
2213: SELECT
2214: COUNT(awd.award_id) lock_count

Line 2216: igf_aw_award_all awd,

2212: IS
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