APPS.HZ_MIXNM_REGISTRY_PUB dependencies on HZ_ENTITY_ATTRIBUTES

Line 238: FROM hz_entity_attributes

234: p_entity_name VARCHAR2,
235: p_attribute_name VARCHAR2
236: ) IS
237: SELECT entity_attr_id
238: FROM hz_entity_attributes
239: WHERE entity_name = p_entity_name
240: AND attribute_name = p_attribute_name;
241:
242: l_entity_attr_id NUMBER;

Line 308: FROM hz_entity_attributes

304: p_entity_name VARCHAR2,
305: p_attribute_name VARCHAR2
306: ) IS
307: SELECT entity_attr_id
308: FROM hz_entity_attributes
309: WHERE entity_name = p_entity_name
310: AND ((attribute_name IS NULL AND
311: (p_attribute_name IS NULL OR
312: p_attribute_name = FND_API.G_MISS_CHAR)) OR

Line 734: fnd_message.set_token('TABLE','hz_entity_attributes');

730: p_entity_attribute_rec.attribute_name <> FND_API.G_MISS_CHAR
731: THEN
732: fnd_message.set_name('AR','HZ_API_COLUMN_SHOULD_BE_NULL');
733: fnd_message.set_token('COLUMN','attribute_name');
734: fnd_message.set_token('TABLE','hz_entity_attributes');
735: fnd_msg_pub.add;
736: x_return_status := FND_API.G_RET_STS_ERROR;
737: ELSIF p_entity_attribute_rec.entity_name IN
738: (G_ORG_ENTITY, G_PERSON_ENTITY)

Line 1147: INSERT INTO hz_entity_attributes (

1143: p_prefix=>l_debug_prefix,
1144: p_msg_level=>fnd_log.level_procedure);
1145: END IF;
1146:
1147: INSERT INTO hz_entity_attributes (
1148: entity_attr_id,
1149: entity_name,
1150: attribute_name,
1151: attribute_group_name,

Line 1162: hz_entity_attributes_s.NEXTVAL,

1158: last_updated_by
1159: ) VALUES (
1160: --
1161: -- entity_attr_id
1162: hz_entity_attributes_s.NEXTVAL,
1163: DECODE(p_entity_attribute_rec.entity_name,
1164: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.entity_name),
1165: DECODE(p_entity_attribute_rec.attribute_name,
1166: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.attribute_name),

Line 1553: FROM hz_entity_attributes

1549: l_debug_prefix VARCHAR2(30) := '';
1550:
1551: CURSOR c_entity IS
1552: SELECT entity_attr_id
1553: FROM hz_entity_attributes
1554: WHERE entity_name = p_entity_name
1555: AND ((attribute_name IS NULL AND
1556: (p_attribute_name IS NULL OR
1557: p_attribute_name = FND_API.G_MISS_CHAR)) OR

Line 1762: FROM hz_entity_attributes

1758: l_debug_prefix VARCHAR2(30) := '';
1759:
1760: CURSOR c_entity IS
1761: SELECT entity_attr_id
1762: FROM hz_entity_attributes
1763: WHERE entity_name = p_entity_name
1764: AND ((attribute_name IS NULL AND
1765: (p_attribute_name IS NULL OR
1766: p_attribute_name = FND_API.G_MISS_CHAR)) OR

Line 1847: DELETE hz_entity_attributes

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
1848: WHERE entity_attr_id = l_entity_attr_id;
1849:
1850: -- delete corresponding rules
1851: DELETE hz_user_overwrite_rules

Line 2021: FROM hz_entity_attributes

2017: l_total NUMBER := 1;
2018:
2019: CURSOR c_entity IS
2020: SELECT entity_attr_id
2021: FROM hz_entity_attributes
2022: WHERE entity_name = p_entity_name
2023: AND ((attribute_name IS NULL AND
2024: (p_attribute_name IS NULL OR
2025: p_attribute_name = FND_API.G_MISS_CHAR)) OR

Line 2123: DELETE hz_entity_attributes

2119:
2120: -- delete the entity and / or attribute if there is no selected data
2121: -- source for it.
2122:
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