DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_48 dependencies on HZ_UTILITY_PUB

Line 3185: hz_utility_pub.created_by,hz_utility_pub.creation_date,

3181: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3182: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3183: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3184: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3185: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3186: hz_utility_pub.last_update_login,
3187: hz_utility_pub.last_update_date,
3188: hz_utility_pub.user_id,p_dup_batch_id);
3189: x_num_matches := x_num_matches+1;

Line 3186: hz_utility_pub.last_update_login,

3182: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3183: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3184: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3185: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3186: hz_utility_pub.last_update_login,
3187: hz_utility_pub.last_update_date,
3188: hz_utility_pub.user_id,p_dup_batch_id);
3189: x_num_matches := x_num_matches+1;
3190: END;

Line 3187: hz_utility_pub.last_update_date,

3183: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3184: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3185: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3186: hz_utility_pub.last_update_login,
3187: hz_utility_pub.last_update_date,
3188: hz_utility_pub.user_id,p_dup_batch_id);
3189: x_num_matches := x_num_matches+1;
3190: END;
3191: END IF;

Line 3188: hz_utility_pub.user_id,p_dup_batch_id);

3184: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3185: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3186: hz_utility_pub.last_update_login,
3187: hz_utility_pub.last_update_date,
3188: hz_utility_pub.user_id,p_dup_batch_id);
3189: x_num_matches := x_num_matches+1;
3190: END;
3191: END IF;
3192: END IF;

Line 3974: hz_utility_pub.created_by,hz_utility_pub.creation_date,

3970: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3971: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3972: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3973: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3974: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3975: hz_utility_pub.last_update_login,
3976: hz_utility_pub.last_update_date,
3977: hz_utility_pub.user_id,p_dup_batch_id);
3978: x_num_matches := x_num_matches+1;

Line 3975: hz_utility_pub.last_update_login,

3971: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3972: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3973: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3974: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3975: hz_utility_pub.last_update_login,
3976: hz_utility_pub.last_update_date,
3977: hz_utility_pub.user_id,p_dup_batch_id);
3978: x_num_matches := x_num_matches+1;
3979: END;

Line 3976: hz_utility_pub.last_update_date,

3972: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3973: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3974: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3975: hz_utility_pub.last_update_login,
3976: hz_utility_pub.last_update_date,
3977: hz_utility_pub.user_id,p_dup_batch_id);
3978: x_num_matches := x_num_matches+1;
3979: END;
3980: END IF;

Line 3977: hz_utility_pub.user_id,p_dup_batch_id);

3973: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3974: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3975: hz_utility_pub.last_update_login,
3976: hz_utility_pub.last_update_date,
3977: hz_utility_pub.user_id,p_dup_batch_id);
3978: x_num_matches := x_num_matches+1;
3979: END;
3980: END IF;
3981: END IF;

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

4158: INSERT INTO HZ_DUP_SETS ( DUP_SET_ID, DUP_BATCH_ID, WINNER_PARTY_ID,
4159: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
4160: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4161: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4162: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4163: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4164: hz_utility_pub.user_id);
4165:
4166: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,

Line 4163: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

4159: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
4160: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4161: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4162: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4163: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4164: hz_utility_pub.user_id);
4165:
4166: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4167: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,

Line 4164: hz_utility_pub.user_id);

4160: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4161: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4162: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4163: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4164: hz_utility_pub.user_id);
4165:
4166: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4167: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4168: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)

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

4166: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4167: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4168: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4169: VALUES (p_party_id,x_dup_set_id,0,0,
4170: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4171: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4172: hz_utility_pub.user_id,p_dup_batch_id);
4173: ELSE
4174: x_dup_set_id := NULL;

Line 4171: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

4167: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4168: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4169: VALUES (p_party_id,x_dup_set_id,0,0,
4170: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4171: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4172: hz_utility_pub.user_id,p_dup_batch_id);
4173: ELSE
4174: x_dup_set_id := NULL;
4175: END IF;

Line 4172: hz_utility_pub.user_id,p_dup_batch_id);

4168: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4169: VALUES (p_party_id,x_dup_set_id,0,0,
4170: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4171: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4172: hz_utility_pub.user_id,p_dup_batch_id);
4173: ELSE
4174: x_dup_set_id := NULL;
4175: END IF;
4176: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN