APPS.AMS_ACTIVATE_EVENTSCHED_PVT SQL Statements

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

Line: 37

   SELECT offr.event_offer_id, offr.object_version_number,offr.event_level,offr.parent_id
   FROM   ams_event_offers_all_b offr, ams_event_headers_all_b hdr
   WHERE  offr.system_status_code = 'AVAILABLE'
   --AND    offr.reg_required_flag = 'Y'
   --AND    offr.reg_start_date <= SYSDATE
   AND    offr.event_header_id = hdr.event_header_id
   AND    hdr.system_status_code = 'ACTIVE';

Line: 47

   SELECT event_offer_id, object_version_number, parent_id,event_level
   FROM   ams_event_offers_all_b
   WHERE  system_status_code = 'AVAILABLE'
   --AND    reg_required_flag = 'Y'
   --AND    reg_start_date <= SYSDATE
   AND    event_header_id IS NULL
   AND    nvl(parent_type, 'RCAM') <> 'CAMP';

Line: 58

   SELECT event_offer_id, object_version_number,event_level
   FROM   ams_event_offers_all_b
   WHERE  system_status_code = 'ACTIVE'
   AND    event_end_date <= SYSDATE
   AND    nvl(parent_type, 'RCAM') <> 'CAMP';*/

Line: 69

   SELECT event_offer_id, object_version_number,event_level
   FROM   ams_event_offers_all_b
   WHERE  system_status_code = 'ACTIVE'
   AND    event_end_date <= l_conv_sysdate
   AND    nvl(parent_type, 'RCAM') <> 'CAMP';

Line: 77

   SELECT user_status_id
   FROM   ams_user_statuses_b
   WHERE  system_status_type = 'AMS_EVENT_STATUS'
   AND    system_status_code = l_status_code
   AND    default_flag = 'Y'
   AND    enabled_flag = 'Y' ;

Line: 86

   SELECT user_status_id
   FROM   ams_campaigns_all_b
   WHERE  campaign_id = l_event_offer_id;

Line: 179

     /* UPDATE ams_event_offers_all_b
      SET system_status_code = 'ACTIVE',
        last_status_date = SYSDATE ,
        user_status_id     = l_status_id,
        object_version_number = l_obj_version + 1
      WHERE  event_offer_id = l_schedule_id ;*/

Line: 208

	 AMS_EventOffer_PVT.update_event_offer (
         p_api_version  => 1.0,
         p_init_msg_list   => FND_API.G_FALSE,
         p_commit          => FND_API.G_FALSE,
         p_validation_level   =>  FND_API.g_valid_level_full,

         p_evo_rec       => l_evo_rec_eveo,

         x_return_status   => x_return_status,
         x_msg_count       => x_msg_count,
         x_msg_data        => x_msg_data
        );

Line: 270

       /*  UPDATE ams_event_offers_all_b
         SET system_status_code = 'ACTIVE',
           last_status_date = SYSDATE ,
           user_status_id     = l_status_id,
           object_version_number = l_obj_version + 1
         WHERE  event_offer_id = l_schedule_id ;*/

Line: 287

	 AMS_EventOffer_PVT.update_event_offer (
         p_api_version  => 1.0,
         p_init_msg_list   => FND_API.G_FALSE,
         p_commit          => FND_API.G_FALSE,
         p_validation_level   =>  FND_API.g_valid_level_full,

         p_evo_rec       => l_evo_rec_oneoff,

         x_return_status   => x_return_status,
         x_msg_count       => x_msg_count,
         x_msg_data        => x_msg_data
        );

Line: 376

       AMS_EventOffer_PVT.update_event_offer (
         p_api_version  => 1.0,
         p_init_msg_list   => FND_API.G_FALSE,
         p_commit          => FND_API.G_FALSE,
         p_validation_level   =>  FND_API.g_valid_level_full,

         p_evo_rec       => l_evo_rec,

         x_return_status   => x_return_status,
         x_msg_count       => x_msg_count,
         x_msg_data        => x_msg_data
        );