APPS.IGW_BUDGET_PERSONNEL_TBH dependencies on IGW_BUDGET_PERSONNEL_DETAILS

Line 27: from igw_budget_personnel_details

23: ,x_return_status OUT NOCOPY VARCHAR2) IS
24:
25: cursor c_budget_personnel is
26: select rowid
27: from igw_budget_personnel_details
28: where budget_personnel_detail_id = p_budget_personnel_detail_id;
29:
30: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
31: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line 37: insert into igw_budget_personnel_details(

33:
34: begin
35: x_return_status := FND_API.G_RET_STS_SUCCESS;
36:
37: insert into igw_budget_personnel_details(
38: proposal_id
39: ,version_id
40: ,budget_period_id
41: ,line_item_id

Line 134: from igw_budget_personnel_details

130: l_row_id ROWID := p_rowid;
131:
132: CURSOR get_row_id IS
133: select rowid
134: from igw_budget_personnel_details
135: where budget_personnel_detail_id = p_budget_personnel_detail_id;
136:
137: begin
138: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 146: update igw_budget_personnel_details

142: FETCH get_row_id INTO l_row_id;
143: CLOSE get_row_id;
144: END IF;
145:
146: update igw_budget_personnel_details
147: set person_id = p_person_id
148: , party_id = p_party_id
149: , start_date = p_start_date
150: , end_date = p_end_date

Line 195: from igw_budget_personnel_details

191: l_row_id ROWID := p_rowid;
192:
193: CURSOR get_row_id IS
194: select rowid
195: from igw_budget_personnel_details
196: where budget_personnel_detail_id = p_budget_personnel_detail_id;
197:
198: begin
199:

Line 208: delete from igw_budget_personnel_details

204: FETCH get_row_id INTO l_row_id;
205: CLOSE get_row_id;
206: END IF;
207:
208: delete from igw_budget_personnel_details
209: where rowid = l_row_id
210: and record_version_number = p_record_version_number;
211:
212: if (sql%notfound) then