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 667: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_ORG_CONTACTS'

663: NULL;
664: END;
665:
666: -- SYNC CONTACTS
667: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_ORG_CONTACTS'
668: THEN
669: BEGIN--bug 6069559
670: SELECT status INTO l_status FROM HZ_ORG_CONTACTS WHERE org_contact_id=p_orig_sys_reference_rec.owner_table_id;
671:

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

666: -- SYNC CONTACTS
667: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_ORG_CONTACTS'
668: THEN
669: BEGIN--bug 6069559
670: SELECT status INTO l_status FROM HZ_ORG_CONTACTS WHERE org_contact_id=p_orig_sys_reference_rec.owner_table_id;
671:
672: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
673: HZ_DQM_SYNC.sync_contact(p_orig_sys_reference_rec.owner_table_id,'U') ;
674: END IF;

Line 1020: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_ORG_CONTACTS'

1016: END;
1017:
1018:
1019: -- SYNC CONTACTS
1020: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_ORG_CONTACTS'
1021: THEN
1022: BEGIN--bug 6069559
1023: SELECT status INTO l_status FROM HZ_ORG_CONTACTS WHERE org_contact_id=l_temp;
1024:

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

1019: -- SYNC CONTACTS
1020: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_ORG_CONTACTS'
1021: THEN
1022: BEGIN--bug 6069559
1023: SELECT status INTO l_status FROM HZ_ORG_CONTACTS WHERE org_contact_id=l_temp;
1024:
1025: IF l_status Is NULL OR l_status = 'A' OR l_status = 'I' THEN
1026: HZ_DQM_SYNC.sync_contact(l_temp,'U') ;
1027: END IF;

Line 2019: --//Table hz_org_contacts

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:
2019: --//Table hz_org_contacts
2020: cursor c_org_cont_id is
2021: select rel.object_id
2022: from hz_org_contacts org ,hz_relationships rel
2023: where org.org_contact_id = p_owner_table_id

Line 2022: from hz_org_contacts org ,hz_relationships rel

2018:
2019: --//Table hz_org_contacts
2020: cursor c_org_cont_id is
2021: select rel.object_id
2022: from hz_org_contacts org ,hz_relationships rel
2023: where org.org_contact_id = p_owner_table_id
2024: and org.party_relationship_id = rel.relationship_id
2025: and rel.directional_flag = 'F';
2026: --and org.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'

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

2027:
2028: --//Table hz_org_contact_roles
2029: cursor c_org_cont_role_id is
2030: select rel.object_id
2031: from hz_org_contact_roles roles,hz_org_contacts org,hz_relationships rel
2032: where roles.org_contact_role_id = p_owner_table_id
2033: and roles.org_contact_id = org.org_contact_id
2034: and org.party_relationship_id = rel.relationship_id
2035: and rel.directional_flag = 'F';

Line 2076: elsif p_owner_table_name = 'HZ_ORG_CONTACTS' 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:
2076: elsif p_owner_table_name = 'HZ_ORG_CONTACTS' then
2077: open c_org_cont_id;
2078: fetch c_org_cont_id into x_party_id;
2079: close c_org_cont_id;
2080: