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.

[Home] [Help]

APPS.IGF_AW_GEN dependencies on IGF_AW_AWARD_ALL

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