APPS.AMS_ADI_MEDIA_PLANNER_PVT SQL Statements

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

Line: 120

      SELECT *
      INTO l_interface_rec
      FROM ams_adi_media_planner
      WHERE operation_type = 'IMPORT'
      AND object_type = p_object_type
      AND object_name = p_object_name
      AND parent_type = p_parent_type
      AND parent_id = p_parent_id;

Line: 235

      SELECT activity_metric_id, object_version_number
      FROM ams_act_metrics_all
      WHERE metric_id = p_metric_id
          AND act_metric_used_by_id = p_act_metric_used_by_id
          AND arc_act_metric_used_by = p_arc_act_metric_used_by
      ORDER BY activity_metric_id;

Line: 243

      SELECT display_type FROM ams_metrics_all_b
      WHERE metric_id = p_metric_id;

Line: 401

            Ams_Actmetric_Pvt.update_actmetric (
                  p_api_version                => 1.0,
                  p_init_msg_list              => FND_API.G_FALSE,
                  p_commit                     => FND_API.G_FALSE,
                  p_act_metric_rec             => l_table_of_metrics(i),
                  x_return_status              => l_return_status,
                  x_msg_count                  => l_msg_count,
                  x_msg_data                   => l_msg_data);

Line: 413

                  ': Return Status update_actmetric '||l_return_status);

Line: 506

      SELECT *
      FROM   ams_adi_media_planner
      WHERE upload_batch_id = p_upload_batch_id;

Line: 612

   x_actmetric_table.delete;

Line: 1000

   DELETE FROM ams_adi_media_planner
      WHERE operation_type = 'IMPORT'
      AND object_type = p_object_type
      AND object_name = p_object_name
      AND parent_type = p_parent_type
      AND parent_id = p_parent_id;