APPS.IGW_BUDGETS_TBH dependencies on IGW_BUDGETS

Line 1: PACKAGE BODY IGW_BUDGETS_TBH AS

1: PACKAGE BODY IGW_BUDGETS_TBH AS
2: -- $Header: igwtbvsb.pls 115.7 2002/11/14 18:39:11 vmedikon ship $
3:
4: procedure INSERT_ROW (
5: p_proposal_id NUMBER

Line 46: from igw_budgets

42: ,x_return_status OUT NOCOPY VARCHAR2) IS
43:
44: cursor c_budgets is
45: select rowid
46: from igw_budgets
47: where proposal_id = p_proposal_id
48: and version_id = p_version_id;
49:
50: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

Line 57: insert into igw_budgets(

53:
54: begin
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: insert into igw_budgets(
58: proposal_id
59: ,version_id
60: ,start_date
61: ,end_date

Line 211: FROM IGW_BUDGETS

207: l_row_id ROWID := p_rowid;
208:
209: CURSOR get_row_id IS
210: SELECT rowid
211: FROM IGW_BUDGETS
212: WHERE proposal_id = p_proposal_id
213: AND version_id = p_version_id;
214:
215: begin

Line 224: update igw_budgets

220: FETCH get_row_id INTO l_row_id;
221: CLOSE get_row_id;
222: END IF;
223:
224: update igw_budgets
225: set start_date = p_start_date
226: , end_date = p_end_date
227: , total_cost = p_total_cost
228: , total_direct_cost = p_total_direct_cost

Line 291: FROM IGW_BUDGETS

287: l_row_id ROWID := p_rowid;
288:
289: CURSOR get_row_id IS
290: SELECT rowid
291: FROM IGW_BUDGETS
292: WHERE proposal_id = p_proposal_id
293: AND version_id = p_version_id;
294:
295: begin

Line 305: delete from igw_budgets

301: FETCH get_row_id INTO l_row_id;
302: CLOSE get_row_id;
303: END IF;
304:
305: delete from igw_budgets
306: where rowid = l_row_id
307: and record_version_number = p_record_version_number;
308:
309: if (sql%notfound) then

Line 324: END IGW_BUDGETS_TBH;

320: RAISE;
321: end DELETE_ROW;
322:
323:
324: END IGW_BUDGETS_TBH;