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 372: FROM hz_organization_profiles

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

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

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

Line 585: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' AND

581:
582: IF l_reload THEN
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

Line 594: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN

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

Line 666: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN

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

Line 767: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN

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

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

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;
1136: END IF;
1137:
1138: -- Debug info.

Line 1714: p_entity_name = 'HZ_ORGANIZATION_PROFILES'

1710:
1711: IF p_attribute_name IS NOT NULL THEN
1712: -- IF G_ORG_SETUP_LAST_UPDATE_DATE IS NOT NULL AND
1713: IF G_ORG_SETUP_LOADED = 'Y' AND
1714: p_entity_name = 'HZ_ORGANIZATION_PROFILES'
1715: THEN
1716: l_index := getIndex(G_ORG_ATTRIBUTE_NAME, UPPER(p_attribute_name));
1717:
1718: -- Debug info.

Line 1763: ELSIF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN

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

Line 2088: if p_entity = 'HZ_ORGANIZATION_PROFILES' THEN

2084: -- Bug 4244112 : Added to populate exceptions for case -
2085: -- DNB = 1, no DNB profile exists
2086: -- SBL = 3, creating SBL profile with value for this attribute
2087:
2088: if p_entity = 'HZ_ORGANIZATION_PROFILES' THEN
2089: BEGIN
2090: select '1' into l_tmp_d from hz_organization_profiles where party_id = p_party_id
2091: and actual_content_source = p_real_data_source_type
2092: -- Bug 4482630 : query only active profiles

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

2086: -- SBL = 3, creating SBL profile with value for this attribute
2087:
2088: if p_entity = 'HZ_ORGANIZATION_PROFILES' THEN
2089: BEGIN
2090: select '1' into l_tmp_d from hz_organization_profiles where party_id = p_party_id
2091: and actual_content_source = p_real_data_source_type
2092: -- Bug 4482630 : query only active profiles
2093: and EFFECTIVE_END_DATE is NULL;
2094: exception

Line 2773: l_entity_name := 'HZ_ORGANIZATION_PROFILES';

2769: p_old_rec => HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC,
2770: x_name_list => l_name_list,
2771: x_new_value_is_null_list => l_null_list);
2772:
2773: l_entity_name := 'HZ_ORGANIZATION_PROFILES';
2774:
2775: ELSE -- 'PERSON'
2776:
2777: HZ_MIXNM_API_DYNAMIC_PKG.initAttributeList

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

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

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

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

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

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

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

3666:
3667: IF p_entity_attr_id IS NULL OR
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

Line 3700: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN

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

Line 4146: p_entity_name => 'HZ_ORGANIZATION_PROFILES',

4142: -- return a updatable of all of attributes we passed in.
4143:
4144: areSSTColumnsUpdeable (
4145: p_party_id => p_party_id,
4146: p_entity_name => 'HZ_ORGANIZATION_PROFILES',
4147: p_attribute_name_list => l_name_list,
4148: p_value_is_null_list => l_sst_value_is_null_list,
4149: p_data_source_type => p_data_source_type,
4150: x_updatable_flag_list => l_updatable_flag_list,

Line 4672: FROM hz_organization_profiles

4668: AND rownum = 1;
4669:
4670: CURSOR c_org_parties IS
4671: SELECT distinct party_id
4672: FROM hz_organization_profiles
4673: WHERE effective_end_date IS NULL
4674: AND actual_content_source <> G_MISS_ACTUAL_CONTENT_SOURCE
4675: ORDER BY party_id;
4676:

Line 4704: OPEN c_prof_setup('HZ_ORGANIZATION_PROFILES');

4700: hz_mixnm_dynamic_pkg_generator.Gen_PackageForConc('HZ_MIXNM_CONC_DYNAMIC_PKG');
4701:
4702: x_process_org := true; x_org_total := 0;
4703:
4704: OPEN c_prof_setup('HZ_ORGANIZATION_PROFILES');
4705: FETCH c_prof_setup INTO l_dummy;
4706: IF c_prof_setup%NOTFOUND THEN
4707: x_process_org := false;
4708: 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 5177: WHERE e.entity_name = 'HZ_ORGANIZATION_PROFILES'

5173: DELETE hz_win_source_exceps
5174: WHERE entity_attr_id IN
5175: (SELECT e.entity_attr_id
5176: FROM hz_entity_attributes e, hz_select_data_sources s
5177: WHERE e.entity_name = 'HZ_ORGANIZATION_PROFILES'
5178: AND s.ranking > 0
5179: AND s.content_source_type = 'USER_ENTERED'
5180: AND e.entity_attr_id = s.entity_attr_id
5181: )

Line 5223: 'HZ_ORGANIZATION_PROFILES',

5219: Write_Log('l_per_party_per_worker = '||l_per_party_per_worker);
5220:
5221: IF l_process_org AND l_org_total <> 0 THEN
5222: CreateUpdatePartyProfiles (
5223: 'HZ_ORGANIZATION_PROFILES',
5224: l_process_org_mode,
5225: l_commit_size,
5226: l_org_party_per_worker,
5227: l_org_id_count,

Line 5246: l_process_org_mode||',HZ_ORGANIZATION_PROFILES',

5242: ELSE
5243: IF l_process_org AND l_org_total <> 0 THEN
5244: conc_sub (
5245: errbuf, retcode,
5246: l_process_org_mode||',HZ_ORGANIZATION_PROFILES',
5247: l_org_id_start(1),
5248: l_org_id_end(l_org_id_end.COUNT),
5249: l_commit_size);
5250: END IF;

Line 5356: IF l_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN

5352: l_process_mode := SUBSTRB(p_entity_type, 1, l_pos1-1);
5353: l_entity_name := SUBSTRB(p_entity_type, l_pos1+1, LENGTHB(p_entity_type)-l_pos1);
5354:
5355: IF l_process_mode = 'C' THEN
5356: IF l_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN
5357: Write_Log('HZ_MIXNM_CONC_DYNAMIC_PKG.BulkCreateOrgSST('||l_from_id||', '||l_to_id||', '||l_commit_size||');');
5358: HZ_MIXNM_CONC_DYNAMIC_PKG.BulkCreateOrgSST(l_from_id, l_to_id, l_commit_size);
5359: ELSE
5360: Write_Log('HZ_MIXNM_CONC_DYNAMIC_PKG.BulkCreatePerSST('||l_from_id||', '||l_to_id||', '||l_commit_size||');');

Line 5364: IF l_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN

5360: Write_Log('HZ_MIXNM_CONC_DYNAMIC_PKG.BulkCreatePerSST('||l_from_id||', '||l_to_id||', '||l_commit_size||');');
5361: HZ_MIXNM_CONC_DYNAMIC_PKG.BulkCreatePersonSST(l_from_id, l_to_id, l_commit_size);
5362: END IF;
5363: ELSE
5364: IF l_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN
5365: Write_Log('HZ_MIXNM_CONC_DYNAMIC_PKG.BulkUpdateOrgSST('||l_from_id||', '||l_to_id||', '||l_commit_size||');');
5366: HZ_MIXNM_CONC_DYNAMIC_PKG.BulkUpdateOrgSST(l_from_id, l_to_id, l_commit_size);
5367: ELSE
5368: Write_Log('HZ_MIXNM_CONC_DYNAMIC_PKG.BulkUpdatePerSST('||l_from_id||', '||l_to_id||', '||l_commit_size||');');