APPS.HZ_MERGE_DUP_PVT dependencies on HZ_MATCHED_PARTY_SITES_GT

Line 2372: from HZ_MATCHED_PARTY_SITES_GT mps

2368: -- need to check if the matched addr is already mapped by other sites
2369: -- therefore, check if the site_id = merge_to_entity_id
2370: cursor get_suggested_addr(l_search_ctx_id NUMBER, l_master_site NUMBER) is
2371: select party_site_id
2372: from HZ_MATCHED_PARTY_SITES_GT mps
2373: where mps.search_context_id = l_search_ctx_id
2374: and mps.party_site_id <> l_master_site
2375: and not exists
2376: ( select 1

Line 2399: FROM HZ_MATCHED_PARTY_SITES_GT

2395: and mpd.entity_name = 'HZ_PARTY_SITES';
2396:
2397: CURSOR c_get_matched_ps(l_search_context_id NUMBER) IS
2398: SELECT party_site_id
2399: FROM HZ_MATCHED_PARTY_SITES_GT
2400: WHERE search_context_id = l_search_context_id;
2401:
2402: CURSOR c_cust_site_check(p_from_entity_id NUMBER) IS
2403: select 1 from hz_cust_acct_sites_all where party_site_id=p_from_entity_id;

Line 2525: DELETE FROM HZ_MATCHED_PARTY_SITES_GT

2521: l_return_status,
2522: l_msg_count,
2523: l_msg_data);
2524: IF l_merge_yn = 'N' THEN
2525: DELETE FROM HZ_MATCHED_PARTY_SITES_GT
2526: WHERE search_context_id = l_search_ctx_id
2527: AND party_site_id = l_temp_from_site;
2528: l_num_matches := l_num_matches - 1;
2529: END IF;

Line 2554: DELETE FROM HZ_MATCHED_PARTY_SITES_GT

2550:
2551: IF (c_get_orig_system%FOUND AND l_to_orig_system <> l_from_orig_system) OR
2552: (c_get_orig_system%NOTFOUND) THEN
2553:
2554: DELETE FROM HZ_MATCHED_PARTY_SITES_GT
2555: WHERE search_context_id = l_search_ctx_id
2556: AND party_site_id = l_temp_from_site;
2557:
2558: l_num_matches := l_num_matches - 1;

Line 2585: FROM HZ_MATCHED_PARTY_SITES_GT matchps

2581: FROM HZ_MERGE_PARTIES_SUGG
2582: WHERE batch_id = p_batch_id )
2583: AND merge_from_entity_id IN
2584: ( SELECT party_site_id
2585: FROM HZ_MATCHED_PARTY_SITES_GT matchps
2586: , HZ_MERGE_PARTYDTLS_SUGG mpd
2587: , HZ_MERGE_PARTIES_SUGG mps
2588: WHERE matchps.search_context_id = l_search_ctx_id
2589: AND matchps.party_site_id = mpd.merge_from_entity_id

Line 2634: -- find out all matched sites from HZ_MATCHED_PARTY_SITES_GT

2630: ,x_msg_data => l_msg_data
2631: );
2632:
2633: IF (l_num_matches > 0) THEN
2634: -- find out all matched sites from HZ_MATCHED_PARTY_SITES_GT
2635: OPEN get_suggested_addr(l_search_ctx_id, l_master_site);
2636: LOOP
2637: FETCH get_suggested_addr into l_merge_from_site;
2638: EXIT WHEN get_suggested_addr%NOTFOUND;