DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_6 dependencies on HZ_UTILITY_PUB

Line 3218: hz_utility_pub.created_by,hz_utility_pub.creation_date,

3214: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3215: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3216: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3217: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3218: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3219: hz_utility_pub.last_update_login,
3220: hz_utility_pub.last_update_date,
3221: hz_utility_pub.user_id,p_dup_batch_id);
3222: x_num_matches := x_num_matches+1;

Line 3219: hz_utility_pub.last_update_login,

3215: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3216: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3217: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3218: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3219: hz_utility_pub.last_update_login,
3220: hz_utility_pub.last_update_date,
3221: hz_utility_pub.user_id,p_dup_batch_id);
3222: x_num_matches := x_num_matches+1;
3223: END;

Line 3220: hz_utility_pub.last_update_date,

3216: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3217: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3218: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3219: hz_utility_pub.last_update_login,
3220: hz_utility_pub.last_update_date,
3221: hz_utility_pub.user_id,p_dup_batch_id);
3222: x_num_matches := x_num_matches+1;
3223: END;
3224: END IF;

Line 3221: hz_utility_pub.user_id,p_dup_batch_id);

3217: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3218: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3219: hz_utility_pub.last_update_login,
3220: hz_utility_pub.last_update_date,
3221: hz_utility_pub.user_id,p_dup_batch_id);
3222: x_num_matches := x_num_matches+1;
3223: END;
3224: END IF;
3225: END IF;

Line 4010: hz_utility_pub.created_by,hz_utility_pub.creation_date,

4006: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4007: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4008: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
4009: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
4010: hz_utility_pub.created_by,hz_utility_pub.creation_date,
4011: hz_utility_pub.last_update_login,
4012: hz_utility_pub.last_update_date,
4013: hz_utility_pub.user_id,p_dup_batch_id);
4014: x_num_matches := x_num_matches+1;

Line 4011: hz_utility_pub.last_update_login,

4007: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4008: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
4009: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
4010: hz_utility_pub.created_by,hz_utility_pub.creation_date,
4011: hz_utility_pub.last_update_login,
4012: hz_utility_pub.last_update_date,
4013: hz_utility_pub.user_id,p_dup_batch_id);
4014: x_num_matches := x_num_matches+1;
4015: END;

Line 4012: hz_utility_pub.last_update_date,

4008: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
4009: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
4010: hz_utility_pub.created_by,hz_utility_pub.creation_date,
4011: hz_utility_pub.last_update_login,
4012: hz_utility_pub.last_update_date,
4013: hz_utility_pub.user_id,p_dup_batch_id);
4014: x_num_matches := x_num_matches+1;
4015: END;
4016: END IF;

Line 4013: hz_utility_pub.user_id,p_dup_batch_id);

4009: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
4010: hz_utility_pub.created_by,hz_utility_pub.creation_date,
4011: hz_utility_pub.last_update_login,
4012: hz_utility_pub.last_update_date,
4013: hz_utility_pub.user_id,p_dup_batch_id);
4014: x_num_matches := x_num_matches+1;
4015: END;
4016: END IF;
4017: END IF;

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

4194: INSERT INTO HZ_DUP_SETS ( DUP_SET_ID, DUP_BATCH_ID, WINNER_PARTY_ID,
4195: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
4196: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4197: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4198: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4199: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4200: hz_utility_pub.user_id);
4201:
4202: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,

Line 4199: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

4195: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
4196: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4197: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4198: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4199: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4200: hz_utility_pub.user_id);
4201:
4202: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4203: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,

Line 4200: hz_utility_pub.user_id);

4196: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4197: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4198: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4199: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4200: hz_utility_pub.user_id);
4201:
4202: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4203: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4204: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)

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

4202: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4203: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4204: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4205: VALUES (p_party_id,x_dup_set_id,0,0,
4206: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4207: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4208: hz_utility_pub.user_id,p_dup_batch_id);
4209: ELSE
4210: x_dup_set_id := NULL;

Line 4207: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

4203: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4204: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4205: VALUES (p_party_id,x_dup_set_id,0,0,
4206: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4207: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4208: hz_utility_pub.user_id,p_dup_batch_id);
4209: ELSE
4210: x_dup_set_id := NULL;
4211: END IF;

Line 4208: hz_utility_pub.user_id,p_dup_batch_id);

4204: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4205: VALUES (p_party_id,x_dup_set_id,0,0,
4206: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4207: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4208: hz_utility_pub.user_id,p_dup_batch_id);
4209: ELSE
4210: x_dup_set_id := NULL;
4211: END IF;
4212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN