DBA Data[Home] [Help]

APPS.XLA_AE_LINES_PKG dependencies on XLA_CMP_SOURCE_PKG

Line 11721: l_array_line_num xla_cmp_source_pkg.t_array_Num;

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

Line 11765: l_array_ae_header_id xla_cmp_source_pkg.t_array_Num;

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;

Line 11766: l_array_event_id xla_cmp_source_pkg.t_array_Num;

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;

Line 11767: l_array_ledger_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;

Line 11768: l_array_bflow_prior_status xla_cmp_source_pkg.t_array_VL30;

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

Line 11769: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;

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;

Line 11770: l_array_entity_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;
11774:

Line 11771: l_array_app_name xla_cmp_source_pkg.t_array_VL240;

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

Line 11772: l_array_app_id xla_cmp_source_pkg.t_array_Num; -- 11776012

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;

Line 11773: l_array_hist_bflow_err xla_cmp_source_pkg.t_array_Num;

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;

Line 12964: l_array_ae_header_id xla_cmp_source_pkg.t_array_Num;

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;

Line 12965: l_array_temp_line_num xla_cmp_source_pkg.t_array_Num; -- 5443083 l_array_ae_line_num

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;

Line 12966: l_array_event_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

Line 12967: l_array_ledger_id xla_cmp_source_pkg.t_array_Num;

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

Line 12968: l_array_balance_type_code xla_cmp_source_pkg.t_array_VL30;

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

Line 12969: l_array_entity_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
12973: l_array_zero_amount_flag xla_cmp_source_pkg.t_array_VL1; -- 5443083

Line 12970: l_array_ref_ae_header_id xla_cmp_source_pkg.t_array_Num; -- 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: --

Line 12971: l_array_header_num xla_cmp_source_pkg.t_array_Num; -- 5443083

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

Line 12972: l_array_ledger_category xla_cmp_source_pkg.t_array_VL30; -- 5443083

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

Line 12973: l_array_zero_amount_flag xla_cmp_source_pkg.t_array_VL1; -- 5443083

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