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 3261: hz_locations l

3257: and p.party_type (+) = s.party_type
3258: and p.status (+) = 'A'
3259: and ps.status (+) = 'A'
3260: and ps.party_id (+) = p.party_id) p2,
3261: hz_locations l
3262: where l.country (+) = p2.country
3263: and l.location_id (+) = p2.location_id
3264: group by decode(p2.address_key,l.address_key,0,1)+
3265: decode(p2.country,l.country,0,2),

Line 3271: l_country hz_locations.country%Type;

3267: p2.customer_key, p2.address_key, p2.country
3268: order by match_rank asc, identifying_address_flag desc,
3269: party_id desc;
3270:
3271: l_country hz_locations.country%Type;
3272: l_akey hz_locations.address_key%Type;
3273: BEGIN
3274: p_plupd_date := Null;
3275: If (p_imp_id is Null) then

Line 3272: l_akey hz_locations.address_key%Type;

3268: order by match_rank asc, identifying_address_flag desc,
3269: party_id desc;
3270:
3271: l_country hz_locations.country%Type;
3272: l_akey hz_locations.address_key%Type;
3273: BEGIN
3274: p_plupd_date := Null;
3275: If (p_imp_id is Null) then
3276: return;

Line 3297: from hz_locations

3293: Exit;
3294: End Loop;
3295: if (p_loc_id is null) then
3296: select max(location_id) into p_loc_id
3297: from hz_locations
3298: where address_key = l_akey and country = l_country;
3299: End if;
3300: End If;
3301: if (p_party_id is not null) then