DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_38 dependencies on HZ_PARTY_ACQUIRE

Line 399: l_matched_value := HZ_PARTY_ACQUIRE.get_known_as (p_record_id, p_entity,'PARTY_ALL_NAMES','Y');

395: BEGIN
396: IF p_entity = 'PARTY' THEN
397: IF p_attribute = 'PARTY_ALL_NAMES' THEN
398:
399: l_matched_value := HZ_PARTY_ACQUIRE.get_known_as (p_record_id, p_entity,'PARTY_ALL_NAMES','Y');
400: RETURN l_matched_value;
401: END IF;
402: NULL;
403: END IF;

Line 406: l_matched_value := HZ_PARTY_ACQUIRE.get_address (p_record_id, p_entity,'ADDRESS','Y');

402: NULL;
403: END IF;
404: IF p_entity = 'PARTY_SITES' THEN
405: IF p_attribute = 'ADDRESS' THEN
406: l_matched_value := HZ_PARTY_ACQUIRE.get_address (p_record_id, p_entity,'ADDRESS','Y');
407: RETURN l_matched_value;
408: END IF;
409: IF p_attribute = 'CITY' THEN
410: BEGIN

Line 512: l_matched_value := HZ_PARTY_ACQUIRE.get_phone_number (p_record_id, p_entity,'FLEX_FORMAT_PHONE_NUMBER','Y');

508: NULL;
509: END IF;
510: IF p_entity = 'CONTACT_POINTS' THEN
511: IF p_attribute = 'FLEX_FORMAT_PHONE_NUMBER' THEN
512: l_matched_value := HZ_PARTY_ACQUIRE.get_phone_number (p_record_id, p_entity,'FLEX_FORMAT_PHONE_NUMBER','Y');
513: RETURN l_matched_value;
514: END IF;
515: IF p_attribute = 'EMAIL_ADDRESS' THEN
516: BEGIN

Line 6012: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');

6008: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6009: hz_utility_v2pub.debug(p_message=>'Inside calling procedure - generate_custom_code',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
6010: END IF;
6011: x_party_search_rec.PARTY_ALL_NAMES:=
6012: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6013:
6014: EXCEPTION
6015: WHEN OTHERS THEN
6016: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

Line 6073: HZ_PARTY_ACQUIRE.get_address(l_party_site_id , 'PARTY_SITES','ADDRESS');

6069: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6070: hz_utility_v2pub.debug(p_message=>'Inside calling procedure - generate_custom_code',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
6071: END IF;
6072: x_party_site_list(J).ADDRESS:=
6073: HZ_PARTY_ACQUIRE.get_address(l_party_site_id , 'PARTY_SITES','ADDRESS');
6074: J:=J+1;
6075:
6076: END LOOP;
6077: CLOSE c_party_sites;

Line 6187: HZ_PARTY_ACQUIRE.get_phone_number(l_contact_point_id , 'CONTACT_POINTS','FLEX_FORMAT_PHONE_NUMBER');

6183: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6184: hz_utility_v2pub.debug(p_message=>'Inside calling procedure - generate_custom_code',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
6185: END IF;
6186: x_contact_point_list(J).FLEX_FORMAT_PHONE_NUMBER:=
6187: HZ_PARTY_ACQUIRE.get_phone_number(l_contact_point_id , 'CONTACT_POINTS','FLEX_FORMAT_PHONE_NUMBER');
6188: J:=J+1;
6189:
6190: END LOOP;
6191: CLOSE c_cpts;