[Home] [Help]
495: WHERE bs.mapping_set_code = bw.mapping_set_code
496: AND bs.amb_context_code = g_staging_context_code
497: AND bw.amb_context_code = g_amb_context_code;
498:
499: l_mapping_sets xla_component_tbl_type;
500: l_mapping_set xla_component_rec_type;
501: l_ms_codes t_array_varchar2;
502: i INTEGER;
503:
513: p_level => C_LEVEL_PROCEDURE);
514: END IF;
515:
516: i := 0;
517: l_mapping_sets := xla_component_tbl_type();
518:
519: IF (C_LEVEL_EVENT >= g_log_level) THEN
520: trace(p_msg => 'BEGIN LOOP - retrieve mapping set',
521: p_module => l_log_module,
588: ,xla_environment_pkg.g_prog_appl_id
589: ,xla_environment_pkg.g_prog_id
590: ,xla_environment_pkg.g_req_Id
591: FROM xla_seg_rule_details d
592: ,TABLE(CAST(l_mapping_sets AS xla_component_tbl_type)) ms
593: WHERE d.amb_context_code = g_amb_context_code
594: AND d.application_id <> g_application_id
595: AND d.value_mapping_set_code = ms.component_code;
596:
683: FROM xla_analytical_hdrs_b w
684: WHERE w.application_id = g_application_id
685: AND w.amb_context_code = g_amb_context_code;
686:
687: l_analytical_criteria xla_component_tbl_type;
688: l_analytical_criterion xla_component_rec_type;
689: l_ac_codes t_array_varchar2;
690: l_ac_type_codes t_array_varchar2;
691: i INTEGER;
701: p_level => C_LEVEL_PROCEDURE);
702: END IF;
703:
704: i := 0;
705: l_analytical_criteria := xla_component_tbl_type();
706:
707: IF (C_LEVEL_EVENT >= g_log_level) THEN
708: trace(p_msg => 'BEGIN LOOP - retrieve analytical criteria',
709: p_module => l_log_module,
791: ,a.analytical_criterion_code
792: ,ac.version_from
793: ,ac.version_to
794: FROM xla_aad_header_ac_assgns a
795: ,TABLE(CAST(l_analytical_criteria AS xla_component_tbl_type)) ac
796: WHERE a.amb_context_code = g_amb_context_code
797: AND a.application_id <> g_application_id
798: AND a.analytical_criterion_type_code = ac.component_owner_code
799: AND a.analytical_criterion_code = ac.component_code
804: ,a.analytical_criterion_code
805: ,ac.version_from
806: ,ac.version_to
807: FROM xla_line_defn_ac_assgns a
808: ,TABLE(CAST(l_analytical_criteria AS xla_component_tbl_type)) ac
809: WHERE a.amb_context_code = g_amb_context_code
810: AND a.application_id <> g_application_id
811: AND a.analytical_criterion_type_code = ac.component_owner_code
812: AND a.analytical_criterion_code = ac.component_code
928: FROM xla_seg_rules_b w
929: WHERE w.application_id = g_application_id
930: AND w.amb_context_code = g_amb_context_code;
931:
932: l_adrs xla_component_tbl_type;
933: l_adr xla_component_rec_type;
934: l_adr_codes t_array_varchar2;
935: l_adr_type_codes t_array_varchar2;
936: i INTEGER;
946: p_level => C_LEVEL_PROCEDURE);
947: END IF;
948:
949: i := 0;
950: l_adrs := xla_component_tbl_type();
951:
952: IF (C_LEVEL_EVENT >= g_log_level) THEN
953: trace(p_msg => 'BEGIN LOOP - retrieve ADR',
954: p_module => l_log_module,
1034: ,a.segment_rule_code
1035: ,adr.version_from
1036: ,adr.version_to
1037: FROM xla_line_defn_adr_assgns a
1038: ,TABLE(CAST(l_adrs AS xla_component_tbl_type)) adr
1039: WHERE a.amb_context_code = g_amb_context_code
1040: AND a.application_id <> g_application_id
1041: AND a.segment_rule_appl_id = g_application_id
1042: AND a.segment_rule_type_code = adr.component_owner_code
1048: ,a.segment_rule_code
1049: ,adr.version_from
1050: ,adr.version_to
1051: FROM xla_seg_rule_details a
1052: ,TABLE(CAST(l_adrs AS xla_component_tbl_type)) adr
1053: WHERE a.amb_context_code = g_amb_context_code
1054: AND a.application_id <> g_application_id
1055: AND a.value_segment_rule_appl_id = g_application_id
1056: AND a.value_segment_rule_type_code = adr.component_owner_code