[Home] [Help]
404: AND relationship_type = NVL(ocon_rec.party_rel_rec.relationship_type,'CONTACT')
405: AND party_id = l_b2b_party_id;
406:
407: CURSOR LOCATION_EXISTS IS
408: SELECT party_site_id FROM hz_party_sites
409: WHERE party_id = x_org_party_id
410: AND location_id = x_location_id;
411:
412: -- sranka 7/15/2003 made changes for COLt Enhancements
410: AND location_id = x_location_id;
411:
412: -- sranka 7/15/2003 made changes for COLt Enhancements
413: CURSOR ORG_LOCATION_EXISTS IS
414: SELECT party_site_id FROM hz_party_sites
415: WHERE party_id = x_org_party_id
416: AND location_id = x_org_location_id;
417:
418: CURSOR PER_LOCATION_EXISTS IS
415: WHERE party_id = x_org_party_id
416: AND location_id = x_org_location_id;
417:
418: CURSOR PER_LOCATION_EXISTS IS
419: SELECT party_site_id FROM hz_party_sites
420: WHERE party_id = x_per_party_id
421: AND location_id = x_location_id;
422:
423: CURSOR CHECK_PSITE_EXISTS IS
420: WHERE party_id = x_per_party_id
421: AND location_id = x_location_id;
422:
423: CURSOR CHECK_PSITE_EXISTS IS
424: SELECT party_site_id FROM hz_party_sites
425: WHERE party_id = x_party_rel_party_id
426: AND location_id = x_location_id;
427:
428:
1457: else
1458: if l_rec_update_flag = 'Y' and l_org_lp_psite_id is not NULL then
1459: org_psite_rec.party_site_id := l_org_lp_psite_id;
1460: select OBJECT_VERSION_NUMBER into l_ps_obj_number
1461: from hz_party_sites
1462: where party_site_id = l_org_lp_psite_id;
1463: hz_party_site_v2pub.update_party_site(
1464: 'F',
1465: org_psite_rec,
1569: else
1570: if l_rec_update_flag = 'Y' and l_lp_psite_id is not NULL then
1571: psite_rec.party_site_id := l_lp_psite_id;
1572: select OBJECT_VERSION_NUMBER into l_ps_obj_number
1573: from hz_party_sites
1574: where party_site_id = l_lp_psite_id;
1575: hz_party_site_v2pub.update_party_site(
1576: 'F',
1577: psite_rec,
2608: else
2609: if l_rec_update_flag = 'Y' and l_lp_psite_id is not NULL then
2610: psite_rec.party_site_id := l_lp_psite_id;
2611: select OBJECT_VERSION_NUMBER into l_ps_obj_number
2612: from hz_party_sites
2613: where party_site_id = l_lp_psite_id;
2614: hz_party_site_v2pub.update_party_site(
2615: 'F',
2616: psite_rec,
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