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 578: FROM hz_merge_party_details

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

Line 594: FROM hz_merge_party_details md1, hz_merge_party_details md2,

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

Line 606: FROM hz_merge_party_details md1, hz_merge_party_details md2,

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

Line 765: DELETE FROM hz_merge_party_details

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

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

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

Line 778: FROM hz_merge_party_details

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

Line 799: ---Update the HZ_MERGE_PARTY_DETAILS table

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

Line 802: UPDATE HZ_MERGE_PARTY_DETAILS

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

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

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

Line 1002: FROM hz_merge_party_details

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

Line 1139: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

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

Line 1153: HZ_MERGE_PARTY_DETAILS_PKG.delete_row(

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

Line 1182: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

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

Line 1238: HZ_MERGE_PARTY_DETAILS_PKG.delete_row(

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

Line 1263: DELETE FROM hz_merge_party_details

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

Line 1572: FROM hz_merge_party_details

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

Line 1725: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

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

Line 1739: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

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

Line 1782: from HZ_MERGE_PARTIES a, HZ_MERGE_PARTY_DETAILS b

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

Line 1810: from HZ_MERGE_PARTIES a, HZ_MERGE_PARTY_DETAILS b

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

Line 1833: from HZ_MERGE_PARTIES a, HZ_MERGE_PARTY_DETAILS b

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

Line 1855: from HZ_MERGE_PARTIES a, HZ_MERGE_PARTY_DETAILS b

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

Line 1932: from hz_merge_party_details

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

Line 2077: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

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

Line 2094: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

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

Line 2116: update HZ_MERGE_PARTY_DETAILS

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

Line 2246: FROM HZ_MERGE_PARTY_DETAILS

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

Line 3365: -- Copy suggested default mapping to HZ_MERGE_PARTY_DETAILS

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

Line 3404: DELETE FROM HZ_MERGE_PARTY_DETAILS

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

Line 3411: INSERT INTO HZ_MERGE_PARTY_DETAILS

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

Line 3582: UPDATE HZ_MERGE_PARTY_DETAILS mpd

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

Line 3608: UPDATE HZ_MERGE_PARTY_DETAILS

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

Line 3621: DELETE HZ_MERGE_PARTY_DETAILS

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

Line 3629: INSERT INTO HZ_MERGE_PARTY_DETAILS

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

Line 3669: -- merge at HZ_MERGE_PARTY_DETAILS

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

Line 3777: from HZ_MERGE_PARTY_DETAILS mpd, HZ_MERGE_PARTIES mp

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

Line 3797: from HZ_MERGE_PARTY_DETAILS mpd, HZ_MERGE_PARTIES mp

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

Line 3822: from HZ_MERGE_PARTY_DETAILS mpd, HZ_MERGE_PARTIES mp

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

Line 3842: from HZ_MERGE_PARTY_DETAILS mpd, HZ_MERGE_PARTIES mp

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

Line 4287: from hz_merge_parties mp, hz_merge_party_details mpd

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

Line 4590: delete from hz_merge_party_details where batch_party_id = l_batch_party_id;

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

Line 4642: hz_merge_party_details pd,

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

Line 4689: hz_merge_party_details pd1

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

Line 4701: hz_merge_party_details pd2

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

Line 4737: hz_merge_party_details pd1

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

Line 4749: hz_merge_party_details pd2

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