eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PARTY_V2PUB dependencies on HZ_ORIG_SYS_REFERENCES

Line 2389: l_orig_system HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM%TYPE;

2385: l_debug_prefix VARCHAR2(30) := '';
2386:
2387: -- Bug 4239442 : Added cursor and variables
2388: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
2389: l_orig_system HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM%TYPE;
2390: l_orig_system_reference HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE%TYPE;
2391: l_created_by_module HZ_ORIG_SYS_REFERENCES.CREATED_BY_MODULE%TYPE;
2392: l_exists VARCHAR2(1);
2393: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2390: l_orig_system_reference HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE%TYPE;

2386:
2387: -- Bug 4239442 : Added cursor and variables
2388: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
2389: l_orig_system HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM%TYPE;
2390: l_orig_system_reference HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE%TYPE;
2391: l_created_by_module HZ_ORIG_SYS_REFERENCES.CREATED_BY_MODULE%TYPE;
2392: l_exists VARCHAR2(1);
2393: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2394: l_msg_count NUMBER;

Line 2391: l_created_by_module HZ_ORIG_SYS_REFERENCES.CREATED_BY_MODULE%TYPE;

2387: -- Bug 4239442 : Added cursor and variables
2388: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
2389: l_orig_system HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM%TYPE;
2390: l_orig_system_reference HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE%TYPE;
2391: l_created_by_module HZ_ORIG_SYS_REFERENCES.CREATED_BY_MODULE%TYPE;
2392: l_exists VARCHAR2(1);
2393: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2394: l_msg_count NUMBER;
2395: l_msg_data VARCHAR2(2000);

Line 2400: FROM hz_orig_sys_references

2396:
2397: CURSOR c_check_party_mapping
2398: IS
2399: SELECT 'Y'
2400: FROM hz_orig_sys_references
2401: WHERE owner_table_id = p_party_id
2402: AND owner_table_name = 'HZ_PARTIES'
2403: AND orig_system = l_orig_system
2404: AND orig_system_reference = l_orig_system_reference