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