APPS.XLA_00206_AAD_S_000004_BC_PKG SQL Statements

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

Line: 1474

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 1544

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 2095

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 2165

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 2723

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 2793

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 3344

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 3414

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 3929

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 3999

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 4507

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 4577

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 5092

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 5162

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 5670

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 5740

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 5780

PROCEDURE insert_sources_15(
                                p_target_ledger_id       IN NUMBER
                              , p_language               IN VARCHAR2
                              , p_sla_ledger_id          IN NUMBER
                              , p_pad_start_date         IN DATE
                              , p_pad_end_date           IN DATE
                         )
IS

C_EVENT_TYPE_CODE    CONSTANT  VARCHAR2(30)  := 'DIRECT_LOAN_APPROVED';

Line: 5795

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_15';

Line: 5800

         (p_msg      => 'BEGIN of insert_sources_15'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 5807

SELECT oracle_username
  INTO p_apps_owner
  FROM fnd_oracle_userid
 WHERE read_only_flag = 'U'
;

Line: 5827

INSERT INTO xla_diag_sources --hdr1
(
        event_id
      , ledger_id
      , sla_ledger_id
      , description_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , source_value
      , source_meaning
      , created_by
      , creation_date
      , last_update_date
      , last_updated_by
      , last_update_login
      , program_update_date
      , program_application_id
      , program_id
      , request_id
)
SELECT
        event_id
      , p_target_ledger_id
      , p_sla_ledger_id
      , p_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , SUBSTR(source_value ,1,1996)
      , SUBSTR(source_meaning,1,200)
      , xla_environment_pkg.g_Usr_Id
      , TRUNC(SYSDATE)
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Usr_Id
      , xla_environment_pkg.g_Login_Id
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Prog_Appl_Id
      , xla_environment_pkg.g_Prog_Id
      , xla_environment_pkg.g_Req_Id
  FROM (
       SELECT xet.event_id                  event_id
            , 0                             line_number
            , CASE r
               WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V' 
                WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V' 
                WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V' 
                WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V' 
                WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V' 
                WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V' 
                WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V' 
                WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V' 
                WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'HEADER' 
                WHEN 2 THEN 'HEADER' 
                WHEN 3 THEN 'HEADER' 
                WHEN 4 THEN 'HEADER' 
                WHEN 5 THEN 'HEADER' 
                WHEN 6 THEN 'HEADER' 
                WHEN 7 THEN 'HEADER' 
                WHEN 8 THEN 'HEADER' 
                WHEN 9 THEN 'HEADER' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '206' 
                WHEN 2 THEN '206' 
                WHEN 3 THEN '206' 
                WHEN 4 THEN '206' 
                WHEN 5 THEN '206' 
                WHEN 6 THEN '206' 
                WHEN 7 THEN '206' 
                WHEN 8 THEN '206' 
                WHEN 9 THEN '206' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'LOAN_CLASS_CODE' 
                WHEN 2 THEN 'LOAN_TYPE' 
                WHEN 3 THEN 'LOAN_NUMBER' 
                WHEN 4 THEN 'FUNDS_RESERVED_FLAG' 
                WHEN 5 THEN 'LOAN_CURRENCY' 
                WHEN 6 THEN 'EXCHANGE_DATE' 
                WHEN 7 THEN 'EXCHANGE_RATE' 
                WHEN 8 THEN 'EXCHANGE_RATE_TYPE' 
                WHEN 9 THEN 'GL_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h2.LOAN_CLASS_CODE)
                WHEN 2 THEN TO_CHAR(h2.LOAN_TYPE)
                WHEN 3 THEN TO_CHAR(h2.LOAN_NUMBER)
                WHEN 4 THEN TO_CHAR(h2.FUNDS_RESERVED_FLAG)
                WHEN 5 THEN TO_CHAR(h2.LOAN_CURRENCY)
                WHEN 6 THEN TO_CHAR(h2.EXCHANGE_DATE)
                WHEN 7 THEN TO_CHAR(h2.EXCHANGE_RATE)
                WHEN 8 THEN TO_CHAR(h2.EXCHANGE_RATE_TYPE)
                WHEN 9 THEN TO_CHAR(h2.GL_DATE)
                
                ELSE null
              END                           source_value
            , CASE r
                WHEN 1 THEN fvl1.meaning
                WHEN 5 THEN fvl15.meaning
                
                ELSE null
              END               source_meaning
        FROM xla_events_gt     xet  
      , LNS_LOAN_HEADERS_EXT_V  h2
  , fnd_lookup_values    fvl1
  , fnd_lookup_values    fvl15
            ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
       WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
         AND xet.event_type_code = C_EVENT_TYPE_CODE
            AND h2.event_id = xet.event_id
   AND fvl1.lookup_type(+)         = 'LOAN_CLASS'
  AND fvl1.lookup_code(+)         = h2.LOAN_CLASS_CODE
  AND fvl1.view_application_id(+) = 206
  AND fvl1.language(+)            = USERENV('LANG')
     AND fvl15.lookup_type(+)         = 'CURRENCY_CODE'
  AND fvl15.lookup_code(+)         = h2.LOAN_CURRENCY
  AND fvl15.view_application_id(+) = 101
  AND fvl15.language(+)            = USERENV('LANG')
  
)
;

Line: 5970

         (p_msg      => 'number of header sources inserted = '||SQL%ROWCOUNT
         ,p_level    => C_LEVEL_STATEMENT
         ,p_module   => l_log_module);

Line: 5980

INSERT INTO xla_diag_sources --line1
(
        event_id
      , ledger_id
      , sla_ledger_id
      , description_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , source_value
      , source_meaning
      , created_by
      , creation_date
      , last_update_date
      , last_updated_by
      , last_update_login
      , program_update_date
      , program_application_id
      , program_id
      , request_id
)
SELECT  event_id
      , p_target_ledger_id
      , p_sla_ledger_id
      , p_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , SUBSTR(source_value,1,1996)
      , SUBSTR(source_meaning,1,200)
      , xla_environment_pkg.g_Usr_Id
      , TRUNC(SYSDATE)
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Usr_Id
      , xla_environment_pkg.g_Login_Id
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Prog_Appl_Id
      , xla_environment_pkg.g_Prog_Id
      , xla_environment_pkg.g_Req_Id
  FROM (
       SELECT xet.event_id                  event_id
            , l1.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                WHEN 10 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'LINE' 
                WHEN 2 THEN 'LINE' 
                WHEN 3 THEN 'LINE' 
                WHEN 4 THEN 'LINE' 
                WHEN 5 THEN 'LINE' 
                WHEN 6 THEN 'LINE' 
                WHEN 7 THEN 'LINE' 
                WHEN 8 THEN 'LINE' 
                WHEN 9 THEN 'LINE' 
                WHEN 10 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '206' 
                WHEN 2 THEN '206' 
                WHEN 3 THEN '206' 
                WHEN 4 THEN '206' 
                WHEN 5 THEN '206' 
                WHEN 6 THEN '206' 
                WHEN 7 THEN '206' 
                WHEN 8 THEN '206' 
                WHEN 9 THEN '206' 
                WHEN 10 THEN '206' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'ACCOUNT_NAME' 
                WHEN 2 THEN 'DERIVED_PROGRAM_ACCOUNT_BSV' 
                WHEN 3 THEN 'CODE_COMBINATION_ID' 
                WHEN 4 THEN 'LINE_TYPE' 
                WHEN 5 THEN 'ACCOUNT_TYPE' 
                WHEN 6 THEN 'EVENT_TYPE' 
                WHEN 7 THEN 'DISBURSEMENT_NUMBER' 
                WHEN 8 THEN 'DISTRIBUTION_ID' 
                WHEN 9 THEN 'DISTRIBUTION_TYPE' 
                WHEN 10 THEN 'DISTRIBUTION_AMOUNT' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l1.ACCOUNT_NAME)
                WHEN 2 THEN TO_CHAR(l1.DERIVED_PROGRAM_ACCOUNT_BSV)
                WHEN 3 THEN TO_CHAR(l1.CODE_COMBINATION_ID)
                WHEN 4 THEN TO_CHAR(l1.LINE_TYPE)
                WHEN 5 THEN TO_CHAR(l1.ACCOUNT_TYPE)
                WHEN 6 THEN TO_CHAR(l1.EVENT_TYPE)
                WHEN 7 THEN TO_CHAR(l1.DISBURSEMENT_NUMBER)
                WHEN 8 THEN TO_CHAR(l1.DISTRIBUTION_ID)
                WHEN 9 THEN TO_CHAR(l1.DISTRIBUTION_TYPE)
                WHEN 10 THEN TO_CHAR(l1.DISTRIBUTION_AMOUNT)
                
                ELSE null
              END                           source_value
            , CASE r
                WHEN 1 THEN fvl4.meaning
                WHEN 5 THEN fvl8.meaning
                WHEN 6 THEN fvl9.meaning
                WHEN 9 THEN fvl13.meaning
                
                ELSE null
              END               source_meaning
         FROM  xla_events_gt     xet  
        , LNS_LOAN_DETAILS_EXT_V  l1
  , fnd_lookup_values    fvl4
  , fnd_lookup_values    fvl8
  , fnd_lookup_values    fvl9
  , fnd_lookup_values    fvl13
            ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
        WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
          AND xet.event_type_code = C_EVENT_TYPE_CODE
            AND l1.event_id          = xet.event_id
   AND fvl4.lookup_type(+)         = 'LOAN_DISTRIBUTION_ACCOUNTS'
  AND fvl4.lookup_code(+)         = l1.ACCOUNT_NAME
  AND fvl4.view_application_id(+) = 206
  AND fvl4.language(+)            = USERENV('LANG')
     AND fvl8.lookup_type(+)         = 'LOAN_DISTRIBUTION_ACCOUNT_DRCR'
  AND fvl8.lookup_code(+)         = l1.ACCOUNT_TYPE
  AND fvl8.view_application_id(+) = 206
  AND fvl8.language(+)            = USERENV('LANG')
     AND fvl9.lookup_type(+)         = 'LOAN_ACCOUNTING_EVENT'
  AND fvl9.lookup_code(+)         = l1.EVENT_TYPE
  AND fvl9.view_application_id(+) = 206
  AND fvl9.language(+)            = USERENV('LANG')
     AND fvl13.lookup_type(+)         = 'LOAN_DISTRIBUTION_ACCOUNT_DRCR'
  AND fvl13.lookup_code(+)         = l1.DISTRIBUTION_TYPE
  AND fvl13.view_application_id(+) = 206
  AND fvl13.language(+)            = USERENV('LANG')
  
)
;

Line: 6140

         (p_msg      => 'number of line sources inserted = '||SQL%ROWCOUNT
         ,p_level    => C_LEVEL_STATEMENT
         ,p_module   => l_log_module);

Line: 6149

         (p_msg      => 'END of insert_sources_15'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 6170

           (p_location => 'XLA_00206_AAD_S_000004_BC_PKG.insert_sources_15');

Line: 6171

END insert_sources_15;

Line: 6315

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Type Code: DIRECT_LOAN_APPROVED
-- Event Class Code: DIRECT
    xet.entity_id
  , xet.legal_entity_id
  , xet.entity_code
  , xet.transaction_number
  , xet.event_id
  , xet.event_class_code
  , xet.event_type_code
  , xet.event_number
  , xet.event_date
  , xet.transaction_date
  , xet.reference_num_1
  , xet.reference_num_2
  , xet.reference_num_3
  , xet.reference_num_4
  , xet.reference_char_1
  , xet.reference_char_2
  , xet.reference_char_3
  , xet.reference_char_4
  , xet.reference_date_1
  , xet.reference_date_2
  , xet.reference_date_3
  , xet.reference_date_4
  , xet.event_created_by
  , xet.budgetary_control_flag 
  , h2.LOAN_CLASS_CODE    source_1
  , fvl1.meaning   source_1_meaning
  , h2.LOAN_TYPE    source_2
  , h2.LOAN_NUMBER    source_3
  , h2.FUNDS_RESERVED_FLAG    source_11
  , h2.LOAN_CURRENCY    source_15
  , fvl15.meaning   source_15_meaning
  , h2.EXCHANGE_DATE    source_16
  , h2.EXCHANGE_RATE    source_17
  , h2.EXCHANGE_RATE_TYPE    source_18
  , h2.GL_DATE    source_20
  FROM xla_events_gt     xet 
  , LNS_LOAN_HEADERS_EXT_V  h2
  , fnd_lookup_values    fvl1
  , fnd_lookup_values    fvl15
 WHERE xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_type_code = C_EVENT_TYPE_CODE
   and xet.event_status_code <> 'N'  AND h2.event_id = xet.event_id
   AND fvl1.lookup_type(+)         = 'LOAN_CLASS'
  AND fvl1.lookup_code(+)         = h2.LOAN_CLASS_CODE
  AND fvl1.view_application_id(+) = 206
  AND fvl1.language(+)            = USERENV('LANG')
     AND fvl15.lookup_type(+)         = 'CURRENCY_CODE'
  AND fvl15.lookup_code(+)         = h2.LOAN_CURRENCY
  AND fvl15.view_application_id(+) = 101
  AND fvl15.language(+)            = USERENV('LANG')
  
 ORDER BY event_id
;

Line: 6376

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Type Code: DIRECT_LOAN_APPROVED
-- Event Class Code: DIRECT
    xet.entity_id
   ,xet.legal_entity_id
   ,xet.entity_code
   ,xet.transaction_number
   ,xet.event_id
   ,xet.event_class_code
   ,xet.event_type_code
   ,xet.event_number
   ,xet.event_date
   ,xet.transaction_date
   ,xet.reference_num_1
   ,xet.reference_num_2
   ,xet.reference_num_3
   ,xet.reference_num_4
   ,xet.reference_char_1
   ,xet.reference_char_2
   ,xet.reference_char_3
   ,xet.reference_char_4
   ,xet.reference_date_1
   ,xet.reference_date_2
   ,xet.reference_date_3
   ,xet.reference_date_4
   ,xet.event_created_by
   ,xet.budgetary_control_flag  , l1.LINE_NUMBER  
  , l1.ACCOUNT_NAME    source_4
  , fvl4.meaning   source_4_meaning
  , l1.DERIVED_PROGRAM_ACCOUNT_BSV    source_5
  , l1.CODE_COMBINATION_ID    source_6
  , l1.LINE_TYPE    source_7
  , l1.ACCOUNT_TYPE    source_8
  , fvl8.meaning   source_8_meaning
  , l1.EVENT_TYPE    source_9
  , fvl9.meaning   source_9_meaning
  , l1.DISBURSEMENT_NUMBER    source_10
  , l1.DISTRIBUTION_ID    source_12
  , l1.DISTRIBUTION_TYPE    source_13
  , fvl13.meaning   source_13_meaning
  , l1.DISTRIBUTION_AMOUNT    source_14
  FROM xla_events_gt     xet 
  , LNS_LOAN_DETAILS_EXT_V  l1
  , fnd_lookup_values    fvl4
  , fnd_lookup_values    fvl8
  , fnd_lookup_values    fvl9
  , fnd_lookup_values    fvl13
 WHERE xet.event_id between x_first_event_id and x_last_event_id
   and xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_type_code = C_EVENT_TYPE_CODE
   and xet.event_status_code <> 'N'   AND l1.event_id      = xet.event_id
   AND fvl4.lookup_type(+)         = 'LOAN_DISTRIBUTION_ACCOUNTS'
  AND fvl4.lookup_code(+)         = l1.ACCOUNT_NAME
  AND fvl4.view_application_id(+) = 206
  AND fvl4.language(+)            = USERENV('LANG')
     AND fvl8.lookup_type(+)         = 'LOAN_DISTRIBUTION_ACCOUNT_DRCR'
  AND fvl8.lookup_code(+)         = l1.ACCOUNT_TYPE
  AND fvl8.view_application_id(+) = 206
  AND fvl8.language(+)            = USERENV('LANG')
     AND fvl9.lookup_type(+)         = 'LOAN_ACCOUNTING_EVENT'
  AND fvl9.lookup_code(+)         = l1.EVENT_TYPE
  AND fvl9.view_application_id(+) = 206
  AND fvl9.language(+)            = USERENV('LANG')
     AND fvl13.lookup_type(+)         = 'LOAN_DISTRIBUTION_ACCOUNT_DRCR'
  AND fvl13.lookup_code(+)         = l1.DISTRIBUTION_TYPE
  AND fvl13.view_application_id(+) = 206
  AND fvl13.language(+)            = USERENV('LANG')
  ;

Line: 6471

g_array_event.DELETE;

Line: 6706

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

Line: 6727

   l_result := XLA_AE_LINES_PKG.InsertLines;

Line: 7121

l_result := XLA_AE_LINES_PKG.InsertLines ;

Line: 7129

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;

Line: 7185

PROCEDURE insert_sources_16(
                                p_target_ledger_id       IN NUMBER
                              , p_language               IN VARCHAR2
                              , p_sla_ledger_id          IN NUMBER
                              , p_pad_start_date         IN DATE
                              , p_pad_end_date           IN DATE
                         )
IS

C_EVENT_TYPE_CODE    CONSTANT  VARCHAR2(30)  := 'FUTURE_DISBURSEMENT_CANCELLED';

Line: 7200

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_16';

Line: 7205

         (p_msg      => 'BEGIN of insert_sources_16'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 7212

SELECT oracle_username
  INTO p_apps_owner
  FROM fnd_oracle_userid
 WHERE read_only_flag = 'U'
;

Line: 7232

INSERT INTO xla_diag_sources --hdr1
(
        event_id
      , ledger_id
      , sla_ledger_id
      , description_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , source_value
      , source_meaning
      , created_by
      , creation_date
      , last_update_date
      , last_updated_by
      , last_update_login
      , program_update_date
      , program_application_id
      , program_id
      , request_id
)
SELECT
        event_id
      , p_target_ledger_id
      , p_sla_ledger_id
      , p_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , SUBSTR(source_value ,1,1996)
      , SUBSTR(source_meaning,1,200)
      , xla_environment_pkg.g_Usr_Id
      , TRUNC(SYSDATE)
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Usr_Id
      , xla_environment_pkg.g_Login_Id
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Prog_Appl_Id
      , xla_environment_pkg.g_Prog_Id
      , xla_environment_pkg.g_Req_Id
  FROM (
       SELECT xet.event_id                  event_id
            , 0                             line_number
            , CASE r
               WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V' 
                WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V' 
                WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V' 
                WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V' 
                WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V' 
                WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V' 
                WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V' 
                WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V' 
                WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'HEADER' 
                WHEN 2 THEN 'HEADER' 
                WHEN 3 THEN 'HEADER' 
                WHEN 4 THEN 'HEADER' 
                WHEN 5 THEN 'HEADER' 
                WHEN 6 THEN 'HEADER' 
                WHEN 7 THEN 'HEADER' 
                WHEN 8 THEN 'HEADER' 
                WHEN 9 THEN 'HEADER' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '206' 
                WHEN 2 THEN '206' 
                WHEN 3 THEN '206' 
                WHEN 4 THEN '206' 
                WHEN 5 THEN '206' 
                WHEN 6 THEN '206' 
                WHEN 7 THEN '206' 
                WHEN 8 THEN '206' 
                WHEN 9 THEN '206' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'LOAN_CLASS_CODE' 
                WHEN 2 THEN 'LOAN_TYPE' 
                WHEN 3 THEN 'LOAN_NUMBER' 
                WHEN 4 THEN 'LOAN_CURRENCY' 
                WHEN 5 THEN 'EXCHANGE_DATE' 
                WHEN 6 THEN 'EXCHANGE_RATE' 
                WHEN 7 THEN 'EXCHANGE_RATE_TYPE' 
                WHEN 8 THEN 'SUBSIDY_COST' 
                WHEN 9 THEN 'GL_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h2.LOAN_CLASS_CODE)
                WHEN 2 THEN TO_CHAR(h2.LOAN_TYPE)
                WHEN 3 THEN TO_CHAR(h2.LOAN_NUMBER)
                WHEN 4 THEN TO_CHAR(h2.LOAN_CURRENCY)
                WHEN 5 THEN TO_CHAR(h2.EXCHANGE_DATE)
                WHEN 6 THEN TO_CHAR(h2.EXCHANGE_RATE)
                WHEN 7 THEN TO_CHAR(h2.EXCHANGE_RATE_TYPE)
                WHEN 8 THEN TO_CHAR(h2.SUBSIDY_COST)
                WHEN 9 THEN TO_CHAR(h2.GL_DATE)
                
                ELSE null
              END                           source_value
            , CASE r
                WHEN 1 THEN fvl1.meaning
                WHEN 4 THEN fvl15.meaning
                
                ELSE null
              END               source_meaning
        FROM xla_events_gt     xet  
      , LNS_LOAN_HEADERS_EXT_V  h2
  , fnd_lookup_values    fvl1
  , fnd_lookup_values    fvl15
            ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
       WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
         AND xet.event_type_code = C_EVENT_TYPE_CODE
            AND h2.event_id = xet.event_id
   AND fvl1.lookup_type(+)         = 'LOAN_CLASS'
  AND fvl1.lookup_code(+)         = h2.LOAN_CLASS_CODE
  AND fvl1.view_application_id(+) = 206
  AND fvl1.language(+)            = USERENV('LANG')
     AND fvl15.lookup_type(+)         = 'CURRENCY_CODE'
  AND fvl15.lookup_code(+)         = h2.LOAN_CURRENCY
  AND fvl15.view_application_id(+) = 101
  AND fvl15.language(+)            = USERENV('LANG')
  
)
;

Line: 7375

         (p_msg      => 'number of header sources inserted = '||SQL%ROWCOUNT
         ,p_level    => C_LEVEL_STATEMENT
         ,p_module   => l_log_module);

Line: 7385

INSERT INTO xla_diag_sources --line1
(
        event_id
      , ledger_id
      , sla_ledger_id
      , description_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , source_value
      , source_meaning
      , created_by
      , creation_date
      , last_update_date
      , last_updated_by
      , last_update_login
      , program_update_date
      , program_application_id
      , program_id
      , request_id
)
SELECT  event_id
      , p_target_ledger_id
      , p_sla_ledger_id
      , p_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , SUBSTR(source_value,1,1996)
      , SUBSTR(source_meaning,1,200)
      , xla_environment_pkg.g_Usr_Id
      , TRUNC(SYSDATE)
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Usr_Id
      , xla_environment_pkg.g_Login_Id
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Prog_Appl_Id
      , xla_environment_pkg.g_Prog_Id
      , xla_environment_pkg.g_Req_Id
  FROM (
       SELECT xet.event_id                  event_id
            , l1.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'LINE' 
                WHEN 2 THEN 'LINE' 
                WHEN 3 THEN 'LINE' 
                WHEN 4 THEN 'LINE' 
                WHEN 5 THEN 'LINE' 
                WHEN 6 THEN 'LINE' 
                WHEN 7 THEN 'LINE' 
                WHEN 8 THEN 'LINE' 
                WHEN 9 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '206' 
                WHEN 2 THEN '206' 
                WHEN 3 THEN '206' 
                WHEN 4 THEN '206' 
                WHEN 5 THEN '206' 
                WHEN 6 THEN '206' 
                WHEN 7 THEN '206' 
                WHEN 8 THEN '206' 
                WHEN 9 THEN '206' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'ACCOUNT_NAME' 
                WHEN 2 THEN 'DERIVED_PROGRAM_ACCOUNT_BSV' 
                WHEN 3 THEN 'CODE_COMBINATION_ID' 
                WHEN 4 THEN 'LINE_TYPE' 
                WHEN 5 THEN 'ACCOUNT_TYPE' 
                WHEN 6 THEN 'EVENT_TYPE' 
                WHEN 7 THEN 'DISTRIBUTION_ID' 
                WHEN 8 THEN 'DISTRIBUTION_TYPE' 
                WHEN 9 THEN 'DISTRIBUTION_AMOUNT' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l1.ACCOUNT_NAME)
                WHEN 2 THEN TO_CHAR(l1.DERIVED_PROGRAM_ACCOUNT_BSV)
                WHEN 3 THEN TO_CHAR(l1.CODE_COMBINATION_ID)
                WHEN 4 THEN TO_CHAR(l1.LINE_TYPE)
                WHEN 5 THEN TO_CHAR(l1.ACCOUNT_TYPE)
                WHEN 6 THEN TO_CHAR(l1.EVENT_TYPE)
                WHEN 7 THEN TO_CHAR(l1.DISTRIBUTION_ID)
                WHEN 8 THEN TO_CHAR(l1.DISTRIBUTION_TYPE)
                WHEN 9 THEN TO_CHAR(l1.DISTRIBUTION_AMOUNT)
                
                ELSE null
              END                           source_value
            , CASE r
                WHEN 1 THEN fvl4.meaning
                WHEN 5 THEN fvl8.meaning
                WHEN 6 THEN fvl9.meaning
                WHEN 8 THEN fvl13.meaning
                
                ELSE null
              END               source_meaning
         FROM  xla_events_gt     xet  
        , LNS_LOAN_DETAILS_EXT_V  l1
  , fnd_lookup_values    fvl4
  , fnd_lookup_values    fvl8
  , fnd_lookup_values    fvl9
  , fnd_lookup_values    fvl13
            ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
        WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
          AND xet.event_type_code = C_EVENT_TYPE_CODE
            AND l1.event_id          = xet.event_id
   AND fvl4.lookup_type(+)         = 'LOAN_DISTRIBUTION_ACCOUNTS'
  AND fvl4.lookup_code(+)         = l1.ACCOUNT_NAME
  AND fvl4.view_application_id(+) = 206
  AND fvl4.language(+)            = USERENV('LANG')
     AND fvl8.lookup_type(+)         = 'LOAN_DISTRIBUTION_ACCOUNT_DRCR'
  AND fvl8.lookup_code(+)         = l1.ACCOUNT_TYPE
  AND fvl8.view_application_id(+) = 206
  AND fvl8.language(+)            = USERENV('LANG')
     AND fvl9.lookup_type(+)         = 'LOAN_ACCOUNTING_EVENT'
  AND fvl9.lookup_code(+)         = l1.EVENT_TYPE
  AND fvl9.view_application_id(+) = 206
  AND fvl9.language(+)            = USERENV('LANG')
     AND fvl13.lookup_type(+)         = 'LOAN_DISTRIBUTION_ACCOUNT_DRCR'
  AND fvl13.lookup_code(+)         = l1.DISTRIBUTION_TYPE
  AND fvl13.view_application_id(+) = 206
  AND fvl13.language(+)            = USERENV('LANG')
  
)
;

Line: 7540

         (p_msg      => 'number of line sources inserted = '||SQL%ROWCOUNT
         ,p_level    => C_LEVEL_STATEMENT
         ,p_module   => l_log_module);

Line: 7549

         (p_msg      => 'END of insert_sources_16'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 7570

           (p_location => 'XLA_00206_AAD_S_000004_BC_PKG.insert_sources_16');

Line: 7571

END insert_sources_16;

Line: 7713

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Type Code: FUTURE_DISBURSEMENT_CANCELLED
-- Event Class Code: DIRECT
    xet.entity_id
  , xet.legal_entity_id
  , xet.entity_code
  , xet.transaction_number
  , xet.event_id
  , xet.event_class_code
  , xet.event_type_code
  , xet.event_number
  , xet.event_date
  , xet.transaction_date
  , xet.reference_num_1
  , xet.reference_num_2
  , xet.reference_num_3
  , xet.reference_num_4
  , xet.reference_char_1
  , xet.reference_char_2
  , xet.reference_char_3
  , xet.reference_char_4
  , xet.reference_date_1
  , xet.reference_date_2
  , xet.reference_date_3
  , xet.reference_date_4
  , xet.event_created_by
  , xet.budgetary_control_flag 
  , h2.LOAN_CLASS_CODE    source_1
  , fvl1.meaning   source_1_meaning
  , h2.LOAN_TYPE    source_2
  , h2.LOAN_NUMBER    source_3
  , h2.LOAN_CURRENCY    source_15
  , fvl15.meaning   source_15_meaning
  , h2.EXCHANGE_DATE    source_16
  , h2.EXCHANGE_RATE    source_17
  , h2.EXCHANGE_RATE_TYPE    source_18
  , h2.SUBSIDY_COST    source_19
  , h2.GL_DATE    source_20
  FROM xla_events_gt     xet 
  , LNS_LOAN_HEADERS_EXT_V  h2
  , fnd_lookup_values    fvl1
  , fnd_lookup_values    fvl15
 WHERE xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_type_code = C_EVENT_TYPE_CODE
   and xet.event_status_code <> 'N'  AND h2.event_id = xet.event_id
   AND fvl1.lookup_type(+)         = 'LOAN_CLASS'
  AND fvl1.lookup_code(+)         = h2.LOAN_CLASS_CODE
  AND fvl1.view_application_id(+) = 206
  AND fvl1.language(+)            = USERENV('LANG')
     AND fvl15.lookup_type(+)         = 'CURRENCY_CODE'
  AND fvl15.lookup_code(+)         = h2.LOAN_CURRENCY
  AND fvl15.view_application_id(+) = 101
  AND fvl15.language(+)            = USERENV('LANG')
  
 ORDER BY event_id
;

Line: 7774

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Type Code: FUTURE_DISBURSEMENT_CANCELLED
-- Event Class Code: DIRECT
    xet.entity_id
   ,xet.legal_entity_id
   ,xet.entity_code
   ,xet.transaction_number
   ,xet.event_id
   ,xet.event_class_code
   ,xet.event_type_code
   ,xet.event_number
   ,xet.event_date
   ,xet.transaction_date
   ,xet.reference_num_1
   ,xet.reference_num_2
   ,xet.reference_num_3
   ,xet.reference_num_4
   ,xet.reference_char_1
   ,xet.reference_char_2
   ,xet.reference_char_3
   ,xet.reference_char_4
   ,xet.reference_date_1
   ,xet.reference_date_2
   ,xet.reference_date_3
   ,xet.reference_date_4
   ,xet.event_created_by
   ,xet.budgetary_control_flag  , l1.LINE_NUMBER  
  , l1.ACCOUNT_NAME    source_4
  , fvl4.meaning   source_4_meaning
  , l1.DERIVED_PROGRAM_ACCOUNT_BSV    source_5
  , l1.CODE_COMBINATION_ID    source_6
  , l1.LINE_TYPE    source_7
  , l1.ACCOUNT_TYPE    source_8
  , fvl8.meaning   source_8_meaning
  , l1.EVENT_TYPE    source_9
  , fvl9.meaning   source_9_meaning
  , l1.DISTRIBUTION_ID    source_12
  , l1.DISTRIBUTION_TYPE    source_13
  , fvl13.meaning   source_13_meaning
  , l1.DISTRIBUTION_AMOUNT    source_14
  FROM xla_events_gt     xet 
  , LNS_LOAN_DETAILS_EXT_V  l1
  , fnd_lookup_values    fvl4
  , fnd_lookup_values    fvl8
  , fnd_lookup_values    fvl9
  , fnd_lookup_values    fvl13
 WHERE xet.event_id between x_first_event_id and x_last_event_id
   and xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_type_code = C_EVENT_TYPE_CODE
   and xet.event_status_code <> 'N'   AND l1.event_id      = xet.event_id
   AND fvl4.lookup_type(+)         = 'LOAN_DISTRIBUTION_ACCOUNTS'
  AND fvl4.lookup_code(+)         = l1.ACCOUNT_NAME
  AND fvl4.view_application_id(+) = 206
  AND fvl4.language(+)            = USERENV('LANG')
     AND fvl8.lookup_type(+)         = 'LOAN_DISTRIBUTION_ACCOUNT_DRCR'
  AND fvl8.lookup_code(+)         = l1.ACCOUNT_TYPE
  AND fvl8.view_application_id(+) = 206
  AND fvl8.language(+)            = USERENV('LANG')
     AND fvl9.lookup_type(+)         = 'LOAN_ACCOUNTING_EVENT'
  AND fvl9.lookup_code(+)         = l1.EVENT_TYPE
  AND fvl9.view_application_id(+) = 206
  AND fvl9.language(+)            = USERENV('LANG')
     AND fvl13.lookup_type(+)         = 'LOAN_DISTRIBUTION_ACCOUNT_DRCR'
  AND fvl13.lookup_code(+)         = l1.DISTRIBUTION_TYPE
  AND fvl13.view_application_id(+) = 206
  AND fvl13.language(+)            = USERENV('LANG')
  ;

Line: 7868

g_array_event.DELETE;

Line: 8103

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

Line: 8124

   l_result := XLA_AE_LINES_PKG.InsertLines;

Line: 8513

l_result := XLA_AE_LINES_PKG.InsertLines ;

Line: 8521

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;

Line: 8645

         insert_sources_15(
                          p_target_ledger_id => p_target_ledger_id
                        , p_language         => l_language
                        , p_sla_ledger_id    => l_sla_ledger_id
                        , p_pad_start_date   => p_pad_start_date
                        , p_pad_end_date     => p_pad_end_date
                          );

Line: 8679

         insert_sources_16(
                          p_target_ledger_id => p_target_ledger_id
                        , p_language         => l_language
                        , p_sla_ledger_id    => l_sla_ledger_id
                        , p_pad_start_date   => p_pad_start_date
                        , p_pad_end_date     => p_pad_end_date
                          );