APPS.XLA_AAD_UPLOAD_PVT dependencies on XLA_MAPPING_SET_VALUES

Line 1126: WHERE xal.table_name = 'XLA_MAPPING_SET_VALUES'

1122: ,xal.value_ccid_segment29
1123: ,xal.value_ccid_segment30
1124: FROM xla_aad_loader_defns_t xal
1125: ,fnd_id_flex_structures fif
1126: WHERE xal.table_name = 'XLA_MAPPING_SET_VALUES'
1127: AND xal.staging_amb_context_code = p_staging_context_code
1128: AND fif.application_id = 101
1129: AND fif.id_flex_code = 'GL#'
1130: AND fif.id_flex_structure_code = xal.value_ccid_id_flex_struct_code;

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

1244: p_level => C_LEVEL_EVENT);
1245: END IF;
1246:
1247: IF (C_LEVEL_EVENT >= g_log_level) THEN
1248: trace(p_msg => 'BEGIN LOOP - Retrieve CCID for XLA_MAPPING_SET_VALUES.view_code_combination_id',
1249: p_module => l_log_module,
1250: p_level => C_LEVEL_EVENT);
1251: END IF;
1252:

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

1347: END IF;
1348: END LOOP;
1349:
1350: IF (C_LEVEL_EVENT >= g_log_level) THEN
1351: trace(p_msg => 'END LOOP - Retrieve CCID for XLA_MAPPING_SET_VALUES.view_code_combination_id',
1352: p_module => l_log_module,
1353: p_level => C_LEVEL_EVENT);
1354: END IF;
1355:

Line 1356: INSERT INTO xla_mapping_set_values

1352: p_module => l_log_module,
1353: p_level => C_LEVEL_EVENT);
1354: END IF;
1355:
1356: INSERT INTO xla_mapping_set_values
1357: (mapping_set_value_id
1358: ,amb_context_code
1359: ,mapping_set_code
1360: ,value_constant

Line 1373: xla_mapping_set_values_s.nextval

1369: ,last_update_date
1370: ,last_updated_by
1371: ,last_update_login)
1372: SELECT
1373: xla_mapping_set_values_s.nextval
1374: ,p_staging_context_code
1375: ,mapping_set_code
1376: ,value_constant
1377: ,value_code_combination_id

Line 1389: WHERE table_name = 'XLA_MAPPING_SET_VALUES'

1385: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1386: ,fnd_load_util.owner_id(owner)
1387: ,0
1388: FROM xla_aad_loader_defns_t xal
1389: WHERE table_name = 'XLA_MAPPING_SET_VALUES'
1390: AND staging_amb_context_code = p_staging_context_code;
1391:
1392: IF (C_LEVEL_EVENT >= g_log_level) THEN
1393: trace(p_msg => '# insert (XLA_MAPPING_SET_VALUES) = '||SQL%ROWCOUNT,

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

1389: WHERE table_name = 'XLA_MAPPING_SET_VALUES'
1390: AND staging_amb_context_code = p_staging_context_code;
1391:
1392: IF (C_LEVEL_EVENT >= g_log_level) THEN
1393: trace(p_msg => '# insert (XLA_MAPPING_SET_VALUES) = '||SQL%ROWCOUNT,
1394: p_module => l_log_module,
1395: p_level => C_LEVEL_EVENT);
1396: END IF;
1397: