11717: WHERE reversal_code = C_DUMMY_PRIOR
11718: AND bflow_prior_entry_status_code IS NOT NULL AND bflow_prior_entry_status_code <> 'X'; -- 5132302 if applied to amt is null
11719: --AND (bflow_prior_entry_status_code IN ('F', DECODE(p_accounting_mode, 'D', 'D', 'F')));
11720:
11721: l_array_line_num xla_cmp_source_pkg.t_array_Num;
11722:
11723:
11724: CURSOR c_bflow_err_lines IS
11725: SELECT /*+ index(xte xla_transaction_entities_n1) */ xal.ae_header_id
11761: AND xte.application_id (+)= xal.bflow_application_id
11762: AND xte.entity_code (+) = xal.bflow_entity_code;
11763:
11764: l_log_module VARCHAR2(240);
11765: l_array_ae_header_id xla_cmp_source_pkg.t_array_Num;
11766: l_array_event_id xla_cmp_source_pkg.t_array_Num;
11767: l_array_ledger_id xla_cmp_source_pkg.t_array_Num;
11768: l_array_bflow_prior_status xla_cmp_source_pkg.t_array_VL30;
11769: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;
11762: AND xte.entity_code (+) = xal.bflow_entity_code;
11763:
11764: l_log_module VARCHAR2(240);
11765: l_array_ae_header_id xla_cmp_source_pkg.t_array_Num;
11766: l_array_event_id xla_cmp_source_pkg.t_array_Num;
11767: l_array_ledger_id xla_cmp_source_pkg.t_array_Num;
11768: l_array_bflow_prior_status xla_cmp_source_pkg.t_array_VL30;
11769: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;
11770: l_array_entity_id xla_cmp_source_pkg.t_array_Num;
11763:
11764: l_log_module VARCHAR2(240);
11765: l_array_ae_header_id xla_cmp_source_pkg.t_array_Num;
11766: l_array_event_id xla_cmp_source_pkg.t_array_Num;
11767: l_array_ledger_id xla_cmp_source_pkg.t_array_Num;
11768: l_array_bflow_prior_status xla_cmp_source_pkg.t_array_VL30;
11769: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;
11770: l_array_entity_id xla_cmp_source_pkg.t_array_Num;
11771: l_array_app_name xla_cmp_source_pkg.t_array_VL240;
11764: l_log_module VARCHAR2(240);
11765: l_array_ae_header_id xla_cmp_source_pkg.t_array_Num;
11766: l_array_event_id xla_cmp_source_pkg.t_array_Num;
11767: l_array_ledger_id xla_cmp_source_pkg.t_array_Num;
11768: l_array_bflow_prior_status xla_cmp_source_pkg.t_array_VL30;
11769: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;
11770: l_array_entity_id xla_cmp_source_pkg.t_array_Num;
11771: l_array_app_name xla_cmp_source_pkg.t_array_VL240;
11772: l_array_app_id xla_cmp_source_pkg.t_array_Num; -- 11776012
11765: l_array_ae_header_id xla_cmp_source_pkg.t_array_Num;
11766: l_array_event_id xla_cmp_source_pkg.t_array_Num;
11767: l_array_ledger_id xla_cmp_source_pkg.t_array_Num;
11768: l_array_bflow_prior_status xla_cmp_source_pkg.t_array_VL30;
11769: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;
11770: l_array_entity_id xla_cmp_source_pkg.t_array_Num;
11771: l_array_app_name xla_cmp_source_pkg.t_array_VL240;
11772: l_array_app_id xla_cmp_source_pkg.t_array_Num; -- 11776012
11773: l_array_hist_bflow_err xla_cmp_source_pkg.t_array_Num;
11766: l_array_event_id xla_cmp_source_pkg.t_array_Num;
11767: l_array_ledger_id xla_cmp_source_pkg.t_array_Num;
11768: l_array_bflow_prior_status xla_cmp_source_pkg.t_array_VL30;
11769: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;
11770: l_array_entity_id xla_cmp_source_pkg.t_array_Num;
11771: l_array_app_name xla_cmp_source_pkg.t_array_VL240;
11772: l_array_app_id xla_cmp_source_pkg.t_array_Num; -- 11776012
11773: l_array_hist_bflow_err xla_cmp_source_pkg.t_array_Num;
11774:
11767: l_array_ledger_id xla_cmp_source_pkg.t_array_Num;
11768: l_array_bflow_prior_status xla_cmp_source_pkg.t_array_VL30;
11769: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;
11770: l_array_entity_id xla_cmp_source_pkg.t_array_Num;
11771: l_array_app_name xla_cmp_source_pkg.t_array_VL240;
11772: l_array_app_id xla_cmp_source_pkg.t_array_Num; -- 11776012
11773: l_array_hist_bflow_err xla_cmp_source_pkg.t_array_Num;
11774:
11775: -- 4655713b MPA and Accrual Reversal
11768: l_array_bflow_prior_status xla_cmp_source_pkg.t_array_VL30;
11769: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;
11770: l_array_entity_id xla_cmp_source_pkg.t_array_Num;
11771: l_array_app_name xla_cmp_source_pkg.t_array_VL240;
11772: l_array_app_id xla_cmp_source_pkg.t_array_Num; -- 11776012
11773: l_array_hist_bflow_err xla_cmp_source_pkg.t_array_Num;
11774:
11775: -- 4655713b MPA and Accrual Reversal
11776: l_array_mpa_segment1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
11769: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;
11770: l_array_entity_id xla_cmp_source_pkg.t_array_Num;
11771: l_array_app_name xla_cmp_source_pkg.t_array_VL240;
11772: l_array_app_id xla_cmp_source_pkg.t_array_Num; -- 11776012
11773: l_array_hist_bflow_err xla_cmp_source_pkg.t_array_Num;
11774:
11775: -- 4655713b MPA and Accrual Reversal
11776: l_array_mpa_segment1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
11777: l_array_mpa_segment2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
12960: --
12961: -- Define local variables
12962: --
12963: l_err_count INTEGER;
12964: l_array_ae_header_id xla_cmp_source_pkg.t_array_Num;
12965: l_array_temp_line_num xla_cmp_source_pkg.t_array_Num; -- 5443083 l_array_ae_line_num
12966: l_array_event_id xla_cmp_source_pkg.t_array_Num;
12967: l_array_ledger_id xla_cmp_source_pkg.t_array_Num;
12968: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;
12961: -- Define local variables
12962: --
12963: l_err_count INTEGER;
12964: l_array_ae_header_id xla_cmp_source_pkg.t_array_Num;
12965: l_array_temp_line_num xla_cmp_source_pkg.t_array_Num; -- 5443083 l_array_ae_line_num
12966: l_array_event_id xla_cmp_source_pkg.t_array_Num;
12967: l_array_ledger_id xla_cmp_source_pkg.t_array_Num;
12968: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;
12969: l_array_entity_id xla_cmp_source_pkg.t_array_Num;
12962: --
12963: l_err_count INTEGER;
12964: l_array_ae_header_id xla_cmp_source_pkg.t_array_Num;
12965: l_array_temp_line_num xla_cmp_source_pkg.t_array_Num; -- 5443083 l_array_ae_line_num
12966: l_array_event_id xla_cmp_source_pkg.t_array_Num;
12967: l_array_ledger_id xla_cmp_source_pkg.t_array_Num;
12968: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;
12969: l_array_entity_id xla_cmp_source_pkg.t_array_Num;
12970: l_array_ref_ae_header_id xla_cmp_source_pkg.t_array_Num; -- 5443083
12963: l_err_count INTEGER;
12964: l_array_ae_header_id xla_cmp_source_pkg.t_array_Num;
12965: l_array_temp_line_num xla_cmp_source_pkg.t_array_Num; -- 5443083 l_array_ae_line_num
12966: l_array_event_id xla_cmp_source_pkg.t_array_Num;
12967: l_array_ledger_id xla_cmp_source_pkg.t_array_Num;
12968: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;
12969: l_array_entity_id xla_cmp_source_pkg.t_array_Num;
12970: l_array_ref_ae_header_id xla_cmp_source_pkg.t_array_Num; -- 5443083
12971: l_array_header_num xla_cmp_source_pkg.t_array_Num; -- 5443083
12964: l_array_ae_header_id xla_cmp_source_pkg.t_array_Num;
12965: l_array_temp_line_num xla_cmp_source_pkg.t_array_Num; -- 5443083 l_array_ae_line_num
12966: l_array_event_id xla_cmp_source_pkg.t_array_Num;
12967: l_array_ledger_id xla_cmp_source_pkg.t_array_Num;
12968: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;
12969: l_array_entity_id xla_cmp_source_pkg.t_array_Num;
12970: l_array_ref_ae_header_id xla_cmp_source_pkg.t_array_Num; -- 5443083
12971: l_array_header_num xla_cmp_source_pkg.t_array_Num; -- 5443083
12972: l_array_ledger_category xla_cmp_source_pkg.t_array_VL30; -- 5443083
12965: l_array_temp_line_num xla_cmp_source_pkg.t_array_Num; -- 5443083 l_array_ae_line_num
12966: l_array_event_id xla_cmp_source_pkg.t_array_Num;
12967: l_array_ledger_id xla_cmp_source_pkg.t_array_Num;
12968: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;
12969: l_array_entity_id xla_cmp_source_pkg.t_array_Num;
12970: l_array_ref_ae_header_id xla_cmp_source_pkg.t_array_Num; -- 5443083
12971: l_array_header_num xla_cmp_source_pkg.t_array_Num; -- 5443083
12972: l_array_ledger_category xla_cmp_source_pkg.t_array_VL30; -- 5443083
12973: l_array_zero_amount_flag xla_cmp_source_pkg.t_array_VL1; -- 5443083
12966: l_array_event_id xla_cmp_source_pkg.t_array_Num;
12967: l_array_ledger_id xla_cmp_source_pkg.t_array_Num;
12968: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;
12969: l_array_entity_id xla_cmp_source_pkg.t_array_Num;
12970: l_array_ref_ae_header_id xla_cmp_source_pkg.t_array_Num; -- 5443083
12971: l_array_header_num xla_cmp_source_pkg.t_array_Num; -- 5443083
12972: l_array_ledger_category xla_cmp_source_pkg.t_array_VL30; -- 5443083
12973: l_array_zero_amount_flag xla_cmp_source_pkg.t_array_VL1; -- 5443083
12974: --
12967: l_array_ledger_id xla_cmp_source_pkg.t_array_Num;
12968: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;
12969: l_array_entity_id xla_cmp_source_pkg.t_array_Num;
12970: l_array_ref_ae_header_id xla_cmp_source_pkg.t_array_Num; -- 5443083
12971: l_array_header_num xla_cmp_source_pkg.t_array_Num; -- 5443083
12972: l_array_ledger_category xla_cmp_source_pkg.t_array_VL30; -- 5443083
12973: l_array_zero_amount_flag xla_cmp_source_pkg.t_array_VL1; -- 5443083
12974: --
12975: -- Cursor to return the same entry lines that are not processed
12968: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;
12969: l_array_entity_id xla_cmp_source_pkg.t_array_Num;
12970: l_array_ref_ae_header_id xla_cmp_source_pkg.t_array_Num; -- 5443083
12971: l_array_header_num xla_cmp_source_pkg.t_array_Num; -- 5443083
12972: l_array_ledger_category xla_cmp_source_pkg.t_array_VL30; -- 5443083
12973: l_array_zero_amount_flag xla_cmp_source_pkg.t_array_VL1; -- 5443083
12974: --
12975: -- Cursor to return the same entry lines that are not processed
12976: --
12969: l_array_entity_id xla_cmp_source_pkg.t_array_Num;
12970: l_array_ref_ae_header_id xla_cmp_source_pkg.t_array_Num; -- 5443083
12971: l_array_header_num xla_cmp_source_pkg.t_array_Num; -- 5443083
12972: l_array_ledger_category xla_cmp_source_pkg.t_array_VL30; -- 5443083
12973: l_array_zero_amount_flag xla_cmp_source_pkg.t_array_VL1; -- 5443083
12974: --
12975: -- Cursor to return the same entry lines that are not processed
12976: --
12977: CURSOR c_bflow_unprocessed_lines IS