APPS.XLA_AAD_UPLOAD_PVT dependencies on XLA_MAPPING_SET_VALUES

Line 1319: WHERE xal.table_name = 'XLA_MAPPING_SET_VALUES'

1315: ,xal.value_ccid_segment29
1316: ,xal.value_ccid_segment30
1317: FROM xla_aad_loader_defns_t xal
1318: ,fnd_id_flex_structures fif
1319: WHERE xal.table_name = 'XLA_MAPPING_SET_VALUES'
1320: AND xal.staging_amb_context_code = p_staging_context_code
1321: AND fif.application_id = 101
1322: AND fif.id_flex_code = 'GL#'
1323: AND fif.id_flex_structure_code = xal.value_ccid_id_flex_struct_code;

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

1465: p_encoded_message => '# insert (XLA_MAPPING_SETS_TL) = '||l_num_rows,
1466: p_component_code => 'populate_mapping_sets');
1467:
1468: IF (C_LEVEL_EVENT >= g_log_level) THEN
1469: trace(p_msg => 'BEGIN LOOP - Retrieve CCID for XLA_MAPPING_SET_VALUES.view_code_combination_id',
1470: p_module => l_log_module,
1471: p_level => C_LEVEL_EVENT);
1472: END IF;
1473:

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

1568: END IF;
1569: END LOOP;
1570:
1571: IF (C_LEVEL_EVENT >= g_log_level) THEN
1572: trace(p_msg => 'END LOOP - Retrieve CCID for XLA_MAPPING_SET_VALUES.view_code_combination_id',
1573: p_module => l_log_module,
1574: p_level => C_LEVEL_EVENT);
1575: END IF;
1576:

Line 1577: INSERT INTO xla_mapping_set_values

1573: p_module => l_log_module,
1574: p_level => C_LEVEL_EVENT);
1575: END IF;
1576:
1577: INSERT INTO xla_mapping_set_values
1578: (mapping_set_value_id
1579: ,amb_context_code
1580: ,mapping_set_code
1581: ,value_constant

Line 1594: xla_mapping_set_values_s.nextval

1590: ,last_update_date
1591: ,last_updated_by
1592: ,last_update_login)
1593: SELECT
1594: xla_mapping_set_values_s.nextval
1595: ,p_staging_context_code
1596: ,mapping_set_code
1597: ,value_constant
1598: ,value_code_combination_id

Line 1610: WHERE table_name = 'XLA_MAPPING_SET_VALUES'

1606: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1607: ,fnd_load_util.owner_id(owner)
1608: ,0
1609: FROM xla_aad_loader_defns_t xal
1610: WHERE table_name = 'XLA_MAPPING_SET_VALUES'
1611: AND staging_amb_context_code = p_staging_context_code;
1612:
1613: l_num_rows := SQL%ROWCOUNT;
1614:

Line 1616: trace(p_msg => '# insert (XLA_MAPPING_SET_VALUES) = '||l_num_rows,

1612:
1613: l_num_rows := SQL%ROWCOUNT;
1614:
1615: IF (C_LEVEL_EVENT >= g_log_level) THEN
1616: trace(p_msg => '# insert (XLA_MAPPING_SET_VALUES) = '||l_num_rows,
1617: p_module => l_log_module,
1618: p_level => C_LEVEL_EVENT);
1619: END IF;
1620:

Line 1628: p_encoded_message => '# insert (XLA_MAPPING_SET_VALUES) = '||l_num_rows,

1624: p_amb_context_code => p_staging_context_code,
1625: p_application_id => p_application_id,
1626: p_request_code => 'IMPORT' ,
1627: p_log_type_code => 'UPLOAD',
1628: p_encoded_message => '# insert (XLA_MAPPING_SET_VALUES) = '||l_num_rows,
1629: p_component_code => 'populate_mapping_sets');
1630: END IF;
1631:
1632: IF (l_error_found) THEN

Line 4193: AD_ZD_SEED.PREPARE('XLA_MAPPING_SET_VALUES');

4189: AD_ZD_SEED.PREPARE('XLA_DESCRIPT_DETAILS_TL');
4190: AD_ZD_SEED.PREPARE('XLA_CONDITIONS');
4191: AD_ZD_SEED.PREPARE('XLA_MAPPING_SETS_B');
4192: AD_ZD_SEED.PREPARE('XLA_MAPPING_SETS_TL');
4193: AD_ZD_SEED.PREPARE('XLA_MAPPING_SET_VALUES');
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');