DBA Data[Home] [Help]

APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_MIXNM_REGISTRY_PUB

Line 2062: p_entity_attribute_rec HZ_MIXNM_REGISTRY_PUB.ENTITY_ATTRIBUTE_REC_TYPE;

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;

Line 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

Line 2135: l_data_source_tbl := HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL(p_orig_sys_rec.orig_system);

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,

Line 2137: HZ_MIXNM_REGISTRY_PUB.Add_EntityAttribute

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,

Line 2168: p_entity_attribute_rec HZ_MIXNM_REGISTRY_PUB.ENTITY_ATTRIBUTE_REC_TYPE;

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:

Line 2169: l_data_source_tbl HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL;

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

Line 2274: l_data_source_tbl := HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL(l_orig_system);

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,

Line 2276: HZ_MIXNM_REGISTRY_PUB.Add_EntityAttribute

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,