70: IF (c_sites%FOUND) THEN
71: UPDATE rrs_sites_b
72: SET site_party_id = p_to_fk_id,
73: last_update_date = SYSDATE,
74: last_updated_by = FND_GLOBAL.user_id,
75: last_update_login = FND_GLOBAL.user_id
76: WHERE site_party_id = p_from_fk_id;
77: END IF;
78: CLOSE c_sites;
71: UPDATE rrs_sites_b
72: SET site_party_id = p_to_fk_id,
73: last_update_date = SYSDATE,
74: last_updated_by = FND_GLOBAL.user_id,
75: last_update_login = FND_GLOBAL.user_id
76: WHERE site_party_id = p_from_fk_id;
77: END IF;
78: CLOSE c_sites;
79:
135: IF ( get_sites_for_update%FOUND ) THEN
136: UPDATE rrs_sites_b
137: SET le_party_id = p_to_fk_id,
138: last_update_date = SYSDATE,
139: last_updated_by = FND_GLOBAL.user_id,
140: last_update_login = FND_GLOBAL.user_id
141: WHERE le_party_id = p_from_fk_id;
142: END IF;
143: CLOSE get_sites_for_update;
136: UPDATE rrs_sites_b
137: SET le_party_id = p_to_fk_id,
138: last_update_date = SYSDATE,
139: last_updated_by = FND_GLOBAL.user_id,
140: last_update_login = FND_GLOBAL.user_id
141: WHERE le_party_id = p_from_fk_id;
142: END IF;
143: CLOSE get_sites_for_update;
144: END IF;