DBA Data[Home] [Help]

APPS.HZ_ORIG_SYSTEM_REF_PUB dependencies on HZ_ORIG_SYS_REFERENCES

Line 426: FROM HZ_ORIG_SYS_REFERENCES

422: x_return_status out nocopy varchar2)
423: is
424: cursor get_owner_table_id_csr is
425: SELECT OWNER_TABLE_ID
426: FROM HZ_ORIG_SYS_REFERENCES
427: WHERE ORIG_SYSTEM = p_orig_system
428: and ORIG_SYSTEM_REFERENCE = p_orig_system_reference
429: and owner_table_name = p_owner_table_name
430: and status = 'A';

Line 448: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');

444: elsif l_count = 0
445: then
446: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
447: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
448: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
449: FND_MSG_PUB.ADD;
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: elsif l_count = 1
452: then