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_MERGE_ENTITY_ATTRI_PVT dependencies on HZ_PERSON_PROFILES

Line 26: FROM HZ_PERSON_PROFILES PP,HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB

22:
23: function get_healthCarePartyId(p_merge_batch_id in number) return number is
24: cursor get_healthCarePartyId_csr is
25: SELECT PP.PARTY_ID
26: FROM HZ_PERSON_PROFILES PP,HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB
27: WHERE PP.PARTY_ID =DSP.DUP_PARTY_ID
28: AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
29: AND DS.DUP_SET_ID = DSP.DUP_SET_ID
30: AND sysdate between pp.effective_start_date and nvl(pp.effective_end_date,sysdate)

Line 47: FROM HZ_PERSON_PROFILES PP,HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB

43:
44: function get_InternalFlagPartyId(p_merge_batch_id in number,p_entity_name in VARCHAR2) return number is
45: cursor get_PPInternalFlagPartyId_csr is
46: SELECT PP.PARTY_ID
47: FROM HZ_PERSON_PROFILES PP,HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB
48: WHERE PP.PARTY_ID =DSP.DUP_PARTY_ID
49: AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
50: AND DS.DUP_SET_ID = DSP.DUP_SET_ID
51: AND sysdate between pp.effective_start_date and nvl(pp.effective_end_date,sysdate)

Line 70: if p_entity_name = 'HZ_PERSON_PROFILES' then

66: AND ROWNUM = 1;
67:
68: l_party_id number;
69: begin
70: if p_entity_name = 'HZ_PERSON_PROFILES' then
71: open get_PPInternalFlagPartyId_csr;
72: fetch get_PPInternalFlagPartyId_csr into l_party_id;
73: close get_PPInternalFlagPartyId_csr;
74: end if;

Line 508: and entity_name = 'HZ_PERSON_PROFILES'

504: cursor get_person_rec_csr is
505: select attribute_name, attribute_value, attribute_type
506: from HZ_MERGE_ENTITY_ATTRIBUTES
507: where merge_to_party_id = p_merge_to_party_id
508: and entity_name = 'HZ_PERSON_PROFILES'
509: and merge_batch_id = p_merge_batch_id;
510:
511: l_attribute_name varchar2(30);
512: l_attribute_value varchar2(2000);

Line 895: elsif p_entity_name = 'HZ_PERSON_PROFILES' then

891: object_version_number = nvl(object_version_number,1)+1
892: where party_id = p_merge_to_party_id
893: and sysdate between effective_start_date and nvl(effective_end_date,sysdate);
894: end if; -- if l_automerge_flag = 'N'
895: elsif p_entity_name = 'HZ_PERSON_PROFILES' then
896: if l_automerge_flag = 'N' or (l_automerge_flag = 'Y' and nvl(fnd_profile.value('HZ_PROF_ATTR_DEFAULT'), 'MASTER') <> 'MASTER')
897: then
898: open get_obj_version_csr;
899: fetch get_obj_version_csr into l_object_version_number, l_orig_sys_ref;

Line 921: update hz_person_profiles

917: l_party_id :=null;
918: l_party_id := get_healthCarePartyId(p_merge_batch_id);
919: if l_party_id is not null
920: then
921: update hz_person_profiles
922: set created_by_module = 'CTB_PERSON_REGISTRY_SERVICES',
923: last_update_date = SYSDATE,
924: last_update_login = FND_GLOBAL.LOGIN_ID,
925: last_updated_by = FND_GLOBAL.USER_ID,

Line 1016: elsif p_entity_name = 'HZ_PERSON_PROFILES'

1012: begin
1013: if p_entity_name = 'HZ_ORGANIZATION_PROFILES'
1014: then
1015: l_lookup_type := 'ORG_PROFILE_CATEGORY';
1016: elsif p_entity_name = 'HZ_PERSON_PROFILES'
1017: then l_lookup_type := 'PERSON_PROFILE_CATEGORY';
1018: end if;
1019: open get_group_attributes_csr(p_attribute_name,l_lookup_type);
1020: loop

Line 1114: from hz_person_profiles pro, hz_merge_parties mp

1110:
1111: -- get candidate parties with desc order for last update date
1112: cursor get_per_candidate_party_csr is
1113: select mp.from_party_id, pro.last_update_date
1114: from hz_person_profiles pro, hz_merge_parties mp
1115: where pro.party_id = mp.from_party_id
1116: and mp.batch_id = p_merge_batch_id
1117: and sysdate between pro.effective_start_date and nvl(pro.effective_end_date,sysdate)
1118: order by pro.last_update_date desc;

Line 1123: from hz_person_profiles pro, hz_merge_parties mp

1119:
1120: -- get candidate parties with desc order for last creation date
1121: cursor get_per_candidate_party_lc_csr is
1122: select mp.from_party_id, pro.last_update_date
1123: from hz_person_profiles pro, hz_merge_parties mp
1124: where pro.party_id = mp.from_party_id
1125: and mp.batch_id = p_merge_batch_id
1126: and sysdate between pro.effective_start_date and nvl(pro.effective_end_date,sysdate)
1127: order by pro.creation_date desc, pro.party_id desc;

Line 1132: from hz_person_profiles pro, hz_merge_parties mp

1128:
1129: -- get candidate parties with desc order for earlist creation date
1130: cursor get_per_candidate_party_ec_csr is
1131: select mp.from_party_id, pro.last_update_date
1132: from hz_person_profiles pro, hz_merge_parties mp
1133: where pro.party_id = mp.from_party_id
1134: and mp.batch_id = p_merge_batch_id
1135: and sysdate between pro.effective_start_date and nvl(pro.effective_end_date,sysdate)
1136: order by pro.creation_date, pro.party_id;

Line 1266: elsif p_entity_name = 'HZ_PERSON_PROFILES'

1262: end if; -- earliest creation date case
1263:
1264: end loop;
1265: close get_leader_attribute_name_csr;
1266: elsif p_entity_name = 'HZ_PERSON_PROFILES'
1267: then
1268: open get_leader_attribute_name_csr('PERSON_PROFILE_CATEGORY');
1269: loop
1270: fetch get_leader_attribute_name_csr into l_attribute_name;

Line 1481: ' from HZ_PERSON_PROFILES OP,HZ_PARTIES PARTY, HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB '||

1477: else -- PERSON CASE
1478: l_str := 'select party_id, decode('''||l_col_type||''',''D'',to_char(attri_value,''YYYY/MM/DD''),attri_value) from '||
1479: '(SELECT party_id, attri_value, rank() over (order by cntAttri desc) rank, '||l_date_clause || ' from '||
1480: '(SELECT OP.PARTY_ID, OP.'||l_col_name||' attri_value, count(*) over (partition by OP.'||l_col_name||') as cntAttri, '||'op.'||l_date_clause||
1481: ' from HZ_PERSON_PROFILES OP,HZ_PARTIES PARTY, HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB '||
1482: 'WHERE OP.PARTY_ID =DSP.DUP_PARTY_ID AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID '||
1483: 'AND DS.DUP_SET_ID = DSP.DUP_SET_ID AND OP.PARTY_ID = PARTY.PARTY_ID '||
1484: 'AND sysdate between effective_start_date and nvl(effective_end_date,sysdate) '||
1485: 'AND OP.'||l_col_name||' is not null '||

Line 1613: if p_entity_name not in ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')

1609: savepoint create_merge_attributes_pvt;
1610: -- Initialize return status to SUCCESS
1611: x_return_status := FND_API.G_RET_STS_SUCCESS;
1612:
1613: if p_entity_name not in ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')
1614: then
1615: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_ENTITY_NAME' );
1616: FND_MSG_PUB.ADD;
1617: RAISE FND_API.G_EXC_ERROR;

Line 1758: if p_entity_name = 'HZ_PERSON_PROFILES' then

1754: p_merge_batch_id => p_merge_batch_id,
1755: p_merge_to_party_id => p_merge_to_party_id,
1756: p_entity_name => p_entity_name);
1757:
1758: if p_entity_name = 'HZ_PERSON_PROFILES' then
1759: l_party_id :=null;
1760: l_party_id := get_healthCarePartyId(p_merge_batch_id);
1761: if l_party_id is not null then
1762: update HZ_MERGE_ENTITY_ATTRIBUTES

Line 1878: from hz_person_profiles

1874: and sysdate between effective_start_date and nvl(effective_end_date,sysdate);
1875:
1876: cursor get_per_last_update_date_csr is
1877: select last_update_date
1878: from hz_person_profiles
1879: where party_id = p_attribute_party_id
1880: and sysdate between effective_start_date and nvl(effective_end_date,sysdate);
1881:
1882: l_object_version_number number;

Line 1895: elsif p_entity_name = 'HZ_PERSON_PROFILES'

1891:
1892: if p_entity_name = 'HZ_ORGANIZATION_PROFILES'
1893: then
1894: l_lookup_type := 'ORG_PROFILE_CATEGORY';
1895: elsif p_entity_name = 'HZ_PERSON_PROFILES'
1896: then l_lookup_type := 'PERSON_PROFILE_CATEGORY';
1897: end if;
1898:
1899: if is_leading_attribute(p_attribute_name,l_lookup_type) = 'N'

Line 1927: elsif p_entity_name = 'HZ_PERSON_PROFILES'

1923: then
1924: open get_org_last_update_date_csr;
1925: fetch get_org_last_update_date_csr into l_last_update_date;
1926: close get_org_last_update_date_csr;
1927: elsif p_entity_name = 'HZ_PERSON_PROFILES'
1928: then
1929: open get_per_last_update_date_csr;
1930: fetch get_per_last_update_date_csr into l_last_update_date;
1931: close get_per_last_update_date_csr;

Line 2092: from hz_person_profiles

2088: and sysdate between effective_start_date and nvl(effective_end_date,sysdate);
2089:
2090: cursor get_per_last_update_date_csr is
2091: select last_update_date
2092: from hz_person_profiles
2093: where party_id = p_attribute_party_id
2094: and sysdate between effective_start_date and nvl(effective_end_date,sysdate);
2095: l_last_update_date date;
2096: begin

Line 2102: elsif p_entity_name = 'HZ_PERSON_PROFILES'

2098: then
2099: open get_org_last_update_date_csr;
2100: fetch get_org_last_update_date_csr into l_last_update_date;
2101: close get_org_last_update_date_csr;
2102: elsif p_entity_name = 'HZ_PERSON_PROFILES'
2103: then
2104: open get_per_last_update_date_csr;
2105: fetch get_per_last_update_date_csr into l_last_update_date;
2106: close get_per_last_update_date_csr;

Line 2130: from hz_person_profiles

2126: from hz_merge_entity_attributes
2127: where merge_batch_id = p_merge_batch_id
2128: and attribute_party_id = l_attribute_party_id and rownum = 1
2129: and derived_last_update_date <> (select last_update_date
2130: from hz_person_profiles
2131: where party_Id = l_attribute_party_id
2132: and sysdate between effective_start_date and nvl(effective_end_date,sysdate));
2133: cursor get_attri_party_id_csr is
2134: select distinct attribute_party_id

Line 2156: elsif p_entity_name = 'HZ_PERSON_PROFILES'

2152: close org_party_data_changed_csr;
2153: return 'Y';
2154: end if;
2155: close org_party_data_changed_csr;
2156: elsif p_entity_name = 'HZ_PERSON_PROFILES'
2157: then
2158: open person_party_data_changed_csr(l_attribute_party_id);
2159: fetch person_party_data_changed_csr into l_tmp;
2160: if person_party_data_changed_csr%FOUND