eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MIXNM_UTILITY dependencies on HZ_PERSON_PROFILES

Line 380: FROM hz_person_profiles

376: CURSOR c_exist_per_sst_profile (
377: p_party_id NUMBER
378: ) IS
379: SELECT 'Y'
380: FROM hz_person_profiles
381: WHERE party_id = p_party_id
382: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
383: AND effective_end_date is NULL;
384:

Line 550: -- IF p_entity_name IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES') THEN

546: p_msg_level=>fnd_log.level_statement);
547: END IF;
548:
549: /*
550: -- IF p_entity_name IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES') THEN
551:
552: OPEN c_profile_last_update_date(p_entity_name);
553: FETCH c_profile_last_update_date INTO l_last_update_date;
554: CLOSE c_profile_last_update_date;

Line 584: p_entity_name = 'HZ_PERSON_PROFILES' AND

580: */
581:
582: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' AND
583: G_ORG_SETUP_LOADED = 'N' OR
584: p_entity_name = 'HZ_PERSON_PROFILES' AND
585: G_PER_SETUP_LOADED = 'N'
586: THEN
587:
588: -- load attribute names

Line 673: IF p_entity_name = 'HZ_PERSON_PROFILES' THEN

669: p_msg_level=>fnd_log.level_statement);
670: END IF;
671: END IF;
672:
673: IF p_entity_name = 'HZ_PERSON_PROFILES' THEN
674: G_PER_SETUP_LOADED := 'Y';
675: -- Bug 4244112 : Added debug log
676: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
677: hz_utility_v2pub.debug(p_message=>'Loaded Person Profiles',

Line 905: WHERE e.entity_name NOT IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')

901:
902: CURSOR c_entity_dict_other IS
903: SELECT e.entity_attr_id, e.entity_name
904: FROM hz_entity_attributes e
905: WHERE e.entity_name NOT IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')
906: ORDER BY e.entity_name;
907:
908: /* SSM SST Integration and Extension
909: The concept of selected data sources for other entities is obsoleted.

Line 918: WHERE e.entity_name NOT IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')

914: SELECT s.entity_attr_id,
915: s.content_source_type
916: FROM hz_entity_attributes e,
917: hz_select_data_sources s
918: WHERE e.entity_name NOT IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')
919: AND s.entity_attr_id = e.entity_attr_id
920: AND s.ranking > 0
921: ORDER BY s.entity_attr_id;
922: */

Line 1128: l_entity_name := 'HZ_PERSON_PROFILES';

1124: p_msg_level=>fnd_log.level_statement);
1125: END IF;
1126:
1127: IF i = 1 THEN
1128: l_entity_name := 'HZ_PERSON_PROFILES';
1129: l_entity_id := G_PERSON_PROFILE_ID;
1130: ELSE
1131: l_entity_name := 'HZ_ORGANIZATION_PROFILES';
1132: l_entity_id := G_ORGANIZATION_PROFILE_ID;

Line 1727: p_entity_name = 'HZ_PERSON_PROFILES'

1723: RETURN 0;
1724: END IF;
1725: -- ELSIF G_PER_SETUP_LAST_UPDATE_DATE IS NOT NULL AND
1726: ELSIF G_PER_SETUP_LOADED = 'Y' AND
1727: p_entity_name = 'HZ_PERSON_PROFILES'
1728: THEN
1729: l_index := getIndex(G_PER_ATTRIBUTE_NAME, UPPER(p_attribute_name));
1730:
1731: -- Debug info.

Line 1751: IF p_entity_name = 'HZ_PERSON_PROFILES' THEN

1747: END IF;
1748: END IF;
1749: -- ELSIF G_DATASOURCE_LAST_UPDATE_DATE IS NOT NULL THEN
1750: ELSIF G_DATASOURCE_LOADED = 'Y' THEN
1751: IF p_entity_name = 'HZ_PERSON_PROFILES' THEN
1752: RETURN G_PERSON_PROFILE_ID;
1753: ELSIF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN
1754: RETURN G_ORGANIZATION_PROFILE_ID;
1755: ELSE

Line 2093: elsif p_entity = 'HZ_PERSON_PROFILES' THEN

2089: p_prefix =>l_debug_prefix,
2090: p_msg_level=>fnd_log.level_statement);
2091: END IF;
2092: END;
2093: elsif p_entity = 'HZ_PERSON_PROFILES' THEN
2094: BEGIN
2095: select '1' into l_tmp_d from hz_person_profiles where party_id = p_party_id
2096: and actual_content_source = p_real_data_source_type
2097: and EFFECTIVE_END_DATE is NULL;

Line 2095: select '1' into l_tmp_d from hz_person_profiles where party_id = p_party_id

2091: END IF;
2092: END;
2093: elsif p_entity = 'HZ_PERSON_PROFILES' THEN
2094: BEGIN
2095: select '1' into l_tmp_d from hz_person_profiles where party_id = p_party_id
2096: and actual_content_source = p_real_data_source_type
2097: and EFFECTIVE_END_DATE is NULL;
2098: exception
2099: when no_data_found then

Line 2775: l_entity_name := 'HZ_PERSON_PROFILES';

2771: x_name_list => l_name_list,
2772: x_new_value_is_null_list => l_null_list);
2773:
2774:
2775: l_entity_name := 'HZ_PERSON_PROFILES';
2776:
2777: END IF;
2778:
2779: cacheSetupForPartyProfiles

Line 3030: * HZ_PERSON_PROFILES.

3026: *
3027: * NOTES
3028: * The procedure can only be called for other entities like HZ_CONTACT_POINTS,
3029: * HZ_LOCATIONS etc. It can not be called on party profiles HZ_ORGANIZATION_PROFILES,
3030: * HZ_PERSON_PROFILES.
3031: *
3032: * MODIFICATION HISTORY
3033: *
3034: * 03-01-2002 Jianying Huang o Created.

Line 3263: * HZ_PERSON_PROFILES.

3259: *
3260: * NOTES
3261: * The procedure can only be called for other entities like HZ_CONTACT_POINTS,
3262: * HZ_LOCATIONS etc. It can not be called on party profiles HZ_ORGANIZATION_PROFILES,
3263: * HZ_PERSON_PROFILES.
3264: *
3265: * MODIFICATION HISTORY
3266: *
3267: * 03-01-2002 Jianying Huang o Created.

Line 3496: * HZ_PERSON_PROFILES.

3492: *
3493: * NOTES
3494: * The procedure can only be called for other entities like HZ_CONTACT_POINTS,
3495: * HZ_LOCATIONS etc. It can not be called on party profiles HZ_ORGANIZATION_PROFILES,
3496: * HZ_PERSON_PROFILES.
3497: *
3498: * MODIFICATION HISTORY
3499: *
3500: * 03-01-2002 Jianying Huang o Created.

Line 3649: IF p_entity_name NOT IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')

3645: l_src_selected VARCHAR2(1) := 'N';
3646:
3647: BEGIN
3648: -- SSM SST Integration and Extension
3649: IF p_entity_name NOT IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')
3650: THEN
3651: RETURN 'Y';
3652: END IF;
3653:

Line 3662: ELSIF p_entity_name = 'HZ_PERSON_PROFILES' THEN

3658: p_entity_attr_id = 0
3659: THEN
3660: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN
3661: p_entity_attr_id := G_ORGANIZATION_PROFILE_ID;
3662: ELSIF p_entity_name = 'HZ_PERSON_PROFILES' THEN
3663: p_entity_attr_id := G_PERSON_PROFILE_ID;
3664: /*ELSE
3665: IF p_entity_name = 'HZ_PARTY_SITES' THEN
3666: l_entity_name := 'HZ_LOCATIONS';

Line 3692: ELSIF p_entity_name = 'HZ_PERSON_PROFILES' THEN

3688: ELSE
3689:
3690: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN
3691: l_return := NVL(fnd_profile.value('HZ_ORG_PROF_MIXNMATCH_ENABLED'), 'N');
3692: ELSIF p_entity_name = 'HZ_PERSON_PROFILES' THEN
3693: l_return := NVL(fnd_profile.value('HZ_PER_PROF_MIXNMATCH_ENABLED'), 'N');
3694: ELSE
3695: IF p_called_from_policy_function = 'Y' THEN
3696: l_return := 'Y';

Line 3944: p_entity_name => 'HZ_PERSON_PROFILES',

3940: -- return a updatable of all of attributes we passed in.
3941:
3942: areSSTColumnsUpdeable (
3943: p_party_id => p_party_id,
3944: p_entity_name => 'HZ_PERSON_PROFILES',
3945: p_attribute_name_list => l_name_list,
3946: p_value_is_null_list => l_sst_value_is_null_list,
3947: p_data_source_type => p_data_source_type,
3948: x_updatable_flag_list => l_updatable_flag_list,

Line 4669: FROM hz_person_profiles

4665: ORDER BY party_id;
4666:
4667: CURSOR c_person_parties IS
4668: SELECT distinct party_id
4669: FROM hz_person_profiles
4670: WHERE effective_end_date IS NULL
4671: AND actual_content_source <> G_MISS_ACTUAL_CONTENT_SOURCE
4672: ORDER BY party_id;
4673:

Line 4754: OPEN c_prof_setup('HZ_PERSON_PROFILES');

4750: END IF;
4751:
4752: x_process_person := true; x_per_total := 0;
4753:
4754: OPEN c_prof_setup('HZ_PERSON_PROFILES');
4755: FETCH c_prof_setup INTO l_dummy;
4756: IF c_prof_setup%NOTFOUND THEN
4757: x_process_person := false;
4758: END IF;

Line 5044: AND e.entity_name IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')

5040: CURSOR c_prof_setup IS
5041: SELECT 'Y'
5042: FROM hz_entity_attributes e
5043: WHERE e.updated_flag = 'Y'
5044: AND e.entity_name IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')
5045: AND rownum = 1;
5046:
5047: l_process_profile BOOLEAN := true;
5048:

Line 5054: AND e.entity_name NOT IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')

5050: SELECT 'Y'
5051: FROM hz_entity_attributes e,
5052: hz_select_data_sources s
5053: WHERE e.updated_flag = 'Y'
5054: AND e.entity_name NOT IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')
5055: AND rownum = 1;
5056:
5057: l_process_other_entities BOOLEAN := true;
5058:

Line 5159: WHERE e.entity_name = 'HZ_PERSON_PROFILES'

5155: DELETE hz_win_source_exceps
5156: WHERE entity_attr_id IN
5157: (SELECT e.entity_attr_id
5158: FROM hz_entity_attributes e, hz_select_data_sources s
5159: WHERE e.entity_name = 'HZ_PERSON_PROFILES'
5160: AND s.ranking > 0
5161: AND s.content_source_type = 'USER_ENTERED'
5162: AND e.entity_attr_id = s.entity_attr_id
5163: )

Line 5204: 'HZ_PERSON_PROFILES',

5200: END IF;
5201:
5202: IF l_process_person AND l_per_total <> 0 THEN
5203: CreateUpdatePartyProfiles (
5204: 'HZ_PERSON_PROFILES',
5205: l_process_person_mode,
5206: l_commit_size,
5207: l_per_party_per_worker,
5208: l_per_id_count,

Line 5225: l_process_org_mode||',HZ_PERSON_PROFILES',

5221:
5222: IF l_process_person AND l_per_total <> 0 THEN
5223: conc_sub (
5224: errbuf, retcode,
5225: l_process_org_mode||',HZ_PERSON_PROFILES',
5226: l_per_id_start(1),
5227: l_per_id_end(l_per_id_end.COUNT),
5228: l_commit_size);
5229: END IF;