APPS.AMS_SCHEDULER_PVT SQL Statements

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

Line: 50

   IS SELECT 1
      FROM   ams_act_lists la
      WHERE  list_act_type = 'TARGET'
      AND    list_used_by = p_obj_type --'CSCH'
      AND    list_used_by_id = p_schedule_id
      AND    EXISTS (SELECT *
                     FROM   ams_list_entries le
                     WHERE  le.list_header_id = la.list_header_id) ;

Line: 201

        SELECT *
        FROM ams_campaign_schedules_vl
        WHERE schedule_id = p_orig_sched_id;

Line: 208

   SELECT 1
     FROM ams_media_channels
    WHERE channel_id = p_medium_id
      AND media_id = p_activity_id
      AND ACTIVE_TO_DATE > SYSDATE;

Line: 215

   SELECT user_status_id
   FROM   ams_user_statuses_b
   WHERE  system_status_type = 'AMS_CAMPAIGN_SCHEDULE_STATUS'
   AND    system_status_code = p_status_code
   AND    default_flag = 'Y'
   AND    enabled_flag = 'Y';

Line: 224

   select schedule_id
   from ams_campaign_schedules_b
   where creation_date = (select max(creation_date)
                               from ams_campaign_schedules_b
                              where nvl(orig_csch_id, schedule_id) = p_schedule_id);

Line: 241

   SELECT content_item_id
     FROM ibc_associations
    WHERE association_type_code  = 'AMS_CSCH'
    AND ASSOCIATED_OBJECT_VAL1 = to_char(p_parent_sched_id);  -- fix for bug # 4145845

Line: 578

     UPDATE AMS_CAMPAIGN_SCHEDULES_B
        SET STATUS_CODE = 'AVAILABLE' ,
            status_date = sysdate,
            user_status_id = l_def_avail_status
      WHERE SCHEDULE_ID = l_new_sched_id;

Line: 622

       SELECT ams_scheduler_s.NEXTVAL
       FROM dual;

Line: 634

   AMS_SCHEDULER_B_PKG.Insert_Row(
          px_scheduler_id  => l_scheduler_id,
          p_created_by  => FND_GLOBAL.USER_ID,
	  p_creation_date  => SYSDATE,
          p_last_updated_by  => FND_GLOBAL.USER_ID,
          p_last_update_date  => SYSDATE,
          p_last_update_login  => FND_GLOBAL.LOGIN_ID,
          px_object_version_number   => l_object_version_number,
          p_object_type    => p_obj_type,
          p_object_id    => p_obj_id,
          p_frequency    => p_freq,
          p_frequency_type    => p_freq_type
	  );