APPS.AMS_ADI_COMMON_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 199

p_update_table_name IN VARCHAR2,
p_upload_batch_id IN NUMBER,
p_use_object_id_as_pk IN VARCHAR2 := FND_API.G_TRUE,
p_commit IN VARCHAR2 := FND_API.G_TRUE,
p_error_records IN OUT  NOCOPY ams_adi_error_rec_t
)
IS
l_count PLS_INTEGER := 0;

Line: 208

l_update_stmt VARCHAR2(4000);

Line: 246

      IF(UPPER(p_update_table_name) = 'AMS_ADI_MEDIA_PLANNER') THEN
        FORALL i  in l_object_ids.first..l_object_ids.last
        update ams_adi_media_planner set operation_status = 'FAILED',error_message = l_error_messages(i)
        where upload_batch_id = p_upload_batch_id and object_id = l_object_ids(i);

Line: 252

        update ams_adi_campaigns_interface set operation_status = 'FAILED',error_message = l_error_messages(i)
        where upload_batch_id = p_upload_batch_id and object_id = l_object_ids(i);

Line: 283

      update ams_adi_campaigns_interface set operation_status = 'FAILED',error_message = l_error_messages(i)
      where upload_batch_id = p_upload_batch_id and object_name = l_object_names(i) and parent_object_id = l_parent_ids(i);

Line: 305

  update ams_adi_campaigns_interface
  set operation_status = 'SUCCESS'
  where upload_batch_id = p_upload_batch_id
  and operation_status = 'NEW';