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_AUTOMERGE_PKG dependencies on HZ_UTILITY_V2PUB

Line 153: HZ_UTILITY_V2PUB.CREATED_BY,

149: insert into hz_dup_sets(winner_party_id, dup_batch_id, dup_set_id, status, merge_type,
150: object_version_number, created_by, creation_date, last_update_login, last_update_date, last_updated_by)
151: values( p_winner_party_id, p_new_dup_batch_id, l_new_dup_set_id, 'SYSBATCH', 'PARTY_MERGE',
152: 1,
153: HZ_UTILITY_V2PUB.CREATED_BY,
154: HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
155: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
156: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
157: OPEN c1(p_DUP_SET_ID, p_winner_party_id);

Line 154: HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

150: object_version_number, created_by, creation_date, last_update_login, last_update_date, last_updated_by)
151: values( p_winner_party_id, p_new_dup_batch_id, l_new_dup_set_id, 'SYSBATCH', 'PARTY_MERGE',
152: 1,
153: HZ_UTILITY_V2PUB.CREATED_BY,
154: HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
155: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
156: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
157: OPEN c1(p_DUP_SET_ID, p_winner_party_id);
158: FETCH c1 into l_w_score;

Line 155: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

151: values( p_winner_party_id, p_new_dup_batch_id, l_new_dup_set_id, 'SYSBATCH', 'PARTY_MERGE',
152: 1,
153: HZ_UTILITY_V2PUB.CREATED_BY,
154: HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
155: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
156: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
157: OPEN c1(p_DUP_SET_ID, p_winner_party_id);
158: FETCH c1 into l_w_score;
159: -- insert row for the dup set and winner party id.

Line 156: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

152: 1,
153: HZ_UTILITY_V2PUB.CREATED_BY,
154: HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
155: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
156: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
157: OPEN c1(p_DUP_SET_ID, p_winner_party_id);
158: FETCH c1 into l_w_score;
159: -- insert row for the dup set and winner party id.
160: insert into hz_dup_set_parties(dup_party_id, dup_set_id, merge_flag, score, created_by,

Line 162: values (p_winner_party_id, l_new_dup_set_id, 'N', l_w_score, HZ_UTILITY_V2PUB.CREATED_BY,

158: FETCH c1 into l_w_score;
159: -- insert row for the dup set and winner party id.
160: insert into hz_dup_set_parties(dup_party_id, dup_set_id, merge_flag, score, created_by,
161: creation_date, last_update_login, last_update_date, last_updated_by,dup_set_batch_id) --Bug No: 4244529
162: values (p_winner_party_id, l_new_dup_set_id, 'N', l_w_score, HZ_UTILITY_V2PUB.CREATED_BY,
163: HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
164: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE, HZ_UTILITY_V2PUB.LAST_UPDATED_BY,p_new_dup_batch_id) ; --Bug No: 4244529
165: CLOSE c1;
166: OPEN c2(p_DUP_SET_ID, p_winner_party_id, p_state);

Line 163: HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

159: -- insert row for the dup set and winner party id.
160: insert into hz_dup_set_parties(dup_party_id, dup_set_id, merge_flag, score, created_by,
161: creation_date, last_update_login, last_update_date, last_updated_by,dup_set_batch_id) --Bug No: 4244529
162: values (p_winner_party_id, l_new_dup_set_id, 'N', l_w_score, HZ_UTILITY_V2PUB.CREATED_BY,
163: HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
164: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE, HZ_UTILITY_V2PUB.LAST_UPDATED_BY,p_new_dup_batch_id) ; --Bug No: 4244529
165: CLOSE c1;
166: OPEN c2(p_DUP_SET_ID, p_winner_party_id, p_state);
167: FETCH c2 bulk collect into l_dup_party_id, l_score;

Line 164: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE, HZ_UTILITY_V2PUB.LAST_UPDATED_BY,p_new_dup_batch_id) ; --Bug No: 4244529

160: insert into hz_dup_set_parties(dup_party_id, dup_set_id, merge_flag, score, created_by,
161: creation_date, last_update_login, last_update_date, last_updated_by,dup_set_batch_id) --Bug No: 4244529
162: values (p_winner_party_id, l_new_dup_set_id, 'N', l_w_score, HZ_UTILITY_V2PUB.CREATED_BY,
163: HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
164: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE, HZ_UTILITY_V2PUB.LAST_UPDATED_BY,p_new_dup_batch_id) ; --Bug No: 4244529
165: CLOSE c1;
166: OPEN c2(p_DUP_SET_ID, p_winner_party_id, p_state);
167: FETCH c2 bulk collect into l_dup_party_id, l_score;
168: log (' l_dup_party_id.count = ' || l_dup_party_id.count);

Line 178: values (l_dup_party_id(I), l_new_dup_set_id, 'N', l_score(I), HZ_UTILITY_V2PUB.CREATED_BY,

174: -- insert row for a particualr dup set and all its parties which are not being
175: -- merged by automerge.
176: insert into hz_dup_set_parties(dup_party_id, dup_set_id, merge_flag, score, created_by,
177: creation_date, last_update_login, last_update_date, last_updated_by,dup_set_batch_id) --Bug No: 4244529
178: values (l_dup_party_id(I), l_new_dup_set_id, 'N', l_score(I), HZ_UTILITY_V2PUB.CREATED_BY,
179: HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
180: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE, HZ_UTILITY_V2PUB.LAST_UPDATED_BY,p_new_dup_batch_id) ; --Bug No: 4244529
181: END LOOP;
182: CLOSE c2;

Line 179: HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

175: -- merged by automerge.
176: insert into hz_dup_set_parties(dup_party_id, dup_set_id, merge_flag, score, created_by,
177: creation_date, last_update_login, last_update_date, last_updated_by,dup_set_batch_id) --Bug No: 4244529
178: values (l_dup_party_id(I), l_new_dup_set_id, 'N', l_score(I), HZ_UTILITY_V2PUB.CREATED_BY,
179: HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
180: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE, HZ_UTILITY_V2PUB.LAST_UPDATED_BY,p_new_dup_batch_id) ; --Bug No: 4244529
181: END LOOP;
182: CLOSE c2;
183: log (' Batch for review created with dup_batch_id = ' ||p_new_dup_batch_id );

Line 180: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE, HZ_UTILITY_V2PUB.LAST_UPDATED_BY,p_new_dup_batch_id) ; --Bug No: 4244529

176: insert into hz_dup_set_parties(dup_party_id, dup_set_id, merge_flag, score, created_by,
177: creation_date, last_update_login, last_update_date, last_updated_by,dup_set_batch_id) --Bug No: 4244529
178: values (l_dup_party_id(I), l_new_dup_set_id, 'N', l_score(I), HZ_UTILITY_V2PUB.CREATED_BY,
179: HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
180: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE, HZ_UTILITY_V2PUB.LAST_UPDATED_BY,p_new_dup_batch_id) ; --Bug No: 4244529
181: END LOOP;
182: CLOSE c2;
183: log (' Batch for review created with dup_batch_id = ' ||p_new_dup_batch_id );
184: EXCEPTION WHEN OTHERS THEN

Line 383: HZ_UTILITY_V2PUB.CREATED_BY, HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

379: insert into hz_dup_batch(dup_batch_id, dup_batch_name, match_rule_id, request_type,
380: created_by, creation_date, last_update_login, last_update_date,
381: last_updated_by, application_id)
382: values(l_new_dup_batch_id, l_batch_name, l_match_rule_id, l_req_type,
383: HZ_UTILITY_V2PUB.CREATED_BY, HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
384: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE, HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
385: HZ_UTILITY_V2PUB.APPLICATION_ID);
386: END IF;
387: -- update winner party id if request_type = 'SYSTEM_GENERATED'

Line 384: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE, HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

380: created_by, creation_date, last_update_login, last_update_date,
381: last_updated_by, application_id)
382: values(l_new_dup_batch_id, l_batch_name, l_match_rule_id, l_req_type,
383: HZ_UTILITY_V2PUB.CREATED_BY, HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
384: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE, HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
385: HZ_UTILITY_V2PUB.APPLICATION_ID);
386: END IF;
387: -- update winner party id if request_type = 'SYSTEM_GENERATED'
388: IF (l_request_type = 'SYSTEM_GENERATED') THEN

Line 385: HZ_UTILITY_V2PUB.APPLICATION_ID);

381: last_updated_by, application_id)
382: values(l_new_dup_batch_id, l_batch_name, l_match_rule_id, l_req_type,
383: HZ_UTILITY_V2PUB.CREATED_BY, HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
384: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE, HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
385: HZ_UTILITY_V2PUB.APPLICATION_ID);
386: END IF;
387: -- update winner party id if request_type = 'SYSTEM_GENERATED'
388: IF (l_request_type = 'SYSTEM_GENERATED') THEN
389: