APPS.AS_IMPORT_SL_PVT dependencies on HZ_ORG_CONTACTS

Line 518: -- 5. HZ_ORG_CONTACTS

514: -- 1. HZ_PARTIES
515: -- 2. HZ_LOCATIONS
516: -- 3. HZ_CONTACT_POINTS
517: -- 4. HZ_PARTY_SITES
518: -- 5. HZ_ORG_CONTACTS
519: -- 6. AS_SALES_LEADS
520: -- 7. AS_SALES_LEAD_LINES
521: -- 8. AS_SALES_LEAD_CONTACTS
522: --------------------------------------------------------

Line 737: if (pEntity = 'HZ_ORG_CONTACTS') then

733: -- pHzpsRec.global_attribute18 := I.gattr_val_18;
734: -- pHzpsRec.global_attribute19 := I.gattr_val_19;
735: -- pHzpsRec.global_attribute20 := I.gattr_val_20;
736: end if;
737: if (pEntity = 'HZ_ORG_CONTACTS') then
738: pHzocRec.attribute_category := I.attr_val_category;
739: pHzocRec.attribute1 := I.attr_val_1;
740: pHzocRec.attribute2 := I.attr_val_2;
741: pHzocRec.attribute3 := I.attr_val_3;

Line 2156: 'HZ_ORG_CONTACTS',

2152: -- l_dummy_rec6 ,
2153: l_dummy_rec7 ,
2154: l_dummy_tbl8 ,
2155: l_dummy_tbl9 ,
2156: 'HZ_ORG_CONTACTS',
2157: pI.import_interface_id,
2158: G_return_status
2159: );
2160: If G_return_status = FND_API.G_RET_STS_SUCCESS Then

Line 2266: -- ffang 082001, hz_org_contacts_roles'

2262:
2263: If (( l_role_rec.role_type is not null) OR
2264: (l_role_rec.role_type <> FND_API.G_MISS_CHAR))
2265: Then
2266: -- ffang 082001, hz_org_contacts_roles'
2267: -- flexfields are going to be obsolete.
2268: -- No need to populate.
2269: /* ***
2270: do_assign_flex (

Line 3448: FROM hz_matched_contacts_gt hzmc, hz_org_contacts hzoc

3444: -- Cursor for getting matched contacts from hz_matched_contacts_gt
3445: CURSOR C_matched_contacts
3446: IS
3447: SELECT hzmc.party_id, hzmc.org_contact_id, score , hzoc.creation_date
3448: FROM hz_matched_contacts_gt hzmc, hz_org_contacts hzoc
3449: WHERE search_context_id = l_search_context_id
3450: AND hzmc.org_contact_id = hzoc.org_contact_id
3451: AND nvl(hzoc.status,'A') = 'A' --bug# 3319259
3452: ORDER BY score desc, hzoc.creation_date desc;

Line 3470: FROM hz_org_contacts hzoc, hz_relationships hzr

3466: -- Cursor for getting contact_party_id and rel_party_id
3467: CURSOR C_get_contact_info
3468: IS
3469: SELECT decode(subject_type,'PERSON',subject_id, object_id) contact_party_id, party_id
3470: FROM hz_org_contacts hzoc, hz_relationships hzr
3471: WHERE hzoc.org_contact_id = l_org_contact_id
3472: AND hzr.relationship_id = hzoc.party_relationship_id
3473: and hzr.relationship_code = 'CONTACT_OF';
3474: