APPS.AMS_ADI_COMMON_PVT dependencies on AMS_ADI_CAMPAIGNS_INTERFACE

Line 252: update ams_adi_campaigns_interface set operation_status = 'FAILED',error_message = l_error_messages(i)

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)
253: where upload_batch_id = p_upload_batch_id and object_id = l_object_ids(i);
254: END IF;
255: END IF;
256:

Line 283: update ams_adi_campaigns_interface set operation_status = 'FAILED',error_message = l_error_messages(i)

279: END LOOP;
280:
281: IF (l_count > 0) THEN
282: FORALL i in l_object_names.first..l_object_names.last
283: update ams_adi_campaigns_interface set operation_status = 'FAILED',error_message = l_error_messages(i)
284: where upload_batch_id = p_upload_batch_id and object_name = l_object_names(i) and parent_object_id = l_parent_ids(i);
285: END IF;
286: END IF;
287: END complete_batch;

Line 305: update ams_adi_campaigns_interface

301: p_upload_batch_id IN NUMBER := 0
302: )
303: IS
304: BEGIN
305: update ams_adi_campaigns_interface
306: set operation_status = 'SUCCESS'
307: where upload_batch_id = p_upload_batch_id
308: and operation_status = 'NEW';
309: