APPS.AMS_EVHRULES_PVT SQL Statements

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

Line: 30

      SELECT user_id
      FROM   ams_jtf_rs_emp_v
      WHERE  resource_id = p_resource_id;

Line: 65

      SELECT event_offer_id, object_version_number, system_status_code, event_object_type
      FROM ams_event_offers_all_b
      WHERE  event_header_id = p_eveh_id
      AND system_status_code <> 'COMPLETED' ;

Line: 85

         UPDATE ams_event_offers_all_b
         SET    system_status_code = 'COMPLETED',
                last_status_date = SYSDATE,
                user_status_id = l_status_id,
                object_version_number = object_version_number + 1
         WHERE  event_offer_id = l_event_offer_id
         AND    object_version_number = l_obj_version ;

Line: 129

   SELECT system_status_code
     FROM ams_user_statuses_vl
    WHERE user_status_id = p_user_status_id
      AND system_status_type = 'AMS_EVENT_STATUS';

Line: 152

PROCEDURE check_evh_update(
   p_evh_rec       IN  AMS_EventHeader_PVT.evh_rec_type,
   x_return_status  OUT NOCOPY VARCHAR2
)
IS
  CURSOR c_evh IS
   SELECT *
     FROM ams_event_headers_vl
    WHERE event_header_id = p_evh_rec.event_header_id;

Line: 163

   SELECT 1
     FROM ams_source_codes
    WHERE source_code = p_evh_rec.source_code
    AND active_flag = 'Y';

Line: 215

         AMS_Utility_PVT.error_message('AMS_EVH_UPDATE_EVH_NAME');

Line: 223

         AMS_Utility_PVT.error_message('AMS_EVH_UPDATE_START_DATE');

Line: 231

         AMS_Utility_PVT.error_message('AMS_EVH_UPDATE_END_DATE');

Line: 261

        AMS_Utility_PVT.error_message('AMS_EVH_UPDATE_SOURCE_CODE');

Line: 319

END check_evh_update;

Line: 335

   SELECT 1
     FROM ams_campaigns_vl
    WHERE campaign_id = p_fund_source_id;

Line: 339

   SELECT 1
     FROM ams_event_headers_vl
    WHERE event_header_id = p_fund_source_id;

Line: 343

   SELECT 1
     FROM ams_event_offers_vl
    WHERE event_offer_id = p_fund_source_id;

Line: 347

   SELECT 1
     FROM ams_event_offers_vl
    WHERE event_offer_id = p_fund_source_id;

Line: 429

   SELECT 1
   FROM   DUAL
   WHERE  EXISTS(
             SELECT 1
             FROM   gl_periods_v
             WHERE  period_set_name = p_evh_calendar
          );

Line: 438

   SELECT start_date, end_date
   FROM   gl_periods_v
   WHERE  period_set_name = p_evh_calendar
   AND    period_name = p_start_period_name;

Line: 444

   SELECT start_date, end_date
   FROM   gl_periods_v
   WHERE  period_set_name = p_evh_calendar
   AND    period_name = p_end_period_name;

Line: 534

   SELECT ams_source_codes_s.NEXTVAL
     FROM DUAL;

Line: 540

   INSERT INTO ams_source_codes(
      source_code_id,
      last_update_date,
      last_updated_by,
      creation_date,
      created_by,
      last_update_login,
      object_version_number,
      source_code,
      source_code_for_id,
      arc_source_code_for
   )
   VALUES(
      l_pk,
      SYSDATE,
      FND_GLOBAL.user_id,
      SYSDATE,
      FND_GLOBAL.user_id,
      FND_GLOBAL.conc_login_id,
      1,  -- object_version_number
      p_source_code,
      p_object_id,
      p_arc_object
   );

Line: 573

PROCEDURE update_evh_source_code(
   p_evh_id      IN  NUMBER,
   p_source_code      IN  VARCHAR2,
   p_global_flag      IN  VARCHAR2,
   x_source_code      OUT NOCOPY VARCHAR2,
   x_return_status    OUT NOCOPY VARCHAR2
)
IS

   l_msg_data  VARCHAR2(2000);

Line: 591

   SELECT global_flag, source_code
   FROM   ams_event_headers_vl
   WHERE  event_header_id = p_evh_id;

Line: 596

   SELECT source_code_id
   FROM   ams_source_codes
   WHERE  source_code = x_source_code
   AND    active_flag = 'Y';

Line: 602

   SELECT SETUP_TYPE_ID
   FROM AMS_EVENT_HEADERS_ALL_B
   WHERE EVENT_HEADER_ID = p_evh_id;

Line: 607

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

Line: 691

END update_evh_source_code;

Line: 700

PROCEDURE update_evo_source_code(
   p_evo_id      IN  NUMBER,
   p_source_code      IN  VARCHAR2,
   p_global_flag      IN  VARCHAR2,
   x_source_code      OUT NOCOPY VARCHAR2,
   x_return_status    OUT NOCOPY VARCHAR2
)
IS

   l_msg_data  VARCHAR2(2000);

Line: 718

   SELECT global_flag, source_code
   FROM   ams_event_offers_vl
   WHERE  event_offer_id = p_evo_id;

Line: 723

   SELECT source_code_id
   FROM   ams_source_codes
   WHERE  source_code = x_source_code
   AND    active_flag = 'Y';

Line: 729

   SELECT SETUP_TYPE_ID
   FROM AMS_EVENT_OFFERS_ALL_B
   WHERE EVENT_HEADER_ID = p_evo_id;

Line: 734

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

Line: 821

END update_evo_source_code;

Line: 830

PROCEDURE update_eone_source_code(
   p_evo_id      IN  NUMBER,
   p_source_code      IN  VARCHAR2,
   p_global_flag      IN  VARCHAR2,
   x_source_code      OUT NOCOPY VARCHAR2,
   x_return_status    OUT NOCOPY VARCHAR2
)
IS

   l_msg_data  VARCHAR2(2000);

Line: 848

   SELECT global_flag, source_code
   FROM   ams_event_offers_vl
   WHERE  event_offer_id = p_evo_id;

Line: 853

   SELECT source_code_id
   FROM   ams_source_codes
   WHERE  source_code = x_source_code
   AND    active_flag = 'Y';

Line: 859

   SELECT SETUP_TYPE_ID
   FROM AMS_EVENT_OFFERS_ALL_B
   WHERE EVENT_HEADER_ID = p_evo_id;

Line: 864

   SELECT custom_setup_id
   FROM   ams_object_attributes
   WHERE  object_type = 'EONE'
   AND    object_id = p_evo_id;

Line: 951

END update_eone_source_code;

Line: 964

PROCEDURE update_event_status(
   p_event_id    IN  NUMBER,
   p_event_activity_type  IN VARCHAR2,
   p_user_status_id       IN NUMBER,
   p_fund_amount_tc       IN NUMBER,
   p_currency_code_tc     IN VARCHAR2
)
IS

   l_old_status_id     NUMBER;

Line: 996

   SELECT user_status_id, object_version_number, setup_type_id, program_id
   FROM   ams_event_headers_all_b
   WHERE  event_header_id = l_event_header_id;

Line: 1002

   SELECT user_status_id, object_version_number, setup_type_id, event_header_id, system_status_code
   FROM   ams_event_offers_all_b
   WHERE  event_offer_id = p_event_id;

Line: 1008

   SELECT user_status_id, object_version_number, setup_type_id, parent_id, system_status_code
   FROM   ams_event_offers_all_b
   WHERE  event_offer_id = p_event_id;

Line: 1014

   SELECT user_status_id
   FROM   ams_campaigns_all_b
   WHERE  campaign_id = l_event_offer_id;

Line: 1021

   SELECT 1
     FROM DUAL
    WHERE EXISTS(
          SELECT 1
            FROM ozf_act_budgets --anchaudh: changed call from ams_act_budgets to ozf_act_budgets : bug#3453430
           WHERE act_budget_used_by_id = p_event_id
             AND arc_act_budget_used_by = p_event_activity_type);

Line: 1106

       user again selects new as user status .
     */

    IF l_old_status_id = p_user_status_id THEN
      RETURN;

Line: 1235

     /*  UPDATE ams_event_headers_all_b
       SET  user_status_id = l_new_status_id,
         system_status_code = AMS_Utility_PVT.get_system_status_code(l_new_status_id),
         last_status_date = SYSDATE
       WHERE  event_header_id = p_event_id; */

Line: 1241

       AMS_EvhRules_PVT.Update_Event_Header_Status(p_event_header_id => p_event_id,
                                 p_new_status_id => l_new_status_id,
                                 p_new_status_code => AMS_Utility_PVT.get_system_status_code(l_new_status_id)
                                 );

Line: 1247

         UPDATE ams_event_offers_all_b
         SET  user_status_id = l_new_status_id,
              system_status_code = AMS_Utility_PVT.get_system_status_code(l_new_status_id),
              last_status_date = SYSDATE
         WHERE  event_offer_id = p_event_id;

Line: 1264

         UPDATE ams_event_offers_all_b
         SET  user_status_id = l_new_status_id,
              system_status_code = AMS_Utility_PVT.get_system_status_code(l_new_status_id),
              last_status_date = SYSDATE
         WHERE  event_offer_id = p_event_id;

Line: 1302

END update_event_status;

Line: 1334

   l_loaded_rows NUMBER;               --holds the count of rows that were inserted in the import interface table for this batch.

Line: 1339

   SELECT as_sl_imp_batch_s.NEXTVAL
     FROM DUAL;

Line: 1343

   SELECT source_code
     FROM ams_event_offers_all_b
    WHERE event_offer_id = event_id_in;

Line: 1348

   SELECT create_registrant_lead_flag
     FROM ams_event_offers_all_b
    WHERE event_offer_id = event_id_in;

Line: 1353

   SELECT create_attendant_lead_flag
     FROM ams_event_offers_all_b
    WHERE event_offer_id = event_id_in;

Line: 1361

   SELECT source_code, create_registrant_lead_flag, create_attendant_lead_flag
     FROM ams_event_offers_all_b
    WHERE event_offer_id = event_id_in;

Line: 1368

   SELECT registrant_party_id
          , registrant_contact_id
          , attendant_party_id
          , attendant_contact_id
     FROM ams_event_registrations
    WHERE event_offer_id = event_id_in
      AND system_status_code = 'REGISTERED'  -- In future when we kill the REGISTERED status and leave ENROLLED, change this to ENROLLED.
      AND active_flag = 'Y';

Line: 1380

   SELECT registrant_party_id
          , registrant_contact_id
          , attendant_party_id
          , attendant_contact_id
     FROM ams_event_registrations
    WHERE event_offer_id = event_id_in
      AND system_status_code = 'REGISTERED'  -- In future when we kill the REGISTERED status and leave ENROLLED, change this to ENROLLED.
      AND attended_flag = 'Y'
      AND active_flag = 'Y';

Line: 1393

      SELECT COUNT(*)
        FROM as_import_interface
       WHERE batch_id = batch_id_in;

Line: 1399

   SELECT subject_id  -- person id
     FROM hz_relationships -- anchaudh: bug fix 3764927.
    WHERE party_id = rel_party_id_in
      AND directional_flag = 'F';

Line: 1408

   SELECT reg.registrant_party_id party_id
          , reg.registrant_contact_id contact_id
     FROM ams_event_registrations reg,
          ams_event_offers_all_b event
    WHERE reg.event_offer_id = event_id_in
      AND reg.system_status_code = 'REGISTERED'  -- In future when we kill the REGISTERED status and leave ENROLLED, change this to ENROLLED.
      AND reg.active_flag = 'Y'
      AND event.event_offer_id = reg.event_offer_id
      AND event.create_registrant_lead_flag = 'Y'
                  UNION
   SELECT reg.attendant_party_id party_id
          , reg.attendant_contact_id contact_id
     FROM ams_event_registrations reg,
          ams_event_offers_all_b event
    WHERE reg.event_offer_id = event_id_in
      AND reg.system_status_code = 'REGISTERED'  -- In future when we kill the REGISTERED status and leave ENROLLED, change this to ENROLLED.
      AND reg.active_flag = 'Y'
      AND reg.attended_flag = 'Y'
      AND event.event_offer_id = reg.event_offer_id
      AND event.create_attendant_lead_flag = 'Y';

Line: 1501

          insert_lead_rec(
                 p_party_id        => l_registrant_for_lead_rec.registrant_party_id
                  ,p_lit_batch_id    => l_lit_batch_id
                  ,p_event_id        => p_event_id
                  ,p_source_code     => l_evnt_sched_src_cd);

Line: 1508

          insert_lead_rec(
                 p_party_id        => l_registrant_for_lead_rec.registrant_party_id
                  ,p_lit_batch_id    => l_lit_batch_id
                  ,p_event_id        => p_event_id
                  ,p_source_code     => l_evnt_sched_src_cd
               ,p_contact_party_id => l_registrant_for_lead_rec.registrant_contact_id);

Line: 1547

           insert_lead_rec(
                 p_party_id         => l_attendant_for_lead_rec.attendant_party_id
                  ,p_lit_batch_id    => l_lit_batch_id
                  ,p_event_id        => p_event_id
                  ,p_source_code     => l_evnt_sched_src_cd);

Line: 1553

            insert_lead_rec(
                 p_party_id         => l_attendant_for_lead_rec.attendant_party_id
                  ,p_lit_batch_id    => l_lit_batch_id
                  ,p_event_id        => p_event_id
                  ,p_source_code     => l_evnt_sched_src_cd
               ,p_contact_party_id => l_attendant_for_lead_rec.attendant_contact_id);

Line: 1578

                    insert_lead_rec(
                          p_party_id         => l_reg_att_for_lead_rec.party_id
                           ,p_lit_batch_id    => l_lit_batch_id
                           ,p_event_id        => p_event_id
                           ,p_source_code     => l_evnt_sched_src_cd);

Line: 1590

                     insert_lead_rec(
                            p_party_id         => l_reg_att_for_lead_rec.party_id
                           ,p_lit_batch_id    => l_lit_batch_id
                           ,p_event_id        => p_event_id
                           ,p_source_code     => l_evnt_sched_src_cd
                          -- ,p_contact_party_id => l_reg_att_for_lead_rec.contact_id);

Line: 1662

PROCEDURE insert_lead_rec(
    p_party_id             IN  NUMBER
   ,p_lit_batch_id        IN  NUMBER
   ,p_event_id            IN  NUMBER
   ,p_source_code         IN  VARCHAR2
   ,p_contact_party_id     IN NUMBER := NULL
)
IS
   l_seq NUMBER;                     --Next value for the primary key in the import lead interface table.

Line: 1675

   SELECT as_import_interface_s.NEXTVAL
     FROM DUAL;

Line: 1680

   SELECT party_type
     FROM hz_parties
    WHERE party_id = party_id_in;

Line: 1686

   SELECT party_site_id
     FROM hz_party_sites
    WHERE party_id = party_id_in
      AND identifying_address_flag = 'Y';

Line: 1713

   INSERT INTO as_import_interface
   (
    IMPORT_INTERFACE_ID              --NOT NULL NUMBER
   , LAST_UPDATE_DATE                --NOT NULL DATE
   , LAST_UPDATED_BY                 --NOT NULL NUMBER
   , CREATION_DATE                   --NOT NULL DATE
   , CREATED_BY                      --NOT NULL NUMBER
   , LAST_UPDATE_LOGIN               --NOT NULL NUMBER
   , LOAD_TYPE                       --         VARCHAR2(20)
   , LOAD_DATE                       --NOT NULL DATE
   , PROMOTION_CODE                  --         VARCHAR2(50)
   , STATUS_CODE                     --         VARCHAR2(30)
   , LEAD_NOTE                       --         VARCHAR2(2000)
   , SOURCE_SYSTEM                   --         VARCHAR2(30)
   , PARTY_TYPE                      --         VARCHAR2(30)
   , BATCH_ID                        --         NUMBER(15)
   , PARTY_ID                        --         NUMBER(15)
   , PARTY_SITE_ID                   --         NUMBER(15)
   ,load_status
   ,contact_party_id
   )
   VALUES
   (
    l_seq                                          --IMPORT_INTERFACE_ID   --NOT NULL NUMBER
   , SYSDATE                                       --LAST_UPDATE_DATE      --NOT NULL DATE
   , FND_GLOBAL.user_id                            --LAST_UPDATED_BY       --NOT NULL NUMBER
   , SYSDATE                                       --CREATION_DATE         --NOT NULL DATE
   , FND_GLOBAL.user_id                            --CREATED_BY            --NOT NULL NUMBER
   , FND_GLOBAL.conc_login_id                      --LAST_UPDATE_LOGIN     --NOT NULL NUMBER
   , 'LEAD_LOAD'                                   --LOAD_TYPE             --         VARCHAR2(20)
   , SYSDATE                                       --LOAD_DATE             --NOT NULL DATE
   , p_source_code                                 --PROMOTION_CODE        --         VARCHAR2(50)
   , FND_PROFILE.Value('AS_DEFAULT_LEAD_STATUS')   --STATUS_CODE           --         VARCHAR2(30)
   , 'Event Registrant is created as a lead.'      --LEAD_NOTE             --         VARCHAR2(2000)
   , 'MARKETING'                                   --SOURCE_SYSTEM         --         VARCHAR2(30)
   , l_party_type                                  --PARTY_TYPE            --         VARCHAR2(30)
   , p_lit_batch_id                                --BATCH_ID              --         NUMBER(15)
   , p_party_id                                    --PARTY_ID              --         NUMBER(15)
   , l_party_site_id                               --PARTY_SITE_ID         --         NUMBER(15)
   ,'NEW'
   , p_contact_party_id                                      -- load_status
   );

Line: 1757

END insert_lead_rec;

Line: 1808

PROCEDURE Add_Update_Access_record(
   p_object_type     IN    VARCHAR2,
   p_object_id      IN    NUMBER,
   p_Owner_user_id  IN    NUMBER,
   x_return_status    OUT NOCOPY VARCHAR2,
   x_msg_count        OUT NOCOPY VARCHAR2,
   x_msg_data         OUT NOCOPY VARCHAR2
   )
   IS

   l_owner_user_id  NUMBER;

Line: 1826

   SELECT USER_OR_ROLE_ID
   FROM AMS_ACT_ACCESS
   WHERE ACT_ACCESS_TO_OBJECT_ID = object_id_in
     AND ARC_ACT_ACCESS_TO_OBJECT = object_type_in
     AND OWNER_FLAG = 'Y';

Line: 1849

         AMS_access_PVT.update_object_owner(p_api_version => 1,
                        x_return_status => x_return_status,
                          x_msg_data => x_msg_data,
                          x_msg_count => x_msg_count,
                          p_object_type => p_object_type,
                          p_object_id => p_object_id,
                          p_resource_id => p_Owner_user_id,
                          p_old_resource_id => l_owner_user_id);

Line: 1860

END Add_Update_Access_record;

Line: 1942

   SELECT count(event_offer_name)
   FROM ams_event_offers_vl
   WHERE event_offer_name = name_in;

Line: 2022

      SELECT event_header_id,object_version_number,system_status_code
      FROM ams_event_headers_all_b
      WHERE  EVENT_HEADER_ID  = p_evh_id
      AND system_status_code <> 'CANCELLED' ;

Line: 2041

         UPDATE ams_event_headers_all_b
         SET    system_status_code = 'CANCELLED',
                last_status_date = SYSDATE,
                user_status_id = l_status_id,
                object_version_number = object_version_number + 1
         WHERE  event_header_id = l_event_header_id
         AND    object_version_number = l_obj_version ;

Line: 2084

      SELECT event_offer_id,object_version_number,system_status_code, event_object_type
      FROM ams_event_offers_all_b
      WHERE  event_header_id  = p_evh_id
      AND system_status_code <> 'CANCELLED' ;

Line: 2103

         UPDATE ams_event_offers_all_b
         SET    system_status_code = 'CANCELLED',
                last_status_date = SYSDATE,
                user_status_id = l_status_id,
                object_version_number = object_version_number + 1
         WHERE  event_offer_id = l_event_offer_id
         AND    object_version_number = l_obj_version ;

Line: 2153

      SELECT event_offer_id,object_version_number,system_status_code, event_object_type
      FROM ams_event_offers_all_b
      WHERE  event_offer_id  = p_offer_id
      AND system_status_code <> 'CANCELLED' ;

Line: 2172

         UPDATE ams_event_offers_all_b
         SET    system_status_code = 'CANCELLED',
                last_status_date = SYSDATE,
                user_status_id = l_status_id,
                object_version_number = object_version_number + 1
         WHERE  event_offer_id = l_event_offer_id
         AND    object_version_number = l_obj_version ;

Line: 2226

      SELECT count(*)
      FROM ams_event_headers_all_b
      WHERE  program_id  = p_prog_id
      AND system_status_code NOT IN ('CANCELLED', 'ARCHIVED');

Line: 2232

      SELECT count(*)
      FROM ams_event_offers_all_b
      WHERE  parent_id  = p_prog_id
      AND event_object_type = 'EONE'
      AND parent_type = 'RCAM'
      AND system_status_code NOT IN ('CANCELLED', 'ARCHIVED');

Line: 2276

      SELECT event_header_id,object_version_number,system_status_code
      FROM ams_event_headers_all_b
      WHERE  EVENT_HEADER_ID  = p_evh_id
      AND system_status_code <> 'COMPLETED' ;

Line: 2295

         UPDATE ams_event_headers_all_b
         SET    system_status_code = 'COMPLETED',
                last_status_date = SYSDATE,
                user_status_id = l_status_id,
                object_version_number = object_version_number + 1
         WHERE  event_header_id = l_event_header_id
         AND    object_version_number = l_obj_version ;

Line: 2337

      SELECT event_offer_id,object_version_number,system_status_code, event_object_type
      FROM ams_event_offers_all_b
      WHERE  event_header_id  = p_evh_id
      AND system_status_code <> 'COMPLETED' ;

Line: 2356

         UPDATE ams_event_offers_all_b
         SET    system_status_code = 'COMPLETED',
                last_status_date = SYSDATE,
                user_status_id = l_status_id,
                object_version_number = object_version_number + 1
         WHERE  event_offer_id = l_event_offer_id
         AND    object_version_number = l_obj_version ;

Line: 2405

      SELECT event_offer_id,object_version_number,system_status_code, event_object_type
      FROM ams_event_offers_all_b
      WHERE  event_offer_id  = p_offer_id
      AND system_status_code <> 'COMPLETED';

Line: 2424

         UPDATE ams_event_offers_all_b
         SET    system_status_code = 'COMPLETED',
                last_status_date = SYSDATE,
                user_status_id = l_status_id,
                object_version_number = object_version_number + 1
         WHERE  event_offer_id = l_event_offer_id
         AND    object_version_number = l_obj_version ;

Line: 2473

      SELECT event_header_id,object_version_number,system_status_code
      FROM ams_event_headers_all_b
      WHERE  program_id  = p_prog_id;

Line: 2478

      SELECT event_offer_id,object_version_number,system_status_code
      FROM ams_event_offers_all_b
      WHERE  parent_id  = p_prog_id
      AND event_object_type = 'EONE'
      AND parent_type = 'RCAM';

Line: 2647

PROCEDURE Update_Event_Header_Status (
   p_event_header_id         IN NUMBER,
   p_new_status_id           IN NUMBER,
   p_new_status_code         IN VARCHAR2
 ) IS
   l_schedule_id             NUMBER ;

Line: 2661

     SELECT event_offer_id , object_version_number, event_object_type
     FROM  ams_event_offers_vl
     WHERE event_header_id = p_event_header_id
     AND system_status_code = 'AVAILABLE';

Line: 2667

     SELECT object_version_number
     FROM ams_event_headers_vl
     WHERE event_header_id = p_event_header_id;

Line: 2672

     SELECT count(*)
     FROM  ams_event_offers_vl
     WHERE event_header_id = p_event_header_id
     AND system_status_code NOT IN ( 'CANCELLED', 'ARCHIVED');

Line: 2678

     SELECT system_status_code
     FROM  ams_event_headers_vl
     WHERE event_header_id = p_event_header_id;

Line: 2702

      UPDATE ams_event_headers_all_b
      SET    user_status_id = p_new_status_id,
             system_status_code    = p_new_status_code,
             last_status_date    = SYSDATE,
             object_version_number = l_evh_obj_ver + 1
      WHERE  event_header_id    = p_event_header_id;

Line: 2715

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

Line: 2754

              UPDATE ams_event_headers_all_b
              SET    user_status_id = p_new_status_id,
                     system_status_code  = p_new_status_code,
                     last_status_date    = SYSDATE,
                     object_version_number = l_evh_obj_ver + 1
              WHERE  event_header_id     = p_event_header_id;

Line: 2771

         UPDATE ams_event_headers_all_b
         SET    user_status_id = p_new_status_id,
                system_status_code  = p_new_status_code,
                last_status_date    = SYSDATE,
                object_version_number = l_evh_obj_ver + 1
          WHERE  event_header_id     = p_event_header_id;

Line: 2779

 END Update_Event_Header_Status;

Line: 2788

PROCEDURE Update_Event_Schedule_Status (
   p_event_offer_id          IN NUMBER,
   p_new_status_id           IN NUMBER,
   p_new_status_code         IN VARCHAR2
 ) IS

 -- declare cursor for enh # 3805347
 CURSOR c_eve_det IS
 SELECT system_status_code, event_object_type
 FROM   ams_event_offers_all_b
 WHERE  event_offer_id = p_event_offer_id;

Line: 2810

   UPDATE ams_event_offers_all_b
   SET    user_status_id = p_new_status_id,
          system_status_code    = p_new_status_code,
          last_status_date    = SYSDATE
   WHERE  event_offer_id    = p_event_offer_id;

Line: 2824

 END Update_Event_Schedule_Status;

Line: 2839

PROCEDURE Update_Owner(
   p_api_version       IN  NUMBER,
   p_init_msg_list     IN  VARCHAR2  := FND_API.g_false,
   p_commit            IN  VARCHAR2  := FND_API.g_false,
   p_validation_level  IN  NUMBER    := FND_API.g_valid_level_full,
   x_return_status     OUT NOCOPY VARCHAR2,
   x_msg_count         OUT NOCOPY NUMBER,
   x_msg_data          OUT NOCOPY VARCHAR2,
   p_object_type       IN  VARCHAR2 := NULL ,
   p_event_id          IN  NUMBER,
   p_owner_id          IN  NUMBER   )
IS
   CURSOR c_header_owner IS
   SELECT owner_user_id
   FROM   ams_event_headers_all_b
   WHERE  event_header_id = p_event_id ;

Line: 2857

   SELECT owner_user_id
   FROM   ams_event_offers_all_b
   WHERE  event_offer_id = p_event_id ;

Line: 2892

       AMS_Access_PVT.update_object_owner(
           p_api_version       => p_api_version,
           p_init_msg_list     => p_init_msg_list,
           p_commit            => p_commit,
           p_validation_level  => p_validation_level,
           x_return_status     => x_return_status,
           x_msg_count         => x_msg_count,
           x_msg_data          => x_msg_data,
           p_object_type       => p_object_type,
           p_object_id         => p_event_id,
           p_resource_id       => p_owner_id,
           p_old_resource_id   => l_old_owner
        );

Line: 2914

END Update_Owner ;

Line: 2969

   SELECT parent_type, owner_user_id
     FROM ams_event_offers_all_b
    WHERE event_offer_id = p_object_id;

Line: 2974

   SELECT schedule_id
     FROM ams_campaign_schedules_b
    WHERE related_event_id = p_object_id;