3753: END IF;
3754:
3755: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3756: trace
3757: (p_msg => '-> CALL xla_cmp_extract_pkg.GenerateFetchHeaderCursor API'
3758: ,p_level => C_LEVEL_STATEMENT
3759: ,p_module => l_log_module);
3760: END IF;
3761: --
3763: --
3764: l_body := xla_cmp_string_pkg.replace_token
3765: (l_body
3766: ,'$header_var$'
3767: ,xla_cmp_extract_pkg.GenerateFetchHeaderCursor
3768: (p_array_h_source_index => p_array_h_source_index
3769: ,p_array_h_mls_source_index => p_array_h_mls_source_index
3770: ,p_array_lookup_type => p_rec_sources.array_lookup_type
3771: ,p_array_view_application_id => p_rec_sources.array_view_application_id)
3775: -- generate the code to cache header sources
3776: l_body := xla_cmp_string_pkg.replace_token
3777: (l_body
3778: ,'$cache_header_sources$'
3779: ,xla_cmp_extract_pkg.GenerateCacheHdrSources
3780: (p_array_h_source_index => p_array_h_source_index
3781: ,p_array_h_mls_source_index => p_array_h_mls_source_index
3782: ,p_array_lookup_type => p_rec_sources.array_lookup_type
3783: ,p_array_view_application_id => p_rec_sources.array_view_application_id
3864: );
3865:
3866: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3867: trace
3868: (p_msg => '-> CALL xla_cmp_extract_pkg.GenerateFetchLineCursor API'
3869: ,p_level => C_LEVEL_STATEMENT
3870: ,p_module => l_log_module);
3871: END IF;
3872: --
3874: --
3875: l_body := xla_cmp_string_pkg.replace_token
3876: (l_body
3877: ,'$line_var$'
3878: ,xla_cmp_extract_pkg.GenerateFetchLineCursor
3879: (p_array_l_source_index => p_array_l_source_index
3880: ,p_array_l_mls_source_index => p_array_l_mls_source_index
3881: ,p_array_source_code => p_rec_sources.array_source_code
3882: ,p_array_lookup_type => p_rec_sources.array_lookup_type
4200: --
4201: l_event :=
4202: xla_cmp_string_pkg.replace_token
4203: (l_event, '$header_types$'
4204: ,xla_cmp_extract_pkg.GenerateHdrStructure
4205: (p_array_table_name => p_array_table_name
4206: ,p_array_source_code => p_rec_sources.array_source_code
4207: ,p_array_h_source_index => p_array_h_source_index
4208: ,p_array_h_table_index => p_array_h_table_index
4221: --
4222: l_event :=
4223: xla_cmp_string_pkg.replace_token
4224: (l_event, '$header_variables$'
4225: ,xla_cmp_extract_pkg.GenerateHdrVariables
4226: (p_array_h_source_index => p_array_h_source_index
4227: ,p_array_h_mls_source_index => p_array_h_mls_source_index
4228: ,p_array_source_code => p_rec_sources.array_source_code
4229: ,p_array_lookup_type => p_rec_sources.array_lookup_type
4242: --
4243: l_event := xla_cmp_string_pkg.replace_token
4244: (l_event
4245: ,'$header_cursor$'
4246: ,XLA_cmp_extract_pkg.GenerateHeaderCursor
4247: (p_array_table_name => p_array_table_name
4248: ,p_array_parent_table_index => p_array_parent_table_index
4249: ,p_array_table_hash => p_array_table_hash
4250: ,p_array_populated_flag => p_array_populated_flag
4291: --
4292: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4293:
4294: trace
4295: (p_msg => '-> CALL xla_cmp_extract_pkg.GenerateLineStructure API'
4296: ,p_level => C_LEVEL_STATEMENT
4297: ,p_module => l_log_module);
4298:
4299: END IF;
4300: --
4301: l_event := xla_cmp_string_pkg.replace_token
4302: (l_event
4303: ,'$line_types$'
4304: ,xla_cmp_extract_pkg.GenerateLineStructure
4305: (p_array_table_name => p_array_table_name
4306: ,p_array_source_code => p_rec_sources.array_source_code
4307: ,p_array_l_source_index => p_array_l_source_index
4308: ,p_array_l_table_index => p_array_l_table_index
4319: (p_msg => 'after generatelineStructure length of l_event:'||to_char(length(l_event))
4320: ,p_level => C_LEVEL_PROCEDURE
4321: ,p_module => l_log_module);
4322: trace
4323: (p_msg => '-> CALL xla_cmp_extract_pkg.GenerateLineVariables API'
4324: ,p_level => C_LEVEL_STATEMENT
4325: ,p_module => l_log_module);
4326:
4327: END IF;
4328: --
4329: l_event := xla_cmp_string_pkg.replace_token
4330: (l_event
4331: ,'$line_variables$'
4332: ,xla_cmp_extract_pkg.GenerateLineVariables
4333: (p_array_l_source_index => p_array_l_source_index
4334: ,p_array_l_mls_source_index => p_array_l_mls_source_index
4335: ,p_array_source_code => p_rec_sources.array_source_code
4336: ,p_array_lookup_type => p_rec_sources.array_lookup_type
4346: (p_msg => 'after generatelinevariables length of l_event:'||to_char(length(l_event))
4347: ,p_level => C_LEVEL_PROCEDURE
4348: ,p_module => l_log_module);
4349: trace
4350: (p_msg => '-> CALL xla_cmp_extract_pkg.GenerateLineCursor API'
4351: ,p_level => C_LEVEL_STATEMENT
4352: ,p_module => l_log_module);
4353:
4354: END IF;
4355: --
4356: l_event := xla_cmp_string_pkg.replace_token
4357: (l_event
4358: ,'$line_cursor$'
4359: ,xla_cmp_extract_pkg.GenerateLineCursor
4360: (p_application_id => p_application_id
4361: ,p_array_table_name => p_array_table_name
4362: ,p_array_parent_table_index => p_array_parent_table_index
4363: ,p_array_table_hash => p_array_table_hash
4380: (p_msg => 'after generatelinecursor length of l_event:'||to_char(length(l_event))
4381: ,p_level => C_LEVEL_PROCEDURE
4382: ,p_module => l_log_module);
4383: trace
4384: (p_msg => '-> CALL xla_cmp_extract_pkg.GenerateLineCursor API'
4385: ,p_level => C_LEVEL_STATEMENT
4386: ,p_module => l_log_module);
4387:
4388: END IF;
4762:
4763: -- Call the Extract Integrity Checker to validate sources with
4764: -- event class Extract Objects
4765:
4766: l_IsExtractValid := xla_cmp_extract_pkg.CallExtractIntegrityChecker (
4767: p_application_id => p_application_id
4768: , p_entity_code => p_entity
4769: , p_event_class_code => p_event_class
4770: , p_amb_context_code => p_amb_context_code
4945: l_insert_sources := xla_cmp_string_pkg.replace_token(l_insert_sources,'$event_type_code$',nvl(p_event_type,' ')); -- 4417664
4946:
4947:
4948: l_insert_sources := xla_cmp_string_pkg.replace_token(l_insert_sources,'$insert_header_sources$',
4949: nvl(xla_cmp_extract_pkg.GenerateInsertHdrSources (
4950: --
4951: p_array_table_name => l_array_table_name
4952: , p_array_parent_table_index => l_array_parent_table_index
4953: , p_array_table_hash => l_array_table_hash
4974: ),' ')
4975: );
4976:
4977: l_insert_sources := xla_cmp_string_pkg.replace_token(l_insert_sources, '$insert_line_sources$',
4978: nvl(xla_cmp_extract_pkg.GenerateInsertLineSources (
4979: --
4980: p_array_table_name => l_array_table_name
4981: , p_array_parent_table_index => l_array_parent_table_index
4982: , p_array_table_hash => l_array_table_hash