[Home] [Help]
242: AND xal.application_short_name = fa.application_short_name
243: AND fa.application_id <> p_application_id
244: AND fa2.application_id = p_application_id;
245:
246: -- krsankar - Bug 6975482 - Introducing 2 new cursors for deleting duplicate data from XLA_ANALYTICAL_HDRS, XLA_ANALYTICAL_SOURCES
247: -- krsankar - Bug 7243326 - Modified to analytical_criterion_code instead of criterion_type_code
248:
249: CURSOR c_del_dup_name IS
250: SELECT table_name
267:
268: CURSOR c_del_dup_name_anal_sources IS
269: SELECT table_name
270: , DECODE(table_name
271: ,'XLA_ANALYTICAL_SOURCES' ,analytical_criterion_type_code||C_CHAR||
272: analytical_criterion_code||C_CHAR||
273: event_class_code)
274: , analytical_criterion_type_code
275: , analytical_criterion_code
280: , source_type_code
281: , count(*)
282: FROM xla_aad_loader_defns_t
283: WHERE staging_amb_context_code = p_staging_context_code
284: AND table_name IN ('XLA_ANALYTICAL_SOURCES')
285: GROUP BY
286: table_name
287: , DECODE(table_name
288: ,'XLA_ANALYTICAL_SOURCES' ,analytical_criterion_type_code||C_CHAR||
284: AND table_name IN ('XLA_ANALYTICAL_SOURCES')
285: GROUP BY
286: table_name
287: , DECODE(table_name
288: ,'XLA_ANALYTICAL_SOURCES' ,analytical_criterion_type_code||C_CHAR||
289: analytical_criterion_code||C_CHAR||
290: event_class_code)
291: , analytical_criterion_type_code
292: , analytical_criterion_code
624:
625:
626: DELETE FROM xla_aad_loader_defns_t
627: WHERE staging_amb_context_code = p_staging_context_code
628: AND upper(table_name) = ('XLA_ANALYTICAL_SOURCES')
629: AND analytical_criterion_type_code = i.analytical_criterion_type_code
630: AND analytical_criterion_code = i.analytical_criterion_code
631: AND analytical_detail_code = i.analytical_detail_code
632: AND entity_code = i.entity_code
634: AND source_code = i.source_code
635: AND source_type_code = i.source_type_code
636: AND rowid NOT IN (select max(rowid) from xla_aad_loader_defns_t
637: WHERE staging_amb_context_code = p_staging_context_code
638: AND upper(table_name) = ('XLA_ANALYTICAL_SOURCES')
639: AND analytical_criterion_type_code = i.analytical_criterion_type_code
640: AND analytical_criterion_code = i.analytical_criterion_code
641: AND analytical_detail_code = i.analytical_detail_code
642: AND entity_code = i.entity_code
1916: p_log_type_code => 'UPLOAD',
1917: p_encoded_message => '# insert (XLA_ANALYTICAL_DTLS_TL) = '||l_num_rows,
1918: p_component_code => 'populate_analytical_criteria');
1919:
1920: INSERT INTO xla_analytical_sources
1921: (amb_context_code
1922: ,analytical_criterion_type_code
1923: ,analytical_criterion_code
1924: ,analytical_detail_code
1953: ,fnd_application fap
1954: ,fnd_application fap2
1955: WHERE fap.application_short_name = xal.application_short_name
1956: AND fap2.application_short_name = xal.source_app_short_name
1957: AND table_name = 'XLA_ANALYTICAL_SOURCES'
1958: AND staging_amb_context_code = p_staging_context_code;
1959:
1960: l_num_rows := SQL%ROWCOUNT;
1961:
1959:
1960: l_num_rows := SQL%ROWCOUNT;
1961:
1962: IF (C_LEVEL_EVENT >= g_log_level) THEN
1963: trace(p_msg => '# insert (XLA_ANALYTICAL_SOURCES) = '||l_num_rows,
1964: p_module => l_log_module,
1965: p_level => C_LEVEL_EVENT);
1966: END IF;
1967:
1971: p_amb_context_code => p_staging_context_code,
1972: p_application_id => p_application_id,
1973: p_request_code => 'IMPORT' ,
1974: p_log_type_code => 'UPLOAD',
1975: p_encoded_message => '# insert (XLA_ANALYTICAL_SOURCES) = '||l_num_rows,
1976: p_component_code => 'populate_analytical_criteria');
1977:
1978: END IF; -- Detail exists
1979: -- END IF; -- Header exists -- Commented as part of Bug 7243326 as Header IF is closed immediately after analytical_hdrs_tl table
4194: AD_ZD_SEED.PREPARE('XLA_ANALYTICAL_HDRS_B');
4195: AD_ZD_SEED.PREPARE('XLA_ANALYTICAL_HDRS_TL');
4196: AD_ZD_SEED.PREPARE('XLA_ANALYTICAL_DTLS_B');
4197: AD_ZD_SEED.PREPARE('XLA_ANALYTICAL_DTLS_TL');
4198: AD_ZD_SEED.PREPARE('XLA_ANALYTICAL_SOURCES');
4199: AD_ZD_SEED.PREPARE('XLA_SEG_RULES_B');
4200: AD_ZD_SEED.PREPARE('XLA_SEG_RULES_TL');
4201: AD_ZD_SEED.PREPARE('XLA_SEG_RULE_DETAILS');
4202: AD_ZD_SEED.PREPARE('XLA_ACCT_LINE_TYPES_B');