DBA Data[Home] [Help]

APPS.CAC_SYNC_CONTACT_DQM_PVT dependencies on HZ_PARTY_SEARCH

Line 65: RETURN hz_party_search.contact_search_rec_type

61: , p_person_name_suffix IN VARCHAR2
62: , p_person_title IN VARCHAR2
63: , p_job_title IN VARCHAR2
64: )
65: RETURN hz_party_search.contact_search_rec_type
66: IS
67: l_contact_search_rec hz_party_search.contact_search_rec_type;
68: BEGIN
69: l_contact_search_rec.contact_name := p_contact_name;

Line 67: l_contact_search_rec hz_party_search.contact_search_rec_type;

63: , p_job_title IN VARCHAR2
64: )
65: RETURN hz_party_search.contact_search_rec_type
66: IS
67: l_contact_search_rec hz_party_search.contact_search_rec_type;
68: BEGIN
69: l_contact_search_rec.contact_name := p_contact_name;
70: l_contact_search_rec.person_name := p_person_name;
71: l_contact_search_rec.person_first_name := p_person_first_name;

Line 90: , x_contact_point_list IN OUT NOCOPY hz_party_search.contact_point_list

86: , p_phone_area_code IN VARCHAR2
87: , p_phone_number IN VARCHAR2
88: , p_contact_point_purpose IN VARCHAR2
89: , p_status IN VARCHAR2
90: , x_contact_point_list IN OUT NOCOPY hz_party_search.contact_point_list
91: )
92: IS
93: l_index NUMBER;
94: BEGIN

Line 115: ,x_contact_point_list IN OUT NOCOPY hz_party_search.contact_point_list

111: p_contact_point_type IN VARCHAR2
112: ,p_email_format IN VARCHAR2
113: ,p_email_address IN VARCHAR2
114: ,p_status IN VARCHAR2
115: ,x_contact_point_list IN OUT NOCOPY hz_party_search.contact_point_list
116: )
117: IS
118: l_index NUMBER;
119: BEGIN

Line 147: , x_contact_point_list IN OUT NOCOPY hz_party_search.contact_point_list

143: , p_cell_phone_area_code IN VARCHAR2
144: , p_cell_phone_number IN VARCHAR2
145: , p_text_email_address IN VARCHAR2
146: , p_html_email_address IN VARCHAR2
147: , x_contact_point_list IN OUT NOCOPY hz_party_search.contact_point_list
148: )
149: IS
150: BEGIN
151: get_contact_point_search_rec

Line 258: l_party_search_rec hz_party_search.party_search_rec_type;

254: , x_msg_count OUT NOCOPY NUMBER
255: , x_msg_data OUT NOCOPY VARCHAR2
256: )
257: IS
258: l_party_search_rec hz_party_search.party_search_rec_type;
259: l_party_site_list hz_party_search.party_site_list;
260: l_contact_list hz_party_search.contact_list;
261: l_contact_point_list hz_party_search.contact_point_list;
262: l_search_ctx_id NUMBER;

Line 259: l_party_site_list hz_party_search.party_site_list;

255: , x_msg_data OUT NOCOPY VARCHAR2
256: )
257: IS
258: l_party_search_rec hz_party_search.party_search_rec_type;
259: l_party_site_list hz_party_search.party_site_list;
260: l_contact_list hz_party_search.contact_list;
261: l_contact_point_list hz_party_search.contact_point_list;
262: l_search_ctx_id NUMBER;
263: l_num_matches NUMBER;

Line 260: l_contact_list hz_party_search.contact_list;

256: )
257: IS
258: l_party_search_rec hz_party_search.party_search_rec_type;
259: l_party_site_list hz_party_search.party_site_list;
260: l_contact_list hz_party_search.contact_list;
261: l_contact_point_list hz_party_search.contact_point_list;
262: l_search_ctx_id NUMBER;
263: l_num_matches NUMBER;
264: l_rule_id NUMBER;

Line 261: l_contact_point_list hz_party_search.contact_point_list;

257: IS
258: l_party_search_rec hz_party_search.party_search_rec_type;
259: l_party_site_list hz_party_search.party_site_list;
260: l_contact_list hz_party_search.contact_list;
261: l_contact_point_list hz_party_search.contact_point_list;
262: l_search_ctx_id NUMBER;
263: l_num_matches NUMBER;
264: l_rule_id NUMBER;
265: BEGIN

Line 287: hz_party_search.find_parties(

283: l_party_search_rec.party_name := p_organization_name;
284: l_party_search_rec.party_type := 'ORGANIZATION';
285: l_party_search_rec.status := 'A';
286:
287: hz_party_search.find_parties(
288: p_init_msg_list => fnd_api.g_false,
289: x_rule_id => l_rule_id,
290: p_party_search_rec => l_party_search_rec,
291: p_party_site_list => l_party_site_list,

Line 376: l_contact_list hz_party_search.contact_list;

372: , x_num_of_matches OUT NOCOPY NUMBER
373: , x_party_id OUT NOCOPY NUMBER
374: )
375: IS
376: l_contact_list hz_party_search.contact_list;
377: l_contact_point_list hz_party_search.contact_point_list;
378: l_search_ctx_id NUMBER;
379: l_rule_id NUMBER;
380: l_num_matches NUMBER;

Line 377: l_contact_point_list hz_party_search.contact_point_list;

373: , x_party_id OUT NOCOPY NUMBER
374: )
375: IS
376: l_contact_list hz_party_search.contact_list;
377: l_contact_point_list hz_party_search.contact_point_list;
378: l_search_ctx_id NUMBER;
379: l_rule_id NUMBER;
380: l_num_matches NUMBER;
381: l_index NUMBER;

Line 434: hz_party_search.get_matching_contacts(

430: , x_contact_point_list => l_contact_point_list
431: );
432:
433: -- Perform DQM check for contacts
434: hz_party_search.get_matching_contacts(
435: p_init_msg_list => fnd_api.g_false,
436: p_rule_id => l_rule_id,
437: p_party_id => p_org_party_id,
438: p_contact_list => l_contact_list,