APPS.IGW_BUDGET_DETAILS_TBH dependencies on IGW_BUDGET_DETAILS

Line 1: PACKAGE BODY IGW_BUDGET_DETAILS_TBH AS

1: PACKAGE BODY IGW_BUDGET_DETAILS_TBH AS
2: --$Header: igwtbdtb.pls 115.4 2002/11/14 18:40:00 vmedikon ship $
3:
4: procedure INSERT_ROW (
5: p_proposal_id NUMBER

Line 28: from igw_budget_details

24: ,x_return_status OUT NOCOPY VARCHAR2) IS
25:
26: cursor c_budget_line is
27: select rowid
28: from igw_budget_details
29: where proposal_id = p_proposal_id
30: and version_id = p_version_id
31: and budget_period_id = p_budget_period_id
32: and line_item_id = p_line_item_id;

Line 41: insert into igw_budget_details(

37:
38: begin
39: x_return_status := FND_API.G_RET_STS_SUCCESS;
40:
41: insert into igw_budget_details(
42: proposal_id
43: ,version_id
44: ,budget_period_id
45: ,line_item_id

Line 141: from igw_budget_details

137: l_row_id ROWID := p_rowid;
138:
139: CURSOR get_row_id IS
140: SELECT rowid
141: from igw_budget_details
142: where proposal_id = p_proposal_id
143: and version_id = p_version_id
144: and budget_period_id = p_budget_period_id
145: and line_item_id = p_line_item_id;

Line 156: update igw_budget_details

152: FETCH get_row_id INTO l_row_id;
153: CLOSE get_row_id;
154: END IF;
155:
156: update igw_budget_details
157: set expenditure_type = p_expenditure_type
158: , expenditure_category_flag = p_expenditure_category_flag
159: , budget_category_code = p_budget_category_code
160: , line_item_description = p_line_item_description

Line 204: from igw_budget_details

200: l_row_id ROWID := p_rowid;
201:
202: CURSOR get_row_id IS
203: SELECT rowid
204: from igw_budget_details
205: where proposal_id = p_proposal_id
206: and version_id = p_version_id
207: and budget_period_id = p_budget_period_id
208: and line_item_id = p_line_item_id;

Line 220: delete from igw_budget_details

216: FETCH get_row_id INTO l_row_id;
217: CLOSE get_row_id;
218: END IF;
219:
220: delete from igw_budget_details
221: where rowid = l_row_id
222: and record_version_number = p_record_version_number;
223:
224: if (sql%notfound) then

Line 239: END IGW_BUDGET_DETAILS_TBH;

235: RAISE;
236: end DELETE_ROW;
237:
238:
239: END IGW_BUDGET_DETAILS_TBH;