eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_CONTACT_POINTS

Line 681: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CONTACT_POINTS'

677: NULL;
678: END;
679:
680: -- SYNC CONTACT POINTS
681: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CONTACT_POINTS'
682: THEN
683: BEGIN--bug 6069559
684: SELECT status INTO l_status FROM hz_contact_points WHERE contact_point_id=p_orig_sys_reference_rec.owner_table_id;
685:

Line 684: SELECT status INTO l_status FROM hz_contact_points WHERE contact_point_id=p_orig_sys_reference_rec.owner_table_id;

680: -- SYNC CONTACT POINTS
681: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CONTACT_POINTS'
682: THEN
683: BEGIN--bug 6069559
684: SELECT status INTO l_status FROM hz_contact_points WHERE contact_point_id=p_orig_sys_reference_rec.owner_table_id;
685:
686: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
687: HZ_DQM_SYNC.sync_contact_point(p_orig_sys_reference_rec.owner_table_id,'U') ;
688: END IF;

Line 1036: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CONTACT_POINTS'

1032:
1033:
1034:
1035: -- SYNC CONTACT POINTS
1036: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CONTACT_POINTS'
1037: THEN
1038: BEGIN--bug 6069559
1039: SELECT status INTO l_status FROM hz_contact_points WHERE contact_point_id=l_temp;
1040:

Line 1039: SELECT status INTO l_status FROM hz_contact_points WHERE contact_point_id=l_temp;

1035: -- SYNC CONTACT POINTS
1036: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CONTACT_POINTS'
1037: THEN
1038: BEGIN--bug 6069559
1039: SELECT status INTO l_status FROM hz_contact_points WHERE contact_point_id=l_temp;
1040:
1041: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
1042: HZ_DQM_SYNC.sync_contact_point(l_temp,'U') ;
1043: END IF;

Line 2005: --//Table hz_contact_points

2001: and uses.cust_acct_site_id = sites.cust_acct_site_id
2002: and sites.cust_account_id = cust.cust_account_id;
2003: --and uses.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
2004:
2005: --//Table hz_contact_points
2006: cursor c_cust_cont_point_id is
2007: select party.party_id
2008: from hz_parties party,hz_contact_points cont
2009: where cont.contact_point_id = p_owner_table_id

Line 2008: from hz_parties party,hz_contact_points cont

2004:
2005: --//Table hz_contact_points
2006: cursor c_cust_cont_point_id is
2007: select party.party_id
2008: from hz_parties party,hz_contact_points cont
2009: where cont.contact_point_id = p_owner_table_id
2010: and cont.owner_table_id = party.party_id
2011: --and cont.status = 'A' -- Bug 3196803 : Removed the check of status = 'A'
2012: union

Line 2014: from hz_party_sites psite,hz_contact_points cont

2010: and cont.owner_table_id = party.party_id
2011: --and cont.status = 'A' -- Bug 3196803 : Removed the check of status = 'A'
2012: union
2013: select psite.party_site_id
2014: from hz_party_sites psite,hz_contact_points cont
2015: where cont.contact_point_id = p_owner_table_id
2016: and cont.owner_table_id = psite.party_site_id;
2017: --and cont.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
2018:

Line 2071: elsif p_owner_table_name = 'HZ_CONTACT_POINTS' then

2067: open c_cust_site_uses_id ;
2068: fetch c_cust_site_uses_id into x_party_id;
2069: close c_cust_site_uses_id;
2070:
2071: elsif p_owner_table_name = 'HZ_CONTACT_POINTS' then
2072: open c_cust_cont_point_id;
2073: fetch c_cust_cont_point_id into x_party_id;
2074: close c_cust_cont_point_id;
2075: