APPS.IGF_AW_GEN_005 dependencies on IGF_AW_AWARD

Line 20: | TBH impact of the igf_aw_award |

16: | Who When What |
17: | veramach Oct 2004 FA 152/FA 137 - Changes to wrappers to|
18: | bring in the awarding period setup |
19: | bkkumar 4-DEC-2003 FA 131 Bug# 3252832 |
20: | TBH impact of the igf_aw_award |
21: | Added columns LOCK_AWARD_FLAG, |
22: | APP_TRANS_NUM_TXT |
23: | veramach 1-NOV-2003 FA 125 Multipl Distribution Methods |
24: | Added procedures update_plan, |

Line 91: p_award_id igf_aw_award.award_id%TYPE

87: app_exception.raise_exception;
88: END update_plan;
89:
90: PROCEDURE update_dist_plan(
91: p_award_id igf_aw_award.award_id%TYPE
92: ) AS
93: ------------------------------------------------------------------
94: --Created by : veramach, Oracle India
95: --Date created: 1-NOV-2003

Line 108: cp_award_id igf_aw_award.award_id%TYPE

104: --bvisvana 11-Jul-2005 TBH impact for notification status code,notification status date and publish in ss flag
105: -------------------------------------------------------------------
106: -- Get award details
107: CURSOR c_award(
108: cp_award_id igf_aw_award.award_id%TYPE
109: ) IS
110: SELECT *
111: FROM igf_aw_award
112: WHERE award_id = cp_award_id;

Line 111: FROM igf_aw_award

107: CURSOR c_award(
108: cp_award_id igf_aw_award.award_id%TYPE
109: ) IS
110: SELECT *
111: FROM igf_aw_award
112: WHERE award_id = cp_award_id;
113:
114: l_award c_award%ROWTYPE;
115:

Line 121: igf_aw_award_pkg.update_row(

117: IF p_award_id IS NOT NULL THEN
118: OPEN c_award(p_award_id);
119: FETCH c_award INTO l_award;
120: IF c_award%FOUND THEN
121: igf_aw_award_pkg.update_row(
122: x_rowid => l_award.row_id,
123: x_award_id => l_award.award_id,
124: x_fund_id => l_award.fund_id,
125: x_base_id => l_award.base_id,

Line 218: FROM igf_aw_award

214: CURSOR c_check_awd(
215: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
216: ) IS
217: SELECT adplans_id
218: FROM igf_aw_award
219: WHERE adplans_id = cp_adplans_id;
220:
221: l_check_agrp c_check_agrp%ROWTYPE;
222: l_check_frml c_check_frml%ROWTYPE;