APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_ORIG_SYSTEMS_B

Line 2165: l_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;

2161: ) is
2162: l_object_version_number NUMBER;
2163: l_sst_flag VARCHAR2(1);
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;

Line 2188: FROM HZ_ORIG_SYSTEMS_B

2184:
2185: BEGIN
2186: SELECT OBJECT_VERSION_NUMBER, SST_FLAG, ORIG_SYSTEM
2187: INTO l_object_version_number, l_sst_flag, l_orig_system
2188: FROM HZ_ORIG_SYSTEMS_B
2189: WHERE orig_system_id = p_orig_sys_rec.orig_system_id
2190: FOR UPDATE OF ORIG_SYSTEM NOWAIT;
2191:
2192: IF NOT ((p_object_version_number is null and l_object_version_number is

Line 2197: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYSTEMS_B');

2193: null)
2194: OR (p_object_version_number = l_object_version_number))
2195: THEN
2196: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2197: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYSTEMS_B');
2198: FND_MSG_PUB.ADD;
2199: x_return_status := FND_API.G_RET_STS_ERROR;
2200: RAISE FND_API.G_EXC_ERROR;
2201: END IF;

Line 2207: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYSTEMS_B');

2203: p_object_version_number := nvl(l_object_version_number, 1) + 1;
2204:
2205: EXCEPTION WHEN NO_DATA_FOUND THEN
2206: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2207: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYSTEMS_B');
2208: FND_MESSAGE.SET_TOKEN('VALUE', p_orig_sys_rec.orig_system_id);
2209: FND_MSG_PUB.ADD;
2210: RAISE FND_API.G_EXC_ERROR;
2211: END;