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_DQM_DUP_ID_PKG dependencies on HZ_DUP_SET_PARTIES

Line 20: | into hz_dup_set_parties.

16: |
17: | HISTORY
18: | 13-MAY-2003 : VJN Created
19: | 7-JUL-2005 Ramesh Ch Bug No: 4244529.Modified insert stmts to denormalize dup_batch_id
20: | into hz_dup_set_parties.
21: | 18-OCT-2005 Ravi Epuri : Bug No: 4669400. Modified the 2 instances of OPEN pt_cur CURSOR, in tca_dup_id_worker
22: | Procedure, to make sure it does not consider Merged and Inactive Parties for duplicate
23: | identification, by adding the filter condition 'Status = A', in the where clause.
24: | 12-JUL-2006 : Raj Bug 5393826: Made changed to procedure report_int_dup_party_osrs.

Line 743: -- REPORT WINNER AND ALL ITS DUPLICATES ( ONE OR MORE) TO HZ_DUP_SET_PARTIES

739: FND_FILE.put_line(FND_FILE.log,'Parties ::: Number of parties inserted to Dup Sets '||SQL%ROWCOUNT);
740: FND_FILE.put_line(FND_FILE.log,'Parties ::: End time of insert '||to_char(sysdate,'hh24:mi:ss'));
741:
742:
743: -- REPORT WINNER AND ALL ITS DUPLICATES ( ONE OR MORE) TO HZ_DUP_SET_PARTIES
744:
745: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------------------');
746: FND_FILE.put_line(FND_FILE.log,'Parties ::: Begin time of insert '||to_char(sysdate,'hh24:mi:ss'));
747:

Line 750: insert into hz_dup_set_parties (dup_party_id, dup_set_id,merge_seq_id,

746: FND_FILE.put_line(FND_FILE.log,'Parties ::: Begin time of insert '||to_char(sysdate,'hh24:mi:ss'));
747:
748:
749: -- this is the part for the winner
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,

Line 1072: -- report duplicate parties to hz_dup_sets aand hz_dup_set_parties

1068: -- sanitize data in temp tables that get populated by the match rule
1069: sanitize_tca_dup_parties ( x_threshold, x_auto_merge_threshold, p_subset_sql,
1070: p_within_subset);
1071:
1072: -- report duplicate parties to hz_dup_sets aand hz_dup_set_parties
1073: report_tca_dup_parties (
1074: p_dup_batch_id, x_threshold, x_auto_merge_threshold );
1075:
1076: -- exception block

Line 1270: -- INSERT WINNER AND ALL ITS DUPLICATES TO HZ_DUP_SET_PARTIES

1266: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------------------');
1267: FND_FILE.put_line(FND_FILE.log,'Parties ::: Number of parties inserted to Dup Sets '|| p_count );
1268: FND_FILE.put_line(FND_FILE.log,'Parties ::: End time of insert '||to_char(sysdate,'hh24:mi:ss'));
1269:
1270: -- INSERT WINNER AND ALL ITS DUPLICATES TO HZ_DUP_SET_PARTIES
1271: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------------------');
1272: FND_FILE.put_line(FND_FILE.log,'Parties ::: Begin time of insert '||to_char(sysdate,'hh24:mi:ss'));
1273: -- this is the part for the winner
1274: insert into hz_dup_set_parties (dup_party_id, dup_set_id,merge_seq_id,

Line 1274: insert into hz_dup_set_parties (dup_party_id, dup_set_id,merge_seq_id,

1270: -- INSERT WINNER AND ALL ITS DUPLICATES TO HZ_DUP_SET_PARTIES
1271: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------------------');
1272: FND_FILE.put_line(FND_FILE.log,'Parties ::: Begin time of insert '||to_char(sysdate,'hh24:mi:ss'));
1273: -- this is the part for the winner
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,

Line 1301: -- The total number of parties inserted into hz_dup_set_parties

1297: and b.party_id = c.party_id
1298: and c.request_id = p_request_id
1299: and b.auto_merge_flag <> 'R' ;
1300:
1301: -- The total number of parties inserted into hz_dup_set_parties
1302: l_party_count := SQL%ROWCOUNT ;
1303:
1304: FND_FILE.put_line(FND_FILE.log,'Parties ::: Number of parties inserted to Dup Set Parties '|| l_party_count);
1305: FND_FILE.put_line(FND_FILE.log,'Parties ::: End time of insert '||to_char(sysdate,'hh24:mi:ss'));

Line 1401: -- INSERT INTO HZ_DUP_SET_PARTIES, ALL THE WINNERS FROM HZ_DUP_SETS

1397: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------------------');
1398: FND_FILE.put_line(FND_FILE.log,'Details ::: Number of parties inserted to Dup Sets '||SQL%ROWCOUNT);
1399: FND_FILE.put_line(FND_FILE.log,'Details ::: End time of insert '||to_char(sysdate,'hh24:mi:ss'));
1400:
1401: -- INSERT INTO HZ_DUP_SET_PARTIES, ALL THE WINNERS FROM HZ_DUP_SETS
1402: -- FOR THE GIVEN BATCH
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

Line 1403: insert into hz_dup_set_parties (dup_party_id, dup_set_id,merge_seq_id,

1399: FND_FILE.put_line(FND_FILE.log,'Details ::: End time of insert '||to_char(sysdate,'hh24:mi:ss'));
1400:
1401: -- INSERT INTO HZ_DUP_SET_PARTIES, ALL THE WINNERS FROM HZ_DUP_SETS
1402: -- FOR THE GIVEN BATCH
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,

Line 2331: -- THAT WILL BE THE BASIS FOR REPORTING TO HZ_DUP_SETS AND HZ_DUP_SET_PARTIES

2327: where a.fid=b.tid and b.fid=a.tid and a.score < b.score) ;
2328:
2329: ------------------------------------------------------------------------------------------------------
2330: -- Step 2 - IDENTIFY DUP SETS AND REPORT THEM APPROPRIATELY, TO ANOTHER TEMP TABLE
2331: -- THAT WILL BE THE BASIS FOR REPORTING TO HZ_DUP_SETS AND HZ_DUP_SET_PARTIES
2332: ------------------------------------------------------------------------------------------------------
2333:
2334: -- Now call the stored program
2335: identify_dup_sets('T',x_return_status,x_msg_count,x_msg_data);

Line 2510: -- Insert winner and its only duplicate, into HZ_DUP_SET_PARTIES

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
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'),

Line 2511: insert into hz_dup_set_parties (dup_party_id,dup_set_id,merge_seq_id,

2507: from hz_dup_results
2508: where flag = 'ND' ;
2509:
2510: -- Insert winner and its only duplicate, into HZ_DUP_SET_PARTIES
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,

Line 2521: insert into hz_dup_set_parties (dup_party_id,dup_set_id,merge_seq_id,

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,
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,

Line 2546: -- Insert winner party and all its duplicates into HZ_DUP_SET_PARTIES

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
2547:
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

Line 2548: insert into hz_dup_set_parties (dup_party_id,dup_set_id,merge_seq_id,

2544: where flag <> 'ND' ;
2545:
2546: -- Insert winner party and all its duplicates into HZ_DUP_SET_PARTIES
2547:
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,