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;
32: l_last_update_date DATE := SYSDATE;
33:
34: begin
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;
32: l_last_update_date DATE := SYSDATE;
33:
34: begin
35: x_return_status := FND_API.G_RET_STS_SUCCESS;
122: ,p_underrecovery_amount NUMBER
123: ,p_record_version_number NUMBER
124: ,x_return_status OUT NOCOPY VARCHAR2)IS
125:
126: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
127: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
128: l_last_update_date DATE := SYSDATE;
129:
130: l_row_id ROWID := p_rowid;
123: ,p_record_version_number NUMBER
124: ,x_return_status OUT NOCOPY VARCHAR2)IS
125:
126: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
127: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
128: l_last_update_date DATE := SYSDATE;
129:
130: l_row_id ROWID := p_rowid;
131: