APPS.HZ_MIXNM_REGISTRY_PUB dependencies on HZ_SELECT_DATA_SOURCES

Line 1264: INSERT INTO hz_select_data_sources (

1260: p_msg_level=>fnd_log.level_procedure);
1261: END IF;
1262:
1263: FORALL i IN 1..p_data_source_tab.COUNT
1264: INSERT INTO hz_select_data_sources (
1265: entity_attr_id,
1266: content_source_type,
1267: ranking,
1268: created_by,

Line 1291: FROM hz_select_data_sources source2

1287: hz_utility_v2pub.last_updated_by
1288: FROM dual
1289: WHERE NOT EXISTS (
1290: SELECT 'Y'
1291: FROM hz_select_data_sources source2
1292: WHERE source2.entity_attr_id = p_entity_attr_id
1293: AND source2.content_source_type = p_data_source_tab(i));
1294:
1295: -- Debug info.

Line 1542: FROM hz_select_data_sources

1538: CURSOR c_data_sources (
1539: p_entity_attr_id NUMBER
1540: ) IS
1541: SELECT content_source_type
1542: FROM hz_select_data_sources
1543: WHERE entity_attr_id = p_entity_attr_id;
1544:
1545: BEGIN
1546:

Line 1751: FROM hz_select_data_sources

1747: CURSOR c_selected_data_source (
1748: p_entity_attr_id NUMBER
1749: ) IS
1750: SELECT 'Y'
1751: FROM hz_select_data_sources
1752: WHERE entity_attr_id = p_entity_attr_id
1753: AND ranking > 0
1754: AND content_source_type <> 'USER_ENTERED'
1755: AND ROWNUM = 1;

Line 1821: DELETE hz_select_data_sources

1817: FETCH c_selected_data_source INTO l_dummy;
1818:
1819: IF c_selected_data_source%NOTFOUND THEN
1820: -- delete the data sources.
1821: DELETE hz_select_data_sources
1822: WHERE entity_attr_id = l_entity_attr_id;
1823:
1824: -- delete the entity and / or attribute.
1825: DELETE hz_entity_attributes

Line 2011: FROM hz_select_data_sources

2007: p_entity_attr_id NUMBER,
2008: p_data_source VARCHAR2
2009: ) IS
2010: SELECT 'Y'
2011: FROM hz_select_data_sources
2012: WHERE entity_attr_id = p_entity_attr_id
2013: AND content_source_type = p_data_source
2014: AND ranking > 0;
2015:

Line 2084: DELETE hz_select_data_sources

2080: FETCH c_data_source INTO l_dummy;
2081:
2082: IF c_data_source%NOTFOUND THEN
2083: -- delete the data sources.
2084: DELETE hz_select_data_sources
2085: WHERE entity_attr_id = l_entity_attr_id
2086: AND content_source_type = p_data_source_tbl(i);
2087: ELSE
2088: fnd_message.set_name('AR', 'HZ_CANNOT_DELETE_ENTITY_SOURCE');

Line 2105: FROM hz_select_data_sources

2101: DELETE hz_entity_attributes
2102: WHERE entity_attr_id = l_entity_attr_id
2103: AND NOT EXISTS (
2104: SELECT 'Y'
2105: FROM hz_select_data_sources
2106: WHERE entity_attr_id = l_entity_attr_id)
2107: RETURNING entity_attr_id BULK COLLECT INTO i_entity_attr_id;
2108:
2109: -- delete corresponding rules