DBA Data[Home] [Help]

APPS.IBE_MERGE_PVT dependencies on HZ_CONTACT_POINTS

Line 1533: elsif p_parent_entity_name = 'HZ_CONTACT_POINTS' Then

1529: END LOOP;
1530: CLOSE MERGE_FROM_SH;
1531: --fix 2889340
1532: --fix 2920475
1533: elsif p_parent_entity_name = 'HZ_CONTACT_POINTS' Then
1534: BEGIN
1535: select 1
1536: into l_dummy
1537: from hz_contact_points

Line 1537: from hz_contact_points

1533: elsif p_parent_entity_name = 'HZ_CONTACT_POINTS' Then
1534: BEGIN
1535: select 1
1536: into l_dummy
1537: from hz_contact_points
1538: where contact_point_id=p_from_fk_id and owner_table_name<>'IBE_SH_QUOTE_ACCESS';
1539: UPDATE IBE_SH_QUOTE_ACCESS SET
1540: contact_point_id = p_to_fk_id,
1541: last_update_date = hz_utility_pub.last_update_date,

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

1550: EXCEPTION
1551: WHEN NO_DATA_FOUND THEN
1552: NULL;
1553: END;
1554: end if; --end if p_parent_entity_name = 'HZ_CONTACT_POINTS' Then
1555:
1556: l_count := sql%rowcount;
1557:
1558: arp_message.set_name('AR', 'AR_ROWS_UPDATED');