APPS.AMS_COPYACTIVITIES_PVT SQL Statements

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

Line: 91

      AMS_CPYutility_pvt.insert_log_mesg(x_transaction_id);

Line: 127

         AMS_CPYutility_pvt.insert_log_mesg(x_transaction_id);

Line: 157

         AMS_CPYutility_pvt.insert_log_mesg(x_transaction_id);

Line: 194

      AMS_CPYutility_pvt.insert_log_mesg(x_transaction_id);

Line: 263

   SELECT * FROM ams_campaigns_vl
   WHERE campaign_id = camp_id ;

Line: 604

                    ams_copyelements_pvt.copy_selected_schedule
                                    ( p_old_camp_id    =>   p_source_object_id,
                                      p_new_camp_id    =>   l_new_campaign_id,
                                      p_old_schedule_id=>   l_tmp_schedule_id,
                                      p_new_start_date =>   l_camp_rec.actual_exec_start_date,
                                      p_new_end_date   =>   l_camp_rec.actual_exec_end_date,
                                      x_return_status  =>   l_return_status,
                                      x_msg_count      =>   l_msg_count,
                                      x_msg_data       =>   l_msg_data );

Line: 837

         SELECT COUNT(*)   --deliverable_name
           FROM ams_deliverables_vl
          WHERE deliverable_name = l_deliv_name;

Line: 885

         SELECT *
           INTO l_deliv_rec
           FROM ams_deliverables_vl
         WHERE  deliverable_id = p_src_deliv_id;

Line: 1192

         SELECT   event_offer_id
         FROM     ams_event_offers_vl
         WHERE  parent_event_offer_id = p_src_eveo_id;

Line: 1202

	SELECT   COUNT(*)
	FROM     ams_event_offers_all_tl
	WHERE  event_offer_name = l_eveo_name;

Line: 1209

         SELECT   custom_setup_id
         FROM     ams_object_attributes
         WHERE  object_id = p_src_eveo_id
            AND object_type = 'EVEO';

Line: 1257

         SELECT   *
         INTO     l_eventoffer_rec
         FROM     ams_event_offers_vl
         WHERE  event_offer_id = p_src_eveo_id;

Line: 1697

      SELECT event_header_id
        FROM ams_event_headers_vl
       WHERE parent_event_header_id = p_src_eveh_id;

Line: 1706

	SELECT COUNT(*)
	FROM ams_event_headers_all_tl
	WHERE event_header_name = l_eveh_name ;

Line: 1712

      SELECT event_offer_id
        FROM ams_event_offers_vl
       WHERE event_header_id = p_src_eveh_id;

Line: 1717

      SELECT custom_setup_id
        FROM ams_object_attributes
       WHERE object_id = p_src_eveh_id
         AND object_type = 'EVEH';

Line: 1767

         SELECT *
           INTO l_eventheader_rec
           FROM ams_event_headers_vl
          WHERE event_header_id = p_src_eveh_id;

Line: 2184

   SELECT *
     FROM ams_campaigns_vl
    WHERE campaign_id = p_src_camp_id;

Line: 2189

   SELECT user_status_id
     FROM ams_user_statuses_b
    WHERE system_status_code = 'NEW'
      AND enabled_flag = 'Y'
      AND sysdate between start_date_active AND NVL(end_date_active,sysdate)
      AND default_flag = 'Y'
      AND system_status_type = 'AMS_CAMPAIGN_STATUS';

Line: 2199

   SELECT MAX(version_no)
     FROM ams_campaigns_vl
    WHERE campaign_name = l_campaign_name;

Line: 2204

   SELECT schedule_id
     FROM ams_campaign_schedules_b
    WHERE campaign_id = src_campaign_id;

Line: 2209

   SELECT task_id
     FROM jtf_tasks_b
    WHERE source_object_type_code = 'AMS_CAMP'
      AND source_object_id = p_src_camp_id;

Line: 2215

   SELECT campaign_id,
          campaign_name
     FROM ams_campaigns_vl
    WHERE parent_campaign_id = p_src_camp_id;

Line: 2731

   SELECT related_event_id
   FROM   ams_campaign_schedules_b
   WHERE  schedule_id = p_sch_id;