6449: AND compilation_flag = 'C'
6450: AND rule_name = pc_rule_name;
6451:
6452: -- DQM Record Types
6453: l_party_cond HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;
6454: l_party_site_cond HZ_PARTY_SEARCH.PARTY_SITE_LIST;
6455: l_contact_cond HZ_PARTY_SEARCH.CONTACT_LIST;
6456: l_contact_point_cond HZ_PARTY_SEARCH.CONTACT_POINT_LIST;
6457:
6450: AND rule_name = pc_rule_name;
6451:
6452: -- DQM Record Types
6453: l_party_cond HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;
6454: l_party_site_cond HZ_PARTY_SEARCH.PARTY_SITE_LIST;
6455: l_contact_cond HZ_PARTY_SEARCH.CONTACT_LIST;
6456: l_contact_point_cond HZ_PARTY_SEARCH.CONTACT_POINT_LIST;
6457:
6458:
6451:
6452: -- DQM Record Types
6453: l_party_cond HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;
6454: l_party_site_cond HZ_PARTY_SEARCH.PARTY_SITE_LIST;
6455: l_contact_cond HZ_PARTY_SEARCH.CONTACT_LIST;
6456: l_contact_point_cond HZ_PARTY_SEARCH.CONTACT_POINT_LIST;
6457:
6458:
6459: l_rule_id NUMBER;
6452: -- DQM Record Types
6453: l_party_cond HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;
6454: l_party_site_cond HZ_PARTY_SEARCH.PARTY_SITE_LIST;
6455: l_contact_cond HZ_PARTY_SEARCH.CONTACT_LIST;
6456: l_contact_point_cond HZ_PARTY_SEARCH.CONTACT_POINT_LIST;
6457:
6458:
6459: l_rule_id NUMBER;
6460: l_partner_id NUMBER;
6566: THEN
6567: IF OZF_DEBUG_LOW_ON THEN
6568: ozf_utility_pvt.debug_message ('calling find parties ');
6569: END IF;
6570: HZ_PARTY_SEARCH.find_parties
6571: (p_init_msg_list => 'T',
6572: x_rule_id => l_rule_id,
6573: p_party_search_rec => l_party_cond,
6574: p_party_site_list => l_party_site_cond,
6653: AND
6654: p_party_site_rec.state IS NOT NULL ))
6655: THEN
6656:
6657: HZ_PARTY_SEARCH.get_matching_party_sites
6658: ('T',
6659: l_rule_id,
6660: l_party_id,
6661: l_party_site_cond,
6737: END IF;
6738:
6739: IF p_contact_rec.contact_name IS NOT NULL THEN
6740:
6741: HZ_PARTY_SEARCH.get_matching_contacts
6742: (p_init_msg_list => 'T',
6743: p_rule_id => l_rule_id,
6744: p_party_id => l_party_id,
6745: p_contact_list => l_contact_cond,