[Home] [Help]
251: org_psite_rec hz_party_site_v2pub.party_site_rec_type := p_org_psite_rec;
252: language_rec hz_person_info_v2pub.person_language_rec_type := p_language_rec;
253: org_party_site_phone_rec hz_contact_point_v2pub.phone_rec_type := p_org_party_site_phone_rec;
254:
255: l_address_key hz_locations.address_key%TYPE ;
256: l_address_key_count NUMBER ;
257:
258: x_b2b varchar(1);
259: x_rented_list_flag varchar(1) := 0;
1378: p_msg_data => 'Create Location for Organization : Check existence for key '||l_address_key ,
1379: p_msg_type => 'DEBUG');
1380:
1381:
1382: select count(*) INTO l_address_key_count from hz_locations where address_key=l_address_key;
1383:
1384: if l_address_key_count =0 then
1385:
1386: AMS_Utility_PVT.Create_Log (
1405: end if;
1406: else
1407: if l_rec_update_flag = 'Y' and x_org_location_id is not NULL then
1408: select OBJECT_VERSION_NUMBER into l_loc_obj_number
1409: from hz_locations
1410: where location_id = x_org_location_id;
1411: org_location_rec.location_id := x_org_location_id;
1412: hz_location_v2pub.update_location(
1413: 'F',
1518: end if; -- if location_rec.address1 is not NULL
1519: else
1520: if l_rec_update_flag = 'Y' and x_location_id is not NULL then
1521: select OBJECT_VERSION_NUMBER into l_loc_obj_number
1522: from hz_locations
1523: where location_id = x_location_id;
1524: location_rec.location_id := x_location_id;
1525: hz_location_v2pub.update_location(
1526: 'F',
2558: end if; -- if location_rec.address1 is not NULL
2559: else
2560: if l_rec_update_flag = 'Y' and x_location_id is not NULL then
2561: select OBJECT_VERSION_NUMBER into l_loc_obj_number
2562: from hz_locations
2563: where location_id = x_location_id;
2564: location_rec.location_id := x_location_id;
2565: hz_location_v2pub.update_location(
2566: 'F',
2989: x_per_party_id number;
2990: x_party_id number;
2991:
2992: cursor c_address_country is
2993: select max(psite.party_id) from hz_party_sites psite, hz_locations loc,
2994: hz_parties party
2995: where psite.location_id = loc.location_id
2996: and loc.address1 = p_address1
2997: and loc.country = p_country
3002:
3003: -- sranka 1/13/2003 created new cursor c_address_country_with_osr for including the orig_system_reference for duplication check
3004:
3005: cursor c_address_country_with_osr is
3006: select max(psite.party_id) from hz_party_sites psite, hz_locations loc,
3007: hz_parties party
3008: where psite.location_id = loc.location_id
3009: and loc.address1 = p_address1
3010: and loc.country = p_country
3014: and psite.party_id = party.party_id
3015: and party.orig_system_reference = p_orig_system_reference;
3016:
3017: cursor c_country is
3018: select max(psite.party_id) from hz_party_sites psite, hz_locations loc,
3019: hz_parties party
3020: where psite.location_id = loc.location_id
3021: and loc.country = p_country
3022: and party.customer_key = l_party_key
3027: -- sranka 1/13/2003
3028: -- created new cursor c_country_with_osr for including the orig_system_reference for duplication check
3029:
3030: cursor c_country_with_osr is
3031: select max(psite.party_id) from hz_party_sites psite, hz_locations loc,
3032: hz_parties party
3033: where psite.location_id = loc.location_id
3034: and loc.country = p_country
3035: and party.customer_key = l_party_key
4423: and nvl(cp.phone_area_code,nvl(p_ph_area_code,'x')) = nvl(p_ph_area_code,'x');
4424: */
4425:
4426: cursor c_address_country is
4427: select max(psite.party_id) from hz_party_sites psite, hz_locations loc,
4428: hz_parties party
4429: where psite.location_id = loc.location_id
4430: and loc.address1 = p_address1
4431: and loc.country = p_country
4434: and party.status = 'A'
4435: and psite.party_id = party.party_id;
4436:
4437: cursor c_address_country_with_osr is
4438: select max(psite.party_id) from hz_party_sites psite, hz_locations loc,
4439: hz_parties party
4440: where psite.location_id = loc.location_id
4441: and loc.address1 = p_address1
4442: and loc.country = p_country
4689: and nvl(cp.phone_area_code,nvl(p_ph_area_code,'x')) = nvl(p_ph_area_code,'x');
4690: */
4691:
4692: cursor c_address_country is
4693: select max(p2.party_id) from hz_party_sites psite, hz_locations loc,
4694: hz_parties party, hz_relationships hr, hz_parties p2
4695: where psite.location_id = loc.location_id
4696: and loc.address1 = p_address1
4697: and loc.country = p_country
4705: and hr.relationship_code = 'CONTACT_OF'
4706: and hr.subject_id = p2.party_id;
4707:
4708: cursor c_address_country_with_osr is
4709: select max(p2.party_id) from hz_party_sites psite, hz_locations loc,
4710: hz_parties party, hz_relationships hr, hz_parties p2
4711: where psite.location_id = loc.location_id
4712: and loc.address1 = p_address1
4713: and loc.country = p_country