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.AMS_LISTIMPORT_PVT dependencies on HZ_FUZZY_PUB

Line 13499: l_address_key := hz_fuzzy_pub.Generate_Key (

13495: and nvl(loc.city,nvl(p_city,'x')) = nvl(p_city,'x');
13496:
13497: begin
13498: x_return_status := FND_API.g_ret_sts_success;
13499: l_address_key := hz_fuzzy_pub.Generate_Key (
13500: p_key_type => 'ADDRESS',
13501: p_address1 => p_address1,
13502: p_postal_code => p_pcode
13503: );

Line 18553: hz_fuzzy_pub.Generate_Key('ORGANIZATION',b2b.party_name,null,null,null,null,null,null,null) "org_key"

18549: L_PARTY_NAME PARTY_NAME_LIST;
18550:
18551: cursor c_org_key is
18552: select b2b.party_name, 'N',
18553: hz_fuzzy_pub.Generate_Key('ORGANIZATION',b2b.party_name,null,null,null,null,null,null,null) "org_key"
18554: from ams_hz_b2b_mapping_v b2b
18555: where b2b.import_list_header_id = p_import_list_header_id
18556: and b2b.load_status in ('ACTIVE','RELOAD')
18557: and b2b.party_name is not null

Line 18822: hz_fuzzy_pub.Generate_Key('ORGANIZATION',b2b.party_name,null,null,null,null,null,null,null) "org_key"

18818: L_PARTY_NAME PARTY_NAME_LIST;
18819:
18820: cursor c_org_key is
18821: select b2b.party_name, 'N',
18822: hz_fuzzy_pub.Generate_Key('ORGANIZATION',b2b.party_name,null,null,null,null,null,null,null) "org_key"
18823: from ams_hz_b2b_mapping_v b2b
18824: where b2b.import_list_header_id = p_import_list_header_id
18825: and b2b.load_status in ('ACTIVE','RELOAD')
18826: and b2b.party_name is not null

Line 19103: hz_fuzzy_pub.Generate_Key('PERSON',null,null,null,null,null,null,b2c.PERSON_FIRST_NAME,b2c.PERSON_LAST_NAME) "per_key"

19099: L_person_status person_status_LIST;
19100:
19101: cursor c_per_key is
19102: select b2c.import_source_line_id, 'N',
19103: hz_fuzzy_pub.Generate_Key('PERSON',null,null,null,null,null,null,b2c.PERSON_FIRST_NAME,b2c.PERSON_LAST_NAME) "per_key"
19104: from ams_hz_b2c_mapping_v b2c
19105: where b2c.import_list_header_id = p_import_list_header_id
19106: and b2c.load_status in ('ACTIVE','RELOAD')
19107: and b2c.PERSON_FIRST_NAME is not null

Line 19418: hz_fuzzy_pub.Generate_Key('PERSON',null,null,null,null,null,null,b2c.PERSON_FIRST_NAME,b2c.PERSON_LAST_NAME) "per_key"

19414: L_person_PARTY_ID person_PARTY_ID_LIST;
19415:
19416: cursor c_per_key is
19417: select b2c.import_source_line_id, 'N',
19418: hz_fuzzy_pub.Generate_Key('PERSON',null,null,null,null,null,null,b2c.PERSON_FIRST_NAME,b2c.PERSON_LAST_NAME) "per_key"
19419: from ams_hz_b2c_mapping_v b2c
19420: where b2c.import_list_header_id = p_import_list_header_id
19421: and b2c.load_status in ('ACTIVE','RELOAD')
19422: and b2c.PERSON_FIRST_NAME is not null

Line 19693: hz_fuzzy_pub.Generate_Key('PERSON',null,null,null,null,null,null,b2b.PERSON_FIRST_NAME,b2b.PERSON_LAST_NAME)

19689: L_ocont_phnumb ocont_phnumb_LIST;
19690:
19691: cursor c_per_key is
19692: select b2b.import_source_line_id, 'N',
19693: hz_fuzzy_pub.Generate_Key('PERSON',null,null,null,null,null,null,b2b.PERSON_FIRST_NAME,b2b.PERSON_LAST_NAME)
19694: "per_key"
19695: from ams_hz_b2b_mapping_v b2b
19696: where b2b.import_list_header_id = p_import_list_header_id
19697: and b2b.load_status in ('ACTIVE','RELOAD')

Line 20071: hz_fuzzy_pub.Generate_Key('PERSON',null,null,null,null,null,null,b2b.PERSON_FIRST_NAME,b2b.PERSON_LAST_NAME)

20067: L_ocont_PARTY_ID ocont_PARTY_ID_LIST;
20068:
20069: cursor c_per_key is
20070: select b2b.import_source_line_id, 'N',
20071: hz_fuzzy_pub.Generate_Key('PERSON',null,null,null,null,null,null,b2b.PERSON_FIRST_NAME,b2b.PERSON_LAST_NAME)
20072: "per_key"
20073: from ams_hz_b2b_mapping_v b2b
20074: where b2b.import_list_header_id = p_import_list_header_id
20075: and b2b.load_status in ('ACTIVE','RELOAD')

Line 20383: hz_fuzzy_pub.Generate_Key('ADDRESS',null,b2b.address1,b2b.address2,b2b.address3,b2b.address4,b2b.postal_code,null,null)

20379: L_PARTY_location_ID PARTY_location_ID_LIST;
20380:
20381: cursor c_addr_key is
20382: select b2b.import_source_line_id,
20383: hz_fuzzy_pub.Generate_Key('ADDRESS',null,b2b.address1,b2b.address2,b2b.address3,b2b.address4,b2b.postal_code,null,null)
20384: "add_key"
20385: from ams_hz_b2b_mapping_v b2b
20386: where b2b.import_list_header_id = p_import_list_header_id
20387: and b2b.load_status in ('ACTIVE','RELOAD')

Line 20541: hz_fuzzy_pub.Generate_Key('ADDRESS',null,b2b.org_address1,b2b.org_address2,b2b.org_address3,b2b.org_address4,b2b.org_postal_code,null,null)

20537: L_org_location_ID party_location_ID_LIST;
20538:
20539: cursor c_addr_key is
20540: select b2b.import_source_line_id,
20541: hz_fuzzy_pub.Generate_Key('ADDRESS',null,b2b.org_address1,b2b.org_address2,b2b.org_address3,b2b.org_address4,b2b.org_postal_code,null,null)
20542: "add_key"
20543: from ams_hz_b2b_mapping_v b2b
20544: where b2b.import_list_header_id = p_import_list_header_id
20545: and b2b.load_status in ('ACTIVE','RELOAD')

Line 20699: hz_fuzzy_pub.Generate_Key('ADDRESS',null,b2c.address1,b2c.address2,b2c.address3,b2c.address4,b2c.postal_code,null,null)

20695: L_PARTY_location_ID PARTY_location_ID_LIST;
20696:
20697: cursor c_addr_key is
20698: select b2c.import_source_line_id,
20699: hz_fuzzy_pub.Generate_Key('ADDRESS',null,b2c.address1,b2c.address2,b2c.address3,b2c.address4,b2c.postal_code,null,null)
20700: "add_key"
20701: from ams_hz_b2c_mapping_v b2c
20702: where b2c.import_list_header_id = p_import_list_header_id
20703: and b2c.load_status in ('ACTIVE','RELOAD')