APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_ORIG_SYSTEMS_B

Line 2212: l_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;

2208: ) is
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;

Line 2235: FROM HZ_ORIG_SYSTEMS_B

2231:
2232: BEGIN
2233: SELECT OBJECT_VERSION_NUMBER, SST_FLAG, ORIG_SYSTEM
2234: INTO l_object_version_number, l_sst_flag, l_orig_system
2235: FROM HZ_ORIG_SYSTEMS_B
2236: WHERE orig_system_id = p_orig_sys_rec.orig_system_id
2237: FOR UPDATE OF ORIG_SYSTEM NOWAIT;
2238:
2239: IF NOT ((p_object_version_number is null and l_object_version_number is

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

2240: null)
2241: OR (p_object_version_number = l_object_version_number))
2242: THEN
2243: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2244: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYSTEMS_B');
2245: FND_MSG_PUB.ADD;
2246: x_return_status := FND_API.G_RET_STS_ERROR;
2247: RAISE FND_API.G_EXC_ERROR;
2248: END IF;

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

2250: p_object_version_number := nvl(l_object_version_number, 1) + 1;
2251:
2252: EXCEPTION WHEN NO_DATA_FOUND THEN
2253: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2254: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYSTEMS_B');
2255: FND_MESSAGE.SET_TOKEN('VALUE', p_orig_sys_rec.orig_system_id);
2256: FND_MSG_PUB.ADD;
2257: RAISE FND_API.G_EXC_ERROR;
2258: END;