DBA Data[Home] [Help]

APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_MIXNM_REGISTRY_PUB

Line 2109: p_entity_attribute_rec HZ_MIXNM_REGISTRY_PUB.ENTITY_ATTRIBUTE_REC_TYPE;

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;
2113: l_data_source_tbl HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL;

Line 2113: l_data_source_tbl HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL;

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;
2113: l_data_source_tbl HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL;
2114:
2115: CURSOR c_data_sources IS
2116: SELECT ENTITY_NAME,
2117: ATTRIBUTE_NAME

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

2178: p_entity_attribute_rec.entity_name := l_entity_name;
2179: p_entity_attribute_rec.attribute_name := l_attribute_name;
2180: p_entity_attribute_rec.created_by_module := 'TCA_MOSR_API';
2181: p_entity_attribute_rec.application_id := 222;
2182: l_data_source_tbl := HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL(p_orig_sys_rec.orig_system);
2183:
2184: HZ_MIXNM_REGISTRY_PUB.Add_EntityAttribute
2185: (p_entity_attribute_rec => p_entity_attribute_rec,
2186: p_data_source_tab => l_data_source_tbl,

Line 2184: HZ_MIXNM_REGISTRY_PUB.Add_EntityAttribute

2180: p_entity_attribute_rec.created_by_module := 'TCA_MOSR_API';
2181: p_entity_attribute_rec.application_id := 222;
2182: l_data_source_tbl := HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL(p_orig_sys_rec.orig_system);
2183:
2184: HZ_MIXNM_REGISTRY_PUB.Add_EntityAttribute
2185: (p_entity_attribute_rec => p_entity_attribute_rec,
2186: p_data_source_tab => l_data_source_tbl,
2187: x_entity_attr_id => x_entity_attr_id,
2188: x_return_status => x_return_status,

Line 2215: p_entity_attribute_rec HZ_MIXNM_REGISTRY_PUB.ENTITY_ATTRIBUTE_REC_TYPE;

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;
2219:

Line 2216: l_data_source_tbl HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL;

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;
2219:
2220: CURSOR c_data_sources IS

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

2317: p_entity_attribute_rec.entity_name := l_entity_name;
2318: p_entity_attribute_rec.attribute_name := l_attribute_name;
2319: p_entity_attribute_rec.created_by_module := 'TCA_MOSR_API';
2320: p_entity_attribute_rec.application_id := 222;
2321: l_data_source_tbl := HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL(l_orig_system);
2322:
2323: HZ_MIXNM_REGISTRY_PUB.Add_EntityAttribute
2324: (p_entity_attribute_rec => p_entity_attribute_rec,
2325: p_data_source_tab => l_data_source_tbl,

Line 2323: HZ_MIXNM_REGISTRY_PUB.Add_EntityAttribute

2319: p_entity_attribute_rec.created_by_module := 'TCA_MOSR_API';
2320: p_entity_attribute_rec.application_id := 222;
2321: l_data_source_tbl := HZ_MIXNM_REGISTRY_PUB.DATA_SOURCE_TBL(l_orig_system);
2322:
2323: HZ_MIXNM_REGISTRY_PUB.Add_EntityAttribute
2324: (p_entity_attribute_rec => p_entity_attribute_rec,
2325: p_data_source_tab => l_data_source_tbl,
2326: x_entity_attr_id => x_entity_attr_id,
2327: x_return_status => x_return_status,