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_PACKAGING dependencies on IGF_AW_AWARD_T_ALL

Line 1704: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,

1700: END LOOP;
1701: END cancel_awards;
1702:
1703: PROCEDURE round_off_disbursements(
1704: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
1705: p_base_id IN igf_aw_award_t_all.base_id%TYPE,
1706: p_process_id IN igf_aw_award_t_all.process_id%TYPE,
1707: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
1708: p_adplans_id IN igf_aw_award_t_all.adplans_id%TYPE,

Line 1705: p_base_id IN igf_aw_award_t_all.base_id%TYPE,

1701: END cancel_awards;
1702:
1703: PROCEDURE round_off_disbursements(
1704: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
1705: p_base_id IN igf_aw_award_t_all.base_id%TYPE,
1706: p_process_id IN igf_aw_award_t_all.process_id%TYPE,
1707: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
1708: p_adplans_id IN igf_aw_award_t_all.adplans_id%TYPE,
1709: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,

Line 1706: p_process_id IN igf_aw_award_t_all.process_id%TYPE,

1702:
1703: PROCEDURE round_off_disbursements(
1704: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
1705: p_base_id IN igf_aw_award_t_all.base_id%TYPE,
1706: p_process_id IN igf_aw_award_t_all.process_id%TYPE,
1707: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
1708: p_adplans_id IN igf_aw_award_t_all.adplans_id%TYPE,
1709: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
1710: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,

Line 1707: p_award_id IN igf_aw_award_t_all.award_id%TYPE,

1703: PROCEDURE round_off_disbursements(
1704: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
1705: p_base_id IN igf_aw_award_t_all.base_id%TYPE,
1706: p_process_id IN igf_aw_award_t_all.process_id%TYPE,
1707: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
1708: p_adplans_id IN igf_aw_award_t_all.adplans_id%TYPE,
1709: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
1710: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
1711: p_disb_count IN NUMBER

Line 1708: p_adplans_id IN igf_aw_award_t_all.adplans_id%TYPE,

1704: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
1705: p_base_id IN igf_aw_award_t_all.base_id%TYPE,
1706: p_process_id IN igf_aw_award_t_all.process_id%TYPE,
1707: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
1708: p_adplans_id IN igf_aw_award_t_all.adplans_id%TYPE,
1709: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
1710: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
1711: p_disb_count IN NUMBER
1712: )

Line 1709: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,

1705: p_base_id IN igf_aw_award_t_all.base_id%TYPE,
1706: p_process_id IN igf_aw_award_t_all.process_id%TYPE,
1707: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
1708: p_adplans_id IN igf_aw_award_t_all.adplans_id%TYPE,
1709: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
1710: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
1711: p_disb_count IN NUMBER
1712: )
1713: IS

Line 1770: cp_fund_id igf_aw_award_t_all.fund_id%TYPE,

1766: -- Returns all the disbursements in the temporary table
1767: -- The ORDER BY clause ensures that the disbursements are returned
1768: -- in the order of their creation
1769: CURSOR cur_get_all_disb (
1770: cp_fund_id igf_aw_award_t_all.fund_id%TYPE,
1771: cp_base_id igf_aw_award_t_all.base_id%TYPE,
1772: cp_process_id igf_aw_award_t_all.process_id%TYPE,
1773: cp_adplans_id igf_aw_award_t_all.adplans_id%TYPE,
1774: p_award_id igf_aw_award_t_all.award_id%TYPE

Line 1771: cp_base_id igf_aw_award_t_all.base_id%TYPE,

1767: -- The ORDER BY clause ensures that the disbursements are returned
1768: -- in the order of their creation
1769: CURSOR cur_get_all_disb (
1770: cp_fund_id igf_aw_award_t_all.fund_id%TYPE,
1771: cp_base_id igf_aw_award_t_all.base_id%TYPE,
1772: cp_process_id igf_aw_award_t_all.process_id%TYPE,
1773: cp_adplans_id igf_aw_award_t_all.adplans_id%TYPE,
1774: p_award_id igf_aw_award_t_all.award_id%TYPE
1775: )

Line 1772: cp_process_id igf_aw_award_t_all.process_id%TYPE,

1768: -- in the order of their creation
1769: CURSOR cur_get_all_disb (
1770: cp_fund_id igf_aw_award_t_all.fund_id%TYPE,
1771: cp_base_id igf_aw_award_t_all.base_id%TYPE,
1772: cp_process_id igf_aw_award_t_all.process_id%TYPE,
1773: cp_adplans_id igf_aw_award_t_all.adplans_id%TYPE,
1774: p_award_id igf_aw_award_t_all.award_id%TYPE
1775: )
1776: IS

Line 1773: cp_adplans_id igf_aw_award_t_all.adplans_id%TYPE,

1769: CURSOR cur_get_all_disb (
1770: cp_fund_id igf_aw_award_t_all.fund_id%TYPE,
1771: cp_base_id igf_aw_award_t_all.base_id%TYPE,
1772: cp_process_id igf_aw_award_t_all.process_id%TYPE,
1773: cp_adplans_id igf_aw_award_t_all.adplans_id%TYPE,
1774: p_award_id igf_aw_award_t_all.award_id%TYPE
1775: )
1776: IS
1777: SELECT awd_t.rowid, awd_t.*

Line 1774: p_award_id igf_aw_award_t_all.award_id%TYPE

1770: cp_fund_id igf_aw_award_t_all.fund_id%TYPE,
1771: cp_base_id igf_aw_award_t_all.base_id%TYPE,
1772: cp_process_id igf_aw_award_t_all.process_id%TYPE,
1773: cp_adplans_id igf_aw_award_t_all.adplans_id%TYPE,
1774: p_award_id igf_aw_award_t_all.award_id%TYPE
1775: )
1776: IS
1777: SELECT awd_t.rowid, awd_t.*
1778: FROM igf_aw_award_t_all awd_t

Line 1778: FROM igf_aw_award_t_all awd_t

1774: p_award_id igf_aw_award_t_all.award_id%TYPE
1775: )
1776: IS
1777: SELECT awd_t.rowid, awd_t.*
1778: FROM igf_aw_award_t_all awd_t
1779: WHERE
1780: base_id = p_base_id AND
1781: fund_id = p_fund_id AND
1782: process_id = p_process_id AND

Line 4989: FROM igf_aw_award_t_all

4985: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
4986: )
4987: IS
4988: SELECT 'x'
4989: FROM igf_aw_award_t_all
4990: WHERE
4991: process_id = l_process_id AND
4992: fund_id = cp_fund_id AND
4993: base_id = cp_base_id AND

Line 5004: FROM igf_aw_award_t_all awd_t

5000: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
5001: )
5002: IS
5003: SELECT awd_t.rowid, awd_t.*
5004: FROM igf_aw_award_t_all awd_t
5005: WHERE
5006: awd_t.flag = 'AU' AND
5007: process_id = l_process_id AND
5008: fund_id = cp_fund_id AND

Line 5029: FROM igf_aw_award_t_all awdt,

5025: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
5026: ) IS
5027: SELECT SUM(DECODE(awd.award_status,'CANCELLED',1,0)) cancelled_awd,
5028: SUM(DECODE(awd.award_status,'OFFERED',1,'ACCEPTED',1,0)) off_acc_awd
5029: FROM igf_aw_award_t_all awdt,
5030: igf_aw_award_all awd
5031: WHERE awdt.fund_id = cp_fund_id
5032: AND awdt.base_id = cp_base_id
5033: AND awdt.process_id = l_process_id

Line 5044: FROM igf_aw_award_t_all awdt,

5040: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
5041: ) IS
5042: SELECT awdt.ROWID row_id,
5043: awdt.*
5044: FROM igf_aw_award_t_all awdt,
5045: igf_aw_award_all awd
5046: WHERE awdt.award_id = awd.award_id
5047: AND awdt.fund_id = cp_fund_id
5048: AND awdt.base_id = cp_base_id

Line 5060: FROM igf_aw_award_t_all awdt

5056: cp_award_id igf_aw_award_all.award_id%TYPE
5057: ) IS
5058: SELECT awdt.ROWID row_id,
5059: awdt.*
5060: FROM igf_aw_award_t_all awdt
5061: WHERE awdt.award_id <> cp_award_id
5062: AND awdt.base_id = cp_base_id
5063: AND awdt.fund_id = cp_fund_id
5064: AND awdt.process_id = l_process_id;

Line 5071: FROM igf_aw_award_t_all awdt,

5067: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
5068: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
5069: ) IS
5070: SELECT awd.award_id
5071: FROM igf_aw_award_t_all awdt,
5072: igf_aw_award_all awd
5073: WHERE awdt.award_id = awd.award_id
5074: AND awdt.fund_id = cp_fund_id
5075: AND awdt.base_id = cp_base_id

Line 5838: cp_process_id igf_aw_award_t_all.process_id%TYPE

5834: -- Gets all the existing awards for a particular fund for a particular student
5835: CURSOR c_get_cancel_awds(
5836: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
5837: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
5838: cp_process_id igf_aw_award_t_all.process_id%TYPE
5839: )
5840: IS
5841: SELECT awd_t.rowid, awd_t.*
5842: FROM igf_aw_award_t_all awd_t

Line 5842: FROM igf_aw_award_t_all awd_t

5838: cp_process_id igf_aw_award_t_all.process_id%TYPE
5839: )
5840: IS
5841: SELECT awd_t.rowid, awd_t.*
5842: FROM igf_aw_award_t_all awd_t
5843: WHERE
5844: base_id = cp_base_id AND
5845: fund_id = cp_fund_id AND
5846: process_id = cp_process_id AND