APPS.AMS_REGISTRANTS_PUB SQL Statements

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

Line: 130

   l_update_reg_rec           VARCHAR2(1);

Line: 145

   select event_registration_id,
          object_version_number,
          confirmation_code,
          system_status_code
   from ams_event_registrations
   where REGISTRANT_PARTY_ID = p_reg_party_id
     and REGISTRANT_CONTACT_ID = p_reg_contact_id
     and ATTENDANT_PARTY_ID = p_att_party_id
     and ATTENDANT_CONTACT_ID = p_att_contact_id
     and EVENT_OFFER_ID = p_event_offer_id
   order by event_registration_id desc;

Line: 158

   select event_registration_id,
          object_version_number,
          REGISTRANT_PARTY_ID,
          REGISTRANT_CONTACT_ID,
          ATTENDANT_PARTY_ID,
          ATTENDANT_CONTACT_ID,
          system_status_code
   from ams_event_registrations
   where confirmation_code = p_confirmation_code;

Line: 169

   select user_status_id
   from ams_user_statuses_vl
   where system_status_type = 'AMS_EVENT_REG_STATUS'
     and system_status_code = l_system_status_code
     and default_flag = 'Y';

Line: 177

     SELECT 1
     FROM hz_parties
     WHERE party_id = p_reg_contact_id;

Line: 183

   select system_status_code
     from ams_event_registrations
    where event_registration_id = p_reg_id;

Line: 189

   select party_type
   from hz_parties
   where party_id = p_party_id;

Line: 194

   select object_id
   from hz_relationships
   where party_id = p_party_id
   and object_type = 'ORGANIZATION';

Line: 204

   SELECT 1
   From hz_relationships
   where party_id = p_party_id
   and object_type = 'ORGANIZATION'
   and object_id = p_org_id;

Line: 565

         IF p_reg_det_rec.update_reg_rec IS NULL
         THEN
            l_update_reg_rec := 'Y';

Line: 569

            l_update_reg_rec := p_reg_det_rec.update_reg_rec;

Line: 573

         AMS_Utility_PVT.debug_message('Value of l_update_reg_rec is '||l_update_reg_rec);

Line: 575

	 Write_log(L_API_NAME, 'Value of l_update_reg_rec is '||l_update_reg_rec);

Line: 577

         IF l_update_reg_rec = 'C'
         THEN

	/*
               IF (AMS_DEBUG_HIGH_ON) THEN
                  AMS_Utility_PVT.debug_message('Calling AMS_EvtRegs_PUB.Register');

Line: 627

         ELSIF l_update_reg_rec = 'N'
         THEN

               -- soagrawa added the following on 24-apr-2003 for bug 2863012
               -- see if existing registration's status is cancelled
               -- if yes, then dont throw error
               OPEN  c_get_reg_status(l_event_registration_id);

Line: 704

         ELSE -- default is update 'U'

	/*
               IF (AMS_DEBUG_HIGH_ON) THEN
                  AMS_Utility_PVT.debug_message('Calling AMS_EvtRegs_PUB.Update_Registration');

Line: 712

	       Write_log(L_API_NAME, 'Calling AMS_EvtRegs_PUB.Update_Registration');

Line: 715

               AMS_EvtRegs_PUB.Update_Registration(  P_Api_Version_Number => 1.0
                                                   , P_Init_Msg_List      => FND_API.G_FALSE
                                                   , P_Commit             => FND_API.G_FALSE
                                                   , P_evt_regs_Rec       => l_evt_regs_rec
                                                   , p_block_fulfillment  => p_block_fulfillment
                                                   , X_Return_Status      => l_return_status
                                                   , X_Msg_Count          => x_msg_count
                                                   , X_Msg_Data           => x_msg_data
                                                  );