[Home] [Help]
4869: SELECT RELATIONSHIP_ID, OBJECT_VERSION_NUMBER FROM hz_relationships WHERE subject_type = 'PERSON'
4870: AND party_id = p_party_id;
4871:
4872: CURSOR LOCATION_EXISTS IS
4873: SELECT party_site_id FROM hz_party_sites
4874: WHERE party_id = x_org_party_id
4875: AND location_id = x_location_id;
4876:
4877: CURSOR CHECK_PSITE_EXISTS IS
4874: WHERE party_id = x_org_party_id
4875: AND location_id = x_location_id;
4876:
4877: CURSOR CHECK_PSITE_EXISTS IS
4878: SELECT party_site_id FROM hz_party_sites
4879: WHERE party_id = x_party_rel_party_id
4880: AND location_id = x_location_id;
4881:
4882: CURSOR phone_exists (x_hz_party_id number) IS
4898: AND owner_table_id = x_hz_party_id
4899: AND email_address = x_email_address;
4900:
4901: CURSOR PER_LOCATION_EXISTS IS
4902: SELECT party_site_id FROM hz_party_sites
4903: WHERE party_id = x_per_party_id
4904: AND location_id = x_location_id;
4905:
4906: party_rec hz_party_v2pub.party_rec_type;
13479:
13480:
13481: cursor c_addr_ps is
13482: select max(loc.location_id)
13483: from hz_party_sites ps, hz_locations loc
13484: where ps.party_id = p_party_id
13485: and ps.location_id = loc.location_id
13486: and loc.address_key = l_address_key
13487: and loc.country = p_country
13571:
13572: begin
13573: x_gen_party_site_number := fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER');
13574: x_party_site_number := null;
13575: select hz_party_sites_s.nextval into x_party_site_id from dual;
13576: if x_gen_party_site_number = 'N' then
13577: select hz_party_site_number_s.nextval into x_party_site_number from dual;
13578: end if;
13579:
18575:
18576:
18577: cursor c_address_country is
18578: select b2b.import_source_line_id, max(psite.party_id)
18579: from hz_party_sites psite, hz_locations loc,
18580: hz_parties party, ams_hz_b2b_mapping_v b2b
18581: where b2b.import_list_header_id = p_import_list_header_id
18582: and b2b.load_status in ('ACTIVE','RELOAD')
18583: and b2b.org_exist = 'Y'
18594: group by b2b.import_source_line_id;
18595:
18596: cursor c_country is
18597: select b2b.import_source_line_id, max(psite.party_id)
18598: from hz_party_sites psite, hz_locations loc,
18599: hz_parties party, ams_hz_b2b_mapping_v b2b
18600: where b2b.import_list_header_id = p_import_list_header_id
18601: and b2b.load_status in ('ACTIVE','RELOAD')
18602: and b2b.org_exist = 'Y'
18845:
18846:
18847: cursor c_address_country is
18848: select b2b.import_source_line_id, max(psite.party_id)
18849: from hz_party_sites psite, hz_locations loc,
18850: hz_parties party, ams_hz_b2b_mapping_v b2b
18851: where b2b.import_list_header_id = p_import_list_header_id
18852: and b2b.load_status in ('ACTIVE','RELOAD')
18853: and b2b.org_exist = 'Y'
18865: group by b2b.import_source_line_id;
18866:
18867: cursor c_country is
18868: select b2b.import_source_line_id, max(psite.party_id)
18869: from hz_party_sites psite, hz_locations loc,
18870: hz_parties party, ams_hz_b2b_mapping_v b2b
18871: where b2b.import_list_header_id = p_import_list_header_id
18872: and b2b.load_status in ('ACTIVE','RELOAD')
18873: and b2b.org_exist = 'Y'
19157: group by b2c.import_source_line_id;
19158:
19159: cursor c_address_country is
19160: select b2c.import_source_line_id, max(psite.party_id)
19161: from hz_party_sites psite, hz_locations loc, hz_parties party, ams_hz_b2c_mapping_v b2c
19162: where b2c.import_list_header_id = p_import_list_header_id
19163: and b2c.load_status in ('ACTIVE','RELOAD')
19164: and b2c.person_exist = 'Y'
19165: and b2c.address1 is not null
19473: group by b2c.import_source_line_id;
19474:
19475: cursor c_address_country is
19476: select b2c.import_source_line_id, max(psite.party_id)
19477: from hz_party_sites psite, hz_locations loc, hz_parties party, ams_hz_b2c_mapping_v b2c
19478: where b2c.import_list_header_id = p_import_list_header_id
19479: and b2c.load_status in ('ACTIVE','RELOAD')
19480: and b2c.person_exist = 'Y'
19481: and b2c.address1 is not null
20388: and b2b.address1 is not null;
20389:
20390: cursor c_addr_ps is
20391: select b2b.import_source_line_id,max(loc.location_id)
20392: from hz_party_sites ps, hz_locations loc,ams_hz_b2b_mapping_v b2b
20393: where b2b.import_list_header_id = p_import_list_header_id
20394: and b2b.load_status in ('ACTIVE','RELOAD')
20395: and b2b.address_key is not null
20396: and b2b.org_party_id is not null
20546: and b2b.org_address1 is not null;
20547:
20548: cursor c_addr_ps is
20549: select b2b.import_source_line_id,max(loc.location_id)
20550: from hz_party_sites ps, hz_locations loc,ams_hz_b2b_mapping_v b2b
20551: where b2b.import_list_header_id = p_import_list_header_id
20552: and b2b.load_status in ('ACTIVE','RELOAD')
20553: and b2b.org_address_key is not null
20554: and b2b.org_party_id is not null
20704: and b2c.address1 is not null;
20705:
20706: cursor c_addr_ps is
20707: select b2c.import_source_line_id,max(loc.location_id)
20708: from hz_party_sites ps, hz_locations loc,ams_hz_b2c_mapping_v b2c
20709: where b2c.import_list_header_id = p_import_list_header_id
20710: and b2c.load_status in ('ACTIVE','RELOAD')
20711: and b2c.address_key is not null
20712: and b2c.person_party_id is not null