22: select rowid
23: from igw_award_budgets
24: where award_budget_id = p_award_budget_id;
25:
26: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
27: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
28: l_last_update_date DATE := SYSDATE;
29:
30: begin
23: from igw_award_budgets
24: where award_budget_id = p_award_budget_id;
25:
26: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
27: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
28: l_last_update_date DATE := SYSDATE;
29:
30: begin
31: x_return_status := FND_API.G_RET_STS_SUCCESS;
106: ,p_transferred_flag VARCHAR2
107: ,p_record_version_number NUMBER
108: ,x_return_status OUT NOCOPY VARCHAR2) IS
109:
110: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
111: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
112: l_last_update_date DATE := SYSDATE;
113:
114: l_row_id ROWID := p_rowid;
107: ,p_record_version_number NUMBER
108: ,x_return_status OUT NOCOPY VARCHAR2) IS
109:
110: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
111: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
112: l_last_update_date DATE := SYSDATE;
113:
114: l_row_id ROWID := p_rowid;
115: