APPS.XLA_AAD_UPLOAD_PVT dependencies on XLA_SEG_RULE_DETAILS

Line 1742: WHERE xal.table_name = 'XLA_SEG_RULE_DETAILS'

1738: ,xal.value_ccid_segment29
1739: ,xal.value_ccid_segment30
1740: FROM xla_aad_loader_defns_t xal
1741: ,fnd_id_flex_structures fif
1742: WHERE xal.table_name = 'XLA_SEG_RULE_DETAILS'
1743: AND xal.staging_amb_context_code = p_staging_context_code
1744: AND fif.application_id = 101
1745: AND fif.id_flex_code = 'GL#'
1746: AND fif.id_flex_structure_code = xal.value_ccid_id_flex_struct_code;

Line 1878: INSERT INTO xla_seg_rule_details

1874: p_module => l_log_module,
1875: p_level => C_LEVEL_EVENT);
1876: END IF;
1877:
1878: INSERT INTO xla_seg_rule_details
1879: (segment_rule_detail_id
1880: ,application_id
1881: ,amb_context_code
1882: ,segment_rule_type_code

Line 1905: xla_seg_rule_details_s.nextval

1901: ,last_update_date
1902: ,last_updated_by
1903: ,last_update_login)
1904: SELECT
1905: xla_seg_rule_details_s.nextval
1906: ,p_application_id
1907: ,p_staging_context_code
1908: ,segment_rule_type_code
1909: ,segment_rule_code

Line 1940: WHERE table_name = 'XLA_SEG_RULE_DETAILS'

1936: LEFT OUTER JOIN fnd_application fap2
1937: ON fap2.application_short_name = xal.input_source_app_short_name
1938: LEFT OUTER JOIN fnd_application fap3
1939: ON fap3.application_short_name = xal.value_segment_rule_appl_sn
1940: WHERE table_name = 'XLA_SEG_RULE_DETAILS'
1941: AND staging_amb_context_code = p_staging_context_code;
1942:
1943: IF (C_LEVEL_EVENT >= g_log_level) THEN
1944: trace(p_msg => '# insert (XLA_SEG_RULE_DETAILS) = '||SQL%ROWCOUNT,

Line 1944: trace(p_msg => '# insert (XLA_SEG_RULE_DETAILS) = '||SQL%ROWCOUNT,

1940: WHERE table_name = 'XLA_SEG_RULE_DETAILS'
1941: AND staging_amb_context_code = p_staging_context_code;
1942:
1943: IF (C_LEVEL_EVENT >= g_log_level) THEN
1944: trace(p_msg => '# insert (XLA_SEG_RULE_DETAILS) = '||SQL%ROWCOUNT,
1945: p_module => l_log_module,
1946: p_level => C_LEVEL_EVENT);
1947: END IF;
1948:

Line 1950: trace(p_msg => 'BEGIN LOOP - Retrieve CCID for XLA_SEG_RULE_DETAILS.view_code_combination_id',

1946: p_level => C_LEVEL_EVENT);
1947: END IF;
1948:
1949: IF (C_LEVEL_EVENT >= g_log_level) THEN
1950: trace(p_msg => 'BEGIN LOOP - Retrieve CCID for XLA_SEG_RULE_DETAILS.view_code_combination_id',
1951: p_module => l_log_module,
1952: p_level => C_LEVEL_EVENT);
1953: END IF;
1954:

Line 2030: UPDATE xla_seg_rule_details

2026: ,p_token_3 => 'USER_SEQUENCE'
2027: ,p_value_3 => l_ccid.user_sequence);
2028: l_error_found := TRUE;
2029: ELSE
2030: UPDATE xla_seg_rule_details
2031: SET value_code_combination_id = l_code_combination_id
2032: WHERE amb_context_code = p_staging_context_code
2033: AND application_id = p_application_id
2034: AND segment_rule_type_code = l_ccid.segment_rule_type_code

Line 2041: trace(p_msg => 'END LOOP - Retrieve CCID for XLA_SEG_RULE_DETAILS.view_code_combination_id',

2037: END IF;
2038: END LOOP;
2039:
2040: IF (C_LEVEL_EVENT >= g_log_level) THEN
2041: trace(p_msg => 'END LOOP - Retrieve CCID for XLA_SEG_RULE_DETAILS.view_code_combination_id',
2042: p_module => l_log_module,
2043: p_level => C_LEVEL_EVENT);
2044: END IF;
2045:

Line 2097: ,xla_seg_rule_details d

2093: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2094: ,fnd_load_util.owner_id(owner)
2095: ,0
2096: FROM xla_aad_loader_defns_t xal
2097: ,xla_seg_rule_details d
2098: ,fnd_application fap
2099: ,fnd_application fap2
2100: WHERE fap.application_short_name(+) = xal.source_app_short_name
2101: AND fap2.application_short_name(+)= xal.value_source_app_short_name