DBA Data[Home] [Help]

APPS.AMS_PARTY_MERGE_PVT dependencies on AMS_ACT_RESOURCES

Line 2289: -- Resources_Party_Merge created for (ams_act_resources)

2285:
2286:
2287: -----------------------------------------------------------------------
2288: -- PROCEDURE
2289: -- Resources_Party_Merge created for (ams_act_resources)
2290: --
2291: -- HISTORY
2292: -- 16-May-2003 soagrawa Created
2293: -----------------------------------------------------------------------

Line 2377: -- to do the party merge for table ams_act_resources

2373: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2374:
2375:
2376: -- Following lines of code is added by soagrawa on 23-Mar-2003
2377: -- to do the party merge for table ams_act_resources
2378:
2379: UPDATE AMS_ACT_RESOURCES
2380: SET resource_id = p_to_fk_id,
2381: last_update_date = hz_utility_pub.last_update_date,

Line 2379: UPDATE AMS_ACT_RESOURCES

2375:
2376: -- Following lines of code is added by soagrawa on 23-Mar-2003
2377: -- to do the party merge for table ams_act_resources
2378:
2379: UPDATE AMS_ACT_RESOURCES
2380: SET resource_id = p_to_fk_id,
2381: last_update_date = hz_utility_pub.last_update_date,
2382: last_updated_by = hz_utility_pub.user_id,
2383: last_update_login = hz_utility_pub.last_update_login