APPS.XLA_08407_AAD_S_000013_BC_PKG SQL Statements

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

Line: 947

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

PROCEDURE insert_sources_18(
                                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)  := 'CC_CONTRACT_CMT_ALL';

Line: 7737

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_18';

Line: 7742

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

Line: 7749

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

Line: 7769

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 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '8407' 
                WHEN 2 THEN '8407' 
                WHEN 3 THEN '8407' 
                WHEN 4 THEN '8407' 
                WHEN 5 THEN '8407' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'HEADER_DESC' 
                WHEN 2 THEN 'REFERENCE_4' 
                WHEN 3 THEN 'REFERENCE_3' 
                WHEN 4 THEN 'DOCUMENT_TYPE' 
                WHEN 5 THEN 'ACCOUNTING_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h1.HEADER_DESC)
                WHEN 2 THEN TO_CHAR(h1.REFERENCE_4)
                WHEN 3 THEN TO_CHAR(h1.REFERENCE_3)
                WHEN 4 THEN TO_CHAR(h1.DOCUMENT_TYPE)
                WHEN 5 THEN TO_CHAR(h1.ACCOUNTING_DATE)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , IGC_CC_EVENT_JE_HEADER_V  h1
             ,(select rownum r from all_objects where rownum <= 5 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 h1.event_id = xet.event_id

)
;

Line: 7878

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

Line: 7888

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
            , l2.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 8 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 9 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 10 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 11 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 12 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 13 THEN 'IGC_CC_EVENT_JE_LINES_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' 
                WHEN 11 THEN 'LINE' 
                WHEN 12 THEN 'LINE' 
                WHEN 13 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '8407' 
                WHEN 2 THEN '8407' 
                WHEN 3 THEN '8407' 
                WHEN 4 THEN '8407' 
                WHEN 5 THEN '8407' 
                WHEN 6 THEN '8407' 
                WHEN 7 THEN '8407' 
                WHEN 8 THEN '8407' 
                WHEN 9 THEN '8407' 
                WHEN 10 THEN '8407' 
                WHEN 11 THEN '8407' 
                WHEN 12 THEN '8407' 
                WHEN 13 THEN '8407' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'TRANSACTION_DESCRIPTION' 
                WHEN 2 THEN 'CODE_COMBINATION_ID' 
                WHEN 3 THEN 'CC_FUNC_CR_AMT' 
                WHEN 4 THEN 'PROJECT_LINE' 
                WHEN 5 THEN 'CC_ACCT_LINE_ID' 
                WHEN 6 THEN 'CC_FUNC_AMT' 
                WHEN 7 THEN 'CURRENCY_CODE' 
                WHEN 8 THEN 'CC_FUNC_DR_AMT' 
                WHEN 9 THEN 'APPLIED_TO_APPL_ID' 
                WHEN 10 THEN 'APPLIED_TO_DIST_LINK_TYPE' 
                WHEN 11 THEN 'APPLIED_TO_ENTITY_CODE' 
                WHEN 12 THEN 'APPLIED_TO_DIST_ID_1' 
                WHEN 13 THEN 'APPLIED_TO_HEADER_ID_1' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l2.TRANSACTION_DESCRIPTION)
                WHEN 2 THEN TO_CHAR(l2.CODE_COMBINATION_ID)
                WHEN 3 THEN TO_CHAR(l2.CC_FUNC_CR_AMT)
                WHEN 4 THEN TO_CHAR(l2.PROJECT_LINE)
                WHEN 5 THEN TO_CHAR(l2.CC_ACCT_LINE_ID)
                WHEN 6 THEN TO_CHAR(l2.CC_FUNC_AMT)
                WHEN 7 THEN TO_CHAR(l2.CURRENCY_CODE)
                WHEN 8 THEN TO_CHAR(l2.CC_FUNC_DR_AMT)
                WHEN 9 THEN TO_CHAR(l2.APPLIED_TO_APPL_ID)
                WHEN 10 THEN TO_CHAR(l2.APPLIED_TO_DIST_LINK_TYPE)
                WHEN 11 THEN TO_CHAR(l2.APPLIED_TO_ENTITY_CODE)
                WHEN 12 THEN TO_CHAR(l2.APPLIED_TO_DIST_ID_1)
                WHEN 13 THEN TO_CHAR(l2.APPLIED_TO_HEADER_ID_1)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , IGC_CC_EVENT_JE_LINES_V  l2
            , (select rownum r from all_objects where rownum <= 13 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 l2.event_id          = xet.event_id

)
;

Line: 8036

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

Line: 8045

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

Line: 8066

           (p_location => 'XLA_08407_AAD_S_000013_BC_PKG.insert_sources_18');

Line: 8067

END insert_sources_18;

Line: 8203

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CC_CONTRACT_CMT
    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 
  , h1.HEADER_DESC    source_2
  , h1.REFERENCE_4    source_3
  , h1.REFERENCE_3    source_4
  , h1.DOCUMENT_TYPE    source_9
  , h1.ACCOUNTING_DATE    source_18
  FROM xla_events_gt     xet 
  , IGC_CC_EVENT_JE_HEADER_V  h1
 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 h1.event_id = xet.event_id

 ORDER BY event_id
;

Line: 8247

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CC_CONTRACT_CMT
    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
 , l2.LINE_NUMBER  
  , l2.TRANSACTION_DESCRIPTION    source_1
  , l2.CODE_COMBINATION_ID    source_5
  , l2.CC_FUNC_CR_AMT    source_6
  , l2.PROJECT_LINE    source_7
  , l2.CC_ACCT_LINE_ID    source_8
  , l2.CC_FUNC_AMT    source_10
  , l2.CURRENCY_CODE    source_11
  , l2.CC_FUNC_DR_AMT    source_12
  , l2.APPLIED_TO_APPL_ID    source_13
  , l2.APPLIED_TO_DIST_LINK_TYPE    source_14
  , l2.APPLIED_TO_ENTITY_CODE    source_15
  , l2.APPLIED_TO_DIST_ID_1    source_16
  , l2.APPLIED_TO_HEADER_ID_1    source_17
  FROM xla_events_gt     xet 
  , IGC_CC_EVENT_JE_LINES_V  l2
 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 l2.event_id      = xet.event_id
;

Line: 8321

g_array_event.DELETE;

Line: 8543

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

Line: 8564

   l_result := XLA_AE_LINES_PKG.InsertLines;

Line: 8916

l_result := XLA_AE_LINES_PKG.InsertLines ;

Line: 8924

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;

Line: 8980

PROCEDURE insert_sources_19(
                                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)  := 'CC_CONTRACT_PRO_ALL';

Line: 8995

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_19';

Line: 9000

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

Line: 9007

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

Line: 9027

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 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '8407' 
                WHEN 2 THEN '8407' 
                WHEN 3 THEN '8407' 
                WHEN 4 THEN '8407' 
                WHEN 5 THEN '8407' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'HEADER_DESC' 
                WHEN 2 THEN 'REFERENCE_4' 
                WHEN 3 THEN 'REFERENCE_3' 
                WHEN 4 THEN 'DOCUMENT_TYPE' 
                WHEN 5 THEN 'ACCOUNTING_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h1.HEADER_DESC)
                WHEN 2 THEN TO_CHAR(h1.REFERENCE_4)
                WHEN 3 THEN TO_CHAR(h1.REFERENCE_3)
                WHEN 4 THEN TO_CHAR(h1.DOCUMENT_TYPE)
                WHEN 5 THEN TO_CHAR(h1.ACCOUNTING_DATE)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , IGC_CC_EVENT_JE_HEADER_V  h1
             ,(select rownum r from all_objects where rownum <= 5 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 h1.event_id = xet.event_id

)
;

Line: 9136

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

Line: 9146

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
            , l2.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 8 THEN 'IGC_CC_EVENT_JE_LINES_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '8407' 
                WHEN 2 THEN '8407' 
                WHEN 3 THEN '8407' 
                WHEN 4 THEN '8407' 
                WHEN 5 THEN '8407' 
                WHEN 6 THEN '8407' 
                WHEN 7 THEN '8407' 
                WHEN 8 THEN '8407' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'TRANSACTION_DESCRIPTION' 
                WHEN 2 THEN 'CODE_COMBINATION_ID' 
                WHEN 3 THEN 'CC_FUNC_CR_AMT' 
                WHEN 4 THEN 'PROJECT_LINE' 
                WHEN 5 THEN 'CC_ACCT_LINE_ID' 
                WHEN 6 THEN 'CC_FUNC_AMT' 
                WHEN 7 THEN 'CURRENCY_CODE' 
                WHEN 8 THEN 'CC_FUNC_DR_AMT' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l2.TRANSACTION_DESCRIPTION)
                WHEN 2 THEN TO_CHAR(l2.CODE_COMBINATION_ID)
                WHEN 3 THEN TO_CHAR(l2.CC_FUNC_CR_AMT)
                WHEN 4 THEN TO_CHAR(l2.PROJECT_LINE)
                WHEN 5 THEN TO_CHAR(l2.CC_ACCT_LINE_ID)
                WHEN 6 THEN TO_CHAR(l2.CC_FUNC_AMT)
                WHEN 7 THEN TO_CHAR(l2.CURRENCY_CODE)
                WHEN 8 THEN TO_CHAR(l2.CC_FUNC_DR_AMT)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , IGC_CC_EVENT_JE_LINES_V  l2
            , (select rownum r from all_objects where rownum <= 8 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 l2.event_id          = xet.event_id

)
;

Line: 9269

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

Line: 9278

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

Line: 9299

           (p_location => 'XLA_08407_AAD_S_000013_BC_PKG.insert_sources_19');

Line: 9300

END insert_sources_19;

Line: 9426

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CC_CONTRACT_PRO
    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 
  , h1.HEADER_DESC    source_2
  , h1.REFERENCE_4    source_3
  , h1.REFERENCE_3    source_4
  , h1.DOCUMENT_TYPE    source_9
  , h1.ACCOUNTING_DATE    source_18
  FROM xla_events_gt     xet 
  , IGC_CC_EVENT_JE_HEADER_V  h1
 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 h1.event_id = xet.event_id

 ORDER BY event_id
;

Line: 9470

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CC_CONTRACT_PRO
    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
 , l2.LINE_NUMBER  
  , l2.TRANSACTION_DESCRIPTION    source_1
  , l2.CODE_COMBINATION_ID    source_5
  , l2.CC_FUNC_CR_AMT    source_6
  , l2.PROJECT_LINE    source_7
  , l2.CC_ACCT_LINE_ID    source_8
  , l2.CC_FUNC_AMT    source_10
  , l2.CURRENCY_CODE    source_11
  , l2.CC_FUNC_DR_AMT    source_12
  FROM xla_events_gt     xet 
  , IGC_CC_EVENT_JE_LINES_V  l2
 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 l2.event_id      = xet.event_id
;

Line: 9539

g_array_event.DELETE;

Line: 9761

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

Line: 9782

   l_result := XLA_AE_LINES_PKG.InsertLines;

Line: 10124

l_result := XLA_AE_LINES_PKG.InsertLines ;

Line: 10132

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;

Line: 10188

PROCEDURE insert_sources_20(
                                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)  := 'CC_PROJECT_BUDGET_ALL';

Line: 10203

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_20';

Line: 10208

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

Line: 10215

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

Line: 10235

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 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '8407' 
                WHEN 2 THEN '8407' 
                WHEN 3 THEN '8407' 
                WHEN 4 THEN '8407' 
                WHEN 5 THEN '8407' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'HEADER_DESC' 
                WHEN 2 THEN 'REFERENCE_4' 
                WHEN 3 THEN 'REFERENCE_3' 
                WHEN 4 THEN 'DOCUMENT_TYPE' 
                WHEN 5 THEN 'ACCOUNTING_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h1.HEADER_DESC)
                WHEN 2 THEN TO_CHAR(h1.REFERENCE_4)
                WHEN 3 THEN TO_CHAR(h1.REFERENCE_3)
                WHEN 4 THEN TO_CHAR(h1.DOCUMENT_TYPE)
                WHEN 5 THEN TO_CHAR(h1.ACCOUNTING_DATE)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , IGC_CC_EVENT_JE_HEADER_V  h1
             ,(select rownum r from all_objects where rownum <= 5 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 h1.event_id = xet.event_id

)
;

Line: 10344

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

Line: 10354

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
            , l2.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_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 '8407' 
                WHEN 2 THEN '8407' 
                WHEN 3 THEN '8407' 
                WHEN 4 THEN '8407' 
                WHEN 5 THEN '8407' 
                WHEN 6 THEN '8407' 
                WHEN 7 THEN '8407' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'TRANSACTION_DESCRIPTION' 
                WHEN 2 THEN 'CODE_COMBINATION_ID' 
                WHEN 3 THEN 'CC_FUNC_CR_AMT' 
                WHEN 4 THEN 'CC_ACCT_LINE_ID' 
                WHEN 5 THEN 'CC_FUNC_AMT' 
                WHEN 6 THEN 'CURRENCY_CODE' 
                WHEN 7 THEN 'CC_FUNC_DR_AMT' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l2.TRANSACTION_DESCRIPTION)
                WHEN 2 THEN TO_CHAR(l2.CODE_COMBINATION_ID)
                WHEN 3 THEN TO_CHAR(l2.CC_FUNC_CR_AMT)
                WHEN 4 THEN TO_CHAR(l2.CC_ACCT_LINE_ID)
                WHEN 5 THEN TO_CHAR(l2.CC_FUNC_AMT)
                WHEN 6 THEN TO_CHAR(l2.CURRENCY_CODE)
                WHEN 7 THEN TO_CHAR(l2.CC_FUNC_DR_AMT)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , IGC_CC_EVENT_JE_LINES_V  l2
            , (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 l2.event_id          = xet.event_id

)
;

Line: 10472

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

Line: 10481

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

Line: 10502

           (p_location => 'XLA_08407_AAD_S_000013_BC_PKG.insert_sources_20');

Line: 10503

END insert_sources_20;

Line: 10627

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CC_PROJECT_BUDGET
    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 
  , h1.HEADER_DESC    source_2
  , h1.REFERENCE_4    source_3
  , h1.REFERENCE_3    source_4
  , h1.DOCUMENT_TYPE    source_9
  , h1.ACCOUNTING_DATE    source_18
  FROM xla_events_gt     xet 
  , IGC_CC_EVENT_JE_HEADER_V  h1
 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 h1.event_id = xet.event_id

 ORDER BY event_id
;

Line: 10671

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CC_PROJECT_BUDGET
    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
 , l2.LINE_NUMBER  
  , l2.TRANSACTION_DESCRIPTION    source_1
  , l2.CODE_COMBINATION_ID    source_5
  , l2.CC_FUNC_CR_AMT    source_6
  , l2.CC_ACCT_LINE_ID    source_8
  , l2.CC_FUNC_AMT    source_10
  , l2.CURRENCY_CODE    source_11
  , l2.CC_FUNC_DR_AMT    source_12
  FROM xla_events_gt     xet 
  , IGC_CC_EVENT_JE_LINES_V  l2
 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 l2.event_id      = xet.event_id
;

Line: 10739

g_array_event.DELETE;

Line: 10961

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

Line: 10982

   l_result := XLA_AE_LINES_PKG.InsertLines;

Line: 11269

l_result := XLA_AE_LINES_PKG.InsertLines ;

Line: 11277

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;

Line: 11333

PROCEDURE insert_sources_21(
                                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)  := 'CC_PURCHASE_ORDERS_ALL';

Line: 11348

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_21';

Line: 11353

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

Line: 11360

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

Line: 11380

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 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '8407' 
                WHEN 2 THEN '8407' 
                WHEN 3 THEN '8407' 
                WHEN 4 THEN '8407' 
                WHEN 5 THEN '8407' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'HEADER_DESC' 
                WHEN 2 THEN 'REFERENCE_4' 
                WHEN 3 THEN 'REFERENCE_3' 
                WHEN 4 THEN 'DOCUMENT_TYPE' 
                WHEN 5 THEN 'ACCOUNTING_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h1.HEADER_DESC)
                WHEN 2 THEN TO_CHAR(h1.REFERENCE_4)
                WHEN 3 THEN TO_CHAR(h1.REFERENCE_3)
                WHEN 4 THEN TO_CHAR(h1.DOCUMENT_TYPE)
                WHEN 5 THEN TO_CHAR(h1.ACCOUNTING_DATE)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , IGC_CC_EVENT_JE_HEADER_V  h1
             ,(select rownum r from all_objects where rownum <= 5 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 h1.event_id = xet.event_id

)
;

Line: 11489

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

Line: 11499

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
            , l2.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_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 '8407' 
                WHEN 2 THEN '8407' 
                WHEN 3 THEN '8407' 
                WHEN 4 THEN '8407' 
                WHEN 5 THEN '8407' 
                WHEN 6 THEN '8407' 
                WHEN 7 THEN '8407' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'TRANSACTION_DESCRIPTION' 
                WHEN 2 THEN 'CODE_COMBINATION_ID' 
                WHEN 3 THEN 'CC_FUNC_CR_AMT' 
                WHEN 4 THEN 'CC_ACCT_LINE_ID' 
                WHEN 5 THEN 'CC_FUNC_AMT' 
                WHEN 6 THEN 'CURRENCY_CODE' 
                WHEN 7 THEN 'CC_FUNC_DR_AMT' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l2.TRANSACTION_DESCRIPTION)
                WHEN 2 THEN TO_CHAR(l2.CODE_COMBINATION_ID)
                WHEN 3 THEN TO_CHAR(l2.CC_FUNC_CR_AMT)
                WHEN 4 THEN TO_CHAR(l2.CC_ACCT_LINE_ID)
                WHEN 5 THEN TO_CHAR(l2.CC_FUNC_AMT)
                WHEN 6 THEN TO_CHAR(l2.CURRENCY_CODE)
                WHEN 7 THEN TO_CHAR(l2.CC_FUNC_DR_AMT)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , IGC_CC_EVENT_JE_LINES_V  l2
            , (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 l2.event_id          = xet.event_id

)
;

Line: 11617

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

Line: 11626

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

Line: 11647

           (p_location => 'XLA_08407_AAD_S_000013_BC_PKG.insert_sources_21');

Line: 11648

END insert_sources_21;

Line: 11772

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CC_PURCHASE_ORDERS
    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 
  , h1.HEADER_DESC    source_2
  , h1.REFERENCE_4    source_3
  , h1.REFERENCE_3    source_4
  , h1.DOCUMENT_TYPE    source_9
  , h1.ACCOUNTING_DATE    source_18
  FROM xla_events_gt     xet 
  , IGC_CC_EVENT_JE_HEADER_V  h1
 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 h1.event_id = xet.event_id

 ORDER BY event_id
;

Line: 11816

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CC_PURCHASE_ORDERS
    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
 , l2.LINE_NUMBER  
  , l2.TRANSACTION_DESCRIPTION    source_1
  , l2.CODE_COMBINATION_ID    source_5
  , l2.CC_FUNC_CR_AMT    source_6
  , l2.CC_ACCT_LINE_ID    source_8
  , l2.CC_FUNC_AMT    source_10
  , l2.CURRENCY_CODE    source_11
  , l2.CC_FUNC_DR_AMT    source_12
  FROM xla_events_gt     xet 
  , IGC_CC_EVENT_JE_LINES_V  l2
 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 l2.event_id      = xet.event_id
;

Line: 11884

g_array_event.DELETE;

Line: 12106

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

Line: 12127

   l_result := XLA_AE_LINES_PKG.InsertLines;

Line: 12414

l_result := XLA_AE_LINES_PKG.InsertLines ;

Line: 12422

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;

Line: 12478

PROCEDURE insert_sources_22(
                                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)  := 'CC_REQUISITIONS_ALL';

Line: 12493

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_22';

Line: 12498

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

Line: 12505

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

Line: 12525

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 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V' 
                WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '8407' 
                WHEN 2 THEN '8407' 
                WHEN 3 THEN '8407' 
                WHEN 4 THEN '8407' 
                WHEN 5 THEN '8407' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'HEADER_DESC' 
                WHEN 2 THEN 'REFERENCE_4' 
                WHEN 3 THEN 'REFERENCE_3' 
                WHEN 4 THEN 'DOCUMENT_TYPE' 
                WHEN 5 THEN 'ACCOUNTING_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h1.HEADER_DESC)
                WHEN 2 THEN TO_CHAR(h1.REFERENCE_4)
                WHEN 3 THEN TO_CHAR(h1.REFERENCE_3)
                WHEN 4 THEN TO_CHAR(h1.DOCUMENT_TYPE)
                WHEN 5 THEN TO_CHAR(h1.ACCOUNTING_DATE)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , IGC_CC_EVENT_JE_HEADER_V  h1
             ,(select rownum r from all_objects where rownum <= 5 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 h1.event_id = xet.event_id

)
;

Line: 12634

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

Line: 12644

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
            , l2.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V' 
                WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_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 '8407' 
                WHEN 2 THEN '8407' 
                WHEN 3 THEN '8407' 
                WHEN 4 THEN '8407' 
                WHEN 5 THEN '8407' 
                WHEN 6 THEN '8407' 
                WHEN 7 THEN '8407' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'TRANSACTION_DESCRIPTION' 
                WHEN 2 THEN 'CODE_COMBINATION_ID' 
                WHEN 3 THEN 'CC_FUNC_CR_AMT' 
                WHEN 4 THEN 'CC_ACCT_LINE_ID' 
                WHEN 5 THEN 'CC_FUNC_AMT' 
                WHEN 6 THEN 'CURRENCY_CODE' 
                WHEN 7 THEN 'CC_FUNC_DR_AMT' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l2.TRANSACTION_DESCRIPTION)
                WHEN 2 THEN TO_CHAR(l2.CODE_COMBINATION_ID)
                WHEN 3 THEN TO_CHAR(l2.CC_FUNC_CR_AMT)
                WHEN 4 THEN TO_CHAR(l2.CC_ACCT_LINE_ID)
                WHEN 5 THEN TO_CHAR(l2.CC_FUNC_AMT)
                WHEN 6 THEN TO_CHAR(l2.CURRENCY_CODE)
                WHEN 7 THEN TO_CHAR(l2.CC_FUNC_DR_AMT)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , IGC_CC_EVENT_JE_LINES_V  l2
            , (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 l2.event_id          = xet.event_id

)
;

Line: 12762

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

Line: 12771

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

Line: 12792

           (p_location => 'XLA_08407_AAD_S_000013_BC_PKG.insert_sources_22');

Line: 12793

END insert_sources_22;

Line: 12917

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CC_REQUISITIONS
    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 
  , h1.HEADER_DESC    source_2
  , h1.REFERENCE_4    source_3
  , h1.REFERENCE_3    source_4
  , h1.DOCUMENT_TYPE    source_9
  , h1.ACCOUNTING_DATE    source_18
  FROM xla_events_gt     xet 
  , IGC_CC_EVENT_JE_HEADER_V  h1
 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 h1.event_id = xet.event_id

 ORDER BY event_id
;

Line: 12961

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CC_REQUISITIONS
    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
 , l2.LINE_NUMBER  
  , l2.TRANSACTION_DESCRIPTION    source_1
  , l2.CODE_COMBINATION_ID    source_5
  , l2.CC_FUNC_CR_AMT    source_6
  , l2.CC_ACCT_LINE_ID    source_8
  , l2.CC_FUNC_AMT    source_10
  , l2.CURRENCY_CODE    source_11
  , l2.CC_FUNC_DR_AMT    source_12
  FROM xla_events_gt     xet 
  , IGC_CC_EVENT_JE_LINES_V  l2
 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 l2.event_id      = xet.event_id
;

Line: 13029

g_array_event.DELETE;

Line: 13251

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

Line: 13272

   l_result := XLA_AE_LINES_PKG.InsertLines;

Line: 13559

l_result := XLA_AE_LINES_PKG.InsertLines ;

Line: 13567

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;

Line: 13691

         insert_sources_18(
                          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: 13725

         insert_sources_19(
                          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: 13759

         insert_sources_20(
                          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: 13793

         insert_sources_21(
                          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: 13827

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