APPS.IGI_IAC_XLA_EVENTS_PKG SQL Statements

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

Line: 41

   select book_type_code,revaluation_date
   into l_book_type_code,l_revaluation_date
   from igi_iac_revaluations
   where revaluation_id =p_revaluation_id;

Line: 128

FUNCTION update_revaluation_event
           ( p_revaluation_id         IN NUMBER ) return boolean IS

   l_reval_source_info  XLA_EVENTS_PUB_PKG.t_event_source_info;

Line: 145

   l_path_name             varchar2(150) := g_path || 'update_revaluation_event';

Line: 148

   select book_type_code,revaluation_date,event_id
   into l_book_type_code,l_revaluation_date,l_event_id
   from igi_iac_revaluations
   where revaluation_id =p_revaluation_id;

Line: 177

   XLA_EVENTS_PUB_PKG.update_event
     (p_event_source_info            => l_reval_source_info,
      p_event_id                     => l_event_id,
      p_event_type_code              => l_event_type_code,
      p_event_date                   => null, --tbd
      p_event_status_code            => null, --tbd
      p_valuation_method             => l_book_type_code,
      p_security_context             => l_security_context);

Line: 196

end update_revaluation_event;

Line: 199

FUNCTION delete_revaluation_event
           (p_revaluation_id         IN NUMBER) return boolean IS

   l_event_id         NUMBER;

Line: 220

   select book_type_code,revaluation_date
   into l_book_type_code,l_revaluation_date
   from igi_iac_revaluations
   where revaluation_id =p_revaluation_id;

Line: 250

   XLA_EVENTS_PUB_PKG.delete_event
      (p_event_source_info            => l_reval_source_info,
       p_event_id                     => l_event_id,
       p_valuation_method             => l_book_type_code,
       p_security_context             => l_security_context);

Line: 266

END delete_revaluation_event;