APPS.FA_XLA_EVENTS_PVT SQL Statements

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

Line: 44

   if (p_calling_fn = 'fa_addition_pvt.insert_asset') then
      l_event_type_code                       := 'ADDITIONS';

Line: 378

   insert into xla_events_int_gt
     (APPLICATION_ID       ,
      LEDGER_ID            ,
      LEGAL_ENTITY_ID      ,
      ENTITY_CODE          ,
      event_type_code      ,
      event_date           ,
      event_number         ,
      event_status_code    ,
      transaction_number   ,
      source_id_int_1      ,
      source_id_char_1     ,
      source_id_int_2      ,
      source_id_int_3      ,
      valuation_method
     )
     values
     (140                  ,
      fa_cache_pkg.fazcbc_record.set_of_books_id,
      l_legal_entity_id    ,
      p_entity_type_code   ,
      'DEPRECIATION'       ,
      p_period_close_date  ,
      l_dummy_number(i)    ,
      XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,
      l_dummy_number(i)    ,
      p_asset_id_tbl(i)    ,
      p_book_type_code     ,
      p_period_counter     ,
      p_deprn_run_id       ,
      p_book_type_code
     );

Line: 419

   select event_id bulk collect
     into x_event_id_tbl
     from xla_events_int_gt
    order by event_number;

Line: 471

   insert into xla_events_int_gt
     (APPLICATION_ID       ,
      LEDGER_ID            ,
      LEGAL_ENTITY_ID      ,
      ENTITY_CODE          ,
      event_type_code      ,
      event_date           ,
      event_number         ,
      event_status_code    ,
      transaction_number   ,
      source_id_int_1      ,
      source_id_char_1     ,
      source_id_char_2     ,
      source_id_int_2      ,
      valuation_method
     )
     values
     (140                  ,
      fa_cache_pkg.fazcbc_record.set_of_books_id,
      l_legal_entity_id    ,
      p_entity_type_code   ,
      'DEFERRED_DEPRECIATION'       ,
      p_period_close_date  ,
      l_dummy_number(i)    ,
      XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,
      l_dummy_number(i)    ,
      p_asset_id_tbl(i)    ,
      p_corp_book          ,
      p_tax_book           ,
      p_corp_period_counter,
      p_corp_book
     );

Line: 512

   select event_id bulk collect
     into x_event_id_tbl
     from xla_events_int_gt
    order by event_number;

Line: 533

PROCEDURE update_event_status
   (p_event_source_info            IN  xla_events_pub_pkg.t_event_source_info
   ,p_event_class_code             IN  VARCHAR2   DEFAULT NULL
   ,p_event_type_code              IN  VARCHAR2   DEFAULT NULL
   ,p_event_date                   IN  DATE       DEFAULT NULL
   ,p_event_status_code            IN  VARCHAR2
   ,p_valuation_method             IN  VARCHAR2
   ,p_security_context             IN  xla_events_pub_pkg.t_security

   ,p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type default null);

Line: 546

FUNCTION update_transaction_event
           (p_ledger_id              IN NUMBER,
            p_transaction_header_id  IN NUMBER,
            p_book_type_code         IN VARCHAR2,
            p_event_type_code        IN VARCHAR2,
            p_event_date             IN DATE,
            p_event_status_code      IN VARCHAR2,
            p_calling_fn             IN VARCHAR2,
            p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type default null) return boolean IS

   l_trx_source_info   XLA_EVENTS_PUB_PKG.t_event_source_info;

Line: 561

   l_calling_fn        varchar2(80) := 'fa_xla_events_pvt.update_transaction_event';

Line: 570

   select event_id
     into l_event_id
     from fa_transaction_headers
    where transaction_header_id = p_transaction_header_id;

Line: 575

   XLA_EVENTS_PUB_PKG.update_event
     (p_event_source_info            => l_trx_source_info,
      p_event_id                     => l_event_id,
      p_event_type_code              => p_event_type_code,
      p_event_date                   => p_event_date,
      p_event_status_code            => p_event_status_code,
      p_valuation_method             => p_book_type_code,
      p_security_context             => l_security_context);

Line: 592

end update_transaction_event;

Line: 594

FUNCTION update_inter_transaction_event
           (p_ledger_id              IN NUMBER,
            p_trx_reference_id       IN NUMBER,
            p_book_type_code         IN VARCHAR2,
            p_event_type_code        IN VARCHAR2,
            p_event_date             IN DATE,
            p_event_status_code      IN VARCHAR2,
            p_calling_fn             IN VARCHAR2,
            p_log_level_rec in fa_api_types.log_level_rec_type default null
           ) return boolean is

   l_trx_source_info   XLA_EVENTS_PUB_PKG.t_event_source_info;

Line: 610

   l_calling_fn        varchar2(80) := 'fa_xla_events_pvt.update_inter_transaction_event';

Line: 619

   select event_id
     into l_event_id
     from fa_trx_references
    where trx_reference_id = p_trx_reference_id;

Line: 624

   XLA_EVENTS_PUB_PKG.update_event
     (p_event_source_info            => l_trx_source_info,
      p_event_id                     => l_event_id,
      p_event_type_code              => p_event_type_code,
      p_event_date                   => p_event_date,
      p_event_status_code            => p_event_status_code,
      p_valuation_method             => p_book_type_code,
      p_security_context             => l_security_context);

Line: 641

end update_inter_transaction_event;

Line: 647

FUNCTION delete_transaction_event
           (p_ledger_id              IN NUMBER,
            p_transaction_header_id  IN NUMBER,
            p_book_type_code         IN VARCHAR2,
            p_calling_fn             IN VARCHAR2,
            p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type default null) return boolean IS

   l_event_id         NUMBER;

Line: 658

   l_calling_fn       varchar2(80) := 'fa_xla_events_pvt.delete_transaction_event';

Line: 667

   select event_id
     into l_event_id
     from fa_transaction_headers
    where transaction_header_id = p_transaction_header_id;

Line: 672

   XLA_EVENTS_PUB_PKG.delete_event
      (p_event_source_info            => l_trx_source_info,
       p_event_id                     => l_event_id,
       p_valuation_method             => p_book_type_code,
       p_security_context             => l_security_context);

Line: 686

END delete_transaction_event;

Line: 688

FUNCTION delete_deprn_event
           (p_event_id               IN NUMBER,
            p_ledger_id              IN NUMBER,
            p_asset_id               IN NUMBER,
            p_book_type_code         IN VARCHAR2,
            p_period_counter         IN NUMBER,
            p_deprn_run_id           IN NUMBER,
            p_calling_fn             IN VARCHAR2,
            p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type default null) return boolean IS

   l_event_id           NUMBER;

Line: 702

   l_calling_fn         varchar2(80) := 'fa_xla_events_pvt.delete_deprn_event';

Line: 714

   XLA_EVENTS_PUB_PKG.delete_event
      (p_event_source_info            => l_deprn_source_info,
       p_event_id                     => p_event_id,
       p_valuation_method             => p_book_type_code,
       p_security_context             => l_security_context);

Line: 728

END delete_deprn_event;