DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_5 dependencies on HZ_UTILITY_PUB

Line 2777: hz_utility_pub.created_by,hz_utility_pub.creation_date,

2773: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
2774: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
2775: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
2776: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
2777: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2778: hz_utility_pub.last_update_login,
2779: hz_utility_pub.last_update_date,
2780: hz_utility_pub.user_id,p_dup_batch_id);
2781: x_num_matches := x_num_matches+1;

Line 2778: hz_utility_pub.last_update_login,

2774: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
2775: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
2776: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
2777: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2778: hz_utility_pub.last_update_login,
2779: hz_utility_pub.last_update_date,
2780: hz_utility_pub.user_id,p_dup_batch_id);
2781: x_num_matches := x_num_matches+1;
2782: END;

Line 2779: hz_utility_pub.last_update_date,

2775: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
2776: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
2777: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2778: hz_utility_pub.last_update_login,
2779: hz_utility_pub.last_update_date,
2780: hz_utility_pub.user_id,p_dup_batch_id);
2781: x_num_matches := x_num_matches+1;
2782: END;
2783: END IF;

Line 2780: hz_utility_pub.user_id,p_dup_batch_id);

2776: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
2777: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2778: hz_utility_pub.last_update_login,
2779: hz_utility_pub.last_update_date,
2780: hz_utility_pub.user_id,p_dup_batch_id);
2781: x_num_matches := x_num_matches+1;
2782: END;
2783: END IF;
2784: END IF;

Line 3561: hz_utility_pub.created_by,hz_utility_pub.creation_date,

3557: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3558: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3559: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3560: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3561: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3562: hz_utility_pub.last_update_login,
3563: hz_utility_pub.last_update_date,
3564: hz_utility_pub.user_id,p_dup_batch_id);
3565: x_num_matches := x_num_matches+1;

Line 3562: hz_utility_pub.last_update_login,

3558: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3559: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3560: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3561: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3562: hz_utility_pub.last_update_login,
3563: hz_utility_pub.last_update_date,
3564: hz_utility_pub.user_id,p_dup_batch_id);
3565: x_num_matches := x_num_matches+1;
3566: END;

Line 3563: hz_utility_pub.last_update_date,

3559: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3560: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3561: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3562: hz_utility_pub.last_update_login,
3563: hz_utility_pub.last_update_date,
3564: hz_utility_pub.user_id,p_dup_batch_id);
3565: x_num_matches := x_num_matches+1;
3566: END;
3567: END IF;

Line 3564: hz_utility_pub.user_id,p_dup_batch_id);

3560: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3561: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3562: hz_utility_pub.last_update_login,
3563: hz_utility_pub.last_update_date,
3564: hz_utility_pub.user_id,p_dup_batch_id);
3565: x_num_matches := x_num_matches+1;
3566: END;
3567: END IF;
3568: END IF;

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

3745: INSERT INTO HZ_DUP_SETS ( DUP_SET_ID, DUP_BATCH_ID, WINNER_PARTY_ID,
3746: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
3747: LAST_UPDATE_DATE, LAST_UPDATED_BY)
3748: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
3749: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
3750: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
3751: hz_utility_pub.user_id);
3752:
3753: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,

Line 3750: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

3746: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
3747: LAST_UPDATE_DATE, LAST_UPDATED_BY)
3748: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
3749: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
3750: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
3751: hz_utility_pub.user_id);
3752:
3753: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
3754: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,

Line 3751: hz_utility_pub.user_id);

3747: LAST_UPDATE_DATE, LAST_UPDATED_BY)
3748: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
3749: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
3750: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
3751: hz_utility_pub.user_id);
3752:
3753: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
3754: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3755: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)

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

3753: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
3754: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3755: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3756: VALUES (p_party_id,x_dup_set_id,0,0,
3757: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
3758: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
3759: hz_utility_pub.user_id,p_dup_batch_id);
3760: ELSE
3761: x_dup_set_id := NULL;

Line 3758: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

3754: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3755: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3756: VALUES (p_party_id,x_dup_set_id,0,0,
3757: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
3758: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
3759: hz_utility_pub.user_id,p_dup_batch_id);
3760: ELSE
3761: x_dup_set_id := NULL;
3762: END IF;

Line 3759: hz_utility_pub.user_id,p_dup_batch_id);

3755: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3756: VALUES (p_party_id,x_dup_set_id,0,0,
3757: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
3758: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
3759: hz_utility_pub.user_id,p_dup_batch_id);
3760: ELSE
3761: x_dup_set_id := NULL;
3762: END IF;
3763: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN