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 1125: INSERT INTO hz_entity_attributes (

1121: p_prefix=>l_debug_prefix,
1122: p_msg_level=>fnd_log.level_procedure);
1123: END IF;
1124:
1125: INSERT INTO hz_entity_attributes (
1126: entity_attr_id,
1127: entity_name,
1128: attribute_name,
1129: attribute_group_name,

Line 1140: hz_entity_attributes_s.NEXTVAL,

1136: last_updated_by
1137: ) VALUES (
1138: --
1139: -- entity_attr_id
1140: hz_entity_attributes_s.NEXTVAL,
1141: DECODE(p_entity_attribute_rec.entity_name,
1142: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.entity_name),
1143: DECODE(p_entity_attribute_rec.attribute_name,
1144: FND_API.G_MISS_CHAR, NULL, p_entity_attribute_rec.attribute_name),

Line 1531: FROM hz_entity_attributes

1527: l_debug_prefix VARCHAR2(30) := '';
1528:
1529: CURSOR c_entity IS
1530: SELECT entity_attr_id
1531: FROM hz_entity_attributes
1532: WHERE entity_name = p_entity_name
1533: AND ((attribute_name IS NULL AND
1534: (p_attribute_name IS NULL OR
1535: p_attribute_name = FND_API.G_MISS_CHAR)) OR

Line 1740: FROM hz_entity_attributes

1736: l_debug_prefix VARCHAR2(30) := '';
1737:
1738: CURSOR c_entity IS
1739: SELECT entity_attr_id
1740: FROM hz_entity_attributes
1741: WHERE entity_name = p_entity_name
1742: AND ((attribute_name IS NULL AND
1743: (p_attribute_name IS NULL OR
1744: p_attribute_name = FND_API.G_MISS_CHAR)) OR

Line 1825: DELETE hz_entity_attributes

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
1826: WHERE entity_attr_id = l_entity_attr_id;
1827:
1828: -- delete corresponding rules
1829: DELETE hz_user_overwrite_rules

Line 1999: FROM hz_entity_attributes

1995: l_total NUMBER := 1;
1996:
1997: CURSOR c_entity IS
1998: SELECT entity_attr_id
1999: FROM hz_entity_attributes
2000: WHERE entity_name = p_entity_name
2001: AND ((attribute_name IS NULL AND
2002: (p_attribute_name IS NULL OR
2003: p_attribute_name = FND_API.G_MISS_CHAR)) OR

Line 2101: DELETE hz_entity_attributes

2097:
2098: -- delete the entity and / or attribute if there is no selected data
2099: -- source for it.
2100:
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