DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_51 dependencies on HZ_UTILITY_PUB

Line 1884: hz_utility_pub.created_by,hz_utility_pub.creation_date,

1880: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
1881: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
1882: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
1883: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
1884: hz_utility_pub.created_by,hz_utility_pub.creation_date,
1885: hz_utility_pub.last_update_login,
1886: hz_utility_pub.last_update_date,
1887: hz_utility_pub.user_id,p_dup_batch_id);
1888: x_num_matches := x_num_matches+1;

Line 1885: hz_utility_pub.last_update_login,

1881: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
1882: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
1883: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
1884: hz_utility_pub.created_by,hz_utility_pub.creation_date,
1885: hz_utility_pub.last_update_login,
1886: hz_utility_pub.last_update_date,
1887: hz_utility_pub.user_id,p_dup_batch_id);
1888: x_num_matches := x_num_matches+1;
1889: END;

Line 1886: hz_utility_pub.last_update_date,

1882: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
1883: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
1884: hz_utility_pub.created_by,hz_utility_pub.creation_date,
1885: hz_utility_pub.last_update_login,
1886: hz_utility_pub.last_update_date,
1887: hz_utility_pub.user_id,p_dup_batch_id);
1888: x_num_matches := x_num_matches+1;
1889: END;
1890: END IF;

Line 1887: hz_utility_pub.user_id,p_dup_batch_id);

1883: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
1884: hz_utility_pub.created_by,hz_utility_pub.creation_date,
1885: hz_utility_pub.last_update_login,
1886: hz_utility_pub.last_update_date,
1887: hz_utility_pub.user_id,p_dup_batch_id);
1888: x_num_matches := x_num_matches+1;
1889: END;
1890: END IF;
1891: END IF;

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

2714: INSERT INTO HZ_DUP_SETS ( DUP_SET_ID, DUP_BATCH_ID, WINNER_PARTY_ID,
2715: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
2716: LAST_UPDATE_DATE, LAST_UPDATED_BY)
2717: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
2718: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
2719: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
2720: hz_utility_pub.user_id);
2721:
2722: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,

Line 2719: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

2715: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
2716: LAST_UPDATE_DATE, LAST_UPDATED_BY)
2717: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
2718: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
2719: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
2720: hz_utility_pub.user_id);
2721:
2722: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
2723: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,

Line 2720: hz_utility_pub.user_id);

2716: LAST_UPDATE_DATE, LAST_UPDATED_BY)
2717: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
2718: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
2719: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
2720: hz_utility_pub.user_id);
2721:
2722: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
2723: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
2724: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)

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

2722: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
2723: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
2724: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
2725: VALUES (p_party_id,x_dup_set_id,0,0,
2726: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
2727: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
2728: hz_utility_pub.user_id,p_dup_batch_id);
2729: ELSE
2730: x_dup_set_id := NULL;

Line 2727: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

2723: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
2724: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
2725: VALUES (p_party_id,x_dup_set_id,0,0,
2726: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
2727: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
2728: hz_utility_pub.user_id,p_dup_batch_id);
2729: ELSE
2730: x_dup_set_id := NULL;
2731: END IF;

Line 2728: hz_utility_pub.user_id,p_dup_batch_id);

2724: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
2725: VALUES (p_party_id,x_dup_set_id,0,0,
2726: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
2727: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
2728: hz_utility_pub.user_id,p_dup_batch_id);
2729: ELSE
2730: x_dup_set_id := NULL;
2731: END IF;
2732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN