APPS.AMS_PARTY_MERGE_PVT dependencies on AMS_VENUES_B

Line 2050: -- Venues_Party_Merge created for (ams_venues_b)

2046: END Listentries_Parent_Party_Merge;
2047:
2048: -----------------------------------------------------------------------
2049: -- PROCEDURE
2050: -- Venues_Party_Merge created for (ams_venues_b)
2051: --
2052: -- HISTORY
2053: -- 06-Mar-2003 Musman Created
2054: -----------------------------------------------------------------------

Line 2132: -- to do the party merge for table ams_venues_b

2128: IF p_from_fk_id <> p_to_fk_id THEN
2129: BEGIN
2130: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2131: -- Following lines of code is added by musman on 6-Mar-2003
2132: -- to do the party merge for table ams_venues_b
2133: UPDATE AMS_VENUES_B
2134: SET party_id = p_to_fk_id,
2135: last_update_date = hz_utility_pub.last_update_date,
2136: last_updated_by = hz_utility_pub.user_id,

Line 2133: UPDATE AMS_VENUES_B

2129: BEGIN
2130: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2131: -- Following lines of code is added by musman on 6-Mar-2003
2132: -- to do the party merge for table ams_venues_b
2133: UPDATE AMS_VENUES_B
2134: SET party_id = p_to_fk_id,
2135: last_update_date = hz_utility_pub.last_update_date,
2136: last_updated_by = hz_utility_pub.user_id,
2137: last_update_login = hz_utility_pub.last_update_login