[Home] [Help]
710: 'HEADER','L','LINE')),
711: 'Y',
712: decode(e.level_code,'H','HEADER_MLS','L','LINE_MLS'))
713: source_level_code
714: FROM xla_event_sources e, xla_sources_b s
715: WHERE e.source_application_id = s.application_id
716: AND e.source_code = s.source_code
717: AND e.source_type_code = s.source_type_code
718: AND e.application_id = p_application_id
3651: AND e.application_id = p_application_id
3652: AND e.entity_code = p_entity_code
3653: AND e.event_class_code = p_event_class_code
3654: AND NOT EXISTS (SELECT 'x'
3655: FROM xla_sources_b s
3656: WHERE s.application_id = e.application_id
3657: AND s.source_type_code = 'S'
3658: AND s.source_code = c.column_name);
3659:
3690: ,'LINE_MLS'
3691: ,'MLS_COLUMNS'
3692: ,c.column_name) <> 'LANGUAGE'
3693: AND NOT EXISTS (SELECT 'x'
3694: FROM xla_sources_b s
3695: WHERE s.application_id = r.reference_object_appl_id
3696: AND s.source_type_code = 'S'
3697: AND s.source_code = c.column_name); */
3698: CURSOR c_mls
3756: AND e.application_id = p_application_id
3757: AND e.entity_code = p_entity_code
3758: AND e.event_class_code = p_event_class_code
3759: AND NOT EXISTS (SELECT 'x'
3760: FROM xla_sources_b s
3761: WHERE s.application_id = e.application_id
3762: AND s.source_type_code = 'S'
3763: AND s.source_code = c.column_name)
3764: UNION ALL
3790: AND e.application_id = p_application_id
3791: AND e.entity_code = p_entity_code
3792: AND e.event_class_code = p_event_class_code
3793: AND NOT EXISTS (SELECT 'x'
3794: FROM xla_sources_b s
3795: WHERE s.application_id = e.application_id
3796: AND s.source_type_code = 'S'
3797: AND s.source_code = c.column_name);
3798:
3831: ,'LINE_MLS'
3832: ,'MLS_COLUMNS'
3833: ,c.column_name) <> 'LANGUAGE'
3834: AND NOT EXISTS (SELECT 'x'
3835: FROM xla_sources_b s
3836: WHERE s.application_id = r.reference_object_appl_id
3837: AND s.source_type_code = 'S'
3838: AND s.source_code = c.column_name)
3839: UNION ALL
3871: ,'LINE_MLS'
3872: ,'MLS_COLUMNS'
3873: ,c.column_name) <> 'LANGUAGE'
3874: AND NOT EXISTS (SELECT 'x'
3875: FROM xla_sources_b s
3876: WHERE s.application_id = r.reference_object_appl_id
3877: AND s.source_type_code = 'S'
3878: AND s.source_code = c.column_name);
3879:
3880:
3881: CURSOR c_tl_sources
3882: IS
3883: SELECT distinct source_code
3884: FROM xla_sources_b e
3885: WHERE e.application_id = p_application_id
3886: AND NOT EXISTS (SELECT 'x'
3887: FROM xla_sources_vl s
3888: WHERE s.application_id = e.application_id
3891:
3892: CURSOR c_ref_tl_sources
3893: IS
3894: SELECT distinct reference_object_appl_id, source_code
3895: FROM xla_sources_b e, xla_reference_objects r
3896: WHERE e.application_id = r.reference_object_appl_id
3897: AND r.application_id = p_application_id
3898: AND NOT EXISTS (SELECT 'x'
3899: FROM xla_sources_vl s
3982: -- Create sources in source_b table for all extract objects
3983: IF l_array_source_code.COUNT > 0 THEN
3984: BEGIN
3985: FORALL i IN l_array_source_code.FIRST..l_array_source_code.LAST SAVE EXCEPTIONS
3986: INSERT INTO xla_sources_b
3987: (source_code
3988: ,application_id
3989: ,source_type_code
3990: ,datatype_code
4044: -- Create sources in source_b table for all reference objects
4045: IF l_array_ref_source_code.COUNT > 0 THEN
4046: BEGIN
4047: FORALL i IN l_array_ref_source_code.FIRST..l_array_ref_source_code.LAST SAVE EXCEPTIONS
4048: INSERT INTO xla_sources_b
4049: (source_code
4050: ,application_id
4051: ,source_type_code
4052: ,datatype_code
4096: END;
4097: END IF;
4098: CLOSE c_ref_sources;
4099:
4100: -- Get all sources that exist in xla_sources_b but not in xla_sources_tl
4101: OPEN c_tl_sources;
4102: FETCH c_tl_sources
4103: BULK COLLECT INTO l_array_tl_source_code;
4104:
4160: CLOSE c_languages;
4161: END IF;
4162: CLOSE c_tl_sources;
4163:
4164: -- Get all sources that exist in xla_sources_b but not in xla_sources_tl
4165: OPEN c_ref_tl_sources;
4166: FETCH c_ref_tl_sources
4167: BULK COLLECT INTO l_array_ref_tl_source_appl_id, l_array_ref_tl_source_code;
4168: