15: BEGIN
16: x_return_status := FND_API.G_RET_STS_SUCCESS;
17:
18: IF (p_from_fk_id <> p_to_fk_id) THEN
19: UPDATE pa_control_items
20: SET owner_id = p_to_fk_id
21: WHERE owner_id = p_from_fk_id;
22:
23: x_to_id := p_from_id;
39: BEGIN
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41:
42: IF (p_from_fk_id <> p_to_fk_id) THEN
43: UPDATE pa_control_items
44: SET last_modified_by_id = p_to_fk_id
45: WHERE last_modified_by_id = p_from_fk_id;
46:
47: x_to_id := p_from_id;
63: BEGIN
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66: IF (p_from_fk_id <> p_to_fk_id) THEN
67: UPDATE pa_control_items
68: SET closed_by_id = p_to_fk_id
69: WHERE closed_by_id = p_from_fk_id;
70:
71: x_to_id := p_from_id;