DBA Data[Home] [Help]

APPS.IBE_MERGE_PVT dependencies on HZ_CONTACT_POINTS

Line 1499: elsif p_parent_entity_name = 'HZ_CONTACT_POINTS' Then

1495: END LOOP;
1496: CLOSE MERGE_FROM_SH;
1497: --fix 2889340
1498: --fix 2920475
1499: elsif p_parent_entity_name = 'HZ_CONTACT_POINTS' Then
1500: BEGIN
1501: select 1
1502: into l_dummy
1503: from hz_contact_points

Line 1503: from hz_contact_points

1499: elsif p_parent_entity_name = 'HZ_CONTACT_POINTS' Then
1500: BEGIN
1501: select 1
1502: into l_dummy
1503: from hz_contact_points
1504: where contact_point_id=p_from_fk_id and owner_table_name<>'IBE_SH_QUOTE_ACCESS';
1505: UPDATE IBE_SH_QUOTE_ACCESS SET
1506: contact_point_id = p_to_fk_id,
1507: last_update_date = hz_utility_pub.last_update_date,

Line 1520: end if; --end if p_parent_entity_name = 'HZ_CONTACT_POINTS' Then

1516: EXCEPTION
1517: WHEN NO_DATA_FOUND THEN
1518: NULL;
1519: END;
1520: end if; --end if p_parent_entity_name = 'HZ_CONTACT_POINTS' Then
1521:
1522: l_count := sql%rowcount;
1523:
1524: arp_message.set_name('AR', 'AR_ROWS_UPDATED');