DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_41 dependencies on HZ_PARTY_ACQUIRE

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

365: NULL;
366: END IF;
367: IF p_entity = 'PARTY_SITES' THEN
368: IF p_attribute = 'ADDRESS' THEN
369: l_matched_value := HZ_PARTY_ACQUIRE.get_address (p_record_id, p_entity,'ADDRESS','Y');
370: RETURN l_matched_value;
371: END IF;
372: IF p_attribute = 'POSTAL_CODE' THEN
373: BEGIN

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

388: NULL;
389: END IF;
390: IF p_entity = 'CONTACT_POINTS' THEN
391: IF p_attribute = 'FLEX_FORMAT_PHONE_NUMBER' THEN
392: l_matched_value := HZ_PARTY_ACQUIRE.get_phone_number (p_record_id, p_entity,'FLEX_FORMAT_PHONE_NUMBER','Y');
393: RETURN l_matched_value;
394: END IF;
395: IF p_attribute = 'EMAIL_ADDRESS' THEN
396: BEGIN

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

5796: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5797: 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);
5798: END IF;
5799: x_party_site_list(J).ADDRESS:=
5800: HZ_PARTY_ACQUIRE.get_address(l_party_site_id , 'PARTY_SITES','ADDRESS');
5801: J:=J+1;
5802:
5803: END LOOP;
5804: CLOSE c_party_sites;

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

5908: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5909: 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);
5910: END IF;
5911: x_contact_point_list(J).FLEX_FORMAT_PHONE_NUMBER:=
5912: HZ_PARTY_ACQUIRE.get_phone_number(l_contact_point_id , 'CONTACT_POINTS','FLEX_FORMAT_PHONE_NUMBER');
5913: J:=J+1;
5914:
5915: END LOOP;
5916: CLOSE c_cpts;