DBA Data[Home] [Help]

APPS.HZ_PARTY_MERGE dependencies on HZ_MERGE_UTIL

Line 925: HZ_MERGE_UTIL.get_reln_party_id(l_from_rel_id);

921: FETCH c_batch_relationships INTO l_from_rel_id, l_to_rel_id;
922: EXIT WHEN c_batch_relationships%NOTFOUND;
923:
924: l_from_rel_party_id :=
925: HZ_MERGE_UTIL.get_reln_party_id(l_from_rel_id);
926: l_to_rel_party_id :=
927: HZ_MERGE_UTIL.get_reln_party_id(l_to_rel_id);
928:
929: IF l_from_rel_party_id IS NOT NULL AND

Line 927: HZ_MERGE_UTIL.get_reln_party_id(l_to_rel_id);

923:
924: l_from_rel_party_id :=
925: HZ_MERGE_UTIL.get_reln_party_id(l_from_rel_id);
926: l_to_rel_party_id :=
927: HZ_MERGE_UTIL.get_reln_party_id(l_to_rel_id);
928:
929: IF l_from_rel_party_id IS NOT NULL AND
930: l_to_rel_party_id IS NOT NULL AND
931: l_from_rel_party_id<>l_to_rel_party_id THEN

Line 2322: rec_query := 'SELECT hz_merge_util.get_party_reln_description(relationship_id) FROM HZ_RELATIONSHIPS'

2318: -- Counstruct dynamic SQL query to fetch description
2319: --4500011
2320:
2321: IF (p_entity_name = 'HZ_PARTY_RELATIONSHIPS') THEN
2322: rec_query := 'SELECT hz_merge_util.get_party_reln_description(relationship_id) FROM HZ_RELATIONSHIPS'
2323: || ' WHERE RELATIONSHIP_ID = '|| ':pk'
2324: || ' AND subject_table_name = ''HZ_PARTIES'' AND object_table_name = ''HZ_PARTIES'' AND directional_flag = ''F''';
2325:
2326: ELSE

Line 2991: l_from_rec_desc :=hz_merge_util.get_party_site_description(l_merge_to_entity_id);

2987: l_proc_name := 'HZ_MERGE_PKG.party_site_merge';
2988: g_cur_merge_dict_id := 0;
2989: g_num_sub_entities :=-1;
2990:
2991: l_from_rec_desc :=hz_merge_util.get_party_site_description(l_merge_to_entity_id);
2992:
2993: -- Execute the merge procedure for the entity
2994: exec_merge(
2995: p_entity_name => 'HZ_PARTY_SITES',

Line 3108: l_from_rec_desc := hz_merge_util.get_party_reln_description(l_merge_to_entity_id);

3104: p_batch_id => p_batch_id,
3105: p_batch_party_id=> l_batch_party_id,
3106: x_return_status => l_return_status);
3107:
3108: l_from_rec_desc := hz_merge_util.get_party_reln_description(l_merge_to_entity_id);
3109:
3110: -- Check if the merge procedure returned an error
3111: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3112: -- Write to log file