[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:
1461: else
1462: if l_rec_update_flag = 'Y' and l_org_lp_psite_id is not NULL then
1463: org_psite_rec.party_site_id := l_org_lp_psite_id;
1464: select OBJECT_VERSION_NUMBER into l_ps_obj_number
1465: from hz_party_sites
1466: where party_site_id = l_org_lp_psite_id;
1467: hz_party_site_v2pub.update_party_site(
1468: 'F',
1469: org_psite_rec,
1573: else
1574: if l_rec_update_flag = 'Y' and l_lp_psite_id is not NULL then
1575: psite_rec.party_site_id := l_lp_psite_id;
1576: select OBJECT_VERSION_NUMBER into l_ps_obj_number
1577: from hz_party_sites
1578: where party_site_id = l_lp_psite_id;
1579: hz_party_site_v2pub.update_party_site(
1580: 'F',
1581: psite_rec,
2615: else
2616: if l_rec_update_flag = 'Y' and l_lp_psite_id is not NULL then
2617: psite_rec.party_site_id := l_lp_psite_id;
2618: select OBJECT_VERSION_NUMBER into l_ps_obj_number
2619: from hz_party_sites
2620: where party_site_id = l_lp_psite_id;
2621: hz_party_site_v2pub.update_party_site(
2622: 'F',
2623: psite_rec,
2996: x_per_party_id number;
2997: x_party_id number;
2998:
2999: cursor c_address_country is
3000: select max(psite.party_id) from hz_party_sites psite, hz_locations loc,
3001: hz_parties party
3002: where psite.location_id = loc.location_id
3003: and loc.address1 = p_address1
3004: and loc.country = p_country
3009:
3010: -- sranka 1/13/2003 created new cursor c_address_country_with_osr for including the orig_system_reference for duplication check
3011:
3012: cursor c_address_country_with_osr is
3013: select max(psite.party_id) from hz_party_sites psite, hz_locations loc,
3014: hz_parties party
3015: where psite.location_id = loc.location_id
3016: and loc.address1 = p_address1
3017: and loc.country = p_country
3021: and psite.party_id = party.party_id
3022: and party.orig_system_reference = p_orig_system_reference;
3023:
3024: cursor c_country is
3025: select max(psite.party_id) from hz_party_sites psite, hz_locations loc,
3026: hz_parties party
3027: where psite.location_id = loc.location_id
3028: and loc.country = p_country
3029: and party.customer_key = l_party_key
3034: -- sranka 1/13/2003
3035: -- created new cursor c_country_with_osr for including the orig_system_reference for duplication check
3036:
3037: cursor c_country_with_osr is
3038: select max(psite.party_id) from hz_party_sites psite, hz_locations loc,
3039: hz_parties party
3040: where psite.location_id = loc.location_id
3041: and loc.country = p_country
3042: and party.customer_key = l_party_key
4430: and nvl(cp.phone_area_code,nvl(p_ph_area_code,'x')) = nvl(p_ph_area_code,'x');
4431: */
4432:
4433: cursor c_address_country is
4434: select max(psite.party_id) from hz_party_sites psite, hz_locations loc,
4435: hz_parties party
4436: where psite.location_id = loc.location_id
4437: and loc.address1 = p_address1
4438: and loc.country = p_country
4441: and party.status = 'A'
4442: and psite.party_id = party.party_id;
4443:
4444: cursor c_address_country_with_osr is
4445: select max(psite.party_id) from hz_party_sites psite, hz_locations loc,
4446: hz_parties party
4447: where psite.location_id = loc.location_id
4448: and loc.address1 = p_address1
4449: and loc.country = p_country
4696: and nvl(cp.phone_area_code,nvl(p_ph_area_code,'x')) = nvl(p_ph_area_code,'x');
4697: */
4698:
4699: cursor c_address_country is
4700: select max(p2.party_id) from hz_party_sites psite, hz_locations loc,
4701: hz_parties party, hz_relationships hr, hz_parties p2
4702: where psite.location_id = loc.location_id
4703: and loc.address1 = p_address1
4704: and loc.country = p_country
4712: and hr.relationship_code = 'CONTACT_OF'
4713: and hr.subject_id = p2.party_id;
4714:
4715: cursor c_address_country_with_osr is
4716: select max(p2.party_id) from hz_party_sites psite, hz_locations loc,
4717: hz_parties party, hz_relationships hr, hz_parties p2
4718: where psite.location_id = loc.location_id
4719: and loc.address1 = p_address1
4720: and loc.country = p_country