2058: x_return_status IN OUT NOCOPY VARCHAR2
2059: ) is
2060: l_entity_name HZ_ENTITY_ATTRIBUTES.ENTITY_NAME%TYPE;
2061: l_attribute_name HZ_ENTITY_ATTRIBUTES.ATTRIBUTE_NAME%TYPE;
2062: p_entity_attribute_rec HZ_MIXNM_REGISTRY_PUB.ENTITY_ATTRIBUTE_REC_TYPE;
2063: x_entity_attr_id NUMBER;
2064: x_msg_count NUMBER;
2065: x_msg_data NUMBER;
2066: l_data_source_tbl HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL;
2062: p_entity_attribute_rec HZ_MIXNM_REGISTRY_PUB.ENTITY_ATTRIBUTE_REC_TYPE;
2063: x_entity_attr_id NUMBER;
2064: x_msg_count NUMBER;
2065: x_msg_data NUMBER;
2066: l_data_source_tbl HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL;
2067:
2068: CURSOR c_data_sources IS
2069: SELECT ENTITY_NAME,
2070: ATTRIBUTE_NAME
2131: p_entity_attribute_rec.entity_name := l_entity_name;
2132: p_entity_attribute_rec.attribute_name := l_attribute_name;
2133: p_entity_attribute_rec.created_by_module := 'TCA_MOSR_API';
2134: p_entity_attribute_rec.application_id := 222;
2135: l_data_source_tbl := HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL(p_orig_sys_rec.orig_system);
2136:
2137: HZ_MIXNM_REGISTRY_PUB.Add_EntityAttribute
2138: (p_entity_attribute_rec => p_entity_attribute_rec,
2139: p_data_source_tab => l_data_source_tbl,
2133: p_entity_attribute_rec.created_by_module := 'TCA_MOSR_API';
2134: p_entity_attribute_rec.application_id := 222;
2135: l_data_source_tbl := HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL(p_orig_sys_rec.orig_system);
2136:
2137: HZ_MIXNM_REGISTRY_PUB.Add_EntityAttribute
2138: (p_entity_attribute_rec => p_entity_attribute_rec,
2139: p_data_source_tab => l_data_source_tbl,
2140: x_entity_attr_id => x_entity_attr_id,
2141: x_return_status => x_return_status,
2164: x_entity_attr_id NUMBER;
2165: l_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;
2166: l_entity_name HZ_ENTITY_ATTRIBUTES.ENTITY_NAME%TYPE;
2167: l_attribute_name HZ_ENTITY_ATTRIBUTES.ATTRIBUTE_NAME%TYPE;
2168: p_entity_attribute_rec HZ_MIXNM_REGISTRY_PUB.ENTITY_ATTRIBUTE_REC_TYPE;
2169: l_data_source_tbl HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL;
2170: x_msg_count NUMBER;
2171: x_msg_data NUMBER;
2172:
2165: l_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;
2166: l_entity_name HZ_ENTITY_ATTRIBUTES.ENTITY_NAME%TYPE;
2167: l_attribute_name HZ_ENTITY_ATTRIBUTES.ATTRIBUTE_NAME%TYPE;
2168: p_entity_attribute_rec HZ_MIXNM_REGISTRY_PUB.ENTITY_ATTRIBUTE_REC_TYPE;
2169: l_data_source_tbl HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL;
2170: x_msg_count NUMBER;
2171: x_msg_data NUMBER;
2172:
2173: CURSOR c_data_sources IS
2270: p_entity_attribute_rec.entity_name := l_entity_name;
2271: p_entity_attribute_rec.attribute_name := l_attribute_name;
2272: p_entity_attribute_rec.created_by_module := 'TCA_MOSR_API';
2273: p_entity_attribute_rec.application_id := 222;
2274: l_data_source_tbl := HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL(l_orig_system);
2275:
2276: HZ_MIXNM_REGISTRY_PUB.Add_EntityAttribute
2277: (p_entity_attribute_rec => p_entity_attribute_rec,
2278: p_data_source_tab => l_data_source_tbl,
2272: p_entity_attribute_rec.created_by_module := 'TCA_MOSR_API';
2273: p_entity_attribute_rec.application_id := 222;
2274: l_data_source_tbl := HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL(l_orig_system);
2275:
2276: HZ_MIXNM_REGISTRY_PUB.Add_EntityAttribute
2277: (p_entity_attribute_rec => p_entity_attribute_rec,
2278: p_data_source_tab => l_data_source_tbl,
2279: x_entity_attr_id => x_entity_attr_id,
2280: x_return_status => x_return_status,