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;
51: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
52: l_last_update_date DATE := SYSDATE;
53:
54: begin
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;
51: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
52: l_last_update_date DATE := SYSDATE;
53:
54: begin
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
199: ,p_attribute15 VARCHAR2
200: ,p_record_version_number NUMBER
201: ,x_return_status OUT NOCOPY VARCHAR2) IS
202:
203: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
204: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
205: l_last_update_date DATE := SYSDATE;
206:
207: l_row_id ROWID := p_rowid;
200: ,p_record_version_number NUMBER
201: ,x_return_status OUT NOCOPY VARCHAR2) IS
202:
203: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
204: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
205: l_last_update_date DATE := SYSDATE;
206:
207: l_row_id ROWID := p_rowid;
208: