DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_37 dependencies on HZ_UTILITY_PUB

Line 3114: hz_utility_pub.created_by,hz_utility_pub.creation_date,

3110: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3111: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3112: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3113: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3114: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3115: hz_utility_pub.last_update_login,
3116: hz_utility_pub.last_update_date,
3117: hz_utility_pub.user_id,p_dup_batch_id);
3118: x_num_matches := x_num_matches+1;

Line 3115: hz_utility_pub.last_update_login,

3111: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3112: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3113: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3114: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3115: hz_utility_pub.last_update_login,
3116: hz_utility_pub.last_update_date,
3117: hz_utility_pub.user_id,p_dup_batch_id);
3118: x_num_matches := x_num_matches+1;
3119: END;

Line 3116: hz_utility_pub.last_update_date,

3112: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3113: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3114: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3115: hz_utility_pub.last_update_login,
3116: hz_utility_pub.last_update_date,
3117: hz_utility_pub.user_id,p_dup_batch_id);
3118: x_num_matches := x_num_matches+1;
3119: END;
3120: END IF;

Line 3117: hz_utility_pub.user_id,p_dup_batch_id);

3113: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3114: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3115: hz_utility_pub.last_update_login,
3116: hz_utility_pub.last_update_date,
3117: hz_utility_pub.user_id,p_dup_batch_id);
3118: x_num_matches := x_num_matches+1;
3119: END;
3120: END IF;
3121: END IF;

Line 3906: hz_utility_pub.created_by,hz_utility_pub.creation_date,

3902: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3903: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3904: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3905: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3906: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3907: hz_utility_pub.last_update_login,
3908: hz_utility_pub.last_update_date,
3909: hz_utility_pub.user_id,p_dup_batch_id);
3910: x_num_matches := x_num_matches+1;

Line 3907: hz_utility_pub.last_update_login,

3903: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3904: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3905: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3906: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3907: hz_utility_pub.last_update_login,
3908: hz_utility_pub.last_update_date,
3909: hz_utility_pub.user_id,p_dup_batch_id);
3910: x_num_matches := x_num_matches+1;
3911: END;

Line 3908: hz_utility_pub.last_update_date,

3904: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3905: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3906: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3907: hz_utility_pub.last_update_login,
3908: hz_utility_pub.last_update_date,
3909: hz_utility_pub.user_id,p_dup_batch_id);
3910: x_num_matches := x_num_matches+1;
3911: END;
3912: END IF;

Line 3909: hz_utility_pub.user_id,p_dup_batch_id);

3905: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3906: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3907: hz_utility_pub.last_update_login,
3908: hz_utility_pub.last_update_date,
3909: hz_utility_pub.user_id,p_dup_batch_id);
3910: x_num_matches := x_num_matches+1;
3911: END;
3912: END IF;
3913: END IF;

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

4090: INSERT INTO HZ_DUP_SETS ( DUP_SET_ID, DUP_BATCH_ID, WINNER_PARTY_ID,
4091: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
4092: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4093: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4094: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4095: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4096: hz_utility_pub.user_id);
4097:
4098: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,

Line 4095: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

4091: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
4092: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4093: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4094: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4095: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4096: hz_utility_pub.user_id);
4097:
4098: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4099: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,

Line 4096: hz_utility_pub.user_id);

4092: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4093: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4094: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4095: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4096: hz_utility_pub.user_id);
4097:
4098: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4099: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4100: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)

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

4098: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4099: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4100: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4101: VALUES (p_party_id,x_dup_set_id,0,0,
4102: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4103: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4104: hz_utility_pub.user_id,p_dup_batch_id);
4105: ELSE
4106: x_dup_set_id := NULL;

Line 4103: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

4099: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4100: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4101: VALUES (p_party_id,x_dup_set_id,0,0,
4102: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4103: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4104: hz_utility_pub.user_id,p_dup_batch_id);
4105: ELSE
4106: x_dup_set_id := NULL;
4107: END IF;

Line 4104: hz_utility_pub.user_id,p_dup_batch_id);

4100: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4101: VALUES (p_party_id,x_dup_set_id,0,0,
4102: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4103: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4104: hz_utility_pub.user_id,p_dup_batch_id);
4105: ELSE
4106: x_dup_set_id := NULL;
4107: END IF;
4108: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN