DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_3 dependencies on HZ_UTILITY_PUB

Line 2799: hz_utility_pub.created_by,hz_utility_pub.creation_date,

2795: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
2796: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
2797: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
2798: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
2799: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2800: hz_utility_pub.last_update_login,
2801: hz_utility_pub.last_update_date,
2802: hz_utility_pub.user_id,p_dup_batch_id);
2803: x_num_matches := x_num_matches+1;

Line 2800: hz_utility_pub.last_update_login,

2796: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
2797: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
2798: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
2799: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2800: hz_utility_pub.last_update_login,
2801: hz_utility_pub.last_update_date,
2802: hz_utility_pub.user_id,p_dup_batch_id);
2803: x_num_matches := x_num_matches+1;
2804: END;

Line 2801: hz_utility_pub.last_update_date,

2797: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
2798: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
2799: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2800: hz_utility_pub.last_update_login,
2801: hz_utility_pub.last_update_date,
2802: hz_utility_pub.user_id,p_dup_batch_id);
2803: x_num_matches := x_num_matches+1;
2804: END;
2805: END IF;

Line 2802: hz_utility_pub.user_id,p_dup_batch_id);

2798: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
2799: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2800: hz_utility_pub.last_update_login,
2801: hz_utility_pub.last_update_date,
2802: hz_utility_pub.user_id,p_dup_batch_id);
2803: x_num_matches := x_num_matches+1;
2804: END;
2805: END IF;
2806: END IF;

Line 3583: hz_utility_pub.created_by,hz_utility_pub.creation_date,

3579: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3580: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3581: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3582: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3583: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3584: hz_utility_pub.last_update_login,
3585: hz_utility_pub.last_update_date,
3586: hz_utility_pub.user_id,p_dup_batch_id);
3587: x_num_matches := x_num_matches+1;

Line 3584: hz_utility_pub.last_update_login,

3580: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3581: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3582: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3583: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3584: hz_utility_pub.last_update_login,
3585: hz_utility_pub.last_update_date,
3586: hz_utility_pub.user_id,p_dup_batch_id);
3587: x_num_matches := x_num_matches+1;
3588: END;

Line 3585: hz_utility_pub.last_update_date,

3581: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3582: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3583: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3584: hz_utility_pub.last_update_login,
3585: hz_utility_pub.last_update_date,
3586: hz_utility_pub.user_id,p_dup_batch_id);
3587: x_num_matches := x_num_matches+1;
3588: END;
3589: END IF;

Line 3586: hz_utility_pub.user_id,p_dup_batch_id);

3582: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3583: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3584: hz_utility_pub.last_update_login,
3585: hz_utility_pub.last_update_date,
3586: hz_utility_pub.user_id,p_dup_batch_id);
3587: x_num_matches := x_num_matches+1;
3588: END;
3589: END IF;
3590: END IF;

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

3767: INSERT INTO HZ_DUP_SETS ( DUP_SET_ID, DUP_BATCH_ID, WINNER_PARTY_ID,
3768: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
3769: LAST_UPDATE_DATE, LAST_UPDATED_BY)
3770: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
3771: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
3772: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
3773: hz_utility_pub.user_id);
3774:
3775: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,

Line 3772: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

3768: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
3769: LAST_UPDATE_DATE, LAST_UPDATED_BY)
3770: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
3771: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
3772: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
3773: hz_utility_pub.user_id);
3774:
3775: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
3776: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,

Line 3773: hz_utility_pub.user_id);

3769: LAST_UPDATE_DATE, LAST_UPDATED_BY)
3770: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
3771: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
3772: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
3773: hz_utility_pub.user_id);
3774:
3775: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
3776: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3777: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)

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

3775: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
3776: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3777: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3778: VALUES (p_party_id,x_dup_set_id,0,0,
3779: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
3780: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
3781: hz_utility_pub.user_id,p_dup_batch_id);
3782: ELSE
3783: x_dup_set_id := NULL;

Line 3780: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

3776: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3777: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3778: VALUES (p_party_id,x_dup_set_id,0,0,
3779: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
3780: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
3781: hz_utility_pub.user_id,p_dup_batch_id);
3782: ELSE
3783: x_dup_set_id := NULL;
3784: END IF;

Line 3781: hz_utility_pub.user_id,p_dup_batch_id);

3777: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3778: VALUES (p_party_id,x_dup_set_id,0,0,
3779: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
3780: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
3781: hz_utility_pub.user_id,p_dup_batch_id);
3782: ELSE
3783: x_dup_set_id := NULL;
3784: END IF;
3785: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN