APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_ORIG_SYS_MAPPING

Line 314: FROM HZ_ORIG_SYS_MAPPING

310: -- check whether record has been updated by another user. If not, lock it.
311: BEGIN
312: SELECT OBJECT_VERSION_NUMBER
313: INTO l_object_version_number
314: FROM HZ_ORIG_SYS_MAPPING
315: WHERE ORIG_SYSTEM = p_orig_sys_entity_map_rec.orig_system
316: and owner_table_name = p_orig_sys_entity_map_rec.owner_table_name
317: FOR UPDATE OF ORIG_SYSTEM NOWAIT;
318:

Line 324: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_MAPPING');

320: null)
321: OR (p_object_version_number = l_object_version_number))
322: THEN
323: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
324: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_MAPPING');
325: FND_MSG_PUB.ADD;
326: x_return_status := FND_API.G_RET_STS_ERROR;
327: RAISE FND_API.G_EXC_ERROR;
328: END IF;

Line 334: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYS_MAPPING');

330: p_object_version_number := nvl(l_object_version_number, 1) + 1;
331:
332: EXCEPTION WHEN NO_DATA_FOUND THEN
333: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
334: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYS_MAPPING');
335: FND_MESSAGE.SET_TOKEN('VALUE', p_orig_sys_entity_map_rec.orig_system);
336: FND_MSG_PUB.ADD;
337: RAISE FND_API.G_EXC_ERROR;
338: END;

Line 1073: from hz_orig_sys_mapping

1069:
1070: --raji
1071: cursor get_multi_mosr_flag is
1072: select multi_osr_flag
1073: from hz_orig_sys_mapping
1074: where owner_table_name = l_orig_sys_reference_rec.owner_table_name
1075: and orig_system = l_orig_sys_reference_rec.orig_system
1076: /*and status ='A'*/;
1077:

Line 1250: from hz_orig_sys_mapping

1246: --raji
1247:
1248: cursor get_multi_mosr_flag is
1249: select multi_osr_flag
1250: from hz_orig_sys_mapping
1251: where owner_table_name = l_orig_sys_reference_rec.owner_table_name
1252: and orig_system = l_orig_sys_reference_rec.orig_system
1253: /*and status='A'*/;
1254:

Line 1594: from hz_orig_sys_mapping

1590: -- //introduce this new cursor,
1591:
1592: cursor get_multi_mosr_flag is
1593: select multi_osr_flag
1594: from hz_orig_sys_mapping
1595: where owner_table_name = p_owner_table_name
1596: and orig_system = (select orig_system from hz_orig_sys_references
1597: where owner_table_id = p_old_owner_table_id
1598: and owner_table_name = p_owner_table_name

Line 1878: from hz_orig_sys_mapping

1874: --//introduce this new cursor,
1875:
1876: cursor get_multi_mosr_flag(p_orig_system NUMBER) is
1877: select multi_osr_flag
1878: from hz_orig_sys_mapping
1879: where owner_table_name = p_owner_table_name
1880: and orig_system = (select orig_system from hz_orig_sys_references
1881: where owner_table_id = p_owner_table_id
1882: and owner_table_name = p_owner_table_name