42: BEGIN
43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44:
45: IF (p_from_fk_id <> p_to_fk_id) THEN
46: UPDATE pa_control_items
47: SET owner_id = p_to_fk_id
48: WHERE owner_id = p_from_fk_id;
49:
50: x_to_id := p_from_id;
66: BEGIN
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: IF (p_from_fk_id <> p_to_fk_id) THEN
70: UPDATE pa_control_items
71: SET last_modified_by_id = p_to_fk_id
72: WHERE last_modified_by_id = p_from_fk_id;
73:
74: x_to_id := p_from_id;
90: BEGIN
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: IF (p_from_fk_id <> p_to_fk_id) THEN
94: UPDATE pa_control_items
95: SET closed_by_id = p_to_fk_id
96: WHERE closed_by_id = p_from_fk_id;
97:
98: x_to_id := p_from_id;