APPS.AS_IMPORT_SL_PVT dependencies on HZ_PARTY_SITES

Line 517: -- 4. HZ_PARTY_SITES

513: -- note: currently, the following entities are only supported
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

Line 693: if (pEntity = 'HZ_PARTY_SITES') then

689: -- pHzcpRec.global_attribute18 := I.gattr_val_18;
690: -- pHzcpRec.global_attribute19 := I.gattr_val_19;
691: -- pHzcpRec.global_attribute20 := I.gattr_val_20;
692: end if;
693: if (pEntity = 'HZ_PARTY_SITES') then
694: pHzpsRec.attribute_category := I.attr_val_category;
695: pHzpsRec.attribute1 := I.attr_val_1;
696: pHzpsRec.attribute2 := I.attr_val_2;
697: pHzpsRec.attribute3 := I.attr_val_3;

Line 1045: and contact_level_table = 'HZ_PARTY_SITES';

1041: into l_res_id
1042: from hz_contact_preferences
1043: where contact_level_table_id = pI.party_site_id
1044: and contact_type = 'MAIL'
1045: and contact_level_table = 'HZ_PARTY_SITES';
1046:
1047: Exception
1048: when NO_DATA_FOUND then
1049: l_res_rec.contact_type := 'MAIL';

Line 1051: l_res_rec.contact_level_table := 'HZ_PARTY_SITES';

1047: Exception
1048: when NO_DATA_FOUND then
1049: l_res_rec.contact_type := 'MAIL';
1050: l_res_rec.preference_start_date := sysdate;
1051: l_res_rec.contact_level_table := 'HZ_PARTY_SITES';
1052: l_res_rec.contact_level_table_id:= pI.party_site_id;
1053:
1054: write_log (3, 'Creating CntPreference: AMAIL');
1055: HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference (

Line 1987: 'HZ_PARTY_SITES',

1983: -- l_dummy_rec6 ,
1984: l_dummy_rec7 ,
1985: l_dummy_tbl8 ,
1986: l_dummy_tbl9 ,
1987: 'HZ_PARTY_SITES',
1988: pI.import_interface_id,
1989: G_return_status
1990: );
1991: ELSIF p_type = 'REL' THEN

Line 3253: from as_import_interface s, hz_parties p, hz_party_sites ps

3249: p.last_update_date, s.address_key, s.country,
3250: nvl(ps.identifying_address_flag, 'N')
3251: identifying_address_flag,
3252: ps.location_id, ps.party_site_id
3253: from as_import_interface s, hz_parties p, hz_party_sites ps
3254: where s.load_status = 'NEW'
3255: and s.import_interface_id = p_interface_id
3256: and p.customer_key (+) = s.customer_key
3257: and p.party_type (+) = s.party_type

Line 3456: FROM hz_matched_party_sites_gt hzmps, hz_party_sites hzps

3452: -- Cursor for getting matched party_site from hz_matched_party_sites_gt
3453: CURSOR C_matched_party_sites
3454: IS
3455: SELECT hzmps.party_id, hzmps.party_site_id, score , hzps.creation_date
3456: FROM hz_matched_party_sites_gt hzmps, hz_party_sites hzps
3457: WHERE search_context_id = l_search_context_id
3458: AND hzps.party_site_id = hzmps.party_site_id
3459: AND hzps.party_id = hzmps.party_id
3460: AND nvl(hzps.status,'A') = 'A' --bug# 3319259

Line 3507: FROM hz_party_sites

3503: -- Cursor for getting party_site_id given the party_id
3504: CURSOR C_get_party_site_id(p_party_id number)
3505: IS
3506: SELECT party_site_id, nvl(identifying_address_flag,'N')
3507: FROM hz_party_sites
3508: WHERE party_id = p_party_id
3509: AND nvl(start_date_active,sysdate) <= sysdate
3510: AND nvl(end_date_active,sysdate) >= sysdate
3511: ORDER BY nvl(identifying_address_flag,'N') DESC;

Line 3842: FROM hz_party_sites

3838: IF C_matched_party_sites%FOUND THEN
3839: write_log(3,'Matched party_site - '||to_char(l_party_site_id)|| ' score '||to_char(l_score)||' created '||to_char(l_creation_date));
3840: I.party_site_id := l_party_site_id;
3841: SELECT location_id INTO I.location_ID
3842: FROM hz_party_sites
3843: WHERE party_site_id = I.party_site_id;
3844: l_create_party_site := 'N';
3845: l_create_location := 'N';
3846: ELSE

Line 3856: FROM hz_party_sites

3852:
3853: ELSE -- IF party_site_id is not null
3854: IF I.location_id IS NULL AND I.party_site_id IS NOT NULL THEN
3855: SELECT location_id INTO I.location_ID
3856: FROM hz_party_sites
3857: WHERE party_site_id = I.party_site_id;
3858: END IF;
3859: l_create_party_site := 'N';
3860: l_create_location := 'N';