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_FUZZY_PUB dependencies on HZ_LOCATIONS

Line 27: TYPE location_tbl_type is TABLE of hz_locations.location_id%TYPE

23: address4 VARCHAR2(240):= FND_API.G_MISS_CHAR,
24: postal_code VARCHAR2(60):=FND_API.G_MISS_CHAR
25: );
26:
27: TYPE location_tbl_type is TABLE of hz_locations.location_id%TYPE
28: INDEX BY BINARY_INTEGER;
29:
30: TYPE party_tbl_type is TABLE of hz_parties.party_id%TYPE
31: INDEX BY BINARY_INTEGER;

Line 258: p_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE DEFAULT NULL,

254: | |
255: +===========================================================================*/
256:
257: PROCEDURE Fuzzy_Search_Address(
258: p_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE DEFAULT NULL,
259: p_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE DEFAULT NULL,
260: p_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE DEFAULT NULL,
261: p_address4 IN HZ_LOCATIONS.ADDRESS4%TYPE DEFAULT NULL,
262: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,

Line 259: p_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE DEFAULT NULL,

255: +===========================================================================*/
256:
257: PROCEDURE Fuzzy_Search_Address(
258: p_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE DEFAULT NULL,
259: p_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE DEFAULT NULL,
260: p_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE DEFAULT NULL,
261: p_address4 IN HZ_LOCATIONS.ADDRESS4%TYPE DEFAULT NULL,
262: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,
263: p_location_tbl OUT NOCOPY LOCATION_TBL_TYPE,

Line 260: p_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE DEFAULT NULL,

256:
257: PROCEDURE Fuzzy_Search_Address(
258: p_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE DEFAULT NULL,
259: p_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE DEFAULT NULL,
260: p_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE DEFAULT NULL,
261: p_address4 IN HZ_LOCATIONS.ADDRESS4%TYPE DEFAULT NULL,
262: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,
263: p_location_tbl OUT NOCOPY LOCATION_TBL_TYPE,
264: p_count OUT NOCOPY NUMBER

Line 261: p_address4 IN HZ_LOCATIONS.ADDRESS4%TYPE DEFAULT NULL,

257: PROCEDURE Fuzzy_Search_Address(
258: p_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE DEFAULT NULL,
259: p_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE DEFAULT NULL,
260: p_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE DEFAULT NULL,
261: p_address4 IN HZ_LOCATIONS.ADDRESS4%TYPE DEFAULT NULL,
262: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,
263: p_location_tbl OUT NOCOPY LOCATION_TBL_TYPE,
264: p_count OUT NOCOPY NUMBER
265: );

Line 262: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,

258: p_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE DEFAULT NULL,
259: p_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE DEFAULT NULL,
260: p_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE DEFAULT NULL,
261: p_address4 IN HZ_LOCATIONS.ADDRESS4%TYPE DEFAULT NULL,
262: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,
263: p_location_tbl OUT NOCOPY LOCATION_TBL_TYPE,
264: p_count OUT NOCOPY NUMBER
265: );
266: