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

Line 78: HZ_CUST_ACCOUNTS CA,HZ_PARTIES PARTY, HZ_DUP_SETS DS,

74: ca.party_id party_id, party.party_name party_name,
75: count(*) over (partition by ca.party_id) as cnt,
76: ca.last_update_date
77: from
78: HZ_CUST_ACCOUNTS CA,HZ_PARTIES PARTY, HZ_DUP_SETS DS,
79: HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB
80: WHERE CA.PARTY_ID =DSP.DUP_PARTY_ID
81: AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
82: AND DS.DUP_SET_ID = DSP.DUP_SET_ID

Line 102: HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB

98: ps.party_id party_id, party.party_name party_name,
99: count(*) over (partition by ps.party_id) as cnt,
100: ps.last_update_date
101: from HZ_PARTY_SITES PS,HZ_PARTIES PARTY,
102: HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB
103: WHERE PS.PARTY_ID =DSP.DUP_PARTY_ID
104: AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
105: AND DS.DUP_SET_ID = DSP.DUP_SET_ID
106: AND PS.PARTY_ID = PARTY.PARTY_ID

Line 125: from HZ_RELATIONSHIPS R,HZ_PARTIES PARTY, HZ_DUP_SETS DS,

121: party.party_id party_id,
122: party.party_name party_name,
123: count(*) over (partition by party.party_id) as cnt,
124: party.last_update_date
125: from HZ_RELATIONSHIPS R,HZ_PARTIES PARTY, HZ_DUP_SETS DS,
126: HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB
127: WHERE PARTY.PARTY_ID =DSP.DUP_PARTY_ID
128: AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
129: AND DS.DUP_SET_ID = DSP.DUP_SET_ID

Line 161: from HZ_DUP_SETS

157: and p.status = 'A';
158:
159: cursor get_set_obj_num_csr is
160: select object_version_number
161: from HZ_DUP_SETS
162: where dup_set_id = p_dup_set_id;
163:
164: -- validate party_id and party_name combination.
165: cursor check_set_party_exist_csr(cp_party_id number, cp_party_name varchar2) is

Line 454: from HZ_PARTIES a, HZ_DUP_SETS b

450: l_cand_type VARCHAR2(30);
451:
452: cursor get_winner_party_type(l_dset_id NUMBER) is
453: select party_type
454: from HZ_PARTIES a, HZ_DUP_SETS b
455: where a.party_id = b.winner_party_id
456: and b.dup_set_id = l_dset_id;
457:
458: cursor get_party_type(l_party_id NUMBER) is

Line 654: HZ_DUP_SETS_PKG.Insert_Row(

650: );
651:
652: x_dup_batch_id := l_dup_batch_id;
653:
654: HZ_DUP_SETS_PKG.Insert_Row(
655: px_dup_set_id => l_dup_set_id
656: ,p_dup_batch_id => l_dup_batch_id
657: ,p_winner_party_id => p_dup_set_rec.winner_party_id
658: ,p_status => 'SYSBATCH'

Line 773: HZ_DUP_SETS_PKG.Insert_Row(

769: FND_MSG_PUB.ADD;
770: RAISE FND_API.G_EXC_ERROR;
771: END IF;
772:
773: HZ_DUP_SETS_PKG.Insert_Row(
774: px_dup_set_id => l_dup_set_id
775: ,p_dup_batch_id => p_dup_set_rec.dup_batch_id
776: ,p_winner_party_id => p_dup_set_rec.winner_party_id
777: ,p_status => 'SYSBATCH'

Line 840: -- update winner_party_id in HZ_DUP_SETS table

836: p_data => x_msg_data);
837:
838: END create_dup_set;
839:
840: -- update winner_party_id in HZ_DUP_SETS table
841: -- and swap the master and candidate
842: PROCEDURE update_winner_party (
843: p_dup_set_id IN NUMBER
844: ,p_winner_party_id IN NUMBER

Line 864: from HZ_DUP_SETS

860: and nvl(merge_flag,'Y') = 'Y';
861:
862: cursor get_dup_sets_info is
863: select winner_party_id, object_version_number
864: from HZ_DUP_SETS
865: where dup_set_id = p_dup_set_id;
866:
867: BEGIN
868:

Line 893: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties

889: l_old_winner_party_id
890: ,l_set_obj_version_number;
891: CLOSE get_dup_sets_info;
892:
893: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties
894: IF (l_set_obj_version_number IS NOT NULL) THEN
895: IF (l_set_obj_version_number <> px_set_obj_version_number) THEN
896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
897: -- row has been changed by another user.

Line 899: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DUP_SETS');

895: IF (l_set_obj_version_number <> px_set_obj_version_number) THEN
896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
897: -- row has been changed by another user.
898: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
899: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DUP_SETS');
900: FND_MSG_PUB.ADD;
901: RAISE FND_API.G_EXC_ERROR;
902: END IF;
903: END IF;

Line 945: -- not doing any update to HZ_DUP_SETS status since user may

941: WHEN NO_DATA_FOUND THEN
942: NULL;
943: END;
944:
945: -- not doing any update to HZ_DUP_SETS status since user may
946: -- be in create merge request flow and status should remain
947: -- the same. For merge multiple party flow, the update call
948: -- will be followed by submit_dup call which will update the
949: -- status to 'PREPROCESS' when successfully call conc request

Line 951: UPDATE HZ_DUP_SETS

947: -- the same. For merge multiple party flow, the update call
948: -- will be followed by submit_dup call which will update the
949: -- status to 'PREPROCESS' when successfully call conc request
950:
951: UPDATE HZ_DUP_SETS
952: SET winner_party_id = p_winner_party_id
953: , last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
954: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
955: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

Line 1002: from HZ_DUP_SETS

998: ) IS
999:
1000: CURSOR get_dup_sets_info IS
1001: select winner_party_id, object_version_number
1002: from HZ_DUP_SETS
1003: where dup_set_id = p_dup_set_id;
1004:
1005: CURSOR check_winner_party(x_party_id NUMBER) IS
1006: select 'X'

Line 1007: from HZ_DUP_SETS

1003: where dup_set_id = p_dup_set_id;
1004:
1005: CURSOR check_winner_party(x_party_id NUMBER) IS
1006: select 'X'
1007: from HZ_DUP_SETS
1008: where winner_party_id = x_party_id
1009: and dup_set_id = p_dup_set_id;
1010:
1011: CURSOR check_dup_party(x_party_id NUMBER) IS

Line 1035: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties

1031: l_winner_party_id
1032: ,l_set_obj_version_number;
1033: CLOSE get_dup_sets_info;
1034:
1035: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties
1036: IF (l_set_obj_version_number IS NOT NULL) THEN
1037: IF (l_set_obj_version_number <> px_set_obj_version_number) THEN
1038: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1039: -- row has been changed by another user.

Line 1041: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DUP_SETS');

1037: IF (l_set_obj_version_number <> px_set_obj_version_number) THEN
1038: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1039: -- row has been changed by another user.
1040: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1041: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DUP_SETS');
1042: FND_MSG_PUB.ADD;
1043: RAISE FND_API.G_EXC_ERROR;
1044: END IF;
1045: END IF;

Line 1065: UPDATE HZ_DUP_SETS

1061: END IF;
1062: END IF;
1063: CLOSE check_winner_party;
1064:
1065: UPDATE HZ_DUP_SETS
1066: set object_version_number = px_set_obj_version_number
1067: , last_update_date = hz_utility_v2pub.last_update_date
1068: , last_updated_by = hz_utility_v2pub.last_updated_by
1069: , last_update_login = hz_utility_v2pub.last_update_login

Line 1107: UPDATE HZ_DUP_SETS

1103: END IF;
1104: END IF;
1105: CLOSE check_dup_party;
1106:
1107: UPDATE HZ_DUP_SETS
1108: set winner_party_id = p_new_winner_party_id
1109: , object_version_number = px_set_obj_version_number
1110: , last_update_date = hz_utility_v2pub.last_update_date
1111: , last_updated_by = hz_utility_v2pub.last_updated_by

Line 1172: -- Reset merge_type of HZ_DUP_SETS and hard delete candidate which has merge_flag = 'N'

1168:
1169: END delete_dup_party;
1170:
1171: --
1172: -- Reset merge_type of HZ_DUP_SETS and hard delete candidate which has merge_flag = 'N'
1173: -- this procedure is used in system duplicate identification flow
1174: --
1175: -- If a duplicate set found by system duplicate identification program has more than
1176: -- one party involved, the merge_type of this dup set is set to PARTY_MERGE. Howvever,

Line 1192: from HZ_DUP_SETS

1188: ) IS
1189:
1190: CURSOR get_dup_sets_info IS
1191: select winner_party_id, object_version_number
1192: from HZ_DUP_SETS
1193: where dup_set_id = p_dup_set_id;
1194:
1195: CURSOR check_only_master IS
1196: select count(1)

Line 1202: from HZ_DUP_SETS

1198: where dup_set_id = p_dup_set_id;
1199:
1200: CURSOR check_winner_party IS
1201: select 'X'
1202: from HZ_DUP_SETS
1203: where winner_party_id =
1204: ( select dup_party_id
1205: from HZ_DUP_SET_PARTIES
1206: where dup_set_id = p_dup_set_id

Line 1229: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties

1225: l_winner_party_id
1226: ,l_set_obj_version_number;
1227: CLOSE get_dup_sets_info;
1228:
1229: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties
1230: IF (l_set_obj_version_number IS NOT NULL) THEN
1231: IF (l_set_obj_version_number <> px_set_obj_version_number) THEN
1232: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1233: -- row has been changed by another user.

Line 1235: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DUP_SETS');

1231: IF (l_set_obj_version_number <> px_set_obj_version_number) THEN
1232: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1233: -- row has been changed by another user.
1234: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1235: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DUP_SETS');
1236: FND_MSG_PUB.ADD;
1237: RAISE FND_API.G_EXC_ERROR;
1238: END IF;
1239: END IF;

Line 1249: -- is not the same as the winner_party_id in HZ_DUP_SETS

1245: FETCH check_winner_party INTO l_check;
1246: IF check_winner_party%NOTFOUND THEN
1247: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1248: -- the remain party in HZ_DUP_SET_PARTIES which has merge_flag <> 'N'
1249: -- is not the same as the winner_party_id in HZ_DUP_SETS
1250: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_SEL_MASTER');
1251: FND_MSG_PUB.ADD;
1252: RAISE FND_API.G_EXC_ERROR;
1253: END IF;

Line 1258: UPDATE HZ_DUP_SETS

1254: END IF;
1255: CLOSE check_winner_party;
1256:
1257: BEGIN
1258: UPDATE HZ_DUP_SETS
1259: set merge_type = 'SAME_PARTY_MERGE'
1260: , object_version_number = px_set_obj_version_number
1261: , last_update_date = hz_utility_v2pub.last_update_date
1262: , last_updated_by = hz_utility_v2pub.last_updated_by

Line 1269: from HZ_DUP_SETS

1265:
1266: DELETE HZ_DUP_SET_PARTIES
1267: where dup_party_id not in
1268: ( select winner_party_id
1269: from HZ_DUP_SETS
1270: where dup_set_id = p_dup_set_id )
1271: and dup_set_id = p_dup_set_id;
1272: EXCEPTION
1273: WHEN NO_DATA_FOUND THEN

Line 1319: from HZ_DUP_SETS

1315: IS
1316:
1317: cursor get_dup_sets_info is
1318: select winner_party_id, object_version_number
1319: from HZ_DUP_SETS
1320: where dup_set_id = p_dup_set_id;
1321:
1322: l_winner_party_id NUMBER;
1323: l_set_obj_version_number NUMBER;

Line 1342: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties

1338: l_winner_party_id
1339: ,l_set_obj_version_number;
1340: CLOSE get_dup_sets_info;
1341:
1342: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties
1343: IF (l_set_obj_version_number IS NOT NULL) THEN
1344: IF (l_set_obj_version_number <> px_set_obj_version_number) THEN
1345: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1346: -- row has been changed by another user.

Line 1348: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DUP_SETS');

1344: IF (l_set_obj_version_number <> px_set_obj_version_number) THEN
1345: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1346: -- row has been changed by another user.
1347: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1348: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DUP_SETS');
1349: FND_MSG_PUB.ADD;
1350: RAISE FND_API.G_EXC_ERROR;
1351: END IF;
1352: END IF;

Line 1372: UPDATE HZ_DUP_SETS

1368: WHEN NO_DATA_FOUND THEN
1369: NULL;
1370: END;
1371:
1372: UPDATE HZ_DUP_SETS
1373: set status = 'REJECTED'
1374: , object_version_number = px_set_obj_version_number
1375: , last_update_date = hz_utility_v2pub.last_update_date
1376: , last_updated_by = hz_utility_v2pub.last_updated_by

Line 1463: UPDATE HZ_DUP_SETS

1459:
1460: if l_user_id is not null
1461: then
1462:
1463: UPDATE HZ_DUP_SETS
1464: SET assigned_to_user_id = l_user_id
1465: , last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
1466: , last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
1467: , last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

Line 1505: FROM hz_dup_sets

1501: SAVEPOINT submit_dup;
1502:
1503: SELECT status , request_id
1504: INTO l_dup_status ,l_last_request_id
1505: FROM hz_dup_sets
1506: WHERE dup_set_id = p_dup_set_id;
1507:
1508: IF l_last_request_id IS NOT NULL THEN
1509: call_status := FND_CONCURRENT.GET_REQUEST_STATUS(

Line 1533: UPDATE HZ_DUP_SETS

1529: RAISE FND_API.G_EXC_ERROR;
1530: END IF;
1531:
1532: IF l_request_id is not null Then
1533: UPDATE HZ_DUP_SETS
1534: SET status = 'PREPROCESS',
1535: request_id = l_request_id,
1536: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1537: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 1559: UPDATE HZ_DUP_SETS

1555: RAISE FND_API.G_EXC_ERROR;
1556: END IF;
1557:
1558: IF l_request_id is not null Then
1559: UPDATE HZ_DUP_SETS
1560: SET status = 'PREPROCESS',
1561: request_id = l_request_id,
1562: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1563: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 1635: from HZ_DUP_SETS

1631: and mb.batch_id = p_dup_set_id;
1632:
1633: cursor get_dup_set_obj_version is
1634: select nvl(object_version_number,-1)
1635: from HZ_DUP_SETS
1636: where dup_set_id = p_dup_set_id;
1637:
1638: BEGIN
1639:

Line 1641: UPDATE HZ_DUP_SETS

1637:
1638: BEGIN
1639:
1640: -- Stamp concurrent request id to dup sets
1641: UPDATE HZ_DUP_SETS
1642: SET REQUEST_ID = hz_utility_v2pub.request_id
1643: WHERE dup_set_id = p_dup_set_id;
1644: COMMIT;
1645:

Line 1742: UPDATE HZ_DUP_SETS

1738: FND_FILE.PUT_LINE (FND_FILE.LOG, 'HZ_DUP_PVT.create_merge unexpected error. ');
1739: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1741: ELSIF (l_return_status = 'S') THEN
1742: UPDATE HZ_DUP_SETS
1743: set status = 'REQUESTED'
1744: , last_update_date = hz_utility_v2pub.last_update_date
1745: , last_updated_by = hz_utility_v2pub.last_updated_by
1746: , last_update_login = hz_utility_v2pub.last_update_login

Line 1785: UPDATE HZ_DUP_SETS

1781: EXCEPTION
1782:
1783: WHEN FND_API.G_EXC_ERROR THEN
1784: ROLLBACK TO create_merge_pvt;
1785: UPDATE HZ_DUP_SETS
1786: SET STATUS = 'ERROR'
1787: WHERE DUP_SET_ID = p_dup_set_id;
1788: COMMIT;
1789: Retcode := 2;

Line 1796: UPDATE HZ_DUP_SETS

1792: Errbuf := logerror(SQLERRM);
1793:
1794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1795: ROLLBACK TO create_merge_pvt;
1796: UPDATE HZ_DUP_SETS
1797: SET STATUS = 'ERROR'
1798: WHERE DUP_SET_ID = p_dup_set_id;
1799: COMMIT;
1800: Retcode := 2;

Line 1807: UPDATE HZ_DUP_SETS

1803: Errbuf := logerror(SQLERRM);
1804:
1805: WHEN OTHERS THEN
1806: ROLLBACK TO create_merge_pvt;
1807: UPDATE HZ_DUP_SETS
1808: SET STATUS = 'ERROR'
1809: WHERE DUP_SET_ID = p_dup_set_id;
1810: COMMIT;
1811: Retcode := 2;

Line 2109: from hz_dup_sets

2105: ,x_msg_data OUT NOCOPY VARCHAR2 ) is
2106:
2107: cursor validate_reprocess_req_csr is
2108: select count(*)
2109: from hz_dup_sets
2110: where status in ('REJECTED', 'COMPLETED','SUBMITTED')
2111: and dup_set_id = p_dup_set_id;
2112: l_count number;
2113: begin

Line 2185: from hz_dup_sets

2181: procedure reset_dup_set_status is
2182:
2183: cursor get_submitted_count_csr is
2184: select count(*)
2185: from hz_dup_sets
2186: where status = 'SUBMITTED'
2187: and rownum = 1; /* as long as we have one submitted status */
2188: l_count number;
2189: begin

Line 2197: update hz_dup_sets

2193: close get_submitted_count_csr;
2194:
2195: if l_count > 0
2196: then
2197: update hz_dup_sets
2198: set status = 'ERROR'
2199: where dup_set_id in
2200: (select dup_set_id
2201: from HZ_MERGE_BATCH mb,

Line 2202: HZ_DUP_SETS ds,

2198: set status = 'ERROR'
2199: where dup_set_id in
2200: (select dup_set_id
2201: from HZ_MERGE_BATCH mb,
2202: HZ_DUP_SETS ds,
2203: Fnd_Concurrent_Requests r,
2204: FND_CONCURRENT_PROGRAMS cp
2205: where
2206: mb.batch_id = ds.dup_set_id

Line 2218: update hz_dup_sets

2214:
2215:
2216: /* handle the case that requests have been deleted from the Fnd_Concurrent_Requests*/
2217:
2218: update hz_dup_sets
2219: set status = 'ERROR'
2220: where dup_set_id in
2221: (select dup_set_id
2222: from HZ_MERGE_BATCH mb,

Line 2223: HZ_DUP_SETS ds,

2219: set status = 'ERROR'
2220: where dup_set_id in
2221: (select dup_set_id
2222: from HZ_MERGE_BATCH mb,
2223: HZ_DUP_SETS ds,
2224: Fnd_Concurrent_Requests r
2225: where
2226: mb.batch_id = ds.dup_set_id
2227: and r.request_id(+) = mb.request_id