[Home] [Help]
3654: * to the position of the decimal point, replace this with
3655: * the correct value from fnd_lookup_values provided that the
3656: * actual_content_source for this record is not 'USER_ENTERED'.
3657: * 31-DEC-2004 Rajib Ranjan Borah o SSM SST Integration and Extension.
3658: * Call HZ_MIXNM_UTILITY.create_exceptions if actual_content_source
3659: * is some third party content source and no prior profile exists..
3660: * 10-DEC-2011 Sudhir Gokavarapu o Bug 13117445 Modified do_create_party_profile calls by adding
3661: * new parameter p_party_create_update_flag.
3662: *
3721:
3722: -- Find the real data source
3723:
3724: l_data_source_type :=
3725: HZ_MIXNM_UTILITY.FindDataSource (
3726: p_content_source_type => p_person_rec.content_source_type,
3727: p_actual_content_source => p_person_rec.actual_content_source,
3728: p_def_actual_content_source => G_SST_SOURCE_TYPE,
3729: x_data_source_from => l_data_source_from );
3773:
3774: -- Find the real data source
3775:
3776: l_data_source_type :=
3777: HZ_MIXNM_UTILITY.FindDataSource(
3778: p_content_source_type => p_organization_rec.content_source_type,
3779: p_actual_content_source => p_organization_rec.actual_content_source,
3780: p_def_actual_content_source => G_SST_SOURCE_TYPE,
3781: x_data_source_from => l_data_source_from );
3904: x_profile_id => x_profile_id,
3905: p_party_create_update_flag => l_party_create_update_flag );
3906: /* Bug 4244112 : do not populate for just UE record
3907: IF l_mixnmatch_enabled = 'Y' THEN
3908: HZ_MIXNM_UTILITY.populateMRRExc(
3909: 'HZ_'||p_party_type||'_PROFILES',
3910: l_content_source_type,
3911: x_party_id);
3912: END IF;
3916: -- find if data source is selected
3917:
3918: IF l_mixnmatch_enabled = 'Y' THEN
3919: l_datasource_selected :=
3920: HZ_MIXNM_UTILITY.isDataSourceSelected(
3921: -- Bug 4376604 : pass entity type
3922: p_party_type,
3923: l_data_source_type);
3924: END IF;
4040: x_profile_id => l_profile_id,
4041: p_party_create_update_flag => l_party_create_update_flag );
4042:
4043: -- SSM SST Integration and Extension
4044: HZ_MIXNM_UTILITY.create_exceptions (
4045: p_party_type => p_party_type,
4046: p_organization_rec => p_organization_rec,
4047: p_person_rec => p_person_rec,
4048: p_third_party_content_source => l_data_source_type,
4047: p_person_rec => p_person_rec,
4048: p_third_party_content_source => l_data_source_type,
4049: p_party_id => x_party_id);
4050:
4051: HZ_MIXNM_UTILITY.populateMRRExc(
4052: 'HZ_'||p_party_type||'_PROFILES',
4053: l_data_source_type,
4054: x_party_id);
4055: ELSE -- need to generate SST profile.
4072: l_create_update_sst_flag := 'C';
4073: l_new_sst_person_rec := l_sst_person_rec;
4074: l_new_sst_organization_rec := l_sst_organization_rec;
4075: -- Bug 4244112 : populate when first third party profile is created
4076: HZ_MIXNM_UTILITY.populateMRRExc(
4077: 'HZ_'||p_party_type||'_PROFILES',
4078: l_data_source_type,
4079: x_party_id);
4080: ELSE
4090: IF l_datasource_selected = 'Y' THEN
4091: -- return SST record which we need to use either
4092: -- generate a SST profile or update an existing SST profile.
4093:
4094: HZ_MIXNM_UTILITY.updateSSTProfile(
4095: p_create_update_flag => 'C',
4096: p_create_update_sst_flag => l_create_update_sst_flag,
4097: p_raise_error_flag => 'N',
4098: p_party_type => p_party_type,
4644: -- if we need to propagate the change to SST profile,
4645: -- and the party.
4646:
4647: l_datasource_selected :=
4648: HZ_MIXNM_UTILITY.isDataSourceSelected(
4649: -- Bug 4376604 : pass entity type
4650: p_party_type,
4651: l_data_source_type);
4652:
4678:
4679: -- return SST record which we need to use to update an existing
4680: -- SST profile.
4681:
4682: HZ_MIXNM_UTILITY.updateSSTProfile (
4683: p_create_update_flag => 'U',
4684: p_create_update_sst_flag => 'U',
4685: p_raise_error_flag => l_raise_error,
4686: p_party_type => p_party_type,
4969:
4970: -- cache if mix-n-match is enabled
4971:
4972: -- IF g_per_mixnmatch_enabled IS NULL THEN
4973: HZ_MIXNM_UTILITY.LoadDataSources(
4974: 'HZ_PERSON_PROFILES', g_per_entity_attr_id,
4975: g_per_mixnmatch_enabled, g_per_selected_datasources);
4976: -- END IF;
4977:
5367: END IF;
5368: -- cache if mix-n-match is enabled
5369:
5370: -- IF g_per_mixnmatch_enabled IS NULL THEN
5371: HZ_MIXNM_UTILITY.LoadDataSources(
5372: 'HZ_PERSON_PROFILES', g_per_entity_attr_id,
5373: g_per_mixnmatch_enabled, g_per_selected_datasources);
5374: -- END IF;
5375:
5375:
5376: -- Get old records. Will be used by business event system.
5377: get_person_rec (
5378: p_party_id => l_person_rec.party_rec.party_id,
5379: p_content_source_type => HZ_MIXNM_UTILITY.FindDataSource(
5380: p_content_source_type => l_person_rec.content_source_type,
5381: p_actual_content_source => l_person_rec.actual_content_source,
5382: p_def_actual_content_source => G_SST_SOURCE_TYPE,
5383: x_data_source_from => l_data_source_from ),
6307:
6308: -- cache if mix-n-match is enabled
6309:
6310: -- IF g_org_mixnmatch_enabled IS NULL THEN
6311: HZ_MIXNM_UTILITY.LoadDataSources(
6312: 'HZ_ORGANIZATION_PROFILES', g_org_entity_attr_id,
6313: g_org_mixnmatch_enabled, g_org_selected_datasources);
6314: -- END IF;
6315:
6744:
6745: -- cache if mix-n-match is enabled
6746:
6747: -- IF g_org_mixnmatch_enabled IS NULL THEN
6748: HZ_MIXNM_UTILITY.LoadDataSources(
6749: 'HZ_ORGANIZATION_PROFILES', g_org_entity_attr_id,
6750: g_org_mixnmatch_enabled, g_org_selected_datasources);
6751: -- END IF;
6752:
6752:
6753: -- Get old records. Will be used by business event system.
6754: get_organization_rec (
6755: p_party_id => l_organization_rec.party_rec.party_id,
6756: p_content_source_type => HZ_MIXNM_UTILITY.FindDataSource(
6757: p_content_source_type => l_organization_rec.content_source_type,
6758: p_actual_content_source => l_organization_rec.actual_content_source,
6759: p_def_actual_content_source => G_SST_SOURCE_TYPE,
6760: x_data_source_from => l_data_source_from ),