[Home] [Help]
2654: if l_imp_type = 'B2B' then
2655: --if party_id is provided and if its of type relationship
2656: --update org_party_id and ocont_party_id
2657: update ams_hz_b2b_mapping_v b2b
2658: set (org_party_id, ocont_party_id) = (select object_id, subject_id from hz_relationships
2659: where party_id = b2b.party_id and object_type = 'ORGANIZATION'
2660: and subject_type = 'PERSON' and relationship_type = 'CONTACT'
2661: and nvl(status,'A') = 'A')
2662: where import_list_header_id = p_import_list_header_id
4866: where hd.import_list_header_id = sr.import_list_header_id
4867: and sr.party_id = p_party_id;
4868:
4869: cursor c_relationship is
4870: SELECT RELATIONSHIP_ID, OBJECT_VERSION_NUMBER FROM hz_relationships WHERE subject_type = 'PERSON'
4871: AND party_id = p_party_id;
4872:
4873: CURSOR LOCATION_EXISTS IS
4874: SELECT party_site_id FROM hz_party_sites
4942: RETURN;
4943: end if;
4944:
4945: if x_b2b = 'B2B' then
4946: SELECT subject_id into x_org_party_id FROM hz_relationships WHERE subject_type = 'ORGANIZATION'
4947: AND party_id = p_party_id;
4948: OPEN b2b;
4949: FETCH b2b into
4950: org_rec.party_rec.orig_system_reference,
5192: end if;
5193:
5194: -- Update Person
5195:
5196: SELECT subject_id into x_person_id FROM hz_relationships WHERE subject_type = 'PERSON'
5197: AND party_id = p_party_id;
5198: -- SELECT last_update_date INTO l_last_update_date1
5199: SELECT OBJECT_VERSION_NUMBER INTO l_object_version
5200: FROM HZ_PARTIES
13947: if l_import_type = 'B2B' then
13948: --if party_id is provided and if its of type relationship
13949: --update org_party_id and ocont_party_id
13950: update ams_hz_b2b_mapping_v b2b
13951: set (org_party_id, ocont_party_id) = (select object_id, subject_id from hz_relationships
13952: where party_id = b2b.party_id and object_type = 'ORGANIZATION'
13953: and subject_type = 'PERSON' and relationship_type = 'CONTACT'
13954: and nvl(status,'A') = 'A')
13955: where import_list_header_id = p_import_list_header_id
19729: cursor c_cont_email_phone is
19730: select b2b.import_source_line_id, max(per.party_id) from
19731: hz_parties org,
19732: hz_parties per,
19733: hz_relationships rel,
19734: hz_contact_points cpoint,
19735: hz_contact_points cpoint1,
19736: ams_hz_b2b_mapping_v b2b
19737: where b2b.import_list_header_id = p_import_list_header_id
19770: cursor c_cont_email is
19771: select b2b.import_source_line_id,max(per.party_id) from
19772: hz_parties org,
19773: hz_parties per,
19774: hz_relationships rel,
19775: hz_contact_points cpoint,
19776: ams_hz_b2b_mapping_v b2b
19777: where b2b.import_list_header_id = p_import_list_header_id
19778: and b2b.load_status in ('ACTIVE','RELOAD')
19802: cursor c_cont_phone is
19803: select b2b.import_source_line_id,max(per.party_id) from
19804: hz_parties org,
19805: hz_parties per,
19806: hz_relationships rel,
19807: hz_contact_points cpoint,
19808: ams_hz_b2b_mapping_v b2b
19809: where b2b.import_list_header_id = p_import_list_header_id
19810: and b2b.load_status in ('ACTIVE','RELOAD')
20093: cursor c_cont_email_phone is
20094: select b2b.import_source_line_id, max(per.party_id) from
20095: hz_parties org,
20096: hz_parties per,
20097: hz_relationships rel,
20098: hz_contact_points cpoint,
20099: hz_contact_points cpoint1,
20100: ams_hz_b2b_mapping_v b2b
20101: where b2b.import_list_header_id = p_import_list_header_id
20134: cursor c_cont_email is
20135: select b2b.import_source_line_id,max(per.party_id) from
20136: hz_parties org,
20137: hz_parties per,
20138: hz_relationships rel,
20139: hz_contact_points cpoint,
20140: ams_hz_b2b_mapping_v b2b
20141: where b2b.import_list_header_id = p_import_list_header_id
20142: and b2b.load_status in ('ACTIVE','RELOAD')
20166: cursor c_cont_phone is
20167: select b2b.import_source_line_id,max(per.party_id) from
20168: hz_parties org,
20169: hz_parties per,
20170: hz_relationships rel,
20171: hz_contact_points cpoint,
20172: ams_hz_b2b_mapping_v b2b
20173: where b2b.import_list_header_id = p_import_list_header_id
20174: and b2b.load_status in ('ACTIVE','RELOAD')