APPS.AMS_LIST_IMPORT_PUB dependencies on HZ_FUZZY_PUB

Line 1369: l_address_key :=hz_fuzzy_pub.Generate_Key (

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

Line 2984: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;

2980:
2981: l_party_key varchar2(1000);
2982: L_COUNT number;
2983: l_max_party_id number;
2984: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;
2985: x_org_party_id number;
2986: l_ps_party_id number;
2987: l_cust_exists varchar2(1);
2988: l_ret_status varchar(1);

Line 3081: l_party_key := hz_fuzzy_pub.Generate_Key (

3077: -- Generates the customer key for ORGANIZATION
3078: --
3079: x_return_status := FND_API.g_ret_sts_success;
3080: if p_org_name is not null then
3081: l_party_key := hz_fuzzy_pub.Generate_Key (
3082: p_key_type => 'ORGANIZATION',
3083: p_party_name => p_org_name
3084: );
3085: -- sranka 1/13/2003

Line 3224: hz_fuzzy_pub.FUZZY_SEARCH_PARTY(

3220: --
3221: if p_per_last_name is not null and p_per_first_name is not null then
3222: L_COUNT := 0;
3223: l_max_party_id := 0;
3224: hz_fuzzy_pub.FUZZY_SEARCH_PARTY(
3225: 'PERSON',
3226: null,
3227: p_per_first_name,
3228: p_per_last_name,

Line 3606: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;

3602: l_email_party_id number;
3603: l_phone_party_id number;
3604: L_COUNT number;
3605: l_max_party_id number;
3606: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;
3607: l_transposed_phone_no varchar(60);
3608:
3609: cursor c_customer_exists is
3610: select 'Y' from hz_parties

Line 3827: l_party_key := hz_fuzzy_pub.Generate_Key (

3823: --
3824: -- Generates the customer key for PERSON
3825: --
3826: if p_per_last_name is not null and p_per_first_name is not null then
3827: l_party_key := hz_fuzzy_pub.Generate_Key (
3828: p_key_type => 'PERSON',
3829: p_first_name => p_per_first_name,
3830: p_last_name => p_per_last_name
3831: );

Line 3989: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;

3985: L_COUNT number;
3986: l_max_party_id number;
3987: l_rel_party_id number;
3988: l_per_party_id number;
3989: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;
3990:
3991:
3992: cursor c_customer_exists is
3993: select MAX(PARTY_ID) from hz_parties

Line 4041: l_party_key := hz_fuzzy_pub.Generate_Key (

4037: --
4038: -- Generates the customer key for PERSON
4039: --
4040: if p_per_last_name is not null and p_per_first_name is not null then
4041: l_party_key := hz_fuzzy_pub.Generate_Key (
4042: p_key_type => 'PERSON',
4043: p_first_name => p_per_first_name,
4044: p_last_name => p_per_last_name
4045: );

Line 4367: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;

4363:
4364: l_party_key varchar2(1000);
4365: L_COUNT number;
4366: l_max_party_id number;
4367: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;
4368: l_cust_exists varchar2(1);
4369: l_ret_status varchar(1);
4370: l_transposed_phone_no varchar2(60);
4371:

Line 4471: l_party_key := hz_fuzzy_pub.Generate_Key (

4467: --
4468: -- Generates the customer key for PERSON
4469: --
4470: if p_per_last_name is not null and p_per_first_name is not null then
4471: l_party_key := hz_fuzzy_pub.Generate_Key (
4472: p_key_type => 'PERSON',
4473: p_first_name => p_per_first_name,
4474: p_last_name => p_per_last_name
4475: );

Line 4613: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;

4609:
4610: l_party_key varchar2(1000);
4611: L_COUNT number;
4612: l_max_party_id number;
4613: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;
4614: l_cust_exists varchar2(1);
4615: l_ret_status varchar(1);
4616: l_transposed_phone_no varchar2(60);
4617:

Line 4761: l_party_key := hz_fuzzy_pub.Generate_Key (

4757: --
4758: -- Generates the customer key for PERSON
4759: --
4760: if p_per_last_name is not null and p_per_first_name is not null then
4761: l_party_key := hz_fuzzy_pub.Generate_Key (
4762: p_key_type => 'PERSON',
4763: p_first_name => p_per_first_name,
4764: p_last_name => p_per_last_name
4765: );

Line 4901: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;

4897:
4898: l_party_key varchar2(1000);
4899: L_COUNT number;
4900: l_max_party_id number;
4901: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;
4902: l_cust_exists varchar2(1);
4903: l_ret_status varchar(1);
4904:
4905:

Line 4936: l_party_key := hz_fuzzy_pub.Generate_Key (

4932: --
4933: -- Generates the customer key for PERSON
4934: --
4935: if p_per_last_name is not null and p_per_first_name is not null then
4936: l_party_key := hz_fuzzy_pub.Generate_Key (
4937: p_key_type => 'PERSON',
4938: p_first_name => p_per_first_name,
4939: p_last_name => p_per_last_name
4940: );