DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_42 dependencies on HZ_PARTY_ACQUIRE

Line 516: l_matched_value := HZ_PARTY_ACQUIRE.get_account_info (p_record_id, p_entity,'ALL_ACCOUNT_NAMES','Y');

512: RETURN l_matched_value;
513: END IF;
514: IF p_attribute = 'ALL_ACCOUNT_NAMES' THEN
515:
516: l_matched_value := HZ_PARTY_ACQUIRE.get_account_info (p_record_id, p_entity,'ALL_ACCOUNT_NAMES','Y');
517: RETURN l_matched_value;
518: END IF;
519: IF p_attribute = 'ALL_ACCOUNT_NUMBERS' THEN
520:

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

517: RETURN l_matched_value;
518: END IF;
519: IF p_attribute = 'ALL_ACCOUNT_NUMBERS' THEN
520:
521: l_matched_value := HZ_PARTY_ACQUIRE.get_account_info (p_record_id, p_entity,'ALL_ACCOUNT_NUMBERS','Y');
522: RETURN l_matched_value;
523: END IF;
524: IF p_attribute = 'JGZZ_FISCAL_CODE' THEN
525:

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

637: NULL;
638: END IF;
639: IF p_entity = 'PARTY_SITES' THEN
640: IF p_attribute = 'ADDRESS' THEN
641: l_matched_value := HZ_PARTY_ACQUIRE.get_address (p_record_id, p_entity,'ADDRESS','Y');
642: RETURN l_matched_value;
643: END IF;
644: IF p_attribute = 'CITY' THEN
645: BEGIN

Line 726: l_matched_value := HZ_PARTY_ACQUIRE.get_contact_name (p_record_id, p_entity,'CONTACT_NAME','Y');

722: NULL;
723: END IF;
724: IF p_entity = 'CONTACTS' THEN
725: IF p_attribute = 'CONTACT_NAME' THEN
726: l_matched_value := HZ_PARTY_ACQUIRE.get_contact_name (p_record_id, p_entity,'CONTACT_NAME','Y');
727: RETURN l_matched_value;
728: END IF;
729: NULL;
730: END IF;

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

729: NULL;
730: END IF;
731: IF p_entity = 'CONTACT_POINTS' THEN
732: IF p_attribute = 'FLEX_FORMAT_PHONE_NUMBER' THEN
733: l_matched_value := HZ_PARTY_ACQUIRE.get_phone_number (p_record_id, p_entity,'FLEX_FORMAT_PHONE_NUMBER','Y');
734: RETURN l_matched_value;
735: END IF;
736: IF p_attribute = 'EMAIL_ADDRESS' THEN
737: BEGIN

Line 7036: HZ_PARTY_ACQUIRE.get_account_info(p_party_id , 'PARTY','ALL_ACCOUNT_NAMES');

7032: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7033: 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);
7034: END IF;
7035: x_party_search_rec.ALL_ACCOUNT_NAMES:=
7036: HZ_PARTY_ACQUIRE.get_account_info(p_party_id , 'PARTY','ALL_ACCOUNT_NAMES');
7037: x_party_search_rec.ALL_ACCOUNT_NUMBERS:=
7038: HZ_PARTY_ACQUIRE.get_account_info(p_party_id , 'PARTY','ALL_ACCOUNT_NUMBERS');
7039:
7040: EXCEPTION

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

7034: END IF;
7035: x_party_search_rec.ALL_ACCOUNT_NAMES:=
7036: HZ_PARTY_ACQUIRE.get_account_info(p_party_id , 'PARTY','ALL_ACCOUNT_NAMES');
7037: x_party_search_rec.ALL_ACCOUNT_NUMBERS:=
7038: HZ_PARTY_ACQUIRE.get_account_info(p_party_id , 'PARTY','ALL_ACCOUNT_NUMBERS');
7039:
7040: EXCEPTION
7041: WHEN OTHERS THEN
7042: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

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

7095: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7096: 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);
7097: END IF;
7098: x_party_site_list(J).ADDRESS:=
7099: HZ_PARTY_ACQUIRE.get_address(l_party_site_id , 'PARTY_SITES','ADDRESS');
7100: J:=J+1;
7101:
7102: END LOOP;
7103: CLOSE c_party_sites;

Line 7157: HZ_PARTY_ACQUIRE.get_contact_name(l_org_contact_id , 'CONTACTS','CONTACT_NAME');

7153: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7154: 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);
7155: END IF;
7156: x_contact_list(J).CONTACT_NAME:=
7157: HZ_PARTY_ACQUIRE.get_contact_name(l_org_contact_id , 'CONTACTS','CONTACT_NAME');
7158:
7159: J:=J+1;
7160: END LOOP;
7161: CLOSE c_contacts;

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

7209: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7210: 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);
7211: END IF;
7212: x_contact_point_list(J).FLEX_FORMAT_PHONE_NUMBER:=
7213: HZ_PARTY_ACQUIRE.get_phone_number(l_contact_point_id , 'CONTACT_POINTS','FLEX_FORMAT_PHONE_NUMBER');
7214: J:=J+1;
7215:
7216: END LOOP;
7217: CLOSE c_cpts;