145: IS
146: BEGIN
147: IF (AMS_DEBUG_HIGH_ON) THEN
148:
149: AMS_UTILITY_PVT.debug_message('table handler : before update site_id = ' || p_site_id );
150: END IF;
151: UPDATE ams_iba_pl_sites_b
152: SET
153: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
199: IS
200: BEGIN
201: IF (AMS_DEBUG_HIGH_ON) THEN
202:
203: AMS_UTILITY_PVT.debug_message('table handler : before delete of b; site_id = ' || p_site_id || ' object_version_num = ' || p_object_version_number);
204: END IF;
205: DELETE FROM ams_iba_pl_sites_b
206: WHERE site_id = p_site_id
207: AND object_version_number = p_object_version_number;
209: IF (AMS_DEBUG_HIGH_ON) THEN
210:
211:
212:
213: AMS_UTILITY_PVT.debug_message('table handler : After delete of b; site_id = ' || p_site_id || ' object_version_num = ' || p_object_version_number);
214:
215: END IF;
216:
217: If (SQL%NOTFOUND) then