APPS.HZ_DQM_DUP_ID_PKG dependencies on HZ_UTILITY_PUB

Line 722: 'SYSBATCH', 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,

718: insert into hz_dup_sets ( winner_party_id, dup_set_id, dup_batch_id,
719: status, merge_type, created_by, creation_date, last_update_login,
720: last_update_date, last_updated_by)
721: select win_party_id, HZ_MERGE_BATCH_S.nextval, p_batch_id,
722: 'SYSBATCH', 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
723: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
724: hz_utility_pub.user_id
725: from
726: (

Line 723: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

719: status, merge_type, created_by, creation_date, last_update_login,
720: last_update_date, last_updated_by)
721: select win_party_id, HZ_MERGE_BATCH_S.nextval, p_batch_id,
722: 'SYSBATCH', 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
723: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
724: hz_utility_pub.user_id
725: from
726: (
727: select distinct d.ord_fid as win_party_id, level as levelu

Line 724: hz_utility_pub.user_id

720: last_update_date, last_updated_by)
721: select win_party_id, HZ_MERGE_BATCH_S.nextval, p_batch_id,
722: 'SYSBATCH', 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
723: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
724: hz_utility_pub.user_id
725: from
726: (
727: select distinct d.ord_fid as win_party_id, level as levelu
728: from hz_dup_results d

Line 754: hz_utility_pub.created_by,hz_utility_pub.creation_date,

750: insert into hz_dup_set_parties (dup_party_id, dup_set_id,merge_seq_id,
751: merge_batch_id,score,merge_flag, created_by,creation_date,last_update_login,
752: last_update_date,last_updated_by,dup_set_batch_id) --Bug No: 4244529
753: select a.winner_party_id, a.dup_set_id, 0, 0, 100 ,'Y',
754: hz_utility_pub.created_by,hz_utility_pub.creation_date,
755: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
756: hz_utility_pub.user_id,a.dup_batch_id --Bug No: 4244529
757: from hz_dup_sets a
758: where a.dup_batch_id = p_batch_id

Line 755: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

751: merge_batch_id,score,merge_flag, created_by,creation_date,last_update_login,
752: last_update_date,last_updated_by,dup_set_batch_id) --Bug No: 4244529
753: select a.winner_party_id, a.dup_set_id, 0, 0, 100 ,'Y',
754: hz_utility_pub.created_by,hz_utility_pub.creation_date,
755: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
756: hz_utility_pub.user_id,a.dup_batch_id --Bug No: 4244529
757: from hz_dup_sets a
758: where a.dup_batch_id = p_batch_id
759: union all

Line 756: hz_utility_pub.user_id,a.dup_batch_id --Bug No: 4244529

752: last_update_date,last_updated_by,dup_set_batch_id) --Bug No: 4244529
753: select a.winner_party_id, a.dup_set_id, 0, 0, 100 ,'Y',
754: hz_utility_pub.created_by,hz_utility_pub.creation_date,
755: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
756: hz_utility_pub.user_id,a.dup_batch_id --Bug No: 4244529
757: from hz_dup_sets a
758: where a.dup_batch_id = p_batch_id
759: union all
760: -- this is the part for all the duplicates of the winner

Line 764: hz_utility_pub.created_by,hz_utility_pub.creation_date,

760: -- this is the part for all the duplicates of the winner
761: -- basically compare the winner from dup set to any row which has the winner has its ord_fid
762: -- and pick up its ord_tid.
763: select b.ord_tid, a.dup_set_id, 0, 0, b.score ,decode( sign(b.score - p_auto_merge_threshold),-1,'N','Y'),
764: hz_utility_pub.created_by,hz_utility_pub.creation_date,
765: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
766: hz_utility_pub.user_id,a.dup_batch_id
767: from hz_dup_sets a, hz_dup_results b
768: where a.dup_batch_id = p_batch_id

Line 765: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

761: -- basically compare the winner from dup set to any row which has the winner has its ord_fid
762: -- and pick up its ord_tid.
763: select b.ord_tid, a.dup_set_id, 0, 0, b.score ,decode( sign(b.score - p_auto_merge_threshold),-1,'N','Y'),
764: hz_utility_pub.created_by,hz_utility_pub.creation_date,
765: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
766: hz_utility_pub.user_id,a.dup_batch_id
767: from hz_dup_sets a, hz_dup_results b
768: where a.dup_batch_id = p_batch_id
769: and a.winner_party_id = b.ord_fid ;

Line 766: hz_utility_pub.user_id,a.dup_batch_id

762: -- and pick up its ord_tid.
763: select b.ord_tid, a.dup_set_id, 0, 0, b.score ,decode( sign(b.score - p_auto_merge_threshold),-1,'N','Y'),
764: hz_utility_pub.created_by,hz_utility_pub.creation_date,
765: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
766: hz_utility_pub.user_id,a.dup_batch_id
767: from hz_dup_sets a, hz_dup_results b
768: where a.dup_batch_id = p_batch_id
769: and a.winner_party_id = b.ord_fid ;
770:

Line 1246: 'SYSBATCH', 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,

1242: insert into hz_dup_sets ( winner_party_id, dup_set_id, dup_batch_id,
1243: status, merge_type, created_by, creation_date, last_update_login,
1244: last_update_date, last_updated_by)
1245: select win_party_id, HZ_MERGE_BATCH_S.nextval, l_dup_batch_id,
1246: 'SYSBATCH', 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
1247: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
1248: hz_utility_pub.user_id
1249: from
1250: (select distinct h.dup_party_id as win_party_id

Line 1247: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

1243: status, merge_type, created_by, creation_date, last_update_login,
1244: last_update_date, last_updated_by)
1245: select win_party_id, HZ_MERGE_BATCH_S.nextval, l_dup_batch_id,
1246: 'SYSBATCH', 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
1247: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
1248: hz_utility_pub.user_id
1249: from
1250: (select distinct h.dup_party_id as win_party_id
1251: from hz_imp_dup_parties h

Line 1248: hz_utility_pub.user_id

1244: last_update_date, last_updated_by)
1245: select win_party_id, HZ_MERGE_BATCH_S.nextval, l_dup_batch_id,
1246: 'SYSBATCH', 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
1247: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
1248: hz_utility_pub.user_id
1249: from
1250: (select distinct h.dup_party_id as win_party_id
1251: from hz_imp_dup_parties h
1252: where h.batch_id = p_batch_id

Line 1278: hz_utility_pub.created_by,hz_utility_pub.creation_date,

1274: insert into hz_dup_set_parties (dup_party_id, dup_set_id,merge_seq_id,
1275: merge_batch_id,score,merge_flag, created_by,creation_date,last_update_login,
1276: last_update_date,last_updated_by,dup_set_batch_id) --Bug No: 4244529
1277: select a.winner_party_id, a.dup_set_id, 0, 0, 100 ,'Y',
1278: hz_utility_pub.created_by,hz_utility_pub.creation_date,
1279: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
1280: hz_utility_pub.user_id,a.dup_batch_id --Bug No: 4244529
1281: from hz_dup_sets a
1282: where a.dup_batch_id = l_dup_batch_id

Line 1279: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

1275: merge_batch_id,score,merge_flag, created_by,creation_date,last_update_login,
1276: last_update_date,last_updated_by,dup_set_batch_id) --Bug No: 4244529
1277: select a.winner_party_id, a.dup_set_id, 0, 0, 100 ,'Y',
1278: hz_utility_pub.created_by,hz_utility_pub.creation_date,
1279: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
1280: hz_utility_pub.user_id,a.dup_batch_id --Bug No: 4244529
1281: from hz_dup_sets a
1282: where a.dup_batch_id = l_dup_batch_id
1283: union all

Line 1280: hz_utility_pub.user_id,a.dup_batch_id --Bug No: 4244529

1276: last_update_date,last_updated_by,dup_set_batch_id) --Bug No: 4244529
1277: select a.winner_party_id, a.dup_set_id, 0, 0, 100 ,'Y',
1278: hz_utility_pub.created_by,hz_utility_pub.creation_date,
1279: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
1280: hz_utility_pub.user_id,a.dup_batch_id --Bug No: 4244529
1281: from hz_dup_sets a
1282: where a.dup_batch_id = l_dup_batch_id
1283: union all
1284: -- this is the part for all the duplicates of the winner

Line 1291: hz_utility_pub.created_by,hz_utility_pub.creation_date,

1287: -- provided the following conditions are met:
1288: -- 1. The interface party id has been loaded
1289: -- 2. The interface party id does not have an automerge flag of 'R'
1290: select b.party_id, a.dup_set_id, 0, p_batch_id, b.score , b.auto_merge_flag,
1291: hz_utility_pub.created_by,hz_utility_pub.creation_date,
1292: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
1293: hz_utility_pub.user_id,a.dup_batch_id --Bug No: 4244529
1294: from hz_dup_sets a, hz_imp_dup_parties b, hz_parties c
1295: where a.dup_batch_id = l_dup_batch_id

Line 1292: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

1288: -- 1. The interface party id has been loaded
1289: -- 2. The interface party id does not have an automerge flag of 'R'
1290: select b.party_id, a.dup_set_id, 0, p_batch_id, b.score , b.auto_merge_flag,
1291: hz_utility_pub.created_by,hz_utility_pub.creation_date,
1292: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
1293: hz_utility_pub.user_id,a.dup_batch_id --Bug No: 4244529
1294: from hz_dup_sets a, hz_imp_dup_parties b, hz_parties c
1295: where a.dup_batch_id = l_dup_batch_id
1296: and a.winner_party_id = b.dup_party_id

Line 1293: hz_utility_pub.user_id,a.dup_batch_id --Bug No: 4244529

1289: -- 2. The interface party id does not have an automerge flag of 'R'
1290: select b.party_id, a.dup_set_id, 0, p_batch_id, b.score , b.auto_merge_flag,
1291: hz_utility_pub.created_by,hz_utility_pub.creation_date,
1292: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
1293: hz_utility_pub.user_id,a.dup_batch_id --Bug No: 4244529
1294: from hz_dup_sets a, hz_imp_dup_parties b, hz_parties c
1295: where a.dup_batch_id = l_dup_batch_id
1296: and a.winner_party_id = b.dup_party_id
1297: and b.party_id = c.party_id

Line 1362: 'SYSBATCH', 'SAME_PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,

1358: insert into hz_dup_sets ( winner_party_id, dup_set_id, dup_batch_id,
1359: status, merge_type, created_by, creation_date, last_update_login,
1360: last_update_date, last_updated_by)
1361: select win_party_id, HZ_MERGE_BATCH_S.nextval, l_dup_batch_id,
1362: 'SYSBATCH', 'SAME_PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
1363: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
1364: hz_utility_pub.user_id
1365: from
1366: (select distinct h.party_id as win_party_id

Line 1363: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

1359: status, merge_type, created_by, creation_date, last_update_login,
1360: last_update_date, last_updated_by)
1361: select win_party_id, HZ_MERGE_BATCH_S.nextval, l_dup_batch_id,
1362: 'SYSBATCH', 'SAME_PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
1363: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
1364: hz_utility_pub.user_id
1365: from
1366: (select distinct h.party_id as win_party_id
1367: from hz_imp_dup_details h

Line 1364: hz_utility_pub.user_id

1360: last_update_date, last_updated_by)
1361: select win_party_id, HZ_MERGE_BATCH_S.nextval, l_dup_batch_id,
1362: 'SYSBATCH', 'SAME_PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
1363: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
1364: hz_utility_pub.user_id
1365: from
1366: (select distinct h.party_id as win_party_id
1367: from hz_imp_dup_details h
1368: where h.batch_id = p_batch_id

Line 1407: hz_utility_pub.created_by,hz_utility_pub.creation_date,

1403: insert into hz_dup_set_parties (dup_party_id, dup_set_id,merge_seq_id,
1404: merge_batch_id,score,merge_flag, created_by,creation_date,last_update_login,
1405: last_update_date,last_updated_by,dup_set_batch_id) --Bug No: 4244529
1406: select a.winner_party_id, a.dup_set_id, 0, 0, 100 ,'Y',
1407: hz_utility_pub.created_by,hz_utility_pub.creation_date,
1408: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
1409: hz_utility_pub.user_id,a.dup_batch_id --Bug No: 4244529
1410: from hz_dup_sets a
1411: where a.dup_batch_id = l_dup_batch_id

Line 1408: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

1404: merge_batch_id,score,merge_flag, created_by,creation_date,last_update_login,
1405: last_update_date,last_updated_by,dup_set_batch_id) --Bug No: 4244529
1406: select a.winner_party_id, a.dup_set_id, 0, 0, 100 ,'Y',
1407: hz_utility_pub.created_by,hz_utility_pub.creation_date,
1408: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
1409: hz_utility_pub.user_id,a.dup_batch_id --Bug No: 4244529
1410: from hz_dup_sets a
1411: where a.dup_batch_id = l_dup_batch_id
1412: and a.merge_type = 'SAME_PARTY_MERGE';

Line 1409: hz_utility_pub.user_id,a.dup_batch_id --Bug No: 4244529

1405: last_update_date,last_updated_by,dup_set_batch_id) --Bug No: 4244529
1406: select a.winner_party_id, a.dup_set_id, 0, 0, 100 ,'Y',
1407: hz_utility_pub.created_by,hz_utility_pub.creation_date,
1408: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
1409: hz_utility_pub.user_id,a.dup_batch_id --Bug No: 4244529
1410: from hz_dup_sets a
1411: where a.dup_batch_id = l_dup_batch_id
1412: and a.merge_type = 'SAME_PARTY_MERGE';
1413:

Line 1834: 'PARTY', 0, hz_utility_pub.creation_date, hz_utility_pub.last_update_date

1830: ,created_by,creation_date,last_update_login
1831: ,last_update_date,last_updated_by)
1832:
1833: select p_batch_id, win_party_osr,win_party_os, win_party_osr, win_party_os,
1834: 'PARTY', 0, hz_utility_pub.creation_date, hz_utility_pub.last_update_date
1835: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date
1836: ,hz_utility_v2pub.last_update_login,hz_utility_v2pub.last_update_date
1837: ,hz_utility_v2pub.last_updated_by
1838: from

Line 1866: 'PARTY', 0, hz_utility_pub.creation_date, hz_utility_pub.last_update_date

1862: score, dup_creation_date, dup_last_update_date
1863: ,created_by,creation_date,last_update_login
1864: ,last_update_date,last_updated_by)
1865: select p_batch_id, win_party_osr,win_party_os, win_party_osr, win_party_os,
1866: 'PARTY', 0, hz_utility_pub.creation_date, hz_utility_pub.last_update_date
1867: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date
1868: ,hz_utility_v2pub.last_update_login,hz_utility_v2pub.last_update_date
1869: ,hz_utility_v2pub.last_updated_by
1870: from

Line 1901: 'PARTY', b.score, hz_utility_pub.creation_date, hz_utility_pub.last_update_date

1897: score, dup_creation_date, dup_last_update_date
1898: ,created_by,creation_date,last_update_login
1899: ,last_update_date,last_updated_by)
1900: select p_batch_id, a.winner_record_osr,a.winner_record_os, b.ord_t_osr, b.t_os,
1901: 'PARTY', b.score, hz_utility_pub.creation_date, hz_utility_pub.last_update_date
1902: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date
1903: ,hz_utility_v2pub.last_update_login,hz_utility_v2pub.last_update_date
1904: ,hz_utility_v2pub.last_updated_by
1905: from hz_imp_int_dedup_results a, hz_int_dup_results_gt b

Line 2504: 'SYSBATCH', 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,

2500: insert into hz_dup_sets ( dup_set_id, dup_batch_id, winner_party_id,
2501: status, merge_type, created_by, creation_date, last_update_login,
2502: last_update_date, last_updated_by)
2503: select dup_set_id, p_batch_id, fid,
2504: 'SYSBATCH', 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
2505: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
2506: hz_utility_pub.user_id
2507: from hz_dup_results
2508: where flag = 'ND' ;

Line 2505: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

2501: status, merge_type, created_by, creation_date, last_update_login,
2502: last_update_date, last_updated_by)
2503: select dup_set_id, p_batch_id, fid,
2504: 'SYSBATCH', 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
2505: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
2506: hz_utility_pub.user_id
2507: from hz_dup_results
2508: where flag = 'ND' ;
2509:

Line 2506: hz_utility_pub.user_id

2502: last_update_date, last_updated_by)
2503: select dup_set_id, p_batch_id, fid,
2504: 'SYSBATCH', 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
2505: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
2506: hz_utility_pub.user_id
2507: from hz_dup_results
2508: where flag = 'ND' ;
2509:
2510: -- Insert winner and its only duplicate, into HZ_DUP_SET_PARTIES

Line 2515: hz_utility_pub.created_by,hz_utility_pub.creation_date,

2511: insert into hz_dup_set_parties (dup_party_id,dup_set_id,merge_seq_id,
2512: merge_batch_id,score,merge_flag,created_by,creation_date,last_update_login,
2513: last_update_date,last_updated_by,dup_set_batch_id) --Bug No: 4244529
2514: select fid, dup_set_id, 0, p_batch_id, score, decode( sign(score - x_auto_merge_threshold),-1,'N','Y'),
2515: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2516: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
2517: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529
2518: from hz_dup_results
2519: where flag = 'ND';

Line 2516: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

2512: merge_batch_id,score,merge_flag,created_by,creation_date,last_update_login,
2513: last_update_date,last_updated_by,dup_set_batch_id) --Bug No: 4244529
2514: select fid, dup_set_id, 0, p_batch_id, score, decode( sign(score - x_auto_merge_threshold),-1,'N','Y'),
2515: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2516: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
2517: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529
2518: from hz_dup_results
2519: where flag = 'ND';
2520:

Line 2517: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529

2513: last_update_date,last_updated_by,dup_set_batch_id) --Bug No: 4244529
2514: select fid, dup_set_id, 0, p_batch_id, score, decode( sign(score - x_auto_merge_threshold),-1,'N','Y'),
2515: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2516: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
2517: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529
2518: from hz_dup_results
2519: where flag = 'ND';
2520:
2521: insert into hz_dup_set_parties (dup_party_id,dup_set_id,merge_seq_id,

Line 2525: hz_utility_pub.created_by,hz_utility_pub.creation_date,

2521: insert into hz_dup_set_parties (dup_party_id,dup_set_id,merge_seq_id,
2522: merge_batch_id,score,merge_flag, created_by,creation_date,last_update_login,
2523: last_update_date,last_updated_by,dup_set_batch_id) --Bug No: 4244529
2524: select tid, dup_set_id, 0,p_batch_id, score,decode( sign(score - x_auto_merge_threshold),-1,'N','Y'),
2525: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2526: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
2527: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529
2528: from hz_dup_results
2529: where flag = 'ND';

Line 2526: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

2522: merge_batch_id,score,merge_flag, created_by,creation_date,last_update_login,
2523: last_update_date,last_updated_by,dup_set_batch_id) --Bug No: 4244529
2524: select tid, dup_set_id, 0,p_batch_id, score,decode( sign(score - x_auto_merge_threshold),-1,'N','Y'),
2525: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2526: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
2527: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529
2528: from hz_dup_results
2529: where flag = 'ND';
2530:

Line 2527: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529

2523: last_update_date,last_updated_by,dup_set_batch_id) --Bug No: 4244529
2524: select tid, dup_set_id, 0,p_batch_id, score,decode( sign(score - x_auto_merge_threshold),-1,'N','Y'),
2525: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2526: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
2527: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529
2528: from hz_dup_results
2529: where flag = 'ND';
2530:
2531: ------------------------------------------------------

Line 2540: 'SYSBATCH', 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,

2536: insert into hz_dup_sets ( dup_set_id, dup_batch_id, winner_party_id,
2537: status, merge_type, created_by, creation_date, last_update_login,
2538: last_update_date, last_updated_by)
2539: select distinct dup_set_id, p_batch_id, flag ,
2540: 'SYSBATCH', 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
2541: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
2542: hz_utility_pub.user_id
2543: from hz_dup_results
2544: where flag <> 'ND' ;

Line 2541: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

2537: status, merge_type, created_by, creation_date, last_update_login,
2538: last_update_date, last_updated_by)
2539: select distinct dup_set_id, p_batch_id, flag ,
2540: 'SYSBATCH', 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
2541: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
2542: hz_utility_pub.user_id
2543: from hz_dup_results
2544: where flag <> 'ND' ;
2545:

Line 2542: hz_utility_pub.user_id

2538: last_update_date, last_updated_by)
2539: select distinct dup_set_id, p_batch_id, flag ,
2540: 'SYSBATCH', 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
2541: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
2542: hz_utility_pub.user_id
2543: from hz_dup_results
2544: where flag <> 'ND' ;
2545:
2546: -- Insert winner party and all its duplicates into HZ_DUP_SET_PARTIES

Line 2552: hz_utility_pub.created_by,hz_utility_pub.creation_date,

2548: insert into hz_dup_set_parties (dup_party_id,dup_set_id,merge_seq_id,
2549: merge_batch_id,score,merge_flag, created_by,creation_date,last_update_login,
2550: last_update_date,last_updated_by,dup_set_batch_id) --Bug No: 4244529
2551: select distinct to_number(flag), dup_set_id, 0, p_batch_id, score ,decode( sign(score - x_auto_merge_threshold),-1,'N','Y'),
2552: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2553: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
2554: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529
2555: from hz_dup_results
2556: where flag <> 'ND'

Line 2553: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

2549: merge_batch_id,score,merge_flag, created_by,creation_date,last_update_login,
2550: last_update_date,last_updated_by,dup_set_batch_id) --Bug No: 4244529
2551: select distinct to_number(flag), dup_set_id, 0, p_batch_id, score ,decode( sign(score - x_auto_merge_threshold),-1,'N','Y'),
2552: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2553: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
2554: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529
2555: from hz_dup_results
2556: where flag <> 'ND'
2557: union

Line 2554: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529

2550: last_update_date,last_updated_by,dup_set_batch_id) --Bug No: 4244529
2551: select distinct to_number(flag), dup_set_id, 0, p_batch_id, score ,decode( sign(score - x_auto_merge_threshold),-1,'N','Y'),
2552: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2553: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
2554: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529
2555: from hz_dup_results
2556: where flag <> 'ND'
2557: union
2558: select distinct fid, dup_set_id, 0, p_batch_id, score ,decode( sign(score - x_auto_merge_threshold),-1,'N','Y'),

Line 2559: hz_utility_pub.created_by,hz_utility_pub.creation_date,

2555: from hz_dup_results
2556: where flag <> 'ND'
2557: union
2558: select distinct fid, dup_set_id, 0, p_batch_id, score ,decode( sign(score - x_auto_merge_threshold),-1,'N','Y'),
2559: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2560: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
2561: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529
2562: from hz_dup_results
2563: where flag <> 'ND'

Line 2560: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

2556: where flag <> 'ND'
2557: union
2558: select distinct fid, dup_set_id, 0, p_batch_id, score ,decode( sign(score - x_auto_merge_threshold),-1,'N','Y'),
2559: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2560: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
2561: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529
2562: from hz_dup_results
2563: where flag <> 'ND'
2564: union

Line 2561: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529

2557: union
2558: select distinct fid, dup_set_id, 0, p_batch_id, score ,decode( sign(score - x_auto_merge_threshold),-1,'N','Y'),
2559: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2560: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
2561: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529
2562: from hz_dup_results
2563: where flag <> 'ND'
2564: union
2565: select distinct tid, dup_set_id, 0, p_batch_id, score ,decode( sign(score - x_auto_merge_threshold),-1,'N','Y'),

Line 2566: hz_utility_pub.created_by,hz_utility_pub.creation_date,

2562: from hz_dup_results
2563: where flag <> 'ND'
2564: union
2565: select distinct tid, dup_set_id, 0, p_batch_id, score ,decode( sign(score - x_auto_merge_threshold),-1,'N','Y'),
2566: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2567: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
2568: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529
2569: from hz_dup_results
2570: where flag <> 'ND' ;

Line 2567: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

2563: where flag <> 'ND'
2564: union
2565: select distinct tid, dup_set_id, 0, p_batch_id, score ,decode( sign(score - x_auto_merge_threshold),-1,'N','Y'),
2566: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2567: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
2568: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529
2569: from hz_dup_results
2570: where flag <> 'ND' ;
2571:

Line 2568: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529

2564: union
2565: select distinct tid, dup_set_id, 0, p_batch_id, score ,decode( sign(score - x_auto_merge_threshold),-1,'N','Y'),
2566: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2567: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
2568: hz_utility_pub.user_id,p_batch_id --Bug No: 4244529
2569: from hz_dup_results
2570: where flag <> 'ND' ;
2571:
2572: return 0 ;