eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_08901_AAD_S_000002_BC_PKG SQL Statements

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

Line: 1674


   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: 1744


      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: 2231


   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: 2301


      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: 2788


   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: 2858


      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: 3345


   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: 3415


      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: 3912


   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: 3982


      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: 4479


   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: 4549


      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: 4589


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)  := 'BUDGET_EXECUTION_ALL';

Line: 4604


      l_log_module := C_DEFAULT_MODULE||'.insert_sources_15';

Line: 4609


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

Line: 4616


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

Line: 4636


INSERT INTO xla_diag_sources --hdr2
(
        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 'FV_BE_BA_FD_HDR_V' 
                WHEN 2 THEN 'FV_BE_BA_FD_HDR_V' 
                WHEN 3 THEN 'FV_BE_BA_FD_HDR_V' 
                WHEN 4 THEN 'FV_BE_BA_FD_HDR_V' 
                WHEN 5 THEN 'FV_BE_BA_FD_HDR_V' 
                WHEN 6 THEN 'FV_BE_BA_FD_HDR_V' 
                WHEN 7 THEN 'FV_BE_BA_FD_HDR_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '8901' 
                WHEN 2 THEN '8901' 
                WHEN 3 THEN '8901' 
                WHEN 4 THEN '8901' 
                WHEN 5 THEN '8901' 
                WHEN 6 THEN '8901' 
                WHEN 7 THEN '8901' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'DOC_NUMBER' 
                WHEN 2 THEN 'BUDGET_LEVEL_ID' 
                WHEN 3 THEN 'DISTRIBUTION_ACCOUNT' 
                WHEN 4 THEN 'SOURCE' 
                WHEN 5 THEN 'CURRENCY_CODE' 
                WHEN 6 THEN 'DOC_ID' 
                WHEN 7 THEN 'GL_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h2.DOC_NUMBER)
                WHEN 2 THEN TO_CHAR(h2.BUDGET_LEVEL_ID)
                WHEN 3 THEN TO_CHAR(h2.DISTRIBUTION_ACCOUNT)
                WHEN 4 THEN TO_CHAR(h2.SOURCE)
                WHEN 5 THEN TO_CHAR(h2.CURRENCY_CODE)
                WHEN 6 THEN TO_CHAR(h2.DOC_ID)
                WHEN 7 THEN TO_CHAR(h2.GL_DATE)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , FV_BE_BA_FD_HDR_V  h2
             ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
         WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
           AND xet.event_class_code = C_EVENT_CLASS_CODE
              AND h2.event_id = xet.event_id

)
;

Line: 4755


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

Line: 4765


INSERT INTO xla_diag_sources  --line2
(
        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 'FV_BE_BA_FD_DTL_V' 
                WHEN 2 THEN 'FV_BE_BA_FD_DTL_V' 
                WHEN 3 THEN 'FV_BE_BA_FD_DTL_V' 
                WHEN 4 THEN 'FV_BE_BA_FD_DTL_V' 
                WHEN 5 THEN 'FV_BE_BA_FD_DTL_V' 
                WHEN 6 THEN 'FV_BE_BA_FD_DTL_V' 
                WHEN 7 THEN 'FV_BE_BA_FD_DTL_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '8901' 
                WHEN 2 THEN '8901' 
                WHEN 3 THEN '8901' 
                WHEN 4 THEN '8901' 
                WHEN 5 THEN '8901' 
                WHEN 6 THEN '8901' 
                WHEN 7 THEN '8901' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'CR_ACCOUNT_SEGMENT_VALUE' 
                WHEN 2 THEN 'DR_ACCOUNT_SEGMENT_VALUE' 
                WHEN 3 THEN 'INCREASE_DECREASE_FLAG' 
                WHEN 4 THEN 'FUND_DISTRIBUTION_ACCOUNT' 
                WHEN 5 THEN 'TRANSACTION_TYPE' 
                WHEN 6 THEN 'TRANSACTION_TYPE_ID' 
                WHEN 7 THEN 'ACCOUNTED_AMOUNT' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l1.CR_ACCOUNT_SEGMENT_VALUE)
                WHEN 2 THEN TO_CHAR(l1.DR_ACCOUNT_SEGMENT_VALUE)
                WHEN 3 THEN TO_CHAR(l1.INCREASE_DECREASE_FLAG)
                WHEN 4 THEN TO_CHAR(l1.FUND_DISTRIBUTION_ACCOUNT)
                WHEN 5 THEN TO_CHAR(l1.TRANSACTION_TYPE)
                WHEN 6 THEN TO_CHAR(l1.TRANSACTION_TYPE_ID)
                WHEN 7 THEN TO_CHAR(l1.ACCOUNTED_AMOUNT)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , FV_BE_BA_FD_DTL_V  l1
            , (select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
        WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
          AND xet.event_class_code = C_EVENT_CLASS_CODE
            AND l1.event_id          = xet.event_id

)
;

Line: 4883


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

Line: 4892


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

Line: 4913


           (p_location => 'XLA_08901_AAD_S_000002_BC_PKG.insert_sources_15');

Line: 4914


END insert_sources_15;

Line: 5042


SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: BUDGET_EXECUTION
    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.DOC_NUMBER    source_1
  , h2.BUDGET_LEVEL_ID    source_2
  , h2.DISTRIBUTION_ACCOUNT    source_8
  , h2.SOURCE    source_10
  , h2.CURRENCY_CODE    source_15
  , h2.DOC_ID    source_16
  , h2.GL_DATE    source_17
  FROM xla_events_gt     xet 
  , FV_BE_BA_FD_HDR_V  h2
 WHERE xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_class_code = C_EVENT_CLASS_CODE
   and xet.event_status_code <> 'N'  AND h2.event_id = xet.event_id

 ORDER BY event_id
;

Line: 5088


SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: BUDGET_EXECUTION
    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.CR_ACCOUNT_SEGMENT_VALUE    source_3
  , l1.DR_ACCOUNT_SEGMENT_VALUE    source_4
  , l1.INCREASE_DECREASE_FLAG    source_5
  , l1.FUND_DISTRIBUTION_ACCOUNT    source_9
  , l1.TRANSACTION_TYPE    source_12
  , l1.TRANSACTION_TYPE_ID    source_13
  , l1.ACCOUNTED_AMOUNT    source_14
  FROM xla_events_gt     xet 
  , FV_BE_BA_FD_DTL_V  l1
 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_class_code = C_EVENT_CLASS_CODE
   and xet.event_status_code <> 'N'   AND l1.event_id      = xet.event_id
;

Line: 5156


g_array_event.DELETE;

Line: 5371


XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

Line: 5392


   l_result := XLA_AE_LINES_PKG.InsertLines;

Line: 5691


l_result := XLA_AE_LINES_PKG.InsertLines ;

Line: 5699


l_result := XLA_AE_HEADER_PKG.InsertHeaders ;

Line: 5755


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)  := 'RPR_BUDGET_EXECUTION_ALL';

Line: 5770


      l_log_module := C_DEFAULT_MODULE||'.insert_sources_16';

Line: 5775


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

Line: 5782


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

Line: 5802


INSERT INTO xla_diag_sources --hdr2
(
        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 'FV_BE_RPR_HDR_V' 
                WHEN 2 THEN 'FV_BE_RPR_HDR_V' 
                WHEN 3 THEN 'FV_BE_RPR_HDR_V' 
                WHEN 4 THEN 'FV_BE_RPR_HDR_V' 
                WHEN 5 THEN 'FV_BE_RPR_HDR_V' 
                WHEN 6 THEN 'FV_BE_RPR_HDR_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '8901' 
                WHEN 2 THEN '8901' 
                WHEN 3 THEN '8901' 
                WHEN 4 THEN '8901' 
                WHEN 5 THEN '8901' 
                WHEN 6 THEN '8901' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'DOC_NUMBER' 
                WHEN 2 THEN 'BUDGET_LEVEL_ID' 
                WHEN 3 THEN 'SOURCE' 
                WHEN 4 THEN 'TRANSACTION_ID' 
                WHEN 5 THEN 'CURRENCY_CODE' 
                WHEN 6 THEN 'GL_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h2.DOC_NUMBER)
                WHEN 2 THEN TO_CHAR(h2.BUDGET_LEVEL_ID)
                WHEN 3 THEN TO_CHAR(h2.SOURCE)
                WHEN 4 THEN TO_CHAR(h2.TRANSACTION_ID)
                WHEN 5 THEN TO_CHAR(h2.CURRENCY_CODE)
                WHEN 6 THEN TO_CHAR(h2.GL_DATE)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , FV_BE_RPR_HDR_V  h2
             ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
         WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
           AND xet.event_class_code = C_EVENT_CLASS_CODE
              AND h2.event_id = xet.event_id

)
;

Line: 5916


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

Line: 5926


INSERT INTO xla_diag_sources  --line2
(
        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 'FV_BE_RPR_DTL_V' 
                WHEN 2 THEN 'FV_BE_RPR_DTL_V' 
                WHEN 3 THEN 'FV_BE_RPR_DTL_V' 
                WHEN 4 THEN 'FV_BE_RPR_DTL_V' 
                WHEN 5 THEN 'FV_BE_RPR_DTL_V' 
                WHEN 6 THEN 'FV_BE_RPR_DTL_V' 
                WHEN 7 THEN 'FV_BE_RPR_DTL_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '8901' 
                WHEN 2 THEN '8901' 
                WHEN 3 THEN '8901' 
                WHEN 4 THEN '8901' 
                WHEN 5 THEN '8901' 
                WHEN 6 THEN '8901' 
                WHEN 7 THEN '8901' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'CR_ACCOUNT_SEGMENT_VALUE' 
                WHEN 2 THEN 'DR_ACCOUNT_SEGMENT_VALUE' 
                WHEN 3 THEN 'DISTRIBUTION_FROM_ACCOUNT' 
                WHEN 4 THEN 'DISTRIBUTION_TO_ACCOUNT' 
                WHEN 5 THEN 'TRANSACTION_TYPE' 
                WHEN 6 THEN 'TRANSACTION_TYPE_ID' 
                WHEN 7 THEN 'ACCOUNTED_AMOUNT' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l1.CR_ACCOUNT_SEGMENT_VALUE)
                WHEN 2 THEN TO_CHAR(l1.DR_ACCOUNT_SEGMENT_VALUE)
                WHEN 3 THEN TO_CHAR(l1.DISTRIBUTION_FROM_ACCOUNT)
                WHEN 4 THEN TO_CHAR(l1.DISTRIBUTION_TO_ACCOUNT)
                WHEN 5 THEN TO_CHAR(l1.TRANSACTION_TYPE)
                WHEN 6 THEN TO_CHAR(l1.TRANSACTION_TYPE_ID)
                WHEN 7 THEN TO_CHAR(l1.ACCOUNTED_AMOUNT)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , FV_BE_RPR_DTL_V  l1
            , (select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
        WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
          AND xet.event_class_code = C_EVENT_CLASS_CODE
            AND l1.event_id          = xet.event_id

)
;

Line: 6044


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

Line: 6053


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

Line: 6074


           (p_location => 'XLA_08901_AAD_S_000002_BC_PKG.insert_sources_16');

Line: 6075


END insert_sources_16;

Line: 6201


SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RPR_BUDGET_EXECUTION
    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.DOC_NUMBER    source_1
  , h2.BUDGET_LEVEL_ID    source_2
  , h2.SOURCE    source_10
  , h2.TRANSACTION_ID    source_11
  , h2.CURRENCY_CODE    source_15
  , h2.GL_DATE    source_17
  FROM xla_events_gt     xet 
  , FV_BE_RPR_HDR_V  h2
 WHERE xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_class_code = C_EVENT_CLASS_CODE
   and xet.event_status_code <> 'N'  AND h2.event_id = xet.event_id

 ORDER BY event_id
;

Line: 6246


SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RPR_BUDGET_EXECUTION
    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.CR_ACCOUNT_SEGMENT_VALUE    source_3
  , l1.DR_ACCOUNT_SEGMENT_VALUE    source_4
  , l1.DISTRIBUTION_FROM_ACCOUNT    source_6
  , l1.DISTRIBUTION_TO_ACCOUNT    source_7
  , l1.TRANSACTION_TYPE    source_12
  , l1.TRANSACTION_TYPE_ID    source_13
  , l1.ACCOUNTED_AMOUNT    source_14
  FROM xla_events_gt     xet 
  , FV_BE_RPR_DTL_V  l1
 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_class_code = C_EVENT_CLASS_CODE
   and xet.event_status_code <> 'N'   AND l1.event_id      = xet.event_id
;

Line: 6314


g_array_event.DELETE;

Line: 6527


XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

Line: 6548


   l_result := XLA_AE_LINES_PKG.InsertLines;

Line: 6897


l_result := XLA_AE_LINES_PKG.InsertLines ;

Line: 6905


l_result := XLA_AE_HEADER_PKG.InsertHeaders ;

Line: 7029


         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: 7063


         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
                          );