DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_7 dependencies on HZ_UTILITY_PUB

Line 3037: hz_utility_pub.created_by,hz_utility_pub.creation_date,

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

Line 3038: hz_utility_pub.last_update_login,

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

Line 3039: hz_utility_pub.last_update_date,

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

Line 3040: hz_utility_pub.user_id,p_dup_batch_id);

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

Line 3826: hz_utility_pub.created_by,hz_utility_pub.creation_date,

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

Line 3827: hz_utility_pub.last_update_login,

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

Line 3828: hz_utility_pub.last_update_date,

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

Line 3829: hz_utility_pub.user_id,p_dup_batch_id);

3825: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3826: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3827: hz_utility_pub.last_update_login,
3828: hz_utility_pub.last_update_date,
3829: hz_utility_pub.user_id,p_dup_batch_id);
3830: x_num_matches := x_num_matches+1;
3831: END;
3832: END IF;
3833: END IF;

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

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

Line 4015: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

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

Line 4016: hz_utility_pub.user_id);

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

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

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

Line 4023: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

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

Line 4024: hz_utility_pub.user_id,p_dup_batch_id);

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