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 333: FROM hz_entity_attributes

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

Line 343: FROM hz_entity_attributes e

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

Line 355: FROM hz_entity_attributes e,

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

Line 394: FROM hz_entity_attributes e,

390: ) IS
391: SELECT e.entity_attr_id,
392: NVL(exp.content_source_type, s1.content_source_type),
393: exp.exception_type
394: FROM hz_entity_attributes e,
395: hz_select_data_sources s1,
396: (SELECT entity_attr_id,
397: content_source_type,
398: exception_type

Line 416: FROM hz_entity_attributes e,

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

Line 897: FROM hz_entity_attributes;

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

Line 904: FROM hz_entity_attributes e

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

Line 916: FROM hz_entity_attributes e,

912:
913: CURSOR c_data_source_other IS
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

Line 929: FROM hz_entity_attributes e,

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

Line 2072: select entity_name into p_entity from hz_entity_attributes

2068:
2069: END IF;
2070: ELSE
2071:
2072: select entity_name into p_entity from hz_entity_attributes
2073: where entity_attr_id = p_entity_attr_id;
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

Line 3707: from hz_select_data_sources d, hz_entity_attributes e

3703: -- check if policy exists.
3704: -- bug fix 2731008
3705: BEGIN
3706: select 'Y' into l_src_selected
3707: from hz_select_data_sources d, hz_entity_attributes e
3708: where e.entity_attr_id = d.entity_attr_id
3709: and UPPER(e.entity_name) = UPPER(p_entity_name)
3710: and d.content_source_type <> G_MISS_CONTENT_SOURCE_TYPE
3711: and d.ranking > 0

Line 4584: * Reset updated flag in hz_entity_attributes.

4580: /**
4581: * PRIVATE PROCEDURE ResetUpdatedFlag
4582: *
4583: * DESCRIPTION
4584: * Reset updated flag in hz_entity_attributes.
4585: *
4586: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
4587: *
4588: * MODIFICATION HISTORY

Line 4595: UPDATE hz_entity_attributes

4591: */
4592:
4593: PROCEDURE ResetUpdatedFlag IS
4594: BEGIN
4595: UPDATE hz_entity_attributes
4596: SET updated_flag = 'N',
4597: last_updated_by = hz_utility_v2pub.last_updated_by,
4598: last_update_login = hz_utility_v2pub.last_update_login,
4599: last_update_date = SYSDATE,

Line 4655: FROM hz_entity_attributes e

4651: CURSOR c_prof_setup (
4652: p_entity_name VARCHAR2
4653: ) IS
4654: SELECT 'Y'
4655: FROM hz_entity_attributes e
4656: WHERE e.updated_flag = 'Y'
4657: AND e.entity_name = p_entity_name
4658: AND rownum = 1;
4659:

Line 4910: FROM hz_entity_attributes e

4906: CURSOR c_other_setup (
4907: p_entity_name VARCHAR2
4908: ) IS
4909: SELECT 'Y'
4910: FROM hz_entity_attributes e
4911: WHERE e.updated_flag = 'Y'
4912: AND e.entity_name = p_entity_name;
4913:
4914: l_dummy VARCHAR2(1);

Line 5036: FROM hz_entity_attributes e

5032: ) IS
5033:
5034: CURSOR c_setup IS
5035: SELECT 'Y'
5036: FROM hz_entity_attributes e
5037: WHERE e.updated_flag = 'Y'
5038: AND rownum = 1;
5039:
5040: CURSOR c_prof_setup IS

Line 5042: FROM hz_entity_attributes e

5038: AND rownum = 1;
5039:
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:

Line 5051: FROM hz_entity_attributes e,

5047: l_process_profile BOOLEAN := true;
5048:
5049: CURSOR c_other_setup IS
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;

Line 5061: FROM hz_entity_attributes e

5057: l_process_other_entities BOOLEAN := true;
5058:
5059: CURSOR c_entities IS
5060: SELECT UNIQUE e.entity_name
5061: FROM hz_entity_attributes e
5062: WHERE e.updated_flag = 'Y'
5063: -- SSM SST Integration and Extension
5064: -- Only profile entities will be passed for policy function.
5065: AND e.attribute_name is not null;

Line 5146: FROM hz_entity_attributes e, hz_select_data_sources s

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

Line 5158: FROM hz_entity_attributes e, hz_select_data_sources s

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

Line 5259: -- reset updated flag in hz_entity_attributes.

5255:
5256: AddPolicy(i_entities);
5257: END IF;
5258:
5259: -- reset updated flag in hz_entity_attributes.
5260: ResetUpdatedFlag;
5261:
5262: EXCEPTION
5263: WHEN OTHERS THEN

Line 5363: from hz_entity_attributes e, hz_select_data_sources s

5359: )IS
5360:
5361: cursor mmr_attributes IS
5362: select e.entity_attr_id, s.content_source_type
5363: from hz_entity_attributes e, hz_select_data_sources s
5364: where s.ranking = -1
5365: AND e.entity_name = p_entity_name
5366: AND e.entity_attr_id = s.entity_attr_id
5367: AND (s.content_source_type= p_data_source_type or

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

5373: AND NOT EXISTS(select 'Y' from hz_win_source_exceps
5374: where party_id = p_party_id
5375: and entity_attr_id = e.entity_attr_id);
5376:
5377: TYPE ATTR_IDList IS TABLE OF hz_entity_attributes.entity_attr_id%TYPE;
5378: TYPE SOURCE_List IS TABLE OF hz_select_data_sources.content_source_type%TYPE;
5379: I_ATTR_ID ATTR_IDList;
5380: I_SOURCE SOURCE_List;
5381:

Line 5486: from hz_entity_attributes

5482: ) Return VARCHAR2 IS
5483:
5484: cursor meaning is
5485: select attribute_name
5486: from hz_entity_attributes
5487: where attribute_group_name = p_group
5488: and entity_name = p_entity;
5489:
5490: l_str VARCHAR2(1000);