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 684: HZ_MERGE_UTIL.get_reln_party_id(p_from_entity_id);

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

Line 686: HZ_MERGE_UTIL.get_reln_party_id(p_to_entity_id);

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

Line 1197: HZ_MERGE_UTIL.get_reln_party_id(p_from_entity_id);

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

Line 1199: HZ_MERGE_UTIL.get_reln_party_id(p_to_entity_id);

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

Line 1243: HZ_MERGE_UTIL.get_reln_party_id(p_from_entity_id);

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

Line 1245: HZ_MERGE_UTIL.get_reln_party_id(p_to_entity_id);

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

Line 1571: HZ_MERGE_UTIL.get_reln_party_id(merge_from_entity_id) from_reln_party_id,

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

Line 1572: HZ_MERGE_UTIL.get_reln_party_id(merge_to_entity_id) to_reln_party_id

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

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

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

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

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

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

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

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

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

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

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

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

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