APPS.IGW_BUDGETS_PKG dependencies on IGW_BUDGETS

Line 1: PACKAGE BODY IGW_BUDGETS_PKG AS

1: PACKAGE BODY IGW_BUDGETS_PKG AS
2: -- $Header: igwbuthb.pls 115.10 2002/03/28 19:13:09 pkm ship $
3: procedure INSERT_ROW (
4: x_rowid IN OUT VARCHAR2
5: ,p_proposal_id NUMBER

Line 39: from igw_budgets

35: ,p_attribute14 VARCHAR2
36: ,p_attribute15 VARCHAR2) IS
37: cursor c_budgets is
38: select rowid
39: from igw_budgets
40: where proposal_id = p_proposal_id;
41:
42: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
43: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line 48: insert into igw_budgets(

44: l_last_update_date DATE := SYSDATE;
45: begin
46:
47:
48: insert into igw_budgets(
49: proposal_id
50: ,version_id
51: ,start_date
52: ,end_date

Line 170: from igw_budgets

166: ,p_attribute14 VARCHAR2
167: ,p_attribute15 VARCHAR2) IS
168: cursor c_budgets is
169: select *
170: from igw_budgets
171: where rowid = x_rowid
172: for update of proposal_id nowait;
173:
174: tlinfo c_budgets%rowtype;

Line 318: update igw_budgets

314: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
315: l_last_update_date DATE := SYSDATE;
316: begin
317:
318: update igw_budgets
319: set start_date = p_start_date
320: , end_date = p_end_date
321: , total_cost = p_total_cost
322: , total_direct_cost = p_total_direct_cost

Line 357: END IGW_BUDGETS_PKG;

353: raise no_data_found;
354: end if;
355: end update_row;
356:
357: END IGW_BUDGETS_PKG;