APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_ORG_CONTACTS

Line 106: from hz_orig_sys_references os,hz_org_contacts org

102: and status = 'A';
103:
104: cursor get_rel_ssc_csr is
105: select count(*)
106: from hz_orig_sys_references os,hz_org_contacts org
107: where os.owner_table_id = org.org_contact_id
108: and os.owner_table_name = p_owner_table_name
109: and org.org_contact_id = p_owner_table_id
110: and os.status = 'A';

Line 121: elsif p_owner_table_name = 'HZ_ORG_CONTACTS' then

117: open get_pps_ssc_csr;
118: fetch get_pps_ssc_csr into l_count;
119: close get_pps_ssc_csr;
120:
121: elsif p_owner_table_name = 'HZ_ORG_CONTACTS' then
122: open get_rel_ssc_csr;
123: fetch get_rel_ssc_csr into l_count;
124: close get_rel_ssc_csr;
125:

Line 650: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_ORG_CONTACTS'

646: NULL;
647: END;
648:
649: -- SYNC CONTACTS
650: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_ORG_CONTACTS'
651: THEN
652: BEGIN--bug 6069559
653: SELECT status INTO l_status FROM HZ_ORG_CONTACTS WHERE org_contact_id=p_orig_sys_reference_rec.owner_table_id;
654:

Line 653: SELECT status INTO l_status FROM HZ_ORG_CONTACTS WHERE org_contact_id=p_orig_sys_reference_rec.owner_table_id;

649: -- SYNC CONTACTS
650: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_ORG_CONTACTS'
651: THEN
652: BEGIN--bug 6069559
653: SELECT status INTO l_status FROM HZ_ORG_CONTACTS WHERE org_contact_id=p_orig_sys_reference_rec.owner_table_id;
654:
655: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
656: HZ_DQM_SYNC.sync_contact(p_orig_sys_reference_rec.owner_table_id,'U') ;
657: END IF;

Line 991: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_ORG_CONTACTS'

987: END;
988:
989:
990: -- SYNC CONTACTS
991: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_ORG_CONTACTS'
992: THEN
993: BEGIN--bug 6069559
994: SELECT status INTO l_status FROM HZ_ORG_CONTACTS WHERE org_contact_id=l_temp;
995:

Line 994: SELECT status INTO l_status FROM HZ_ORG_CONTACTS WHERE org_contact_id=l_temp;

990: -- SYNC CONTACTS
991: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_ORG_CONTACTS'
992: THEN
993: BEGIN--bug 6069559
994: SELECT status INTO l_status FROM HZ_ORG_CONTACTS WHERE org_contact_id=l_temp;
995:
996: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
997: HZ_DQM_SYNC.sync_contact(l_temp,'U') ;
998: END IF;

Line 1972: --//Table hz_org_contacts

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:
1972: --//Table hz_org_contacts
1973: cursor c_org_cont_id is
1974: select rel.object_id
1975: from hz_org_contacts org ,hz_relationships rel
1976: where org.org_contact_id = p_owner_table_id

Line 1975: from hz_org_contacts org ,hz_relationships rel

1971:
1972: --//Table hz_org_contacts
1973: cursor c_org_cont_id is
1974: select rel.object_id
1975: from hz_org_contacts org ,hz_relationships rel
1976: where org.org_contact_id = p_owner_table_id
1977: and org.party_relationship_id = rel.relationship_id
1978: and rel.directional_flag = 'F';
1979: --and org.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'

Line 1984: from hz_org_contact_roles roles,hz_org_contacts org,hz_relationships rel

1980:
1981: --//Table hz_org_contact_roles
1982: cursor c_org_cont_role_id is
1983: select rel.object_id
1984: from hz_org_contact_roles roles,hz_org_contacts org,hz_relationships rel
1985: where roles.org_contact_role_id = p_owner_table_id
1986: and roles.org_contact_id = org.org_contact_id
1987: and org.party_relationship_id = rel.relationship_id
1988: and rel.directional_flag = 'F';

Line 2029: elsif p_owner_table_name = 'HZ_ORG_CONTACTS' 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:
2029: elsif p_owner_table_name = 'HZ_ORG_CONTACTS' then
2030: open c_org_cont_id;
2031: fetch c_org_cont_id into x_party_id;
2032: close c_org_cont_id;
2033: