APPS.AMS_PARTY_MERGE_PVT dependencies on AMS_OFFER_PARTIES

Line 2178: FROM ams_offer_parties

2174: l_merge_reason_code VARCHAR2(30);
2175:
2176: CURSOR c_list_header_id IS
2177: SELECT qp_list_header_id
2178: FROM ams_offer_parties
2179: WHERE party_id = p_from_fk_id;
2180:
2181: CURSOR c_is_duplicate(l_list_header_id NUMBER, l_party_id NUMBER) IS
2182: SELECT 'Y'

Line 2183: FROM ams_offer_parties

2179: WHERE party_id = p_from_fk_id;
2180:
2181: CURSOR c_is_duplicate(l_list_header_id NUMBER, l_party_id NUMBER) IS
2182: SELECT 'Y'
2183: FROM ams_offer_parties
2184: WHERE qp_list_header_id = l_list_header_id
2185: AND party_id = l_party_id;
2186:
2187: l_is_duplicate VARCHAR2(10);

Line 2258: DELETE FROM ams_offer_parties

2254: FETCH c_is_duplicate INTO l_is_duplicate;
2255: CLOSE c_is_duplicate;
2256:
2257: IF l_is_duplicate = 'Y' THEN
2258: DELETE FROM ams_offer_parties
2259: WHERE qp_list_header_id = l_list_header_id.qp_list_header_id
2260: AND party_id = p_from_fk_id;
2261: ELSE
2262: UPDATE ams_offer_parties

Line 2262: UPDATE ams_offer_parties

2258: DELETE FROM ams_offer_parties
2259: WHERE qp_list_header_id = l_list_header_id.qp_list_header_id
2260: AND party_id = p_from_fk_id;
2261: ELSE
2262: UPDATE ams_offer_parties
2263: SET party_id = p_to_fk_id
2264: ,last_update_date = hz_utility_pub.last_update_date
2265: ,last_updated_by = hz_utility_pub.user_id
2266: ,last_update_login = hz_utility_pub.last_update_login