DBA Data[Home] [Help]

APPS.AMS_WEB_CITEM_ASSOC_PKG dependencies on AMS_UTILITY_PVT

Line 114: AMS_UTILITY_PVT.debug_message('table handler : before update p_placement_citem_id =' || p_placement_citem_id );

110: IS
111: BEGIN
112:
113: IF (AMS_DEBUG_HIGH_ON) THEN
114: AMS_UTILITY_PVT.debug_message('table handler : before update p_placement_citem_id =' || p_placement_citem_id );
115: END IF;
116:
117:
118: UPDATE ams_web_plce_citem_assoc

Line 154: AMS_UTILITY_PVT.debug_message('table handler : before delete of b; placement_citem_id = ' || p_placement_citem_id || ' object_version_num = ' || p_object_version_number);

150: IS
151: BEGIN
152: IF (AMS_DEBUG_HIGH_ON) THEN
153:
154: AMS_UTILITY_PVT.debug_message('table handler : before delete of b; placement_citem_id = ' || p_placement_citem_id || ' object_version_num = ' || p_object_version_number);
155: END IF;
156: DELETE FROM ams_web_plce_citem_assoc
157: WHERE placement_citem_id = p_placement_citem_id
158: AND object_version_number = p_object_version_number;

Line 164: AMS_UTILITY_PVT.debug_message('table handler : After delete of b; placement_citem_id = ' || p_placement_citem_id || ' object_version_num = ' || p_object_version_number);

160: IF (AMS_DEBUG_HIGH_ON) THEN
161:
162:
163:
164: AMS_UTILITY_PVT.debug_message('table handler : After delete of b; placement_citem_id = ' || p_placement_citem_id || ' object_version_num = ' || p_object_version_number);
165:
166: END IF;
167:
168: If (SQL%NOTFOUND) then