APPS.IGW_AWARD_BUDGETS_TBH dependencies on IGW_AWARD_BUDGETS

Line 1: PACKAGE BODY IGW_AWARD_BUDGETS_TBH AS

1: PACKAGE BODY IGW_AWARD_BUDGETS_TBH AS
2: --$Header: igwtabtb.pls 115.4 2002/11/18 19:19:44 ashkumar noship $
3:
4: procedure INSERT_ROW (
5: p_award_budget_id NUMBER

Line 23: from igw_award_budgets

19: ,x_return_status OUT NOCOPY VARCHAR2) IS
20:
21: cursor c_budget_line is
22: select rowid
23: from igw_award_budgets
24: where award_budget_id = p_award_budget_id;
25:
26: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
27: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line 33: insert into igw_award_budgets(

29:
30: begin
31: x_return_status := FND_API.G_RET_STS_SUCCESS;
32:
33: insert into igw_award_budgets(
34: award_budget_id
35: ,proposal_installment_id
36: ,budget_period_id
37: ,expenditure_type_cat

Line 118: from igw_award_budgets

114: l_row_id ROWID := p_rowid;
115:
116: CURSOR get_row_id IS
117: SELECT rowid
118: from igw_award_budgets
119: where award_budget_id = p_award_budget_id;
120:
121: begin
122: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 130: update igw_award_budgets

126: FETCH get_row_id INTO l_row_id;
127: CLOSE get_row_id;
128: END IF;
129:
130: update igw_award_budgets
131: set budget_period_id = p_budget_period_id
132: , expenditure_type_cat = p_expenditure_type_cat
133: , expenditure_category_flag = p_expenditure_category_flag
134: , budget_amount = p_budget_amount

Line 172: from igw_award_budgets

168: l_row_id ROWID := p_rowid;
169:
170: CURSOR get_row_id IS
171: SELECT rowid
172: from igw_award_budgets
173: where award_budget_id = p_award_budget_id;
174:
175: begin
176:

Line 185: delete from igw_award_budgets

181: FETCH get_row_id INTO l_row_id;
182: CLOSE get_row_id;
183: END IF;
184:
185: delete from igw_award_budgets
186: where rowid = l_row_id
187: and record_version_number = p_record_version_number;
188:
189: if (sql%notfound) then

Line 204: END IGW_AWARD_BUDGETS_TBH;

200: RAISE;
201: end DELETE_ROW;
202:
203:
204: END IGW_AWARD_BUDGETS_TBH;