[Home] [Help]
1420: local_activity_code) ';
1421:
1422: l_s5 varchar2(10000) := '
1423: when (all_errors is not null and party_type = ''PERSON'') then
1424: into hz_person_profiles ( -- p1
1425: actual_content_source,
1426: application_id,
1427: content_source_type,
1428: created_by,
1489: :5, -- program_application_id
1490: :6, -- program_id
1491: :3, -- sysdate
1492: :7, -- request_id
1493: hz_person_profiles_s.nextval,
1494: party_id,
1495: person_name,
1496: person_pre_name_adjunct,
1497: person_first_name,
1537: l_s6 varchar2(10000) := '
1538: when (all_errors is not null
1539: and l_content_source_type <> ''USER_ENTERED''
1540: and party_type = ''PERSON'') then
1541: into hz_person_profiles ( -- p2
1542: actual_content_source,
1543: application_id,
1544: content_source_type,
1545: created_by,
1606: :5, -- program_application_id
1607: :6, -- program_id
1608: :3, -- sysdate
1609: :7, -- request_id
1610: hz_person_profiles_s.nextval+1,
1611: party_id,
1612: person_name,
1613: person_pre_name_adjunct,
1614: person_first_name,
1655: when (all_errors is not null
1656: and l_content_source_type <> ''USER_ENTERED''
1657: and party_type = ''PERSON''
1658: and :11 = ''Y'') then
1659: into hz_person_profiles ( -- p2
1660: actual_content_source,
1661: application_id,
1662: content_source_type,
1663: created_by,
1724: :5, -- program_application_id
1725: :6, -- program_id
1726: :3, -- sysdate
1727: :7, -- request_id
1728: hz_person_profiles_s.nextval+2,
1729: party_id,
1730: person_name,
1731: person_pre_name_adjunct,
1732: person_first_name,
3226: ps.party_id,
3227: ps.new_osr_exists_flag,
3228: ps.old_orig_system_reference
3229: FROM HZ_IMP_PARTIES_INT pi, HZ_IMP_PARTIES_SG ps, HZ_PARTIES p,
3230: HZ_PERSON_PROFILES pp,
3231: HZ_ORGANIZATION_PROFILES op,
3232: fnd_lookup_values party_type_l,
3233: fnd_lookup_values month_l,
3234: fnd_lookup_values legal_status_l,
3662: ACTUAL_CONTENT_SOURCE
3663: from hz_organization_profiles where ';
3664:
3665: l_insert_per_profile varchar2(10000) :=
3666: 'insert into hz_person_profiles pp1
3667: (
3668: PERSON_PROFILE_ID,
3669: PARTY_ID,
3670: PERSON_NAME,
3721: DECEASED_FLAG,
3722: CREATED_BY_MODULE
3723: )
3724: select
3725: hz_person_profiles_s.nextval,
3726: PARTY_ID,
3727: decode(:l_person_name, NULL, PERSON_NAME, :G_MISS_CHAR, PERSON_NAME,
3728: :l_person_name),
3729: :l_sysdate,
3816: :G_MISS_DATE, ''N'', ''Y''),
3817: :l_deceased_flag),
3818: nvl(CREATED_BY_MODULE, decode(:l_created_by_module, :G_MISS_CHAR, ''HZ_IMPORT'',
3819: NULL, ''HZ_IMPORT'', :l_created_by_module))
3820: from hz_person_profiles where ';
3821:
3822: l_update_org_profile varchar2(10000) :=
3823: 'update hz_organization_profiles op1 set
3824: ORGANIZATION_NAME = DECODE(:l_organization_name,
4068: where ';
4069:
4070:
4071: l_update_per_profile varchar2(10000) :=
4072: 'update hz_person_profiles pp1 set
4073: PERSON_NAME = DECODE(:l_person_name,
4074: NULL, PERSON_NAME,
4075: :G_MISS_CHAR, PERSON_NAME,
4076: :l_person_name),
4534: /******************************/
4535:
4536: /* Loop to handle duplicate party_id or party_number exceptions. Only
4537: needed for hz_parties. When inserting into hz_organization_profiles or
4538: hz_person_profiles, l_num_row_processed is used to determine if an interface
4539: record was inserted successfully, which excludes problem with duplicate
4540: party_id as well. So this problem will not be reported again. Then when
4541: inserting into profiles table, whenever there is any exception, just
4542: exit as it'll be some unknown error not encountered while updating into
5220: p_msg_level=>fnd_log.level_statement);
5221: END IF;
5222:
5223: /********************************************/
5224: /*** Insert into HZ_PERSON_PROFILES ***/
5225: /*** Mix and Match : disabled ***/
5226: /*** Version Profile: NEW_VERSION ***/
5227: /********************************************/
5228:
5286: p_msg_level=>fnd_log.level_statement);
5287: END IF;
5288:
5289: /********************************************/
5290: /*** End date current HZ_PERSON_PROFILES ***/
5291: /*** Mix and Match : disabled ***/
5292: /*** Version Profile: NEW_VERSION ***/
5293: /********************************************/
5294:
5295: -- mixnmatch disabled and version = NEW_VERSION
5296: -- End date current profile and save the profile ids.
5297: -- Then use the profile ids for copying values to new profile
5298: ForAll j in 1..l_party_orig_system_reference.count
5299: update hz_person_profiles pp1 set
5300: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
5301: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
5302: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
5303: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
5423: p_msg_level=>fnd_log.level_statement);
5424: END IF;
5425:
5426: /******************************************/
5427: /*** Update HZ_PERSON_PROFILES ***/
5428: /*** Mix and Match : disabled ***/
5429: /*** Version Profile: NO_VERSION ***/
5430: /******************************************/
5431:
5713:
5714: IF l_per_mixnmatch_enabled = 'N' THEN
5715:
5716: /******************************************/
5717: /*** Update HZ_PERSON_PROFILES ***/
5718: /*** Mix and Match : disabled ***/
5719: /*** Version Profile: ONE_DAY_VERSION ***/
5720: /******************************************/
5721:
5785:
5786:
5787:
5788: /******************************************/
5789: /*** Insert into HZ_PERSON_PROFILES ***/
5790: /*** Mix and Match : disabled ***/
5791: /*** Version Profile: ONE_DAY_VERSION ***/
5792: /******************************************/
5793:
5851: l_content_source_type, l_actual_content_source;
5852:
5853:
5854: /******************************************/
5855: /*** End date HZ_PERSON_PROFILES ***/
5856: /*** Mix and Match : disabled ***/
5857: /*** Version Profile: ONE_DAY_VERSION ***/
5858: /******************************************/
5859: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5862: p_msg_level=>fnd_log.level_statement);
5863: END IF;
5864:
5865: ForAll j in 1..l_party_orig_system_reference.count
5866: update hz_person_profiles pp1 set
5867: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
5868: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
5869: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
5870: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
6137: IF l_per_mixnmatch_enabled = 'N' AND
6138: l_content_source_type <> 'USER_ENTERED' THEN
6139:
6140: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6141: hz_utility_v2pub.debug(p_message=>'Insert into hz_person_profiles',
6142: p_prefix =>l_debug_prefix,
6143: p_msg_level=>fnd_log.level_statement);
6144: END IF;
6145:
6143: p_msg_level=>fnd_log.level_statement);
6144: END IF;
6145:
6146: ForAll j in 1..l_party_orig_system_reference.count
6147: insert into hz_person_profiles
6148: (
6149: PERSON_PROFILE_ID,
6150: PARTY_ID,
6151: PERSON_NAME,
6202: DECEASED_FLAG,
6203: CREATED_BY_MODULE
6204: )
6205: select
6206: hz_person_profiles_s.nextval,
6207: l_party_id(j),
6208: nvl(l_person_name(j), l_party_name(j)),
6209: P_DML_RECORD.SYSDATE,
6210: P_DML_RECORD.USER_ID,
6298: from dual
6299: where
6300: l_num_row_processed(j) = 1
6301: and l_party_type(j) = 'PERSON'
6302: and not exists (select 1 from hz_person_profiles pp2 -- Bug 6398209
6303: where pp2.content_source_type = l_content_source_type
6304: and pp2.actual_content_source = l_actual_content_source
6305: and pp2.party_id = l_party_id(j));
6306: END IF; -- l_per_mixnmatch_enabled = 'N' AND l_content_source_type <> 'USER_ENTERED'
6470: p_msg_level=>fnd_log.level_statement);
6471: END IF;
6472:
6473: /********************************************/
6474: /*** Insert into HZ_PERSON_PROFILES ***/
6475: /*** Mix and Match : enabled ***/
6476: /*** Orig system : USER_ENTERED ***/
6477: /*** Has no DNB data ***/
6478: /*** Version Profile: NEW_VERSION ***/
6486: and :l_num_row_processed = 1
6487: and :l_party_type = ''PERSON''
6488: and CONTENT_SOURCE_TYPE = ''USER_ENTERED''
6489: and ACTUAL_CONTENT_SOURCE = ''SST''
6490: and not exists (select 1 from hz_person_profiles pp2
6491: where pp2.content_source_type = ''USER_ENTERED''
6492: and pp2.actual_content_source = ''USER_ENTERED''
6493: and :party_id = pp2.party_id)'
6494: USING
6539: p_msg_level=>fnd_log.level_statement);
6540: END IF;
6541:
6542: /********************************************/
6543: /*** End date current HZ_PERSON_PROFILES ***/
6544: /*** Mix and Match : enabled ***/
6545: /*** Orig system : USER_ENTERED ***/
6546: /*** Has no DNB data ***/
6547: /*** Version Profile: NEW_VERSION ***/
6547: /*** Version Profile: NEW_VERSION ***/
6548: /********************************************/
6549:
6550: ForAll j in 1..l_party_orig_system_reference.count
6551: update hz_person_profiles pp1 set
6552: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
6553: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
6554: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
6555: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
6566: and l_num_row_processed(j) = 1
6567: and l_party_type(j) = 'PERSON'
6568: and CONTENT_SOURCE_TYPE = 'USER_ENTERED'
6569: and ACTUAL_CONTENT_SOURCE = 'SST'
6570: and not exists (select 1 from hz_person_profiles pp2
6571: where pp2.content_source_type = 'USER_ENTERED'
6572: and pp2.actual_content_source = 'USER_ENTERED'
6573: and pp1.party_id = pp2.party_id)
6574: and nvl(request_id, -1) <> P_DML_RECORD.REQUEST_ID;
6718: p_msg_level=>fnd_log.level_statement);
6719: END IF;
6720:
6721: /********************************************/
6722: /*** Insert into HZ_PERSON_PROFILES ***/
6723: /*** Mix and Match : enabled ***/
6724: /*** Orig system : USER_ENTERED ***/
6725: /*** Has DNB data ***/
6726: /*** Version Profile: NEW_VERSION ***/
6783: p_msg_level=>fnd_log.level_statement);
6784: END IF;
6785:
6786: /********************************************/
6787: /*** End date current HZ_PERSON_PROFILES ***/
6788: /*** Mix and Match : enabled ***/
6789: /*** Orig system : USER_ENTERED ***/
6790: /*** Has DNB data ***/
6791: /*** Version Profile: NEW_VERSION ***/
6791: /*** Version Profile: NEW_VERSION ***/
6792: /********************************************/
6793:
6794: ForAll j in 1..l_party_orig_system_reference.count
6795: update hz_person_profiles pp1 set
6796: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
6797: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
6798: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
6799: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
6927: p_msg_level=>fnd_log.level_statement);
6928: END IF;
6929:
6930: /******************************************/
6931: /*** Update HZ_PERSON_PROFILES ***/
6932: /*** Mix and Match : enabled ***/
6933: /*** Orig system : USER_ENTERED ***/
6934: /*** Has no DNB data ***/
6935: /*** Version Profile: NO_VERSION ***/
6943: and :l_num_row_processed = 1
6944: and :l_party_type = ''PERSON''
6945: and CONTENT_SOURCE_TYPE = ''USER_ENTERED''
6946: and ACTUAL_CONTENT_SOURCE = ''SST''
6947: and not exists (select 1 from hz_person_profiles pp2
6948: where pp2.content_source_type = ''USER_ENTERED''
6949: and pp2.actual_content_source = ''USER_ENTERED''
6950: and pp1.party_id = pp2.party_id)'
6951: USING
7090: p_msg_level=>fnd_log.level_statement);
7091: END IF;
7092:
7093: /******************************************/
7094: /*** Update HZ_PERSON_PROFILES ***/
7095: /*** Mix and Match : enabled ***/
7096: /*** Orig system : USER_ENTERED ***/
7097: /*** Has DNB data ***/
7098: /*** Version Profile: NO_VERSION ***/
7399:
7400: IF l_per_mixnmatch_enabled = 'Y' THEN
7401:
7402: /*****************************************/
7403: /*** Update HZ_PERSON_PROFILES ***/
7404: /*** Mix and Match : enabled ***/
7405: /*** Orig system : USER_ENTERED ***/
7406: /*** Has no DNB data ***/
7407: /*** Version Profile: ONE_DAY_VERSION ***/
7422: and trunc(EFFECTIVE_START_DATE) = :l_sysdate
7423: and :l_party_type = ''PERSON''
7424: and CONTENT_SOURCE_TYPE = ''USER_ENTERED''
7425: and ACTUAL_CONTENT_SOURCE = ''SST''
7426: and not exists (select 1 from hz_person_profiles pp2
7427: where pp2.content_source_type = ''USER_ENTERED''
7428: and pp2.actual_content_source = ''USER_ENTERED''
7429: and :l_party_id = pp2.party_id)'
7430: USING
7469: l_party_id(j), l_num_row_processed(j), trunc(P_DML_RECORD.SYSDATE), l_party_type(j), l_party_id(j);
7470:
7471:
7472: /*****************************************/
7473: /*** Insert into HZ_PERSON_PROFILES ***/
7474: /*** Mix and Match : enabled ***/
7475: /*** Orig system : USER_ENTERED ***/
7476: /*** Has no DNB data ***/
7477: /*** Version Profile: ONE_DAY_VERSION ***/
7492: and :l_party_type = ''PERSON''
7493: and trunc(EFFECTIVE_START_DATE) < :l_sysdate
7494: and CONTENT_SOURCE_TYPE = ''USER_ENTERED''
7495: and ACTUAL_CONTENT_SOURCE = ''SST''
7496: and not exists (select 1 from hz_person_profiles pp2
7497: where pp2.content_source_type = ''USER_ENTERED''
7498: and pp2.actual_content_source = ''USER_ENTERED''
7499: and :l_party_id = pp2.party_id)'
7500: USING
7540: l_party_id(j), l_num_row_processed(j), l_party_type(j), trunc(P_DML_RECORD.SYSDATE), l_party_id(j);
7541:
7542:
7543: /*****************************************/
7544: /*** End date HZ_PERSON_PROFILES ***/
7545: /*** Mix and Match : enabled ***/
7546: /*** Orig system : USER_ENTERED ***/
7547: /*** Has no DNB data ***/
7548: /*** Version Profile: ONE_DAY_VERSION ***/
7553: p_msg_level=>fnd_log.level_statement);
7554: END IF;
7555:
7556: ForAll j in 1..l_party_orig_system_reference.count
7557: update hz_person_profiles pp1 set
7558: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
7559: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
7560: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
7561: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
7572: and trunc(EFFECTIVE_START_DATE) < trunc(P_DML_RECORD.SYSDATE)
7573: and l_party_type(j) = 'PERSON'
7574: and CONTENT_SOURCE_TYPE = 'USER_ENTERED'
7575: and ACTUAL_CONTENT_SOURCE = 'SST'
7576: and not exists (select 1 from hz_person_profiles pp2
7577: where pp2.content_source_type = 'USER_ENTERED'
7578: and pp2.actual_content_source = 'USER_ENTERED'
7579: and pp1.party_id = pp2.party_id)
7580: and nvl(request_id, -1) <> P_DML_RECORD.REQUEST_ID;
7813:
7814: IF l_per_mixnmatch_enabled = 'Y' THEN
7815:
7816: /*****************************************/
7817: /*** Update HZ_PERSON_PROFILES ***/
7818: /*** Mix and Match : enabled ***/
7819: /*** Orig system : USER_ENTERED ***/
7820: /*** Has DNB data ***/
7821: /*** Version Profile: ONE_DAY_VERSION ***/
7879: l_party_id(j), l_num_row_processed(j), trunc(P_DML_RECORD.SYSDATE), l_party_type(j);
7880:
7881:
7882: /*****************************************/
7883: /*** Insert into HZ_PERSON_PROFILES ***/
7884: /*** Mix and Match : enabled ***/
7885: /*** Orig system : USER_ENTERED ***/
7886: /*** Has DNB data ***/
7887: /*** Version Profile: ONE_DAY_VERSION ***/
7945: l_party_id(j), l_num_row_processed(j), l_party_type(j), trunc(P_DML_RECORD.SYSDATE);
7946:
7947:
7948: /*****************************************/
7949: /*** End date HZ_PERSON_PROFILES ***/
7950: /*** Mix and Match : enabled ***/
7951: /*** Orig system : USER_ENTERED ***/
7952: /*** Has DNB data ***/
7953: /*** Version Profile: ONE_DAY_VERSION ***/
7959: p_msg_level=>fnd_log.level_statement);
7960: END IF;
7961:
7962: ForAll j in 1..l_party_orig_system_reference.count
7963: update hz_person_profiles pp1 set
7964: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
7965: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
7966: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
7967: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
8123:
8124: IF l_per_mixnmatch_enabled = 'Y' THEN
8125:
8126: /******************************************/
8127: /*** Insert into HZ_PERSON_PROFILES ***/
8128: /*** Mix and Match : enabled ***/
8129: /*** Version Profile: NEW_VERSION ***/
8130: /*** Orig system : 3rd Party ***/
8131: /*** With existing 3rd party data ***/
8189: l_content_source_type, l_actual_content_source;
8190:
8191:
8192: /********************************************/
8193: /*** End date current HZ_PERSON_PROFILES ***/
8194: /*** Mix and Match : enabled ***/
8195: /*** Version Profile: NEW_VERSION ***/
8196: /*** Orig system : 3rd Party ***/
8197: /*** With existing 3rd party data ***/
8202: p_msg_level=>fnd_log.level_statement);
8203: END IF;
8204:
8205: ForAll j in 1..l_party_orig_system_reference.count
8206: update hz_person_profiles pp1 set
8207: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
8208: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
8209: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
8210: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
8327:
8328: IF l_per_mixnmatch_enabled = 'Y' THEN
8329:
8330: /******************************************/
8331: /*** Update HZ_PERSON_PROFILES ***/
8332: /*** Mix and Match : enabled ***/
8333: /*** Version Profile: NO_VERSION ***/
8334: /*** Orig system : 3rd Party ***/
8335: /*** With existing 3rd party data ***/
8620:
8621: IF l_per_mixnmatch_enabled = 'Y' THEN
8622:
8623: /******************************************/
8624: /*** Update HZ_PERSON_PROFILES ***/
8625: /*** Mix and Match : enabled ***/
8626: /*** Version Profile: ONE_DAY_VERSION ***/
8627: /*** Orig system : 3rd Party ***/
8628: /*** With existing 3rd party data ***/
8686: l_content_source_type, l_actual_content_source;
8687:
8688:
8689: /******************************************/
8690: /*** Insert into HZ_PERSON_PROFILES ***/
8691: /*** Mix and Match : enabled ***/
8692: /*** Version Profile: ONE_DAY_VERSION ***/
8693: /*** Orig system : 3rd Party ***/
8694: /*** With existing 3rd party data ***/
8753: l_content_source_type, l_actual_content_source;
8754:
8755:
8756: /******************************************/
8757: /*** End date HZ_PERSON_PROFILES ***/
8758: /*** Mix and Match : enabled ***/
8759: /*** Version Profile: ONE_DAY_VERSION ***/
8760: /*** Orig system : 3rd Party ***/
8761: /*** With existing 3rd party data ***/
8766: p_msg_level=>fnd_log.level_statement);
8767: END IF;
8768:
8769: ForAll j in 1..l_party_orig_system_reference.count
8770: update hz_person_profiles pp1 set
8771: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
8772: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
8773: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
8774: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
9048:
9049: IF l_per_mixnmatch_enabled = 'Y' THEN
9050:
9051: /******************************************/
9052: /*** Insert into HZ_PERSON_PROFILES ***/
9053: /*** Mix and Match : enabled ***/
9054: /*** Orig system : 3rd Party ***/
9055: /*** Without existing 3rd party data ***/
9056: /******************************************/
9054: /*** Orig system : 3rd Party ***/
9055: /*** Without existing 3rd party data ***/
9056: /******************************************/
9057: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
9058: hz_utility_v2pub.debug(p_message=>'Insert into hz_person_profiles',
9059: p_prefix =>l_debug_prefix,
9060: p_msg_level=>fnd_log.level_statement);
9061: END IF;
9062:
9060: p_msg_level=>fnd_log.level_statement);
9061: END IF;
9062:
9063: ForAll j in 1..l_party_orig_system_reference.count
9064: insert into hz_person_profiles
9065: (
9066: PERSON_PROFILE_ID,
9067: PARTY_ID,
9068: PERSON_NAME,
9119: DECEASED_FLAG,
9120: CREATED_BY_MODULE
9121: )
9122: select
9123: hz_person_profiles_s.nextval,
9124: l_party_id(j),
9125: nvl(l_person_name(j), l_party_name(j)),
9126: P_DML_RECORD.SYSDATE,
9127: P_DML_RECORD.USER_ID,
9215: from dual
9216: where
9217: l_num_row_processed(j) = 1
9218: and l_party_type(j) = 'PERSON'
9219: and not exists (select 1 from hz_person_profiles pp2
9220: where pp2.content_source_type = l_content_source_type
9221: and pp2.actual_content_source = l_actual_content_source
9222: and pp2.party_id = l_party_id(j)
9223: and pp2.effective_end_date is null);
9529: --Initialize API return status to success.
9530: x_return_status := FND_API.G_RET_STS_SUCCESS;
9531:
9532: l_org_mixnmatch_enabled := HZ_MIXNM_UTILITY.isMixNMatchEnabled('HZ_ORGANIZATION_PROFILES',l_entity_attr_id);
9533: l_per_mixnmatch_enabled := HZ_MIXNM_UTILITY.isMixNMatchEnabled('HZ_PERSON_PROFILES',l_entity_attr_id);
9534:
9535: l_content_source_type := P_DML_RECORD.ACTUAL_CONTENT_SRC;
9536: IF l_content_source_type = 'USER_ENTERED' THEN
9537: l_actual_content_source := 'SST';