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_ORGANIZATION_PROFILES

Line 369: FROM hz_organization_profiles

365: CURSOR c_exist_org_sst_profile (
366: p_party_id NUMBER
367: ) IS
368: SELECT 'Y'
369: FROM hz_organization_profiles
370: WHERE party_id = p_party_id
371: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
372: AND effective_end_date is NULL;
373:

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 562: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN

558: END IF;
559:
560: -- IF l_last_update_date IS NOT NULL THEN
561:
562: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN
563: IF G_ORG_SETUP_LAST_UPDATE_DATE IS NULL OR
564: G_ORG_SETUP_LAST_UPDATE_DATE <> l_last_update_date
565: THEN
566: G_ORG_SETUP_LAST_UPDATE_DATE := l_last_update_date;

Line 582: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' AND

578:
579: IF l_reload THEN
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

Line 591: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN

587:
588: -- load attribute names
589:
590: OPEN c_entity_dict(p_entity_name);
591: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN
592: FETCH c_entity_dict BULK COLLECT INTO
593: G_ORG_ATTRIBUTE_ID, G_ORG_ATTRIBUTE_NAME;
594: ELSE
595: FETCH c_entity_dict BULK COLLECT INTO

Line 663: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN

659: -- person and organization profile entity
660: -- setup seperately
661: -- G_ORG_SETUP_LOADED := 'Y';
662:
663: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN
664: G_ORG_SETUP_LOADED := 'Y';
665: -- Bug 4244112 : Added debug log
666: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
667: hz_utility_v2pub.debug(p_message=>'Loaded Organization Profiles',

Line 764: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN

760: -- can not cache real data source and exception type because
761: -- they are transactional data and should be cleared when
762: -- rollback.
763:
764: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN
765: OPEN c_exist_org_sst_profile(p_party_id);
766: FETCH c_exist_org_sst_profile INTO l_dummy;
767: IF c_exist_org_sst_profile%NOTFOUND THEN
768: l_dummy := 'N';

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 1131: l_entity_name := 'HZ_ORGANIZATION_PROFILES';

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;
1133: END IF;
1134:
1135: -- Debug info.

Line 1704: p_entity_name = 'HZ_ORGANIZATION_PROFILES'

1700:
1701: IF p_attribute_name IS NOT NULL THEN
1702: -- IF G_ORG_SETUP_LAST_UPDATE_DATE IS NOT NULL AND
1703: IF G_ORG_SETUP_LOADED = 'Y' AND
1704: p_entity_name = 'HZ_ORGANIZATION_PROFILES'
1705: THEN
1706: l_index := getIndex(G_ORG_ATTRIBUTE_NAME, UPPER(p_attribute_name));
1707:
1708: -- Debug info.

Line 1753: ELSIF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN

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
1756: l_index := getIndex(G_ENTITY_NAME, p_entity_name);
1757:

Line 2078: if p_entity = 'HZ_ORGANIZATION_PROFILES' THEN

2074: -- Bug 4244112 : Added to populate exceptions for case -
2075: -- DNB = 1, no DNB profile exists
2076: -- SBL = 3, creating SBL profile with value for this attribute
2077:
2078: if p_entity = 'HZ_ORGANIZATION_PROFILES' THEN
2079: BEGIN
2080: select '1' into l_tmp_d from hz_organization_profiles where party_id = p_party_id
2081: and actual_content_source = p_real_data_source_type
2082: -- Bug 4482630 : query only active profiles

Line 2080: select '1' into l_tmp_d from hz_organization_profiles where party_id = p_party_id

2076: -- SBL = 3, creating SBL profile with value for this attribute
2077:
2078: if p_entity = 'HZ_ORGANIZATION_PROFILES' THEN
2079: BEGIN
2080: select '1' into l_tmp_d from hz_organization_profiles where party_id = p_party_id
2081: and actual_content_source = p_real_data_source_type
2082: -- Bug 4482630 : query only active profiles
2083: and EFFECTIVE_END_DATE is NULL;
2084: exception

Line 2763: l_entity_name := 'HZ_ORGANIZATION_PROFILES';

2759: p_old_rec => HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
2760: x_name_list => l_name_list,
2761: x_new_value_is_null_list => l_null_list);
2762:
2763: l_entity_name := 'HZ_ORGANIZATION_PROFILES';
2764:
2765: ELSE -- 'PERSON'
2766:
2767: HZ_MIXNM_API_DYNAMIC_PKG.initAttributeList

Line 3029: * HZ_LOCATIONS etc. It can not be called on party profiles HZ_ORGANIZATION_PROFILES,

3025: * user-entered data for this entity.
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: *

Line 3262: * HZ_LOCATIONS etc. It can not be called on party profiles HZ_ORGANIZATION_PROFILES,

3258: * user-entered data for this entity.
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: *

Line 3495: * HZ_LOCATIONS etc. It can not be called on party profiles HZ_ORGANIZATION_PROFILES,

3491: * validation fails.
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: *

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 3660: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN

3656:
3657: IF p_entity_attr_id IS NULL OR
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

Line 3690: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN

3686: -- return cached value.
3687: RETURN G_MIXNM_ENABLED_FLAG(p_entity_attr_id);
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

Line 4136: p_entity_name => 'HZ_ORGANIZATION_PROFILES',

4132: -- return a updatable of all of attributes we passed in.
4133:
4134: areSSTColumnsUpdeable (
4135: p_party_id => p_party_id,
4136: p_entity_name => 'HZ_ORGANIZATION_PROFILES',
4137: p_attribute_name_list => l_name_list,
4138: p_value_is_null_list => l_sst_value_is_null_list,
4139: p_data_source_type => p_data_source_type,
4140: x_updatable_flag_list => l_updatable_flag_list,

Line 4662: FROM hz_organization_profiles

4658: AND rownum = 1;
4659:
4660: CURSOR c_org_parties IS
4661: SELECT distinct party_id
4662: FROM hz_organization_profiles
4663: WHERE effective_end_date IS NULL
4664: AND actual_content_source <> G_MISS_ACTUAL_CONTENT_SOURCE
4665: ORDER BY party_id;
4666:

Line 4694: OPEN c_prof_setup('HZ_ORGANIZATION_PROFILES');

4690: hz_mixnm_dynamic_pkg_generator.Gen_PackageForConc('HZ_MIXNM_CONC_DYNAMIC_PKG');
4691:
4692: x_process_org := true; x_org_total := 0;
4693:
4694: OPEN c_prof_setup('HZ_ORGANIZATION_PROFILES');
4695: FETCH c_prof_setup INTO l_dummy;
4696: IF c_prof_setup%NOTFOUND THEN
4697: x_process_org := false;
4698: 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 5147: WHERE e.entity_name = 'HZ_ORGANIZATION_PROFILES'

5143: DELETE hz_win_source_exceps
5144: WHERE entity_attr_id IN
5145: (SELECT e.entity_attr_id
5146: FROM hz_entity_attributes e, hz_select_data_sources s
5147: WHERE e.entity_name = 'HZ_ORGANIZATION_PROFILES'
5148: AND s.ranking > 0
5149: AND s.content_source_type = 'USER_ENTERED'
5150: AND e.entity_attr_id = s.entity_attr_id
5151: )

Line 5193: 'HZ_ORGANIZATION_PROFILES',

5189: Write_Log('l_per_party_per_worker = '||l_per_party_per_worker);
5190:
5191: IF l_process_org AND l_org_total <> 0 THEN
5192: CreateUpdatePartyProfiles (
5193: 'HZ_ORGANIZATION_PROFILES',
5194: l_process_org_mode,
5195: l_commit_size,
5196: l_org_party_per_worker,
5197: l_org_id_count,

Line 5216: l_process_org_mode||',HZ_ORGANIZATION_PROFILES',

5212: ELSE
5213: IF l_process_org AND l_org_total <> 0 THEN
5214: conc_sub (
5215: errbuf, retcode,
5216: l_process_org_mode||',HZ_ORGANIZATION_PROFILES',
5217: l_org_id_start(1),
5218: l_org_id_end(l_org_id_end.COUNT),
5219: l_commit_size);
5220: END IF;

Line 5325: IF l_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN

5321: l_process_mode := SUBSTRB(p_entity_type, 1, l_pos1-1);
5322: l_entity_name := SUBSTRB(p_entity_type, l_pos1+1, LENGTHB(p_entity_type)-l_pos1);
5323:
5324: IF l_process_mode = 'C' THEN
5325: IF l_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN
5326: Write_Log('HZ_MIXNM_CONC_DYNAMIC_PKG.BulkCreateOrgSST('||l_from_id||', '||l_to_id||', '||l_commit_size||');');
5327: HZ_MIXNM_CONC_DYNAMIC_PKG.BulkCreateOrgSST(l_from_id, l_to_id, l_commit_size);
5328: ELSE
5329: Write_Log('HZ_MIXNM_CONC_DYNAMIC_PKG.BulkCreatePerSST('||l_from_id||', '||l_to_id||', '||l_commit_size||');');

Line 5333: IF l_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN

5329: Write_Log('HZ_MIXNM_CONC_DYNAMIC_PKG.BulkCreatePerSST('||l_from_id||', '||l_to_id||', '||l_commit_size||');');
5330: HZ_MIXNM_CONC_DYNAMIC_PKG.BulkCreatePersonSST(l_from_id, l_to_id, l_commit_size);
5331: END IF;
5332: ELSE
5333: IF l_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN
5334: Write_Log('HZ_MIXNM_CONC_DYNAMIC_PKG.BulkUpdateOrgSST('||l_from_id||', '||l_to_id||', '||l_commit_size||');');
5335: HZ_MIXNM_CONC_DYNAMIC_PKG.BulkUpdateOrgSST(l_from_id, l_to_id, l_commit_size);
5336: ELSE
5337: Write_Log('HZ_MIXNM_CONC_DYNAMIC_PKG.BulkUpdatePerSST('||l_from_id||', '||l_to_id||', '||l_commit_size||');');