APPS.AMS_REGISTRANTS_PVT dependencies on HZ_FUZZY_PUB

Line 176: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;

172: l_email_party_id number;
173: l_phone_party_id number;
174: l_count number;
175: l_max_party_id number;
176: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;
177: l_stat NUMBER := 0;
178: l_party_id NUMBER;
179:
180: NO_EMAIL_FOUND CONSTANT NUMBER := 10;

Line 233: l_per_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;

229:
230:
231: l_count number;
232: l_max_party_id number;
233: l_per_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;
234:
235: begin
236: /*
237: IF (AMS_DEBUG_HIGH_ON) THEN

Line 260: l_party_key := hz_fuzzy_pub.Generate_Key (

256:
257:
258: x_return_status := FND_API.g_ret_sts_success;
259: if p_rec.last_name is not null and p_rec.first_name is not null then
260: l_party_key := hz_fuzzy_pub.Generate_Key (
261: p_key_type => 'PERSON',
262: p_first_name => p_rec.first_name,
263: p_last_name => p_rec.last_name
264: );

Line 1837: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;

1833:
1834: l_party_key varchar2(1000);
1835: L_COUNT number;
1836: l_max_party_id number;
1837: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;
1838: l_cust_exists varchar2(1);
1839: l_ret_status varchar(1);
1840:
1841: cursor c_email_address is

Line 1889: l_party_key := hz_fuzzy_pub.Generate_Key ( p_key_type => 'PERSON'

1885: if ( (p_per_last_name is not null)
1886: and (p_per_first_name is not null)
1887: )
1888: then
1889: l_party_key := hz_fuzzy_pub.Generate_Key ( p_key_type => 'PERSON'
1890: , p_first_name => p_per_first_name
1891: , p_last_name => p_per_last_name
1892: );
1893: /*IF (AMS_DEBUG_HIGH_ON) THEN

Line 1974: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;

1970:
1971: l_party_key varchar2(1000);
1972: L_COUNT number;
1973: l_max_party_id number;
1974: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;
1975: x_org_party_id number;
1976: l_ps_party_id number;
1977: l_cust_exists varchar2(1);
1978: l_ret_status varchar(1);

Line 2014: l_party_key := hz_fuzzy_pub.Generate_Key (

2010: --
2011: -- Generates the customer key for ORGANIZATION
2012: --
2013: if p_org_name is not null then
2014: l_party_key := hz_fuzzy_pub.Generate_Key (
2015: p_key_type => 'ORGANIZATION',
2016: p_party_name => p_org_name
2017: );
2018: open c_customer_exists;

Line 2026: l_party_key := hz_fuzzy_pub.Generate_Key (

2022: --
2023: -- Generates the customer key for PERSON
2024: --
2025: if p_per_last_name is not null and p_per_first_name is not null then
2026: l_party_key := hz_fuzzy_pub.Generate_Key (
2027: p_key_type => 'PERSON',
2028: p_first_name => p_per_first_name,
2029: p_last_name => p_per_last_name
2030: );

Line 2096: hz_fuzzy_pub.FUZZY_SEARCH_PARTY(

2092: --
2093: if p_org_name is not null then
2094: L_COUNT := 0;
2095: l_max_party_id := 0;
2096: hz_fuzzy_pub.FUZZY_SEARCH_PARTY(
2097: 'ORGANIZATION',
2098: p_org_name,
2099: null,
2100: null,

Line 2121: hz_fuzzy_pub.FUZZY_SEARCH_PARTY(

2117: --
2118: if p_per_last_name is not null and p_per_first_name is not null then
2119: L_COUNT := 0;
2120: l_max_party_id := 0;
2121: hz_fuzzy_pub.FUZZY_SEARCH_PARTY(
2122: 'PERSON',
2123: null,
2124: p_per_first_name,
2125: p_per_last_name,

Line 2163: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;

2159: l_email_party_id number;
2160: l_phone_party_id number;
2161: L_COUNT number;
2162: l_max_party_id number;
2163: l_party_tbl hz_fuzzy_pub.PARTY_TBL_TYPE;
2164:
2165:
2166: cursor c_customer_exists is
2167: select 'Y' from hz_parties

Line 2251: l_party_key := hz_fuzzy_pub.Generate_Key (

2247: --
2248: -- Generates the customer key for PERSON
2249: --
2250: if p_per_last_name is not null and p_per_first_name is not null then
2251: l_party_key := hz_fuzzy_pub.Generate_Key (
2252: p_key_type => 'PERSON',
2253: p_first_name => p_per_first_name,
2254: p_last_name => p_per_last_name
2255: );

Line 2331: l_address_key := hz_fuzzy_pub.Generate_Key (

2327: and nvl(loc.city,p_city) = p_city;
2328:
2329: begin
2330:
2331: l_address_key := hz_fuzzy_pub.Generate_Key (
2332: p_key_type => 'ADDRESS',
2333: p_address1 => p_address1,
2334: p_postal_code => p_pcode
2335: );