DBA Data[Home] [Help]

APPS.HZ_FUZZY_PUB dependencies on HZ_LOCATION_V2PUB

Line 489: p_address_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,

485: | |
486: +===========================================================================*/
487:
488: PROCEDURE Find_Duplicate_Address (
489: p_address_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
490: p_address_key IN VARCHAR2,
491: p_key_search_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE,
492: p_location_id OUT NOCOPY NUMBER,
493: p_is_duplicate OUT NOCOPY VARCHAR2)

Line 1344: l_address_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;

1340: p_msg_count OUT NOCOPY NUMBER,
1341: p_msg_data OUT NOCOPY VARCHAR2,
1342: p_location_id OUT NOCOPY NUMBER) IS
1343:
1344: l_address_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
1345: l_address_key VARCHAR2(2000);
1346: l_location_id NUMBER;
1347: l_is_duplicate VARCHAR2(10);
1348: