APPS.AMS_LIST_IMPORT_PUB dependencies on HZ_FUZZY_PUB

Line 1373: l_address_key :=hz_fuzzy_pub.Generate_Key (

1369: x_msg_count := null;
1370: x_msg_data := null;
1371: if (l_rec_update_flag = 'N' or (l_rec_update_flag = 'Y' and x_org_location_id is NULL)) then
1372:
1373: l_address_key :=hz_fuzzy_pub.Generate_Key (
1374: p_key_type => 'ADDRESS',
1375: p_address1 => org_location_rec.address1,
1376: p_postal_code => org_location_rec.postal_code);
1377:

Line 2991: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;

2987:
2988: l_party_key varchar2(1000);
2989: L_COUNT number;
2990: l_max_party_id number;
2991: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;
2992: x_org_party_id number;
2993: l_ps_party_id number;
2994: l_cust_exists varchar2(1);
2995: l_ret_status varchar(1);

Line 3088: l_party_key := hz_fuzzy_pub.Generate_Key (

3084: -- Generates the customer key for ORGANIZATION
3085: --
3086: x_return_status := FND_API.g_ret_sts_success;
3087: if p_org_name is not null then
3088: l_party_key := hz_fuzzy_pub.Generate_Key (
3089: p_key_type => 'ORGANIZATION',
3090: p_party_name => p_org_name
3091: );
3092: -- sranka 1/13/2003

Line 3231: hz_fuzzy_pub.FUZZY_SEARCH_PARTY(

3227: --
3228: if p_per_last_name is not null and p_per_first_name is not null then
3229: L_COUNT := 0;
3230: l_max_party_id := 0;
3231: hz_fuzzy_pub.FUZZY_SEARCH_PARTY(
3232: 'PERSON',
3233: null,
3234: p_per_first_name,
3235: p_per_last_name,

Line 3613: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;

3609: l_email_party_id number;
3610: l_phone_party_id number;
3611: L_COUNT number;
3612: l_max_party_id number;
3613: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;
3614: l_transposed_phone_no varchar(60);
3615:
3616: cursor c_customer_exists is
3617: select 'Y' from hz_parties

Line 3834: l_party_key := hz_fuzzy_pub.Generate_Key (

3830: --
3831: -- Generates the customer key for PERSON
3832: --
3833: if p_per_last_name is not null and p_per_first_name is not null then
3834: l_party_key := hz_fuzzy_pub.Generate_Key (
3835: p_key_type => 'PERSON',
3836: p_first_name => p_per_first_name,
3837: p_last_name => p_per_last_name
3838: );

Line 3996: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;

3992: L_COUNT number;
3993: l_max_party_id number;
3994: l_rel_party_id number;
3995: l_per_party_id number;
3996: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;
3997:
3998:
3999: cursor c_customer_exists is
4000: select MAX(PARTY_ID) from hz_parties

Line 4048: l_party_key := hz_fuzzy_pub.Generate_Key (

4044: --
4045: -- Generates the customer key for PERSON
4046: --
4047: if p_per_last_name is not null and p_per_first_name is not null then
4048: l_party_key := hz_fuzzy_pub.Generate_Key (
4049: p_key_type => 'PERSON',
4050: p_first_name => p_per_first_name,
4051: p_last_name => p_per_last_name
4052: );

Line 4374: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;

4370:
4371: l_party_key varchar2(1000);
4372: L_COUNT number;
4373: l_max_party_id number;
4374: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;
4375: l_cust_exists varchar2(1);
4376: l_ret_status varchar(1);
4377: l_transposed_phone_no varchar2(60);
4378:

Line 4478: l_party_key := hz_fuzzy_pub.Generate_Key (

4474: --
4475: -- Generates the customer key for PERSON
4476: --
4477: if p_per_last_name is not null and p_per_first_name is not null then
4478: l_party_key := hz_fuzzy_pub.Generate_Key (
4479: p_key_type => 'PERSON',
4480: p_first_name => p_per_first_name,
4481: p_last_name => p_per_last_name
4482: );

Line 4620: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;

4616:
4617: l_party_key varchar2(1000);
4618: L_COUNT number;
4619: l_max_party_id number;
4620: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;
4621: l_cust_exists varchar2(1);
4622: l_ret_status varchar(1);
4623: l_transposed_phone_no varchar2(60);
4624:

Line 4768: l_party_key := hz_fuzzy_pub.Generate_Key (

4764: --
4765: -- Generates the customer key for PERSON
4766: --
4767: if p_per_last_name is not null and p_per_first_name is not null then
4768: l_party_key := hz_fuzzy_pub.Generate_Key (
4769: p_key_type => 'PERSON',
4770: p_first_name => p_per_first_name,
4771: p_last_name => p_per_last_name
4772: );

Line 4908: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;

4904:
4905: l_party_key varchar2(1000);
4906: L_COUNT number;
4907: l_max_party_id number;
4908: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;
4909: l_cust_exists varchar2(1);
4910: l_ret_status varchar(1);
4911:
4912:

Line 4943: l_party_key := hz_fuzzy_pub.Generate_Key (

4939: --
4940: -- Generates the customer key for PERSON
4941: --
4942: if p_per_last_name is not null and p_per_first_name is not null then
4943: l_party_key := hz_fuzzy_pub.Generate_Key (
4944: p_key_type => 'PERSON',
4945: p_first_name => p_per_first_name,
4946: p_last_name => p_per_last_name
4947: );