DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_4 dependencies on HZ_UTILITY_PUB

Line 2890: hz_utility_pub.created_by,hz_utility_pub.creation_date,

2886: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
2887: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
2888: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
2889: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
2890: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2891: hz_utility_pub.last_update_login,
2892: hz_utility_pub.last_update_date,
2893: hz_utility_pub.user_id,p_dup_batch_id);
2894: x_num_matches := x_num_matches+1;

Line 2891: hz_utility_pub.last_update_login,

2887: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
2888: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
2889: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
2890: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2891: hz_utility_pub.last_update_login,
2892: hz_utility_pub.last_update_date,
2893: hz_utility_pub.user_id,p_dup_batch_id);
2894: x_num_matches := x_num_matches+1;
2895: END;

Line 2892: hz_utility_pub.last_update_date,

2888: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
2889: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
2890: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2891: hz_utility_pub.last_update_login,
2892: hz_utility_pub.last_update_date,
2893: hz_utility_pub.user_id,p_dup_batch_id);
2894: x_num_matches := x_num_matches+1;
2895: END;
2896: END IF;

Line 2893: hz_utility_pub.user_id,p_dup_batch_id);

2889: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
2890: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2891: hz_utility_pub.last_update_login,
2892: hz_utility_pub.last_update_date,
2893: hz_utility_pub.user_id,p_dup_batch_id);
2894: x_num_matches := x_num_matches+1;
2895: END;
2896: END IF;
2897: END IF;

Line 3676: hz_utility_pub.created_by,hz_utility_pub.creation_date,

3672: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3673: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3674: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3675: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3676: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3677: hz_utility_pub.last_update_login,
3678: hz_utility_pub.last_update_date,
3679: hz_utility_pub.user_id,p_dup_batch_id);
3680: x_num_matches := x_num_matches+1;

Line 3677: hz_utility_pub.last_update_login,

3673: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3674: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3675: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3676: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3677: hz_utility_pub.last_update_login,
3678: hz_utility_pub.last_update_date,
3679: hz_utility_pub.user_id,p_dup_batch_id);
3680: x_num_matches := x_num_matches+1;
3681: END;

Line 3678: hz_utility_pub.last_update_date,

3674: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3675: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3676: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3677: hz_utility_pub.last_update_login,
3678: hz_utility_pub.last_update_date,
3679: hz_utility_pub.user_id,p_dup_batch_id);
3680: x_num_matches := x_num_matches+1;
3681: END;
3682: END IF;

Line 3679: hz_utility_pub.user_id,p_dup_batch_id);

3675: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3676: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3677: hz_utility_pub.last_update_login,
3678: hz_utility_pub.last_update_date,
3679: hz_utility_pub.user_id,p_dup_batch_id);
3680: x_num_matches := x_num_matches+1;
3681: END;
3682: END IF;
3683: END IF;

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

3860: INSERT INTO HZ_DUP_SETS ( DUP_SET_ID, DUP_BATCH_ID, WINNER_PARTY_ID,
3861: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
3862: LAST_UPDATE_DATE, LAST_UPDATED_BY)
3863: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
3864: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
3865: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
3866: hz_utility_pub.user_id);
3867:
3868: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,

Line 3865: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

3861: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
3862: LAST_UPDATE_DATE, LAST_UPDATED_BY)
3863: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
3864: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
3865: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
3866: hz_utility_pub.user_id);
3867:
3868: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
3869: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,

Line 3866: hz_utility_pub.user_id);

3862: LAST_UPDATE_DATE, LAST_UPDATED_BY)
3863: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
3864: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
3865: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
3866: hz_utility_pub.user_id);
3867:
3868: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
3869: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3870: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)

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

3868: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
3869: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3870: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3871: VALUES (p_party_id,x_dup_set_id,0,0,
3872: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
3873: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
3874: hz_utility_pub.user_id,p_dup_batch_id);
3875: ELSE
3876: x_dup_set_id := NULL;

Line 3873: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

3869: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3870: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3871: VALUES (p_party_id,x_dup_set_id,0,0,
3872: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
3873: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
3874: hz_utility_pub.user_id,p_dup_batch_id);
3875: ELSE
3876: x_dup_set_id := NULL;
3877: END IF;

Line 3874: hz_utility_pub.user_id,p_dup_batch_id);

3870: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3871: VALUES (p_party_id,x_dup_set_id,0,0,
3872: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
3873: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
3874: hz_utility_pub.user_id,p_dup_batch_id);
3875: ELSE
3876: x_dup_set_id := NULL;
3877: END IF;
3878: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN