APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_ENTITY_ATTRIBUTES

Line 2107: l_entity_name HZ_ENTITY_ATTRIBUTES.ENTITY_NAME%TYPE;

2103: p_orig_sys_rec IN OUT NOCOPY HZ_ORIG_SYSTEM_REF_PVT.ORIG_SYS_REC_TYPE,
2104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2105: x_return_status IN OUT NOCOPY VARCHAR2
2106: ) is
2107: l_entity_name HZ_ENTITY_ATTRIBUTES.ENTITY_NAME%TYPE;
2108: l_attribute_name HZ_ENTITY_ATTRIBUTES.ATTRIBUTE_NAME%TYPE;
2109: p_entity_attribute_rec HZ_MIXNM_REGISTRY_PUB.ENTITY_ATTRIBUTE_REC_TYPE;
2110: x_entity_attr_id NUMBER;
2111: x_msg_count NUMBER;

Line 2108: l_attribute_name HZ_ENTITY_ATTRIBUTES.ATTRIBUTE_NAME%TYPE;

2104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2105: x_return_status IN OUT NOCOPY VARCHAR2
2106: ) is
2107: l_entity_name HZ_ENTITY_ATTRIBUTES.ENTITY_NAME%TYPE;
2108: l_attribute_name HZ_ENTITY_ATTRIBUTES.ATTRIBUTE_NAME%TYPE;
2109: p_entity_attribute_rec HZ_MIXNM_REGISTRY_PUB.ENTITY_ATTRIBUTE_REC_TYPE;
2110: x_entity_attr_id NUMBER;
2111: x_msg_count NUMBER;
2112: x_msg_data NUMBER;

Line 2118: FROM HZ_ENTITY_ATTRIBUTES;

2114:
2115: CURSOR c_data_sources IS
2116: SELECT ENTITY_NAME,
2117: ATTRIBUTE_NAME
2118: FROM HZ_ENTITY_ATTRIBUTES;
2119: begin
2120:
2121: --Initialize API return status to success.
2122: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2213: l_entity_name HZ_ENTITY_ATTRIBUTES.ENTITY_NAME%TYPE;

2209: l_object_version_number NUMBER;
2210: l_sst_flag VARCHAR2(1);
2211: x_entity_attr_id NUMBER;
2212: l_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;
2213: l_entity_name HZ_ENTITY_ATTRIBUTES.ENTITY_NAME%TYPE;
2214: l_attribute_name HZ_ENTITY_ATTRIBUTES.ATTRIBUTE_NAME%TYPE;
2215: p_entity_attribute_rec HZ_MIXNM_REGISTRY_PUB.ENTITY_ATTRIBUTE_REC_TYPE;
2216: l_data_source_tbl HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL;
2217: x_msg_count NUMBER;

Line 2214: l_attribute_name HZ_ENTITY_ATTRIBUTES.ATTRIBUTE_NAME%TYPE;

2210: l_sst_flag VARCHAR2(1);
2211: x_entity_attr_id NUMBER;
2212: l_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;
2213: l_entity_name HZ_ENTITY_ATTRIBUTES.ENTITY_NAME%TYPE;
2214: l_attribute_name HZ_ENTITY_ATTRIBUTES.ATTRIBUTE_NAME%TYPE;
2215: p_entity_attribute_rec HZ_MIXNM_REGISTRY_PUB.ENTITY_ATTRIBUTE_REC_TYPE;
2216: l_data_source_tbl HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL;
2217: x_msg_count NUMBER;
2218: x_msg_data NUMBER;

Line 2223: FROM HZ_ENTITY_ATTRIBUTES;

2219:
2220: CURSOR c_data_sources IS
2221: SELECT ENTITY_NAME,
2222: ATTRIBUTE_NAME
2223: FROM HZ_ENTITY_ATTRIBUTES;
2224:
2225: begin
2226:
2227: --Initialize API return status to success.