APPS.HZ_MIXNM_REGISTRY_PUB dependencies on HZ_SELECT_DATA_SOURCES

Line 1286: INSERT INTO hz_select_data_sources (

1282: p_msg_level=>fnd_log.level_procedure);
1283: END IF;
1284:
1285: FORALL i IN 1..p_data_source_tab.COUNT
1286: INSERT INTO hz_select_data_sources (
1287: entity_attr_id,
1288: content_source_type,
1289: ranking,
1290: created_by,

Line 1313: FROM hz_select_data_sources source2

1309: hz_utility_v2pub.last_updated_by
1310: FROM dual
1311: WHERE NOT EXISTS (
1312: SELECT 'Y'
1313: FROM hz_select_data_sources source2
1314: WHERE source2.entity_attr_id = p_entity_attr_id
1315: AND source2.content_source_type = p_data_source_tab(i));
1316:
1317: -- Debug info.

Line 1564: FROM hz_select_data_sources

1560: CURSOR c_data_sources (
1561: p_entity_attr_id NUMBER
1562: ) IS
1563: SELECT content_source_type
1564: FROM hz_select_data_sources
1565: WHERE entity_attr_id = p_entity_attr_id;
1566:
1567: BEGIN
1568:

Line 1773: FROM hz_select_data_sources

1769: CURSOR c_selected_data_source (
1770: p_entity_attr_id NUMBER
1771: ) IS
1772: SELECT 'Y'
1773: FROM hz_select_data_sources
1774: WHERE entity_attr_id = p_entity_attr_id
1775: AND ranking > 0
1776: AND content_source_type <> 'USER_ENTERED'
1777: AND ROWNUM = 1;

Line 1843: DELETE hz_select_data_sources

1839: FETCH c_selected_data_source INTO l_dummy;
1840:
1841: IF c_selected_data_source%NOTFOUND THEN
1842: -- delete the data sources.
1843: DELETE hz_select_data_sources
1844: WHERE entity_attr_id = l_entity_attr_id;
1845:
1846: -- delete the entity and / or attribute.
1847: DELETE hz_entity_attributes

Line 2033: FROM hz_select_data_sources

2029: p_entity_attr_id NUMBER,
2030: p_data_source VARCHAR2
2031: ) IS
2032: SELECT 'Y'
2033: FROM hz_select_data_sources
2034: WHERE entity_attr_id = p_entity_attr_id
2035: AND content_source_type = p_data_source
2036: AND ranking > 0;
2037:

Line 2106: DELETE hz_select_data_sources

2102: FETCH c_data_source INTO l_dummy;
2103:
2104: IF c_data_source%NOTFOUND THEN
2105: -- delete the data sources.
2106: DELETE hz_select_data_sources
2107: WHERE entity_attr_id = l_entity_attr_id
2108: AND content_source_type = p_data_source_tbl(i);
2109: ELSE
2110: fnd_message.set_name('AR', 'HZ_CANNOT_DELETE_ENTITY_SOURCE');

Line 2127: FROM hz_select_data_sources

2123: DELETE hz_entity_attributes
2124: WHERE entity_attr_id = l_entity_attr_id
2125: AND NOT EXISTS (
2126: SELECT 'Y'
2127: FROM hz_select_data_sources
2128: WHERE entity_attr_id = l_entity_attr_id)
2129: RETURNING entity_attr_id BULK COLLECT INTO i_entity_attr_id;
2130:
2131: -- delete corresponding rules