APPS.AS_IMPORT_SL_PVT dependencies on HZ_LOCATIONS

Line 515: -- 2. HZ_LOCATIONS

511: -- scope: private
512: -- assign the Recs with flex values
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

Line 605: if (pEntity = 'HZ_LOCATIONS') then

601: -- pHzpRec.global_attribute18 := I.gattr_val_18;
602: -- pHzpRec.global_attribute19 := I.gattr_val_19;
603: -- pHzpRec.global_attribute20 := I.gattr_val_20;
604: end if;
605: if (pEntity = 'HZ_LOCATIONS') then
606: pHzlRec.attribute_category := I.attr_val_category;
607: pHzlRec.attribute1 := I.attr_val_1;
608: pHzlRec.attribute2 := I.attr_val_2;
609: pHzlRec.attribute3 := I.attr_val_3;

Line 1792: 'HZ_LOCATIONS',

1788: -- l_dummy_rec6 ,
1789: l_dummy_rec7 ,
1790: l_dummy_tbl8 ,
1791: l_dummy_tbl9 ,
1792: 'HZ_LOCATIONS',
1793: pI.import_interface_id,
1794: G_return_status
1795: );
1796:

Line 3242: hz_locations l

3238: and p.party_type (+) = s.party_type
3239: and p.status (+) = 'A'
3240: and ps.status (+) = 'A'
3241: and ps.party_id (+) = p.party_id) p2,
3242: hz_locations l
3243: where l.country (+) = p2.country
3244: and l.location_id (+) = p2.location_id
3245: group by decode(p2.address_key,l.address_key,0,1)+
3246: decode(p2.country,l.country,0,2),

Line 3252: l_country hz_locations.country%Type;

3248: p2.customer_key, p2.address_key, p2.country
3249: order by match_rank asc, identifying_address_flag desc,
3250: party_id desc;
3251:
3252: l_country hz_locations.country%Type;
3253: l_akey hz_locations.address_key%Type;
3254: BEGIN
3255: p_plupd_date := Null;
3256: If (p_imp_id is Null) then

Line 3253: l_akey hz_locations.address_key%Type;

3249: order by match_rank asc, identifying_address_flag desc,
3250: party_id desc;
3251:
3252: l_country hz_locations.country%Type;
3253: l_akey hz_locations.address_key%Type;
3254: BEGIN
3255: p_plupd_date := Null;
3256: If (p_imp_id is Null) then
3257: return;

Line 3278: from hz_locations

3274: Exit;
3275: End Loop;
3276: if (p_loc_id is null) then
3277: select max(location_id) into p_loc_id
3278: from hz_locations
3279: where address_key = l_akey and country = l_country;
3280: End if;
3281: End If;
3282: if (p_party_id is not null) then