eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_IMPORT_SL_PVT dependencies on HZ_PARTY_SEARCH

Line 3359: party_cond HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;

3355:
3356: -- Declare Variables for passing search criteria
3357:
3358: -- Pass Party search criteria in this variable
3359: party_cond HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;
3360: -- Pass Party Site search criteria in this variable
3361: party_site_cond HZ_PARTY_SEARCH.PARTY_SITE_LIST;
3362: -- Pass Contact search criteria in this variable
3363: contact_cond HZ_PARTY_SEARCH.CONTACT_LIST;

Line 3361: party_site_cond HZ_PARTY_SEARCH.PARTY_SITE_LIST;

3357:
3358: -- Pass Party search criteria in this variable
3359: party_cond HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;
3360: -- Pass Party Site search criteria in this variable
3361: party_site_cond HZ_PARTY_SEARCH.PARTY_SITE_LIST;
3362: -- Pass Contact search criteria in this variable
3363: contact_cond HZ_PARTY_SEARCH.CONTACT_LIST;
3364: -- Pass Contact Point search criteria in this variable
3365: contact_point_cond HZ_PARTY_SEARCH.CONTACT_POINT_LIST;

Line 3363: contact_cond HZ_PARTY_SEARCH.CONTACT_LIST;

3359: party_cond HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;
3360: -- Pass Party Site search criteria in this variable
3361: party_site_cond HZ_PARTY_SEARCH.PARTY_SITE_LIST;
3362: -- Pass Contact search criteria in this variable
3363: contact_cond HZ_PARTY_SEARCH.CONTACT_LIST;
3364: -- Pass Contact Point search criteria in this variable
3365: contact_point_cond HZ_PARTY_SEARCH.CONTACT_POINT_LIST;
3366:
3367: -- The Match Rule to use for the dup identification.

Line 3365: contact_point_cond HZ_PARTY_SEARCH.CONTACT_POINT_LIST;

3361: party_site_cond HZ_PARTY_SEARCH.PARTY_SITE_LIST;
3362: -- Pass Contact search criteria in this variable
3363: contact_cond HZ_PARTY_SEARCH.CONTACT_LIST;
3364: -- Pass Contact Point search criteria in this variable
3365: contact_point_cond HZ_PARTY_SEARCH.CONTACT_POINT_LIST;
3366:
3367: -- The Match Rule to use for the dup identification.
3368: l_rule_id NUMBER;
3369:

Line 3697: HZ_PARTY_SEARCH.find_parties ('T',l_rule_id, party_cond, party_site_cond, contact_cond , contact_point_cond, NULL,

3693: write_log(3,'rule_id '||to_char(l_rule_id));
3694:
3695: IF l_orig_sys_party_found = 'N' THEN
3696: -- Full search
3697: HZ_PARTY_SEARCH.find_parties ('T',l_rule_id, party_cond, party_site_cond, contact_cond , contact_point_cond, NULL,
3698: 'N',l_search_context_id, l_num_matches, l_return_status, l_msg_count, l_msg_data);
3699: ELSE
3700: -- l_restrict_sql := ' party_id in (select party_id from hz_parties where orig_system_reference = '''||I.orig_system_reference||''')';
3701: write_log(3,'In Restrict sql');

Line 3704: HZ_PARTY_SEARCH.find_parties ('T',l_rule_id, party_cond, party_site_cond, contact_cond , contact_point_cond,

3700: -- l_restrict_sql := ' party_id in (select party_id from hz_parties where orig_system_reference = '''||I.orig_system_reference||''')';
3701: write_log(3,'In Restrict sql');
3702:
3703: -- Restricted search by passing p_restrict_sql
3704: HZ_PARTY_SEARCH.find_parties ('T',l_rule_id, party_cond, party_site_cond, contact_cond , contact_point_cond,
3705: '/* SELECTIVE */ party_id in (select party_id from hz_parties where ORIG_SYSTEM_REFERENCE = '''||I.orig_system_reference||''') ',
3706: 'N',l_search_context_id, l_num_matches, l_return_status, l_msg_count, l_msg_data);
3707:
3708: IF l_num_matches = 0 THEN

Line 3711: HZ_PARTY_SEARCH.find_parties ('T',l_rule_id, party_cond, party_site_cond, contact_cond , contact_point_cond, NULL,

3707:
3708: IF l_num_matches = 0 THEN
3709: -- Full search
3710: write_log(3,'performing full search');
3711: HZ_PARTY_SEARCH.find_parties ('T',l_rule_id, party_cond, party_site_cond, contact_cond , contact_point_cond, NULL,
3712: 'N',l_search_context_id, l_num_matches, l_return_status, l_msg_count, l_msg_data);
3713: END IF;
3714: END IF;
3715:

Line 3810: HZ_PARTY_SEARCH.get_matching_party_sites ('T',l_rule_id, I.party_id, party_site_cond,

3806:
3807: -- SOLIN, Bug 4942209
3808: -- create a new rule profile for DQM party site match
3809: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_PARTY_SITE'));
3810: HZ_PARTY_SEARCH.get_matching_party_sites ('T',l_rule_id, I.party_id, party_site_cond,
3811: contact_point_cond, l_search_context_id, l_return_status, l_msg_count, l_msg_data);
3812:
3813: IF l_return_status <> FND_API.g_ret_sts_success THEN
3814: RAISE FND_API.g_exc_error;

Line 3860: HZ_PARTY_SEARCH.get_matching_contacts('T',l_rule_id, I.party_id, contact_cond, contact_point_cond,

3856: IF I.party_id IS NOT NULL THEN --4
3857: write_log(3,'#3 :: Calling GET_MATCHING_CONTACTS with party_id: '||to_char(I.party_id));
3858:
3859: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_CONTACT'));
3860: HZ_PARTY_SEARCH.get_matching_contacts('T',l_rule_id, I.party_id, contact_cond, contact_point_cond,
3861: l_search_context_id, l_return_status, l_msg_count, l_msg_data);
3862:
3863: IF l_return_status <> FND_API.g_ret_sts_success THEN
3864: RAISE FND_API.g_exc_error;

Line 3894: HZ_PARTY_SEARCH.find_parties ('T',l_rule_id, party_cond, party_site_cond, contact_cond , contact_point_cond, NULL,

3890: party_cond.party_type := 'PERSON';
3891: party_cond.party_name := I.first_name||' '||I.last_name;
3892:
3893: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_PERSON'));
3894: HZ_PARTY_SEARCH.find_parties ('T',l_rule_id, party_cond, party_site_cond, contact_cond , contact_point_cond, NULL,
3895: 'N',l_search_context_id, l_num_matches, l_return_status, l_msg_count, l_msg_data);
3896:
3897: IF l_num_matches > 0 THEN --match found
3898: OPEN C_matched_party('PERSON');

Line 3943: HZ_PARTY_SEARCH.get_matching_contact_points('T',l_rule_id, I.party_id, contact_point_cond, l_search_context_id, l_return_status, l_msg_count, l_msg_data);

3939: IF l_contact_provided = 'N' AND I.first_name IS NOT NULL AND I.last_name IS NOT NULL THEN
3940: IF I.email_address IS NOT NULL or I.phone_number IS NOT NULL THEN
3941: write_log(3,'#4 :: Calling GET_MATCHING_CONTACT_POINTS with party_id: '||to_char(I.party_id));
3942: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_CONTACT'));
3943: HZ_PARTY_SEARCH.get_matching_contact_points('T',l_rule_id, I.party_id, contact_point_cond, l_search_context_id, l_return_status, l_msg_count, l_msg_data);
3944:
3945: IF l_return_status <> FND_API.g_ret_sts_success THEN
3946: RAISE FND_API.g_exc_error;
3947: END IF;