DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_4 dependencies on HZ_UTILITY_PUB

Line 2893: hz_utility_pub.created_by,hz_utility_pub.creation_date,

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

Line 2894: hz_utility_pub.last_update_login,

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

Line 2895: hz_utility_pub.last_update_date,

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

Line 2896: hz_utility_pub.user_id,p_dup_batch_id);

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

Line 3680: hz_utility_pub.created_by,hz_utility_pub.creation_date,

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

Line 3681: hz_utility_pub.last_update_login,

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

Line 3682: hz_utility_pub.last_update_date,

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

Line 3683: hz_utility_pub.user_id,p_dup_batch_id);

3679: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3680: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3681: hz_utility_pub.last_update_login,
3682: hz_utility_pub.last_update_date,
3683: hz_utility_pub.user_id,p_dup_batch_id);
3684: x_num_matches := x_num_matches+1;
3685: END;
3686: END IF;
3687: END IF;

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

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

Line 3869: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

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

Line 3870: hz_utility_pub.user_id);

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

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

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

Line 3877: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

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

Line 3878: hz_utility_pub.user_id,p_dup_batch_id);

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