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 1044: from hz_orig_sys_mapping

1040:
1041: --raji
1042: cursor get_multi_mosr_flag is
1043: select multi_osr_flag
1044: from hz_orig_sys_mapping
1045: where owner_table_name = l_orig_sys_reference_rec.owner_table_name
1046: and orig_system = l_orig_sys_reference_rec.orig_system
1047: /*and status ='A'*/;
1048:

Line 1221: from hz_orig_sys_mapping

1217: --raji
1218:
1219: cursor get_multi_mosr_flag is
1220: select multi_osr_flag
1221: from hz_orig_sys_mapping
1222: where owner_table_name = l_orig_sys_reference_rec.owner_table_name
1223: and orig_system = l_orig_sys_reference_rec.orig_system
1224: /*and status='A'*/;
1225:

Line 1557: from hz_orig_sys_mapping

1553: -- //introduce this new cursor,
1554:
1555: cursor get_multi_mosr_flag is
1556: select multi_osr_flag
1557: from hz_orig_sys_mapping
1558: where owner_table_name = p_owner_table_name
1559: and orig_system = (select orig_system from hz_orig_sys_references
1560: where owner_table_id = p_old_owner_table_id
1561: and owner_table_name = p_owner_table_name

Line 1833: from hz_orig_sys_mapping

1829: --//introduce this new cursor,
1830:
1831: cursor get_multi_mosr_flag(p_orig_system NUMBER) is
1832: select multi_osr_flag
1833: from hz_orig_sys_mapping
1834: where owner_table_name = p_owner_table_name
1835: and orig_system = (select orig_system from hz_orig_sys_references
1836: where owner_table_id = p_owner_table_id
1837: and owner_table_name = p_owner_table_name