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_PARTY_DETAILS

Line 579: FROM hz_merge_party_details

575: END IF;
576:
577: BEGIN
578: SELECT mandatory_merge, merge_to_entity_id INTO l_mm, l_merge_to
579: FROM hz_merge_party_details
580: where batch_party_id=p_batch_party_id
581: AND entity_name = p_entity
582: AND merge_from_entity_id = p_from_entity_id;
583:

Line 595: FROM hz_merge_party_details md1, hz_merge_party_details md2,

591:
592: IF p_from_entity_id = l_merge_to THEN
593: /* Check if any entity is merged to p_from_entity_id */
594: SELECT count(1) INTO l_tmp
595: FROM hz_merge_party_details md1, hz_merge_party_details md2,
596: hz_merge_parties mp1, hz_merge_parties mp2
597: where md1.batch_party_id=p_batch_party_id
598: AND md1.batch_party_id = mp1.batch_party_id
599: AND mp1.batch_id = mp2.batch_id

Line 607: FROM hz_merge_party_details md1, hz_merge_party_details md2,

603: AND md2.merge_from_entity_id<>p_from_entity_id;
604:
605: /* Check if p_to_entity_id is merged to another entity */
606: SELECT count(1) INTO l_tmp2
607: FROM hz_merge_party_details md1, hz_merge_party_details md2,
608: hz_merge_parties mp1, hz_merge_parties mp2
609: where md1.batch_party_id=p_batch_party_id
610: AND md1.batch_party_id = mp1.batch_party_id
611: AND mp1.batch_id = mp2.batch_id

Line 766: DELETE FROM hz_merge_party_details

762: and from_party_id = l_from_rel_party_id;
763:
764: HZ_MERGE_PARTIES_PKG.delete_Row(rel_batch_party_id);
765:
766: DELETE FROM hz_merge_party_details
767: WHERE batch_party_id = rel_batch_party_id;
768:
769: END IF; --l_rel_party_count
770:

Line 774: --get the object_version_number of the record in hz_merge_party_details

770:
771: END IF; --p_to_entity_id is not null
772: END IF; --p_entity
773:
774: --get the object_version_number of the record in hz_merge_party_details
775: --for locking purpose
776:
777: SELECT object_version_number
778: INTO db_object_version_number

Line 779: FROM hz_merge_party_details

775: --for locking purpose
776:
777: SELECT object_version_number
778: INTO db_object_version_number
779: FROM hz_merge_party_details
780: WHERE merge_from_entity_id = p_from_entity_id
781: AND batch_party_id = p_batch_party_id
782: AND entity_name = p_entity
783: FOR UPDATE OF merge_from_entity_id, batch_party_id,entity_name nowait;

Line 800: ---Update the HZ_MERGE_PARTY_DETAILS table

796: p_object_version_number IS NOT NULL AND
797: db_object_version_number = p_object_version_number )
798: ) THEN
799:
800: ---Update the HZ_MERGE_PARTY_DETAILS table
801: l_object_version_number := NVL(p_object_version_number, 1) + 1;
802:
803: UPDATE HZ_MERGE_PARTY_DETAILS
804: SET merge_to_entity_id = p_to_entity_id,

Line 803: UPDATE HZ_MERGE_PARTY_DETAILS

799:
800: ---Update the HZ_MERGE_PARTY_DETAILS table
801: l_object_version_number := NVL(p_object_version_number, 1) + 1;
802:
803: UPDATE HZ_MERGE_PARTY_DETAILS
804: SET merge_to_entity_id = p_to_entity_id,
805: object_version_number = l_object_version_number
806: WHERE merge_from_entity_id = p_from_entity_id
807: AND batch_party_id = p_batch_party_id

Line 834: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_merge_party_details');

830: WHERE BATCH_ID = l_dup_set_id;
831:
832: ELSE
833: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
834: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_merge_party_details');
835: FND_MSG_PUB.ADD;
836: RAISE FND_API.G_EXC_ERROR;
837: END IF;
838:

Line 1003: FROM hz_merge_party_details

999: CURSOR c_map_detail_record_exist(cp_batch_party_id IN NUMBER,
1000: cp_entity_name IN VARCHAR2,
1001: cp_from_entity_id IN NUMBER) IS
1002: SELECT count(1)
1003: FROM hz_merge_party_details
1004: WHERE batch_party_id = cp_batch_party_id
1005: AND entity_name = cp_entity_name
1006: AND merge_from_entity_id = cp_from_entity_id;
1007:

Line 1140: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

1136: RAISE FND_API.G_EXC_ERROR;
1137: END IF;
1138: END IF;
1139: CLOSE c_cust_site_check;
1140: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
1141: p_batch_party_id,
1142: 'HZ_PARTY_SITES',
1143: p_from_entity_id,
1144: p_to_entity_id,

Line 1154: HZ_MERGE_PARTY_DETAILS_PKG.delete_row(

1150: hz_utility_v2pub.last_updated_by);
1151:
1152: ELSE
1153: IF l_map_dtl_count >0 THEN
1154: HZ_MERGE_PARTY_DETAILS_PKG.delete_row(
1155: p_batch_party_id, 'HZ_PARTY_SITES', p_from_entity_id);
1156: END IF;
1157: END IF;
1158:

Line 1183: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181: END IF;
1182:
1183: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
1184: p_batch_party_id,
1185: 'HZ_PARTY_RELATIONSHIPS',
1186: p_from_entity_id,
1187: p_to_entity_id,

Line 1239: HZ_MERGE_PARTY_DETAILS_PKG.delete_row(

1235: END IF; --l_rel_party_count
1236: end if; --l_from_rel_party_id is not null
1237: ELSE
1238: IF l_map_dtl_count>0 THEN
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);

Line 1264: DELETE FROM hz_merge_party_details

1260: AND from_party_id = l_from_rel_party_id;
1261:
1262: HZ_MERGE_PARTIES_PKG.delete_Row(rel_batch_party_id);
1263:
1264: DELETE FROM hz_merge_party_details
1265: WHERE batch_party_id = rel_batch_party_id;
1266:
1267: end if; --l_rel_party_count
1268: end if; -- l_map_dtl_count

Line 1573: FROM hz_merge_party_details

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
1577: AND merge_from_entity_id IS NOT NULL

Line 1726: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

1722: ELSE
1723: l_to_entity_id := l_dup_ps_id;
1724: END IF;
1725:
1726: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
1727: p_batch_party_id,
1728: 'HZ_PARTY_SITES',
1729: l_ps_id,
1730: l_to_entity_id,

Line 1740: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

1736: hz_utility_v2pub.last_updated_by);
1737: ELSE
1738: l_to_entity_id := l_ps_id;
1739:
1740: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
1741: p_batch_party_id,
1742: 'HZ_PARTY_SITES',
1743: l_ps_id,
1744: l_to_entity_id,

Line 1783: from HZ_MERGE_PARTIES a, HZ_MERGE_PARTY_DETAILS b

1779: AND object_table_name = 'HZ_PARTIES'
1780: AND (merge_type ='S' OR actual_content_source <> 'DNB')--Bug No. 4114254
1781: AND not exists
1782: ( select 1
1783: from HZ_MERGE_PARTIES a, HZ_MERGE_PARTY_DETAILS b
1784: where a.batch_party_id = b.batch_party_id
1785: and b.merge_from_entity_id = r.relationship_id
1786: and b.entity_name = 'HZ_PARTY_RELATIONSHIPS'
1787: and a.batch_id = l_batch_id );

Line 1811: from HZ_MERGE_PARTIES a, HZ_MERGE_PARTY_DETAILS b

1807: AND object_table_name = 'HZ_PARTIES'
1808: AND (merge_type ='S' OR actual_content_source <> 'DNB') --Bug No. 4114254
1809: AND not exists --4651128
1810: ( select 1
1811: from HZ_MERGE_PARTIES a, HZ_MERGE_PARTY_DETAILS b
1812: where a.batch_party_id = b.batch_party_id
1813: and b.merge_from_entity_id = r.relationship_id
1814: and b.entity_name = 'HZ_PARTY_RELATIONSHIPS'
1815: and a.batch_id = c_batch_id );

Line 1834: from HZ_MERGE_PARTIES a, HZ_MERGE_PARTY_DETAILS b

1830: SELECT relationship_id, start_date, nvl(end_date,to_date('12/31/4712','MM/DD/YYYY'))
1831: FROM HZ_RELATIONSHIPS r
1832: WHERE
1833: relationship_id in (select distinct b.merge_to_entity_id
1834: from HZ_MERGE_PARTIES a, HZ_MERGE_PARTY_DETAILS b
1835: where a.batch_party_id = b.batch_party_id
1836: and b.entity_name = 'HZ_PARTY_RELATIONSHIPS'
1837: and a.batch_id = c_batch_id)
1838: AND subject_id = cp_subj_id

Line 1856: from HZ_MERGE_PARTIES a, HZ_MERGE_PARTY_DETAILS b

1852: SELECT relationship_id, start_date, nvl(end_date,to_date('12/31/4712','MM/DD/YYYY'))
1853: FROM HZ_RELATIONSHIPS r
1854: WHERE
1855: relationship_id in (select distinct b.merge_to_entity_id
1856: from HZ_MERGE_PARTIES a, HZ_MERGE_PARTY_DETAILS b
1857: where a.batch_party_id = b.batch_party_id
1858: and b.entity_name = 'HZ_PARTY_RELATIONSHIPS'
1859: and a.batch_id = c_batch_id)
1860: AND object_id = cp_obj_id

Line 1933: from hz_merge_party_details

1929: and rownum = 1;
1930:
1931: cursor c_check_inactive_to_id(cp_id number) is
1932: select merge_to_entity_id
1933: from hz_merge_party_details
1934: where merge_from_entity_id = merge_to_entity_id
1935: and merge_from_entity_id = cp_id;
1936:
1937:

Line 2078: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

2074: ELSE
2075: l_mandatory_merge := 'N';
2076: END IF;
2077:
2078: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
2079: p_batch_party_id,
2080: 'HZ_PARTY_RELATIONSHIPS',
2081: l_pr_id,
2082: l_dup_pr_id,

Line 2095: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

2091:
2092: --5400786
2093: l_temp := 'Y';
2094: ---5400786
2095: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
2096: p_batch_party_id,
2097: 'HZ_PARTY_RELATIONSHIPS',
2098: l_pr_id,
2099: l_pr_id,

Line 2117: update HZ_MERGE_PARTY_DETAILS

2113: --5400786
2114: if l_to_id = l_pr_id AND l_temp <> 'Y' -- inactive id
2115: --5400786
2116: then
2117: update HZ_MERGE_PARTY_DETAILS
2118: set
2119: merge_from_entity_id = l_dup_pr_id,
2120: merge_to_entity_id = l_dup_pr_id
2121: where merge_to_entity_id = l_pr_id

Line 2247: FROM HZ_MERGE_PARTY_DETAILS

2243: ,last_update_login
2244: ,last_update_date
2245: ,last_updated_by
2246: ,object_version_number
2247: FROM HZ_MERGE_PARTY_DETAILS
2248: WHERE batch_party_id IN
2249: ( SELECT batch_party_id
2250: FROM HZ_MERGE_PARTIES_SUGG
2251: WHERE batch_id = p_batch_id );

Line 3367: -- Copy suggested default mapping to HZ_MERGE_PARTY_DETAILS

3363: --
3364: -- PROCEDURE apply_suggested_default
3365: --
3366: -- DESCRIPTION
3367: -- Copy suggested default mapping to HZ_MERGE_PARTY_DETAILS
3368: --
3369: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3370: --
3371: -- ARGUMENTS

Line 3406: DELETE FROM HZ_MERGE_PARTY_DETAILS

3402: savepoint apply_suggested_default;
3403:
3404: x_return_status := FND_API.G_RET_STS_SUCCESS;
3405:
3406: DELETE FROM HZ_MERGE_PARTY_DETAILS
3407: WHERE BATCH_PARTY_ID IN
3408: ( SELECT BATCH_PARTY_ID
3409: FROM HZ_MERGE_PARTIES
3410: WHERE BATCH_ID = p_batch_id )

Line 3413: INSERT INTO HZ_MERGE_PARTY_DETAILS

3409: FROM HZ_MERGE_PARTIES
3410: WHERE BATCH_ID = p_batch_id )
3411: AND ENTITY_NAME = p_entity_name;
3412:
3413: INSERT INTO HZ_MERGE_PARTY_DETAILS
3414: (
3415: batch_party_id
3416: ,entity_name
3417: ,merge_from_entity_id

Line 3584: UPDATE HZ_MERGE_PARTY_DETAILS mpd

3580: IF(p_merge_type = 'PARTY_MERGE') THEN
3581:
3582:
3583: -- copy mapping from suggested defaults table
3584: UPDATE HZ_MERGE_PARTY_DETAILS mpd
3585: SET mpd.merge_from_entity_id =
3586: ( SELECT merge_from_entity_id
3587: FROM HZ_MERGE_PARTYDTLS_SUGG mps
3588: WHERE mpd.batch_party_id = mps.batch_party_id

Line 3610: UPDATE HZ_MERGE_PARTY_DETAILS

3606:
3607:
3608:
3609: -- clean up all non-mandatory merge sites and reln mapping in merge party details
3610: UPDATE HZ_MERGE_PARTY_DETAILS
3611: SET merge_to_entity_id = merge_from_entity_id
3612: WHERE mandatory_merge <> 'Y'
3613: AND entity_name = p_entity_name
3614: AND batch_party_id IN

Line 3623: DELETE HZ_MERGE_PARTY_DETAILS

3619:
3620: ELSIF(p_merge_type = 'SAME_PARTY_MERGE') THEN
3621:
3622: -- remove all mapping
3623: DELETE HZ_MERGE_PARTY_DETAILS
3624: WHERE entity_name = p_entity_name
3625: AND batch_party_id IN
3626: ( SELECT batch_party_id
3627: FROM HZ_MERGE_PARTIES

Line 3631: INSERT INTO HZ_MERGE_PARTY_DETAILS

3627: FROM HZ_MERGE_PARTIES
3628: WHERE batch_id = p_batch_id );
3629:
3630: -- only insert those mandatory merge mapping
3631: INSERT INTO HZ_MERGE_PARTY_DETAILS
3632: (
3633: batch_party_id
3634: ,entity_name
3635: ,merge_from_entity_id

Line 3671: -- merge at HZ_MERGE_PARTY_DETAILS

3667: IF(p_entity_name = 'HZ_PARTY_RELATIONSHIPS') THEN
3668:
3669: -- remove all DUPLICATE_RELN_PARTY record in HZ_MERGE_PARTIES first
3670: -- then recreate them by finding out all relationship mandatory
3671: -- merge at HZ_MERGE_PARTY_DETAILS
3672:
3673:
3674: DELETE FROM HZ_MERGE_PARTIES mp
3675: WHERE mp.batch_id = p_batch_id

Line 3779: from HZ_MERGE_PARTY_DETAILS mpd, HZ_MERGE_PARTIES mp

3775: ) IS
3776:
3777: CURSOR get_reln_party_sp IS
3778: select to_rel.subject_id, count(1)
3779: from HZ_MERGE_PARTY_DETAILS mpd, HZ_MERGE_PARTIES mp
3780: , HZ_RELATIONSHIPS from_rel, HZ_RELATIONSHIPS to_rel
3781: , HZ_PARTIES from_pty, HZ_PARTIES to_pty
3782: where mpd.batch_party_id = mp.batch_party_id
3783: and mp.batch_id = p_batch_id

Line 3799: from HZ_MERGE_PARTY_DETAILS mpd, HZ_MERGE_PARTIES mp

3795: group by to_rel.subject_id;
3796:
3797: CURSOR get_reln_party_mp IS
3798: select to_rel.subject_id, count(1)
3799: from HZ_MERGE_PARTY_DETAILS mpd, HZ_MERGE_PARTIES mp
3800: , HZ_RELATIONSHIPS from_rel, HZ_RELATIONSHIPS to_rel
3801: , HZ_PARTIES from_pty, HZ_PARTIES to_pty
3802: where mpd.batch_party_id = mp.batch_party_id
3803: and mpd.merge_from_entity_id <> mpd.merge_to_entity_id

Line 3824: from HZ_MERGE_PARTY_DETAILS mpd, HZ_MERGE_PARTIES mp

3820: group by to_rel.subject_id;
3821:
3822: CURSOR get_reln_from_party_sp(l_to_party_id NUMBER) IS
3823: select from_rel.subject_id
3824: from HZ_MERGE_PARTY_DETAILS mpd, HZ_MERGE_PARTIES mp
3825: , HZ_RELATIONSHIPS from_rel, HZ_RELATIONSHIPS to_rel
3826: , HZ_PARTIES from_pty, HZ_PARTIES to_pty
3827: where mpd.batch_party_id = mp.batch_party_id
3828: and mp.batch_id = p_batch_id

Line 3844: from HZ_MERGE_PARTY_DETAILS mpd, HZ_MERGE_PARTIES mp

3840: and to_rel.subject_id = to_pty.party_id;
3841:
3842: CURSOR get_reln_from_party_mp(l_to_party_id NUMBER) IS
3843: select from_rel.subject_id
3844: from HZ_MERGE_PARTY_DETAILS mpd, HZ_MERGE_PARTIES mp
3845: , HZ_RELATIONSHIPS from_rel, HZ_RELATIONSHIPS to_rel
3846: , HZ_PARTIES from_pty, HZ_PARTIES to_pty
3847: where mpd.batch_party_id = mp.batch_party_id
3848: and mpd.merge_from_entity_id <> mpd.merge_to_entity_id

Line 4289: from hz_merge_parties mp, hz_merge_party_details mpd

4285: l_obj_ver_number NUMBER;
4286:
4287: CURSOR c_children(cp_merge_batch_id NUMBER, cp_entity VARCHAR2, cp_entity_id NUMBER) IS
4288: SELECT mpd.merge_from_entity_id, mpd.batch_party_id, mpd.object_version_number
4289: from hz_merge_parties mp, hz_merge_party_details mpd
4290: WHERE mp.batch_id=cp_merge_batch_id
4291: AND mpd.entity_name = p_entity
4292: AND mp.batch_party_id = mpd.batch_party_id
4293: AND mpd.merge_from_entity_id <> cp_entity_id

Line 4593: delete from hz_merge_party_details where batch_party_id = l_batch_party_id;

4589:
4590: if l_batch_party_id is not null
4591: then
4592: delete from hz_merge_parties where batch_party_id = l_batch_party_id;
4593: delete from hz_merge_party_details where batch_party_id = l_batch_party_id;
4594:
4595: end if;
4596: end loop;
4597: close get_merged_rel_party_csr;

Line 4645: hz_merge_party_details pd,

4641:
4642: cursor get_from_addr_csr is
4643: select hz_format_pub.format_address(l.location_id,null,null,', ')
4644: from hz_merge_parties p,
4645: hz_merge_party_details pd,
4646: hz_party_sites s,
4647: hz_locations l,
4648: hz_parties hp
4649: where p.batch_party_id = pd.batch_party_id

Line 4692: hz_merge_party_details pd1

4688: FROM hz_party_sites ps1,
4689: hz_cust_acct_sites_all as1,
4690: hz_cust_accounts ca1,
4691: hz_merge_parties p1,
4692: hz_merge_party_details pd1
4693: WHERE p1.batch_id = p_merge_batch_id
4694: AND ps1.party_site_id = as1.party_site_id
4695: and ca1.cust_account_id = as1.cust_account_id
4696: and p1.batch_party_id = pd1.batch_party_id

Line 4704: hz_merge_party_details pd2

4700: AND exists
4701: ( select 1 from hz_party_sites ps2,
4702: hz_cust_acct_sites_all as2,
4703: hz_merge_parties p2,
4704: hz_merge_party_details pd2
4705: where p2.batch_id = p_merge_batch_id
4706: and ps2.party_site_id = as2.party_site_id
4707: and as2.cust_account_id = as1.cust_account_id
4708: and as2.org_id = as1.org_id

Line 4740: hz_merge_party_details pd1

4736: FROM hz_party_sites ps1,
4737: hz_cust_acct_sites_all as1,
4738: hz_cust_accounts ca1,
4739: hz_merge_parties p1,
4740: hz_merge_party_details pd1
4741: WHERE p1.batch_id = p_merge_batch_id
4742: AND ps1.party_site_id = as1.party_site_id
4743: and ca1.cust_account_id = as1.cust_account_id
4744: and p1.batch_party_id = pd1.batch_party_id

Line 4752: hz_merge_party_details pd2

4748: AND exists
4749: ( select 1 from hz_party_sites ps2,
4750: hz_cust_acct_sites_all as2,
4751: hz_merge_parties p2,
4752: hz_merge_party_details pd2
4753: where p2.batch_id = p_merge_batch_id
4754: and ps2.party_site_id = as2.party_site_id
4755: and as2.cust_account_id = as1.cust_account_id
4756: and as2.org_id = as1.org_id