25: and location_code = p_location_code
26: and activity_type_code = p_activity_type_code
27: and fiscal_year = p_fiscal_year;
28:
29: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
30: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
31: l_last_update_date DATE := SYSDATE;
32:
33: begin
26: and activity_type_code = p_activity_type_code
27: and fiscal_year = p_fiscal_year;
28:
29: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
30: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
31: l_last_update_date DATE := SYSDATE;
32:
33: begin
34: x_return_status := FND_API.G_RET_STS_SUCCESS;
100: ,p_rowid VARCHAR2
101: ,p_record_version_number NUMBER
102: ,x_return_status OUT NOCOPY VARCHAR2) IS
103:
104: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
105: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
106: l_last_update_date DATE := SYSDATE;
107:
108: l_row_id ROWID := p_rowid;
101: ,p_record_version_number NUMBER
102: ,x_return_status OUT NOCOPY VARCHAR2) IS
103:
104: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
105: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
106: l_last_update_date DATE := SYSDATE;
107:
108: l_row_id ROWID := p_rowid;
109: