DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_62 dependencies on HZ_PARTY_ACQUIRE

Line 433: l_matched_value := HZ_PARTY_ACQUIRE.get_account_info (p_record_id, p_entity,'ALL_ACCOUNT_NUMBERS','Y');

429: RETURN l_matched_value;
430: END IF;
431: IF p_attribute = 'ALL_ACCOUNT_NUMBERS' THEN
432:
433: l_matched_value := HZ_PARTY_ACQUIRE.get_account_info (p_record_id, p_entity,'ALL_ACCOUNT_NUMBERS','Y');
434: RETURN l_matched_value;
435: END IF;
436: IF p_attribute = 'PARTY_ALL_NAMES' THEN
437:

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

434: RETURN l_matched_value;
435: END IF;
436: IF p_attribute = 'PARTY_ALL_NAMES' THEN
437:
438: l_matched_value := HZ_PARTY_ACQUIRE.get_known_as (p_record_id, p_entity,'PARTY_ALL_NAMES','Y');
439: RETURN l_matched_value;
440: END IF;
441: IF p_attribute = 'DUNS_NUMBER_C' THEN
442:

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

480: NULL;
481: END IF;
482: IF p_entity = 'PARTY_SITES' THEN
483: IF p_attribute = 'ADDRESS' THEN
484: l_matched_value := HZ_PARTY_ACQUIRE.get_address (p_record_id, p_entity,'ADDRESS','Y');
485: RETURN l_matched_value;
486: END IF;
487: IF p_attribute = 'CITY' THEN
488: BEGIN

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

555: NULL;
556: END IF;
557: IF p_entity = 'CONTACT_POINTS' THEN
558: IF p_attribute = 'FLEX_FORMAT_PHONE_NUMBER' THEN
559: l_matched_value := HZ_PARTY_ACQUIRE.get_phone_number (p_record_id, p_entity,'FLEX_FORMAT_PHONE_NUMBER','Y');
560: RETURN l_matched_value;
561: END IF;
562: IF p_attribute = 'URL' THEN
563: BEGIN

Line 6397: HZ_PARTY_ACQUIRE.get_account_info(p_party_id , 'PARTY','ALL_ACCOUNT_NUMBERS');

6393: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6394: 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);
6395: END IF;
6396: x_party_search_rec.ALL_ACCOUNT_NUMBERS:=
6397: HZ_PARTY_ACQUIRE.get_account_info(p_party_id , 'PARTY','ALL_ACCOUNT_NUMBERS');
6398: x_party_search_rec.PARTY_ALL_NAMES:=
6399: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6400:
6401: EXCEPTION

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

6395: END IF;
6396: x_party_search_rec.ALL_ACCOUNT_NUMBERS:=
6397: HZ_PARTY_ACQUIRE.get_account_info(p_party_id , 'PARTY','ALL_ACCOUNT_NUMBERS');
6398: x_party_search_rec.PARTY_ALL_NAMES:=
6399: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6400:
6401: EXCEPTION
6402: WHEN OTHERS THEN
6403: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

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

6454: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6455: 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);
6456: END IF;
6457: x_party_site_list(J).ADDRESS:=
6458: HZ_PARTY_ACQUIRE.get_address(l_party_site_id , 'PARTY_SITES','ADDRESS');
6459: J:=J+1;
6460:
6461: END LOOP;
6462: CLOSE c_party_sites;

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

6566: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6567: 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);
6568: END IF;
6569: x_contact_point_list(J).FLEX_FORMAT_PHONE_NUMBER:=
6570: HZ_PARTY_ACQUIRE.get_phone_number(l_contact_point_id , 'CONTACT_POINTS','FLEX_FORMAT_PHONE_NUMBER');
6571: J:=J+1;
6572:
6573: END LOOP;
6574: CLOSE c_cpts;