DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_38 dependencies on HZ_UTILITY_PUB

Line 3343: hz_utility_pub.created_by,hz_utility_pub.creation_date,

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

Line 3344: hz_utility_pub.last_update_login,

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

Line 3345: hz_utility_pub.last_update_date,

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

Line 3346: hz_utility_pub.user_id,p_dup_batch_id);

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

Line 4140: hz_utility_pub.created_by,hz_utility_pub.creation_date,

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

Line 4141: hz_utility_pub.last_update_login,

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

Line 4142: hz_utility_pub.last_update_date,

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

Line 4143: hz_utility_pub.user_id,p_dup_batch_id);

4139: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
4140: hz_utility_pub.created_by,hz_utility_pub.creation_date,
4141: hz_utility_pub.last_update_login,
4142: hz_utility_pub.last_update_date,
4143: hz_utility_pub.user_id,p_dup_batch_id);
4144: x_num_matches := x_num_matches+1;
4145: END;
4146: END IF;
4147: END IF;

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

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

Line 4329: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

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

Line 4330: hz_utility_pub.user_id);

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

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

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

Line 4337: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

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

Line 4338: hz_utility_pub.user_id,p_dup_batch_id);

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