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 664: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CONTACT_POINTS'

660: NULL;
661: END;
662:
663: -- SYNC CONTACT POINTS
664: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CONTACT_POINTS'
665: THEN
666: BEGIN--bug 6069559
667: SELECT status INTO l_status FROM hz_contact_points WHERE contact_point_id=p_orig_sys_reference_rec.owner_table_id;
668:

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

663: -- SYNC CONTACT POINTS
664: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CONTACT_POINTS'
665: THEN
666: BEGIN--bug 6069559
667: SELECT status INTO l_status FROM hz_contact_points WHERE contact_point_id=p_orig_sys_reference_rec.owner_table_id;
668:
669: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
670: HZ_DQM_SYNC.sync_contact_point(p_orig_sys_reference_rec.owner_table_id,'U') ;
671: END IF;

Line 1007: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CONTACT_POINTS'

1003:
1004:
1005:
1006: -- SYNC CONTACT POINTS
1007: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CONTACT_POINTS'
1008: THEN
1009: BEGIN--bug 6069559
1010: SELECT status INTO l_status FROM hz_contact_points WHERE contact_point_id=l_temp;
1011:

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

1006: -- SYNC CONTACT POINTS
1007: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CONTACT_POINTS'
1008: THEN
1009: BEGIN--bug 6069559
1010: SELECT status INTO l_status FROM hz_contact_points WHERE contact_point_id=l_temp;
1011:
1012: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
1013: HZ_DQM_SYNC.sync_contact_point(l_temp,'U') ;
1014: END IF;

Line 1958: --//Table hz_contact_points

1954: and uses.cust_acct_site_id = sites.cust_acct_site_id
1955: and sites.cust_account_id = cust.cust_account_id;
1956: --and uses.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
1957:
1958: --//Table hz_contact_points
1959: cursor c_cust_cont_point_id is
1960: select party.party_id
1961: from hz_parties party,hz_contact_points cont
1962: where cont.contact_point_id = p_owner_table_id

Line 1961: from hz_parties party,hz_contact_points cont

1957:
1958: --//Table hz_contact_points
1959: cursor c_cust_cont_point_id is
1960: select party.party_id
1961: from hz_parties party,hz_contact_points cont
1962: where cont.contact_point_id = p_owner_table_id
1963: and cont.owner_table_id = party.party_id
1964: --and cont.status = 'A' -- Bug 3196803 : Removed the check of status = 'A'
1965: union

Line 1967: from hz_party_sites psite,hz_contact_points cont

1963: and cont.owner_table_id = party.party_id
1964: --and cont.status = 'A' -- Bug 3196803 : Removed the check of status = 'A'
1965: union
1966: select psite.party_site_id
1967: from hz_party_sites psite,hz_contact_points cont
1968: where cont.contact_point_id = p_owner_table_id
1969: and cont.owner_table_id = psite.party_site_id;
1970: --and cont.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
1971:

Line 2024: elsif p_owner_table_name = 'HZ_CONTACT_POINTS' then

2020: open c_cust_site_uses_id ;
2021: fetch c_cust_site_uses_id into x_party_id;
2022: close c_cust_site_uses_id;
2023:
2024: elsif p_owner_table_name = 'HZ_CONTACT_POINTS' then
2025: open c_cust_cont_point_id;
2026: fetch c_cust_cont_point_id into x_party_id;
2027: close c_cust_cont_point_id;
2028: