24: where proposal_id = p_proposal_id
25: and version_id = p_version_id
26: and budget_period_id = p_budget_period_id;
27:
28: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
29: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
30: l_last_update_date DATE := SYSDATE;
31:
32: begin
25: and version_id = p_version_id
26: and budget_period_id = p_budget_period_id;
27:
28: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
29: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
30: l_last_update_date DATE := SYSDATE;
31:
32: begin
33: x_return_status := FND_API.G_RET_STS_SUCCESS;
108: ,p_program_income_source VARCHAR2
109: ,p_record_version_number NUMBER
110: ,x_return_status OUT NOCOPY VARCHAR2) IS
111:
112: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
113: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
114: l_last_update_date DATE := SYSDATE;
115:
116: l_row_id ROWID := p_rowid;
109: ,p_record_version_number NUMBER
110: ,x_return_status OUT NOCOPY VARCHAR2) IS
111:
112: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
113: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
114: l_last_update_date DATE := SYSDATE;
115:
116: l_row_id ROWID := p_rowid;
117: