APPS.IGW_BUDGET_PERIODS_TBH dependencies on IGW_BUDGET_PERIODS

Line 1: PACKAGE BODY IGW_BUDGET_PERIODS_TBH AS

1: PACKAGE BODY IGW_BUDGET_PERIODS_TBH AS
2: -- $Header: igwtbprb.pls 115.5 2002/11/14 18:41:23 vmedikon ship $
3:
4: procedure INSERT_ROW (
5: p_proposal_id NUMBER

Line 23: from igw_budget_periods

19: ,x_return_status OUT NOCOPY VARCHAR2) IS
20:
21: cursor c_budget_period is
22: select rowid
23: from igw_budget_periods
24: where proposal_id = p_proposal_id
25: and version_id = p_version_id
26: and budget_period_id = p_budget_period_id;
27:

Line 35: insert into igw_budget_periods(

31:
32: begin
33: x_return_status := FND_API.G_RET_STS_SUCCESS;
34:
35: insert into igw_budget_periods(
36: proposal_id
37: ,version_id
38: ,budget_period_id
39: ,start_date

Line 120: FROM IGW_BUDGET_PERIODS

116: l_row_id ROWID := p_rowid;
117:
118: CURSOR get_row_id IS
119: SELECT rowid
120: FROM IGW_BUDGET_PERIODS
121: WHERE proposal_id = p_proposal_id
122: AND version_id = p_version_id
123: AND budget_period_id = p_budget_period_id;
124:

Line 134: update igw_budget_periods

130: FETCH get_row_id INTO l_row_id;
131: CLOSE get_row_id;
132: END IF;
133:
134: update igw_budget_periods
135: set budget_period_id = p_budget_period_id
136: , start_date = p_start_date
137: , end_date = p_end_date
138: , total_cost = p_total_cost

Line 177: FROM IGW_BUDGET_PERIODS

173: l_row_id ROWID := p_rowid;
174:
175: CURSOR get_row_id IS
176: SELECT rowid
177: FROM IGW_BUDGET_PERIODS
178: WHERE proposal_id = p_proposal_id
179: AND version_id = p_version_id
180: AND budget_period_id = p_budget_period_id;
181:

Line 192: delete from igw_budget_periods

188: FETCH get_row_id INTO l_row_id;
189: CLOSE get_row_id;
190: END IF;
191:
192: delete from igw_budget_periods
193: where rowid = l_row_id
194: and record_version_number = p_record_version_number;
195:
196: if (sql%notfound) then

Line 211: END IGW_BUDGET_PERIODS_TBH;

207: RAISE;
208: end DELETE_ROW;
209:
210:
211: END IGW_BUDGET_PERIODS_TBH;