DBA Data[Home] [Help]

APPS.AMS_PARTY_MERGE_PVT dependencies on AMS_CHANNELS_B

Line 345: -- to do the party merge for table ams_channels_b

341: IF p_from_fk_id <> p_to_fk_id THEN
342: BEGIN
343: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
344: -- Following lines of code is added by ptendulk on 14-May-2001
345: -- to do the party merge for table ams_channels_b
346: UPDATE AMS_CHANNELS_B
347: SET party_id = p_to_fk_id,
348: last_update_date = hz_utility_pub.last_update_date,
349: last_updated_by = hz_utility_pub.user_id,

Line 346: UPDATE AMS_CHANNELS_B

342: BEGIN
343: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
344: -- Following lines of code is added by ptendulk on 14-May-2001
345: -- to do the party merge for table ams_channels_b
346: UPDATE AMS_CHANNELS_B
347: SET party_id = p_to_fk_id,
348: last_update_date = hz_utility_pub.last_update_date,
349: last_updated_by = hz_utility_pub.user_id,
350: last_update_login = hz_utility_pub.last_update_login,

Line 453: -- to do the party merge for table ams_channels_b

449: IF p_from_fk_id <> p_to_fk_id THEN
450: BEGIN
451: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
452: -- Following lines of code is added by ptendulk on 14-May-2001
453: -- to do the party merge for table ams_channels_b
454: UPDATE AMS_PARTY_SOURCES
455: SET party_id = p_to_fk_id,
456: last_update_date = hz_utility_pub.last_update_date,
457: last_updated_by = hz_utility_pub.user_id,

Line 1817: -- to do the party merge for table ams_channels_b

1813: IF p_from_fk_id <> p_to_fk_id THEN
1814: BEGIN
1815: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1816: -- Following lines of code is added by ptendulk on 14-May-2001
1817: -- to do the party merge for table ams_channels_b
1818: UPDATE AMS_IMP_SOURCE_LINES
1819: SET party_id = p_to_fk_id,
1820: last_update_date = hz_utility_pub.last_update_date,
1821: last_updated_by = hz_utility_pub.user_id,

Line 1922: -- to do the party merge for table ams_channels_b

1918: IF p_from_fk_id <> p_to_fk_id THEN
1919: BEGIN
1920: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1921: -- Following lines of code is added by ptendulk on 14-May-2001
1922: -- to do the party merge for table ams_channels_b
1923: UPDATE AMS_LIST_ENTRIES
1924: SET party_id = p_to_fk_id,
1925: last_update_date = hz_utility_pub.last_update_date,
1926: last_updated_by = hz_utility_pub.user_id,

Line 2027: -- to do the party merge for table ams_channels_b

2023: IF p_from_fk_id <> p_to_fk_id THEN
2024: BEGIN
2025: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2026: -- Following lines of code is added by ptendulk on 14-May-2001
2027: -- to do the party merge for table ams_channels_b
2028: UPDATE AMS_LIST_ENTRIES
2029: SET parent_party_id = p_to_fk_id,
2030: last_update_date = hz_utility_pub.last_update_date,
2031: last_updated_by = hz_utility_pub.user_id,