DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_40 dependencies on HZ_UTILITY_PUB

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

4239: INSERT INTO HZ_DUP_SETS ( DUP_SET_ID, DUP_BATCH_ID, WINNER_PARTY_ID,
4240: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
4241: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4242: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4243: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4244: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4245: hz_utility_pub.user_id);
4246:
4247: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,

Line 4244: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

4240: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
4241: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4242: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4243: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4244: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4245: hz_utility_pub.user_id);
4246:
4247: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4248: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,

Line 4245: hz_utility_pub.user_id);

4241: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4242: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4243: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4244: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4245: hz_utility_pub.user_id);
4246:
4247: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4248: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4249: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)

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

4247: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4248: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4249: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4250: VALUES (p_party_id,x_dup_set_id,0,0,
4251: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4252: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4253: hz_utility_pub.user_id,p_dup_batch_id);
4254: ELSE
4255: x_dup_set_id := NULL;

Line 4252: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

4248: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4249: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4250: VALUES (p_party_id,x_dup_set_id,0,0,
4251: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4252: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4253: hz_utility_pub.user_id,p_dup_batch_id);
4254: ELSE
4255: x_dup_set_id := NULL;
4256: END IF;

Line 4253: hz_utility_pub.user_id,p_dup_batch_id);

4249: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4250: VALUES (p_party_id,x_dup_set_id,0,0,
4251: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4252: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4253: hz_utility_pub.user_id,p_dup_batch_id);
4254: ELSE
4255: x_dup_set_id := NULL;
4256: END IF;
4257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN