[Home] [Help]
908: sic_code)';
909:
910: l_s2 varchar2(10000) := '
911: when (all_errors is not null and party_type = ''ORGANIZATION'') then -- o1
912: into hz_organization_profiles (
913: actual_content_source,
914: application_id,
915: content_source_type,
916: created_by,
1004: :5, -- program_application_id
1005: :6, -- program_id
1006: :3, -- sysdate
1007: :7, -- request_id
1008: hz_organization_profiles_s.nextval,
1009: party_id,
1010: organization_name,
1011: ceo_name,
1012: ceo_title,
1080: l_s3 varchar2(10000) := '
1081: when (all_errors is not null
1082: and l_content_source_type <> ''USER_ENTERED''
1083: and party_type = ''ORGANIZATION'') then
1084: into hz_organization_profiles ( -- o2
1085: actual_content_source,
1086: application_id,
1087: content_source_type,
1088: created_by,
1176: :5, -- program_application_id
1177: :6, -- program_id
1178: :3, -- sysdate
1179: :7, -- request_id
1180: hz_organization_profiles_s.nextval+1,
1181: party_id,
1182: organization_name,
1183: ceo_name,
1184: ceo_title,
1251: l_s4 varchar2(10000) := 'when (all_errors is not null
1252: and l_content_source_type <> ''USER_ENTERED''
1253: and party_type = ''ORGANIZATION''
1254: and :10 = ''Y'') then
1255: into hz_organization_profiles ( -- o3
1256: actual_content_source,
1257: application_id,
1258: content_source_type,
1259: created_by,
1347: :5, -- program_application_id
1348: :6, -- program_id
1349: :3, -- sysdate
1350: :7, -- request_id
1351: hz_organization_profiles_s.nextval+2,
1352: party_id,
1353: organization_name,
1354: ceo_name,
1355: ceo_title,
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,
3241: fnd_lookup_values local_bus_iden_type_l,
3444:
3445: l_dml_exception varchar2(1) := 'N';
3446:
3447: l_insert_org_profile varchar2(10000) :=
3448: 'insert into hz_organization_profiles op1
3449: (
3450: ORGANIZATION_PROFILE_ID,
3451: PARTY_ID,
3452: ORGANIZATION_NAME,
3526: DO_NOT_CONFUSE_WITH,
3527: ACTUAL_CONTENT_SOURCE
3528: )
3529: select
3530: hz_organization_profiles_s.nextval,
3531: PARTY_ID,
3532: decode(:l_organization_name, NULL, ORGANIZATION_NAME, :G_MISS_CHAR, ORGANIZATION_NAME,
3533: :l_organization_name),
3534: decode(:l_ceo_name, NULL, CEO_NAME, :G_MISS_CHAR, NULL,
3665: APPLICATION_ID,
3666: decode(:l_do_not_confuse_with, NULL, DO_NOT_CONFUSE_WITH, :G_MISS_CHAR, NULL,
3667: :l_do_not_confuse_with),
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: (
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,
3831: NULL, ORGANIZATION_NAME,
3832: :G_MISS_CHAR, ORGANIZATION_NAME,
3833: :l_organization_name),
4551: /*** Update HZ_PARTIES ***/
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
5110: p_msg_level=>fnd_log.level_statement);
5111: END IF;
5112:
5113: /********************************************/
5114: /*** Insert into HZ_ORGANIZATION_PROFILES ***/
5115: /*** Mix and Match : disabled ***/
5116: /*** Version Profile: NEW_VERSION ***/
5117: /********************************************/
5118:
5198: p_msg_level=>fnd_log.level_statement);
5199: END IF;
5200:
5201: /*************************************************/
5202: /*** End date current HZ_ORGANIZATION_PROFILES ***/
5203: /*** Mix and Match : disabled ***/
5204: /*** Version Profile: NEW_VERSION ***/
5205: /*************************************************/
5206:
5206:
5207: -- End date current profile and save the profile ids.
5208: -- Then use the profile ids for copying values to new profile
5209: ForAll j in 1..l_party_orig_system_reference.count
5210: update hz_organization_profiles op1 set
5211: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
5212: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
5213: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
5214: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
5351: p_msg_level=>fnd_log.level_statement);
5352: END IF;
5353:
5354: /********************************************/
5355: /*** Update HZ_ORGANIZATION_PROFILES ***/
5356: /*** Mix and Match : disabled ***/
5357: /*** Version Profile: NO_VERSION ***/
5358: /********************************************/
5359:
5511: p_msg_level=>fnd_log.level_statement);
5512: END IF;
5513:
5514: /******************************************/
5515: /*** Update HZ_ORGANIZATION_PROFILES ***/
5516: /*** Mix and Match : disabled ***/
5517: /*** Version Profile: ONE_DAY_VERSION ***/
5518: /******************************************/
5519:
5602: l_content_source_type, l_actual_content_source;
5603:
5604:
5605: /********************************************/
5606: /*** Insert into HZ_ORGANIZATION_PROFILES ***/
5607: /*** Mix and Match : disabled ***/
5608: /*** Version Profile: ONE_DAY_VERSION ***/
5609: /********************************************/
5610: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5692: l_content_source_type, l_actual_content_source;
5693:
5694:
5695: /********************************************/
5696: /*** End date HZ_ORGANIZATION_PROFILES ***/
5697: /*** Mix and Match : disabled ***/
5698: /*** Version Profile: ONE_DAY_VERSION ***/
5699: /********************************************/
5700:
5704: p_msg_level=>fnd_log.level_statement);
5705: END IF;
5706:
5707: ForAll j in 1..l_party_orig_system_reference.count
5708: update hz_organization_profiles op1 set
5709: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
5710: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
5711: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
5712: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
5908:
5909: IF l_org_mixnmatch_enabled = 'N' AND
5910: l_content_source_type <> 'USER_ENTERED' THEN
5911: /********************************************/
5912: /*** Insert into HZ_ORGANIZATION_PROFILES ***/
5913: /*** Mix and Match : disabled ***/
5914: /********************************************/
5915: /* Insert new org profile if content source is 3rd party and
5916: 3rd party data not exists */
5915: /* Insert new org profile if content source is 3rd party and
5916: 3rd party data not exists */
5917:
5918: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5919: hz_utility_v2pub.debug(p_message=>'Insert into hz_organization_profiles',
5920: p_prefix =>l_debug_prefix,
5921: p_msg_level=>fnd_log.level_statement);
5922: END IF;
5923:
5921: p_msg_level=>fnd_log.level_statement);
5922: END IF;
5923:
5924: ForAll j in 1..l_party_orig_system_reference.count
5925: insert into hz_organization_profiles
5926: (
5927: ORGANIZATION_PROFILE_ID,
5928: PARTY_ID,
5929: ORGANIZATION_NAME,
6003: DO_NOT_CONFUSE_WITH,
6004: ACTUAL_CONTENT_SOURCE
6005: )
6006: select
6007: hz_organization_profiles_s.nextval,
6008: l_party_id(j), -- assume l_party_id cannot be null or G_MISS
6009: nvl(l_organization_name(j), l_party_name(j)),
6010: decode(l_ceo_name(j), P_DML_RECORD.GMISS_CHAR, NULL,
6011: l_ceo_name(j)),
6144: from dual
6145: where
6146: l_num_row_processed(j) = 1
6147: and l_party_type(j) = 'ORGANIZATION'
6148: and not exists (select 1 from hz_organization_profiles op2
6149: where op2.content_source_type = l_content_source_type
6150: and op2.actual_content_source = l_actual_content_source
6151: and op2.party_id = l_party_id(j));
6152:
6343:
6344: /* Handle records with no DNB data */
6345:
6346: /********************************************/
6347: /*** Insert into HZ_ORGANIZATION_PROFILES ***/
6348: /*** Mix and Match : enabled ***/
6349: /*** Orig system : USER_ENTERED ***/
6350: /*** Has no DNB data ***/
6351: /*** Version Profile: NEW_VERSION ***/
6363: and :l_num_row_processed = 1
6364: and :l_party_type = ''ORGANIZATION''
6365: and CONTENT_SOURCE_TYPE = ''USER_ENTERED''
6366: and ACTUAL_CONTENT_SOURCE = ''SST''
6367: and not exists (select 1 from hz_organization_profiles op2
6368: where op2.content_source_type = ''USER_ENTERED''
6369: and op2.actual_content_source = ''USER_ENTERED''
6370: and :l_party_id = op2.party_id)'
6371: USING
6435: l_do_not_confuse_with(j), P_DML_RECORD.GMISS_CHAR, l_do_not_confuse_with(j),
6436: l_party_id(j), l_num_row_processed(j), l_party_type(j), l_party_id(j);
6437:
6438: /*************************************************/
6439: /*** End date current HZ_ORGANIZATION_PROFILES ***/
6440: /*** Mix and Match : enabled ***/
6441: /*** Orig system : USER_ENTERED ***/
6442: /*** Has no DNB data ***/
6443: /*** Version Profile: NEW_VERSION ***/
6451:
6452: -- End date current profile and save the profile ids.
6453: -- Then use the profile ids for copying values to new profile
6454: ForAll j in 1..l_party_orig_system_reference.count
6455: update hz_organization_profiles op1 set
6456: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
6457: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
6458: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
6459: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
6470: and l_num_row_processed(j) = 1
6471: and l_party_type(j) = 'ORGANIZATION'
6472: and CONTENT_SOURCE_TYPE = 'USER_ENTERED'
6473: and ACTUAL_CONTENT_SOURCE = 'SST'
6474: and not exists (select 1 from hz_organization_profiles op2
6475: where op2.content_source_type = 'USER_ENTERED'
6476: and op2.actual_content_source = 'USER_ENTERED'
6477: and op1.party_id = op2.party_id)
6478: and nvl(request_id, -1) <> P_DML_RECORD.REQUEST_ID;
6609: p_msg_level=>fnd_log.level_statement);
6610: END IF;
6611:
6612: /********************************************/
6613: /*** Insert into HZ_ORGANIZATION_PROFILES ***/
6614: /*** Mix and Match : enabled ***/
6615: /*** Orig system : USER_ENTERED ***/
6616: /*** Has DNB data ***/
6617: /*** Version Profile: NEW_VERSION ***/
6693: l_do_not_confuse_with(j), P_DML_RECORD.GMISS_CHAR, l_do_not_confuse_with(j),
6694: l_party_id(j), l_num_row_processed(j), l_party_type(j);
6695:
6696: /*************************************************/
6697: /*** End date current HZ_ORGANIZATION_PROFILES ***/
6698: /*** Mix and Match : enabled ***/
6699: /*** Orig system : USER_ENTERED ***/
6700: /*** Has DNB data ***/
6701: /*** Version Profile: NEW_VERSION ***/
6703:
6704: -- End date current profile and save the profile ids.
6705: -- Then use the profile ids for copying values to new profile
6706: ForAll j in 1..l_party_orig_system_reference.count
6707: update hz_organization_profiles op1 set
6708: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
6709: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
6710: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
6711: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
6850: p_msg_level=>fnd_log.level_statement);
6851: END IF;
6852:
6853: /******************************************/
6854: /*** Update HZ_ORGANIZATION_PROFILES ***/
6855: /*** Mix and Match : enabled ***/
6856: /*** Orig system : USER_ENTERED ***/
6857: /*** Has no DNB data ***/
6858: /*** Version Profile: NO_VERSION ***/
6866: and :l_num_row_processed = 1
6867: and :l_party_type = ''ORGANIZATION''
6868: and CONTENT_SOURCE_TYPE = ''USER_ENTERED''
6869: and ACTUAL_CONTENT_SOURCE = ''SST''
6870: and not exists (select 1 from hz_organization_profiles op2
6871: where op2.content_source_type = ''USER_ENTERED''
6872: and op2.actual_content_source = ''USER_ENTERED''
6873: and op1.party_id = op2.party_id)'
6874: USING
7016:
7017: IF l_org_mixnmatch_enabled = 'Y' THEN
7018:
7019: /******************************************/
7020: /*** Update HZ_ORGANIZATION_PROFILES ***/
7021: /*** Mix and Match : enabled ***/
7022: /*** Orig system : USER_ENTERED ***/
7023: /*** Has DNB data ***/
7024: /*** Version Profile: NO_VERSION ***/
7178: p_msg_level=>fnd_log.level_statement);
7179: END IF;
7180:
7181: /******************************************/
7182: /*** Update HZ_ORGANIZATION_PROFILES ***/
7183: /*** Mix and Match : enabled ***/
7184: /*** Orig system : USER_ENTERED ***/
7185: /*** Has no DNB data ***/
7186: /*** Version Profile: ONE_DAY_VERSION ***/
7206: and trunc(EFFECTIVE_START_DATE) = :l_sysdate
7207: and :l_party_type = ''ORGANIZATION''
7208: and CONTENT_SOURCE_TYPE = ''USER_ENTERED''
7209: and ACTUAL_CONTENT_SOURCE = ''SST''
7210: and not exists (select 1 from hz_organization_profiles op2
7211: where op2.content_source_type = ''USER_ENTERED''
7212: and op2.actual_content_source = ''USER_ENTERED''
7213: and op1.party_id = op2.party_id)'
7214:
7278: l_party_id(j), l_num_row_processed(j), trunc(P_DML_RECORD.SYSDATE), l_party_type(j);
7279:
7280:
7281: /********************************************/
7282: /*** Insert into HZ_ORGANIZATION_PROFILES ***/
7283: /*** Mix and Match : enabled ***/
7284: /*** Orig system : USER_ENTERED ***/
7285: /*** Has no DNB data ***/
7286: /*** Version Profile: ONE_DAY_VERSION ***/
7301: and :l_party_type = ''ORGANIZATION''
7302: and trunc(EFFECTIVE_START_DATE) < :l_sysdate
7303: and CONTENT_SOURCE_TYPE = ''USER_ENTERED''
7304: and ACTUAL_CONTENT_SOURCE = ''SST''
7305: and not exists (select 1 from hz_organization_profiles op2
7306: where op2.content_source_type = ''USER_ENTERED''
7307: and op2.actual_content_source = ''USER_ENTERED''
7308: and :l_party_id = op2.party_id)'
7309: USING
7373: l_do_not_confuse_with(j), P_DML_RECORD.GMISS_CHAR, l_do_not_confuse_with(j),
7374: l_party_id(j), l_num_row_processed(j), l_party_type(j), trunc(P_DML_RECORD.SYSDATE), l_party_id(j);
7375:
7376: /******************************************/
7377: /*** End date HZ_ORGANIZATION_PROFILES ***/
7378: /*** Mix and Match : enabled ***/
7379: /*** Orig system : USER_ENTERED ***/
7380: /*** Has no DNB data ***/
7381: /*** Version Profile: ONE_DAY_VERSION ***/
7386: p_msg_level=>fnd_log.level_statement);
7387: END IF;
7388:
7389: ForAll j in 1..l_party_orig_system_reference.count
7390: update hz_organization_profiles op1 set
7391: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
7392: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
7393: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
7394: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
7405: and trunc(EFFECTIVE_START_DATE) < trunc(P_DML_RECORD.SYSDATE)
7406: and l_party_type(j) = 'ORGANIZATION'
7407: and CONTENT_SOURCE_TYPE = 'USER_ENTERED'
7408: and ACTUAL_CONTENT_SOURCE = 'SST'
7409: and not exists (select 1 from hz_organization_profiles op2
7410: where op2.content_source_type = 'USER_ENTERED'
7411: and op2.actual_content_source = 'USER_ENTERED'
7412: and op1.party_id = op2.party_id)
7413: and nvl(request_id, -1) <> P_DML_RECORD.REQUEST_ID;
7608:
7609: IF l_org_mixnmatch_enabled = 'Y' THEN
7610:
7611: /******************************************/
7612: /*** Update HZ_ORGANIZATION_PROFILES ***/
7613: /*** Mix and Match : enabled ***/
7614: /*** Orig system : USER_ENTERED ***/
7615: /*** Version Profile: ONE_DAY_VERSION ***/
7616: /*** Has DNB data ***/
7699: l_do_not_confuse_with(j), P_DML_RECORD.GMISS_CHAR, l_do_not_confuse_with(j),
7700: l_party_id(j), l_num_row_processed(j), trunc(P_DML_RECORD.SYSDATE), l_party_type(j);
7701:
7702: /********************************************/
7703: /*** Insert into HZ_ORGANIZATION_PROFILES ***/
7704: /*** Mix and Match : enabled ***/
7705: /*** Orig system : USER_ENTERED ***/
7706: /*** Has DNB data ***/
7707: /*** Version Profile: ONE_DAY_VERSION ***/
7790: l_do_not_confuse_with(j), P_DML_RECORD.GMISS_CHAR, l_do_not_confuse_with(j),
7791: l_party_id(j), l_num_row_processed(j), l_party_type(j), trunc(P_DML_RECORD.SYSDATE);
7792:
7793: /********************************************/
7794: /*** End date HZ_ORGANIZATION_PROFILES ***/
7795: /*** Mix and Match : enabled ***/
7796: /*** Orig system : USER_ENTERED ***/
7797: /*** Version Profile: ONE_DAY_VERSION ***/
7798: /*** Has DNB data ***/
7804: p_msg_level=>fnd_log.level_statement);
7805: END IF;
7806:
7807: ForAll j in 1..l_party_orig_system_reference.count
7808: update hz_organization_profiles op1 set
7809: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
7810: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
7811: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
7812: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
8016: p_msg_level=>fnd_log.level_statement);
8017: END IF;
8018:
8019: /********************************************/
8020: /*** Insert into HZ_ORGANIZATION_PROFILES ***/
8021: /*** Mix and Match : enabled ***/
8022: /*** Version Profile: NEW_VERSION ***/
8023: /*** Orig system : 3rd Party ***/
8024: /*** With existing 3rd party data ***/
8101: l_party_id(j), l_num_row_processed(j), l_party_type(j),
8102: l_content_source_type, l_actual_content_source;
8103:
8104: /*************************************************/
8105: /*** End date current HZ_ORGANIZATION_PROFILES ***/
8106: /*** Mix and Match : enabled ***/
8107: /*** Version Profile: NEW_VERSION ***/
8108: /*** Orig system : 3rd Party ***/
8109: /*** With existing 3rd party data ***/
8114: p_msg_level=>fnd_log.level_statement);
8115: END IF;
8116:
8117: ForAll j in 1..l_party_orig_system_reference.count
8118: update hz_organization_profiles op1 set
8119: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
8120: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
8121: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
8122: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
8258: p_msg_level=>fnd_log.level_statement);
8259: END IF;
8260:
8261: /******************************************/
8262: /*** Update HZ_ORGANIZATION_PROFILES ***/
8263: /*** Mix and Match : enabled ***/
8264: /*** Version Profile: NO_VERSION ***/
8265: /*** Orig system : 3rd Party ***/
8266: /*** With existing 3rd party data ***/
8421:
8422: IF l_org_mixnmatch_enabled = 'Y' THEN
8423:
8424: /******************************************/
8425: /*** Update HZ_ORGANIZATION_PROFILES ***/
8426: /*** Mix and Match : enabled ***/
8427: /*** Version Profile: ONE_DAY_VERSION ***/
8428: /*** Orig system : 3rd Party ***/
8429: /*** With existing 3rd party data ***/
8507:
8508:
8509:
8510: /********************************************/
8511: /*** Insert into HZ_ORGANIZATION_PROFILES ***/
8512: /*** Mix and Match : enabled ***/
8513: /*** Version Profile: ONE_DAY_VERSION ***/
8514: /*** Orig system : 3rd Party ***/
8515: /*** With existing 3rd party data ***/
8598: l_party_id(j), l_num_row_processed(j), l_party_type(j), trunc(P_DML_RECORD.SYSDATE),
8599: l_content_source_type, l_actual_content_source;
8600:
8601: /******************************************/
8602: /*** End date HZ_ORGANIZATION_PROFILES ***/
8603: /*** Mix and Match : enabled ***/
8604: /*** Version Profile: ONE_DAY_VERSION ***/
8605: /*** Orig system : 3rd Party ***/
8606: /*** With existing 3rd party data ***/
8611: p_msg_level=>fnd_log.level_statement);
8612: END IF;
8613:
8614: ForAll j in 1..l_party_orig_system_reference.count
8615: update hz_organization_profiles op1 set
8616: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
8617: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
8618: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
8619: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
8813:
8814: IF l_org_mixnmatch_enabled = 'Y' THEN
8815:
8816: /********************************************/
8817: /*** Insert into HZ_ORGANIZATION_PROFILES ***/
8818: /*** Mix and Match : enabled ***/
8819: /*** Orig system : 3rd Party ***/
8820: /*** Without existing 3rd party data ***/
8821: /********************************************/
8832: profile without getting values from the current user entered profile.
8833: Insert record after above update or the new record will be processed
8834: by the updates */
8835: ForAll j in 1..l_party_orig_system_reference.count
8836: insert into hz_organization_profiles
8837: (
8838: ORGANIZATION_PROFILE_ID,
8839: PARTY_ID,
8840: ORGANIZATION_NAME,
8914: DO_NOT_CONFUSE_WITH,
8915: ACTUAL_CONTENT_SOURCE
8916: )
8917: select
8918: hz_organization_profiles_s.nextval,
8919: l_party_id(j), -- assume l_party_id cannot be null or G_MISS
8920: nvl(l_organization_name(j), l_party_name(j)),
8921: decode(l_ceo_name(j), P_DML_RECORD.GMISS_CHAR, NULL,
8922: l_ceo_name(j)),
9055: from dual
9056: where
9057: l_num_row_processed(j) = 1
9058: and l_party_type(j) = 'ORGANIZATION'
9059: and not exists (select 1 from hz_organization_profiles op2
9060: where op2.content_source_type = l_content_source_type
9061: and op2.actual_content_source = l_actual_content_source
9062: and op2.party_id = l_party_id(j)
9063: and op2.effective_end_date is null);
9546:
9547: --Initialize API return status to success.
9548: x_return_status := FND_API.G_RET_STS_SUCCESS;
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: