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_DUP_SETS

Line 82: l_merge_type HZ_DUP_SETS.MERGE_TYPE%TYPE;

78: x_msg_data OUT NOCOPY VARCHAR2 ) IS
79:
80: l_merge_from HZ_DUP_SET_PARTIES.DUP_PARTY_ID%TYPE;
81: l_merge_to HZ_DUP_SET_PARTIES.DUP_PARTY_ID%TYPE;
82: l_merge_type HZ_DUP_SETS.MERGE_TYPE%TYPE;
83: l_merge_type2 HZ_DUP_SETS.MERGE_TYPE%TYPE;
84: l_count NUMBER := 0;
85: l_dup_set_count NUMBER;
86: l_default_mapping VARCHAR2(1);

Line 83: l_merge_type2 HZ_DUP_SETS.MERGE_TYPE%TYPE;

79:
80: l_merge_from HZ_DUP_SET_PARTIES.DUP_PARTY_ID%TYPE;
81: l_merge_to HZ_DUP_SET_PARTIES.DUP_PARTY_ID%TYPE;
82: l_merge_type HZ_DUP_SETS.MERGE_TYPE%TYPE;
83: l_merge_type2 HZ_DUP_SETS.MERGE_TYPE%TYPE;
84: l_count NUMBER := 0;
85: l_dup_set_count NUMBER;
86: l_default_mapping VARCHAR2(1);
87: l_party_type VARCHAR2(255);

Line 101: FROM HZ_DUP_SETS, HZ_PARTIES

97:
98: CURSOR c_batch_name IS
99: SELECT substrb(party_name, 1, 60) || ' (' || p_dup_set_id||')',
100: winner_party_id, merge_type
101: FROM HZ_DUP_SETS, HZ_PARTIES
102: WHERE winner_party_id = party_id
103: AND dup_set_id = p_dup_set_id;
104:
105: cursor get_automerge_flag_csr is

Line 107: from hz_dup_batch db, hz_dup_sets ds

103: AND dup_set_id = p_dup_set_id;
104:
105: cursor get_automerge_flag_csr is
106: select nvl(db.automerge_flag,'N')
107: from hz_dup_batch db, hz_dup_sets ds
108: where db.dup_batch_id = ds.dup_batch_id
109: and ds.dup_set_id = p_dup_set_id
110: and rownum=1;
111:

Line 122: from hz_dup_batch db, hz_dup_sets ds

118: ORDER BY decode(dup_party_id,cp_winner_party_id,2,1);
119:
120: cursor sugg_request_exist_csr is
121: select count(*)
122: from hz_dup_batch db, hz_dup_sets ds
123: where db.dup_batch_id = ds.dup_batch_id
124: and db.match_rule_id = -1
125: and db.dup_batch_name like 'SUGG:%'
126: and ds.dup_set_id = p_dup_set_id;

Line 321: --get the object_version_number of the record in hz_dup_sets

317: RETURN;
318: END IF;
319: end if; -- p_default_mapping = 'Y'
320:
321: --get the object_version_number of the record in hz_dup_sets
322: --for locking purpose
323:
324: SELECT object_version_number
325: INTO db_object_version_number

Line 326: FROM hz_dup_sets

322: --for locking purpose
323:
324: SELECT object_version_number
325: INTO db_object_version_number
326: FROM hz_dup_sets
327: WHERE dup_set_id = p_dup_set_id
328: FOR UPDATE OF dup_set_id;
329:
330: --if the 2 object version numbers are same then continue

Line 342: UPDATE HZ_DUP_SETS

338:
339: l_object_version_number := NVL(p_object_version_number, 1) + 1;
340:
341: --Update the dup set table status and merge_batch_id column
342: UPDATE HZ_DUP_SETS
343: SET object_version_number = l_object_version_number
344: WHERE dup_set_id = p_dup_set_id;
345:
346: p_object_version_number := l_object_version_number;

Line 349: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_dup_sets');

345:
346: p_object_version_number := l_object_version_number;
347: ELSE
348: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
349: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_dup_sets');
350: FND_MSG_PUB.ADD;
351: RAISE FND_API.G_EXC_ERROR;
352: END IF;
353:

Line 818: UPDATE HZ_DUP_SETS

814: FROM hz_merge_parties
815: WHERE batch_party_id = p_batch_party_id
816: AND ROWNUM = 1;
817:
818: UPDATE HZ_DUP_SETS
819: SET STATUS = 'MAPPING',
820: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
821: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
822: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

Line 1274: UPDATE HZ_DUP_SETS

1270:
1271:
1272: end if; --p_entity
1273:
1274: UPDATE HZ_DUP_SETS
1275: SET STATUS = 'MAPPING',
1276: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1277: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1278: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

Line 1405: FROM hz_dup_sets ds, hz_merge_batch mb

1401:
1402: -- a data librarian dup set must have merge batch
1403: SELECT ds.status
1404: INTO l_dup_set_status
1405: FROM hz_dup_sets ds, hz_merge_batch mb
1406: WHERE ds.dup_set_id = mb.batch_id
1407: AND ds.dup_set_id = p_batch_id;
1408:
1409: IF l_last_request_id IS NOT NULL THEN

Line 1494: UPDATE HZ_DUP_SETS

1490: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1491: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1492: WHERE batch_id = p_batch_id;
1493:
1494: UPDATE HZ_DUP_SETS
1495: SET status = 'SUBMITTED',
1496: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1497: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1498: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

Line 1696: FROM HZ_DUP_SETS dset,HZ_MERGE_PARTIES mpar

1692: l_case VARCHAR2(1);
1693:
1694: BEGIN
1695: SELECT dset.merge_type INTO l_merge_type
1696: FROM HZ_DUP_SETS dset,HZ_MERGE_PARTIES mpar
1697: WHERE dset.dup_set_id = mpar.batch_id
1698: AND mpar.batch_party_id = p_batch_party_id;
1699:
1700: IF l_merge_type = 'SAME_PARTY_MERGE' THEN

Line 1941: FROM HZ_DUP_SETS dset,HZ_MERGE_PARTIES mpar

1937:
1938: BEGIN
1939: l_temp := 'N';
1940: SELECT dset.merge_type, mpar.batch_id INTO l_merge_type, l_batch_id
1941: FROM HZ_DUP_SETS dset,HZ_MERGE_PARTIES mpar
1942: WHERE dset.dup_set_id = mpar.batch_id
1943: AND mpar.batch_party_id = p_batch_party_id;
1944:
1945: IF l_merge_type = 'SAME_PARTY_MERGE' THEN

Line 2157: from HZ_DUP_SETS

2153: l_default_relat_rule NUMBER := 0;
2154:
2155: cursor get_dup_sets_info(l_dup_set_id NUMBER) is
2156: select merge_type
2157: from HZ_DUP_SETS
2158: where dup_set_id = l_dup_set_id;
2159:
2160: BEGIN
2161:

Line 3789: from HZ_DUP_SETS where dup_set_id = p_batch_id )

3785: and mpd.merge_from_entity_id = from_rel.relationship_id
3786: and mpd.merge_to_entity_id = to_rel.relationship_id
3787: and from_rel.object_id =
3788: ( select winner_party_id
3789: from HZ_DUP_SETS where dup_set_id = p_batch_id )
3790: and to_rel.object_id =
3791: ( select winner_party_id
3792: from HZ_DUP_SETS where dup_set_id = p_batch_id )
3793: and from_rel.subject_id = from_pty.party_id

Line 3792: from HZ_DUP_SETS where dup_set_id = p_batch_id )

3788: ( select winner_party_id
3789: from HZ_DUP_SETS where dup_set_id = p_batch_id )
3790: and to_rel.object_id =
3791: ( select winner_party_id
3792: from HZ_DUP_SETS where dup_set_id = p_batch_id )
3793: and from_rel.subject_id = from_pty.party_id
3794: and to_rel.subject_id = to_pty.party_id
3795: group by to_rel.subject_id;
3796:

Line 3834: from HZ_DUP_SETS where dup_set_id = p_batch_id )

3830: and mpd.merge_from_entity_id = from_rel.relationship_id
3831: and mpd.merge_to_entity_id = to_rel.relationship_id
3832: and from_rel.object_id =
3833: ( select winner_party_id
3834: from HZ_DUP_SETS where dup_set_id = p_batch_id )
3835: and to_rel.object_id =
3836: ( select winner_party_id
3837: from HZ_DUP_SETS where dup_set_id = p_batch_id )
3838: and from_rel.subject_id = from_pty.party_id

Line 3837: from HZ_DUP_SETS where dup_set_id = p_batch_id )

3833: ( select winner_party_id
3834: from HZ_DUP_SETS where dup_set_id = p_batch_id )
3835: and to_rel.object_id =
3836: ( select winner_party_id
3837: from HZ_DUP_SETS where dup_set_id = p_batch_id )
3838: and from_rel.subject_id = from_pty.party_id
3839: and to_rel.subject_id = l_to_party_id
3840: and to_rel.subject_id = to_pty.party_id;
3841:

Line 3869: from HZ_DUP_SETS a, HZ_PARTIES b

3865: and to_rel.subject_id = l_to_party_id;
3866:
3867: CURSOR get_master_party is
3868: select party_name
3869: from HZ_DUP_SETS a, HZ_PARTIES b
3870: where a.winner_party_id = b.party_id
3871: and a.dup_set_id = p_batch_id;
3872:
3873: CURSOR get_cand_party(l_party_id NUMBER) is

Line 4167: FROM HZ_DUP_SETS a, HZ_PARTIES pty

4163: 'ORGANIZATION','HZ_ORGANIZATION_PROFILES',
4164: 'HZ_ORGANIZATION_PROFILES'),
4165: a.winner_party_id
4166: INTO l_party_type, l_merge_to
4167: FROM HZ_DUP_SETS a, HZ_PARTIES pty
4168: WHERE a.dup_set_id = p_batch_id
4169: AND a.winner_party_id = pty.party_id;
4170:
4171: HZ_MERGE_ENTITY_ATTRI_PVT.create_merge_attributes(

Line 4448: from hz_parties party, hz_dup_sets ds, hz_dup_set_parties dsp, hz_dup_batch db

4444: x_msg_data OUT NOCOPY VARCHAR2 ) is
4445:
4446: cursor dset_overlap_merged_party_csr is
4447: select party.party_number,ds.object_version_number
4448: from hz_parties party, hz_dup_sets ds, hz_dup_set_parties dsp, hz_dup_batch db
4449: where party.party_id =dsp.dup_party_id
4450: and db.dup_batch_id = ds.dup_batch_id
4451: and ds.dup_set_id = dsp.dup_set_id
4452: and party.status = 'M'

Line 4458: hz_dup_sets ds, hz_dup_set_parties dsp, hz_dup_batch db

4454:
4455: cursor dset_overlap_req_party_csr is
4456: select distinct mp.batch_id,dsp.dup_party_id,ds.object_version_number
4457: from hz_merge_batch mb, hz_merge_parties mp,
4458: hz_dup_sets ds, hz_dup_set_parties dsp, hz_dup_batch db
4459: where mp.batch_id <> ds.dup_set_id
4460: and mb.batch_id = mp.batch_id
4461: and db.dup_batch_id = ds.dup_batch_id
4462: and ds.dup_set_id = dsp.dup_set_id

Line 4480: from hz_dup_sets

4476:
4477: /* from DL UI merge_batch_id = dup_set_id */
4478: cursor batch_dset_obj_ver_num_csr is
4479: select object_version_number
4480: from hz_dup_sets
4481: where dup_set_id = p_merge_batch_id;
4482:
4483: cursor get_merged_rel_party_csr is
4484: select mp2.batch_party_id

Line 4564: UPDATE HZ_DUP_SETS

4560: ,x_msg_data => x_msg_data);
4561: */
4562:
4563: -- Update dup set status to 'Error'
4564: UPDATE HZ_DUP_SETS
4565: SET STATUS = 'ERROR',
4566: OBJECT_VERSION_NUMBER = nvl(OBJECT_VERSION_NUMBER,1)+1,
4567: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
4568: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,