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

Line 3117: hz_utility_pub.created_by,hz_utility_pub.creation_date,

3113: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3114: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3115: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3116: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3117: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3118: hz_utility_pub.last_update_login,
3119: hz_utility_pub.last_update_date,
3120: hz_utility_pub.user_id,p_dup_batch_id);
3121: x_num_matches := x_num_matches+1;

Line 3118: hz_utility_pub.last_update_login,

3114: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3115: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3116: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3117: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3118: hz_utility_pub.last_update_login,
3119: hz_utility_pub.last_update_date,
3120: hz_utility_pub.user_id,p_dup_batch_id);
3121: x_num_matches := x_num_matches+1;
3122: END;

Line 3119: hz_utility_pub.last_update_date,

3115: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3116: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3117: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3118: hz_utility_pub.last_update_login,
3119: hz_utility_pub.last_update_date,
3120: hz_utility_pub.user_id,p_dup_batch_id);
3121: x_num_matches := x_num_matches+1;
3122: END;
3123: END IF;

Line 3120: hz_utility_pub.user_id,p_dup_batch_id);

3116: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3117: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3118: hz_utility_pub.last_update_login,
3119: hz_utility_pub.last_update_date,
3120: hz_utility_pub.user_id,p_dup_batch_id);
3121: x_num_matches := x_num_matches+1;
3122: END;
3123: END IF;
3124: END IF;

Line 3910: hz_utility_pub.created_by,hz_utility_pub.creation_date,

3906: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3907: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3908: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3909: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3910: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3911: hz_utility_pub.last_update_login,
3912: hz_utility_pub.last_update_date,
3913: hz_utility_pub.user_id,p_dup_batch_id);
3914: x_num_matches := x_num_matches+1;

Line 3911: hz_utility_pub.last_update_login,

3907: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3908: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3909: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3910: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3911: hz_utility_pub.last_update_login,
3912: hz_utility_pub.last_update_date,
3913: hz_utility_pub.user_id,p_dup_batch_id);
3914: x_num_matches := x_num_matches+1;
3915: END;

Line 3912: hz_utility_pub.last_update_date,

3908: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3909: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3910: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3911: hz_utility_pub.last_update_login,
3912: hz_utility_pub.last_update_date,
3913: hz_utility_pub.user_id,p_dup_batch_id);
3914: x_num_matches := x_num_matches+1;
3915: END;
3916: END IF;

Line 3913: hz_utility_pub.user_id,p_dup_batch_id);

3909: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3910: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3911: hz_utility_pub.last_update_login,
3912: hz_utility_pub.last_update_date,
3913: hz_utility_pub.user_id,p_dup_batch_id);
3914: x_num_matches := x_num_matches+1;
3915: END;
3916: END IF;
3917: END IF;

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

4094: INSERT INTO HZ_DUP_SETS ( DUP_SET_ID, DUP_BATCH_ID, WINNER_PARTY_ID,
4095: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
4096: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4097: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4098: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4099: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4100: hz_utility_pub.user_id);
4101:
4102: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,

Line 4099: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

4095: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
4096: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4097: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4098: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4099: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4100: hz_utility_pub.user_id);
4101:
4102: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4103: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,

Line 4100: hz_utility_pub.user_id);

4096: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4097: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4098: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4099: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4100: hz_utility_pub.user_id);
4101:
4102: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4103: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4104: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)

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

4102: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4103: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4104: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4105: VALUES (p_party_id,x_dup_set_id,0,0,
4106: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4107: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4108: hz_utility_pub.user_id,p_dup_batch_id);
4109: ELSE
4110: x_dup_set_id := NULL;

Line 4107: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

4103: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4104: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4105: VALUES (p_party_id,x_dup_set_id,0,0,
4106: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4107: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4108: hz_utility_pub.user_id,p_dup_batch_id);
4109: ELSE
4110: x_dup_set_id := NULL;
4111: END IF;

Line 4108: hz_utility_pub.user_id,p_dup_batch_id);

4104: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4105: VALUES (p_party_id,x_dup_set_id,0,0,
4106: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4107: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4108: hz_utility_pub.user_id,p_dup_batch_id);
4109: ELSE
4110: x_dup_set_id := NULL;
4111: END IF;
4112: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN