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_PARTIES

Line 30: TYPE party_tbl_type is TABLE of hz_parties.party_id%TYPE

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;
32:
33:
34: /*===========================================================================+

Line 301: p_party_type IN HZ_PARTIES.PARTY_TYPE%TYPE,

297: | |
298: +===========================================================================*/
299:
300: PROCEDURE Fuzzy_Search_Party(
301: p_party_type IN HZ_PARTIES.PARTY_TYPE%TYPE,
302: p_party_name IN HZ_PARTIES.PARTY_NAME%TYPE DEFAULT NULL,
303: p_first_name IN HZ_PARTIES.PERSON_FIRST_NAME%TYPE DEFAULT NULL,
304: p_last_name IN HZ_PARTIES.PERSON_LAST_NAME%TYPE DEFAULT NULL,
305: p_party_tbl OUT NOCOPY PARTY_TBL_TYPE,

Line 302: p_party_name IN HZ_PARTIES.PARTY_NAME%TYPE DEFAULT NULL,

298: +===========================================================================*/
299:
300: PROCEDURE Fuzzy_Search_Party(
301: p_party_type IN HZ_PARTIES.PARTY_TYPE%TYPE,
302: p_party_name IN HZ_PARTIES.PARTY_NAME%TYPE DEFAULT NULL,
303: p_first_name IN HZ_PARTIES.PERSON_FIRST_NAME%TYPE DEFAULT NULL,
304: p_last_name IN HZ_PARTIES.PERSON_LAST_NAME%TYPE DEFAULT NULL,
305: p_party_tbl OUT NOCOPY PARTY_TBL_TYPE,
306: p_count OUT NOCOPY NUMBER

Line 303: p_first_name IN HZ_PARTIES.PERSON_FIRST_NAME%TYPE DEFAULT NULL,

299:
300: PROCEDURE Fuzzy_Search_Party(
301: p_party_type IN HZ_PARTIES.PARTY_TYPE%TYPE,
302: p_party_name IN HZ_PARTIES.PARTY_NAME%TYPE DEFAULT NULL,
303: p_first_name IN HZ_PARTIES.PERSON_FIRST_NAME%TYPE DEFAULT NULL,
304: p_last_name IN HZ_PARTIES.PERSON_LAST_NAME%TYPE DEFAULT NULL,
305: p_party_tbl OUT NOCOPY PARTY_TBL_TYPE,
306: p_count OUT NOCOPY NUMBER
307: );

Line 304: p_last_name IN HZ_PARTIES.PERSON_LAST_NAME%TYPE DEFAULT NULL,

300: PROCEDURE Fuzzy_Search_Party(
301: p_party_type IN HZ_PARTIES.PARTY_TYPE%TYPE,
302: p_party_name IN HZ_PARTIES.PARTY_NAME%TYPE DEFAULT NULL,
303: p_first_name IN HZ_PARTIES.PERSON_FIRST_NAME%TYPE DEFAULT NULL,
304: p_last_name IN HZ_PARTIES.PERSON_LAST_NAME%TYPE DEFAULT NULL,
305: p_party_tbl OUT NOCOPY PARTY_TBL_TYPE,
306: p_count OUT NOCOPY NUMBER
307: );
308: