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_DUP_PVT dependencies on HZ_MERGE_UTIL

Line 683: HZ_MERGE_UTIL.get_reln_party_id(p_from_entity_id);

679: CLOSE c_cust_site_check;
680: ELSIF p_entity = 'HZ_PARTY_RELATIONSHIPS' then
681:
682: l_from_rel_party_id :=
683: HZ_MERGE_UTIL.get_reln_party_id(p_from_entity_id);
684: l_to_rel_party_id :=
685: HZ_MERGE_UTIL.get_reln_party_id(p_to_entity_id);
686:
687: SELECT count(*) into l_rel_party_count

Line 685: HZ_MERGE_UTIL.get_reln_party_id(p_to_entity_id);

681:
682: l_from_rel_party_id :=
683: HZ_MERGE_UTIL.get_reln_party_id(p_from_entity_id);
684: l_to_rel_party_id :=
685: HZ_MERGE_UTIL.get_reln_party_id(p_to_entity_id);
686:
687: SELECT count(*) into l_rel_party_count
688: FROM hz_merge_parties
689: WHERE batch_id = l_batch_id

Line 1196: HZ_MERGE_UTIL.get_reln_party_id(p_from_entity_id);

1192: hz_utility_v2pub.last_updated_by);
1193:
1194:
1195: l_from_rel_party_id :=
1196: HZ_MERGE_UTIL.get_reln_party_id(p_from_entity_id);
1197: l_to_rel_party_id :=
1198: HZ_MERGE_UTIL.get_reln_party_id(p_to_entity_id);
1199:
1200: SELECT count(1) INTO l_rel_party_count

Line 1198: HZ_MERGE_UTIL.get_reln_party_id(p_to_entity_id);

1194:
1195: l_from_rel_party_id :=
1196: HZ_MERGE_UTIL.get_reln_party_id(p_from_entity_id);
1197: l_to_rel_party_id :=
1198: HZ_MERGE_UTIL.get_reln_party_id(p_to_entity_id);
1199:
1200: SELECT count(1) INTO l_rel_party_count
1201: FROM hz_merge_parties
1202: WHERE batch_id = l_batch_id

Line 1242: HZ_MERGE_UTIL.get_reln_party_id(p_from_entity_id);

1238: HZ_MERGE_PARTY_DETAILS_PKG.delete_row(
1239: p_batch_party_id, 'HZ_PARTY_RELATIONSHIPS', p_from_entity_id);
1240:
1241: l_from_rel_party_id :=
1242: HZ_MERGE_UTIL.get_reln_party_id(p_from_entity_id);
1243: l_to_rel_party_id :=
1244: HZ_MERGE_UTIL.get_reln_party_id(p_to_entity_id);
1245:
1246: SELECT count(1) INTO l_rel_party_count

Line 1244: HZ_MERGE_UTIL.get_reln_party_id(p_to_entity_id);

1240:
1241: l_from_rel_party_id :=
1242: HZ_MERGE_UTIL.get_reln_party_id(p_from_entity_id);
1243: l_to_rel_party_id :=
1244: HZ_MERGE_UTIL.get_reln_party_id(p_to_entity_id);
1245:
1246: SELECT count(1) INTO l_rel_party_count
1247: FROM hz_merge_parties
1248: WHERE batch_id = l_batch_id

Line 1570: HZ_MERGE_UTIL.get_reln_party_id(merge_from_entity_id) from_reln_party_id,

1566: p_batch_id IN NUMBER)IS
1567:
1568: CURSOR merged_relns(cp_batch_party_id NUMBER) IS
1569: SELECT merge_from_entity_id, merge_to_entity_id,
1570: HZ_MERGE_UTIL.get_reln_party_id(merge_from_entity_id) from_reln_party_id,
1571: HZ_MERGE_UTIL.get_reln_party_id(merge_to_entity_id) to_reln_party_id
1572: FROM hz_merge_party_details
1573: WHERE batch_party_id = cp_batch_party_id
1574: AND entity_name = 'HZ_PARTY_RELATIONSHIPS'

Line 1571: HZ_MERGE_UTIL.get_reln_party_id(merge_to_entity_id) to_reln_party_id

1567:
1568: CURSOR merged_relns(cp_batch_party_id NUMBER) IS
1569: SELECT merge_from_entity_id, merge_to_entity_id,
1570: HZ_MERGE_UTIL.get_reln_party_id(merge_from_entity_id) from_reln_party_id,
1571: HZ_MERGE_UTIL.get_reln_party_id(merge_to_entity_id) to_reln_party_id
1572: FROM hz_merge_party_details
1573: WHERE batch_party_id = cp_batch_party_id
1574: AND entity_name = 'HZ_PARTY_RELATIONSHIPS'
1575: AND merge_to_entity_id IS NOT NULL

Line 2996: l_from_rel_party_id := hz_merge_util.get_reln_party_id(l_merge_from_reln_tbl(i));

2992: -- we need to loop through all parties and check for relationship party
2993: FOR i IN 1..l_merge_from_reln_tbl.COUNT LOOP
2994:
2995: -- check to see if there exist any relationship party, then do the party merge
2996: l_from_rel_party_id := hz_merge_util.get_reln_party_id(l_merge_from_reln_tbl(i));
2997: l_to_rel_party_id := hz_merge_util.get_reln_party_id(l_reln_id);
2998:
2999: select count(1) into l_rel_party_count
3000: from HZ_MERGE_PARTIES

Line 2997: l_to_rel_party_id := hz_merge_util.get_reln_party_id(l_reln_id);

2993: FOR i IN 1..l_merge_from_reln_tbl.COUNT LOOP
2994:
2995: -- check to see if there exist any relationship party, then do the party merge
2996: l_from_rel_party_id := hz_merge_util.get_reln_party_id(l_merge_from_reln_tbl(i));
2997: l_to_rel_party_id := hz_merge_util.get_reln_party_id(l_reln_id);
2998:
2999: select count(1) into l_rel_party_count
3000: from HZ_MERGE_PARTIES
3001: where batch_id = p_batch_id

Line 3122: l_from_rel_party_id := hz_merge_util.get_reln_party_id(l_merge_from_reln);

3118: ,1
3119: );
3120:
3121: -- find out those related party sites
3122: l_from_rel_party_id := hz_merge_util.get_reln_party_id(l_merge_from_reln);
3123: l_to_rel_party_id := hz_merge_util.get_reln_party_id(l_reln_id);
3124:
3125: select count(1) into l_rel_party_count
3126: from HZ_MERGE_PARTIES

Line 3123: l_to_rel_party_id := hz_merge_util.get_reln_party_id(l_reln_id);

3119: );
3120:
3121: -- find out those related party sites
3122: l_from_rel_party_id := hz_merge_util.get_reln_party_id(l_merge_from_reln);
3123: l_to_rel_party_id := hz_merge_util.get_reln_party_id(l_reln_id);
3124:
3125: select count(1) into l_rel_party_count
3126: from HZ_MERGE_PARTIES
3127: where batch_id = p_batch_id

Line 3558: SELECT HZ_MERGE_UTIL.get_reln_party_id(a.merge_from_entity_id)

3554: ,x_msg_data OUT NOCOPY VARCHAR2
3555: ) IS
3556:
3557: CURSOR find_mand_reln IS
3558: SELECT HZ_MERGE_UTIL.get_reln_party_id(a.merge_from_entity_id)
3559: , HZ_MERGE_UTIL.get_reln_party_id(a.merge_from_entity_id)
3560: FROM HZ_MERGE_PARTYDTLS_SUGG a
3561: , HZ_MERGE_PARTIES_SUGG b
3562: WHERE b.batch_id = p_batch_id

Line 3559: , HZ_MERGE_UTIL.get_reln_party_id(a.merge_from_entity_id)

3555: ) IS
3556:
3557: CURSOR find_mand_reln IS
3558: SELECT HZ_MERGE_UTIL.get_reln_party_id(a.merge_from_entity_id)
3559: , HZ_MERGE_UTIL.get_reln_party_id(a.merge_from_entity_id)
3560: FROM HZ_MERGE_PARTYDTLS_SUGG a
3561: , HZ_MERGE_PARTIES_SUGG b
3562: WHERE b.batch_id = p_batch_id
3563: AND a.entity_name = 'HZ_PARTY_RELATIONSHIPS'