DBA Data[Home] [Help]

APPS.AMS_IBA_PL_SITES_B_PKG dependencies on AMS_UTILITY_PVT

Line 149: AMS_UTILITY_PVT.debug_message('table handler : before update site_id = ' || p_site_id );

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),

Line 203: AMS_UTILITY_PVT.debug_message('table handler : before delete of b; site_id = ' || p_site_id || ' object_version_num = ' || p_object_version_number);

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;

Line 213: AMS_UTILITY_PVT.debug_message('table handler : After delete of b; site_id = ' || p_site_id || ' object_version_num = ' || 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