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 3378: party_cond HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;

3374:
3375: -- Declare Variables for passing search criteria
3376:
3377: -- Pass Party search criteria in this variable
3378: party_cond HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;
3379: -- Pass Party Site search criteria in this variable
3380: party_site_cond HZ_PARTY_SEARCH.PARTY_SITE_LIST;
3381: -- Pass Contact search criteria in this variable
3382: contact_cond HZ_PARTY_SEARCH.CONTACT_LIST;

Line 3380: party_site_cond HZ_PARTY_SEARCH.PARTY_SITE_LIST;

3376:
3377: -- Pass Party search criteria in this variable
3378: party_cond HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;
3379: -- Pass Party Site search criteria in this variable
3380: party_site_cond HZ_PARTY_SEARCH.PARTY_SITE_LIST;
3381: -- Pass Contact search criteria in this variable
3382: contact_cond HZ_PARTY_SEARCH.CONTACT_LIST;
3383: -- Pass Contact Point search criteria in this variable
3384: contact_point_cond HZ_PARTY_SEARCH.CONTACT_POINT_LIST;

Line 3382: contact_cond HZ_PARTY_SEARCH.CONTACT_LIST;

3378: party_cond HZ_PARTY_SEARCH.PARTY_SEARCH_REC_TYPE;
3379: -- Pass Party Site search criteria in this variable
3380: party_site_cond HZ_PARTY_SEARCH.PARTY_SITE_LIST;
3381: -- Pass Contact search criteria in this variable
3382: contact_cond HZ_PARTY_SEARCH.CONTACT_LIST;
3383: -- Pass Contact Point search criteria in this variable
3384: contact_point_cond HZ_PARTY_SEARCH.CONTACT_POINT_LIST;
3385:
3386: -- The Match Rule to use for the dup identification.

Line 3384: contact_point_cond HZ_PARTY_SEARCH.CONTACT_POINT_LIST;

3380: party_site_cond HZ_PARTY_SEARCH.PARTY_SITE_LIST;
3381: -- Pass Contact search criteria in this variable
3382: contact_cond HZ_PARTY_SEARCH.CONTACT_LIST;
3383: -- Pass Contact Point search criteria in this variable
3384: contact_point_cond HZ_PARTY_SEARCH.CONTACT_POINT_LIST;
3385:
3386: -- The Match Rule to use for the dup identification.
3387: l_rule_id NUMBER;
3388:

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

3712: write_log(3,'rule_id '||to_char(l_rule_id));
3713:
3714: IF l_orig_sys_party_found = 'N' THEN
3715: -- Full search
3716: HZ_PARTY_SEARCH.find_parties ('T',l_rule_id, party_cond, party_site_cond, contact_cond , contact_point_cond, NULL,
3717: 'N',l_search_context_id, l_num_matches, l_return_status, l_msg_count, l_msg_data);
3718: ELSE
3719: -- l_restrict_sql := ' party_id in (select party_id from hz_parties where orig_system_reference = '''||I.orig_system_reference||''')';
3720: write_log(3,'In Restrict sql');

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

3719: -- l_restrict_sql := ' party_id in (select party_id from hz_parties where orig_system_reference = '''||I.orig_system_reference||''')';
3720: write_log(3,'In Restrict sql');
3721:
3722: -- Restricted search by passing p_restrict_sql
3723: HZ_PARTY_SEARCH.find_parties ('T',l_rule_id, party_cond, party_site_cond, contact_cond , contact_point_cond,
3724: '/* SELECTIVE */ party_id in (select party_id from hz_parties where ORIG_SYSTEM_REFERENCE = '''||I.orig_system_reference||''') ',
3725: 'N',l_search_context_id, l_num_matches, l_return_status, l_msg_count, l_msg_data);
3726:
3727: IF l_num_matches = 0 THEN

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

3726:
3727: IF l_num_matches = 0 THEN
3728: -- Full search
3729: write_log(3,'performing full search');
3730: HZ_PARTY_SEARCH.find_parties ('T',l_rule_id, party_cond, party_site_cond, contact_cond , contact_point_cond, NULL,
3731: 'N',l_search_context_id, l_num_matches, l_return_status, l_msg_count, l_msg_data);
3732: END IF;
3733: END IF;
3734:

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

3825:
3826: -- SOLIN, Bug 4942209
3827: -- create a new rule profile for DQM party site match
3828: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_PARTY_SITE'));
3829: HZ_PARTY_SEARCH.get_matching_party_sites ('T',l_rule_id, I.party_id, party_site_cond,
3830: contact_point_cond, l_search_context_id, l_return_status, l_msg_count, l_msg_data);
3831:
3832: IF l_return_status <> FND_API.g_ret_sts_success THEN
3833: RAISE FND_API.g_exc_error;

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

3875: IF I.party_id IS NOT NULL THEN --4
3876: write_log(3,'#3 :: Calling GET_MATCHING_CONTACTS with party_id: '||to_char(I.party_id));
3877:
3878: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_CONTACT'));
3879: HZ_PARTY_SEARCH.get_matching_contacts('T',l_rule_id, I.party_id, contact_cond, contact_point_cond,
3880: l_search_context_id, l_return_status, l_msg_count, l_msg_data);
3881:
3882: IF l_return_status <> FND_API.g_ret_sts_success THEN
3883: RAISE FND_API.g_exc_error;

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

3909: party_cond.party_type := 'PERSON';
3910: party_cond.party_name := I.first_name||' '||I.last_name;
3911:
3912: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_PERSON'));
3913: HZ_PARTY_SEARCH.find_parties ('T',l_rule_id, party_cond, party_site_cond, contact_cond , contact_point_cond, NULL,
3914: 'N',l_search_context_id, l_num_matches, l_return_status, l_msg_count, l_msg_data);
3915:
3916: IF l_num_matches > 0 THEN --match found
3917: OPEN C_matched_party('PERSON');

Line 3962: 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);

3958: IF l_contact_provided = 'N' AND I.first_name IS NOT NULL AND I.last_name IS NOT NULL THEN
3959: IF I.email_address IS NOT NULL or I.phone_number IS NOT NULL THEN
3960: write_log(3,'#4 :: Calling GET_MATCHING_CONTACT_POINTS with party_id: '||to_char(I.party_id));
3961: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_CONTACT'));
3962: 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);
3963:
3964: IF l_return_status <> FND_API.g_ret_sts_success THEN
3965: RAISE FND_API.g_exc_error;
3966: END IF;