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_MERGE_BATCH_S

Line 721: select win_party_id, HZ_MERGE_BATCH_S.nextval, p_batch_id,

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

Line 1245: select win_party_id, HZ_MERGE_BATCH_S.nextval, l_dup_batch_id,

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

Line 1361: select win_party_id, HZ_MERGE_BATCH_S.nextval, l_dup_batch_id,

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

Line 2387: SELECT HZ_MERGE_BATCH_S.nextval INTO x_dup_set_id FROM DUAL;

2383: IF rowCount = 0
2384: THEN
2385: master_party_id := to_char(p_fid);
2386: -- get the sequence from HZ_DUP_SETS
2387: SELECT HZ_MERGE_BATCH_S.nextval INTO x_dup_set_id FROM DUAL;
2388: END IF;
2389:
2390: -- Stamp all intersecting rows (including the passed in row itself), that still have a 'D' flag,
2391: -- with the stamp of the Master and also populate the dup set id column

Line 2412: set dup_set_id = HZ_MERGE_BATCH_S.nextval

2408:
2409: -- Stamp the dup set id column of all rows with flag = 'ND', with sequence obtained from
2410: -- HZ_DUP_SETS
2411: update hz_dup_results a
2412: set dup_set_id = HZ_MERGE_BATCH_S.nextval
2413: where a.flag = 'ND' ;
2414: return 0 ;
2415: END stamp_trivial_dup_sets ;
2416: