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 383: FROM hz_person_profiles

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

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

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

Line 587: p_entity_name = 'HZ_PERSON_PROFILES' AND

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

Line 676: IF p_entity_name = 'HZ_PERSON_PROFILES' THEN

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

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

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

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

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

Line 1131: l_entity_name := 'HZ_PERSON_PROFILES';

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

Line 1737: p_entity_name = 'HZ_PERSON_PROFILES'

1733: RETURN 0;
1734: END IF;
1735: -- ELSIF G_PER_SETUP_LAST_UPDATE_DATE IS NOT NULL AND
1736: ELSIF G_PER_SETUP_LOADED = 'Y' AND
1737: p_entity_name = 'HZ_PERSON_PROFILES'
1738: THEN
1739: l_index := getIndex(G_PER_ATTRIBUTE_NAME, UPPER(p_attribute_name));
1740:
1741: -- Debug info.

Line 1761: IF p_entity_name = 'HZ_PERSON_PROFILES' THEN

1757: END IF;
1758: END IF;
1759: -- ELSIF G_DATASOURCE_LAST_UPDATE_DATE IS NOT NULL THEN
1760: ELSIF G_DATASOURCE_LOADED = 'Y' THEN
1761: IF p_entity_name = 'HZ_PERSON_PROFILES' THEN
1762: RETURN G_PERSON_PROFILE_ID;
1763: ELSIF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN
1764: RETURN G_ORGANIZATION_PROFILE_ID;
1765: ELSE

Line 2103: elsif p_entity = 'HZ_PERSON_PROFILES' THEN

2099: p_prefix =>l_debug_prefix,
2100: p_msg_level=>fnd_log.level_statement);
2101: END IF;
2102: END;
2103: elsif p_entity = 'HZ_PERSON_PROFILES' THEN
2104: BEGIN
2105: select '1' into l_tmp_d from hz_person_profiles where party_id = p_party_id
2106: and actual_content_source = p_real_data_source_type
2107: and EFFECTIVE_END_DATE is NULL;

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

2101: END IF;
2102: END;
2103: elsif p_entity = 'HZ_PERSON_PROFILES' THEN
2104: BEGIN
2105: select '1' into l_tmp_d from hz_person_profiles where party_id = p_party_id
2106: and actual_content_source = p_real_data_source_type
2107: and EFFECTIVE_END_DATE is NULL;
2108: exception
2109: when no_data_found then

Line 2785: l_entity_name := 'HZ_PERSON_PROFILES';

2781: x_name_list => l_name_list,
2782: x_new_value_is_null_list => l_null_list);
2783:
2784:
2785: l_entity_name := 'HZ_PERSON_PROFILES';
2786:
2787: END IF;
2788:
2789: cacheSetupForPartyProfiles

Line 3040: * HZ_PERSON_PROFILES.

3036: *
3037: * NOTES
3038: * The procedure can only be called for other entities like HZ_CONTACT_POINTS,
3039: * HZ_LOCATIONS etc. It can not be called on party profiles HZ_ORGANIZATION_PROFILES,
3040: * HZ_PERSON_PROFILES.
3041: *
3042: * MODIFICATION HISTORY
3043: *
3044: * 03-01-2002 Jianying Huang o Created.

Line 3273: * HZ_PERSON_PROFILES.

3269: *
3270: * NOTES
3271: * The procedure can only be called for other entities like HZ_CONTACT_POINTS,
3272: * HZ_LOCATIONS etc. It can not be called on party profiles HZ_ORGANIZATION_PROFILES,
3273: * HZ_PERSON_PROFILES.
3274: *
3275: * MODIFICATION HISTORY
3276: *
3277: * 03-01-2002 Jianying Huang o Created.

Line 3506: * HZ_PERSON_PROFILES.

3502: *
3503: * NOTES
3504: * The procedure can only be called for other entities like HZ_CONTACT_POINTS,
3505: * HZ_LOCATIONS etc. It can not be called on party profiles HZ_ORGANIZATION_PROFILES,
3506: * HZ_PERSON_PROFILES.
3507: *
3508: * MODIFICATION HISTORY
3509: *
3510: * 03-01-2002 Jianying Huang o Created.

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

3655: l_src_selected VARCHAR2(1) := 'N';
3656:
3657: BEGIN
3658: -- SSM SST Integration and Extension
3659: IF p_entity_name NOT IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')
3660: THEN
3661: RETURN 'Y';
3662: END IF;
3663:

Line 3672: ELSIF p_entity_name = 'HZ_PERSON_PROFILES' THEN

3668: p_entity_attr_id = 0
3669: THEN
3670: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN
3671: p_entity_attr_id := G_ORGANIZATION_PROFILE_ID;
3672: ELSIF p_entity_name = 'HZ_PERSON_PROFILES' THEN
3673: p_entity_attr_id := G_PERSON_PROFILE_ID;
3674: /*ELSE
3675: IF p_entity_name = 'HZ_PARTY_SITES' THEN
3676: l_entity_name := 'HZ_LOCATIONS';

Line 3702: ELSIF p_entity_name = 'HZ_PERSON_PROFILES' THEN

3698: ELSE
3699:
3700: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN
3701: l_return := NVL(fnd_profile.value('HZ_ORG_PROF_MIXNMATCH_ENABLED'), 'N');
3702: ELSIF p_entity_name = 'HZ_PERSON_PROFILES' THEN
3703: l_return := NVL(fnd_profile.value('HZ_PER_PROF_MIXNMATCH_ENABLED'), 'N');
3704: ELSE
3705: IF p_called_from_policy_function = 'Y' THEN
3706: l_return := 'Y';

Line 3954: p_entity_name => 'HZ_PERSON_PROFILES',

3950: -- return a updatable of all of attributes we passed in.
3951:
3952: areSSTColumnsUpdeable (
3953: p_party_id => p_party_id,
3954: p_entity_name => 'HZ_PERSON_PROFILES',
3955: p_attribute_name_list => l_name_list,
3956: p_value_is_null_list => l_sst_value_is_null_list,
3957: p_data_source_type => p_data_source_type,
3958: x_updatable_flag_list => l_updatable_flag_list,

Line 4679: FROM hz_person_profiles

4675: ORDER BY party_id;
4676:
4677: CURSOR c_person_parties IS
4678: SELECT distinct party_id
4679: FROM hz_person_profiles
4680: WHERE effective_end_date IS NULL
4681: AND actual_content_source <> G_MISS_ACTUAL_CONTENT_SOURCE
4682: ORDER BY party_id;
4683:

Line 4764: OPEN c_prof_setup('HZ_PERSON_PROFILES');

4760: END IF;
4761:
4762: x_process_person := true; x_per_total := 0;
4763:
4764: OPEN c_prof_setup('HZ_PERSON_PROFILES');
4765: FETCH c_prof_setup INTO l_dummy;
4766: IF c_prof_setup%NOTFOUND THEN
4767: x_process_person := false;
4768: END IF;

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

5053: CURSOR c_prof_setup IS
5054: SELECT 'Y'
5055: FROM hz_entity_attributes e
5056: WHERE e.updated_flag = 'Y'
5057: AND e.entity_name IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')
5058: AND rownum = 1;
5059:
5060: l_process_profile BOOLEAN := true;
5061:

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

5063: SELECT 'Y'
5064: FROM hz_entity_attributes e,
5065: hz_select_data_sources s
5066: WHERE e.updated_flag = 'Y'
5067: AND e.entity_name NOT IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')
5068: AND rownum = 1;
5069:
5070: l_process_other_entities BOOLEAN := true;
5071:

Line 5189: WHERE e.entity_name = 'HZ_PERSON_PROFILES'

5185: DELETE hz_win_source_exceps
5186: WHERE entity_attr_id IN
5187: (SELECT e.entity_attr_id
5188: FROM hz_entity_attributes e, hz_select_data_sources s
5189: WHERE e.entity_name = 'HZ_PERSON_PROFILES'
5190: AND s.ranking > 0
5191: AND s.content_source_type = 'USER_ENTERED'
5192: AND e.entity_attr_id = s.entity_attr_id
5193: )

Line 5234: 'HZ_PERSON_PROFILES',

5230: END IF;
5231:
5232: IF l_process_person AND l_per_total <> 0 THEN
5233: CreateUpdatePartyProfiles (
5234: 'HZ_PERSON_PROFILES',
5235: l_process_person_mode,
5236: l_commit_size,
5237: l_per_party_per_worker,
5238: l_per_id_count,

Line 5255: l_process_org_mode||',HZ_PERSON_PROFILES',

5251:
5252: IF l_process_person AND l_per_total <> 0 THEN
5253: conc_sub (
5254: errbuf, retcode,
5255: l_process_org_mode||',HZ_PERSON_PROFILES',
5256: l_per_id_start(1),
5257: l_per_id_end(l_per_id_end.COUNT),
5258: l_commit_size);
5259: END IF;