[Home] [Help]
3603: * to the position of the decimal point, replace this with
3604: * the correct value from fnd_lookup_values provided that the
3605: * actual_content_source for this record is not 'USER_ENTERED'.
3606: * 31-DEC-2004 Rajib Ranjan Borah o SSM SST Integration and Extension.
3607: * Call HZ_MIXNM_UTILITY.create_exceptions if actual_content_source
3608: * is some third party content source and no prior profile exists..
3609: */
3610:
3611: PROCEDURE do_create_party(
3667:
3668: -- Find the real data source
3669:
3670: l_data_source_type :=
3671: HZ_MIXNM_UTILITY.FindDataSource (
3672: p_content_source_type => p_person_rec.content_source_type,
3673: p_actual_content_source => p_person_rec.actual_content_source,
3674: p_def_actual_content_source => G_SST_SOURCE_TYPE,
3675: x_data_source_from => l_data_source_from );
3719:
3720: -- Find the real data source
3721:
3722: l_data_source_type :=
3723: HZ_MIXNM_UTILITY.FindDataSource(
3724: p_content_source_type => p_organization_rec.content_source_type,
3725: p_actual_content_source => p_organization_rec.actual_content_source,
3726: p_def_actual_content_source => G_SST_SOURCE_TYPE,
3727: x_data_source_from => l_data_source_from );
3849: p_actual_content_source => l_actual_content_source,
3850: x_profile_id => x_profile_id );
3851: /* Bug 4244112 : do not populate for just UE record
3852: IF l_mixnmatch_enabled = 'Y' THEN
3853: HZ_MIXNM_UTILITY.populateMRRExc(
3854: 'HZ_'||p_party_type||'_PROFILES',
3855: l_content_source_type,
3856: x_party_id);
3857: END IF;
3861: -- find if data source is selected
3862:
3863: IF l_mixnmatch_enabled = 'Y' THEN
3864: l_datasource_selected :=
3865: HZ_MIXNM_UTILITY.isDataSourceSelected(
3866: -- Bug 4376604 : pass entity type
3867: p_party_type,
3868: l_data_source_type);
3869: END IF;
3982: p_actual_content_source => l_actual_content_source,
3983: x_profile_id => l_profile_id );
3984:
3985: -- SSM SST Integration and Extension
3986: HZ_MIXNM_UTILITY.create_exceptions (
3987: p_party_type => p_party_type,
3988: p_organization_rec => p_organization_rec,
3989: p_person_rec => p_person_rec,
3990: p_third_party_content_source => l_data_source_type,
3989: p_person_rec => p_person_rec,
3990: p_third_party_content_source => l_data_source_type,
3991: p_party_id => x_party_id);
3992:
3993: HZ_MIXNM_UTILITY.populateMRRExc(
3994: 'HZ_'||p_party_type||'_PROFILES',
3995: l_data_source_type,
3996: x_party_id);
3997: ELSE -- need to generate SST profile.
4014: l_create_update_sst_flag := 'C';
4015: l_new_sst_person_rec := l_sst_person_rec;
4016: l_new_sst_organization_rec := l_sst_organization_rec;
4017: -- Bug 4244112 : populate when first third party profile is created
4018: HZ_MIXNM_UTILITY.populateMRRExc(
4019: 'HZ_'||p_party_type||'_PROFILES',
4020: l_data_source_type,
4021: x_party_id);
4022: ELSE
4032: IF l_datasource_selected = 'Y' THEN
4033: -- return SST record which we need to use either
4034: -- generate a SST profile or update an existing SST profile.
4035:
4036: HZ_MIXNM_UTILITY.updateSSTProfile(
4037: p_create_update_flag => 'C',
4038: p_create_update_sst_flag => l_create_update_sst_flag,
4039: p_raise_error_flag => 'N',
4040: p_party_type => p_party_type,
4584: -- if we need to propagate the change to SST profile,
4585: -- and the party.
4586:
4587: l_datasource_selected :=
4588: HZ_MIXNM_UTILITY.isDataSourceSelected(
4589: -- Bug 4376604 : pass entity type
4590: p_party_type,
4591: l_data_source_type);
4592:
4618:
4619: -- return SST record which we need to use to update an existing
4620: -- SST profile.
4621:
4622: HZ_MIXNM_UTILITY.updateSSTProfile (
4623: p_create_update_flag => 'U',
4624: p_create_update_sst_flag => 'U',
4625: p_raise_error_flag => l_raise_error,
4626: p_party_type => p_party_type,
4909:
4910: -- cache if mix-n-match is enabled
4911:
4912: -- IF g_per_mixnmatch_enabled IS NULL THEN
4913: HZ_MIXNM_UTILITY.LoadDataSources(
4914: 'HZ_PERSON_PROFILES', g_per_entity_attr_id,
4915: g_per_mixnmatch_enabled, g_per_selected_datasources);
4916: -- END IF;
4917:
5296: END IF;
5297: -- cache if mix-n-match is enabled
5298:
5299: -- IF g_per_mixnmatch_enabled IS NULL THEN
5300: HZ_MIXNM_UTILITY.LoadDataSources(
5301: 'HZ_PERSON_PROFILES', g_per_entity_attr_id,
5302: g_per_mixnmatch_enabled, g_per_selected_datasources);
5303: -- END IF;
5304:
5304:
5305: -- Get old records. Will be used by business event system.
5306: get_person_rec (
5307: p_party_id => l_person_rec.party_rec.party_id,
5308: p_content_source_type => HZ_MIXNM_UTILITY.FindDataSource(
5309: p_content_source_type => l_person_rec.content_source_type,
5310: p_actual_content_source => l_person_rec.actual_content_source,
5311: p_def_actual_content_source => G_SST_SOURCE_TYPE,
5312: x_data_source_from => l_data_source_from ),
6236:
6237: -- cache if mix-n-match is enabled
6238:
6239: -- IF g_org_mixnmatch_enabled IS NULL THEN
6240: HZ_MIXNM_UTILITY.LoadDataSources(
6241: 'HZ_ORGANIZATION_PROFILES', g_org_entity_attr_id,
6242: g_org_mixnmatch_enabled, g_org_selected_datasources);
6243: -- END IF;
6244:
6663:
6664: -- cache if mix-n-match is enabled
6665:
6666: -- IF g_org_mixnmatch_enabled IS NULL THEN
6667: HZ_MIXNM_UTILITY.LoadDataSources(
6668: 'HZ_ORGANIZATION_PROFILES', g_org_entity_attr_id,
6669: g_org_mixnmatch_enabled, g_org_selected_datasources);
6670: -- END IF;
6671:
6671:
6672: -- Get old records. Will be used by business event system.
6673: get_organization_rec (
6674: p_party_id => l_organization_rec.party_rec.party_id,
6675: p_content_source_type => HZ_MIXNM_UTILITY.FindDataSource(
6676: p_content_source_type => l_organization_rec.content_source_type,
6677: p_actual_content_source => l_organization_rec.actual_content_source,
6678: p_def_actual_content_source => G_SST_SOURCE_TYPE,
6679: x_data_source_from => l_data_source_from ),