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_ENTITY_ATTRIBUTES

Line 336: FROM hz_entity_attributes

332: CURSOR c_profile_last_update_date (
333: p_entity_name VARCHAR2
334: ) IS
335: SELECT max(last_update_date) last_update_date
336: FROM hz_entity_attributes
337: WHERE entity_name = p_entity_name;
338: */
339:
340: -- load attribute names in setup table for party profiles

Line 346: FROM hz_entity_attributes e

342: CURSOR c_entity_dict (
343: p_entity_name VARCHAR2
344: ) IS
345: SELECT e.entity_attr_id, e.attribute_name
346: FROM hz_entity_attributes e
347: WHERE e.entity_name = p_entity_name
348: ORDER BY e.attribute_name;
349:
350: -- load data source ranking in setup table for party profiles

Line 358: FROM hz_entity_attributes e,

354: ) IS
355: SELECT s.entity_attr_id,
356: s.content_source_type,
357: s.ranking
358: FROM hz_entity_attributes e,
359: hz_select_data_sources s
360: WHERE e.entity_name = p_entity_name
361: AND s.entity_attr_id = e.entity_attr_id
362: AND s.ranking <> 0;

Line 397: FROM hz_entity_attributes e,

393: ) IS
394: SELECT e.entity_attr_id,
395: NVL(exp.content_source_type, s1.content_source_type),
396: exp.exception_type
397: FROM hz_entity_attributes e,
398: hz_select_data_sources s1,
399: (SELECT entity_attr_id,
400: content_source_type,
401: exception_type

Line 419: FROM hz_entity_attributes e,

415: ) IS
416: SELECT e.entity_attr_id,
417: NVL(exp.content_source_type, 'USER_ENTERED'),
418: exp.exception_type
419: FROM hz_entity_attributes e,
420: (SELECT entity_attr_id,
421: content_source_type,
422: exception_type
423: FROM hz_win_source_exceps

Line 900: FROM hz_entity_attributes;

896: -- load last update date for data source' setup
897:
898: CURSOR c_datasource_last_update_date IS
899: SELECT max(last_update_date) last_update_date
900: FROM hz_entity_attributes;
901: */
902:
903: -- load entity names in setup table for other entities
904:

Line 907: FROM hz_entity_attributes e

903: -- load entity names in setup table for other entities
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

Line 919: FROM hz_entity_attributes e,

915:
916: CURSOR c_data_source_other IS
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

Line 932: FROM hz_entity_attributes e,

928: CURSOR c_data_source_profile (
929: p_entity_name VARCHAR2
930: ) IS
931: SELECT UNIQUE s.content_source_type
932: FROM hz_entity_attributes e,
933: hz_select_data_sources s
934: WHERE e.entity_name = p_entity_name
935: AND s.entity_attr_id = e.entity_attr_id
936: AND s.ranking <> 0; -- SSM SST Integration and Extension -->> ranking of -1 denotes MRR

Line 2082: select entity_name into p_entity from hz_entity_attributes

2078:
2079: END IF;
2080: ELSE
2081:
2082: select entity_name into p_entity from hz_entity_attributes
2083: where entity_attr_id = p_entity_attr_id;
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

Line 3717: from hz_select_data_sources d, hz_entity_attributes e

3713: -- check if policy exists.
3714: -- bug fix 2731008
3715: BEGIN
3716: select 'Y' into l_src_selected
3717: from hz_select_data_sources d, hz_entity_attributes e
3718: where e.entity_attr_id = d.entity_attr_id
3719: and UPPER(e.entity_name) = UPPER(p_entity_name)
3720: and d.content_source_type <> G_MISS_CONTENT_SOURCE_TYPE
3721: and d.ranking > 0

Line 4594: * Reset updated flag in hz_entity_attributes.

4590: /**
4591: * PRIVATE PROCEDURE ResetUpdatedFlag
4592: *
4593: * DESCRIPTION
4594: * Reset updated flag in hz_entity_attributes.
4595: *
4596: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
4597: *
4598: * MODIFICATION HISTORY

Line 4605: UPDATE hz_entity_attributes

4601: */
4602:
4603: PROCEDURE ResetUpdatedFlag IS
4604: BEGIN
4605: UPDATE hz_entity_attributes
4606: SET updated_flag = 'N',
4607: last_updated_by = hz_utility_v2pub.last_updated_by,
4608: last_update_login = hz_utility_v2pub.last_update_login,
4609: last_update_date = SYSDATE,

Line 4665: FROM hz_entity_attributes e

4661: CURSOR c_prof_setup (
4662: p_entity_name VARCHAR2
4663: ) IS
4664: SELECT 'Y'
4665: FROM hz_entity_attributes e
4666: WHERE e.updated_flag = 'Y'
4667: AND e.entity_name = p_entity_name
4668: AND rownum = 1;
4669:

Line 4920: FROM hz_entity_attributes e

4916: CURSOR c_other_setup (
4917: p_entity_name VARCHAR2
4918: ) IS
4919: SELECT 'Y'
4920: FROM hz_entity_attributes e
4921: WHERE e.updated_flag = 'Y'
4922: AND e.entity_name = p_entity_name;
4923:
4924: l_dummy VARCHAR2(1);

Line 5049: FROM hz_entity_attributes e

5045: ) IS
5046:
5047: CURSOR c_setup IS
5048: SELECT 'Y'
5049: FROM hz_entity_attributes e
5050: WHERE e.updated_flag = 'Y'
5051: AND rownum = 1;
5052:
5053: CURSOR c_prof_setup IS

Line 5055: FROM hz_entity_attributes e

5051: AND rownum = 1;
5052:
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:

Line 5064: FROM hz_entity_attributes e,

5060: l_process_profile BOOLEAN := true;
5061:
5062: CURSOR c_other_setup IS
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;

Line 5074: FROM hz_entity_attributes e

5070: l_process_other_entities BOOLEAN := true;
5071:
5072: CURSOR c_entities IS
5073: SELECT UNIQUE e.entity_name
5074: FROM hz_entity_attributes e
5075: WHERE e.updated_flag = 'Y'
5076: -- SSM SST Integration and Extension
5077: -- Only profile entities will be passed for policy function.
5078: AND e.attribute_name is not null;

Line 5176: FROM hz_entity_attributes e, hz_select_data_sources s

5172: IF l_process_org AND l_org_total <> 0 THEN
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

Line 5188: FROM hz_entity_attributes e, hz_select_data_sources s

5184: IF l_process_person AND l_per_total <> 0 THEN
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

Line 5289: -- reset updated flag in hz_entity_attributes.

5285:
5286: AddPolicy(i_entities);
5287: END IF;
5288:
5289: -- reset updated flag in hz_entity_attributes.
5290: ResetUpdatedFlag;
5291: END IF; -- Running Mode
5292:
5293: EXCEPTION

Line 5394: from hz_entity_attributes e, hz_select_data_sources s

5390: )IS
5391:
5392: cursor mmr_attributes IS
5393: select e.entity_attr_id, s.content_source_type
5394: from hz_entity_attributes e, hz_select_data_sources s
5395: where s.ranking = -1
5396: AND e.entity_name = p_entity_name
5397: AND e.entity_attr_id = s.entity_attr_id
5398: AND (s.content_source_type= p_data_source_type or

Line 5408: TYPE ATTR_IDList IS TABLE OF hz_entity_attributes.entity_attr_id%TYPE;

5404: AND NOT EXISTS(select 'Y' from hz_win_source_exceps
5405: where party_id = p_party_id
5406: and entity_attr_id = e.entity_attr_id);
5407:
5408: TYPE ATTR_IDList IS TABLE OF hz_entity_attributes.entity_attr_id%TYPE;
5409: TYPE SOURCE_List IS TABLE OF hz_select_data_sources.content_source_type%TYPE;
5410: I_ATTR_ID ATTR_IDList;
5411: I_SOURCE SOURCE_List;
5412:

Line 5517: from hz_entity_attributes

5513: ) Return VARCHAR2 IS
5514:
5515: cursor meaning is
5516: select attribute_name
5517: from hz_entity_attributes
5518: where attribute_group_name = p_group
5519: and entity_name = p_entity;
5520:
5521: l_str VARCHAR2(1000);

Line 5553: FROM hz_entity_attributes

5549: PROCEDURE generate_mixnm_dynm_pkg IS
5550:
5551: CURSOR c_attributes IS
5552: SELECT 'Y'
5553: FROM hz_entity_attributes
5554: WHERE updated_flag = 'Y'
5555: AND ROWNUM = 1;
5556:
5557: l_dummy VARCHAR2(1);

Line 5572: UPDATE hz_entity_attributes

5568: OPEN c_attributes;
5569: FETCH c_attributes INTO l_dummy;
5570:
5571: IF c_attributes%NOTFOUND THEN
5572: UPDATE hz_entity_attributes
5573: SET updated_flag = 'Y';
5574:
5575: -- Debug info.
5576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5602: UPDATE hz_entity_attributes

5598: p_msg_level=>fnd_log.level_procedure);
5599: END IF;
5600:
5601: IF c_attributes%NOTFOUND THEN
5602: UPDATE hz_entity_attributes
5603: SET updated_flag = 'N';
5604:
5605: -- Debug info.
5606: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN