DBA Data[Home] [Help]

APPS.AMS_ADI_COMMON_PVT dependencies on AMS_ADI_MEDIA_PLANNER

Line 246: IF(UPPER(p_update_table_name) = 'AMS_ADI_MEDIA_PLANNER') THEN

242:
243: END LOOP;
244:
245: IF (l_count > 0) THEN
246: IF(UPPER(p_update_table_name) = 'AMS_ADI_MEDIA_PLANNER') THEN
247: FORALL i in l_object_ids.first..l_object_ids.last
248: update ams_adi_media_planner set operation_status = 'FAILED',error_message = l_error_messages(i)
249: where upload_batch_id = p_upload_batch_id and object_id = l_object_ids(i);
250: ELSE

Line 248: update ams_adi_media_planner set operation_status = 'FAILED',error_message = l_error_messages(i)

244:
245: IF (l_count > 0) THEN
246: IF(UPPER(p_update_table_name) = 'AMS_ADI_MEDIA_PLANNER') THEN
247: FORALL i in l_object_ids.first..l_object_ids.last
248: update ams_adi_media_planner set operation_status = 'FAILED',error_message = l_error_messages(i)
249: where upload_batch_id = p_upload_batch_id and object_id = l_object_ids(i);
250: ELSE
251: FORALL i in l_object_ids.first..l_object_ids.last
252: update ams_adi_campaigns_interface set operation_status = 'FAILED',error_message = l_error_messages(i)