DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_7 dependencies on HZ_UTILITY_PUB

Line 3040: hz_utility_pub.created_by,hz_utility_pub.creation_date,

3036: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3037: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3038: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3039: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3040: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3041: hz_utility_pub.last_update_login,
3042: hz_utility_pub.last_update_date,
3043: hz_utility_pub.user_id,p_dup_batch_id);
3044: x_num_matches := x_num_matches+1;

Line 3041: hz_utility_pub.last_update_login,

3037: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3038: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3039: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3040: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3041: hz_utility_pub.last_update_login,
3042: hz_utility_pub.last_update_date,
3043: hz_utility_pub.user_id,p_dup_batch_id);
3044: x_num_matches := x_num_matches+1;
3045: END;

Line 3042: hz_utility_pub.last_update_date,

3038: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3039: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3040: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3041: hz_utility_pub.last_update_login,
3042: hz_utility_pub.last_update_date,
3043: hz_utility_pub.user_id,p_dup_batch_id);
3044: x_num_matches := x_num_matches+1;
3045: END;
3046: END IF;

Line 3043: hz_utility_pub.user_id,p_dup_batch_id);

3039: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3040: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3041: hz_utility_pub.last_update_login,
3042: hz_utility_pub.last_update_date,
3043: hz_utility_pub.user_id,p_dup_batch_id);
3044: x_num_matches := x_num_matches+1;
3045: END;
3046: END IF;
3047: END IF;

Line 3830: hz_utility_pub.created_by,hz_utility_pub.creation_date,

3826: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3827: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3828: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3829: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3830: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3831: hz_utility_pub.last_update_login,
3832: hz_utility_pub.last_update_date,
3833: hz_utility_pub.user_id,p_dup_batch_id);
3834: x_num_matches := x_num_matches+1;

Line 3831: hz_utility_pub.last_update_login,

3827: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3828: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3829: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3830: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3831: hz_utility_pub.last_update_login,
3832: hz_utility_pub.last_update_date,
3833: hz_utility_pub.user_id,p_dup_batch_id);
3834: x_num_matches := x_num_matches+1;
3835: END;

Line 3832: hz_utility_pub.last_update_date,

3828: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3829: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3830: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3831: hz_utility_pub.last_update_login,
3832: hz_utility_pub.last_update_date,
3833: hz_utility_pub.user_id,p_dup_batch_id);
3834: x_num_matches := x_num_matches+1;
3835: END;
3836: END IF;

Line 3833: hz_utility_pub.user_id,p_dup_batch_id);

3829: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3830: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3831: hz_utility_pub.last_update_login,
3832: hz_utility_pub.last_update_date,
3833: hz_utility_pub.user_id,p_dup_batch_id);
3834: x_num_matches := x_num_matches+1;
3835: END;
3836: END IF;
3837: END IF;

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

4014: INSERT INTO HZ_DUP_SETS ( DUP_SET_ID, DUP_BATCH_ID, WINNER_PARTY_ID,
4015: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
4016: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4017: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4018: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4019: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4020: hz_utility_pub.user_id);
4021:
4022: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,

Line 4019: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

4015: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
4016: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4017: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4018: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4019: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4020: hz_utility_pub.user_id);
4021:
4022: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4023: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,

Line 4020: hz_utility_pub.user_id);

4016: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4017: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4018: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4019: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4020: hz_utility_pub.user_id);
4021:
4022: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4023: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4024: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)

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

4022: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4023: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4024: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4025: VALUES (p_party_id,x_dup_set_id,0,0,
4026: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4027: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4028: hz_utility_pub.user_id,p_dup_batch_id);
4029: ELSE
4030: x_dup_set_id := NULL;

Line 4027: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

4023: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4024: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4025: VALUES (p_party_id,x_dup_set_id,0,0,
4026: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4027: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4028: hz_utility_pub.user_id,p_dup_batch_id);
4029: ELSE
4030: x_dup_set_id := NULL;
4031: END IF;

Line 4028: hz_utility_pub.user_id,p_dup_batch_id);

4024: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4025: VALUES (p_party_id,x_dup_set_id,0,0,
4026: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4027: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4028: hz_utility_pub.user_id,p_dup_batch_id);
4029: ELSE
4030: x_dup_set_id := NULL;
4031: END IF;
4032: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN