[Home] [Help]
2064: ,xal.value_ccid_segment29
2065: ,xal.value_ccid_segment30
2066: FROM xla_aad_loader_defns_t xal
2067: ,fnd_id_flex_structures fif
2068: WHERE xal.table_name = 'XLA_SEG_RULE_DETAILS'
2069: AND xal.staging_amb_context_code = p_staging_context_code
2070: AND fif.application_id = 101
2071: AND fif.id_flex_code = 'GL#'
2072: AND fif.id_flex_structure_code = xal.value_ccid_id_flex_struct_code;
2227: p_log_type_code => 'UPLOAD',
2228: p_encoded_message => '# insert (XLA_SEG_RULES_TL) = '||l_num_rows,
2229: p_component_code => 'populate_adrs');
2230:
2231: INSERT INTO xla_seg_rule_details
2232: (segment_rule_detail_id
2233: ,application_id
2234: ,amb_context_code
2235: ,segment_rule_type_code
2254: ,last_update_date
2255: ,last_updated_by
2256: ,last_update_login)
2257: SELECT
2258: xla_seg_rule_details_s.nextval
2259: ,p_application_id
2260: ,p_staging_context_code
2261: ,segment_rule_type_code
2262: ,segment_rule_code
2289: LEFT OUTER JOIN fnd_application fap2
2290: ON fap2.application_short_name = xal.input_source_app_short_name
2291: LEFT OUTER JOIN fnd_application fap3
2292: ON fap3.application_short_name = xal.value_segment_rule_appl_sn
2293: WHERE table_name = 'XLA_SEG_RULE_DETAILS'
2294: AND staging_amb_context_code = p_staging_context_code;
2295:
2296: l_num_rows := SQL%ROWCOUNT;
2297: IF (C_LEVEL_EVENT >= g_log_level) THEN
2294: AND staging_amb_context_code = p_staging_context_code;
2295:
2296: l_num_rows := SQL%ROWCOUNT;
2297: IF (C_LEVEL_EVENT >= g_log_level) THEN
2298: trace(p_msg => '# insert (XLA_SEG_RULE_DETAILS) = '||l_num_rows,
2299: p_module => l_log_module,
2300: p_level => C_LEVEL_EVENT);
2301: END IF;
2302: -- Bug : 16208537
2305: p_amb_context_code => p_staging_context_code,
2306: p_application_id => p_application_id,
2307: p_request_code => 'IMPORT' ,
2308: p_log_type_code => 'UPLOAD',
2309: p_encoded_message => '# insert (XLA_SEG_RULE_DETAILS) = '||l_num_rows,
2310: p_component_code => 'populate_adrs');
2311:
2312: IF (C_LEVEL_EVENT >= g_log_level) THEN
2313: trace(p_msg => 'BEGIN LOOP - Retrieve CCID for XLA_SEG_RULE_DETAILS.view_code_combination_id',
2309: p_encoded_message => '# insert (XLA_SEG_RULE_DETAILS) = '||l_num_rows,
2310: p_component_code => 'populate_adrs');
2311:
2312: IF (C_LEVEL_EVENT >= g_log_level) THEN
2313: trace(p_msg => 'BEGIN LOOP - Retrieve CCID for XLA_SEG_RULE_DETAILS.view_code_combination_id',
2314: p_module => l_log_module,
2315: p_level => C_LEVEL_EVENT);
2316: END IF;
2317:
2389: ,p_token_3 => 'USER_SEQUENCE'
2390: ,p_value_3 => l_ccid.user_sequence);
2391: l_error_found := TRUE;
2392: ELSE
2393: UPDATE xla_seg_rule_details
2394: SET value_code_combination_id = l_code_combination_id
2395: WHERE amb_context_code = p_staging_context_code
2396: AND application_id = p_application_id
2397: AND segment_rule_type_code = l_ccid.segment_rule_type_code
2400: END IF;
2401: END LOOP;
2402:
2403: IF (C_LEVEL_EVENT >= g_log_level) THEN
2404: trace(p_msg => 'END LOOP - Retrieve CCID for XLA_SEG_RULE_DETAILS.view_code_combination_id',
2405: p_module => l_log_module,
2406: p_level => C_LEVEL_EVENT);
2407: END IF;
2408:
2456: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2457: ,fnd_load_util.owner_id(owner)
2458: ,0
2459: FROM xla_aad_loader_defns_t xal
2460: ,xla_seg_rule_details d
2461: ,fnd_application fap
2462: ,fnd_application fap2
2463: WHERE fap.application_short_name(+) = xal.source_app_short_name
2464: AND fap2.application_short_name(+)= xal.value_source_app_short_name
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');
4203: AD_ZD_SEED.PREPARE('XLA_ACCT_LINE_TYPES_TL');
4204: AD_ZD_SEED.PREPARE('XLA_JLT_ACCT_ATTRS');
4205: AD_ZD_SEED.PREPARE('XLA_LINE_DEFINITIONS_B');