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_MATCH_RULE_38 dependencies on HZ_UTILITY_PUB

Line 3346: hz_utility_pub.created_by,hz_utility_pub.creation_date,

3342: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3343: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3344: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3345: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3346: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3347: hz_utility_pub.last_update_login,
3348: hz_utility_pub.last_update_date,
3349: hz_utility_pub.user_id,p_dup_batch_id);
3350: x_num_matches := x_num_matches+1;

Line 3347: hz_utility_pub.last_update_login,

3343: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3344: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3345: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3346: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3347: hz_utility_pub.last_update_login,
3348: hz_utility_pub.last_update_date,
3349: hz_utility_pub.user_id,p_dup_batch_id);
3350: x_num_matches := x_num_matches+1;
3351: END;

Line 3348: hz_utility_pub.last_update_date,

3344: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3345: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3346: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3347: hz_utility_pub.last_update_login,
3348: hz_utility_pub.last_update_date,
3349: hz_utility_pub.user_id,p_dup_batch_id);
3350: x_num_matches := x_num_matches+1;
3351: END;
3352: END IF;

Line 3349: hz_utility_pub.user_id,p_dup_batch_id);

3345: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3346: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3347: hz_utility_pub.last_update_login,
3348: hz_utility_pub.last_update_date,
3349: hz_utility_pub.user_id,p_dup_batch_id);
3350: x_num_matches := x_num_matches+1;
3351: END;
3352: END IF;
3353: END IF;

Line 4144: hz_utility_pub.created_by,hz_utility_pub.creation_date,

4140: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4141: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4142: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
4143: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
4144: hz_utility_pub.created_by,hz_utility_pub.creation_date,
4145: hz_utility_pub.last_update_login,
4146: hz_utility_pub.last_update_date,
4147: hz_utility_pub.user_id,p_dup_batch_id);
4148: x_num_matches := x_num_matches+1;

Line 4145: hz_utility_pub.last_update_login,

4141: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4142: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
4143: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
4144: hz_utility_pub.created_by,hz_utility_pub.creation_date,
4145: hz_utility_pub.last_update_login,
4146: hz_utility_pub.last_update_date,
4147: hz_utility_pub.user_id,p_dup_batch_id);
4148: x_num_matches := x_num_matches+1;
4149: END;

Line 4146: hz_utility_pub.last_update_date,

4142: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
4143: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
4144: hz_utility_pub.created_by,hz_utility_pub.creation_date,
4145: hz_utility_pub.last_update_login,
4146: hz_utility_pub.last_update_date,
4147: hz_utility_pub.user_id,p_dup_batch_id);
4148: x_num_matches := x_num_matches+1;
4149: END;
4150: END IF;

Line 4147: hz_utility_pub.user_id,p_dup_batch_id);

4143: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
4144: hz_utility_pub.created_by,hz_utility_pub.creation_date,
4145: hz_utility_pub.last_update_login,
4146: hz_utility_pub.last_update_date,
4147: hz_utility_pub.user_id,p_dup_batch_id);
4148: x_num_matches := x_num_matches+1;
4149: END;
4150: END IF;
4151: END IF;

Line 4332: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,

4328: INSERT INTO HZ_DUP_SETS ( DUP_SET_ID, DUP_BATCH_ID, WINNER_PARTY_ID,
4329: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
4330: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4331: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4332: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4333: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4334: hz_utility_pub.user_id);
4335:
4336: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,

Line 4333: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

4329: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
4330: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4331: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4332: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4333: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4334: hz_utility_pub.user_id);
4335:
4336: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4337: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,

Line 4334: hz_utility_pub.user_id);

4330: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4331: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4332: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4333: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4334: hz_utility_pub.user_id);
4335:
4336: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4337: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4338: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)

Line 4340: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,

4336: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4337: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4338: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4339: VALUES (p_party_id,x_dup_set_id,0,0,
4340: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4341: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4342: hz_utility_pub.user_id,p_dup_batch_id);
4343: ELSE
4344: x_dup_set_id := NULL;

Line 4341: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

4337: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4338: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4339: VALUES (p_party_id,x_dup_set_id,0,0,
4340: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4341: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4342: hz_utility_pub.user_id,p_dup_batch_id);
4343: ELSE
4344: x_dup_set_id := NULL;
4345: END IF;

Line 4342: hz_utility_pub.user_id,p_dup_batch_id);

4338: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4339: VALUES (p_party_id,x_dup_set_id,0,0,
4340: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4341: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4342: hz_utility_pub.user_id,p_dup_batch_id);
4343: ELSE
4344: x_dup_set_id := NULL;
4345: END IF;
4346: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN