APPS.AS_INTEREST_MERGE_PKG dependencies on AS_INTERESTS_ALL

Line 89: UPDATE AS_INTERESTS_ALL

85:
86: IF p_from_fk_id <> p_to_fk_id THEN
87: BEGIN
88: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
89: UPDATE AS_INTERESTS_ALL
90: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
91: last_update_date = hz_utility_pub.last_update_date,
92: last_updated_by = hz_utility_pub.user_id,
93: last_update_login = hz_utility_pub.last_update_login,

Line 99: UPDATE AS_INTERESTS_ALL

95: program_id = hz_utility_pub.program_id,
96: program_update_date = sysdate
97: where customer_id = p_from_fk_id;
98: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
99: UPDATE AS_INTERESTS_ALL
100: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
101: last_update_date = hz_utility_pub.last_update_date,
102: last_updated_by = hz_utility_pub.user_id,
103: last_update_login = hz_utility_pub.last_update_login,

Line 109: UPDATE AS_INTERESTS_ALL

105: program_id = hz_utility_pub.program_id,
106: program_update_date = sysdate
107: where address_id = p_from_fk_id;
108: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN -- merge org_contact
109: UPDATE AS_INTERESTS_ALL
110: set object_version_number = nvl(object_version_number,0) + 1, contact_id = p_to_fk_id,
111: last_update_date = hz_utility_pub.last_update_date,
112: last_updated_by = hz_utility_pub.user_id,
113: last_update_login = hz_utility_pub.last_update_login,