[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,
3232: ps.party_id,
3233: ps.new_osr_exists_flag,
3234: ps.old_orig_system_reference
3235: FROM HZ_IMP_PARTIES_INT pi, HZ_IMP_PARTIES_SG ps, HZ_PARTIES p,
3236: HZ_PERSON_PROFILES pp,
3237: HZ_ORGANIZATION_PROFILES op,
3238: fnd_lookup_values party_type_l,
3239: fnd_lookup_values month_l,
3240: fnd_lookup_values legal_status_l,
3668: ACTUAL_CONTENT_SOURCE
3669: from hz_organization_profiles where ';
3670:
3671: l_insert_per_profile varchar2(10000) :=
3672: 'insert into hz_person_profiles pp1
3673: (
3674: PERSON_PROFILE_ID,
3675: PARTY_ID,
3676: PERSON_NAME,
3727: DECEASED_FLAG,
3728: CREATED_BY_MODULE
3729: )
3730: select
3731: hz_person_profiles_s.nextval,
3732: PARTY_ID,
3733: decode(:l_person_name, NULL, PERSON_NAME, :G_MISS_CHAR, PERSON_NAME,
3734: :l_person_name),
3735: :l_sysdate,
3822: :G_MISS_DATE, ''N'', ''Y''),
3823: :l_deceased_flag),
3824: nvl(CREATED_BY_MODULE, decode(:l_created_by_module, :G_MISS_CHAR, ''HZ_IMPORT'',
3825: NULL, ''HZ_IMPORT'', :l_created_by_module))
3826: from hz_person_profiles where ';
3827:
3828: l_update_org_profile varchar2(10000) :=
3829: 'update hz_organization_profiles op1 set
3830: ORGANIZATION_NAME = DECODE(:l_organization_name,
4074: where ';
4075:
4076:
4077: l_update_per_profile varchar2(10000) :=
4078: 'update hz_person_profiles pp1 set
4079: PERSON_NAME = DECODE(:l_person_name,
4080: NULL, PERSON_NAME,
4081: :G_MISS_CHAR, PERSON_NAME,
4082: :l_person_name),
4552: /******************************/
4553:
4554: /* Loop to handle duplicate party_id or party_number exceptions. Only
4555: needed for hz_parties. When inserting into hz_organization_profiles or
4556: hz_person_profiles, l_num_row_processed is used to determine if an interface
4557: record was inserted successfully, which excludes problem with duplicate
4558: party_id as well. So this problem will not be reported again. Then when
4559: inserting into profiles table, whenever there is any exception, just
4560: exit as it'll be some unknown error not encountered while updating into
5238: p_msg_level=>fnd_log.level_statement);
5239: END IF;
5240:
5241: /********************************************/
5242: /*** Insert into HZ_PERSON_PROFILES ***/
5243: /*** Mix and Match : disabled ***/
5244: /*** Version Profile: NEW_VERSION ***/
5245: /********************************************/
5246:
5304: p_msg_level=>fnd_log.level_statement);
5305: END IF;
5306:
5307: /********************************************/
5308: /*** End date current HZ_PERSON_PROFILES ***/
5309: /*** Mix and Match : disabled ***/
5310: /*** Version Profile: NEW_VERSION ***/
5311: /********************************************/
5312:
5313: -- mixnmatch disabled and version = NEW_VERSION
5314: -- End date current profile and save the profile ids.
5315: -- Then use the profile ids for copying values to new profile
5316: ForAll j in 1..l_party_orig_system_reference.count
5317: update hz_person_profiles pp1 set
5318: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
5319: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
5320: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
5321: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
5441: p_msg_level=>fnd_log.level_statement);
5442: END IF;
5443:
5444: /******************************************/
5445: /*** Update HZ_PERSON_PROFILES ***/
5446: /*** Mix and Match : disabled ***/
5447: /*** Version Profile: NO_VERSION ***/
5448: /******************************************/
5449:
5731:
5732: IF l_per_mixnmatch_enabled = 'N' THEN
5733:
5734: /******************************************/
5735: /*** Update HZ_PERSON_PROFILES ***/
5736: /*** Mix and Match : disabled ***/
5737: /*** Version Profile: ONE_DAY_VERSION ***/
5738: /******************************************/
5739:
5803:
5804:
5805:
5806: /******************************************/
5807: /*** Insert into HZ_PERSON_PROFILES ***/
5808: /*** Mix and Match : disabled ***/
5809: /*** Version Profile: ONE_DAY_VERSION ***/
5810: /******************************************/
5811:
5869: l_content_source_type, l_actual_content_source;
5870:
5871:
5872: /******************************************/
5873: /*** End date HZ_PERSON_PROFILES ***/
5874: /*** Mix and Match : disabled ***/
5875: /*** Version Profile: ONE_DAY_VERSION ***/
5876: /******************************************/
5877: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5880: p_msg_level=>fnd_log.level_statement);
5881: END IF;
5882:
5883: ForAll j in 1..l_party_orig_system_reference.count
5884: update hz_person_profiles pp1 set
5885: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
5886: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
5887: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
5888: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
6155: IF l_per_mixnmatch_enabled = 'N' AND
6156: l_content_source_type <> 'USER_ENTERED' THEN
6157:
6158: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6159: hz_utility_v2pub.debug(p_message=>'Insert into hz_person_profiles',
6160: p_prefix =>l_debug_prefix,
6161: p_msg_level=>fnd_log.level_statement);
6162: END IF;
6163:
6161: p_msg_level=>fnd_log.level_statement);
6162: END IF;
6163:
6164: ForAll j in 1..l_party_orig_system_reference.count
6165: insert into hz_person_profiles
6166: (
6167: PERSON_PROFILE_ID,
6168: PARTY_ID,
6169: PERSON_NAME,
6220: DECEASED_FLAG,
6221: CREATED_BY_MODULE
6222: )
6223: select
6224: hz_person_profiles_s.nextval,
6225: l_party_id(j),
6226: nvl(l_person_name(j), l_party_name(j)),
6227: P_DML_RECORD.SYSDATE,
6228: P_DML_RECORD.USER_ID,
6316: from dual
6317: where
6318: l_num_row_processed(j) = 1
6319: and l_party_type(j) = 'PERSON'
6320: and not exists (select 1 from hz_person_profiles pp2 -- Bug 6398209
6321: where pp2.content_source_type = l_content_source_type
6322: and pp2.actual_content_source = l_actual_content_source
6323: and pp2.party_id = l_party_id(j));
6324: END IF; -- l_per_mixnmatch_enabled = 'N' AND l_content_source_type <> 'USER_ENTERED'
6488: p_msg_level=>fnd_log.level_statement);
6489: END IF;
6490:
6491: /********************************************/
6492: /*** Insert into HZ_PERSON_PROFILES ***/
6493: /*** Mix and Match : enabled ***/
6494: /*** Orig system : USER_ENTERED ***/
6495: /*** Has no DNB data ***/
6496: /*** Version Profile: NEW_VERSION ***/
6504: and :l_num_row_processed = 1
6505: and :l_party_type = ''PERSON''
6506: and CONTENT_SOURCE_TYPE = ''USER_ENTERED''
6507: and ACTUAL_CONTENT_SOURCE = ''SST''
6508: and not exists (select 1 from hz_person_profiles pp2
6509: where pp2.content_source_type = ''USER_ENTERED''
6510: and pp2.actual_content_source = ''USER_ENTERED''
6511: and :party_id = pp2.party_id)'
6512: USING
6557: p_msg_level=>fnd_log.level_statement);
6558: END IF;
6559:
6560: /********************************************/
6561: /*** End date current HZ_PERSON_PROFILES ***/
6562: /*** Mix and Match : enabled ***/
6563: /*** Orig system : USER_ENTERED ***/
6564: /*** Has no DNB data ***/
6565: /*** Version Profile: NEW_VERSION ***/
6565: /*** Version Profile: NEW_VERSION ***/
6566: /********************************************/
6567:
6568: ForAll j in 1..l_party_orig_system_reference.count
6569: update hz_person_profiles pp1 set
6570: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
6571: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
6572: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
6573: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
6584: and l_num_row_processed(j) = 1
6585: and l_party_type(j) = 'PERSON'
6586: and CONTENT_SOURCE_TYPE = 'USER_ENTERED'
6587: and ACTUAL_CONTENT_SOURCE = 'SST'
6588: and not exists (select 1 from hz_person_profiles pp2
6589: where pp2.content_source_type = 'USER_ENTERED'
6590: and pp2.actual_content_source = 'USER_ENTERED'
6591: and pp1.party_id = pp2.party_id)
6592: and nvl(request_id, -1) <> P_DML_RECORD.REQUEST_ID;
6736: p_msg_level=>fnd_log.level_statement);
6737: END IF;
6738:
6739: /********************************************/
6740: /*** Insert into HZ_PERSON_PROFILES ***/
6741: /*** Mix and Match : enabled ***/
6742: /*** Orig system : USER_ENTERED ***/
6743: /*** Has DNB data ***/
6744: /*** Version Profile: NEW_VERSION ***/
6801: p_msg_level=>fnd_log.level_statement);
6802: END IF;
6803:
6804: /********************************************/
6805: /*** End date current HZ_PERSON_PROFILES ***/
6806: /*** Mix and Match : enabled ***/
6807: /*** Orig system : USER_ENTERED ***/
6808: /*** Has DNB data ***/
6809: /*** Version Profile: NEW_VERSION ***/
6809: /*** Version Profile: NEW_VERSION ***/
6810: /********************************************/
6811:
6812: ForAll j in 1..l_party_orig_system_reference.count
6813: update hz_person_profiles pp1 set
6814: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
6815: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
6816: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
6817: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
6945: p_msg_level=>fnd_log.level_statement);
6946: END IF;
6947:
6948: /******************************************/
6949: /*** Update HZ_PERSON_PROFILES ***/
6950: /*** Mix and Match : enabled ***/
6951: /*** Orig system : USER_ENTERED ***/
6952: /*** Has no DNB data ***/
6953: /*** Version Profile: NO_VERSION ***/
6961: and :l_num_row_processed = 1
6962: and :l_party_type = ''PERSON''
6963: and CONTENT_SOURCE_TYPE = ''USER_ENTERED''
6964: and ACTUAL_CONTENT_SOURCE = ''SST''
6965: and not exists (select 1 from hz_person_profiles pp2
6966: where pp2.content_source_type = ''USER_ENTERED''
6967: and pp2.actual_content_source = ''USER_ENTERED''
6968: and pp1.party_id = pp2.party_id)'
6969: USING
7108: p_msg_level=>fnd_log.level_statement);
7109: END IF;
7110:
7111: /******************************************/
7112: /*** Update HZ_PERSON_PROFILES ***/
7113: /*** Mix and Match : enabled ***/
7114: /*** Orig system : USER_ENTERED ***/
7115: /*** Has DNB data ***/
7116: /*** Version Profile: NO_VERSION ***/
7417:
7418: IF l_per_mixnmatch_enabled = 'Y' THEN
7419:
7420: /*****************************************/
7421: /*** Update HZ_PERSON_PROFILES ***/
7422: /*** Mix and Match : enabled ***/
7423: /*** Orig system : USER_ENTERED ***/
7424: /*** Has no DNB data ***/
7425: /*** Version Profile: ONE_DAY_VERSION ***/
7440: and trunc(EFFECTIVE_START_DATE) = :l_sysdate
7441: and :l_party_type = ''PERSON''
7442: and CONTENT_SOURCE_TYPE = ''USER_ENTERED''
7443: and ACTUAL_CONTENT_SOURCE = ''SST''
7444: and not exists (select 1 from hz_person_profiles pp2
7445: where pp2.content_source_type = ''USER_ENTERED''
7446: and pp2.actual_content_source = ''USER_ENTERED''
7447: and :l_party_id = pp2.party_id)'
7448: USING
7487: l_party_id(j), l_num_row_processed(j), trunc(P_DML_RECORD.SYSDATE), l_party_type(j), l_party_id(j);
7488:
7489:
7490: /*****************************************/
7491: /*** Insert into HZ_PERSON_PROFILES ***/
7492: /*** Mix and Match : enabled ***/
7493: /*** Orig system : USER_ENTERED ***/
7494: /*** Has no DNB data ***/
7495: /*** Version Profile: ONE_DAY_VERSION ***/
7510: and :l_party_type = ''PERSON''
7511: and trunc(EFFECTIVE_START_DATE) < :l_sysdate
7512: and CONTENT_SOURCE_TYPE = ''USER_ENTERED''
7513: and ACTUAL_CONTENT_SOURCE = ''SST''
7514: and not exists (select 1 from hz_person_profiles pp2
7515: where pp2.content_source_type = ''USER_ENTERED''
7516: and pp2.actual_content_source = ''USER_ENTERED''
7517: and :l_party_id = pp2.party_id)'
7518: USING
7558: l_party_id(j), l_num_row_processed(j), l_party_type(j), trunc(P_DML_RECORD.SYSDATE), l_party_id(j);
7559:
7560:
7561: /*****************************************/
7562: /*** End date HZ_PERSON_PROFILES ***/
7563: /*** Mix and Match : enabled ***/
7564: /*** Orig system : USER_ENTERED ***/
7565: /*** Has no DNB data ***/
7566: /*** Version Profile: ONE_DAY_VERSION ***/
7571: p_msg_level=>fnd_log.level_statement);
7572: END IF;
7573:
7574: ForAll j in 1..l_party_orig_system_reference.count
7575: update hz_person_profiles pp1 set
7576: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
7577: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
7578: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
7579: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
7590: and trunc(EFFECTIVE_START_DATE) < trunc(P_DML_RECORD.SYSDATE)
7591: and l_party_type(j) = 'PERSON'
7592: and CONTENT_SOURCE_TYPE = 'USER_ENTERED'
7593: and ACTUAL_CONTENT_SOURCE = 'SST'
7594: and not exists (select 1 from hz_person_profiles pp2
7595: where pp2.content_source_type = 'USER_ENTERED'
7596: and pp2.actual_content_source = 'USER_ENTERED'
7597: and pp1.party_id = pp2.party_id)
7598: and nvl(request_id, -1) <> P_DML_RECORD.REQUEST_ID;
7831:
7832: IF l_per_mixnmatch_enabled = 'Y' THEN
7833:
7834: /*****************************************/
7835: /*** Update HZ_PERSON_PROFILES ***/
7836: /*** Mix and Match : enabled ***/
7837: /*** Orig system : USER_ENTERED ***/
7838: /*** Has DNB data ***/
7839: /*** Version Profile: ONE_DAY_VERSION ***/
7897: l_party_id(j), l_num_row_processed(j), trunc(P_DML_RECORD.SYSDATE), l_party_type(j);
7898:
7899:
7900: /*****************************************/
7901: /*** Insert into HZ_PERSON_PROFILES ***/
7902: /*** Mix and Match : enabled ***/
7903: /*** Orig system : USER_ENTERED ***/
7904: /*** Has DNB data ***/
7905: /*** Version Profile: ONE_DAY_VERSION ***/
7963: l_party_id(j), l_num_row_processed(j), l_party_type(j), trunc(P_DML_RECORD.SYSDATE);
7964:
7965:
7966: /*****************************************/
7967: /*** End date HZ_PERSON_PROFILES ***/
7968: /*** Mix and Match : enabled ***/
7969: /*** Orig system : USER_ENTERED ***/
7970: /*** Has DNB data ***/
7971: /*** Version Profile: ONE_DAY_VERSION ***/
7977: p_msg_level=>fnd_log.level_statement);
7978: END IF;
7979:
7980: ForAll j in 1..l_party_orig_system_reference.count
7981: update hz_person_profiles pp1 set
7982: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
7983: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
7984: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
7985: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
8141:
8142: IF l_per_mixnmatch_enabled = 'Y' THEN
8143:
8144: /******************************************/
8145: /*** Insert into HZ_PERSON_PROFILES ***/
8146: /*** Mix and Match : enabled ***/
8147: /*** Version Profile: NEW_VERSION ***/
8148: /*** Orig system : 3rd Party ***/
8149: /*** With existing 3rd party data ***/
8207: l_content_source_type, l_actual_content_source;
8208:
8209:
8210: /********************************************/
8211: /*** End date current HZ_PERSON_PROFILES ***/
8212: /*** Mix and Match : enabled ***/
8213: /*** Version Profile: NEW_VERSION ***/
8214: /*** Orig system : 3rd Party ***/
8215: /*** With existing 3rd party data ***/
8220: p_msg_level=>fnd_log.level_statement);
8221: END IF;
8222:
8223: ForAll j in 1..l_party_orig_system_reference.count
8224: update hz_person_profiles pp1 set
8225: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
8226: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
8227: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
8228: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
8345:
8346: IF l_per_mixnmatch_enabled = 'Y' THEN
8347:
8348: /******************************************/
8349: /*** Update HZ_PERSON_PROFILES ***/
8350: /*** Mix and Match : enabled ***/
8351: /*** Version Profile: NO_VERSION ***/
8352: /*** Orig system : 3rd Party ***/
8353: /*** With existing 3rd party data ***/
8638:
8639: IF l_per_mixnmatch_enabled = 'Y' THEN
8640:
8641: /******************************************/
8642: /*** Update HZ_PERSON_PROFILES ***/
8643: /*** Mix and Match : enabled ***/
8644: /*** Version Profile: ONE_DAY_VERSION ***/
8645: /*** Orig system : 3rd Party ***/
8646: /*** With existing 3rd party data ***/
8704: l_content_source_type, l_actual_content_source;
8705:
8706:
8707: /******************************************/
8708: /*** Insert into HZ_PERSON_PROFILES ***/
8709: /*** Mix and Match : enabled ***/
8710: /*** Version Profile: ONE_DAY_VERSION ***/
8711: /*** Orig system : 3rd Party ***/
8712: /*** With existing 3rd party data ***/
8771: l_content_source_type, l_actual_content_source;
8772:
8773:
8774: /******************************************/
8775: /*** End date HZ_PERSON_PROFILES ***/
8776: /*** Mix and Match : enabled ***/
8777: /*** Version Profile: ONE_DAY_VERSION ***/
8778: /*** Orig system : 3rd Party ***/
8779: /*** With existing 3rd party data ***/
8784: p_msg_level=>fnd_log.level_statement);
8785: END IF;
8786:
8787: ForAll j in 1..l_party_orig_system_reference.count
8788: update hz_person_profiles pp1 set
8789: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
8790: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
8791: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
8792: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
9066:
9067: IF l_per_mixnmatch_enabled = 'Y' THEN
9068:
9069: /******************************************/
9070: /*** Insert into HZ_PERSON_PROFILES ***/
9071: /*** Mix and Match : enabled ***/
9072: /*** Orig system : 3rd Party ***/
9073: /*** Without existing 3rd party data ***/
9074: /******************************************/
9072: /*** Orig system : 3rd Party ***/
9073: /*** Without existing 3rd party data ***/
9074: /******************************************/
9075: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
9076: hz_utility_v2pub.debug(p_message=>'Insert into hz_person_profiles',
9077: p_prefix =>l_debug_prefix,
9078: p_msg_level=>fnd_log.level_statement);
9079: END IF;
9080:
9078: p_msg_level=>fnd_log.level_statement);
9079: END IF;
9080:
9081: ForAll j in 1..l_party_orig_system_reference.count
9082: insert into hz_person_profiles
9083: (
9084: PERSON_PROFILE_ID,
9085: PARTY_ID,
9086: PERSON_NAME,
9137: DECEASED_FLAG,
9138: CREATED_BY_MODULE
9139: )
9140: select
9141: hz_person_profiles_s.nextval,
9142: l_party_id(j),
9143: nvl(l_person_name(j), l_party_name(j)),
9144: P_DML_RECORD.SYSDATE,
9145: P_DML_RECORD.USER_ID,
9233: from dual
9234: where
9235: l_num_row_processed(j) = 1
9236: and l_party_type(j) = 'PERSON'
9237: and not exists (select 1 from hz_person_profiles pp2
9238: where pp2.content_source_type = l_content_source_type
9239: and pp2.actual_content_source = l_actual_content_source
9240: and pp2.party_id = l_party_id(j)
9241: and pp2.effective_end_date is null);
9549:
9550: l_org_mixnmatch_enabled := HZ_MIXNM_UTILITY.isMixNMatchEnabled('HZ_ORGANIZATION_PROFILES',l_entity_attr_id);
9551: l_entity_attr_id := NULL; --Bug 10365551
9552:
9553: l_per_mixnmatch_enabled := HZ_MIXNM_UTILITY.isMixNMatchEnabled('HZ_PERSON_PROFILES',l_entity_attr_id);
9554:
9555: l_content_source_type := P_DML_RECORD.ACTUAL_CONTENT_SRC;
9556: IF l_content_source_type = 'USER_ENTERED' THEN
9557: l_actual_content_source := 'SST';